Win 10 Bitlocker
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…
Last logon user name
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
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
Are you looking for something different?