SMS 2003 - Reports - Adobe Software Audit Report
Last week, we were given a software audit notice by Adobe. There were specific criteria which needed to be met in our reports to be submitted and specific named files to be audited. Given their provided data I produced the following report and thought I would post it for those who may receive simillar a similar request from Adobe. (I would hate anyone else to have to type in all these .exe names.) I've sorted by NetBios Name, but you can change the grouping and ordering anyway you wish to be suitable for your site. I've also included the MOF file for import.
Report Query:
SELECT SYS.Netbios_Name0 AS Computer_Name, SYS.AD_Site_Name0 AS AD_Site, SP.CompanyName AS Publisher, SP.ProductName, SF.FileName,
SF.FileSize, SF.FileVersion, SF.FilePath
FROM v_GS_SoftwareProduct SP INNER JOIN
v_GS_SoftwareFile SF ON SP.ResourceID = SF.ResourceID AND SP.ProductID = SF.ProductId INNER JOIN
v_R_System SYS ON SP.ResourceID = SYS.ResourceID
WHERE (SF.FileName = 'Acrobat.exe' OR
SF.FileName = 'Acrobat Elements.exe' OR
SF.FileName = 'AcrobatElementsServer.exe' OR
SF.FileName = 'acrodist.exe' OR
SF.FileName = 'Acroex32.exe' OR
SF.FileName = 'AcroRd32.exe' OR
SF.FileName = 'Adobe Premiere Elements.exe' OR
SF.FileName = 'Adobe Premiere Pro.exe' OR
SF.FileName = 'AfterFX.exe' OR
SF.FileName = 'Altercast.exe' OR
SF.FileName = 'AlterCastServer.exe' OR
SF.FileName = 'atmfm.exe' OR
SF.FileName = 'audition.exe' OR
SF.FileName = 'Authorware 5.exe' OR
SF.FileName = 'Authorware 6.exe' OR
SF.FileName = 'Authorware 61.exe' OR
SF.FileName = 'Authorware 7.exe' OR
SF.FileName = 'breezeaddin5x0.exe' OR
SF.FileName = 'Capture.exe' OR
SF.FileName = 'cfperfmon_mx.dll' OR
SF.FileName = 'cfserver.exe' OR
SF.FileName = 'cfstudio4.exe' OR
SF.FileName = 'cfstudio45.exe' OR
SF.FileName = 'cfstudio5.exe' OR
SF.FileName = 'Contribute 4.exe' OR
SF.FileName = 'Contribute.exe' OR
SF.FileName = 'ConvertIP.exe' OR
SF.FileName = 'coolpro2.exe' OR
SF.FileName = 'dimensions.exe' OR
SF.FileName = 'Director.exe' OR
SF.FileName = 'Dreamweaver.exe' OR
SF.FileName = 'EncoreDVD.exe' OR
SF.FileName = 'Fireworks 3.exe' OR
SF.FileName = 'Fireworks 4.exe' OR
SF.FileName = 'Fireworks.exe' OR
SF.FileName = 'Flash.exe' OR
SF.FileName = 'Flash8VideoEncoder.exe' OR
SF.FileName = 'FlashCom.exe' OR
SF.FileName = 'Flashprinter.exe' OR
SF.FileName = 'FlashRemotingCmpntsInstall.exe' OR
SF.FileName = 'FlashRemotingComponents-win-en.exe' OR
SF.FileName = 'frame.exe' OR
SF.FileName = 'framemaker.exe' OR
SF.FileName = 'framemaker' + 'sgml.exe' OR
SF.FileName = 'FreeHand 10.exe' OR
SF.FileName = 'FreeHand 9.exe' OR
SF.FileName = 'FreeHand MX.exe' OR
SF.FileName = 'golive.exe' OR
SF.FileName = 'HomeSite' + '.exe' OR
SF.FileName = 'homesite4.exe' OR
SF.FileName = 'homesite45.exe' OR
SF.FileName = 'Homesite5.exe' OR
SF.FileName = 'Illustrator.exe' OR
SF.FileName = 'imageready.exe' OR
SF.FileName = 'InCopy.exe' OR
SF.FileName = 'indesign.exe' OR
SF.FileName = 'InitNameService.exe' OR
SF.FileName = 'jrstudio.exe' OR
SF.FileName = 'jrun.exe' OR
SF.FileName = 'jsm.exe' OR
SF.FileName = 'livemotion.exe' OR
SF.FileName = 'pbe.exe' OR
SF.FileName = 'pd.exe' OR
SF.FileName = 'pd3.exe' OR
SF.FileName = 'pd4.exe' OR
SF.FileName = 'Photoshop Elements 3.exe' OR
SF.FileName = 'Photoshop Elements 4.exe' OR
SF.FileName = 'Photoshop.exe' OR
SF.FileName = 'PhotoshopAlbum.exe' OR
SF.FileName = 'PhotoshopElements.exe' OR
SF.FileName = 'photoshp.exe' OR
SF.FileName = 'photosle.exe' OR
SF.FileName = 'pm4.exe' OR
SF.FileName = 'pm5.exe' OR
SF.FileName = 'pm6.exe' OR
SF.FileName = 'pm65.exe' OR
SF.FileName = 'pm70.exe' OR
SF.FileName = 'pm70.exe' OR
SF.FileName = 'premiere.exe' OR
SF.FileName = 'Presenter.exe' OR
SF.FileName = 'robodemo.exe' OR
SF.FileName = 'robohelp.exe' OR
SF.FileName = 'roboinfo.exe' OR
SF.FileName = 'streamline.exe' OR
SF.FileName = 'UltraDev.exe' OR
SF.FileName = 'versioncueCS2tray.exe' OR
SF.FileName = 'versioncuetray.exe' OR
SF.FileName = 'Workbench.exe') AND (SP.CompanyName LIKE '%Adobe%' OR
SP.CompanyName LIKE '%Macromedia%')
GROUP BY SP.CompanyName, SP.ProductName, SF.FileName, SF.FileSize, SF.FileVersion, SF.FilePath, SP.ProductVersion, SYS.Netbios_Name0,
SYS.AD_Site_Name0
ORDER BY SYS.Netbios_Name0