Asset name, Department Name, Username Report

[willkp23]

I am looking for a report to show the following items in columns. I have no clue how to do this!

Asset Name
Username (only active ones)
Department they work in
What type of asset (no servers)

Any ideas? i'm stuck

[Hemoco · Accepted solution]

Hi,

Use the following report to get the information that you want:

Select Distinct Top 1000000 tsysAssetTypes.AssetTypeIcon16 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblAssets.Userdomain,
tblAssetCustom.Department,
tblComputersystem.Domainrole,
tsysAssetTypes.AssetTypename As type
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblComputersystem.Domainrole < 2



To use the report above, do the following:
• Open the report builder under Reports/Create New Report.
• Paste the SQL code we provided at the bottom of the page.
• Left-click somewhere in the upper section of the page so the code applies.
• Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.