No mail stats in AppInsight for Exchange

It's likely data collection is not completing in a timely fashion. I recommend completing the steps outlined on the KB article below on all Exchange Mailbox Servers monitored by AppInsight for Exchange. You may need to wait up to 24 hours before determining if this fixed the issue, as user mailbox statistics are collected only once per-day.

• SolarWinds Knowledge Base :: AppInsight for Exchange: Excessive number of PowerShell sessions and incomplete or missing …

Thanks for the suggestion. I've had a look at these settings on the DAG mailbox servers, which are as follows;

Winrs

    AllowRemoteShellAccess = true

    IdleTimeout = 180000

    MaxConcurrentUsers = 25

    MaxShellRunTime = 2147483647

    MaxProcessesPerShell = 15

    MaxMemoryPerShellMB = 512

    MaxShellsPerUser = 25

I've not changed anything, as these settings appear to be ok (and were probably set when I 'configured' the servers during the AppInsight setup)

Maybe to elaborate here. I might have found something, but need it confirmed.

If I drill down into <mailbox server> / AppInsight for Exchange / Microsoft Exchange / Database Copies, when I click on one of the DB's and go into the details of this, under Database Details / Component Name (where it shows the database name), there's a red warning showing;

PowerShell script error. Failed to connect to the RPC server on computer "<exchange3.mydomain.com>". Verify that a valid computer name was used.

Obviously I've replaced the server and domain name, but essentilly 'exchange3' is in the same site, but not accessible via RPC (only SMTP). Could this be causing the mailbox stats to fail? It's not managed in NPM, so is essentially unknown. I actually don't want to include this server anyway, just the DAG that is accessible. Can I exclude 'exchange3', or do all servers in the site have to work via RPC?

That is most certainly the root cause of the problem. That node does not necessarily need to be managed but it should be accessible via RPC to collect the necessary information about the mailbox statistics. This information is only available from the Hub Transport server.