Kevin Holman's System Center 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 UseAre you interested in having a dedicated engineer that will be your Mic

Browse by Tags

Related Posts
  • Blog Post: 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 and end time of the outage, based on the...
  • Blog Post: 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 Server 2003 Operating System – Operating System Performance...
  • Blog Post: 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 data from the data warehouse to build reports...
  • Blog Post: Moving the Data Warehouse Database and Reporting server to new hardware–my experience

    The time has come to move my Warehouse Database and OpsMgr Reporting Server role to a new server in my lab.  Today – both roles are installed on a single server (named OMDW).  This server is running Windows Server 2008 SP2 x86, and SQL 2008 SP1 DB engine and SQL Reporting (32bit to match the...
  • Blog Post: 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 objects of type "Exchange 2003 Role". Well, if...
  • Blog Post: Understanding and modifying Data Warehouse retention and grooming

    You will likely find that the default retention in the OpsMgr data warehouse will need to be adjusted for your environment.  I often find customers are reluctant to adjust these – because they don't know what they want to keep.  So – they assume the defaults are good – and they just keep EVERYTHING...
  • Blog Post: The 31552 event, or “why is my data warehouse server consuming so much CPU?”

    A very common customer scenario – is where all of a sudden you start getting these 31552 events on the RMS, every 10 minutes. This drives a monitor state and generates an alert when the monitor goes red. However – most of the time my experience is that this alert gets “ missed ” in all the other alerts...
  • Blog Post: 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 data without having to launch a SQL query analyzer...
  • Blog Post: 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 this object.  You could potentially write reports...
  • Blog Post: 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, and then it will show all agents that are potentially...
  • Blog Post: 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.  The problem is... the Alert often...
  • Blog Post: 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 into a web page view. Here is an example: ...
  • Blog Post: 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 ADMP update... but in the meantime: ...
  • Blog Post: Why do my reports show no data?

    Often times.... I hear about reports not showing any data. Especially ad-hoc performance reports. When we run a report – we have to run the report against the same object type (class) that the data was collected from. The problem is – “how do you know what object type that was???” This is a common...
  • Blog Post: Do you use ACS? You have GOT to check out these reports!

    Jimmy Harper has written some really cool reports for making ACS data more useful, and these can be used as templates for creating your own similar reports.  Get them here: http://blogs.technet.com/jimmyharper/archive/2009/12/10/some-custom-acs-reports.aspx   For a primer on writing your own...
  • Blog Post: 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 report - and see all my servers that have NOT been...
  • Blog Post: Charts not showing up in scheduled reports?

          There is an issue where scheduled reports will email the report, however, the graphic/chart will not show up in the attachment. Additionally, on the reporting server application event log – you will see the following event: Level: Error EventID: 108 Source: Report Server Windows...
  • Blog Post: 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 if my Operations team misses on of these alerts...
  • Blog Post: 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 the RAW, individual data points. This is kept in the...
  • Blog Post: System Center Central – some really cool OpsMgr Health reports available

    System Center Central has published some really good reports – which will help you keep up with the health of your environment. http://www.systemcentercentral.com/BlogDetails/tabid/143/IndexID/73350/Default.aspx   Many of these are based on queries published on my blog and other blogs in the community...
  • Blog Post: 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 to 500 objects returned.  Therefore - if the...
  • Blog Post: 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 the SDK service.  We can do this via powershell...