/build/static/layout/Breadcrumb_cap_w.png
10/11/2016 851 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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share