Notification

Icon
Error

ALL Inventory - Dockin Station connected - Report - Run Audit Report - for all brand, model, serial number, firmware, warranty status

Posted: Saturday, November 7, 2020 12:41:56 PM(UTC)
TechSupport

TechSupport

Member Original PosterPosts: 2
0
Like
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

Active Discussions

Lansweeper Software deployment initiated by user
by  LS_enthusiast_4444  
Go to last post Go to first unread
Last post: Yesterday at 9:28:18 PM(UTC)
Lansweeper Help Desk not disabling for regular users?
by  FrankSc   Go to last post Go to first unread
Last post: Yesterday at 8:18:38 PM(UTC)
Lansweeper Satisfaction Questionnaire after ticket close
by  mouaad  
Go to last post Go to first unread
Last post: Yesterday at 4:31:44 PM(UTC)
Lansweeper Microsoft EDGE browser support
by  Vapoured   Go to last post Go to first unread
Last post: Yesterday at 4:54:30 AM(UTC)
Lansweeper Asset Management - Unattached assets
by  MrDiamond  
Go to last post Go to first unread
Last post: 11/25/2020 8:15:16 PM(UTC)
Lansweeper Lansweeper Fresh Install Hanging, High CPU, Unusable
by  ebars   Go to last post Go to first unread
Last post: 11/24/2020 7:53:38 PM(UTC)
Lansweeper Forwarding tickets to regular email recipents
by  ChristerT  
Go to last post Go to first unread
Last post: 11/24/2020 9:48:15 AM(UTC)