Software Aging Report
I have a mandate to produce a report on software that is older than 1 year on our network, so we can monitor aging and upgrade when necessary.
I tried using the wizard, but the report does not come out configured the way I need it to be.
I have created the following script, using Easy Query Builder:
SELECT SOFTWARE.DISPLAY_NAME AS "SOFTWARE DISPLAY_NAME", SOFTWARE.DISPLAY_VERSION AS "SOFTWARE DISPLAY_VERSION", SOFTWARE.CREATED AS "SOFTWARE CREATED", MACHINE.NAME AS "MACHINE NAME", MACHINE.USER_FULLNAME AS "MACHINE USER_FULLNAME", MACHINE.USER_LOGGED AS "MACHINE USER_LOGGED"
FROM (SOFTWARE AS SOFTWARE
INNER JOIN MACHINE AS MACHINE ON ( MACHINE.ID = SOFTWARE.ID ))
NOT (SOFTWARE.DISPLAY_NAME LIKE '%MUI%') AND
NOT (SOFTWARE.DISPLAY_NAME LIKE '%Hotfix%') AND
NOT (SOFTWARE.DISPLAY_NAME LIKE '%Proof%') AND
SOFTWARE.CREATED < '2018-12-31 10:32:34' )
My end goal is to get a CSV file that I can import into Excel and create a pivot table for summary.
My questions are:
1) Am I accessing the correct tables ?
2) Is there anything I am missing out that you feel would enhance usability for my Tech Team?
Looking forward to your responses!
Thanks in advance
Be the first to answer this question