Survey 2014: How do you use SCOM reporting? – Results

I started this post with the very simple thing – copied and pasted title from my previous post. And immediately got the very strange feeling of having a huge debt. Not a financial of course (which I try to avoid), by blogging and writing debt. It is weird and ridiculous to publish a survey result […]
Continue reading…

 

How to add a good-looking description for SCOM Report?

Yesterday I was asked a question: I would like to enter a description for a published SCOM report that is longer than the 512 character limit. I see that the Veeam reports have very detailed and long descriptions. Do you know how I can accomplish this? Here is the answer: to get the long, detailed […]
Continue reading…

 

How to configure SQL Server 2012 Data Tools to support OpsMgr reports development

This is just a short note on how to configure SQL Server 2012 Data Tools to support OpsMgr reports development. Note: Since I do not use Dundas Chart any more, I haven’t tried to install it. SSRS native chart control is the prefered option in my opinion. However, if you still need it, you may […]
Continue reading…

 

Designing the perfect SCOM report – my workflow (Part 3/3)

In previous parts we discussed how to get ready for SCOM reports development and how to plan the perfect report. Now we’re ready to rock.
If you have done your homework, the implementation will be pretty much straightforward process , the speed will depend on your technical skills only. My implementation workflow usually includes: SQL Server stored procedure(s) for data retrieval; report definition (RDL); report parameter block (RPDL); Injection of stored procedures, report definition and parameter block into management pack […]
Continue reading…

 

Designing the perfect SCOM report – my workflow (Part 2/3)

Plan.
There are so many things that can be described in this part. There is no straightforward approach in software design. It’s all about finding the right balance between many factors. However, if you’re writing SCOM report for yourself or for your fellow IT Pro sitting at the desk next to you, don’t worry – skip this part, get your vision and do it. If this is not the case, you’ll need to invest lot of time (sometimes even more than implementation takes) into planning […]
Continue reading…

 

Designing the perfect SCOM report – my workflow (Part 1/3)

It was more than four years ago when I created my first SCOM report. I have authored several dozens since that. Some of them were great, most were just good. Many people asked me how do I do that and assumed that report authoring for SCOM is something really complex. In fact, it is not. At least it is not more difficult than writing non-SCOM report or your own resume. The only thing one need to author good SCOM report is to understand the process and follow it […]
Continue reading…

 

GRL Tools: Usage instructions and download link

GRLTools are used to generate a Management Pack containing a set of linked performance reports based on Veeam eGRL performance and top/bottom reports. Please read this post carefully before using these tools. Download link is at the bottom of the post. Prerequisites GRLTools require OpsMgr 2007 R2 or 2012 or 2012 SP1 console to be […]
Continue reading…

 

OpsMgr data warehouse: some things to consider

If you plan to use data from OpsMgr DW, you should be aware that there is a number of some specific points you should consider when developing your data retrieval strategy. Here are some of them: Aggregation. Applies to: State and Performance data. OpsMgr DW doesn’t store raw data for a long period of time. […]
Continue reading…

 

How many performance collection rules are there in MP? (#scom #sysctr #opsmgr)

It was a hot day here in Veeam Management Pack R&D Teeam, we’re getting closer and closer to feature complete deadline and code freeze. I’ve spent few days on reviewing performance reports MP and ended with rebuilding it from the scratch  – 36 reports, 175 performance collection rules, 853 report-rule links. When I was done, […]
Continue reading…