List of asset documents with clickable links

[Susan_A]

The report below lists the documents you've added to your assets. Replace what's marked in yellow with your own Lansweeper server name and website port number. You can then click on a document name in the Hyp column to open the corresponding doc.

The report will only list assets that meet all of the following criteria:

• The asset's state is set to "active".
  
• At least one document was added to the Docs tab of the asset's Lansweeper webpage.

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tsysAssetTypes.AssetTypename As AssetType,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Serialnumber,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  'http://LansweeperServerName:81/AssetActions.aspx?action=getDoc&assetId=' +
  Cast(tblAssets.AssetID As nvarchar) + '&docId=' + tblAssetDocs.Docguid As
  hyperlink_hyp,
  'Document: ' + tblAssetDocs.Docname As hyperlink_name_hyp,
  tblAssetDocs.AddedBy,
  tblAssetDocs.Added
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblAssetDocs On tblAssets.AssetID = tblAssetDocs.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.IPNumeric,
  tblAssets.AssetName,
  tblAssetDocs.Added Desc