Report needed that shows all servers and all of the software

[dsnider]

Hello, 

Would you please help me with a sql query to create a report that lists all of our servers and all of the software installed on them?  This would be for windows server. 

Thank you!

[Mister_Nobody · Accepted solution]

Try this:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblSoftwareUni.softwareName As Software,
  tblSoftwareUni.SoftwarePublisher As Publisher,
  tblSoftware.softwareVersion As Version,
  tblSoftware.Lastchanged,
  tblAssets.Lastseen
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
  Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.OScode Like '%s' And tblState.Statename = 'Active'

[dsnider]

Thank you so much!!  This is exactly what I needed!

Kindest regards, Dena