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