SCCM SQL Query to get Windows Hello for Business installed devices

Question

SCCM SQL Query to get Windows Hello for Business installed devices

Kalyan Sundar 566

Hi All,

Anybody have a SQL query to get Windows Hello for Business installed devices

Thank you

3 answers

Your answer

Answer 1

Hi, @Kalyan Sundar

Thank you for posting in Microsoft Q&A forum.

Check if this query helps:

select 
S.Name0 as [ComputerName],
CDR.SerialNumber as [SerialNumber],
S.User_Name0 as [UserName],
CS.Manufacturer0 as [Manufacturer],
CS.Model0 as [Model],
S.Build01 as [OS Build],
CDR.LastPolicyRequest as [Last Online],
CASE WHEN S.ResourceId in (select ResourceId from v_GS_SYSTEM_DEVICES where Name0 = 'Windows Hello Face Software Device') THEN 'YES' ELSE 'NO' END as [Hello Face Supported],
CASE WHEN S.ResourceId in (select ResourceId from v_GS_SYSTEM_DEVICES where Name0 like '%Fingerprint%') THEN 'YES' ELSE 'NO' END as [Hello Fingerprint Supported]
from v_R_System as S
join v_CombinedDeviceResources as CDR on (CDR.MachineID = S.ResourceID)
join v_GS_COMPUTER_SYSTEM as CS ON (CS.ResourceId = S.ResourceId)
join v_GS_SYSTEM_ENCLOSURE as SE ON (SE.ResourceId = S.ResourceId)
where SE.ChassisTypes0 in (9, 10, 11, 12, 30, 31, 32)
and SE.Tag0 = 'System Enclosure 0'
order by Model

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Add comment".

Answer 2

Garth 5,801

Windows hello is not inventoried by default by Configmgr. You will need to extend the inventory first.

Alfredo Alegrett 0 Reputation points

2024-02-22T16:35:11.4566667+00:00

Hello Garth, how do I extend the inventory?
Garth Jones 1,666 Reputation points MVP

2024-02-22T18:40:18.2966667+00:00

Extending the inventory of ConfigMgr is the easy part. The hard part is How can you actually inventory the data you want. e.g. how do you know exactly which system Windows Hello is installed? Once you can answer that question adding the inventory is "easy"
Alfredo Alegrett 0 Reputation points

2024-02-22T19:18:46.07+00:00

Thank you Garth for your reply. My issue is I want to inventory systems before deploying WH4B to see how many are capable and how many are not. Running the script above, has giving lots of false negative, reporting laptops as not having a camera cable of WH4B, but in physical inspection they systems do have a capable camera. Thank you in advance for any suggestions.
Garth Jones 1,666 Reputation points MVP

2024-02-22T20:23:39.2033333+00:00

So How exactly are you inspecting a system to determine that WH4B is capable? this will reveal how you can automate the data collection for a single device. once that is done you can then extend the inventory to collect the data.
Alfredo Alegrett 0 Reputation points

2024-02-27T14:21:09.88+00:00

I have ran the SQL query listed above, but he results tell me that only 100 computers out of 8,000 have a capable camera. I have researched over 800 of the systems that report NOT having a capable camera and they all do. Any ideas why I'm getting so many false negatives? Thank you.
Garth Jones 1,666 Reputation points MVP

2024-02-28T15:54:24.06+00:00

How exactly are you determine that they are capable? Exactly what steps did you take?

Answer 3

Kalyan Sundar 566

CASE WHEN S.ResourceId in (select ResourceId from v_GS_SYSTEM_DEVICES where Name0 = 'Windows Hello Face Software Device') THEN 'YES' ELSE 'NO' END as [Hello Face Supported]

If the above condition is true, it means the machine have enabled Windows hello ?

AllenLiu-MSFT 49,316 Reputation points Microsoft External Staff

2023-10-13T05:37:12.2133333+00:00

Yes, it means the Windows Hello Face has enabled. You may test some devices to see if it is correct.
AllenLiu-MSFT 49,316 Reputation points Microsoft External Staff

2023-10-27T07:38:25.0666667+00:00

Just checking if there's any progress or updates?
Alfredo Alegrett 0 Reputation points

2024-02-22T16:38:11.8+00:00

I ran this query, and the results tell me that only 100 computers out of 8,000 have a capable camera. I have researched over 800 of the systems that report NOT having a capable camera and they all do. Any ideas why I'm getting so many false negatives? Thank you.

Share via

SCCM SQL Query to get Windows Hello for Business installed devices

3 answers

Your answer