Solved

Creating SLA views in SCOM 2012

Posted on 2013-11-05
24
1,922 Views
Last Modified: 2013-11-10
Dear Experts.

i have an outstanding issue with my new SCOM 2012 organization.

im truying to create an SLA view to monitor a group of three servers as in general OS health to show which of the servers are up or down.
im wondering how this could be done.
best regards

Arghos.
0
Comment
Question by:arghosrho
  • 12
  • 12
24 Comments
 
LVL 8

Expert Comment

by:Leon Taljaard
ID: 39626380
Hi

There isn't a up/down view per say, more of a "availability" which could be a specific component of the server or the server as a whole.

you might want to take a look at getting the free Opslogix Ping MP found here http://www.opslogix.com/download-ping-management-pack and then maybe specify the ping status monitor in your SLA criteria for those servers.

Goodluck
0
 

Author Comment

by:arghosrho
ID: 39627003
i will download the MP and il let you know how it turns out. as the final goal is to show that server group in an SLA and when something goes wrong the SLA circle turns red. that is what my employer want to see,
a second question on the side.
do u have any suggestion on how to do that without the SLA view.
showing a group of servers in a visualization and when any of the servers goes down a red light goes on.? sounds simple but this is what my employer want.
0
 
LVL 8

Expert Comment

by:Leon Taljaard
ID: 39627733
Hi

What you could do is create a "dashboard" with SSRS report and have it update/refresh the report every 5 min or more depending on what is required or you could create a PowerView/PowerPivot sheet in Excel and connect to your DB and use a query as below.

SELECT     BaseManagedEntity.DisplayName as 'Server Name'
,BaseManagedEntity.Name as 'IP Address',
 State.HealthState
FROM         Monitor AS m INNER JOIN
                      LocalizedText AS LT ON LT.ElementName = m.MonitorName INNER JOIN
                      State ON m.MonitorId = State.MonitorId INNER JOIN
                      BaseManagedEntity ON State.BaseManagedEntityId = BaseManagedEntity.BaseManagedEntityId
WHERE     (LT.LTValue = 'Target Host Ping Check')

Open in new window


You will notice I used the 'Target Host Ping Check' which is the monitor that comes with that Ping MP that I told you about earlier, you can then also filter the query further to only the server names you need to see, then in SSRS or Excel you can create indicators for the "healthstate" value 1 being healthy and 3 being critical and it would change colours like a traffic light :)

Below is a view of my output which I would then use to create the graphic view from

Ping State Query
So there are many other ways you can use the data from the SCOM db to present it in another system, even creating a BI dashboard with Microsoft BI possibly.

This has been our requirement as the default views are a little restricted for our environment so we have created many like these.

Hope this helps
0
 

Author Comment

by:arghosrho
ID: 39627994
well the thing is we need a simple webview to show that employing excel isnt exactly what we want.
but id like to get more information about the SSRS reports in a dhasboardview. can u please give me some examples on how to do that.
i already have created a group with 3 servers so how can i do that?
excuse me if i come forward like a noob
0
 
LVL 8

Expert Comment

by:Leon Taljaard
ID: 39628213
Hi

Nothing wrong with asking for help on something you haven't tried or implemented so never worry about sounding like a noob :)

You could look at the following to get you started http://www.systemcentercentral.com/creating-a-custom-report-for-scom-2007-r2-with-sql-2008-reporting-in-microsoft-visual-studio-2008/

This is using VS 2008, you could then instead of inserting a matrix you could insert a indicator instead and then set your indicators accordingly.

You can also use the above link idea to create other different views/reports, you would then take the .rdl file and upload it to your SCOM report server http://"SCOMreportserver"/reports and just place it into a folder or create a custom folder and then name the report accordingly.

I have attached a example .rdl that you could edit in report editor or in VS 2008

You will need to change the data source to your own sql server name as well as the DB name of your datawarehouse db, also you would have to change the group name to your own created group.

Here are some screen shots

Datasource to your SQL server connection and DB name

DW DB name
You can then customize this report to your own configuration as well as add an auto refresh into the report.

Hope this will help and sure its more info, you will also see the new updated query if you right click dataset1 and click query, which will include the group name input as well as the spot where you will change the DW name to your production DW name.

When creating the data source connection, it will connect to your operationsmanager db not the DW.

Let me know if you don't understand anything

Thanks
SCOM-Indicator-Example.rdl
0
 

Author Comment

by:arghosrho
ID: 39629638
i think i got the soul of it.
but well let me get e bit deaper on the goal.
my employer want a webpage to show the state, and what they want is something really simplistic so for example. we have a group of servers server1, server2 and server three.
what is needed is that a webpage should appear that shows green as long as these three servers are online and working as soon as any of the servers goes down this webpage should show a red light.
0
 
LVL 8

Expert Comment

by:Leon Taljaard
ID: 39629660
That is exactly in the .rdl file I attached, it is simple small report that can be customized for your needs, it can be displayed on a LCD screen and will show you a green or red depending on the state of the server being up or down.

The previous post will give you all that you need to get that going.

Nothing else to do :)
0
 

Author Comment

by:arghosrho
ID: 39629662
do we have to have the SCom reporting for this? as this is not installed.
0
 
LVL 8

Expert Comment

by:Leon Taljaard
ID: 39629676
well you have the OperationsManager and OperationsManagerDW database don't you ? so this would be directly running a query on both from a SSRS report.
0
 

Author Comment

by:arghosrho
ID: 39629772
can u assit me a bit in getting the free MP to work and include its result in a SLA view? i wanna start with this and then go all the way to the custom reports.
0
 
LVL 8

Expert Comment

by:Leon Taljaard
ID: 39629776
Well all you need to do is download the MP from the site I gave you already and then there will be a config document that is easy to read on how to setup the hosts (ping from) and the targets (servers to ping), do you have SCOM 2007 or SCOM 2012 ?

Once you have that going then let me know then I will try help you with the SLA view.

If you get stuck with the Ping MP let me know.
0
 

Author Comment

by:arghosrho
ID: 39629778
i have scom 2012. and i dont seem to find the configuration document attached.
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 8

Expert Comment

by:Leon Taljaard
ID: 39629783
the config document wasn't attached, but when you go to the link and download the MP, there is a PDF document.

http://www.opslogix.com/download-ping-management-pack

The files mp files as well as the document will be in the download.
0
 

Author Comment

by:arghosrho
ID: 39629815
good ive done the basic configuration and i can some results.
but how am i supposed to translate that to an SLA. i still get a grey result.
i also want to make diffrent sals to represent diffrent server.
0
 
LVL 8

Expert Comment

by:Leon Taljaard
ID: 39629883
So you have done your configuration of the Hosts (Ping from) and targets (to ping) ? the first time the MP is imported it will not show green results as it will still be processed by SCOM and discoveries run. If your agent is grey then the management service isn't running on them possibly.

Also there seems to be a know issue even with SCOM 2012 SP1 where if you had to open the web console the SLA view would show green but in the console itself it will show grey, what you could also try do is change ur SLA value from 99 % to 98 % or lower.

If you want more SLA views for each server group you would either have to create a SLA for each server group which are all the same but just the groups would be different or you would have to create a separate SLA dashboard for each.

In my opinion the SLA view isn't the greatest
0
 

Author Comment

by:arghosrho
ID: 39629884
im monitoring a couple of servers with the MP now, and they are all fine and green. i just dont know how to put this output to an SLA
0
 

Author Comment

by:arghosrho
ID: 39629890
well what im missing is how to get the information from this MP to a SLA ? i just cant get it to work
the mp shows healthy serves the sla shows nothing at all.
0
 
LVL 8

Expert Comment

by:Leon Taljaard
ID: 39629912
Well you would go into your Authoring TAB, click on Service Level Tracking and then create a new SLA, name it whatever you want.

Here are some screen shots attached, you would then just create a service level objective for each group targeted to each group, then create your own SLA dashboard in the Monitoring view and add your newly created SLA.
SLA1.PNG
SLA2.PNG
SLA3.PNG
0
 

Author Comment

by:arghosrho
ID: 39629924
does the choice of managment pack in the first screen make a diffrence?
0
 
LVL 8

Expert Comment

by:Leon Taljaard
ID: 39629927
no, you choose the custom MP that you would want to put it into, obviously not the default MP or any other sealed MP, create your own.
0
 

Author Comment

by:arghosrho
ID: 39629941
ok i managed to get it to work so far.
now i have 8 servers in the MP can i actually make 2 SLA views each to show 4 servers of these 8?
0
 
LVL 8

Expert Comment

by:Leon Taljaard
ID: 39629946
yes, but you would have to create a group for one set of 4 and another group for the other set of 4 and then just use the one SLA created but then add 2 Monitor SLO's each targeted to each group.
0
 

Author Comment

by:arghosrho
ID: 39629961
groups you mean as in authoring groups and then creating a group with certain members?
in case yes.

4 of these server are already in a group. in the members of the group what i choose from all the availble options? as creating a group requires choosing certain options int he members pane.
i know i exhausted you but im really in a bad need of getting this right
0
 
LVL 8

Accepted Solution

by:
Leon Taljaard earned 500 total points
ID: 39629969
Yes so you would then create another group in "Authoring" with the other 4 servers in and then just create 2 monitor slo's



so you would have 2 listed as in the above example which has one, but each would just be targeted to each group.

Make sense ?
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
In this article, I will show you HOW TO: Perform a Physical to Virtual (P2V) Conversion the easy way from a computer backup (image).
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now