/build/static/layout/Breadcrumb_cap_w.png

Combining smart labels

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

Answers (9)

Posted by: airwolf 11 years ago
Red Belt
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.
Posted by: scout12 11 years ago
Purple Belt
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.
Posted by: airwolf 11 years ago
Red Belt
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.
Posted by: airwolf 11 years ago
Red Belt
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%'
Posted by: scout12 11 years ago
Purple Belt
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.
Posted by: airwolf 11 years ago
Red Belt
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.
Posted by: scout12 11 years ago
Purple Belt
0
Yeah but a machine filter does not have the software version number option
Posted by: airwolf 11 years ago
Red Belt
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.
Posted by: snissen 11 years ago
Fourth Degree Green Belt
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
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ