→ 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: 
techsupport1
Engaged Sweeper II
Anyone, know how to write the report script?



Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblBaseBoard.Manufacturer As MBManufacturer,
tblUSBController.*
From tblAssets
Inner Join tblBaseBoard On tblAssets.AssetID = tblBaseBoard.AssetID
Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
Inner Join tblUSBController On tblAssets.AssetID = tblUSBController.AssetID
Order By tblAssets.AssetName
5 REPLIES 5
Andy_Sismey
Champion Sweeper III
I think your correct have a look at this post

https://www.lansweeper.com/forum/yaf_postst19208findunread_Tracking-assets-like-docking-station--mouse-and-keyboards.aspx#post61985
techsupport1
Engaged Sweeper II
It don`t show as asset.

That mean not all IT Asset can be manage by lansweeper.

techsupport1
Engaged Sweeper II
Hi Andy,

Firstly thank you for help to try out.

We brought a few Dock / Docking Station from Dell that have Model & Serial:-

1) Model WD19
2) Model WD19DC
3) Model WD19TB
4) Model D3100


Not sure how to write the SQL script to show as a inventory report for audit?
Hi,

So If you Click On the Asset Tab and type one of the models in say WD19 into the Model filter does it show as an asset if not ///

One option if they are not being scanned is to manually add them to the Asset database, then link them with the particular laptops , so when you view the laptops the Dock will display as a linked device, you can also import multiple docks from a CSv?
Andy_Sismey
Champion Sweeper III
This could be a starting point, I dont have many docks to test it on ....

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblSystemEnclosure.ChassisTypes,
tblSystemEnclosure.Win32_SystemEnclosureid,
TsysChassisTypes.ChassisName,
tblSystemEnclosure.LockPresent,
tblSystemEnclosure.SecurityStatus,
tblSystemEnclosure.Manufacturer,
tblSystemEnclosure.SerialNumber,
tblSystemEnclosure.Version,
tblSystemEnclosure.SMBIOSAssetTag,
tblSystemEnclosure.Lastchanged
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblSystemEnclosure On
tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes
Where tblSystemEnclosure.ChassisTypes = '12' And tblAssetCustom.State = 1