Daily Report of any New Application Installs
I am still new to using our K1000 and I am barley scratching the surface so far. Is there a way to have it generate a daily report listing any newly installed applicatioins from the PC's that the agents monitor. We are currently in the process of migrating to a domain and at this point we have to set our users as local admins for thier PC's to prevent never ending phone calls of "we need admin rights just to open this application". We are haivng issues with applications being installed and not finding out untill a problem arises or we are working with the PC for another reason and find out things have been installed that we did not authorize. I want to find a daily report that will will list any application changes each day so we are made aware sooner if a program was installed or even uninstalled on what machine.
Answers (2)
see
http://www.itninja.com/question/k1000-report-of-software-installed-by-date
This one is from KACE's newsletter and you just have to change the Interval time frame.
SELECT CONCAT(S.DISPLAY_NAME, ' ', S.DISPLAY_VERSION) AS 'Software',
A.NAME as 'Computer', AH.TIME as 'Installed'
FROM ASSET_HISTORY AH, ASSET A, ASSET_TYPE AST, SOFTWARE S
WHERE AST.ASSET_CATEGORY = "Computer"
and A.ID = AH.ASSET_ID
and AH.DESCRIPTION LIKE CONCAT('%%Found software item ', S.DISPLAY_NAME,
' ', S.DISPLAY_VERSION, '%%')
and DATE(AH.TIME) > DATE(DATE_SUB(NOW(), INTERVAL 7 DAY))
ORDER BY Installed, Computer
