Notification

Icon
Error

Asset Group Config - setting up asset groups that list usb devices

Posted: Friday, October 11, 2019 3:31:01 PM(UTC)
aaapp user

aaapp user

Member Original PosterPosts: 1
0
Like
How would i set up an asset group to show the printers that are connected by usb and arent on the network
CyberCitizen
#1CyberCitizen Member Posts: 359  
posted: 10/14/2019 1:10:54 AM(UTC)
Originally Posted by: aaapp user Go to Quoted Post
How would i set up an asset group to show the printers that are connected by usb and arent on the network


Not sure on Asset Group but there is a report for this.

Printer: Local USB Printers

Code:
Select Top 1000000 tsysOS.Image As Icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tsysOS.OSname As OS,
  tblAssets.SP,
  tblAssets.IPAddress As IP,
  tblPrinters.Caption As Printer,
  tblPrinters.Portname As [Printer Port],
  tblPrinters.Capabilitydescriptions As [Printer Capabilities],
  tblPrinters.Lastchanged
From tblAssets
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Left Join tblPrinters On tblAssets.AssetID = tblPrinters.AssetID
Where (tblPrinters.Portname Like 'DOT4%' Or tblPrinters.Portname Like 'USB%')
  And tblPrinters.Local = 1
Order By tblAssets.Domain,
  tblAssets.AssetName,
  Printer

Active Discussions

Lansweeper Unable to send to External Email
by  pryan67   Go to last post Go to first unread
Last post: Yesterday at 8:21:01 PM(UTC)
Lansweeper Lansweeper assets not being Scanned
by  Jordan  
Go to last post Go to first unread
Last post: Yesterday at 6:42:22 PM(UTC)
Lansweeper Database size growing too large
by  bladd   Go to last post Go to first unread
Last post: Yesterday at 4:26:44 PM(UTC)
Lansweeper Searching Specific File
by  mzipperer  
Go to last post Go to first unread
Last post: Yesterday at 4:23:29 PM(UTC)
Lansweeper Exchange 2010 information is not populating
by  Moe   Go to last post Go to first unread
Last post: Yesterday at 12:30:38 PM(UTC)
Lansweeper Routinely Exploited Vulnerabilities Query Report
by  pryan67  
Go to last post Go to first unread
Last post: Yesterday at 12:25:31 PM(UTC)
Lansweeper Creating a report for new devices every 2 hours to alert
by  Moe   Go to last post Go to first unread
Last post: 6/4/2020 7:26:11 PM(UTC)
Lansweeper Changes in the licensing model
by  BullGates  
Go to last post Go to first unread
Last post: 6/4/2020 6:27:23 PM(UTC)