AssetName hyperlink

[harringg]

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetID,
  tblAssets.AssetName As [Device Name],
  tblAssetCustom.Location As [Device Location],
  tblAssets.IPAddress As [IP Address],
  tblAssetCustom.Custom8 As [Switch Location],
  tblAssetCustom.Custom9 As [PatchPanel ID],
  tblAssetCustom.Custom10 As [Switch ID]
From tblAssets
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Left Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssetCustom.Custom9 Like '111%'
Order By tblAssetCustom.Custom10

How would I modify this report to allow me to click on the AssetName column and allow me to drill down to the selected device?

LS v5

[dsnyrs]

Is there a way to hyperlink
tblAssetCustom.DNSName

Thanks

[Hemoco]

dsnyrs wrote:
Is there a way to hyperlink
tblAssetCustom.DNSName

No, this is not possible.

[Hemoco]

You need to add tblAssets.AssetID like you did in your previous report.

[harringg]

Lansweeper wrote:
You need to add tblAssets.AssetID like you did in your previous report.

Thank you! That works.

[Hemoco · Accepted solution]

You need to remove the alias assigned to tblAssets.AssetName.

[harringg]

Lansweeper wrote:
You need to remove the alias assigned to tblAssets.AssetName.

That worked for that report. Thanks.

However, I have this report, which didn't have an alias, and it too won't let me click (drill-down) on the AssetName, but I'd like to be able to.

Select Top 1000000 tblAssets.AssetName,
  tblAssetCustom.Custom7,
  tblAssetCustom.Custom8,
  tblAssetCustom.Custom9,
  tblAssetCustom.Custom10,
  tblAssetCustom.Custom11,
  tblAssets.Description
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssetCustom.Custom7 Like '%:%'

LS v.5060