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)
Please log in to answer
Posted by:
cblake
13 years ago
There are several examples in the forum. Here's a couple:
http://itninja.com/question/silent-uninstall-oracle-8-cilent3368&mpage=1&key=software%2Clabel%2Cversion𒀇
http://www.appdeploy.com/messageboards/tm.asp?m=64620&mpage=1&key=software%2Clabel%2Cversionﱭ
http://itninja.com/question/silent-uninstall-oracle-8-cilent3368&mpage=1&key=software%2Clabel%2Cversion𒀇
http://www.appdeploy.com/messageboards/tm.asp?m=64620&mpage=1&key=software%2Clabel%2Cversionﱭ
Posted by:
jmcelvoy
13 years ago
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.
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
jmcelvoy,
Have you had machines check back in since creating the label?
Have you had machines check back in since creating the label?
Posted by:
jmcelvoy
13 years ago
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.