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   [ + ] Show 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.

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
Answer this question or Comment on this question for clarity