tag:blogger.com,1999:blog-5536481848801330672.post4332763214208003663..comments2024-03-29T05:26:16.848+00:00Comments on Microsoft System Center Suite: SCOM Distributed App Health DashboardSteve Beaumonthttp://www.blogger.com/profile/01656851477395070464noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-5536481848801330672.post-27051674686536454872012-09-26T15:42:18.356+01:002012-09-26T15:42:18.356+01:00tI love your guys input on this. I am currently wo...tI love your guys input on this. I am currently working on a project to make a dash similar to yours with SCOM 2007 R2. I am having a problem though which is puzzling me. I am getting multiple healthstate for each distributed application i add to the query. One that i know is critical, i added and it shows in the preview data window 3x and heathstate 0,1,3.<br /><br />Any idea why?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5536481848801330672.post-5370657778956821582011-07-07T13:50:52.673+01:002011-07-07T13:50:52.673+01:00I don't mind at all Steve, I appreciate the co...I don't mind at all Steve, I appreciate the comments and thanks again for your original post!<br /><br />Keep up the good work!Kevin Greenehttps://www.blogger.com/profile/09485844569754734795noreply@blogger.comtag:blogger.com,1999:blog-5536481848801330672.post-83932636112707387932011-07-07T13:38:56.522+01:002011-07-07T13:38:56.522+01:00I don't mind at all Kevin, and I must say, wha...I don't mind at all Kevin, and I must say, what an amazing set of posts you've done!!<br /><br />I'll create a new post to reference yours if that's ok?<br /><br />Cheers,<br />SBSteve Beaumonthttps://www.blogger.com/profile/01656851477395070464noreply@blogger.comtag:blogger.com,1999:blog-5536481848801330672.post-51900648668948644422011-07-06T15:52:22.936+01:002011-07-06T15:52:22.936+01:00Hi Steve,
I liked your solution that much that I ...Hi Steve,<br /><br />I liked your solution that much that I put together my own SCOM dashboarding series of blog posts.<br /><br />http://kevingreeneitblog.blogspot.com/2011/07/scom-dashboards-intro.html<br /><br />I've given you the credit of course for the Distributed Application Dashboard and also linked to your blog.<br /><br />Hope you don't mind!<br /><br />Kev.Kevin Greenehttps://www.blogger.com/profile/09485844569754734795noreply@blogger.comtag:blogger.com,1999:blog-5536481848801330672.post-72549221969540628252011-06-02T08:49:36.953+01:002011-06-02T08:49:36.953+01:00Hi Kevin,
I was wondering what was wrong there for...Hi Kevin,<br />I was wondering what was wrong there for a while, but then I twigged too.<br /><br />As I mentioned in the post, when you're adding the SQL to the dashboard, you need to chop the case statements out so that the dashboard has the numerical values to work with, sorry, should have put that bit in bold!<br /><br />Glad you liked it btw!<br /><br />Cheers,<br />SBSteve Beaumonthttps://www.blogger.com/profile/01656851477395070464noreply@blogger.comtag:blogger.com,1999:blog-5536481848801330672.post-25727988370271849722011-06-01T17:04:44.299+01:002011-06-01T17:04:44.299+01:00Hi again Steve,
I've just managed to figure i...Hi again Steve,<br /><br />I've just managed to figure it out so no need to come back to me with the solution. I've posted it below for anyone else that is reading this:<br /><br />SELECT distinct BaseManagedEntity.DisplayName, State.HealthState<br /> FROM State INNER JOIN<br /> BaseManagedEntity ON State.BaseManagedEntityId = BaseManagedEntity.BaseManagedEntityId<br /> where (BaseManagedEntity.FullName like 'Service_%' <br />or BaseManagedEntity.DisplayName = 'Active Directory Topology Root' <br />or BaseManagedEntity.DisplayName = 'Certificate Services' <br />or BaseManagedEntity.DisplayName = 'ConfigMgr 2007 Site Hierarchy' <br />or BaseManagedEntity.DisplayName = 'Operations Manager Management Group')<br /> and BaseManagedEntity.Name is NULL <br />or (BaseManagedEntity.DisplayName = 'Exchange Service' and State.HealthState <> '0')<br /><br />Thanks again for the excellent post,<br /><br />Kevin.Kevin Greenehttps://www.blogger.com/profile/09485844569754734795noreply@blogger.comtag:blogger.com,1999:blog-5536481848801330672.post-7299970578114352152011-06-01T16:42:32.308+01:002011-06-01T16:42:32.308+01:00Hi Steve,
I'm lovin this post on SCOM DA dash...Hi Steve,<br /><br />I'm lovin this post on SCOM DA dashboarding! I've done quite a bit with the SCCM and SCSM dashboards within SCOM for my clients but didn't have the SQL 'Kung Fu' to tie in DA's into it until I saw your blog post today.<br /><br />I am trying to get the scorecard working the way you have in your diagram but it keeps giving me an error of :<br /><br />'There are no numeric data in the defined query to show on a graph'<br /><br />I'm sure I am missing something simple but if you could provide me with more information or even the SQL query that you used for the scorecard, I'd be much obliged.<br /><br />Thanks in advance,<br /><br />Kevin!Kevin Greenehttps://www.blogger.com/profile/09485844569754734795noreply@blogger.com