Get an Overview of Asset Types Seen by CDR
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.
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