Hello,
I am looking for a Report that will generate the software installed on an asset listed by Asset Groups. I am currently using the following snippet, however this only generates a list of software based on AssetID.
Select Top 1000000 *
From (Select Top 1000000 tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version,
Reverse(Stuff(Reverse((Select a.AssetName + ', '
From tblSoftware s Inner Join tblSoftwareUni su On su.SoftID = s.softID
Inner Join tblAssets a On a.AssetID = s.AssetID Inner Join
tblAssetCustom ac On ac.AssetID = a.AssetID
Where ac.State = 1 And su.softwareName = tblSoftwareUni.softwareName And
s.softwareVersion = tblSoftware.softwareVersion Order By a.AssetName
For Xml Path(''))), 1, 2, '')) As Computers
From tblSoftware
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Group By tblSoftwareUni.softwareName,
tblSoftware.softwareVersion) T1
Where T1.Computers Is Not Null
Order By T1.Software,
T1.Version