K1000: Kace SQL report not showing every machine
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 NAMEIt 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.
There are no answers at this time