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

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
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.
Answered 03/24/2011 by: jmcelvoy
Second Degree Blue Belt

Please log in to comment
0
jmcelvoy,

Have you had machines check back in since creating the label?
Answered 03/24/2011 by: dchristian
Red Belt

Please log in to comment
0
Yes, I implemented this early this morning and have my computers set to check back in every 30 minutes. Still nothing.
Answered 03/24/2011 by: jmcelvoy
Second Degree Blue Belt

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