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 Service Message: Report Server Windows Service (instancename) cannot…

7

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…

32

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…

20

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, but they have wrapped a lot of the most common queries into a set…

1

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 reports – check our Ryan Andorfer’s site “Living with SCOM”.  He has a picture filled walkthrough…

1

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.  This…

89

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 warehouse – and you can see it…

0

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 time…

25

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 against this…

2

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 report….

0

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…

1

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…

11

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…

7

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 from:…

12

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,…

1

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…

18

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?  What can I do to "spot check" agents with issues?…

21

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 doesn’t tell us which agent needs this enabled!!! Here…

11

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 window all the time.  …

12

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:   Instead – you need to add…

0