Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ashleyrosa7352
Engaged Sweeper

Hello, I am a New member of this group

2 REPLIES 2
Mister_Nobody
Honored Sweeper III

Try this report:

Select Top 1000000 a.AssetID,
  a.AssetName,
  a.Domain,
  a.Username,
  a.Userdomain,
  Coalesce(os.Image, [at].AssetTypeIcon10) As icon,
  a.IPAddress,
  ipl.IPLocation,
  ac.Manufacturer,
  ac.Model,
  os.OSname As OS,
  a.SP,
  a.Lastseen As [Last successful scan],
  a.Lasttried As [Last scan attempt],
  pnpdu.DeviceName,
  pnpdu.Description,
  pnpd.FriendlyName,
  pnpdu.DeviceClass,
  pnpdu.DriverProviderName,
  pnpd.DriverVersion,
  pnpd.HardwareID,
  pnpd.PDO,
  pnpd.DeviceID
From tblAssets a
  Left Join tblAssetCustom ac On ac.AssetID = a.AssetID
  Inner Join tblPnPSignedDrivers pnpd On a.AssetID = pnpd.AssetID
  Inner Join tblPnPSignedDriversUni pnpdu On pnpd.PnPSignedDriverUniID =
      pnpdu.PnPSignedDriverUniID
  Left Join tsysAssetTypes [at] On [at].AssetType = a.Assettype
  Left Join tsysIPLocations ipl On a.IPAddress = ipl.IPLocation
  Left Join tsysOS os On os.OScode = a.OScode
  Left Join tblState st On st.State = ac.State
Where pnpdu.DeviceClass = 'BIOMETRIC' And pnpd.PDO Is Not Null And
  pnpd.PDO <> '' And Lower(st.Statename) = 'active'
Order By a.Domain,
  a.AssetName,
  pnpdu.DeviceClass,
  pnpdu.DeviceName
FrankSc
Lansweeper Tech Support
Lansweeper Tech Support

Dear, 

It depends a bit on which protocols are supported on the devices you want to scan.

Some support SNMP, in that way, they can be scanned as a "network device". 

Some may also support SSH, so you can probably use an SSH credential. 
But we believe SNMP would be the preferred way to do it.

 

Scan a network device - Lansweeper Community

 

General Discussions

Find answers to technical questions about Lansweeper.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now