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 8 years ago
Answers (2)
Answer Summary:
Please log in to answer
Posted by:
JasonEgg
8 years ago
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
8 years ago
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...
