/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


K1000: Kace SQL report not showing every machine

08/28/2015 1403 views
I am suppose to generate a report that shows all the machines that received the managed installation of a particular software in the last week. I used the following sql statement: 

SELECT NAME, TIME, VALUE1 as Software, VALUE2 as Version


FROM ASSET_HISTORY A


WHERE FIELD_NAME = 'SOFTWARE' 

AND CHANGE_TYPE = 'DETECTED'

AND VALUE1 = 'DGCIApp' OR VALUE1 = 'Digital Guardian Agent'

ORDER BY NAME

It kicks back 80 or so results. The problems is If I choose "Show All" under the settings for the software under managed installations it shows much more than that having the software installed. Any help is appreciated.
1 Comment   [ + ] Show comment

Comments

  • I think the "show all" shows all installed software, not in the past week, but what is in inventory.

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