KACE Product Support

The smart label (filter) should be set to find systems that have the software of the specific version installed. Then, you apply the smart label to the managed installation or script.

You can create a filter with the wizard (Create Filter tab) under Inventory, or you can write a custom filter using SQL.

Ok so I created a Software label that looks like this "SELECT ID FROM SOFTWARE WHERE (( SOFTWARE.DISPLAY_NAME like '%IBM System i Access for Windows V6R1M0%') AND SOFTWARE.DISPLAY_VERSION like '%06.01.0001%')"

When I try to deploy a script filtering on this label it targets 0 machines.

A smart label won't apply to a system until it checks-in after you create the label. So, if your check-in interval is 2 hours then you'll have to wait at least 2 hours to get a valid list of systems added to the label.

You can check your SQL code in MySQL Browser / MySQL Workbench, but labels are only applied at check-in.

Also, your code isn't going to grab machine IDs. Try this:


SELECT M.ID FROM MACHINE M
JOIN MACHINE_SOFTWARE_JT MSJT ON (M.ID = MSJT.MACHINE_ID)
JOIN SOFTWARE S ON (MSJT.SOFTWARE_ID = S.ID)
WHERE S.DISPLAY_NAME like '%IBM System i Access for Windows V6R1M0%' AND S.DISPLAY_VERSION like '%06.01.0001%'


Ok I see it grabbing machines now. Is there anyway to do that through the GUI or just have to code it?

BTW thanks a lot.

Any way to do what through the GUI? Create the filter? You can do this from the tab on the right side of the Inventory page.

Yeah but a machine filter does not have the software version number option

In the wizard, I believe you are correct. I write everything out in SQL, so it's been a while since I've used the wizard method.

If you ever need help writing queries, just post on the forums. You may be able to find something in the Reports forum or an existing thread here to suit your needs. And even if you can't, chances are someone can copy/paste what you're looking for from their own KBOX smart labels.

I'll make another suggestion about getting started with queries: find out what fields are available in what tables. For example, since the wizard doesn't give you a hint that a DISPLAY_VERSION field exists, you'd never think to try it in a query.

You can use MySQL WorkBench or set up an ODBC connection to your database, then look at the major tables (like MACHINE) and the data in various fields.

Good luck! Sande