Hi I am trying to target a group of machines with a piece of software with a specific software version. I can not seem to figure out how to target the machines with a smart label.
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
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.
Answered 07/14/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
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.
Answered 07/14/2010 by: scout12
Purple Belt

Please log in to comment
0
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.
Answered 07/14/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
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%'
Answered 07/14/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
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.
Answered 07/14/2010 by: scout12
Purple Belt

Please log in to comment
0
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.
Answered 07/14/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
Yeah but a machine filter does not have the software version number option
Answered 07/14/2010 by: scout12
Purple Belt

Please log in to comment
0
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.
Answered 07/14/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
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
Answered 07/16/2010 by: snissen
Fourth Degree Green Belt

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