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

Report Center Calculate your network's computing power
by  GBInnovation   Go to last post Go to first unread
Last post: Yesterday at 12:11:18 PM(UTC)
Lansweeper Custom All Assets Report Help
by  Matt Fuhrman  
Go to last post Go to first unread
Last post: 11/12/2019 11:13:54 PM(UTC)
Lansweeper Patch Tuesday report, last 3 months
by  JacobH   Go to last post Go to first unread
Last post: 11/12/2019 5:28:37 PM(UTC)
Lansweeper Report ALL office (ms officce,libreoffice,openoffice
by  AlexRus227  
Go to last post Go to first unread
Last post: 11/12/2019 8:37:07 AM(UTC)
Lansweeper Assets Missing Quickfix Data - Last 60 Days
by  Mike6436   Go to last post Go to first unread
Last post: 11/11/2019 6:11:30 PM(UTC)
Lansweeper BlueKeep Vulnerability
by  jwood.mls  
Go to last post Go to first unread
Last post: 11/11/2019 4:58:59 PM(UTC)
Lansweeper tblCPlogoninfo - None interactive logons?
by  Millslansweeper   Go to last post Go to first unread
Last post: 11/8/2019 1:32:12 PM(UTC)
Lansweeper Software : changes last 24 hours Enhancement
by  RC62N  
Go to last post Go to first unread
Last post: 11/7/2019 10:05:53 PM(UTC)