/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


Report of new software installed for a period of time

09/29/2020 118 views
We are trying to create a report that would show any new installations of a specific in the past 24 hours or week.  If that is not possible we would like a report that showed any new installations of any software.  Is this possible?  How would I create that?  Thanks in advance for any help you can give.
0 Comments   [ + ] Show comments

Comments


All Answers

1

You can query from the database anything you want.

As an example you can use this report for the last 14 days (and modify it for your own needs)

SELECT DISTINCT NAME, VALUE1 AS 'Software Display Name', VALUE2 AS 'Software Version', TIME

FROM ASSET_HISTORY A

WHERE CHANGE_TYPE = 'DETECTED'

AND FIELD_NAME = 'SOFTWARE'

AND TIME > DATE_SUB(NOW(), INTERVAL 14 DAY)

ORDER BY NAME, VALUE1


Answered 09/29/2020 by: Nico_K
Red Belt

1

I have a few examples of this type of report in my GitHub repository:

New versions of Java installed in the past day: https://github.com/csteelatgburg/K1000-Database-Queries/blob/master/software%20-%20java%20new%20versions%20in%20past%20day.sql

Software installed on given computers in the past 20 days: https://github.com/csteelatgburg/K1000-Database-Queries/blob/master/software%20installed%20on%20given%20computers%20in%20past%20days.sql 

Answered 09/30/2020 by: chucksteel
Red Belt

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