Hello,
I am fairly new to reporting in Lansweeper and I have created a report that lists Non-Active Monitors with following information
AssetName
AssetTypename
Lastseen
Lasttried
State
Serialnumber
Description
Model
Manufacturer
I would like to see on the report the pc's the monitors in Non-Active state are showing connected to. I appreciate any help regarding this request.
Here is the code I am currently using.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssetCustom.State,
tblAssetCustom.Serialnumber,
tblAssets.Description,
tblAssetCustom.Model,
tblAssetCustom.Manufacturer
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tsysAssetTypes.AssetTypename = 'Monitor' And tblAssetCustom.State = '2'
