‎03-16-2022 11:47 AM
‎03-24-2022 11:11 AM
Select Top 1000000 Case
When Row_Number() Over (Partition By tblassets.AssetName Order By
Query1.softwareName) = 1 Then tblassets.AssetName
Else Null
End As 'Name',
Query1.softwareName
From tblassets
Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Inner Join (Select tblSoftwareUni.softwareName,
tblSoftware.AssetID
From lansweeperdb.dbo.tblSoftware
Inner Join lansweeperdb.dbo.tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID) Query1 On Query1.AssetID = tblassets.AssetID
Where tblassetcustom.State = 1
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now