‎05-27-2022 01:57 PM
Solved! Go to Solution.
‎05-27-2022 03:56 PM
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',
Case
When Row_Number() Over (Partition By tblassets.AssetName Order By
Query1.softwareName) = 1 Then tblassetcustom.Manufacturer
Else Null
End As 'Manufacturer',
Case
When Row_Number() Over (Partition By tblassets.AssetName Order By
Query1.softwareName) = 1 Then tblassetcustom.Model
Else Null
End As 'Model',
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
‎12-14-2022 07:02 PM
Still looking for help with this report
‎05-27-2022 04:15 PM
‎05-27-2022 03:56 PM
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',
Case
When Row_Number() Over (Partition By tblassets.AssetName Order By
Query1.softwareName) = 1 Then tblassetcustom.Manufacturer
Else Null
End As 'Manufacturer',
Case
When Row_Number() Over (Partition By tblassets.AssetName Order By
Query1.softwareName) = 1 Then tblassetcustom.Model
Else Null
End As 'Model',
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
‎05-27-2022 02:15 PM
‎05-27-2022 02:45 PM
Andy.S wrote:
Have a look at this one : https://www.lansweeper.com/forum/yaf_postst14691_List-all-assets-report.aspx#post50226
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now