This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Send reports from all three regions in one email?

Hey everyone,

I'm curious if there is a way (maybe from the EOC?) to send monthly reports from three regional SolarWinds servers in one email?  Instead of having three emails separately being sent from each one. 

Any insight would be helpful.  Thanks!

  • EOC only holds the latest stats, so if your reports include historical data (which i would expect almost all good reports should) then it will not serve to aggregate them.

    I'd expect the only way to pull this off using Solarwinds tools would be to consolidate those three separate instances into a single instance using additional polling engines and additional web servers.  Outside of that you could do it directly in SQL Server Reporting Services but that would be happening entirely outside the Orion UI.

  • aLTeReGo​ Do you have any insight into how this may be achieved?

  • Off hand the only way I can see to achieve this today is with a cross database SQL query. This can be done by specifying multiple instances and database in the FROM clause of your SQL query. E.G.

    select
      
    *
    from
      LocalTable
    ,
      
    [OtherServerName].[OtherDB].[dbo].[OtherTable]