tag:blogger.com,1999:blog-1807410337729170157.post4741470440705068702..comments2024-02-18T22:16:56.032-08:00Comments on System Center 2012 Notes From the Field: Setup a Disk Report in SCOM 2012 (Part-3)Dave Murphyhttp://www.blogger.com/profile/14038170973560613332noreply@blogger.comBlogger12125tag:blogger.com,1999:blog-1807410337729170157.post-79982628765262218812015-11-11T06:11:32.002-08:002015-11-11T06:11:32.002-08:00I agree with Dave. To teach to fish, is better tha...I agree with Dave. To teach to fish, is better than just giving away a fish.Patrick's Bloggerhttps://www.blogger.com/profile/12711650981716597676noreply@blogger.comtag:blogger.com,1999:blog-1807410337729170157.post-77134805942277796022013-12-07T09:48:05.358-08:002013-12-07T09:48:05.358-08:00thanks a lot for the excellent report dave, could ...thanks a lot for the excellent report dave, could you please help us to configure memory/CPU utilization report. thanks a ton in advance <br /><br />CheersUnknownhttps://www.blogger.com/profile/17304158941574985017noreply@blogger.comtag:blogger.com,1999:blog-1807410337729170157.post-87040529561350782392013-11-26T15:27:32.526-08:002013-11-26T15:27:32.526-08:00Also, I do consulting work. Would be more than hap...Also, I do consulting work. Would be more than happy to dial in and assist.Dave Murphyhttps://www.blogger.com/profile/14038170973560613332noreply@blogger.comtag:blogger.com,1999:blog-1807410337729170157.post-54484330898276797472013-11-26T10:06:16.854-08:002013-11-26T10:06:16.854-08:00Haven't had issue yet, beyond one or two serve...Haven't had issue yet, beyond one or two servers that throw a fit now and then. Seems a bit odd that all your 2008 and 2012 servers are missing. Double check the WMI query to ensure you're able to pull those stats from one or two of those servers. I typically use scriptomatic 2.0 to perform those queries and check on the health of WMI.Dave Murphyhttps://www.blogger.com/profile/14038170973560613332noreply@blogger.comtag:blogger.com,1999:blog-1807410337729170157.post-56843803993083689632013-11-26T07:19:15.456-08:002013-11-26T07:19:15.456-08:00Dave,
First of all thank you for all these three ...Dave,<br /><br />First of all thank you for all these three articles. It was great and easy to follow. I was just wondering if you had any problems with Win 2008 and Win 2012 counters reporting total disk space. Mine works for Win 2003 and reports disk size but when it comes to OS higher than 2003, they are all 0.00 GB.Tikihttps://www.blogger.com/profile/14951795834175198922noreply@blogger.comtag:blogger.com,1999:blog-1807410337729170157.post-48276681335522101422013-11-02T04:01:48.758-07:002013-11-02T04:01:48.758-07:00Hopefully that makes sense. The difference in expe...Hopefully that makes sense. The difference in experience you're having, versus what I appear to have is that I've had to perform a lot of wmi troubleshooting on the back end. It took a good week or so to iron out all those issues. That is where the wmi posts came from that I did earlier on. Many of the WMI classes get locked down by .NET or some other update and have to be opened back up and there are about half a dozen WMI memory leak hotfixes as well, which I just posted an article about in troubleshooting gray agents, which is another reason data points could be missing.Dave Murphyhttps://www.blogger.com/profile/14038170973560613332noreply@blogger.comtag:blogger.com,1999:blog-1807410337729170157.post-68217917694903306752013-11-02T03:58:19.986-07:002013-11-02T03:58:19.986-07:00Correct, the date is stored in UTC time and is som...Correct, the date is stored in UTC time and is something I've played around with in other reports. I have encountered issues with the NULL values before, typically when there are issues with WMI or system performance at either the SCOM or individual host level. At a basic level, that NULL value can mean SCOM wasn't able to connect and extract the necessary value for that particular time slice, often due to performance issues, but could be WMI isn't doing well or the system is overloaded, leading to a blank or NULL field. That was one of the reasons I settled in initially on the pivot function, because it averages out several time slices in a short period to come up with the value, so if one or two are missing, it shouldn't affect the outcome too much. Consider that if you filter on IS NOT NULL, you may be passing up an opportunity to find machines that aren't reporting health state consistently and that may require additional tuning or are having performance problems. But yes, I have encountered issues with NULL values.Dave Murphyhttps://www.blogger.com/profile/14038170973560613332noreply@blogger.comtag:blogger.com,1999:blog-1807410337729170157.post-11549549226261991762013-11-01T20:41:57.850-07:002013-11-01T20:41:57.850-07:00Dave, I'm interested to hear if you think the...Dave, I'm interested to hear if you think the way I made it work has any side impact. I changed the DataSet query from GETDATE() to GETUTCDATE() because I believe that is how Operations Manager stores the information. I also did the total - fee space in the SQL query instead of in the expression. Lastly, the final piece that made the largest difference is I added [Total Disk Space] IS NOT NULL. It seemed some of the values were NULL and that is why I would get 0.00 but there was always one filled out so this allowed Total Space to never be 0.00<br /><br />I'm really interested in why I ran into these issues if you didn't.Anonymoushttps://www.blogger.com/profile/02006512777889958227noreply@blogger.comtag:blogger.com,1999:blog-1807410337729170157.post-67634773839497823432013-11-01T14:00:04.604-07:002013-11-01T14:00:04.604-07:00Why is your Total (GB) and Used (GB) the same numb...Why is your Total (GB) and Used (GB) the same number? I have an issue where for some I'm seeing a Total (GB) of 0.00 and where it does work my Users is like yours the same as my total?Anonymoushttps://www.blogger.com/profile/02006512777889958227noreply@blogger.comtag:blogger.com,1999:blog-1807410337729170157.post-55460727670101145332013-05-14T16:01:09.397-07:002013-05-14T16:01:09.397-07:00I have thought about it. My internal conflict is t...I have thought about it. My internal conflict is that if I publish the file, a lot of folks will think it works out of the box without understanding the background logic going on and that there are dependencies driving the report that have to be setup. Dave Murphyhttps://www.blogger.com/profile/14038170973560613332noreply@blogger.comtag:blogger.com,1999:blog-1807410337729170157.post-2532676669461909032013-05-04T18:54:29.032-07:002013-05-04T18:54:29.032-07:00Dave - it would a temendous help to the community ...Dave - it would a temendous help to the community provide the report for downlaod.<br /><br />Thoughts?Lazerushttps://www.blogger.com/profile/02065777131056779751noreply@blogger.comtag:blogger.com,1999:blog-1807410337729170157.post-61291323555515834522013-01-24T03:38:26.844-08:002013-01-24T03:38:26.844-08:00Hi Dave,
Would it be possible to change the sql c...Hi Dave,<br /><br />Would it be possible to change the sql code to work out the percentage increase if the value was taken at 12pm the day before and compare to the value 12pm today?Anonymoushttps://www.blogger.com/profile/18130581137503099724noreply@blogger.com