Is it possible to run SQL Server/ Oracle DB reports simultaneously for multiple DB instances rather then running for individual instances?

Hello Yusuf,

there are cross instance reports available (Oracle + SQL Server). But you need to be aware that those reports are resource intensive. 

To find the reports, click on the"Reports" lefthand side under Dashboards and then click on "Run a Report". In the popup window select "All SQL Templates" or "All Oracle Templates", when you filter for "Cross Instances" you will get all available reports. See screenshot below.

Does that help?

Kind Regards

Nicola

Hi Nicola,

Thank you for your response, I'm familiar with Foglight report templates, however these reports can be run only for single/ one DB instance at a time and are not very user friendly for customer's who have a large DB environment and are looking to execute reports for multiple DB instances at the same time. Looking for an option or a work around option that gives customers flexibility to execute reports for multiple database instances at the same time.

Hi Nicola,

Thank you for your response, I'm familiar with Foglight report templates, however these reports can be run only for single/ one DB instance at a time and are not very user friendly for customer's who have a large DB environment and are looking to execute reports for multiple DB instances at the same time. Looking for an option or a work around option that gives customers flexibility to execute reports for multiple database instances at the same time.

Hello Yusuf,

in that case you can check if the DB Expansion Pack provides the reports you need. You can get it from here:

https://www.quest.com/community/foglight/f/forum/418/foglight-database-expansion-pack

The pack contains additonal dashboards + reports which were created by our PSO team and are based on customers requests they picked up from the field.

I hope that helps.

Kind Regards

Nicola

Hi Nicola,

Thank you for sharing information on DB Expansion Pack, this looks promising, let me explore the reports in detail.Thanks again in advance for your help in this matter.