→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
jrichg
Engaged Sweeper
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
1 REPLY 1
MikeMc
Champion Sweeper II
I'm having a hard time envisioning the output of this request. Can you provide a sample?