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: 247  
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 Check if Netbios is disabled over TCP/IP
by  CyberCitizen   Go to last post Go to first unread
Last post: Today at 2:35:37 AM(UTC)
Lansweeper Change the Callto: link to Tel:
by  CyberCitizen  
Go to last post Go to first unread
Last post: Today at 2:05:38 AM(UTC)
Lansweeper Ticket Info Meter incorrect
by  pfalls  
Go to last post Go to first unread
Last post: Yesterday at 4:32:21 PM(UTC)
Lansweeper OS: Not latest Build of Windows 10 report
by  RKCar   Go to last post Go to first unread
Last post: Yesterday at 3:08:52 PM(UTC)
Lansweeper Windows Defender AV
by  Mikey!  
Go to last post Go to first unread
Last post: Yesterday at 2:48:54 PM(UTC)
Lansweeper Allow Users and cc Users to edit ticket form field
by  eoinpryan   Go to last post Go to first unread
Last post: Yesterday at 12:41:05 PM(UTC)
Lansweeper Mobile App
by  jdvuyk  
Go to last post Go to first unread
Last post: Yesterday at 2:28:56 AM(UTC)