/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Trying to find OS Language and Software Language

03/08/2016 1268 views
I'm trying to write a custom SQL for:
- For all computers with French operating system (I can only seem to look up by OS_NAME LIKE ''%Professionnel%'' - Is there a better way?)
- Supply a list of software grouped by name/version/language and give the count of each.

There's a view called SAM_VIEW_INVENTORY_ADD_REMOVE_PROGRAMS which contains the software language, but I can't figure out how to get this data myself. I've looked through all the tables and can't figure it out.

Does anyone have the source for the query SAM_VIEW_INVENTORY_ADD_REMOVE_PROGRAMS which I could look at and try to figure this out?

Thanks.
0 Comments   [ + ] Show comments

Comments


Be the first to answer this question

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