Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » reporting   (RSS)
Friday, July 24, 2009 8:51 PM

Writing reports against RAW Perf data in the Data Warehouse

By default – our generic reports access *aggregated* data in the warehouse… either daily or hourly.  These contain information like number of data points, avg, min, max, and std. deviation data.  However, sometimes users will want access to
Posted by kevinhol | 0 Comments
Filed under: ,
Thursday, June 11, 2009 5:48 AM

Outages and Maintenance Report

This is a little report I put together on request. This report will query the data warehouse, and show all the outages, and maintenance, for objects in specific groups. The outages look at all the “Failed to Connect to Computer” alerts, and list the start
Posted by kevinhol | 9 Comments
Filed under: , ,

Attachment(s): Outage and Maintenance Report.zip
Friday, June 05, 2009 6:59 AM

Maintenance mode – tying the text of the category to the database

I havent seen this discussed before – so I figured I would post this. In the OpsDB and DWDB – we keep some tables names MaintenanceMode and MaintenanceModeHistory. When you place an object into maintenance mode – we will log a row in the database for
Posted by kevinhol | 0 Comments
Filed under: , ,
Wednesday, April 01, 2009 4:22 PM

Running reports – how can I run historical reports on agents that have been decommissioned?

  When we delete an agent from monitoring, we do NOT delete the agent data from the Data Warehouse – by design of course.   However – when running a report, the deleted agent was not showing up.  For instance – I am running the Windows
Posted by kevinhol | 0 Comments
Filed under:
Friday, November 07, 2008 10:14 PM

A cool way to use a web page view in the console - run a report!

Here is a unique way to use web page views in the OpsMgr console. You can create a web page view in the Ops Console for pretty much any HTML - whether local to your hard drive - or a real web page. When you run an SRS based report, you can drop this link
Posted by kevinhol | 1 Comments
Filed under: ,
Monday, October 27, 2008 5:59 PM

How many consoles are connected to my RMS?

This discussion comes up quite a bit. There are a couple ways to track this data....  even to alert us if it breaches a threshold.   One way to look at the number of connected consoles, is to examine the number of users that are connected to
Posted by kevinhol | 0 Comments
Filed under: ,
Wednesday, September 03, 2008 10:46 PM

Using OpsMgr to see which servers have not been logged on to via RDP

This came up in a discussion group.... and while it maybe not be all that interesting of a topic.... it is interesting to see the kinds of reports you can write with OpsMgr and look for unique scenarios.   The question was - "How can I run a
Posted by kevinhol | 7 Comments
Filed under: ,
Monday, July 21, 2008 10:22 PM

Auditing on Alerts from the Data Warehouse

Do you want auditing information on how many alerts are being closed or modified by your OpsMgr users? You can use the following queries to get this information from the data warehouse, and I have attached some reports below as well: To get all raw alert
Posted by kevinhol | 11 Comments
Filed under:

Attachment(s): Alert_Reports.zip
Tuesday, July 15, 2008 7:34 PM

The Exchange Server Configuration report doesn't return any data

I figured out why - and instead of just posting about the workaround... I thought I'd take a moment and post on the process I used to determine the how and the why: When you run the "Exchange Configuration Report" per the guide, you are supposed to add
Posted by kevinhol | 1 Comments
Filed under: ,
Friday, June 27, 2008 11:11 PM

A report to show all agents missing a specific hotfix

This is a continuation of my previous post on determining which agents are missing a hot-fix: How do I know which hotfixes have been applied to which agents- I wrote up a report that allows you to paste in a KB article number into the report as a parameter,
Posted by kevinhol | 12 Comments
Filed under: , ,

Attachment(s): Agents_Missing_Hotfix_Report.rdl
Friday, June 27, 2008 10:39 PM

Which servers are DOWN in my company, and which just have a heartbeat failure, RIGHT NOW?

          In OpsMgr 2007, when a agent experiences a heartbeat failure, several things happen.  There are diagnostics, and possibly recoveries that are run.  Alerts, and possibly notifications go out. But what happens
Posted by kevinhol | 11 Comments
Attachment(s): Servers_Down_Report.rdl
Friday, June 27, 2008 10:04 PM

Agent Proxy alerts - finding the right machine to enable agent proxy on using a custom report

Certain types of agents need the agent proxy setting enabled.  These are documented in various guides... such as Exchange Active Directory, Cluster nodes, etc... However, sometimes, we still get alerts that Agent Proxy needs to be enabled for a HealthService. 
Posted by kevinhol | 8 Comments
Filed under: ,

Attachment(s): HealthService_Agent_Proxy_GUID_report.rdl
Friday, June 27, 2008 9:39 PM

Creating a new data source for reporting against the Operational Database

I am going to be publishing several reports over the next few months, that query the Operational Database instead of the Data warehouse.  We will use these reports for getting all sorts of administrative information... which will allow us to get
Posted by kevinhol | 9 Comments
Filed under:
Thursday, June 26, 2008 8:37 PM

AD Role Holders Report - how to get data

The "AD Role Holders" report has some incorrect description information on how to run the report. If you follow the instructions... adding the "Active Directory Domain Controller Computer Role" you will get no data returned. This will be fixed in an upcoming
Posted by kevinhol | 0 Comments
Filed under:
Wednesday, June 25, 2008 10:01 PM

When searching for objects to include in reports - the results are limited to 500 objects

Keep this in mind when searching for an object when creating a report.  If you don't give very specific search criteria... or if you just select "Add Object" then select "Search" with no criteria.... the result set is limited
Posted by kevinhol | 0 Comments
Filed under:
More Posts Next page »
 
Page view tracker