This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Exporting data to an external database

We would like to export backup data for all monitored SQL Servers ideally directly to another database so that we can join with another system to create reports.  For example: show backups by DBA, by application etc..  Management is very interested in this type of tracking for obvious reasons.  Is there a way to do this other than exporting to flat file? We would like an automated method.

Parents
  • Hello Robert,

    you posted this request in the Foglight forum, but Foglight is a monitoring tool and not a backup tool. Maybe I misunderstand your request. If that is the case, please provide a bit more details which part of the backup workflow you want to monitor.

    Kind Regards

    Nicola

  • Yes, you do misunderstand what I am asking.  We monitor our SQL Server environment with Foglight.  There are several ways to look at backup data (when was the last backup, how it was performed, was the backup successful etc.) within Foglight.  However, from management's perspective, seeing a list of databases and their last successful backup date is only mildly interesting.  How does a manager, especially upper management, filter to figure out who is responsible for failed backups, or what application the database is a part of?  They can't just from the Foglight view.  However, we have other database inventory systems that match databases to DBAs, to first line managers, and to applications.  Obviously, we could manually export reports from Foglight as XLS and then export reports from our inventory systems and manually create these types of reports that show the information we are after.  However, it would be ideal to automate a report export from Foglight to a remote database so that we can then join that report to our inventory system so that we can create a new report/dashboard (not in Foglight) that shows what we are looking for.  If not directly to an external database, at least to a remote fileshare.  So far, I have been able to use groovy script to save a report to a local directory on the FMS, but I cannot figure out how to send remotely.

Reply
  • Yes, you do misunderstand what I am asking.  We monitor our SQL Server environment with Foglight.  There are several ways to look at backup data (when was the last backup, how it was performed, was the backup successful etc.) within Foglight.  However, from management's perspective, seeing a list of databases and their last successful backup date is only mildly interesting.  How does a manager, especially upper management, filter to figure out who is responsible for failed backups, or what application the database is a part of?  They can't just from the Foglight view.  However, we have other database inventory systems that match databases to DBAs, to first line managers, and to applications.  Obviously, we could manually export reports from Foglight as XLS and then export reports from our inventory systems and manually create these types of reports that show the information we are after.  However, it would be ideal to automate a report export from Foglight to a remote database so that we can then join that report to our inventory system so that we can create a new report/dashboard (not in Foglight) that shows what we are looking for.  If not directly to an external database, at least to a remote fileshare.  So far, I have been able to use groovy script to save a report to a local directory on the FMS, but I cannot figure out how to send remotely.

Children