All SQL All Versions

[chads]

Looking for a report that combines all SQL versions installed and leaves out the junk that isn't needed. Microsoft SQL, postresql and everything else with other vendors that is SQL.

[MikeMc]

I updated my previous query to remove the Linux references.

[chads]

This is providing this error

Error: Conversion failed when converting date and/or time from character string.

[MikeMc · Accepted solution]

This query lists all software that contains SQL in the name.

Select Top 100000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblSoftwareUni.softwareName As Software,
  tblSoftware.softwareVersion As Version,
  tblSoftware.Installdate
From tblAssets
  Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
  Inner Join tblSoftware On tblSoftware.AssetID = tblAssets.AssetID
  Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID 
Where tblSoftwareUni.softwareName Like '%SQL%' And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
  Software