/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Software inventory with no label

10/03/2011 1626 views
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


Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

All 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
7th Degree Black Belt

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

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

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ