I have a working report that works great that shows our USB-C Docks, however I'd like to change this to be a Chart report so that I can create a dashboard widget for the data. The SQL query I have working for the report is below. How do I change this so that it becomes compatible for use as a Chart report?
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblUSBDevices.Name As [USB Device],
tblUSBDevices.Manufacturer As [USB Device Manufacturer]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblUSBDevices On tblAssets.AssetID = tblUSBDevices.AssetID
Where tblUSBDevices.Name Like '%usb-c%' And tblUSBDevices.Name Not Like '%Head%'
And tblAssetCustom.State = 1
Order By [USB Device]
