Adobe Products SCCM Report

Report that shows you all Adobe products filtred by machine name and AD site:



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