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.
<span class="kwd" style="color:#101094;">select</span><span class="pln" style="color:#303336;"><br /> </span><span class="pun" style="color:#303336;">*</span><span class="pln" style="color:#303336;"><br /></span><span class="kwd" style="color:#101094;">from</span><span class="pln" style="color:#303336;"><br /> LocalTable</span><span class="pun" style="color:#303336;">,</span><span class="pln" style="color:#303336;"><br /> </span><span class="pun" style="color:#303336;">[</span><span class="pln" style="color: #303336;">OtherServerName</span><span class="pun" style="color: #303336;">].[</span><span class="pln" style="color: #303336;">OtherDB</span><span class="pun" style="color: #303336;">].[</span><span class="pln" style="color: #303336;">dbo</span><span class="pun" style="color: #303336;">].[</span><span class="pln" style="color: #303336;">OtherTable</span><span class="pun" style="color: #303336;">]</span>
