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
