ALL Inventory - Dockin Station connected - Report

[techsupport1]

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

[Andy_Sismey]

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]

It don`t show as asset.

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

[techsupport1]

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?

[Andy_Sismey]

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]

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