Jimmy Harper's Operations Manager Blog

Posts in this blog are provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified in the Terms of Use

November, 2010

  • Active Alerts Report

    NOTE: This report uses the Operations Database instead of the Data Warehouse….in order for it to work, you must create an SRS Data Source for the OpsDB…Kevin Holman has instructions for this here . Here’s a simple report to show...
  • Alert Count by Hour Report

    Very simple report which shows the number of Alerts generated in each hour of a given day….just select the date and the GMT offset and run it.
  • ACS Database Dashboard Report

    Here’s a little report that I put together to get a look at what is going on in the ACS Database. The report will show: Number of Events in the DB Number of days represented in the DB Max Events Per Day Average Events Per Day Partition...