• State Suggested Answer
  • Locked Locked
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 59 subscribers
  • Views 4930 views
  • Users 0 members are here
Options
Related
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

Daily Blocking History Report

shawnwilson
over 6 years ago

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.

  • 0 over 6 years ago

    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