Software Audit

[Eaglesoftis]

I have recently been tasked with doing an audit of all Adobe software installed on our machines (500+). They supplied me with a list of .exe files that they are wanting installed numbers for. I found a way to get it but now they are wanting more information. So my question is, How do I build a report with all of these things:

Application name

Version

Executable name

Full file path to the .exe

Computer name

Total number of installed

Thank you ahead of time!!

This what I have come up with so far:

Select Distinct Top 1000000 dbo.tblSoftware.softwareName As Software, dbo.tblSoftware.softwareVersion As Version, Count(dbo.tblSoftware.SoftwareID) As Total From dbo.tblSoftware Inner Join dbo.tblComputers On dbo.tblSoftware.ComputerName = dbo.tblComputers.Computername Inner Join dbo.web40ActiveComputers On dbo.tblComputers.Computername = dbo.web40ActiveComputers.Computername Where (tblSoftware.softwareName Like '3D Toolkit.exe' Or
tblSoftware.softwareName Like 'A3DReviewer.exe' Or
tblSoftware.softwareName Like 'Accelio Integrate Suite.msc' Or
tblSoftware.softwareName Like 'acroaum.exe' Or
tblSoftware.softwareName Like 'Acrobat Elements.exe' Or
tblSoftware.softwareName Like 'Acrobat.exe' Or
tblSoftware.softwareName Like 'AcrobatElementsServer.exe' Or
tblSoftware.softwareName Like 'acrodist.exe' Or
tblSoftware.softwareName Like 'Acroex32.exe' Or
tblSoftware.softwareName Like 'AcroRd32.exe' Or
tblSoftware.softwareName Like 'Adobe Drive.exe' Or
tblSoftware.softwareName Like 'Adobe Encore DVD.exe' Or
tblSoftware.softwareName Like 'Adobe Encore.exe' Or
tblSoftware.softwareName Like 'Adobe Extension Manager CS4.exe' Or tblSoftware.softwareName Like 'Adobe Extension Manager CS5.exe' Or tblSoftware.softwareName Like 'Adobe Flash Catalyst.exe' Or tblSoftware.softwareName Like 'Adobe Media Encoder.exe' Or tblSoftware.softwareName Like 'Adobe OnLocation.exe' Or tblSoftware.softwareName Like 'Adobe Premiere Elements 7.0.exe' Or tblSoftware.softwareName Like 'Adobe Premiere Elements 8.0.exe' Or tblSoftware.softwareName Like 'Adobe Premiere Elements 9.exe' Or tblSoftware.softwareName Like 'Adobe Premiere Elements.exe' Or tblSoftware.softwareName Like 'Adobe Premiere Pro.exe' Or tblSoftware.softwareName Like 'Adobe Soundbooth CS3.exe' Or tblSoftware.softwareName Like 'Adobe Soundbooth CS4.exe' Or tblSoftware.softwareName Like 'Adobe Soundbooth CS5.exe' Or tblSoftware.softwareName Like 'Adobe Stock Photos CS3.exe' Or tblSoftware.softwareName Like 'Adobe Ultra.exe' Or
tblSoftware.softwareName Like 'Adobe_Premiere_Elements.exe' Or tblSoftware.softwareName Like 'adobe_SAP_Formbuilder.exe' Or tblSoftware.softwareName Like 'adobe_SAP_Formbuilder_5.0.exe' Or tblSoftware.softwareName Like 'adobe_SAP_Formbuilder_5.1.exe' Or tblSoftware.softwareName Like 'adobe_SAP_Formbuilder_5.5.exe' Or tblSoftware.softwareName Like 'adobe_SAP_Formbuilder_5.6.exe' Or tblSoftware.softwareName Like 'adobe_SAP_Formbuilder_5.exe' Or tblSoftware.softwareName Like 'AdobeCaptivate.exe' Or
tblSoftware.softwareName Like 'adobe-lcm-lcvalidator.ear' Or tblSoftware.softwareName Like 'AfterFX.exe' Or
tblSoftware.softwareName Like 'Altercast.exe' Or
tblSoftware.softwareName Like 'AlterCastServer.exe' Or
tblSoftware.softwareName Like 'atmfm.exe' Or
tblSoftware.softwareName Like 'audition.exe' Or
tblSoftware.softwareName Like 'Authorware 5.exe' Or
tblSoftware.softwareName Like 'Authorware 6.exe' Or
tblSoftware.softwareName Like 'Authorware 61.exe' Or
tblSoftware.softwareName Like 'Authorware 7.exe' Or
tblSoftware.softwareName Like 'breezeaddin5x0.exe' Or
tblSoftware.softwareName Like 'bridge.exe' Or
tblSoftware.softwareName Like 'Capture.exe' Or
tblSoftware.softwareName Like 'cfperfmon_mx.dll' Or
tblSoftware.softwareName Like 'cfserver.exe' Or
tblSoftware.softwareName Like 'cfstudio4.exe' Or
tblSoftware.softwareName Like 'cfstudio45.exe' Or
tblSoftware.softwareName Like 'cfstudio5.exe' Or
tblSoftware.softwareName Like 'Contribute 4.exe' Or
tblSoftware.softwareName Like 'Contribute.exe' Or
tblSoftware.softwareName Like 'ConvertIP.exe' Or
tblSoftware.softwareName Like 'coolpro2.exe' Or
tblSoftware.softwareName Like 'DeviceCentral.exe' Or
tblSoftware.softwareName Like 'dfadmin.exe' Or
tblSoftware.softwareName Like 'dfdesign.exe' Or
tblSoftware.softwareName Like 'dffill.exe' Or
tblSoftware.softwareName Like 'dfformap.exe' Or
tblSoftware.softwareName Like 'dfill.exe' Or
tblSoftware.softwareName Like 'dfroute.exe' Or
tblSoftware.softwareName Like 'dimensions.exe' Or
tblSoftware.softwareName Like 'Director.exe' Or
tblSoftware.softwareName Like 'Dreamweaver.exe' Or
tblSoftware.softwareName Like 'DVRack2.exe' Or
tblSoftware.softwareName Like 'EncoreDVD.exe' Or
tblSoftware.softwareName Like 'Extension Manager.exe' Or tblSoftware.softwareName Like 'filler.exe' Or
tblSoftware.softwareName Like 'filler50.exe' Or
tblSoftware.softwareName Like 'filler51.exe' Or
tblSoftware.softwareName Like 'Fireworks 3.exe' Or
tblSoftware.softwareName Like 'Fireworks 4.exe' Or
tblSoftware.softwareName Like 'Fireworks.exe' Or
tblSoftware.softwareName Like 'Flash Video Encoder.exe' Or tblSoftware.softwareName Like 'Flash.exe' Or
tblSoftware.softwareName Like 'flash.ocx' Or
tblSoftware.softwareName Like 'Flash8VideoEncoder.exe' Or tblSoftware.softwareName Like 'FlashBuilder4.exe' Or
tblSoftware.softwareName Like 'FlashCom.exe' Or
tblSoftware.softwareName Like 'Flashprinter.exe' Or
tblSoftware.softwareName Like 'FlashRemotingCmpntsInstall.exe' Or tblSoftware.softwareName Like 'FlashRemotingComponents-win-en.exe' Or tblSoftware.softwareName Like 'Flex Builder.exe' Or
tblSoftware.softwareName Like 'FlexBuilder.exe' Or
tblSoftware.softwareName Like 'FormDesign.exe' Or
tblSoftware.softwareName Like 'FormDesigner.exe' Or
tblSoftware.softwareName Like 'frame.exe' Or
tblSoftware.softwareName Like 'framemaker.exe' Or
tblSoftware.softwareName Like 'framemaker+sgml.exe' Or
tblSoftware.softwareName Like 'FrameViewer.exe' Or
tblSoftware.softwareName Like 'FreeHand 10.exe' Or
tblSoftware.softwareName Like 'FreeHand 9.exe' Or
tblSoftware.softwareName Like 'FreeHand MX.exe' Or
tblSoftware.softwareName Like 'fsservice.exe' Or
tblSoftware.softwareName Like 'fsserviceagentservice.exe' Or tblSoftware.softwareName Like 'golive.exe' Or
tblSoftware.softwareName Like 'HomeSite+.exe' Or
tblSoftware.softwareName Like 'homesite4.exe' Or
tblSoftware.softwareName Like 'homesite45.exe' Or
tblSoftware.softwareName Like 'Homesite5.exe' Or
tblSoftware.softwareName Like 'Illustrator.exe' Or
tblSoftware.softwareName Like 'imageready.exe' Or
tblSoftware.softwareName Like 'InCopy.exe' Or
tblSoftware.softwareName Like 'indesign.exe' Or
tblSoftware.softwareName Like 'InDesign.exe' Or
tblSoftware.softwareName Like 'InitNameService.exe' Or
tblSoftware.softwareName Like 'install_all_win_ax.dat' Or tblSoftware.softwareName Like 'jfcntrl.exe' Or
tblSoftware.softwareName Like 'jfdesign.exe' Or
tblSoftware.softwareName Like 'JFMerge.exe' Or
tblSoftware.softwareName Like 'JFrdi.exe' Or
tblSoftware.softwareName Like 'jfserver.exe' Or
tblSoftware.softwareName Like 'jmerge.exe' Or
tblSoftware.softwareName Like 'jrstudio.exe' Or
tblSoftware.softwareName Like 'jrun.exe' Or
tblSoftware.softwareName Like 'jsm.exe' Or
tblSoftware.softwareName Like 'LFS_BarcodedForms.properties' Or tblSoftware.softwareName Like 'LFS_BusinessActivityMonitoring.properties' Or tblSoftware.softwareName Like 'LFS_ElectronicSignatures.properties' Or tblSoftware.softwareName Like 'LFS_Forms.properties' Or tblSoftware.softwareName Like 'LFS_Foundation.properties' Or tblSoftware.softwareName Like 'LFS_Output.properties' Or tblSoftware.softwareName Like 'LFS_PDFGenerator.properties' Or tblSoftware.softwareName Like 'LFS_ProcessManagement.properties' Or tblSoftware.softwareName Like 'LFS_ReaderExtensions.properties' Or tblSoftware.softwareName Like 'LFS_RightsManagement.properties' Or tblSoftware.softwareName Like 'lightroom.exe' Or
tblSoftware.softwareName Like 'LiveCycle UI.ear' Or
tblSoftware.softwareName Like 'LiveCycle8.ear' Or
tblSoftware.softwareName Like 'LiveCycle8Native.ear' Or tblSoftware.softwareName Like 'livemotion.exe' Or
tblSoftware.softwareName Like 'np32dsw.dll' Or
tblSoftware.softwareName Like 'NPSWF32.dll' Or
tblSoftware.softwareName Like 'pagemill.exe' Or
tblSoftware.softwareName Like 'pbe.exe' Or
tblSoftware.softwareName Like 'pd.exe' Or
tblSoftware.softwareName Like 'pd3.exe' Or
tblSoftware.softwareName Like 'pd4.exe' Or
tblSoftware.softwareName Like 'PDF_X_1a_2001.kfp' Or
tblSoftware.softwareName Like 'Photoshop Elements 3.0.exe' Or tblSoftware.softwareName Like 'Photoshop Elements 4.0.exe' Or tblSoftware.softwareName Like 'Photoshop Elements 5.0.exe' Or tblSoftware.softwareName Like 'Photoshop Elements 6.0.exe' Or tblSoftware.softwareName Like 'Photoshop Elements 7.0.exe' Or tblSoftware.softwareName Like 'Photoshop Elements 8.0.exe' Or tblSoftware.softwareName Like 'Photoshop Elements 90.exe' Or tblSoftware.softwareName Like 'Photoshop.exe' Or
tblSoftware.softwareName Like 'PhotoshopAlbum.exe' Or
tblSoftware.softwareName Like 'PhotoshopElements.exe' Or tblSoftware.softwareName Like 'photoshp.exe' Or
tblSoftware.softwareName Like 'photosle.exe' Or
tblSoftware.softwareName Like 'pm.exe' Or
tblSoftware.softwareName Like 'pm4.exex' Or
tblSoftware.softwareName Like 'pm5.exe' Or
tblSoftware.softwareName Like 'pm6.exe' Or
tblSoftware.softwareName Like 'pm65.exe' Or
tblSoftware.softwareName Like 'pm70.exe' Or
tblSoftware.softwareName Like 'premiere.exe' Or
tblSoftware.softwareName Like 'Presenter.exe' Or
tblSoftware.softwareName Like 'robodemo.exe' Or
tblSoftware.softwareName Like 'robodemo.exe' Or
tblSoftware.softwareName Like 'robohelp.exe' Or
tblSoftware.softwareName Like 'roboinfo.exe' Or
tblSoftware.softwareName Like 'streamline.exe' Or
tblSoftware.softwareName Like 'SwDir.dll' Or
tblSoftware.softwareName Like 'swflash.ocx' Or
tblSoftware.softwareName Like 'Ultra2.exe' Or
tblSoftware.softwareName Like 'UltraDev.exe' Or
tblSoftware.softwareName Like 'versioncueCS2tray.exe' Or tblSoftware.softwareName Like 'VersionCueCS3Tray.exe' Or tblSoftware.softwareName Like 'VersionCueCS4Tray.exe' Or tblSoftware.softwareName Like 'versioncuetray.exe' Or
tblSoftware.softwareName Like 'VisualCommunicator.exe' Or tblSoftware.softwareName Like 'VlogIt.exe' Or
tblSoftware.softwareName Like 'Workbench.exe') And (tblSoftware.SoftwarePublisher Like '%Adobe%' Or tblSoftware.SoftwarePublisher Like '%Macromedia%') Group By dbo.tblSoftware.softwareName, dbo.tblSoftware.softwareVersion Order By Count(dbo.tblSoftware.SoftwareID) Desc, dbo.tblSoftware.softwareName


Now all I need to do is figure out how to get the file path in there and I think I will have it fixed. Any suggestions?

[Susan_A]

There is no easy way to report on executable paths at the moment. Lansweeper doesn't scan this information by default and the only parameters available for custom file scanning are: %programfiles%, %programfiles(x86)% and %windir%. The only way to report on variations of an executable path for now is to manually submit all variations of the path for scanning.

[Lachlan_Brown]

Hi,

Reviving an old thread.

Just wondering how you were able to retrieve the executable paths from the list adobe supplied you.

We are being audited by adobe as well and have been given a list of 180 odd executables that we have to report on.

I know we can can into custom scanning and add:
%programfiles(x86)%\Adobe\Reader 11.0\Reader\AcroRd32.exe

But how would we know the full path and different versions as wildcards do not work?

Hopefully someone has some ideas on how we can either determine the path for all equivalent of the variables or an easier way.

Thanks in advance.

[Eaglesoftis]

Thank you! That will get me part of what I need.

[Hemoco]

This isn't going to work.

blSoftware.softwareName Like 'A3DReviewer.exe'

Field softwarename is the name of the software as seen in add/remove programs.
The install path isn't stored for the software.

This can be a good start but you can't get all the information you want.

Select tblSoftware.softwareName, tblSoftware.softwareVersion,
  Count(tblComputers.Computername) As total
From tblComputers Inner Join
  tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Where tblSoftware.SoftwarePublisher Like 'adobe%'
Group By tblSoftware.softwareName, tblSoftware.softwareVersion
Order By tblSoftware.softwareName, tblSoftware.softwareVersion