/build/static/layout/Breadcrumb_cap_w.png

Create machine label based on software label k1000

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!

1 Comment   [ + ] Show comment
  • If you know the title and version, why not just create a machine label using software title and software version as your drop downs? - nshah 7 years ago

Answers (2)

Answer Summary:
Posted by: JasonEgg 7 years ago
Red Belt
2

Top Answer

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
          )
Posted by: davreh99 7 years ago
Orange Belt
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...

 
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