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 Microsoft EDGE browser support
by  Vapoured   Go to last post Go to first unread
Last post: Today at 4:54:30 AM(UTC)
Lansweeper Asset Management - Unattached assets
by  MrDiamond  
Go to last post Go to first unread
Last post: Yesterday at 8:15:16 PM(UTC)
Lansweeper Help Desk not disabling for regular users?
by  Maveritsch   Go to last post Go to first unread
Last post: Yesterday at 3:22:03 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)
Lansweeper Outlook task and calendar
by  Squack the Duck  
Go to last post Go to first unread
Last post: 11/24/2020 12:40:37 AM(UTC)
Lansweeper Cap on number of routers?
by  MarkPayton   Go to last post Go to first unread
Last post: 11/23/2020 10:04:12 PM(UTC)
Lansweeper Authenticate from CLI
by  blunderdog  
Go to last post Go to first unread
Last post: 11/23/2020 9:57:04 PM(UTC)