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. 

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

2

see

http://www.itninja.com/question/k1000-report-of-software-installed-by-date

Answered 04/18/2013 by: SMal.tmcc
Red Belt

Please log in to comment

Answers

1

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

Answered 04/18/2013 by: nshah
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share