Smart Label for detecting PCs which havent Microsoft Office installed.
Hello,
i try to make a smart label which should detect the PCs which havent installed Office.
I make a Software smart label but it dont show me the pcs only the Software which dont have Microsoft Office in their name.
We try to run the Kace 2000 for installing Windows and then should the Kace 1000 automaticly install all Software we need.I wanna realize that with a smart label or is there an other easyer solution?
Greetings
Daniel
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
petelanglois
11 years ago
Make the smart label under Computer Inventory not the Software Inventory.
Here is one I use for finding machines that DO NOT have McAfee installed.
select *, UNIX_TIMESTAMP(now()) - UNIX_TIMESTAMP(LAST_SYNC) as LAST_SYNC_TIME, UNIX_TIMESTAMP(MACHINE.LAST_SYNC) as LAST_SYNC_SECONDS from ORG1.MACHINE LEFT JOIN KBSYS.KUID_ORGANIZATION ON KUID_ORGANIZATION.KUID=MACHINE.KUID LEFT JOIN KBSYS.SMMP_CONNECTION ON SMMP_CONNECTION.KUID = MACHINE.KUID AND KUID_ORGANIZATION.ORGANIZATION_ID = 1 where (( (1 not in (select 1 from ORG1.SOFTWARE, ORG1.MACHINE_SOFTWARE_JT where MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID and MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID and SOFTWARE.DISPLAY_NAME like '%McAfee%')) ))
Comments:
