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.
Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity