exchange report to show users sorted by organisational unit?

In the SQL Database:

dbo.APM_ExBB_Mailbox.OrganizationalUnit

In SWQL it is:

Orion.APM.Exchange.Mailbox.OrganizationalUnit

In the Web Report Writer, that's going to be found under the "AppInsight for Exchange: Mailbox" object type as such:

Hope that helps!

-ZackM

Loop1 Systems: SolarWinds Training and Professional Services

• LinkedIN: Loop1 Systems
• Facebook: Loop1 Systems
• Twitter: @Loop1Systems

Just one further question? @zackm that screenshot you posted doesn't look like my web report writer,

and when I create my new web report I can't see that field you mentioned. "AppInsight for Exchange: Mailbox" am I in the wrong place completely?

The GUI is from NPM 12 RC1

The screen you are on is where you choose what type of content you want to add to your report. I would start with Reports > Custom Table

The next screen would ask you what you want to report on, in your case it would be the Mailboxes

The screen after that would allow you to then design your actual table, that's where you can select columns (which is the screenshot I added previously)

Thanks for your help and I created my report and management were happy.