Software Audit

[svap]

please help with the following report for v5

a big list with all computers and users where software x and software y are installed
Pcname, username, fullname , software (see below), lastseen 30days, ipadress

required products:

Microsoft Project Professional 2010
Microsoft Project Standard 2010
Microsoft Visio Premium 2010
Microsoft Visio Professional 2010
Microsoft Visio Professional 2013
Microsoft Visual Studio 2005 Premier Partner Edition
Microsoft Visual Studio 2005 Professional Edition
Microsoft Visual Studio 2008 Professional Edition
Microsoft Visual Studio 2010 Premium
Microsoft Visual Studio 2010 Professional
Microsoft Visual Studio Ultimate 2012
Microsoft Visual Studio 2010 Ultimate
Microsoft Visual Studio Premium 2012

thanks!!!
p

[svap]

manythanks!

[Hemoco · Accepted solution]

Please try the report below for the information you are after.

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.Username,
tblAssets.Userdomain,
tblADusers.Firstname,
tblADusers.Lastname,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftwareUni.SoftwarePublisher,
tblAssets.Lastseen
From tblAssets
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join tblADusers On tblADusers.Username = tblAssets.Username And
tblADusers.Userdomain = tblAssets.Userdomain
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where (tblSoftwareUni.SoftwarePublisher Like '%microsoft vis%' And
tblAssets.Lastseen > GetDate() - 30) Or
(tblSoftwareUni.SoftwarePublisher Like '%microsoft project%' And tblAssets.Lastseen >
GetDate() - 30)
Order By tblAssets.Domain,
tblAssets.AssetName,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion