Has anyone created any blocking history reports? I am looking to create daily blocking reports that are emailed every morning about what was blocking what and for how long.... host, app, sql, resource, lock type, start time, block duration, block chain, ... anything. Any thoughts would be appreciated.
Hello, there is lock report available for Oracle. Please go to the reports dashboard and under "Run a Report" find the Oracle templates. There is a report called "Locks Report". Please check if that contains the details you need. For SQL Server we have a Deadlock Report available. Apart from that you can always create a report based on data of a specific dashboard. On the top top right corner of the dashboard you will find a "Report" icon. There you can click on "Create a new report" and select then "create report based on current dashboard". If you are not familiar with the Foglight object structure, you might need PSO assistance to get this done. Does that help? Kind Regards Nicola