Win 10 Bitlocker
Question
Hi HTMD
Can someone help me with the below query
I want to fetch a report for all my win 10 devices and check if bitlocker is enabled or not in sql with the following attributes…
Computer name
Last logon user name
Zone
Country
Site
Protection bitlocker enabled or not
Answers ( 8 )
I cannot generate a report itself from built in SSRS
Copy the SQL query from that report and try removing collection-related section from the default query.
If there is any sql query …please share sir
Hi htmd,
I think the collection is not getting displayed in my environment.
So please have this thread closed.
Thank you again
Yes sir, i tried from default reports but when i select the collection id from the drop down menu, nothing is available to select..
I think you can try to edit that report and remove the collection prompt
Make a copy of the original report and try to edit the copied report
There are many default reports available for SCCM BitLocker management
BitLocker Computer Compliance
BitLocker Enterprise Compliance Dashboard
BitLocker Enterprise Compliance Details
BitLocker Enterprise Compliance Summary
Recovery Audit Report
https://docs.microsoft.com/en-us/mem/configmgr/protect/deploy-use/bitlocker/view-reports
Are you looking for something different?