I'm trying to create a report on our assets that link to individual users. For example, the first column would be the AssetTag, and the second would be the User (Showing as Lastname, Firstname or Firstname Lastname). I'd like to be able to click on that user and go to the page for that user's AD information and logged computers. The best I've been able to do so far is to show their username, although it is not clickable. Is there a way to link the user?
This is the report I have so far:
Select Top 1000000 tblSystemEnclosure.SMBIOSAssetTag,
tblAssets.Username,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblSystemEnclosure On
tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Where tblAssetCustom.State = 1 And tsysAssetTypes.AssetType = -1
