cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
magson
Engaged Sweeper II
Hello All,

I am trying to create a basic report on ALL our assets to who installed it and when. I felt it to be simple, but turns out for me, it is not.

All I need on the report is, ANY Asset ID (PC,Printer, Monitor, anything) with the fields who installed it and when.

When I create this report, i got 90% there but it only shows PC/Laptop hostnames and nothing else. -



Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename As AssetType,
tsysAssetTypes.AssetTypeIcon10 As Icon,
tblAssetUserRelations.Username As [Installed By],
tblAssetUserRelations.StartDate As [Date Installed]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetUserRelations On
tblAssets.AssetID = tblAssetUserRelations.AssetID
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Where tblAssetUserRelations.Type Like '%8%' And tblAssetCustom.State = 1
Order By tblAssets.AssetName


I do hope someone can answer my issue.

If you require any more information, please let me know
0 REPLIES 0