/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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
0 Comments   [ - ] Hide Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
Answer this question or Comment on this question for clarity

Answers

0
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.

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 2


note: also take the "ORDER BY 2" off the query to use as a smart label
Answered 10/03/2011 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
0
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
Answered 10/03/2011 by: benmills
Senior Yellow Belt

Please log in to comment