David J Davis
01/07/2022, 5:34 PMzwass
01/07/2022, 5:46 PMDavid J Davis
01/07/2022, 5:58 PMSELECT name,version FROM programs WHERE name LIKE '%Ivanti Environment Manager Agent%' AND version = '10.6.16.0';
Gavin
01/07/2022, 6:21 PMDavid J Davis
01/07/2022, 6:22 PMGavin
01/07/2022, 6:23 PMDavid J Davis
01/07/2022, 6:25 PMGavin
01/07/2022, 6:29 PMselect * FROM apps, os_version where os_version.version = '12.0.1'
zwass
01/07/2022, 6:37 PMDavid J Davis
01/07/2022, 6:40 PMSELECT 1 FROM programs, os_version
WHERE programs.name LIKE '%Ivanti Environment Manager Agent%' AND programs.version = '10.6.16.0' AND os_version.name NOT LIKE 'Microsoft Windows Server%';
Gavin
01/07/2022, 6:49 PMDavid J Davis
01/07/2022, 7:12 PMSELECT programs.version, programs.name, os_version.name FROM programs, os_version
WHERE programs.name LIKE "%Ivanti Environment Manager Agent%" AND programs.version <> '10.6.16.0' AND os_version.name NOT LIKE "Microsoft Windows Server%";
zwass
01/07/2022, 7:31 PMSELECT 1 WHERE (select count(*) from os_version where name LIKE "Microsoft Windows Server%") > 0 OR (select count(*) from programs WHERE name LIKE '%Ivanti Environment Manager Agent%' AND version = '10.6.16.0') > 0;
?David J Davis
01/07/2022, 8:30 PMzwass
01/07/2022, 9:02 PMDavid J Davis
01/07/2022, 9:40 PMzwass
01/07/2022, 11:32 PM