cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
meddlema
Engaged Sweeper
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'
0 REPLIES 0