Add computer OU column to SCCM reports

There a various reports that I would like to add a column which includes the computer OU.  I don’t know SQL so I was wondering if I could get help to create a query.  A couple of the reports in particular I want to add the computer OU column to are the Inactive clients details report under Client Status category and the Bitlocker Enterprise Compliance Details under en-US category.  I want to the add columns so that I can email one report to our department liaisons and they can see the computers that need remediation for their areas.  I don’t want to create subscriptions for each department.

Any help would be appreciated!

MLstev01

Leave a Reply