/build/static/layout/Breadcrumb_cap_w.png

Computer Label by Software Product Version

Is there a way to create a computer label based off a product version number? I have 21 pc's that need upgraded to the latest version of a particular piece of software. I can find the old software versions product number under Inventory>Software and it lists the 21 pc's that have that product version. When I create a Smart Label off that it just includes the software. I need to somehow create a Smart Label of these 21 so I can configure a Distribution to deploy the newest version of software only to these 21 that need it.

0 Comments   [ + ] Show comments

Answers (4)

Posted by: jmcelvoy 13 years ago
Second Degree Blue Belt
0
Thanks for the links. Reading through those, I found a suggested query that I thought would work, but so far it's not. I went under Label>Smart Labels and created a new Machine Smart Label. I then put in some bogus query and saved the Label. I then went back into Label>Smart Label and opened the Label I just created and modified the SQL with:
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 '%PDS1771%' AND S.DISPLAY_VERSION like '%19.92.0.587%'

My software Display Name (Title) is PDS1771 and my version number is 19.92.0.587. Am I doing something wrong as there are no machines showing up under this Label.
Posted by: dchristian 13 years ago
Red Belt
0
jmcelvoy,

Have you had machines check back in since creating the label?
Posted by: jmcelvoy 13 years ago
Second Degree Blue Belt
0
Yes, I implemented this early this morning and have my computers set to check back in every 30 minutes. Still nothing.
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
 
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