/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide 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.
Answer this question or Comment on this question for clarity

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