Video Screencast Help

Differential Software Report y/o New Software Installed Alert?

Created: 21 Jun 2012 • Updated: 21 Jun 2012 | 2 comments
This issue has been solved. See solution.


Im using NS7.1 but I cant find some way of automate a differential software report, or make an email atert to notify a new software installed.

Any ideas guys?


Comments 2 CommentsJump to latest comment

mclemson's picture
Does this work?
SELECT vc.Name,arp.DisplayName,arp.DisplayVersion 
FROM Inv_AddRemoveProgram arp
JOIN vComputer vc ON vc.Guid=arp._ResourceGuid
WHERE arp.InstallFlag=1 AND arp.InstallDate > GETDATE()-30
Once you create this as a report, an automation policy would handle the e-mail task for you:

Mike Clemson, Senior Systems Engineer, ASC
Intuitive Technology Group -- Symantec Platinum Partner