Workstations with No Biometric Hardware Report

[zinger3031]

I am trying to write a report that will identify all laptops that do not have biometric hardware installed. I was able to find a report that includes all computers with that hardware. Was wondering if this was possible to create?

[Mister_Nobody]

Try this report:

Select Top 1000000 tblassets.AssetID,
  tblassets.AssetName,
  TsysChassisTypes.ChassisName,
Max(tblPnPSignedDriversUni.DeviceName) As biometric_device,
  Count(tblPnPSignedDriversUni.DeviceName) As count_biometric_device
From tblassets
  Inner Join tblSystemEnclosure On
      tblassets.AssetID = tblSystemEnclosure.AssetID
  Inner Join TsysChassisTypes On tblSystemEnclosure.ChassisTypes =
      TsysChassisTypes.Chassistype And TsysChassisTypes.ChassisName In
      ('laptop', 'notebook', 'portable')
  Left Join tblPnPSignedDrivers On
      tblassets.AssetID = tblPnPSignedDrivers.AssetID
  Left Join tblPnPSignedDriversUni On
      tblPnPSignedDriversUni.PnPSignedDriverUniID =
      tblPnPSignedDrivers.PnPSignedDriverUniID And
      tblPnPSignedDriversUni.DeviceClass Like 'biometric%'
Group By tblassets.AssetID,
  tblassets.AssetName,
  TsysChassisTypes.ChassisName
Order By count_biometric_device Desc