USB devices

[chaley]

I have seen in some of the other forums that USB devices are not reported. Is this still the case?

Thank you
Charles

[chaley]

I'm getting the following error with the previous posted report:

Error during saving report: "Column names in each view or functions must be unique. Column name "Size" in view or function 'Web50rep7cfa4ef84889486b80ccf755c6f3e278' is specified more than once."

[Hemoco · Accepted solution]

chaley wrote:
I'm getting the following error with the previous posted report:

Error during saving report: "Column names in each view or functions must be unique. Column name "Size" in view or function 'Web50rep7cfa4ef84889486b80ccf755c6f3e278' is specified more than once."

Remove one instance of tblFloppy.Size from the query.

This report only lists disk information however. Lansweeper currently only scans a limited number of USB devices, such as mice and keyboards. It only reports on USB devices that have their own WMI classes.

There is a Win32_USBControllerDevice WMI class that provides limited (and not very readable) info on attached USB devices, but this class is not currently implemented.

[ict-user]

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tsysOS.OSname As OS,
tsysOS.Image As icon,
tblFloppy.Manufacturer As [Drive Manufacturer],
tblFloppy.Model As [Drive Model],
tblFloppy.Size,
tblFloppy.Size
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblFloppy On tblAssets.AssetID = tblFloppy.AssetID
Left Outer Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblFloppy.Size > 1 And tblAssetCustom.State = 1 And
tblFloppy.InterfaceType = N'USB'
Order By tblAssets.AssetName Desc