Get an overview of all the asset types that have been scanned by Credential free Device Recognition (CDR). CDR can be affectively used to monitor what devices are active on your network and retains data for 14 days by default. By using this chart, you’ll be able to check which devices have been active in a specific subnet in the last 14 days. To get more info on CDR and how you can use it, you can also check out the related Pro Tips blog post.
To use this in a chart widget, prefix the report name with “Chart:” and select it in the chart report widget found on a dashboard.
Asset Types Scanned by CDR Chart Lansweeper Classic Query
select Type,
sum(Assets) as Assets
from (Select Top 1000000 Coalesce(NullIf(tsysAssetTypes.AssetTypename, 'Unknown'),
tsysAssetTypes2.AssetTypename, 'Unknown') As 'Type',
Count(tblAssetRadarDevice.Ipv4Address) As Assets,
tsysAssetTypes.AssetTypename,
tsysAssetTypes2.AssetTypename As AssetTypename1
From tblAssetRadarDevice
Left Join tblDeviceRecognition On tblAssetRadarDevice.MacAddress =
tblDeviceRecognition.MacAddress
Left Join tblAssetMacAddress On tblAssetMacAddress.Mac =
tblAssetRadarDevice.MacAddress And tblAssetMacAddress.AssetID In
(Select Top (1) tblAssets.AssetID
From tblAssets Inner Join tblAssetRadarDevice On
tblAssetRadarDevice.MacAddress = tblAssets.Mac
Where tblAssets.Mac = tblAssetMacAddress.Mac Order By
tblAssets.Lastseen Desc) And tblAssetMacAddress.AssetID In (Select Top
(1) tblAssets.AssetID From tblAssets
Where tblAssets.IPAddress Is Not Null And tblAssets.IPAddress =
tblAssetRadarDevice.Ipv4Address And tblAssets.Mac Is Not Null And
tblAssets.Mac = tblAssetRadarDevice.MacAddress Order By
tblAssets.Lastseen Desc)
Left Outer Join tblAssets On tblAssets.AssetID = tblAssetMacAddress.AssetID
Left Outer Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Outer Join tsysAssetTypes On tsysAssetTypes.AssetType =
tblAssets.Assettype
Left Outer Join tsysAssetTypes As tsysAssetTypes2 On
tsysAssetTypes2.AssetType = tblDeviceRecognition.Type
Group By tsysAssetTypes.AssetTypename,
tsysAssetTypes2.AssetTypename) as Sub
group by Type
order by Assets desc
