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

Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

1

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%')) ))
Answered 09/09/2013 by: petelanglois
Fourth Degree Black Belt

  • Okay it work.

    Thank you!
Please log in to comment
Answer this question or Comment on this question for clarity