NEW Required Sql Query for fetching Workstations Compliance

[Karthik Upendra]

Hi, I am looking for a sql query that lists the application installed (with version),Bit locker encryption, Patching compliance, AV status from list of all computers in my organization. I manage the configuration manager and I know how to run the query from management studio. I just need the query. please help.

 

[Garth]

Have you looked at the built in reports for this. What is wrong with their queries?

 

[Karthik Upendra]

Hi Garth,

Thanks for reply . I am looking for consolidated report which has all the parameters as i mentioned above,

 

[Garth]

Again, have you looked a the built in reports? They have the SQL queries in each report. From there you can create your own dashboard with anything you like.

If you are looking for one that is prebuilt for you then Bing for dashboard like that. Therefore both commercial and many be community ones. Keep in mind that is a lot of data for a dashboard.