NOTE: I am using K1000 v6.

I would like to create a Smart Label that will apply to computers that do NOT have a particular piece of software installed. I have tried using the wizard, selecting "Software Titles" "does not contain" "software title", but that lists every computer in inventory. I have tried "!=" with the same result. The SQL query generated is:

SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, MACHINE.IP, MACHINE.MAC, MACHINE.ID as TOPIC_ID FROM MACHINE  WHERE (((not exists  (select 1 from SOFTWARE, MACHINE_SOFTWARE_JT where MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE.ID AND SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID and SOFTWARE.DISPLAY_NAME like '%software title%')) ))

I am a SQL n00b, so I can only assume that it is comparing the software title to every title on each computer, thus creating a TRUE result every time. How can I fix this?

Answer Summary:
Make sure you're typing in the right software title. *hangs head in shame*
Cancel
1 Comment   [ + ] Show Comment

Comments

  • I'm doing exactly this, but I've got several machines that the label isn't applying to. There is nothing to rule them out.

    We're deploying Skype for Business on a branch-by-branch basis, so I've created separate labels for each branch - all machines missing Skype for Business.

    hmm cant include images in these comments..
    Smart Label:
    Branch = Chevy Chase
    Name does not contain Server
    Software Titles does not contain Skype for Business

    Branch is custom asset field that wasn't hooped in a kace upgrade that wiped all the "Location" assignments..
    Name is OS name
    Software Titles is self explanatory.

    Example of failure to tag a machine with the label: A Windows 10 Pro x64 machine assigned to the Chevy Chase office and does not currently have any Skype at all installed on the machine. Inventory for this machine is executing on schedule and even forcing the inventory doesn't actually apply my label.

    Thoughts?
Please log in to comment

Community Chosen Answer

1

I did this to create a smart label for my managed installs.  the first thing I did was install the software on a machine and then look in the inventory to see what KACE called the software.  Note these are machine labels I'm using, and I tend to go pretty generic as far as software title.  The following image is one of my machine smart labels that I have associated with a managed install for flash player.  The first filter is for operating system, the second is under software, and the third is under device identity information.  The important thing is making sure you know what KACE calls the software, that's why I use a generic term of "Flash player" for this.  That way when I move to a new version it still has at least "flash player" in the name somewhere.

 

I do the same with basic programs like Java or Adobe Reader.  Also, the third filter in this example is just another label I made for initial software installs, and is not by any means needed.

 
Answered 05/16/2014 by: Eray
Yellow Belt

  • Talk about your "Duh" moments. I had the damn thing misspelled. Never mind, Dell, your product works as advertised!
Please log in to comment

Answers

This content is currently hidden from public view.
Reason: Removed by member request
For more information, visit our FAQ's.

Answer this question or Comment on this question for clarity

Share