Software inventory with no label
I'm trying to create some smart labels to label as much of my software inventory as possible (along with a couple of manual labels). I'd like to be able to see what's left. Is there a way to do an advanced search for items that have no label? It's easy to do with Computers, but I don't see the option in the software search.
I was also wondering what the "Inventory Rule" search field is.
Thanks,
Ben
I was also wondering what the "Inventory Rule" search field is.
Thanks,
Ben
0 Comments
[ + ] Show comments
Answers (2)
Please log in to answer
Posted by:
GillySpy
12 years ago
Here is a query you could use as a report or as a software smart label.
If you use it as a smart label then you'll have to create a label called "missing label" to associate it to. Anything with label "missing label" has no other labels.
I assumed you were not interested in software defined patches.
note: also take the "ORDER BY 2" off the query to use as a smart label
If you use it as a smart label then you'll have to create a label called "missing label" to associate it to. Anything with label "missing label" has no other labels.
I assumed you were not interested in software defined patches.
select SOFTWARE.ID, DISPLAY_NAME, DISPLAY_VERSION
FROM SOFTWARE LEFT JOIN SOFTWARE_LABEL_JT SL ON SL.SOFTWARE_ID=SOFTWARE.ID
LEFT JOIN (select ID from LABEL WHERE NAME NOT LIKE 'Missing Label' and TYPE <>'hidden') L
ON SL.LABEL_ID=L.ID
WHERE
L.ID IS NULL
and IS_PATCH=0
ORDER BY 2note: also take the "ORDER BY 2" off the query to use as a smart label
Posted by:
benmills
12 years ago
Thanks GillySpy. This works perfectly.
Now I can periodically look at this label and see the new software that's on our network.
Thanks,
Ben
Now I can periodically look at this label and see the new software that's on our network.
Thanks,
Ben
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.