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!