K1000: Kace SQL report not showing every machine
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
-
I think the "show all" shows all installed software, not in the past week, but what is in inventory. - flip1001 8 years ago
Answers (0)
Please log in to answer
Be the first to answer this question
