Find Computers and Users with Specific Software Installed
Just like hardware information, keeping track of software information is essential for businesses. Not only to ensure that all the required software is present for an employee, but also to make sure that you know when software is out of date. Additionally, if users are able to install software themselves, you can always keep track on what software they have installed to take action when malicious software is detected.
With the audit below you can find exactly which user have your specified Windows software installed. A similar report for Windows, Linux and Mac can be found here.
Users with Software Installed Query
Select Top 1000000 tblAssets.AssetID, tblAssets.AssetUnique, tblAssets.Domain, tblAssets.Username, tblADusers.Displayname As [User], tblSoftwareUni.softwareName As software, tblSoftware.softwareVersion As version, tblSoftwareUni.SoftwarePublisher As publisher, tsysOS.Image As icon From tblSoftware Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode Left Join tblADusers On tblADusers.Username = tblAssets.Username And tblADusers.Userdomain = tblAssets.Userdomain Where tblSoftwareUni.softwareName Like '%ExampleSoftware%' And tblAssetCustom.State = 1 Order By tblAssets.AssetName, software, version