→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
chaley
Engaged Sweeper
I have seen in some of the other forums that USB devices are not reported. Is this still the case?

Thank you
Charles
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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.

View solution in original post

3 REPLIES 3
chaley
Engaged Sweeper
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
Lansweeper Alumni
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
Engaged Sweeper III
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