Quick question: Do you have AppInsight for Exchange pointing to your Exchange environment? If not, get it on there a it may give you information you're after. Check out the SolarWinds demo site:
Have a look at what AppInsight for Exchange gives you. If you click on one of the mailboxes, it'll give you this information (link takes you to one of the mailboxes in the demo site).
Yes we do have AppInsight installed and we can see such reports as below which is based per DB.
But we need to see a historical report for this over X days or weeks so we can see the users that are growing fast. We have 1000's of users across lots of DB's
Looks like you'll be needing to work out a report using a custom SQL query to pull out the relevant data. Drop support a line, ask if they can help, they've assisted me in the past.
Failing that, have a look through your Orion database tables and see if you can find the relevant fields, and construct a SQL select query from there. It'll take some time, but this will be the best way to ensure you get not only the data you need, but in the format you want.
Have contacted support and will see what they say.
If anyone wishes to know how to do this then here is the Custom SQL you need to run. The caveat to this is that if you have a lot of users in a large DB the results are very good in a graph but at least you can get the historical information into Excel and then run you own reports. Enjoy:
First we need to get the list of the IDs of the databases. Please run this in Database Manager:
SELECT ID, DatabaseIdentity, ServerName
Then you can create the report:
1. Create a new report
2. Add multiple Custom Chart resources to it - one per database
3. Use the following SQL query as a datasource:
SELECT CONVERT(DATE, MAX(d.TimeStamp)) AS Date, m.DisplayName AS Account, MAX(d.TotalItemSize) AS Size, MAX(db.DatabaseIdentity) AS DBName, MAX(db.ServerName) AS ServerName FROM APM_ExBB_Mailbox_Detail d
LEFT JOIN APM_ExBB_Mailbox m ON m.ID = d.MailboxID
LEFT JOIN APM_ExBB_MailboxDatabase db ON db.ID = m.DatabaseID
WHERE DATEDIFF(dd, d.TimeStamp, GETUTCDATE()) < 30
AND m.DatabaseID = INSERT_DB_ID_HERE
GROUP BY m.DisplayName, CONVERT(DATE, TimeStamp)
ORDER BY MAX(TimeStamp) ASC
where you replace the INSER_DB_ID_HERE text with the actual ID of the database.
- 4. Set up the chart, add the Size column to the Y axis
I'm having trouble setting up the custom chart. Could you post screen grabs of how you have it setup?