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: 249  
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 Hyper-V guests dissapeared and reappeared
by  Esben.D   Go to last post Go to first unread
Last post: Yesterday at 4:30:47 PM(UTC)
Lansweeper DB cleanup script
by  William382  
Go to last post Go to first unread
Last post: Yesterday at 4:23:43 PM(UTC)
Lansweeper Installing MS KB with Deploy
by  Esben.D   Go to last post Go to first unread
Last post: Yesterday at 4:01:45 PM(UTC)
Lansweeper Ticket Info Meter incorrect
by  pfalls  
Go to last post Go to first unread
Last post: Yesterday at 3:27:44 PM(UTC)
Lansweeper Asset Checkboxes in reports
by  ufficioced   Go to last post Go to first unread
Last post: Yesterday at 1:22:17 PM(UTC)
Lansweeper Silent "Run as logged in user" option
by  CyberCitizen  
Go to last post Go to first unread
Last post: Yesterday at 3:45:25 AM(UTC)
Lansweeper New ticket creation not emailing the user
by  MVMIC IT LANSWEEPER   Go to last post Go to first unread
Last post: 11/15/2019 5:36:23 PM(UTC)