obso1337
asked on
SCCM Smart Card Reader Report
I need to make an SCCM report that will show the workstation name if if it has a usb smart scard reader attached. If it could search for the usb device description being like either one of these that would be great:
Smart Card%
%USB CCID%
%Usbccid%
USB Smart%
ActivCard%
SCR33x%
Any help is appreciated.
Smart Card%
%USB CCID%
%Usbccid%
USB Smart%
ActivCard%
SCR33x%
Any help is appreciated.
ASKER
No. I see the sata controller...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Okay. I'll have to check it out tomorrow.
ASKER
That some what helped me, but I would like to know if anyone can correct the WQL statement and make it work?
SELECT DISTINCT v_GS_SYSTEM.Name0
FROM v_GS_SYSTEM
WHERE v_GS_USB_DEVICE.Description0 LIKE 'Smart Card% or %USB CCID% or %Usbccid% or USB Smart% or ActivCard% or SCR33x%'
FROM v_GS_USB_DEVICE
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That works, but it's showing every workstation even though half of them don't have smart card readers.
I would encourage you to review the criteria - you defined the search to look with any system with the result matching ANY of the criteria you listed. If I run the report with your criteria, I also get all the comptuers in my site. If I remove all the criteria except %Smart Card% I do not return any results in my site (I do not believe I have any Smart Cards used in my site). Please review your criteria to tweak your results. //lwb
ASKER
After editing the query I was able to get what I needed. Thanks
I know this post is old, but I figured I'd throw in my $.02.
SELECT DISTINCT SystemName0
, Caption0
, Description0
, Manufacturer0
, Name0
, GroupID
, ResourceID
, Service0
, Status0
, TimeStamp
FROM dbo.v_GS_USB_DEVICE
WHERE ClassGuid0='{50dd5230-ba8a -11d1-bf5d -0000f805f 530}'
ORDER BY Name0
SELECT DISTINCT SystemName0
, Caption0
, Description0
, Manufacturer0
, Name0
, GroupID
, ResourceID
, Service0
, Status0
, TimeStamp
FROM dbo.v_GS_USB_DEVICE
WHERE ClassGuid0='{50dd5230-ba8a
ORDER BY Name0
wmic scsicontroller get name, description, deviceid
Do you see your smartcard reader listed in there?