Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

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.

Hi

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?

Thanks!

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:
http://www.symantec.com/docs/HOWTO21604

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

SOLUTION