/build/static/layout/Breadcrumb_cap_w.png

Software Deployment Question


Create machine label based on software label k1000

10/11/2016 1157 views
Hello,

I have some software that has several versions running in our organization. I have found the specific versions I would like to uninstall and have created a software label containing all those versions. I would like to assign a label to all of the devices that have software on them that are contained in that label. Is this possible?

Thanks!
Answer Summary:
1 Comment   [ + ] Show comment

Comments

  • If you know the title and version, why not just create a machine label using software title and software version as your drop downs?

Answer Chosen by the Author

2
insert the label id of your software label in the query below:
SELECT MACHINE.ID AS TOPIC_ID
  FROM MACHINE
       JOIN MACHINE_SOFTWARE_JT
          ON MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID
 WHERE MACHINE_SOFTWARE_JT.SOFTWARE_ID IN
          (SELECT SOFTWARE.ID
             FROM SOFTWARE
                  JOIN SOFTWARE_LABEL_JT
                     ON SOFTWARE.ID = SOFTWARE_LABEL_JT.SOFTWARE_ID
             WHERE SOFTWARE_LABEL_JT.LABEL_ID = YOUR LABEL_ID HERE
          )
Answered 10/11/2016 by: JasonEgg
Red Belt

All Answers

0

Seems like you can modify the software Smart Label and check the box for "Device Inventory".  Then you can run a script or whatever is next against this label.  I realize I may be missing something from your original question...

Answered 10/12/2016 by: davreh99
Orange Belt

 
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