tag:blogger.com,1999:blog-18074103377291701572024-03-12T19:00:01.150-07:00System Center 2012 Notes From the FieldDave Murphyhttp://www.blogger.com/profile/14038170973560613332noreply@blogger.comBlogger43125tag:blogger.com,1999:blog-1807410337729170157.post-27166375001011488912015-08-18T08:44:00.001-07:002015-08-18T08:44:56.613-07:00Finding a DNS Zone Creation DateNot SCOM related, but this is pretty much the only place I dump things I need to remember, and maybe you'll find it useful.<br />
<br />
Was in my Windows Server DNS console this morning and I noticed some odd domains listed. I don't remember seeing them before and wanted to see when they were created, to make sure folks weren't randomly adding new zones.<br />
<br />
<ul>
<li>Fire up <strong>adsiedit.msc</strong> on a domain controller.</li>
<li>Choose <strong>Connect to</strong></li>
<li>Under <strong>Connection Point</strong>, choose <strong>Select or type a Distinguished Name or Naming Context</strong></li>
<li>Enter <strong>DC=DomainDnsZones,DC=<second level DNS>,DC=<top level DNS></strong></li>
<ul>
<li>E.G. dc=DomainDnsZones,DC=contoso,DC=corp</li>
</ul>
<li>Next, select <strong>CN=MicrosoftDNS</strong></li>
<li>In the right hand pane, look for the zone in question, reverse or forward</li>
<li><strong>Right-click</strong> on the folder and select <strong>Properties</strong></li>
<li>Browse to the <strong>whenCreated</strong> properties to find out when the zone was added to the system</li>
</ul>
Dave Murphyhttp://www.blogger.com/profile/14038170973560613332noreply@blogger.com1tag:blogger.com,1999:blog-1807410337729170157.post-42049135252682049242015-07-30T13:18:00.000-07:002015-07-30T13:19:35.970-07:00SCOM - Check for and alert on low space on mount points - Part 1I have a number of sites still running Exchange 2010 and because of the buggy management pack there is often not a way to alert on the drive space of an exchange server mount point because sites have removed the management pack.<br />
<br />
In searching for a solution, I came across a nice article that helped get me started here:<br />
<br />
<a href="http://www.powershellneedfulthings.com/?p=36">http://www.powershellneedfulthings.com/?p=36</a><br />
<br />
I took that script and added some additional information so that I could generate both an error condition on low drive space as well as a recovery alert so SCOM knew when to close the alert itself.<br />
<br />
In order for this script to run cleanly, you first need to run the following powershell command on any server you want to run mout-point checks on:<br />
<br />
<span style="font-family: "Calibri","sans-serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">new-eventlog
-LogName System -Source OpsHealthScript</span><br />
<span style="font-family: "Calibri","sans-serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"></span><br />
<span style="font-family: "Calibri","sans-serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Next, schedule the following script to run periodically on your server via task scheduler or whatever program you might use to run scripts on a recurring basis.</span><br />
<span style="font-family: "Calibri","sans-serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"></span><br />
<span style="font-family: "Calibri","sans-serif"; font-size: xx-small; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">$TotalGB = @{Name="Capacity(GB)";expression={[math]::round(($_.Capacity/ 1073741824),2)}}<br />$FreeGB = @{Name="FreeSpace(GB)";expression={[math]::round(($_.FreeSpace / 1073741824),2)}}<br />$FreePerc = @{Name="Free(%)";expression={[math]::round(((($_.FreeSpace / 1073741824)/($_.Capacity / 1073741824)) * 100),0)}}<br />$Check = @{Name="Failed";expression={[math]::round(((($_.FreeSpace / 1073741824)/($_.Capacity / 1073741824)) * 100),0) -lt 10}}</span><br />
<span style="font-family: "Calibri","sans-serif"; font-size: xx-small; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"></span><br />
<span style="font-family: "Calibri","sans-serif"; font-size: xx-small; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"> function get-mountpoints {</span><br />
<span style="font-family: "Calibri","sans-serif"; font-size: xx-small; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"> $global:volumes = Get-WmiObject -computer $server win32_volume | Where-object {$_.DriveLetter -eq $null}</span><br />
<span style="font-family: "Calibri","sans-serif"; font-size: xx-small; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"> $global:volumes | Select SystemName, Label, Capacity, FreeSpace, $Check | Format-Table -AutoSize</span><br />
<span style="font-family: "Calibri","sans-serif"; font-size: xx-small; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"> }</span><br />
<span style="font-family: "Calibri","sans-serif"; font-size: xx-small; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"></span><br />
<span style="font-family: "Calibri","sans-serif"; font-size: xx-small; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">$servers = [system.environment]::MachineName</span><br />
<span style="font-family: "Calibri","sans-serif"; font-size: xx-small; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">foreach ($server in $servers){<br />get-mountpoints<br />}</span><br />
<span style="font-family: "Calibri","sans-serif"; font-size: xx-small; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">$Flag = $global:volumes | Select $Check</span><br />
<span style="font-family: "Calibri","sans-serif"; font-size: xx-small; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">If ($Flag -match "True") {<br />Write-EventLog -logname System -source OpsHealthScript -eventID 500 -Entrytype Error -message 'One or more Exchange mount points are below 10% free space.'<br />} </span><br />
<span style="font-family: "Calibri","sans-serif"; font-size: xx-small; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Else {<br />Write-EventLog -logname System -source OpsHealthScript -eventID 800 -Entrytype Information -message 'Exchange mount points are healthy.'<br />}</span><br />
<br />
You can access the file here: <a href="https://drive.google.com/file/d/0B0LvF9h9eDlcNTVHa1ZpNU5jc28/view?usp=sharing" target="_blank">mount-point-space.ps1</a><br />
<br />
Once this is scheduled, you can setup alerting in a couple of ways, one is a simple alert detection within SCOM to detect Error 500 in the system event log, the other is a correlated alert detection so that each alert generated by the script does not create a new alert within SCOM. I'll go over that in additional detail.Dave Murphyhttp://www.blogger.com/profile/14038170973560613332noreply@blogger.com0tag:blogger.com,1999:blog-1807410337729170157.post-40133953921084127682015-03-27T16:53:00.000-07:002015-03-27T16:53:47.887-07:00Exchange Inventory Powershell ScriptNot SCOM related, but I cobbled together a powershell script that gives useful information for your exchange inventory. In particular, I was looking to re-balance my exchange databases and wanted to get the particulars of all my user mailboxes. I find that using using the alias when running some of the move commands is easier. The script will provide you with the following information:<br />
<ul>
<li>Users's display name</li>
<li>Total size of the user's mailbox</li>
<li>The primary SMTP address for the user</li>
<li>The user's alias</li>
<li>The database on which the mailbox is located</li>
</ul>
By tweaking fields in the PSObject section, you can display or remove additional information, so long as that information is part of one of the other calls, like get-recipient or get-mailboxstatistics. As an example, the original script I found did not pull the database information, so I added that field in.<br />
<br />
$(Foreach ($mailbox in Get-recipient -ResultSize Unlimited -RecipientType UserMailbox){<br />$Stat = $mailbox | Get-MailboxStatistics | Select TotalItemSize,ItemCount<br /> New-Object PSObject -Property @{<br /> DisplayName = $mailbox.DisplayName<br /> TotalItemSize = $Stat.TotalItemSize<br /> PrimarySmtpAddress = $mailbox.PrimarySmtpAddress<br /> Alias = $mailbox.Alias<br /> Database = $mailbox.Database}<br />}) | Select DisplayName,TotalItemSize,PrimarySmtpAddress,Alias,Database<br />
<br />
Dave Murphyhttp://www.blogger.com/profile/14038170973560613332noreply@blogger.com0tag:blogger.com,1999:blog-1807410337729170157.post-18046472782295714742015-01-08T16:40:00.000-08:002015-01-08T16:40:38.993-08:00System Center Custom Application MonitoringSometimes, a problem can seem really hard, but turn out to be rather simple if approached from a different perspective. The application team I support has a poorly written application running on a server. This should sound familiar to most system admins out there. <br />
<br />
The application crashed the other day, but none of the windows services actually stopped, nor were there any event log errors to really go off of either. How do we monitor that service then? One option might be the TCP port but nobody seemed to know what that was. Digging into the application, it had a small scripting engine, which allowed us to run some basic scripts.<br />
<br />
The first thought the application team had was, we'll write an event log saying everything is ok, and when that doesn't appear, we want an alert. Well, we can monitor for missing alerts in SCOM, but that seemed like it would be destined for error.<br />
<br />
What we settled on instead was to have the program simply drop a file in the temp directory. It would put the file there every 30 minutes, with the same name. So now what? I created a small and simple batch file that would check for the file, then delete it if it was there. Otherwise, report the file missing and the service stopped.<br />
<br />
IF EXIST C:\TEMP\running.log GOTO Good<br />
EVENTCREATE /T ERROR /ID 333 /L application /d "Custom Application Failed"<br />
:Good<br />
DEL C:\TEMP\running.log /q<br />
<br />
I then set a schedule task to run every 30 minutes to run this batch file. When the file went missing, it would write the error to the event log. From there, just setup an event monitor in System Center to catch and alert on the event.Dave Murphyhttp://www.blogger.com/profile/14038170973560613332noreply@blogger.com0tag:blogger.com,1999:blog-1807410337729170157.post-49699014282543253872015-01-08T16:32:00.000-08:002015-01-08T16:32:20.901-08:00Operations Manager Performance Trending with Excel - No SQL RequiredA powerful tool for administrators is to trend data to troubleshoot performance problems and forecast future resource needs. In the past, I've run SQL queries but needed a way to instruct support staff on a basic means to accomplish the same tasks right from the console. Thankfully, Operations Manager and Excel allow just that.<br />
<br />
Let's get started.<br />
<br />
Fire up the Operations Manager Console to the Monitoring section, then open the Windows Computers view (or any section where you access the computer health view, such as SQL)<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0CrNxm8aq3BP-Pjn9C-HAJMmGywwunTo0pWLjQPxZMCv4LNhXPIBVEOXNixJOL1Cccn7oGuBOJIB3iJPRGUwRUPQt7DE1t6sBzGo-I3UrcwF-qAsV-JYlZz8URBuUMjcicMco4POleWI/s1600/WindowsComputerView.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0CrNxm8aq3BP-Pjn9C-HAJMmGywwunTo0pWLjQPxZMCv4LNhXPIBVEOXNixJOL1Cccn7oGuBOJIB3iJPRGUwRUPQt7DE1t6sBzGo-I3UrcwF-qAsV-JYlZz8URBuUMjcicMco4POleWI/s1600/WindowsComputerView.jpg" /></a></div>
<br />
Find a server you're interested in or simply select one from the list.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKnbg3DDihQr2mce6ZBI3uVspNos1KBFiCP-WmXdGgLNbMfRvh4Cmk-T6dbb4HzVhSrt8PH8yyvOcmumhSHtCk1Lq-WVeitk8sswmhXaCGqAfuL1FiM6V8jQFCtrWk-TR7uzTTNIyBabY/s1600/ScomTrending.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKnbg3DDihQr2mce6ZBI3uVspNos1KBFiCP-WmXdGgLNbMfRvh4Cmk-T6dbb4HzVhSrt8PH8yyvOcmumhSHtCk1Lq-WVeitk8sswmhXaCGqAfuL1FiM6V8jQFCtrWk-TR7uzTTNIyBabY/s1600/ScomTrending.jpg" height="42" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
After selecting the system, select the <strong>Performance View</strong> under the <strong>Navigation</strong> pane of the task panel on the right side of the management console.<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjD3KtPyAF2S2a4r9d-AfMAygVcgMK-2DWlVKFBYPYhBtSb3BosE6WLKJe1mbwb-wMebiyrP9PSVzMRr2OlQElfL2zdTM1Qa2tPld7T5yGHks5lX-h9RIDisR8xrTp-87yQ16mxuRTppag/s1600/PerformanceView.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjD3KtPyAF2S2a4r9d-AfMAygVcgMK-2DWlVKFBYPYhBtSb3BosE6WLKJe1mbwb-wMebiyrP9PSVzMRr2OlQElfL2zdTM1Qa2tPld7T5yGHks5lX-h9RIDisR8xrTp-87yQ16mxuRTppag/s1600/PerformanceView.jpg" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
Once the <strong>Performance View</strong> window comes up, in the <strong>Performance Actions</strong> pane on the right side of the console, change your time frame via <strong>Select Time Range</strong>, selecting a meaningful period, such as two weeks or longer.<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgL5z73gHfjgiAaK4vKQp3g4n-6dHTKPljMZsVXUJ5OnXSZo4IcdqWzJETsB5BqYF2JcSKMMmGKFHzw9O98IKN2gUhfly1LjVArKkFgNDq54IADNJk9ViR8eMBWSVVI5j-kHfxqcYbOt3M/s1600/PerformanceActions.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgL5z73gHfjgiAaK4vKQp3g4n-6dHTKPljMZsVXUJ5OnXSZo4IcdqWzJETsB5BqYF2JcSKMMmGKFHzw9O98IKN2gUhfly1LjVArKkFgNDq54IADNJk9ViR8eMBWSVVI5j-kHfxqcYbOt3M/s1600/PerformanceActions.jpg" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGZxicmpmgrAnE6NtxYbevTs3T1wmYEqNrSW1-RJZvG-08yTHDQMlN9LxOPBSyF0gZ0kzrPCcE0mVAC1Vk7gFkIKFSSkuGO1ESDRGnmyzCueaxmh1bNlJHiUb-sJw6UhcaFMDYgufS_8c/s1600/SelectTimeRange.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGZxicmpmgrAnE6NtxYbevTs3T1wmYEqNrSW1-RJZvG-08yTHDQMlN9LxOPBSyF0gZ0kzrPCcE0mVAC1Vk7gFkIKFSSkuGO1ESDRGnmyzCueaxmh1bNlJHiUb-sJw6UhcaFMDYgufS_8c/s1600/SelectTimeRange.jpg" height="304" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
Now at the bottom of the performance monitor screen, select a counter you're interested. I'll use <strong>Percent Memory Used</strong> for this example.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxoFzbysutmF-EyImCaXDF9Z1xq71RLImCBd8LU9xUd4bQQTR02CkWyoTdPv3Qhvzaw52ddiBxf9uj1eXHpcRe18GGT8f04wvnY0L0j1OVoN1u9UreQqw2FbVrtgl8wXaYS2ufGKubGkE/s1600/SCOMCounter.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxoFzbysutmF-EyImCaXDF9Z1xq71RLImCBd8LU9xUd4bQQTR02CkWyoTdPv3Qhvzaw52ddiBxf9uj1eXHpcRe18GGT8f04wvnY0L0j1OVoN1u9UreQqw2FbVrtgl8wXaYS2ufGKubGkE/s1600/SCOMCounter.jpg" height="11" width="400" /></a></div>
<br />
When selected, a graph should display such as the following:<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-bBQ5ccjgce_-EraflWbSlA6nZrrhKF7-OdTADlEqy-IYYvSBrGxSbfCW3Q7UmDWG9C1j60s736eJBmys4cYbmS6hjgcduHJubcHYa-i7HXmfbWa-FdMevgcsWwadzdKREohDVlqAhhU/s1600/SCOMGraph.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-bBQ5ccjgce_-EraflWbSlA6nZrrhKF7-OdTADlEqy-IYYvSBrGxSbfCW3Q7UmDWG9C1j60s736eJBmys4cYbmS6hjgcduHJubcHYa-i7HXmfbWa-FdMevgcsWwadzdKREohDVlqAhhU/s1600/SCOMGraph.jpg" height="136" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
Going back to the <strong>Performance Actions</strong> pane, select <strong>Copy Data to Clipboard</strong><br />
<br />
Open up notepad and past the contents, which should look similar to the following:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0fRir2N_r06N_KJ9KqLvUNHgzvbO0jFiZblfSsM_7oiTG0uTw9CzgipYNz9nJYqVeHku1kZWD9l0EGvkmwIChAvgU-UA2vPvyCpsTIWOJlDFvzC_pkP8oAodQ4hf5KXqueV0ym9nfB0A/s1600/ClipBoardData.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0fRir2N_r06N_KJ9KqLvUNHgzvbO0jFiZblfSsM_7oiTG0uTw9CzgipYNz9nJYqVeHku1kZWD9l0EGvkmwIChAvgU-UA2vPvyCpsTIWOJlDFvzC_pkP8oAodQ4hf5KXqueV0ym9nfB0A/s1600/ClipBoardData.jpg" height="231" width="320" /></a></div>
<br />
Save the file with an xml extension<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3y12x1oBciMEa16yMN-HWYe7yTYgzaOuhfbjL8_t9WWwt8_5WrgxSia6E4UVZfPm4S4h9d_ELkrGVuMvv2JewWV4orMpwSQ_U3BgeqwOlUFmDyYFH8Drp03NWqlMZxv0R6wWEUoUGyNQ/s1600/notepadsaveas.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3y12x1oBciMEa16yMN-HWYe7yTYgzaOuhfbjL8_t9WWwt8_5WrgxSia6E4UVZfPm4S4h9d_ELkrGVuMvv2JewWV4orMpwSQ_U3BgeqwOlUFmDyYFH8Drp03NWqlMZxv0R6wWEUoUGyNQ/s1600/notepadsaveas.jpg" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEix1aTZ0DRpRqImiqxo8Ag5AhyphenhyphenZ8lTBq20TxmzSOHFVfcJFFxGRCPaMTVSvmC1s-LSym-VcXIvE0BPCzWIrkBpYC2q3nfKZEww-e52_VhV_FDvWDpxXDBTpkEksUv58Mv7zCoWplDyMdUE/s1600/xmlfile.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEix1aTZ0DRpRqImiqxo8Ag5AhyphenhyphenZ8lTBq20TxmzSOHFVfcJFFxGRCPaMTVSvmC1s-LSym-VcXIvE0BPCzWIrkBpYC2q3nfKZEww-e52_VhV_FDvWDpxXDBTpkEksUv58Mv7zCoWplDyMdUE/s1600/xmlfile.jpg" height="120" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
Now open Excel, select the<strong> Data</strong> tab and select <strong>From Other Sources</strong> -> <strong>From XML Data Import</strong><br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwIgqIuiPA_IyIZnxPC3KN7iD_WWf9bmu_8kWlTjac7-_teTRApCN8oHjczI2reBnnhus7ay9od7D8LYWM8pNTyLCTFFOOoOihhfFnrxBsSv5dX8XM9KVgWfhhrNg3xsd7kVqOgoIhePk/s1600/xmlimport.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwIgqIuiPA_IyIZnxPC3KN7iD_WWf9bmu_8kWlTjac7-_teTRApCN8oHjczI2reBnnhus7ay9od7D8LYWM8pNTyLCTFFOOoOihhfFnrxBsSv5dX8XM9KVgWfhhrNg3xsd7kVqOgoIhePk/s1600/xmlimport.jpg" height="183" width="320" /></a></div>
<br />
Select the XML file created earlier; accept the import defaults when prompted<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_JfuEC-mrfTW9-GOm39cgGtnuvGc4rYWYU-JVWm2vKjM32kII-N3a_flOec74qbsqa_3tWAvkJdtx0JOtS81Bq_0KOA5rhpVSF2cTrkUIGP-pwQw18-uT4TirxyAdxACtg_aL6FgKkiU/s1600/ImportData.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_JfuEC-mrfTW9-GOm39cgGtnuvGc4rYWYU-JVWm2vKjM32kII-N3a_flOec74qbsqa_3tWAvkJdtx0JOtS81Bq_0KOA5rhpVSF2cTrkUIGP-pwQw18-uT4TirxyAdxACtg_aL6FgKkiU/s1600/ImportData.jpg" /></a></div>
<br />
This should populate the Excel spreadsheet with an X and Y column. The first column is the date/time stamp and the Y column is the performance data.<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhCPRX4nQKRjOHivQxhAyIlTsH6bYkbGKMWw0F08AzCjR6a-aotXmcuPmodRuiKWywsqY4bkp6uqgpnX33qKfTKPxN-KpgYSlyPfHKDCQt3Uhw9IDPjseBT3CBYHog57NmWwzzax_c-cPo/s1600/exceldata.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhCPRX4nQKRjOHivQxhAyIlTsH6bYkbGKMWw0F08AzCjR6a-aotXmcuPmodRuiKWywsqY4bkp6uqgpnX33qKfTKPxN-KpgYSlyPfHKDCQt3Uhw9IDPjseBT3CBYHog57NmWwzzax_c-cPo/s1600/exceldata.jpg" height="320" width="277" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
Select all of the Y data and with it highlighted, select the <strong>Insert</strong> tab -> <strong>Line</strong> -> <strong>2-D Line</strong> to generate a graph.<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuaYcXTJjp3LapESdlHDA1WlmYy8Yi_yC2W7LI4gaY4cZzH-JY2458dKBpgGjA5yAIH_ZzbssOBKnziihkgqADWCCWmYzCgDLp_D9-qqvXzc4nuaY3KuPRzd5mijaWdNblwU25h8wWqsw/s1600/ExcelLineMenu.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuaYcXTJjp3LapESdlHDA1WlmYy8Yi_yC2W7LI4gaY4cZzH-JY2458dKBpgGjA5yAIH_ZzbssOBKnziihkgqADWCCWmYzCgDLp_D9-qqvXzc4nuaY3KuPRzd5mijaWdNblwU25h8wWqsw/s1600/ExcelLineMenu.jpg" height="191" width="320" /></a></div>
<br />
This should yield a graph in Excel such as the following:<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjduLSnbfi4iyx07_R_5QbX9ECEVwy1tipS7-1fTbevettxAzF5zKdgyocuiyMnaNF5lTdy5DunDmXE-dNSlGLXlHEo05hl94-KgIHyt5IMmdgc3wvyuyAOL9AjlFJyssI7hFwOQmgrm4M/s1600/ExcelGraph.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjduLSnbfi4iyx07_R_5QbX9ECEVwy1tipS7-1fTbevettxAzF5zKdgyocuiyMnaNF5lTdy5DunDmXE-dNSlGLXlHEo05hl94-KgIHyt5IMmdgc3wvyuyAOL9AjlFJyssI7hFwOQmgrm4M/s1600/ExcelGraph.JPG" height="192" width="320" /></a></div>
<br />
Right-click on the graph line and select <strong>Add Trendline</strong><br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidIkSvffAlQdK0ORwrSWHRBUIzjxaqI1HFtS78ch1qERvCe9ixSj6iTYEPbDo6Y-CWMoY_DpUo6PSfCzNlNcuLWxf_gTZzYnsSxAGhvnOBz-hKf5c7tpnYeGihiCy7BDg9AUOROmqUgKw/s1600/AddTrendLine.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidIkSvffAlQdK0ORwrSWHRBUIzjxaqI1HFtS78ch1qERvCe9ixSj6iTYEPbDo6Y-CWMoY_DpUo6PSfCzNlNcuLWxf_gTZzYnsSxAGhvnOBz-hKf5c7tpnYeGihiCy7BDg9AUOROmqUgKw/s1600/AddTrendLine.jpg" height="299" width="320" /></a></div>
<strong></strong><br />
Generally, accepting the default will paint a trendline that is helpful for finding issues such as a memory leak or consistent data usage on a hard drive. However, you can play around with the trend to perform longer-term forecasts. I added 50 periods to the end of my trend line to see how memory might look in the future after my data set.<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjlFX1gdOjdz9CDlKCpRH4_2JbRBGXxredr0grGcx4-ZoZPkUjLrahEq1lJTejS4fHgcK4n79IGovz7efWTMmoguxCGbsQ-YqoP5wPeL9pWWp_EiKZMAqTFjnWR36gG-6wDTQQLbjNK-gU/s1600/TrendlineOptions.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjlFX1gdOjdz9CDlKCpRH4_2JbRBGXxredr0grGcx4-ZoZPkUjLrahEq1lJTejS4fHgcK4n79IGovz7efWTMmoguxCGbsQ-YqoP5wPeL9pWWp_EiKZMAqTFjnWR36gG-6wDTQQLbjNK-gU/s1600/TrendlineOptions.jpg" height="320" width="278" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
Graph results with the trendline:<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKPrvZ2ATj2Z6w68aBkfQxMVbUaOFJTeg5cFKlE7ggJf9nLh-sQhFcYZrEEdD3VoMcoKyWuw_fA0g4gdUu4s8byyovz2qPwKZ_h5YOa2aNQ4WSBADzSgPr4_Oy-iYpC0biCbhgW0Pf3JU/s1600/GraphwithTrendline.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKPrvZ2ATj2Z6w68aBkfQxMVbUaOFJTeg5cFKlE7ggJf9nLh-sQhFcYZrEEdD3VoMcoKyWuw_fA0g4gdUu4s8byyovz2qPwKZ_h5YOa2aNQ4WSBADzSgPr4_Oy-iYpC0biCbhgW0Pf3JU/s1600/GraphwithTrendline.JPG" height="193" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
The line extends a bit beyond the graph data and shows an overall flat trend on memory utilization. If the server had a memory leak, as an example, the graph might trend steadily upwards like this:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigvuVdEdqyvdleI64hTd-eqyWyJeFwXUhj6oqebpCvdA97kmrHD3NpjR9FHVdiHeE_6TL6a00st0-fmlWficDkXiIIRwq5FZ3WgS7an5aqAT4uC5TXyXTYDMsQ1EoSmHEAMTMHtTpxbc0/s1600/BadTrendLine.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigvuVdEdqyvdleI64hTd-eqyWyJeFwXUhj6oqebpCvdA97kmrHD3NpjR9FHVdiHeE_6TL6a00st0-fmlWficDkXiIIRwq5FZ3WgS7an5aqAT4uC5TXyXTYDMsQ1EoSmHEAMTMHtTpxbc0/s1600/BadTrendLine.JPG" height="173" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
There you have it, a simple but powerful tool for analyzing data recorded in SCOM without a lot of effort.Dave Murphyhttp://www.blogger.com/profile/14038170973560613332noreply@blogger.com0tag:blogger.com,1999:blog-1807410337729170157.post-5573562991004364612014-12-23T10:40:00.000-08:002014-12-23T11:10:08.363-08:00AD Site Availability Degraded / AD Site Performance Health DegradedAfter deploying the Active Directory Management Packs, we had a domain controller start alert spewing. I had not come across anything out there that really dealt with the alert; the warning from this type of event was not in <a href="http://eventid.net/">eventid.net</a> either. But it's all figured out now and here is the solution to the perplexing problem I encountered.<br />
<br />
You could also title this, "How to Perform an Online/Offline Defragmentation of your Health Service Store in System Center".<br />
<br />
Problem Description:<br />
<br />
First, the SCOM console began to fill up with AD Site Availability Health Degraded and AD Site Performance Health Degraded critical alerts from the Active Directory Management Packs.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNvtS4YaVEYtGjlxuNP1dGIk9-KbbPB4CnJRQazr6Tpk00FCK0mKxdw-VtLolBsqBzVgeP3Y9xsZbWm2urXVsnhDFaeM1tTSuir4SW6DBbbBqG0GVznjs-4hHUEZzl2tZyZmvoG2647EE/s1600/AgentSitePerformance.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="AD Site Availability Health Degraded and AD Site Performance Health Degraded" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNvtS4YaVEYtGjlxuNP1dGIk9-KbbPB4CnJRQazr6Tpk00FCK0mKxdw-VtLolBsqBzVgeP3Y9xsZbWm2urXVsnhDFaeM1tTSuir4SW6DBbbBqG0GVznjs-4hHUEZzl2tZyZmvoG2647EE/s1600/AgentSitePerformance.jpg" height="203" title="System Center Operations Manager 2012 - AD Site Availability Health Degraded and AD Site Performance Health Degraded" width="400" /></a></div>
<br />
On the offending domain controller, I observed the following Application event log spewing:<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOJi2_ADo_PZyyy1C6Xhg_YrlIwBxiRm28Igsp5LxFn5ZArRR0Saa9LJ3mxCWaqRwbX9zfQyKnA86ENXX7wgrk745XIRpBO_ve-JLXDVzOW4jToX4Omkd1tcTAITTXbCDKMjqQdA4153w/s1600/Event+906+Occurrence.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOJi2_ADo_PZyyy1C6Xhg_YrlIwBxiRm28Igsp5LxFn5ZArRR0Saa9LJ3mxCWaqRwbX9zfQyKnA86ENXX7wgrk745XIRpBO_ve-JLXDVzOW4jToX4Omkd1tcTAITTXbCDKMjqQdA4153w/s1600/Event+906+Occurrence.jpg" height="272" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
The contents of the warning were as follows:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVKbplliuAP13fLzL3o6G76974MvyHA14l1pQ2nj4YmwZFbcXxjEBPMvAcclLJmAmooOyjF8hXcsYSgb0zD_2p5cX0Mlc-iGZ_gYhod7wmA_VyRm9SXdtn_VPIRUzNF_6A7dVBqe6WU4Q/s1600/Event+906+Properties.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="HealthService (1704) A significant portion of the database buffer cache has been written out to the system paging file. This may result in severe performance degredation. See help link for complete details of possible causes. Log Name: Application | Source: ESENT | Event ID: 906" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVKbplliuAP13fLzL3o6G76974MvyHA14l1pQ2nj4YmwZFbcXxjEBPMvAcclLJmAmooOyjF8hXcsYSgb0zD_2p5cX0Mlc-iGZ_gYhod7wmA_VyRm9SXdtn_VPIRUzNF_6A7dVBqe6WU4Q/s1600/Event+906+Properties.jpg" height="276" title="System Center Operations Manager - Event 906 Property Description" width="400" /></a></div>
<br />
Troubleshooting:<br />
<br />
Initially what I suspected was that I had an application or process going bonkers on the server, taking up memory and causing the SCOM agent to malfunction or be starved of resources. I loaded the Systernals <a href="http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx" target="_blank">Process Monitor</a> utility to see what was happening when these events fired off, since typically it only took a few minutes in between each event. What was captured was a significant amount of file activity from the Health Service to
<br />
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
C:\Program Files\Microsoft Monitoring Agent\Agent\Health
Service State\Health Service Store\HealthServiceStore.edb . Essentially, there was no other process at the time of these warnings or corresponding alerts in the System Center Management Console that could account for issues on the system.</div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
</div>
<div class="separator" style="clear: both; margin: 0in 0in 10pt; text-align: center;">
</div>
<div class="separator" style="clear: both; margin: 0in 0in 10pt; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgDSGoZ3Cx1psMRVy5PIC1CWHzK3uqrhStbK7alZ4ZXTowloprC6etnLl0RuVcIYxVR3fymZ2WoDwIeJtQrxC8lRmuK23e9jJ_cO1Gv82qiZaTtMo2xbFIkucj4fFoQgpC4Kav0uKVXAnw/s1600/Process+Monitor.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="SCOM HealthService | ReadFile | C:\Program Files\Microsoft Monitoring Agent\Agent\Health Service State\Health Service Store\HealthServiceStore.edb" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgDSGoZ3Cx1psMRVy5PIC1CWHzK3uqrhStbK7alZ4ZXTowloprC6etnLl0RuVcIYxVR3fymZ2WoDwIeJtQrxC8lRmuK23e9jJ_cO1Gv82qiZaTtMo2xbFIkucj4fFoQgpC4Kav0uKVXAnw/s1600/Process+Monitor.jpg" height="91" title="Process Monitor of System Center Operations Manager 2012 Agent Activity" width="400" /></a></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
</div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
With the smoking gun being the Health Service Database, I performed some quick online maintenance from within the console to start.</div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
</div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
In the Operations Manager Console, I started by browsing to the Operations Manager folder, then Agent Details and selecting the Agents by Version view. </div>
<div class="separator" style="clear: both; margin: 0in 0in 10pt; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEtsoQjNvSej_C14vv1Yphj7KsOk_J-vqOHXLU4jtNfVm-7hnz18BqxXyzmknFYEPJvzitBpQYRaVCPEZZ0000WPZtnvaias1QvoP1BjRViIUAk0oB6MQrSVAJTonKJ2-Y4shtBfpulXE/s1600/OpsManagerFolder.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Management Console Tree -> Operations Manager -> Agent Details -> Agents By Version" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEtsoQjNvSej_C14vv1Yphj7KsOk_J-vqOHXLU4jtNfVm-7hnz18BqxXyzmknFYEPJvzitBpQYRaVCPEZZ0000WPZtnvaias1QvoP1BjRViIUAk0oB6MQrSVAJTonKJ2-Y4shtBfpulXE/s1600/OpsManagerFolder.jpg" title="System Center 2012 Operations Manager Console" /></a></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
</div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
</div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
Selecting the offending computer brought up the Health Service Tasks I could perform, Start Online Store Maintenance, being the one I was looking for.</div>
<div class="separator" style="clear: both; margin: 0in 0in 10pt; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgEVILnFYBpNMnlxZVyym1-vIX5jUIeFb4GAz-Bctno2UhTtPHJHOw0LUGeUMHg30BF5Bien0xEaetqokBJD4OvXKom2uhRShrRQ0tVtgGG3ZfccIZ_WmsaDyZfnzOLTS-qVZucMlv1CFc/s1600/HealthServiceTask.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Management Console Health Service Task for Health Service Database Maintenance | Start Online Store Maintenance" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgEVILnFYBpNMnlxZVyym1-vIX5jUIeFb4GAz-Bctno2UhTtPHJHOw0LUGeUMHg30BF5Bien0xEaetqokBJD4OvXKom2uhRShrRQ0tVtgGG3ZfccIZ_WmsaDyZfnzOLTS-qVZucMlv1CFc/s1600/HealthServiceTask.jpg" height="320" title="System Center 2012 Operations Manager Console" width="159" /></a></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
</div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
Final Solution:<br />
<br />
Unfortunately, the online store maintenance was not adequate enough to remediate the errors and warnings I was encountering so I opted for an offline defragmentation of the Health Service Store database. Perform the following if local warnings persist on the client system.</div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
</div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<ul>
<li>Login to the offending client system via console or RDP</li>
<li>Open an administrative command prompt</li>
<li>Change directory to "<span style="font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">C:\Program
Files\Microsoft Monitoring Agent\Agent\Health Service State\Health Service
Store"</span></li>
<li><span style="font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">From the service console (services.msc) or from command prompt (<span style="font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">net
stop “Microsoft Monitoring Agent”), stop the Microsoft Monitoring Agent service</span></span></li>
<li><span style="font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><span style="font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Run esentutl /r edb (without this, you likely won't be able to perform a defragmentation)</span></span></li>
<li>Next, run esentutl /d HealthServiceStore.edb</li>
</ul>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhUOUGYqGmbIsH0gNdMux6AUrYYhHtl_hZGGRWTGu0zIZVK_qkLk4ST7hyphenhyphen7WJK-FB44b595how7-Q1tRipwYZkNnsaeKxhZMKfhyphenhyphenuPzyTq8yuxvmn8y66b-y3-EVv2tll674ZVjUzkghJI/s1600/CmdView.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Running esentutl /d HealthServiceStore.edb in order to compact and defragment the health service database after log spewing occurred from loading the Active Directory management packs" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhUOUGYqGmbIsH0gNdMux6AUrYYhHtl_hZGGRWTGu0zIZVK_qkLk4ST7hyphenhyphen7WJK-FB44b595how7-Q1tRipwYZkNnsaeKxhZMKfhyphenhyphenuPzyTq8yuxvmn8y66b-y3-EVv2tll674ZVjUzkghJI/s1600/CmdView.jpg" height="202" title="System Center Operations Manager 2012 - offline defragementation of Health Service Store database" width="400" /></a></div>
<span style="font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><span style="font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"></span></span><br />
<span style="font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><span style="font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">When this completed, my HealthServiceStore.edb file went from 174MB to 27Mb and both the warnings in the local Application event log and the critical health alerts in the System Center Operations Manager Console went away.</span></span>Dave Murphyhttp://www.blogger.com/profile/14038170973560613332noreply@blogger.com3tag:blogger.com,1999:blog-1807410337729170157.post-5365254401546326712014-08-06T12:58:00.003-07:002014-08-06T12:58:48.601-07:00Problems with the 2012 R2 Web ConsolesThis post is a little long, but I wanted to include as much pertinent error information as possible to help folks properly identify if they are encountering the same type of issue.<br />
<br />
Recently upgraded our systems to SCOM 2012 R2 and encountered some issues with client connectivity to the web console. SQL is on a separate system from the management console. Web and Management Console is on the same system (for perspective on how our systems are distributed).<br />
<br />
First, let's start with some of the errors I was seeing:<br />
<br />
From a client, attempting to connect to the AppAdvisor console:<br />
<br />
Error on the client:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiKgCl1VEa2cDMjC0n31AXxjhuBiSxDhp3Bo948Kpae4cY5ZWjw4u0aqGkqaX31sQ9bCPkFA1rME8Jci-rei0Q6wzwkXABjdr71B1OkYMowDUqd-mt3YP7rzBky_N93hyphenhyphen7m3h3edBhkZxo/s1600/AppAdvisorErrror.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="An error has occured - The additional error information can be found int he Windows Application Log. We appologize for any inconvenience caused by this temporary service outage." border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiKgCl1VEa2cDMjC0n31AXxjhuBiSxDhp3Bo948Kpae4cY5ZWjw4u0aqGkqaX31sQ9bCPkFA1rME8Jci-rei0Q6wzwkXABjdr71B1OkYMowDUqd-mt3YP7rzBky_N93hyphenhyphen7m3h3edBhkZxo/s1600/AppAdvisorErrror.JPG" height="160" title="SCOM 2012 R2 - AppAdvisor Website Error" width="320" /></a></div>
<br />
<br />
Warning on the SCOM management server when connecting to the AppAdvisor console:<br />
<br />
<table cellpadding="2" cellspacing="0" style="width: 100%;"><tbody>
<tr>
<td style="background: rgb(120, 120, 120); border-bottom-color: rgb(221, 221, 221);">Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 8/5/2014 9:38:10 AM :<br />
Event time (UTC): 8/5/2014 4:38:10 PM :<br />
Event ID: 20964fc40f3c43348ccff13e467e259a :<br />
Event sequence: 7 :<br />
Event occurrence: 1 :<br />
Event detail code: 0 :<br />
:<br />
Application information: :<br />
Application domain: /LM/W3SVC/1/ROOT/AppAdvisor-1-130517302775480349 :<br />
Trust level: Full :<br />
Application Virtual Path: /AppAdvisor :<br />
Application Path: C:\Program Files\Microsoft System Center 2012 R2\Operations Manager\WebConsole\AppDiagnostics\AppAdvisor\Web\ :<br />
Machine name: SCOM-MS01 :<br />
:<br />
Process information: :<br />
Process ID: 4332 :<br />
Process name: w3wp.exe :<br />
Account name: NT AUTHORITY\NETWORK SERVICE :<br />
:<br />
Exception information: :<br />
:
Exception type: WebException :<br />
Exception message: The request failed with HTTP status 401: Unauthorized.:<br />
:<br />
Request information: :<br />
Request URL: http://scom-ms01/AppAdvisor/Pages/ReportService/ReportServicePageImpl.aspx?_r=&_c=g&_pg=436ac5a4-3e70-41b9-9fe1-5a5c96724dc0&_s=2C369460 :<br />
Request path: /AppAdvisor/Pages/ReportService/ReportServicePageImpl.aspx :<br />
User host address: <client ip=""> :<br />
User: <domain user="">:<br />
Is authenticated: True :<br />
Authentication Type: Forms :<br />
Thread account name: NT AUTHORITY\NETWORK SERVICE :<br />:<br />
Thread information: :<br />
Thread ID: 17 :<br />
Thread account name: NT AUTHORITY\NETWORK SERVICE :<br />
Is impersonating: False :<br />
</domain></client></td>
</tr>
</tbody></table>
<br />
Similarly, I received that error when connecting to the AppDiagnostics site as well:<br />
<br />
<table cellpadding="2" cellspacing="0" style="width: 100%;"><tbody>
<tr>
<td style="background: rgb(120, 120, 120); border-bottom-color: rgb(221, 221, 221);">Event code: 3005 <br />
Event message: An unhandled exception has occurred. <br />
Event time: 8/5/2014 9:32:02 AM <br />
Event time (UTC): 8/5/2014 4:32:02 PM <br />
Event ID: 67e2d2ba9c4842c3bc041c62bad932e3 <br />
Event sequence: 8 <br />
Event occurrence: 1 <br />
Event detail code: 0 <br />
Application information: <br />
Application domain: /LM/W3SVC/1/ROOT/AppDiagnostics-2-130517299136496487 <br />
Trust level: Full <br />
Application Virtual Path: /AppDiagnostics <br />
Application Path: C:\Program Files\Microsoft System Center 2012 R2\Operations Manager\WebConsole\AppDiagnostics\Web\ <br />
Machine name: SCOM-MS01 <br />
<br />
Process information: <br />
Process ID: 8048 <br />
Process name: w3wp.exe <br />
Account name: IIS APPPOOL\OperationsManagerAppMonitoring <br />
<br />
Exception information: <br />
Exception type: OleDbCommandException <br />
Exception message: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.<br />
Command text: Select CONFIGID, CONFIGNAME, CONFIGVALUE From apm.CONFIG<br />
Connection: Provider=SQLOLEDB;Server=scom-sql;database=OperationsManager;Integrated Security=SSPI;<br />
<br />
Request information: <br />
Request URL: http://scom-ms01/AppDiagnostics/Pages/Authenticate.aspx?ReturnUrl=/appdiagnostics <br />
Request path: /AppDiagnostics/Pages/Authenticate.aspx <br />
User host address: <client ip=""> <br />
User: <br />
Is authenticated: False <br />
Authentication Type: <br />
Thread account name: IIS APPPOOL\OperationsManagerAppMonitoring <br /><br />
Thread information: <br />
Thread ID: 9 <br />
Thread account name: IIS APPPOOL\OperationsManagerAppMonitoring <br />
Is impersonating: False<br />
</client></td>
</tr>
</tbody></table>
<br />
And finally, on the primary /OperationsManager web console, I'd receive an authentication error. The client would be prompted multiple times for a username and password and eventually bomb out.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVcup7q0GgGF-HPXcZqf4dtLYxvW0iKzZUBLuh2MU-oCzJCyRqngwNfmb8bCBroFpO8bstZ4F_DyuXvFD8zf6S7Xld3s094GkI0uJIxEDgjHG6Q6b2dhgUtj9N8DDG-P9yTt_nUFMg79g/s1600/OperationsManager+-+Authentication+Error.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Server Error - 401 - Unauthorized: Access is denied due to invalide credentials. You do not have permission to view this directory or page using the credentials that you supplied." border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVcup7q0GgGF-HPXcZqf4dtLYxvW0iKzZUBLuh2MU-oCzJCyRqngwNfmb8bCBroFpO8bstZ4F_DyuXvFD8zf6S7Xld3s094GkI0uJIxEDgjHG6Q6b2dhgUtj9N8DDG-P9yTt_nUFMg79g/s1600/OperationsManager+-+Authentication+Error.JPG" height="73" title="SCOM Operations Manager Web Console Login Error" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
Solving the problem.<br />
<br />
First step was a prerequisite for both the AppAdvisor and AppDiagnostic issues.<br />
<ol>
<li>Open the IIS console on the web console server</li>
<li>Select "Application Pools"</li>
<li>Select "OperationsManagerAppMonitoring"</li>
<li>If you are receiving the errors and the application pool "Identity" is set to "ApplicationPoolIdentity", with the OperationsManagerAppMonitoring pool highlighted, select "Advanced Settings" option in the action pane.</li>
<li>Under "Process Model", change the Identity from ApplicationPoolIdentity to "NetworkService"</li>
<li>Run an IISReset at an administrator (elevated) command prompt</li>
</ol>
At this point, the AppDiagnostic website started working, but the AppAdvisor site did not. I had to perform additional steps for that site.<br />
<ol>
<li>Open the IIS console on the web console server</li>
<li>Select and expand the site (Default Web Site on my server) where the Operations Manager web console is installed.</li>
<li>Select the virtual directory named "AppAdvisor"</li>
<li>Open the "Authentication" applet</li>
<li>If not already enabled, enable the "Anonymous" and "ASP .NET Impersonation" methods</li>
<li>Run an IISReset at an administrator (elevated) command prompt</li>
</ol>
Final piece to get into the Operations Manager web console was to adjust an IE setting, oddly enough. To fix this portion, I took the following steps:<br />
<ol>
<li>Open "Internet Options" in Internet Explorer</li>
<li>Select the "Advanced" tab</li>
<li>Scroll almost all the way down and uncheck the box for "Enable Integrated Windows Authentication"</li>
</ol>
After these adjustments, all web consoles were available for remote clients.Dave Murphyhttp://www.blogger.com/profile/14038170973560613332noreply@blogger.com0tag:blogger.com,1999:blog-1807410337729170157.post-61341618253548561142014-02-07T16:36:00.000-08:002014-02-07T16:36:38.697-08:00SCOM 2012 Failed Accessing Windows Event Log with Veeam Management PackNoticed during a routine health check that our two Management Servers were showing a warning state. Error read as "Failed Access Windows Event Log" <management server 1> (Health Service).<br />
<br />
Error details show the following:<br />
<br />
The Windows Event Log Provider is still unable to open the Veeam Collector event
log on computer 'management server 1'. The Provider has been unable to open
the Veeam Collector event log for 720 seconds. Most recent error details: The
specified channel could not be found. Check channel configuration. One or more
workflows were affected by this. Workflow name: many Instance name: many
Instance ID: many Management group:<br />
<br />
We have the Veeam management pack for SCOM loaded and sure enough, this appears to be a documented issue on the Veeam knowledge base.<br />
<br />
<a href="http://www.veeam.com/kb1496#/kb1496">http://www.veeam.com/kb1496#/kb1496</a><br />
Dave Murphyhttp://www.blogger.com/profile/14038170973560613332noreply@blogger.com0tag:blogger.com,1999:blog-1807410337729170157.post-15700123274317171952013-11-21T16:50:00.001-08:002013-11-21T16:51:05.642-08:00Windows 2012 WMI HotfixHad a 2012 Server that was being monitoring by System Center lock up on us today. Suspect a WMI leak. Hotfix deployment, engage!<br />
<br />
<a href="http://support.microsoft.com/kb/2790831/en-us">http://support.microsoft.com/kb/2790831/en-us</a><br />
<br />Dave Murphyhttp://www.blogger.com/profile/14038170973560613332noreply@blogger.com1tag:blogger.com,1999:blog-1807410337729170157.post-4819635355244539792013-11-15T10:43:00.001-08:002013-11-15T10:43:21.662-08:00SCOM 2012 Powershell - Retrieving a List of Computers in a GroupHad to search for a batch file that is on one of the many SQL servers we have in the environment. First inclination was, let me pull the systems from SCOM since it has all our SQL servers.<br />
<br />
Poked around the interwebs a while and noticed a lot of scripts had references to 2007 commands that hadn't been updated to 2012. Here's the basic steps taken to get my group of SQL servers. You could perform the same task on pretty much any group in the same manner.<br />
<br />
<ul>
<li>Open the Operations Manager Shell powershell console</li>
</ul>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFYQ2aYuvsgRJAjGQ6tfr1bHo6SSZF8Rq-HWzSNVoNxrbD-1xjDlhl1b56iD40k9YCyjuyH4cfj307VVxg5VcLWhGZ2rR2UZFtemCSanOBh3JtwLTNuBWev1k7JdHaKNaUHz-ZUfs6FDw/s1600/SCOM+Powershell+Console.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Image illustratin the correct System Center 2012 Operations Manager Shell to open for running the powershell commands" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFYQ2aYuvsgRJAjGQ6tfr1bHo6SSZF8Rq-HWzSNVoNxrbD-1xjDlhl1b56iD40k9YCyjuyH4cfj307VVxg5VcLWhGZ2rR2UZFtemCSanOBh3JtwLTNuBWev1k7JdHaKNaUHz-ZUfs6FDw/s1600/SCOM+Powershell+Console.jpg" title="SCOM 2012 Operations Manager Shell" /></a></div>
<ul>
<li>Type in : Get-SCOMGroup</li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhf5sVGmLFA83_8WIwomy_Au4N8UI38nxesDT8Ii2CyhWSBR4YRH832fP_eEEmZG5WDk0DWH2xFditf8X8IzzeVQDoaM4bpL7_N2ukU8dvj5cQxamRbRE8BxvyIh9EXOTocgcb-FlQ-el4/s1600/1-Get-SCOMGroup.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Image shows the sample output of running the SCOM 2012 Get-SCOMGroup command in powershell" border="0" height="161" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhf5sVGmLFA83_8WIwomy_Au4N8UI38nxesDT8Ii2CyhWSBR4YRH832fP_eEEmZG5WDk0DWH2xFditf8X8IzzeVQDoaM4bpL7_N2ukU8dvj5cQxamRbRE8BxvyIh9EXOTocgcb-FlQ-el4/s400/1-Get-SCOMGroup.JPG" title="Operations Manager Powershell Console Showing the Get-SCOMGroup command" width="400" /></a></div>
<ul>
<li>Search for the group you want to retrieve members from</li>
</ul>
<ul>
<li>Now type in: $Group = Get-SCOMGroup | where {$_.DisplayName -eq "SQL Computers"} (or insert the group your looking for instead of SQL Computers")</li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvM3mBeH468Xb9l1n_tnSWXzUvOLoqYshbj3pMOdvMVlOjlPkLMT6lhcMx30JGi-GEJRpb6eayHC4ztopQ24xdLip18QybL_Crly_iz1j52Ys97MV2KgwOjJ2DPaXGicAZINhikhQrnhE/s1600/2-GetSpecificGroup.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Image illustrates running the Get-SCOMGroup command with a filter for a specific group and assigning to a variable" border="0" height="48" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvM3mBeH468Xb9l1n_tnSWXzUvOLoqYshbj3pMOdvMVlOjlPkLMT6lhcMx30JGi-GEJRpb6eayHC4ztopQ24xdLip18QybL_Crly_iz1j52Ys97MV2KgwOjJ2DPaXGicAZINhikhQrnhE/s400/2-GetSpecificGroup.JPG" title="SCOM 2012 powershell command to get assign a specific group to a variable from Operations Manager" width="400" /></a></div>
<br />
<ul>
<li>Next, type in: $Members = $Group.GetRelatedMonitoringObjects()</li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhpPX2hGwvjhtwyvEv9bIvPhMjjE2C8oovJSDirWrIKo3qm_fJ-UKA2pR6lyxOKP64a_CAWBju4NIwoEg4XZFHK73f6T_F1XhkIDOe7kWr5ot4MVK4DNDBSQMQTUvG-6ZCPJkpA76qOFL0/s1600/3-GetGroupMembers.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Illustrates the use of the command GetRelatedMonitoringObjects() for retriving a list of group members and assigning them to a variable" border="0" height="68" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhpPX2hGwvjhtwyvEv9bIvPhMjjE2C8oovJSDirWrIKo3qm_fJ-UKA2pR6lyxOKP64a_CAWBju4NIwoEg4XZFHK73f6T_F1XhkIDOe7kWr5ot4MVK4DNDBSQMQTUvG-6ZCPJkpA76qOFL0/s400/3-GetGroupMembers.JPG" title="SCOM 2012 management shell loading the members of a specific Operations Manager group into a variable" width="400" /></a></div>
<br />
<ul>
<li>Now, you can simply type: $Members</li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgBkXDnJGtPNQpyID7IbePPWWDKipI7yB6byTyWfD1gCXlx8s_wRaYV_bjPfYqryQzL1T2v9Xnv6B_gjIRtPVOsgyBCm7M-8CAp-j-fVcLrVROqUUkIuqyL1adNzm0WUW-e3CT8a0CKLI/s1600/4-DisplayGroupMembersinConsole.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Illustrates the output of members captured in the previous step using GetRelatedMonitoringObject(). Should show three headings and then the server members from the group" border="0" height="66" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgBkXDnJGtPNQpyID7IbePPWWDKipI7yB6byTyWfD1gCXlx8s_wRaYV_bjPfYqryQzL1T2v9Xnv6B_gjIRtPVOsgyBCm7M-8CAp-j-fVcLrVROqUUkIuqyL1adNzm0WUW-e3CT8a0CKLI/s400/4-DisplayGroupMembersinConsole.JPG" title="SCOM 2012 Operations Manager shell command showing output of group members" width="400" /></a></div>
<br />
<ul>
<li>Or, pipe the command out to a file: $Members | Sort DisplayName | FT DisplayName | out-file C:\Scripts\Servers.txt</li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjN0iNZBsens408XktBCiLYvGbq2JzXjUVutVhUUjZWwSqg2wuEOct3cV6gw_Uha8Jxh4oCi6OKgL-FgPGmP2S2Z1z-8R4JAfnMfCtX1cuRvAFxJ-eYUSF4bVhSnC-QLd87uUgn4ciigjw/s1600/5-PipeMemberstoFile.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Illustrates running the following command in powershell to pipe a variable out to a file: $Members | Sort DisplayName | FT DisplayName | out-file C:\Scripts\Servers.txt" border="0" height="76" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjN0iNZBsens408XktBCiLYvGbq2JzXjUVutVhUUjZWwSqg2wuEOct3cV6gw_Uha8Jxh4oCi6OKgL-FgPGmP2S2Z1z-8R4JAfnMfCtX1cuRvAFxJ-eYUSF4bVhSnC-QLd87uUgn4ciigjw/s400/5-PipeMemberstoFile.JPG" title="Piping the contents of a variable out to a file in the Operations Manager shell console" width="400" /></a></div>
<br />
<br />Dave Murphyhttp://www.blogger.com/profile/14038170973560613332noreply@blogger.com7tag:blogger.com,1999:blog-1807410337729170157.post-75812720930145458032013-10-31T16:47:00.001-07:002013-11-15T10:46:25.336-08:00Automated Discovery and Troubleshooting of Gray State Systems in System Center 2012 (Part-1)Recently come across a rash of clients and internal systems at the office where monitored devices, for whatever reason, have gone into a gray state. I needed a way to quickly discover these systems, and ideally, run a script that would take some basic actions to remediate or troubleshoot these agents. In this first post, I'll give the full code necessary to get the gray agent discovery running. In the second post, I'll give a powershell script that detects the grayed out agents, shuts down the HealthService, clears the agent health directory, and then turns the HealthService back on automatically.<br />
<br />
I came across three lines of code in the following blog, which got me pointed in the right direction. However, the code did not work correctly as provided.<br />
<br />
<a href="http://www.bictt.com/blogs/bictt.php/2011/05/27/scom-trick-14-troubleshoot-grey">http://www.bictt.com/blogs/bictt.php/2011/05/27/scom-trick-14-troubleshoot-grey</a><br />
<br />
<em>$WCC = get-monitoringclass -name "Microsoft.SystemCenter.Agent"<br />$MO = Get-MonitoringObject -monitoringclass:$WCC | where {$_.IsAvailable -eq $false}<br />$MO | select DisplayName</em><br />
<em></em><br />
With just that code, I would receive the following error screen:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgDWqhGF_9sR1EPqKdqnLf6QDfsPFxKqM9Q-NsYZ0yWikSJNIrTixNqEc5Ql4BQwNZnL1tzZltGVGqBXv-nB6N99RLlvGe3sCdkVaNt0gch7vDhwR30DxVsLFPLmqxXSdaElMkv7PU6qSs/s1600/Agent+Discovery+Script+Failure.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Illustrates an error that is common when using powerhsell get-monitoringclass without specifiying the appropriate variables for the script to connect to the System Center 2012 Management Server" border="0" height="172" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgDWqhGF_9sR1EPqKdqnLf6QDfsPFxKqM9Q-NsYZ0yWikSJNIrTixNqEc5Ql4BQwNZnL1tzZltGVGqBXv-nB6N99RLlvGe3sCdkVaNt0gch7vDhwR30DxVsLFPLmqxXSdaElMkv7PU6qSs/s640/Agent+Discovery+Script+Failure.JPG" title="Poweshell Gray Agent Detection Script Error for SCOM 2012" width="520" /></a></div>
<br />
<br />
If you update the code to include the following path and connection to your system center server, the code will function properly. Running this should spit out a list of computers with a gray state in the agent status. This code should all be included in your powershell script:<br />
<br />
<br />
<em>$RMSFQDN = "<your SCOM managment server FQDN>"<br />$Name = "Microsoft.EnterpriseManagement.OperationsManager.Client"<br />$ModuleLoaded = Get-Pssnapin $Name -ErrorAction SilentlyContinue</em><br />
<em>If (-not $ModuleLoaded)<br />{<br />add-pssnapin "Microsoft.EnterpriseManagement.OperationsManager.Client";<br />}</em><br />
<em>New-ManagementGroupConnection -ConnectionString $RMSFQDN<br />Set-Location "OperationsManagerMonitoring::";</em><br />
<br />
<em>$AgentClass = get-monitoringclass -name:Microsoft.SystemCenter.Agent</em><br />
<em>$MO = Get-MonitoringObject -monitoringclass:$AgentClass | where {$_.IsAvailable -eq $false}<br /><br />$MO | select DisplayName</em> <br />
<br />
Also, review this link for a comprehensive list of WMI hotfixes for various platforms:<br />
<br />
<a href="http://support.microsoft.com/kb/2591403">http://support.microsoft.com/kb/2591403</a><br />
<br />
Updated 11-15-2013: Review this link for agent based system hotfixes: <a href="http://support.microsoft.com/kb/2843219">http://support.microsoft.com/kb/2843219</a>Dave Murphyhttp://www.blogger.com/profile/14038170973560613332noreply@blogger.com0tag:blogger.com,1999:blog-1807410337729170157.post-80214592386834595572013-06-14T20:57:00.001-07:002013-06-14T20:57:45.156-07:00Scripting the Deployment of the Action Account to serversIf you have a large server list and you quickly want to add rights for your action account, check out this helpful method. Just go to active directory and create a query for your servers, then remove the columns (outside of the server names). I've enclosed the query definition. Drop this into an xml file and import into Active Directory, under "Saved Queries".<br />
<br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;"><QUERY><NAME>Servers</NAME><DESCRIPTION></DESCRIPTION><DN></DN><FILTERLASTLOGON>-1</FILTERLASTLOGON><LDAPQUERY>(&amp;(&amp;(sAMAccountType=805306369)(objectCategory=computer)(objectClass=computer)(operatingSystem=Windows\20Server*)))</LDAPQUERY><ONELEVEL>FALSE</ONELEVEL><COLUMNID>{5AAC0BFD-BFA4-44BB-95A9-EF6CCC1F64EF}</COLUMNID></QUERY></span><br />
Here is the link to the site:<br />
<br />
<a href="http://www.bluemoonpcrepair.com/wp/?p=145">http://www.bluemoonpcrepair.com/wp/?p=145</a><br />
Dave Murphyhttp://www.blogger.com/profile/14038170973560613332noreply@blogger.com0tag:blogger.com,1999:blog-1807410337729170157.post-12070916836285065112013-05-02T16:33:00.000-07:002013-05-02T16:33:27.458-07:00Where Did My LINUX RPMs Go?! @##%&&%Some time ago, I created a video and wrote a blog on a quick and painless way to install the LINUX agents for SCOM. Well, came time to do that again and I noticed, even after downloading the management packs from the catalog, I could not find the rpm files!<br />
<br />
After some exasperating searching and much gnashing of the teeth, I finally found the download for the updated management packs. Installing the ones from this pack will give you the rpms. In the past, the rpms could be found on the CD/DVD.<br />
<br />
System Center 2012 Monitoring Pack for UNIX and Linux Operating Systems :<br />
<a href="http://www.microsoft.com/en-us/download/details.aspx?id=29696">http://www.microsoft.com/en-us/download/details.aspx?id=29696</a><br />
Dave Murphyhttp://www.blogger.com/profile/14038170973560613332noreply@blogger.com0tag:blogger.com,1999:blog-1807410337729170157.post-75842890413751238292013-03-11T14:28:00.000-07:002013-03-11T14:28:13.582-07:00Upcoming topics on SCOMHaven't had a chance to post anything recently, but it's not for a lack of trying. I have 41 pages of screen shots and instructions that walk folks through the SNMP troubleshooting, from creating the LINUX test system through to getting the alerts in SCOM, trying to walk through where your SNMP setup could be failing. Also going to post pulling raw metrics for analysis in Excel. SQL Reporting is nice, but it can be overly complicated when sometimes, you just want some quick data and some graphs. Finally, will be posting another method for organizing data outside of the datawarehouse. This will provide a safer method of writing your own reports and views without disturbing the installation.Dave Murphyhttp://www.blogger.com/profile/14038170973560613332noreply@blogger.com0tag:blogger.com,1999:blog-1807410337729170157.post-83592839918249344482013-02-15T09:31:00.001-08:002013-02-15T09:31:14.550-08:00System Center Installer - OMServer.msi returned error 1603Having problems installing your secondary management server, maybe even your primary? Great post about pre-requisites. Setting up our secondary server, the management server installer was failing. I had made sure to install the report viewer modules, .NET 4.0 but forgot .NET 3.51. The installer won't tell you directly that the prerequisite was missing and will simply fail, leaving you to pour through a large install log to find the problem.<br />
<br />
If you're seeing this in your install log, it may be the same case:<br />
<br />
Always: :LaunchMSI: Setting rollback to true<br />[16:58:55]: Error: :LaunchMSI: MSI C:\SCOMSP1\Setup\AMD64\Server\OMServer.msi returned error 1603<br />
<br />
Check Christopher Keyaert's article for additional information and other troubleshooting steps.<br />
<br />
<a href="http://www.vnext.be/2013/01/24/scom-2012-sp1-omserver-msi-returned-error-1603/">http://www.vnext.be/2013/01/24/scom-2012-sp1-omserver-msi-returned-error-1603/</a>Dave Murphyhttp://www.blogger.com/profile/14038170973560613332noreply@blogger.com3tag:blogger.com,1999:blog-1807410337729170157.post-49472431747288415212013-02-11T09:46:00.003-08:002013-02-11T09:46:26.181-08:00Way to Mass Uninstall System Center Agents on Remote ComputersI needed to remove the agents on a number of computers and naturally, I wanted a quick way of doing so. I had a csv output from an active directory query but needed a way to use that to uninstall the agent. The following powershell script will allow you to do just so. It may or may not work on certain 2000 and 2003 installations. I am working on a script that works on all systems. In the mean time, here you go.<br />
<br />
$Servers="computer1","computer2", "computer3"<br />FOREACH ($TargetServer in $servers){(Get-WmiObject -Class Win32_Product -Filter "Name='System Center Operations Manager 2012 Agent'" -ComputerName $TargetServer ).Uninstall()}Dave Murphyhttp://www.blogger.com/profile/14038170973560613332noreply@blogger.com0tag:blogger.com,1999:blog-1807410337729170157.post-54124286861367542752013-02-11T09:42:00.001-08:002013-02-11T09:42:19.460-08:00Errors with SCOM 2012 SP1 Upgrade or InstallationUpgraded to SCOM 2012 SP1 last week and exposed an few errors for those who may have gone a little to fast in the installation. Chances are, if you are seeing the following errors, you may have forgotten to change the "Data Access Service" option during the upgrade to a domain account. If you leave it a service account, you will get the following errors post upgrade. Now, the good thing is, if you've done this and can no longer log into the management console, go back to your server, hunt down the System Center Data Access Service and change the login from "Local Service" to your data access account that was created during the original installation of System Center.<br />
<br />
Also, if you are starting from scratch with an SP1 installation, you will need to add trailing "\" back slashes on the SQL directories. If you do not, the Datawarehouse installation will likely fail and roll the entire installation back. So, when you perform the SQL server discovery during installation, the installer will find your data and log directories and populate them automatically as such:<br />
<br />
"D:\SQL Data"<br />
"L:\SQL Logs"<br />
<br />
You need to change these to the following format (obviously your drives and directories may differ)<br />
<br />
"D:\SQL Data\"<br />
"L:\SQL Logs\"<br />
<br />
And then your System Center Operations Manager 2012 SP1 installation should proceed.<br />
<br />
<br />
<strong>Errors you may encounter if you do not have a domain login for the Data Access account:</strong><br />
<br />
Inner Exception.Type: Microsoft.EnterpriseManagement.Common.ServiceNotRunningException, Exception Error Code: 0x80131604, Exception.Message: The Data Access service is either not running or not yet initialized. Check the event log for more information.<br />
Event 29120<br />
OpsMgr Management Configuration Service failed to process configuration request (Xml configuration file or management pack request) due to the following exception<br />
System.Runtime.Remoting.RemotingException: Unable to get ISdkService interface. Please make sure local Sdk Service is running.<br /> at Microsoft.EnterpriseManagement.ManagementConfiguration.Communication.CredentialDataProvider.CreateSdkConnector()<br />
<br />
Event 29195<br />
OpsMgr Management Configuration Service failed to communicate with System Center Data Access Service due to the following exception<br />
System.Runtime.Remoting.RemotingException: Unable to get ISdkService interface. Please make sure local Sdk Service is running.<br />
<br />Event 26380<br />
The System Center Data Access service failed due to an unhandled exception. <br />The service will attempt to restart. <br />Exception: <br />
Microsoft.EnterpriseManagement.Common.SdkServiceNotInitializedException: The Data Access service has not yet initialized. Please try again.<br />
<br />
Event 26340<br />
System Center Data Access Service and/or System Center Management is unresponsive because Authorization Manager is unable to recover from database errors. Please restart services System Center Data Access Service and System Center Management.Dave Murphyhttp://www.blogger.com/profile/14038170973560613332noreply@blogger.com0tag:blogger.com,1999:blog-1807410337729170157.post-47414704407050687022012-12-27T10:55:00.003-08:002012-12-27T14:42:44.217-08:00Setup a Disk Report in SCOM 2012 (Part-3)<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;">Finally got around to getting all the screen shots for the updated post for creating a more visually useful report. Now I don't have to make a new years resolution to get it done.</span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"></span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;">Recall in Part-2 of Setting up a Logical Disk Report for SCOM 2012 that a new view was created to make life a little easier. It was named “vCustomHourlyLogicalDiskPerf”. We will continue to use this view in the design of our updated, color-coded report. I was going to switch over to Visual Studio for this update, but decided to stick with Report Builder 3.0, which is a tool that comes with SQL or can be downloaded for free.</span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"></span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;">I will be more to the point with this post since I have covered other topics in parts one and two. Please refer back to those if you get stuck here. I presume you have already created the SQL view, which this post will utilize and was created earlier in Part-2.</span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"></span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;">Open Microsoft Report Builder 3.0 and connect to your SQL server housing the Operations Manager data warehouse. Start with a blank report project.</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwnS84JhPoxWVQgeqUTwC07jcuFj_tl1GkxE6_AJOGSIqsqvwbsT7HS2c7GlYEjNaWBJeoh_4mfbpvR5cgg8BJlWVISdHZj6zb1RvP4kt_FOYx5UZuYTYLvljxepguYGj37_sesR8VgGc/s1600/SCOM-2012-Disk-Report-Image1.1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="235" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwnS84JhPoxWVQgeqUTwC07jcuFj_tl1GkxE6_AJOGSIqsqvwbsT7HS2c7GlYEjNaWBJeoh_4mfbpvR5cgg8BJlWVISdHZj6zb1RvP4kt_FOYx5UZuYTYLvljxepguYGj37_sesR8VgGc/s320/SCOM-2012-Disk-Report-Image1.1.jpg" width="320" /></a></div>
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"><br />In the blank report, go ahead and resize out to about 8 inches for width.</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpr1tzoSIem6ddJPSm-WL4kZ0x34i1_Zz5ce0hjN-wEdogI63zUtHYGvLtSXDtwLE2T3Le9RDKu5qCP9EwAaWw-lF0pX6cgD6IRTLqNRi5q_wrRl6rt6gTn3ThdiDEMytF09XbFeGJRrA/s1600/SCOM-2012-Disk-Report-Image1.2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="43" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpr1tzoSIem6ddJPSm-WL4kZ0x34i1_Zz5ce0hjN-wEdogI63zUtHYGvLtSXDtwLE2T3Le9RDKu5qCP9EwAaWw-lF0pX6cgD6IRTLqNRi5q_wrRl6rt6gTn3ThdiDEMytF09XbFeGJRrA/s320/SCOM-2012-Disk-Report-Image1.2.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEEuJiNhfxyHouQBbHtdHyiHP7yn0Je7LP_TddOBwOq3gWp80m-yKHObLWgyb3fgKviT0dtKsqxY4vikcgWxWzDLINDtkOKSW2zMUcm1TBoaUqCxHQ3wkEF4XkGdMj0Ekc6naeNDMV350/s1600/SCOM-2012-Disk-Report-Image1.3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a> </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEEuJiNhfxyHouQBbHtdHyiHP7yn0Je7LP_TddOBwOq3gWp80m-yKHObLWgyb3fgKviT0dtKsqxY4vikcgWxWzDLINDtkOKSW2zMUcm1TBoaUqCxHQ3wkEF4XkGdMj0Ekc6naeNDMV350/s1600/SCOM-2012-Disk-Report-Image1.3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a> </div>
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"><br />Let’s add a quick title. For this, we’ll call it “Less than 10% Free Logical Disk Report”<br />
</span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"></span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"></span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"></span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"></span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEEuJiNhfxyHouQBbHtdHyiHP7yn0Je7LP_TddOBwOq3gWp80m-yKHObLWgyb3fgKviT0dtKsqxY4vikcgWxWzDLINDtkOKSW2zMUcm1TBoaUqCxHQ3wkEF4XkGdMj0Ekc6naeNDMV350/s1600/SCOM-2012-Disk-Report-Image1.3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="90" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEEuJiNhfxyHouQBbHtdHyiHP7yn0Je7LP_TddOBwOq3gWp80m-yKHObLWgyb3fgKviT0dtKsqxY4vikcgWxWzDLINDtkOKSW2zMUcm1TBoaUqCxHQ3wkEF4XkGdMj0Ekc6naeNDMV350/s320/SCOM-2012-Disk-Report-Image1.3.jpg" width="320" /></a></div>
<br /><br />Now let’s add the datasource:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZYa0sFtt3Wzg83HUeQ-wi7xkBFihL4zfofYbIvzTHSsNcqwd_635X45SMbheuyK3U0yb-vBDEXbh95Uw99_1EpUO8HtWtwaLki21TbWH8aQZ5mxGPRxH0fEULTKyztvUzB5cpdRdE5Pg/s1600/SCOM-2012-Disk-Report-Image1.4.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZYa0sFtt3Wzg83HUeQ-wi7xkBFihL4zfofYbIvzTHSsNcqwd_635X45SMbheuyK3U0yb-vBDEXbh95Uw99_1EpUO8HtWtwaLki21TbWH8aQZ5mxGPRxH0fEULTKyztvUzB5cpdRdE5Pg/s1600/SCOM-2012-Disk-Report-Image1.4.jpg" /></a></div>
<br /><br /> <br />Select the “Use a connection embedded in my report” and enter the connection string to DataWarehouseMain</span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"></span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"></span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"></span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"></span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"></span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjb3txsZwGXcJ1QVdSWJaydpgQLhrcSDcAa_Q_Tf3BX6EyUUBhyphenhyphenZQiC6VZ87AeqN8enKezledbhX-fdvVV6bA0Fb3vkYokE7zdMDmVHaeMI-hVFCDRV1cR0iQyFUamApJzy0jArsrYiRaw/s1600/SCOM-2012-Disk-Report-Image1.5.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="235" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjb3txsZwGXcJ1QVdSWJaydpgQLhrcSDcAa_Q_Tf3BX6EyUUBhyphenhyphenZQiC6VZ87AeqN8enKezledbhX-fdvVV6bA0Fb3vkYokE7zdMDmVHaeMI-hVFCDRV1cR0iQyFUamApJzy0jArsrYiRaw/s320/SCOM-2012-Disk-Report-Image1.5.jpg" width="320" /></a></div>
<br />data source=<SQL DW Server>;initial catalog=OperationsManagerDW;Integrated Security=SSPI<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgT4mcPlqe-uytiFjuePJI9Z5Z-Glyj6ARke7QFPf1Ye9XCyzYPCi01Qe7OwQrfNQZ06HoTss7ZXKwL6bfbgFJ9reVIjviBK4QSUlNA1oajt1WTdFDwZIcEUDf5eUmmB736CEto9JtW5Ow/s1600/SCOM-2012-Disk-Report-Image1.6.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="235" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgT4mcPlqe-uytiFjuePJI9Z5Z-Glyj6ARke7QFPf1Ye9XCyzYPCi01Qe7OwQrfNQZ06HoTss7ZXKwL6bfbgFJ9reVIjviBK4QSUlNA1oajt1WTdFDwZIcEUDf5eUmmB736CEto9JtW5Ow/s320/SCOM-2012-Disk-Report-Image1.6.jpg" width="320" /></a></div>
<br />For the time being, change the credentials to “Use Current Windows User”. This will be changed after the report is complete, but use this for now in order to connect to the database and finish the report.<br />
<br />Now let us add a dataset:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj90vE3K1WbXyb_VNRcoq_XtMU425fo1-27C6cfuxTpxuw5BzEuv8tZuAzMStTBVoFkln8_ekbfZ4yw63LGXrUOKPcVNanbdrwFBe3tSV4i64g6FtdDN7JQEDNVyW42e7JtLlyN72tDLjY/s1600/SCOM-2012-Disk-Report-Image1.7.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj90vE3K1WbXyb_VNRcoq_XtMU425fo1-27C6cfuxTpxuw5BzEuv8tZuAzMStTBVoFkln8_ekbfZ4yw63LGXrUOKPcVNanbdrwFBe3tSV4i64g6FtdDN7JQEDNVyW42e7JtLlyN72tDLjY/s1600/SCOM-2012-Disk-Report-Image1.7.jpg" /></a></div>
<br /><br />We are going to do a slightly different dataset here than the one used in Part-2 of the series. For the purposes of this report, I want it to give me the status of disk space as of the last day. Since we’re trying to keep this simple and hack the code, we can run into accuracy issues with the construction of this report if more than one day of data is used. Additionally, I use this report each Friday so I know the disks that are currently having space issues so I can remediate the problems prior to the weekend and hopefully, avoid an outtage or after-hours call.<br />
<br />
Here is the select statement for this dataset. Notice, I am hard coding the dates here. No variables will have to be used when this report runs. This makes it fast to use and easy to schedule. Notice some of the exclusions in the last section of the query. I am specifically removing the “total” metric, which can add redundant data. I also remove volume links that may be reported by services such as clustering or exchange, but effectively have the same data as the logical disk link. I could also exclude servers here that I know I don’t care about but that might have monitoring data, such as a backup server, video server, etc.</span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;">DECLARE @Start_Date DATETIME<br />DECLARE @End_Date DATETIME<br />SET @Start_Date = DateAdd(d,-1,GETDATE())<br />SET @End_Date = GETDATE()</span><br />
<span style="font-family: Arial;"></span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;">select<br />[Total Disk Space],<br />[Free Megabytes],<br />[% Free Space],<br />InstanceName,<br />Path,<br />DateTime</span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"><br />from<br />(select CounterName, AverageValue,InstanceName, Path,DateTime <br /> FROM vCustomHourlyLogicalDiskPerf) AS SourceTable<br />PIVOT<br />(<br />AVG (AverageValue) FOR CounterName IN ([Total Disk Space],[Free Megabytes],[% Free Space])<br />) AS PivotTable<br />
<br />WHERE<br />DateTime >= @Start_Date AND<br />DateTime <= @End_Date AND<br />NOT InstanceName = '_Total' AND<br />NOT InstanceName Like '\\?\Volume%%' AND<br />[% Free Space] <= 10.00<br />
<br />
</span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"></span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"></span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"></span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"></span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkOzR54mvY6ZKJJCg5lkj62ej5PTE0LQG3_0oslSinF4GiYLu-EE4cpZ6XJfckFuAIJp5ZcqYLR4jrGmMWf2EttGSMna6sAqEudWD_dIveaRq9XIruK6GCT1iwkb5i6upi9rOZQY2518w/s1600/SCOM-2012-Disk-Report-Image1.8.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkOzR54mvY6ZKJJCg5lkj62ej5PTE0LQG3_0oslSinF4GiYLu-EE4cpZ6XJfckFuAIJp5ZcqYLR4jrGmMWf2EttGSMna6sAqEudWD_dIveaRq9XIruK6GCT1iwkb5i6upi9rOZQY2518w/s320/SCOM-2012-Disk-Report-Image1.8.jpg" width="313" /></a></div>
</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPzgNsDFb1WEAI3zbQrH1luP4bJRnJgEFG_r1Q6BgsBJuH9l1E4QAeuVaDNiCNCXvuyJ6qMmN44DQLcCeBi_hxbXGGF8jOKJIbiVDgerkTRldYLbSyRffvJnDtEqqCDF0xz-3EyMET7jc/s1600/SCOM-2012-Disk-Report-Image1.9.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a> </div>
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"><br />With the query complete, let’s get the report up and running. This report will include a status bar to visually show the disk space left as well as color coding to show really critical space issues in red and warnings in orange.<br />
<br />Start by inserting a matrix into the report fields. Just drag and drop the matrix onto the report itself and then reposition to the upper-left, just under the title</span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"></span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"></span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"></span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPzgNsDFb1WEAI3zbQrH1luP4bJRnJgEFG_r1Q6BgsBJuH9l1E4QAeuVaDNiCNCXvuyJ6qMmN44DQLcCeBi_hxbXGGF8jOKJIbiVDgerkTRldYLbSyRffvJnDtEqqCDF0xz-3EyMET7jc/s1600/SCOM-2012-Disk-Report-Image1.9.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPzgNsDFb1WEAI3zbQrH1luP4bJRnJgEFG_r1Q6BgsBJuH9l1E4QAeuVaDNiCNCXvuyJ6qMmN44DQLcCeBi_hxbXGGF8jOKJIbiVDgerkTRldYLbSyRffvJnDtEqqCDF0xz-3EyMET7jc/s1600/SCOM-2012-Disk-Report-Image1.9.jpg" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0BJKoIAWIvnZc1OLbSoL2vAOiIbG6DJAPGKOtbdKaC6m6stS_sXrgCEyc1ZALtQaKLpScFPF6ST9KkG-DrQiiCJVE1k6EWmXAbK8Y5cIGDabr6pghDORsyMmNWv-hz8ZAWr2UilK_mg0/s1600/SCOM-2012-Disk-Report-Image10.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="89" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0BJKoIAWIvnZc1OLbSoL2vAOiIbG6DJAPGKOtbdKaC6m6stS_sXrgCEyc1ZALtQaKLpScFPF6ST9KkG-DrQiiCJVE1k6EWmXAbK8Y5cIGDabr6pghDORsyMmNWv-hz8ZAWr2UilK_mg0/s320/SCOM-2012-Disk-Report-Image10.jpg" width="320" /></a></div>
<br />
<br />Grab the “Path” variable from the dataset and drag to the lower left corner of the matrix:<br /><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0AMVgXBrIU86D01MkLXGqiLc0mLvbWFEA3rabp_vH0t_ByGS0CnZN8NkvfZ6yC8vA6AOSFBFcuC6IAanUfY-gK_l0_8HnNY9lYC3w1amPLBnznWEzBnQN1MF4q98BZOSOii_3RXvPvFc/s1600/SCOM-2012-Disk-Report-Image11.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="139" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0AMVgXBrIU86D01MkLXGqiLc0mLvbWFEA3rabp_vH0t_ByGS0CnZN8NkvfZ6yC8vA6AOSFBFcuC6IAanUfY-gK_l0_8HnNY9lYC3w1amPLBnznWEzBnQN1MF4q98BZOSOii_3RXvPvFc/s320/SCOM-2012-Disk-Report-Image11.jpg" width="320" /></a></div>
</span><br />
<br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;">Next, add a child group to the “Row Groups”:</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiB6y05itmmsUIrBdJcsio0V78xDAleB9B2MOuo2oMjHfihgh8dV3nRbZTEgxleg40q7qN3OQTeWe5ihoDDdBbKfC9E_2J1I0NyxnzrwcCBqJuB2HhQNHBI1ReCTUECYSkoGfpqWb6dBYE/s1600/SCOM-2012-Disk-Report-Image12.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="134" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiB6y05itmmsUIrBdJcsio0V78xDAleB9B2MOuo2oMjHfihgh8dV3nRbZTEgxleg40q7qN3OQTeWe5ihoDDdBbKfC9E_2J1I0NyxnzrwcCBqJuB2HhQNHBI1ReCTUECYSkoGfpqWb6dBYE/s320/SCOM-2012-Disk-Report-Image12.jpg" width="320" /></a></div>
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"><br /><br />Add the “Instance Name to the row child group”<br />
</span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"></span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7xiMjFe32cqdCRXSMWxEr_jIYJ10ybA1_qhyLKSv4BeuBba-RabheqHDiiPsWQ4VlSx9vPkcegtxnMRN4Ln353Dl0lXHOAFHKvpFcrwxM48965dhVGNmh-o2XJ8JmwfqP4TDtjpeQock/s1600/SCOM-2012-Disk-Report-Image13.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="142" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7xiMjFe32cqdCRXSMWxEr_jIYJ10ybA1_qhyLKSv4BeuBba-RabheqHDiiPsWQ4VlSx9vPkcegtxnMRN4Ln353Dl0lXHOAFHKvpFcrwxM48965dhVGNmh-o2XJ8JmwfqP4TDtjpeQock/s320/SCOM-2012-Disk-Report-Image13.jpg" width="320" /></a></div>
<br /><br />On the third, remaining column, select the top of the column and right-click to add another column within the group. This needs to be repeated four times.</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBJBaJibNHkh94Ordzf8i_McZrLqqbs2ImPQ2sT9SUONmS93b_2zkGNnqC1QmZDVa1gnXE47ab_ap_s8ynVHmMvEc-In0gAjjs51yKjGWwyDO8nzyFq_JtKzXEz7ehjd_blWQvO3TK5xA/s1600/SCOM-2012-Disk-Report-Image14.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="176" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBJBaJibNHkh94Ordzf8i_McZrLqqbs2ImPQ2sT9SUONmS93b_2zkGNnqC1QmZDVa1gnXE47ab_ap_s8ynVHmMvEc-In0gAjjs51yKjGWwyDO8nzyFq_JtKzXEz7ehjd_blWQvO3TK5xA/s320/SCOM-2012-Disk-Report-Image14.jpg" width="320" /></a></div>
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;">Should now have something that looks like this:</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDfe33xC8U2NAvn4duikqZDUvmtkjMCpzwu6ZmZuiTixjBDmdBDFf5HVnAmDbZj_VOvzaBgDhIOQCm4crR2J2FR22wUvHXncNqyX0WN2IwAt6XqkNycWrGIQ_zp91oYHggUUxnYf5hwIc/s1600/SCOM-2012-Disk-Report-Image15.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="66" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDfe33xC8U2NAvn4duikqZDUvmtkjMCpzwu6ZmZuiTixjBDmdBDFf5HVnAmDbZj_VOvzaBgDhIOQCm4crR2J2FR22wUvHXncNqyX0WN2IwAt6XqkNycWrGIQ_zp91oYHggUUxnYf5hwIc/s320/SCOM-2012-Disk-Report-Image15.jpg" width="320" /></a></div>
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"><br /><br />We’ll need to split the top header. Right click on the top header to bring up the context menu and select “Split Cells”<br />
</span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"></span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkrvMBbLKfuTwyximHwrEPqordRC3funnVP0xM08EylqekO_Fz5VWoxvxp6IMnnIke36Pa-ZgGYkJQYXuSmJP-22IOhDrgiMVryLiJI4zTbsPZE0kuhulOpiIFMAwu6PABsG8Q-fytbu4/s1600/SCOM-2012-Disk-Report-Image16.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="241" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkrvMBbLKfuTwyximHwrEPqordRC3funnVP0xM08EylqekO_Fz5VWoxvxp6IMnnIke36Pa-ZgGYkJQYXuSmJP-22IOhDrgiMVryLiJI4zTbsPZE0kuhulOpiIFMAwu6PABsG8Q-fytbu4/s320/SCOM-2012-Disk-Report-Image16.jpg" width="320" /></a></div>
<br /><br />Now, in this order, drag and drop the total disk space, free disk space and % free metrics into the bottom of each column. Leave a space between “free disk space” Should look something like the following:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdpeQa-4nhkd6DKIqe7wsiqIY9D31KjNXBnWL6sXpHZvBGWKzPP79X1rUuky_Uvfpm7U0AGzeLtOegKoN6sBOMT2mkdG-xzlkfnVdbzMQg1bdyAZt-CXES3okXKS1c6t7GDlB0N1m0jg0/s1600/SCOM-2012-Disk-Report-Image17.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="50" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdpeQa-4nhkd6DKIqe7wsiqIY9D31KjNXBnWL6sXpHZvBGWKzPP79X1rUuky_Uvfpm7U0AGzeLtOegKoN6sBOMT2mkdG-xzlkfnVdbzMQg1bdyAZt-CXES3okXKS1c6t7GDlB0N1m0jg0/s320/SCOM-2012-Disk-Report-Image17.jpg" width="320" /></a></div>
<br /><br />This isn’t very handy, since we don’t want the sum of these metrics. So we’ll want to adjust each field, starting with “Total Disk”, right click on the field and select the “expression” option.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidKcIzRICsaqsDGzDPCnNxVoiExewR9rDHUSz9zMdHNuYIyGWnSH6YkUEimAepQLJv3qN9_T0UvQlChKAlsWeWY9nDsZtY-iuMPEf-NedxD6_c0B5prasBZIo4VVHT46I-YSZSJLketm0/s1600/SCOM-2012-Disk-Report-Image18.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidKcIzRICsaqsDGzDPCnNxVoiExewR9rDHUSz9zMdHNuYIyGWnSH6YkUEimAepQLJv3qN9_T0UvQlChKAlsWeWY9nDsZtY-iuMPEf-NedxD6_c0B5prasBZIo4VVHT46I-YSZSJLketm0/s1600/SCOM-2012-Disk-Report-Image18.jpg" /></a></div>
<br />
<br />Let’s change this to the actual value along with converting it into Gigabytes, from the default Megabytes.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyTYv96N8j0m9UTgEr_-ruhQL16-Hs5PAaHs1lahqK9eU1T_7V5C8KjfhfaMgWOomkxaCKRL91T7t6iyTOmkwqW3LX3TtYJivKf61l1528X6dfZVETmCM7FAbF_n16WRkOXqyL8gsZXuY/s1600/SCOM-2012-Disk-Report-Image19.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="290" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyTYv96N8j0m9UTgEr_-ruhQL16-Hs5PAaHs1lahqK9eU1T_7V5C8KjfhfaMgWOomkxaCKRL91T7t6iyTOmkwqW3LX3TtYJivKf61l1528X6dfZVETmCM7FAbF_n16WRkOXqyL8gsZXuY/s320/SCOM-2012-Disk-Report-Image19.jpg" width="320" /></a></div>
<br />
<br />Now do the same with free space.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPb8O4i4gZKGsSNBR4eU3WyOIUx1Zrr7MznRgFGfdtw_1o5UM-P-cdY_ziI-mcD7RKNG3YhTDRdI1mw0aH7b4YRQmBr0BMeDj88MU0ecuvTA2B8IY-tZZkzc_XcTxNOdhhxIVcjUfocqY/s1600/SCOM-2012-Disk-Report-Image20.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="290" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPb8O4i4gZKGsSNBR4eU3WyOIUx1Zrr7MznRgFGfdtw_1o5UM-P-cdY_ziI-mcD7RKNG3YhTDRdI1mw0aH7b4YRQmBr0BMeDj88MU0ecuvTA2B8IY-tZZkzc_XcTxNOdhhxIVcjUfocqY/s320/SCOM-2012-Disk-Report-Image20.jpg" width="320" /></a></div>
<br /><br />For the next field, which is blank, we’ll call it used disk space Used (GB). Here, we’ll use a calculated field. We could have done this in the SQL query itself, but I chose to do this differently. The expression here should include the total disk space minus the free disk space.<br />
<br />
=(Fields!Total_Disk_Space.Value-Fields!ID__Free_Space.Value)/1000<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnyemJ0il_Ky6sG6UYntmWNFTSP-_uhBUGOBDr9mK61xEY6FKyBd_FD9RGcmrINUV97BM22gQFm3ITkOdZODXOXJcDJ-x6zihPkE4j5vuaHFjQ7BRpGlQfQE6Ax2_F7uV34ut45EIB5Cg/s1600/SCOM-2012-Disk-Report-Image21.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="290" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnyemJ0il_Ky6sG6UYntmWNFTSP-_uhBUGOBDr9mK61xEY6FKyBd_FD9RGcmrINUV97BM22gQFm3ITkOdZODXOXJcDJ-x6zihPkE4j5vuaHFjQ7BRpGlQfQE6Ax2_F7uV34ut45EIB5Cg/s320/SCOM-2012-Disk-Report-Image21.jpg" width="320" /></a></div>
<br /><br />Then finally on to percent free space.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjS80F6QJFiCGZKNSEAqSyftOHZjkxUtRQrR7F8HtjSTCcNUT-YxZWPsAuZWVIHm9t8ucCaVP_jiSp_Ha0Az65byw3Muz44Ew45Vu4BExbDLurgT8WYkgAXys3aErWAd7xbiHrjzuSl3Hg/s1600/SCOM-2012-Disk-Report-Image22.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="290" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjS80F6QJFiCGZKNSEAqSyftOHZjkxUtRQrR7F8HtjSTCcNUT-YxZWPsAuZWVIHm9t8ucCaVP_jiSp_Ha0Az65byw3Muz44Ew45Vu4BExbDLurgT8WYkgAXys3aErWAd7xbiHrjzuSl3Hg/s320/SCOM-2012-Disk-Report-Image22.jpg" width="320" /></a></div>
<br /><br />For this field, we are going to add a color coding mechanism. Right click on the ID_Free_space and select the “Text Box Properties”<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmOGh5bpoEhP6Pkb6PmQJvVlf_j85gw9cHd9A1kOhoO8sTY_o-JxTkXrkUJM-belw8PoWCzYK6ZsvQXjrfPuVT4wrhNeT2hIy0F2FROTn-roP72k1oZ7IPjX5DHwQSw7h-V-U4q_oMI-M/s1600/SCOM-2012-Disk-Report-Image23.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmOGh5bpoEhP6Pkb6PmQJvVlf_j85gw9cHd9A1kOhoO8sTY_o-JxTkXrkUJM-belw8PoWCzYK6ZsvQXjrfPuVT4wrhNeT2hIy0F2FROTn-roP72k1oZ7IPjX5DHwQSw7h-V-U4q_oMI-M/s1600/SCOM-2012-Disk-Report-Image23.jpg" /></a></div>
<br /><br />Navigate to Font, and select the expression applet next to color.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqUbt_Yoeh3Wpy57FniNxb_l_4bqNmKilTRFGilQ-w88W_Fb4c9gWJdYqRfRN1CNT56RffrRmQMzIqc58iOKIgHoFWSbGmYrDRsp58jXFmmzfNbMc5xy9f1vd0oyKkg27k15Mbonkufow/s1600/SCOM-2012-Disk-Report-Image24.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="291" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqUbt_Yoeh3Wpy57FniNxb_l_4bqNmKilTRFGilQ-w88W_Fb4c9gWJdYqRfRN1CNT56RffrRmQMzIqc58iOKIgHoFWSbGmYrDRsp58jXFmmzfNbMc5xy9f1vd0oyKkg27k15Mbonkufow/s320/SCOM-2012-Disk-Report-Image24.jpg" width="320" /></a></div>
<br /><br />Add the following expression in the "Color" field</span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"><br />=IIF(Fields!ID__Free_Space.Value >= 10, "Green", IIF(Fields!ID__Free_Space.Value >= 5, "Orange", "Red"))<br />
<br />What this is saying is, any field greater than 10% free space will show up as green, otherwise, anything between 10 and 5 will turn orange and anything under 5 will turn red. If this report had not been limited already to items under 10%, it would have made the corresponding report much easier to figure out which items were critical.<br />
<br /> <br />
Under the “Insert” menu item in the report builder, select “Gauge” and then select the lower-right, empty column, to insert the visual gauge for free space.<br />
</span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"></span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi05Izl-PLYSu6IHKRAmBUMZb3vlahRHVWhYenf8rWN00IS2yLtBsAR-8anIn6TRaauFuI5ks-H_cmKfxQiGKNoHh-nwfX4NdhPFLkY2oczpUGEjPVpCLT_UwlsWTL69tnp-xfGINZzEes/s1600/SCOM-2012-Disk-Report-Image25.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="203" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi05Izl-PLYSu6IHKRAmBUMZb3vlahRHVWhYenf8rWN00IS2yLtBsAR-8anIn6TRaauFuI5ks-H_cmKfxQiGKNoHh-nwfX4NdhPFLkY2oczpUGEjPVpCLT_UwlsWTL69tnp-xfGINZzEes/s320/SCOM-2012-Disk-Report-Image25.jpg" width="320" /></a></div>
<br /><br />We’ll choose the “Bullet Graph” under linear gauges.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhknP1xkg88KVzoa4mOckQXjWZXEEGERJ7VDclKmrXcUSp0cHezJNe3dxKQULkUi1_nvsHMtiaC9qJ7IBrjKJWu9Yplv0Sicf6s3tWU7zjhoCsOOg0oXqytFFfjSiy7jsi5ErO7T0OUX3o/s1600/SCOM-2012-Disk-Report-Image26.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="283" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhknP1xkg88KVzoa4mOckQXjWZXEEGERJ7VDclKmrXcUSp0cHezJNe3dxKQULkUi1_nvsHMtiaC9qJ7IBrjKJWu9Yplv0Sicf6s3tWU7zjhoCsOOg0oXqytFFfjSiy7jsi5ErO7T0OUX3o/s320/SCOM-2012-Disk-Report-Image26.jpg" width="320" /></a></div>
<br /><br />Double-click on the gauge and for the “LinearPointer1” values, select the “ID_Free_Space” field and then delete “LinearPointer2”. The gauge will also want to sum up the values. Go back to the expression and remove the SUM option.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipGET7Hwu0_opqnNlKpfAJFr-izLw_Kacx2aCotbnbdWHy_WYC62_dQEfmCECWZ1weN6dyEjrJex5s2KaapeOv7d8q84WgR8rIvOsy4X2Oh-4bGhoz-oCh_iTGPWIPv3fpd3-_Bd1Yo94/s1600/SCOM-2012-Disk-Report-Image27.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="123" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipGET7Hwu0_opqnNlKpfAJFr-izLw_Kacx2aCotbnbdWHy_WYC62_dQEfmCECWZ1weN6dyEjrJex5s2KaapeOv7d8q84WgR8rIvOsy4X2Oh-4bGhoz-oCh_iTGPWIPv3fpd3-_Bd1Yo94/s320/SCOM-2012-Disk-Report-Image27.jpg" width="320" /></a></div>
<br /><br />For the gauge, we’ll want similar fill options to our numerical values. Select the small line in the gauge, then right-click and select the “Pointer Properties”.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmuIBzrMfi_r3Dsqy4PAVl6tsCzBIJN7VetborYgDplCHgSKT38M-aY1gb3m-YuW1gDZCXDnNlDN7XnztfL0ePC1Ojeg6rrrumxJVomNsnqq8L_zCrqV_vwL6sL1hCehvwLknnUABtCzs/s1600/SCOM-2012-Disk-Report-Image28.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="256" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmuIBzrMfi_r3Dsqy4PAVl6tsCzBIJN7VetborYgDplCHgSKT38M-aY1gb3m-YuW1gDZCXDnNlDN7XnztfL0ePC1Ojeg6rrrumxJVomNsnqq8L_zCrqV_vwL6sL1hCehvwLknnUABtCzs/s320/SCOM-2012-Disk-Report-Image28.jpg" width="320" /></a></div>
<br /><br />Select the “Pointer Fill” option and adjust the expression for the “Color” and “Secondary Color” with the following expression.<br />
<br />=IIF(Fields!ID__Free_Space.Value >= 10, "Green", IIF(Fields!ID__Free_Space.Value >= 5, "Orange", "Red"))<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDtI1ztYPD4EUoDTbLKsGDRuKjlF5Ahyphenhyphen8kqzXwBbqYiZ-W0No4-Fjxky90z5I2YwlainKh_jB1pIkSmiipXJ-6gMuLjdslvzMjZvioau-Z5FCiEEpiWsA_wMFIrxtxLYtcWwn98huOxLg/s1600/SCOM-2012-Disk-Report-Image29.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="290" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDtI1ztYPD4EUoDTbLKsGDRuKjlF5Ahyphenhyphen8kqzXwBbqYiZ-W0No4-Fjxky90z5I2YwlainKh_jB1pIkSmiipXJ-6gMuLjdslvzMjZvioau-Z5FCiEEpiWsA_wMFIrxtxLYtcWwn98huOxLg/s320/SCOM-2012-Disk-Report-Image29.jpg" width="320" /></a></div>
<br /><br />Adjust the column widths and get things all squared up. Now your report should look something like this:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjK2tr4c__P9aWUSPblFmUjIN5fryCXMcxvYlIHLcFwZhMRX13PcljhSlbAzSvUE6YFbfGw50qzAshtiF6zf_HUwFZYG-KN44mD3KvsOlmqflgi7t3idRevTEgdusQ23_Njej1nLqKYwfY/s1600/SCOM-2012-Disk-Report-Image30.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="65" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjK2tr4c__P9aWUSPblFmUjIN5fryCXMcxvYlIHLcFwZhMRX13PcljhSlbAzSvUE6YFbfGw50qzAshtiF6zf_HUwFZYG-KN44mD3KvsOlmqflgi7t3idRevTEgdusQ23_Njej1nLqKYwfY/s320/SCOM-2012-Disk-Report-Image30.jpg" width="320" /></a></div>
<br /><br />Now go back to the properties of DataWarehouseMain and change the credentials back to “Do not use Credentials”<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIVK3uTe1ccd2dhu_iq25oJc69AAu57GbgolkPHqo0wXhBkv5HiNQnSETqD2nklx3hzXsmBJ47LiOpzoRwgRBRgvYa3lr0s1mHnFr9nihn_jt3pm8xIBphwFhN9e74FPROL8GYYF954kU/s1600/SCOM-2012-Disk-Report-Image31.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="235" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIVK3uTe1ccd2dhu_iq25oJc69AAu57GbgolkPHqo0wXhBkv5HiNQnSETqD2nklx3hzXsmBJ47LiOpzoRwgRBRgvYa3lr0s1mHnFr9nihn_jt3pm8xIBphwFhN9e74FPROL8GYYF954kU/s320/SCOM-2012-Disk-Report-Image31.jpg" width="320" /></a></div>
<br /><br />Now save the report to the SCOM reporting server.<br />
<br /> <br />The report is almost ready to be completed and viewed. Login to the web interface of the report server. <br />
<br />
Usually with the syntax of</span><span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;">http://<rep</span><span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;">ort</span><span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"><span style="color: #0066cc;"> </span></span><span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;">server>/Reports. </span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"></span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;">Select the "Details View" and look for the DataWarehouseMain object and select it. Go into the object properties and copy the selection string. Now find the report you just created, and select the manage option in the drop down menu.</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhUOZRa7zc7v8V5Bf04KHKHyT7_TIGjZUcscfdyQNKH4zcfJXtiBr_eKv1Eu3ZoT49jb4I26EY72SKZyYrXM3DJ7W1nIlugjN0M1E8vT5-1zqfuEfatMJ6JFzOc_65N3cCVRV_tI3N9oYc/s1600/SCOM-2012-Disk-Report-Image32.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="212" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhUOZRa7zc7v8V5Bf04KHKHyT7_TIGjZUcscfdyQNKH4zcfJXtiBr_eKv1Eu3ZoT49jb4I26EY72SKZyYrXM3DJ7W1nIlugjN0M1E8vT5-1zqfuEfatMJ6JFzOc_65N3cCVRV_tI3N9oYc/s320/SCOM-2012-Disk-Report-Image32.jpg" width="320" /></a></div>
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"><br /><br />Go to the “Data Sources” tab for the report and delete the existing connection string and replace with the one copied from DataWarehouseMain. Also ensure that “Credentials are not required” is selected. Apply the changes. <br />
</span><span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"></span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;">You should now be able to run the report. Depending on the cleanup you did in the report format, you may need to go back and make some changes. In my example, I did not adjust the numerical formatting for each text field and ended up with too many decimals in the fields. So long as you are only changing text field properties, you should be able to save the report without altering any connection string settings.</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOWzXZat0YpiqHmqCuMNyuEhiJGAo1lWwW5Uo0P0HIVUBdpp5hQWDYqYaGbFpF0P1kHGyX0syftGHMrzTFVStXJgalUUz0Kl-CuVwgjTOV0QgQKKCOm13idfjWoVgdTDK7t2y3rusOe7k/s1600/SCOM-2012-Disk-Report-Image33.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="43" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOWzXZat0YpiqHmqCuMNyuEhiJGAo1lWwW5Uo0P0HIVUBdpp5hQWDYqYaGbFpF0P1kHGyX0syftGHMrzTFVStXJgalUUz0Kl-CuVwgjTOV0QgQKKCOm13idfjWoVgdTDK7t2y3rusOe7k/s320/SCOM-2012-Disk-Report-Image33.jpg" width="320" /></a></div>
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"><br /><br />To correct this, open a text box property, select the “Number” tab and change the format to “Number” with 2 decimal places.<br />
</span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"></span><br />
<span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;"><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1_UlOSjIQFM_MmQOfgM4khJ_rzIuFHT2gA84JrG1Lx_kCEGBKAEq9aBoDtlNbzLpk2NDk4mxanA4Vl2MP1n0YDp0y_DJvBoSJFLWxaH1kt-ix2CS1MsQ_7busMBfxK6udDX-_nE4_24w/s1600/SCOM-2012-Disk-Report-Image34.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1_UlOSjIQFM_MmQOfgM4khJ_rzIuFHT2gA84JrG1Lx_kCEGBKAEq9aBoDtlNbzLpk2NDk4mxanA4Vl2MP1n0YDp0y_DJvBoSJFLWxaH1kt-ix2CS1MsQ_7busMBfxK6udDX-_nE4_24w/s1600/SCOM-2012-Disk-Report-Image34.jpg" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZzGSH1J8qOHKixqqjXuACldWVc1dbbCBTh41HSec1gg8f6wSr8Dz2qty09xLvmJn2M42KhkooQgUN9_M9KIRAb7q70O5BMQHbzBOzIobnPC0GE2pv9ORWT5Mn3Q-bM29wcxgpuVH1vP8/s1600/SCOM-2012-Disk-Report-Image35.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="291" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZzGSH1J8qOHKixqqjXuACldWVc1dbbCBTh41HSec1gg8f6wSr8Dz2qty09xLvmJn2M42KhkooQgUN9_M9KIRAb7q70O5BMQHbzBOzIobnPC0GE2pv9ORWT5Mn3Q-bM29wcxgpuVH1vP8/s320/SCOM-2012-Disk-Report-Image35.jpg" width="320" /></a></div>
<br /><br /><br />Now the output looks like this, which is much better:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi__fC368RGimi2zkNSVVR3dHwQIO93wxAe0rFCqM0j6RQEtcAEGQ56Nomb07PjsZnbO9sOWq_odhIZ9Oyx-K0TSFTBEsirOKSYAPrarqDn95sOVBE0IbBYksdJzPYKMS4PWlbivZfTafE/s1600/SCOM-2012-Disk-Report-Image36.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="49" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi__fC368RGimi2zkNSVVR3dHwQIO93wxAe0rFCqM0j6RQEtcAEGQ56Nomb07PjsZnbO9sOWq_odhIZ9Oyx-K0TSFTBEsirOKSYAPrarqDn95sOVBE0IbBYksdJzPYKMS4PWlbivZfTafE/s320/SCOM-2012-Disk-Report-Image36.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHDj1oHLiGHDbpaAF9MkUud3pVoJBy4mjVyUjzP4EotjidxCBKjWD_1-c3P3WcUn6dshFPrZuONgZ-dQrHHt_NkgPW9FF-ECqIrwoD3p9uJy4b3N9P0k0lTDNFMfgcuE6yOdipq10edZo/s1600/SCOM-2012-Disk-Report-Image37.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="39" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHDj1oHLiGHDbpaAF9MkUud3pVoJBy4mjVyUjzP4EotjidxCBKjWD_1-c3P3WcUn6dshFPrZuONgZ-dQrHHt_NkgPW9FF-ECqIrwoD3p9uJy4b3N9P0k0lTDNFMfgcuE6yOdipq10edZo/s320/SCOM-2012-Disk-Report-Image37.jpg" width="320" /></a></div>
<br /><br /><br />Good luck and happy report writing. There is a little bit of everything in this post and hopefully this helps get you started with additional techniques.</span><br />Dave Murphyhttp://www.blogger.com/profile/14038170973560613332noreply@blogger.com12tag:blogger.com,1999:blog-1807410337729170157.post-84968024576819133892012-11-26T11:45:00.002-08:002012-12-27T14:12:59.804-08:00SCOM Exchange Management Pack PitfallWell this was certainly a fun one to track down. Again, being my week on call and it being a holiday, there was no rest for the wicked apparently. The problems actually surfaced earlier in the week but then reared their head again on Saturday. If you get into this situation, there will be what seems to be random issues with exchange, queues shutting down, mailboxes getting disconnected. All sorts of weird stuff. I'll explain more after the errors. Here are some of the error messages we started receiving in the email queue and the exchange event logs. <br />
<br />
***************************************************<br />
<div class="MsoPlainText" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">Alert: The database copy is very low on log volume space.
The volume has reached critical levels.<o:p></o:p></span></div>
<br />
<div class="MsoPlainText" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">Source: Database Copy (log) Logical Disk Space (D:\DB1) -
<server> (Mailbox) - </span></div>
<div class="MsoPlainText" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;"></span> </div>
<div class="MsoPlainText" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">Path: <server>; <server>(Mailbox) -
Last modified by: System Last modified time: 11/24/2012 10:33:24 AM
Alert description: TimeSampled: 2012-11-24T10:32:45.0000000-08:00<o:p></o:p></span></div>
<br />
<div class="MsoPlainText" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">ObjectName: LogicalDisk<o:p></o:p></span></div>
<br />
<div class="MsoPlainText" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">CounterName: % Free Space<o:p></o:p></span></div>
<br />
<div class="MsoPlainText" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">InstanceName: D:\DB1<o:p></o:p></span></div>
<br />
<div class="MsoPlainText" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">Value: 4<o:p></o:p></span></div>
<br />
<div class="MsoPlainText" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">SampleValue: 11.9463672637939<o:p></o:p></span></div>
<br />
<div class="MsoPlainText" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">Knowledge: </span><a href="http://go.microsoft.com/fwlink/?LinkID=67336&id=10a2b32c-b844-44f1-b750-d5150e0b249c"><span style="color: blue; font-family: Calibri;">http://go.microsoft.com/fwlink/?LinkID=67336&id=10a2b32c-b844-44f1-b750-d5150e0b249c</span></a><o:p></o:p></div>
<br />
***************************************************<br />
Log Name: Microsoft-Exchange-Troubleshooters/Operational<br />
Source: Database Space<br />
Date: 11/23/2012 4:27:32 PM<br />
Event ID: 5701<br />
Task Category: (1)<br />
Level: Error<br />
Keywords: Classic<br />
User: N/A<br />
Computer: <servername><br />
Description:<br />
The database space troubleshooter detected a low space condition on volume D:\DB1\ for database DB1. Provisioning for this database has been disabled. Database is under 16% free space.<br />
***************************************************<br />
<br />
Now let's pull the curtains back a bit and find out what's going on here. There are several things involved. First, Exchange 2010 has a powershell script called troubleshoot-databasespace.ps1. Without SCOM, this script would be called manually. The Exchange management pack, however, calls it automatically. More details can be found here - <a href="http://letsexchange.blogspot.com/2012/09/exchange-2010-sp1-added-new-script.html">http://letsexchange.blogspot.com/2012/09/exchange-2010-sp1-added-new-script.html</a><br />
<br />
Troubleshoot-databasespace.ps1 refers to a file that has the limits set to gauge the database health. Here are the default constants in the file, StoreTSConstants.ps1:<br />
<br />
There were found in the \Exchange14\Scripts folder<br />
<br />
# The percentage of disk space for the EDB file at which we should start quarantining users.<br />
$PercentEdbFreeSpaceDefaultThreshold = 25<br />
# The percentage of disk space for the logs at which we should start quarantining users.<br />
$PercentLogFreeSpaceDefaultThreshold = 25<br />
# The percentage of disk space for the EDB file at which we are at alert levels.<br />
$PercentEdbFreeSpaceAlertThreshold = 16<br />
# The percentage of disk space for the EDB file at which we are at critical levels.<br />
$PercentEdbFreeSpaceCriticalThreshold = 8<br />
<br />
So, in our case, we have a 600 Gb lun and were down to roughly 12% of our space, falling below the alert levels set by default, but still had 72Gb of storage left. So exchange went into alert mode. We started receiving issues of users not being able to connect to exchange or unable to send messages but still able to receive them. Very strange stuff. I changed the values to start alerting at 5% and then put the servers in maintenance mode to get over the immediate issue.<br />
<br />
So, don't get caught in the Exchange Management Pack trap. Ensure you set these levels to something that makes sense. Unlike the SCOM disk alerts that have a two factor calculation mechanisms, this is the old-fashioned percentage calculation, making it very easy to get bit on large volumes. The other option is that you turn off these monitors. Given the space monitoring is somewhat redundant with the SCOM disk space alerts, that may be a safer alternative.<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />Dave Murphyhttp://www.blogger.com/profile/14038170973560613332noreply@blogger.com1tag:blogger.com,1999:blog-1807410337729170157.post-2255160860940622032012-11-23T13:40:00.001-08:002012-12-27T14:14:17.508-08:00Using Monitors for Automated Disk Space RecoveryThought I would do a new post today. It's the day after Thanksgiving and guess who drew the after-hours phone a monitoring ticket this week? So, bunch of disk space monitors came in and I decided I didn't want to have to respond to them, especially since I will have after-hours duties during Christmas as well, lucky me.<br />
<br />
So the concept I'll illustrate here is to have SCOM take automated actions to clean-up drive space on its own, hopefully averting an impending disaster and the need for you to get up from your peaceful slumber, camping trip or whatever it is you do when you try to have a life outside of daily IT tasks.<br />
<br />
As with any Microsoft product, there are about a dozen ways to do this. I give you probably the simplest way, but long term would probably be difficult to maintain in a large server environment. I'll improve on this and post any updates when I do.<br />
<br />
First, let us start by creating a folder on the root drive of a target server. I called the folder "C:\Scripts". Create a batch file in the folder. I called mine "cleanup.bat"<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGoJ9uTVj48AnnCRJhAsG_JBNj6Fj4Fq7uq-SMtyBcpzKBy9LwlSUhw7BhnS9IjOYL-FISE3yWlr0UZQPzV4kV6Nd0YOZJNIHyYoviodVl-wDrfgGCg-RenJsjJeem1omQtbyGy2Ni4Z8/s1600/disk+cleanup-1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="System Center 2012 SCOM Disk Cleanup Script Folder" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGoJ9uTVj48AnnCRJhAsG_JBNj6Fj4Fq7uq-SMtyBcpzKBy9LwlSUhw7BhnS9IjOYL-FISE3yWlr0UZQPzV4kV6Nd0YOZJNIHyYoviodVl-wDrfgGCg-RenJsjJeem1omQtbyGy2Ni4Z8/s1600/disk+cleanup-1.jpg" title="System Center 2012 SCOM Disk Cleanup Script Folder" /></a></div>
<br />
<br />
I have included the contents of the sample script. It is pretty basic, essentially clearing out temporary files in a variety of locations.
This could certainly be expanded to remove old IIS or Blackberry log files, remove SQL backups, etc. Any action that can be scripted can essentially be run here.<br />
<br />
<br />
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Courier; font-size: 8pt; line-height: 115%;">del C:\Temp\*.* /s /q</span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Courier; font-size: 8pt; line-height: 115%;">del %Windir%\Temp /s /q</span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Courier; font-size: 8pt; line-height: 115%;">IF EXIST "C:\Users\" (</span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Courier; font-size: 8pt; line-height: 115%;"><span style="mso-spacerun: yes;"> </span>for /D %%x in
("C:\Users\*") do ( </span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Courier; font-size: 8pt; line-height: 115%;"><span style="mso-spacerun: yes;"> </span>del /f /s /q
"%%x\AppData\Local\Temp\" </span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Courier; font-size: 8pt; line-height: 115%;"><span style="mso-spacerun: yes;"> </span>del /f /s /q
"%%x\AppData\Local\Microsoft\Windows\Temporary Internet Files\" </span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Courier; font-size: 8pt; line-height: 115%;"><span style="mso-spacerun: yes;"> </span>)</span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Courier; font-size: 8pt; line-height: 115%;">)</span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Courier; font-size: 8pt; line-height: 115%;">IF EXIST "C:\Documents and Settings\" (</span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Courier; font-size: 8pt; line-height: 115%;"><span style="mso-spacerun: yes;"> </span>for /D %%x in
("C:\Documents and Settings\*") do (</span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Courier; font-size: 8pt; line-height: 115%;"><span style="mso-spacerun: yes;"> </span>del /f /s /q
"%%x\Local Settings\Temp\"</span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Courier; font-size: 8pt; line-height: 115%;"><span style="mso-spacerun: yes;"> </span>del /f /s /q
"%%x\Local Settings\Temporary Internet Files\"</span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Courier; font-size: 8pt; line-height: 115%;"><span style="mso-spacerun: yes;"> </span>)</span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Courier; font-size: 8pt; line-height: 115%;">)<o:p></o:p></span></div>
With the script loaded on the target server, go to your SCOM management console and navigate to the authoring tab and then select the "Monitors" option.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgiqQhsg3aN6loN1C4f9pmyuJnaLizodcRj2JiaMKnzDMHQa4-KBwl767yzYCsRTA-G9azHqtq0Sj2JuF0qRuds1nd_RlzfNbVRBFzcTyoM9SrUyyRBuV82CEkSTp0OEPQR2OVi-ZmO88U/s1600/disk+cleanup-2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgiqQhsg3aN6loN1C4f9pmyuJnaLizodcRj2JiaMKnzDMHQa4-KBwl767yzYCsRTA-G9azHqtq0Sj2JuF0qRuds1nd_RlzfNbVRBFzcTyoM9SrUyyRBuV82CEkSTp0OEPQR2OVi-ZmO88U/s1600/disk+cleanup-2.jpg" /></a></div>
<br />
<br />
After the monitors all load, in th search field, type in "Logical Disk" to narrow the monitors. Once the search finishes, you can then select one of the Logical Disk Free Space monitors, such as Windows Server 2000, Windows Server 2003 or Windows Server 2008. I chose to alter the settings for the Windows Server 2008 Logical Disk Free Space monitor. Right-click on the Logical Disk Free Space monitor and select "Properties".<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9iEOncVWAcqPQHd_E6RgZtuXNAWdIHam2EX1r-tTFToaLYWRkK0wMUJLPU3DVU8H40nytwoGndpQx_FL0lgLaesxW9kgSu7YZbZVJrPPFC0wrPiu2RXSper1WtpJv3ZyMUcDTxPPWgJA/s1600/disk+cleanup-3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9iEOncVWAcqPQHd_E6RgZtuXNAWdIHam2EX1r-tTFToaLYWRkK0wMUJLPU3DVU8H40nytwoGndpQx_FL0lgLaesxW9kgSu7YZbZVJrPPFC0wrPiu2RXSper1WtpJv3ZyMUcDTxPPWgJA/s320/disk+cleanup-3.jpg" title="System Center 2012 SCOM Logical Disk Free Space Properties" /></a></div>
<br />
<br />
Navigate to the "Diagnostic and Recovery" tab. Here, we will want to add a recovery task. You can put in the same task for both warning and critical recovery tasks if you like.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjotxozcKclbrixNAnaGqv4YyWMRZuEMx3xIvfiWizpRLX5eB2WvbriCUbe9Wj0Z-89dYbjo0_YRgtJcMpEgDiSa0WabJ3D7jMGanQmI8z_bBXJmw3Rl7qMTMMtyvep9uYVv-kTLU4Apho/s1600/disk+cleanup-4.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjotxozcKclbrixNAnaGqv4YyWMRZuEMx3xIvfiWizpRLX5eB2WvbriCUbe9Wj0Z-89dYbjo0_YRgtJcMpEgDiSa0WabJ3D7jMGanQmI8z_bBXJmw3Rl7qMTMMtyvep9uYVv-kTLU4Apho/s320/disk+cleanup-4.jpg" width="308" /></a></div>
<br />
In the "Recovery Task Type", select "Run Command" and change the destination management pack to either the default client overrides or an alternate management pack you might have for such customizations.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCU3K870jLeBTET1T31PIEkgihDB_Ki5ZG8YOBXrJq9o5Jyclt_6n_63CD9un1WcPAG0rfQXjBnCmo_ZcAJeMp_RIfJj6vdh3g-WW4P4KcdUrZzmX6Sq1n4H5GYS1nUa2veK7sGe46HGk/s1600/disk+cleanup-5.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="272" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCU3K870jLeBTET1T31PIEkgihDB_Ki5ZG8YOBXrJq9o5Jyclt_6n_63CD9un1WcPAG0rfQXjBnCmo_ZcAJeMp_RIfJj6vdh3g-WW4P4KcdUrZzmX6Sq1n4H5GYS1nUa2veK7sGe46HGk/s320/disk+cleanup-5.jpg" width="320" /></a></div>
<br />
On the next section, give the recovery task a name that makes sense. You can choose to have the system recalculate the monitor. If disk space falls back into the norm, the alert will clear itself automatically.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9jsp1o4rkzkxFmqNT4Zifr_YtfX_NaFJdCjffk7gClS67OZNcmaKPRK0FSYF7HW2Um82mXFzba5NxcMzIN4N5L3oRpKR9mN4eYYVeBU2gV1FrTJ-EOOGsjjRIgdCPYWntovRpOB2femg/s1600/disk+cleanup-6.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="272" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9jsp1o4rkzkxFmqNT4Zifr_YtfX_NaFJdCjffk7gClS67OZNcmaKPRK0FSYF7HW2Um82mXFzba5NxcMzIN4N5L3oRpKR9mN4eYYVeBU2gV1FrTJ-EOOGsjjRIgdCPYWntovRpOB2femg/s320/disk+cleanup-6.jpg" width="320" /></a></div>
<br />
On the last screen, enter the path on the target server where the script was located. As I outlined in the beginning, I put the scripts in the "C:\Scripts\" folder with a file called cleanup.bat.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRlXMhShYITQsUQS3zL3Sf5RqrZTjGneInHIDm8VHvYEqxo7-1QfdEFfCrtuXF0VbjlFRmNLok_dm9-Trllua8kg7VDEHRg2W_s2MhzVb0xV1w4lVnHjb4GfKgrzhBeea8P0BnFrdKqdE/s1600/disk+cleanup-7.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="272" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRlXMhShYITQsUQS3zL3Sf5RqrZTjGneInHIDm8VHvYEqxo7-1QfdEFfCrtuXF0VbjlFRmNLok_dm9-Trllua8kg7VDEHRg2W_s2MhzVb0xV1w4lVnHjb4GfKgrzhBeea8P0BnFrdKqdE/s320/disk+cleanup-7.jpg" width="320" /></a></div>
<br />
You are basically done at this point. When the alert or warning condition occurs (which ever you setup to respond to), the script will kick off and delete the files.<br />
<br />
The nice thing about running a recovery task in this manner is that if the alert persists, you know there is a larger problem as the basic steps of clearing up misc., temporary files has already been accomplished. Now you know there is something out of the ordinary going on.<br />
<br />
You can now test this script by running a program called Philip 2.10. This will create a large file in one of the temporary directories cleared by the sample script. You can download the software from the following location:<br />
<br />
<span style="font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><a href="http://www.softpedia.com/get/System/File-Management/Philip.shtml"><span style="color: blue;">http://www.softpedia.com/get/System/File-Management/Philip.shtml</span></a></span>Dave Murphyhttp://www.blogger.com/profile/14038170973560613332noreply@blogger.com5tag:blogger.com,1999:blog-1807410337729170157.post-37137855448620895322012-10-24T15:11:00.001-07:002012-10-24T15:11:34.907-07:00Monitoring HP Servers Running VMWare (Intro)Up until now, we have had a definitely challenge in working to get our HP VMware servers actively monitored at the hardware level in SCOM. Last month, HP introduced a new series of management packs. The downside is, they require the SNMP services to be running in order to pick up agentless and VMWare based systems. We'll see how that affects SNMP capabilities in SCOM as there had been instructions to disable those services. More to come on these updates.Dave Murphyhttp://www.blogger.com/profile/14038170973560613332noreply@blogger.com0tag:blogger.com,1999:blog-1807410337729170157.post-155147175434794952012-08-21T11:15:00.002-07:002012-08-21T11:15:28.027-07:00Retrieving a List of Monitored SQL Databases and Database FilesHere is a tid-bit of housekeeping information. Our DBA wanted to know how many databases were floating around out there. I realized, there didn't seem to be a consolidated report that showed all SQL 2000, 2005 and 2008 instances. Most reports are segmented by SQL version and still don't really show all this information in a quick list. I concocted a couple of queries that pry that information out of the System Center Database. Try them out!<br />
<br />
Open up SQL Management studio, connect to the SQL server running your System Center databases and give these queries a shot:<br />
<br />
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">Use OperationsManager<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="color: blue; font-family: "Courier New"; font-size: 10pt;">Select</span><span style="font-family: "Courier New"; font-size: 10pt;"> <span style="color: grey;">*<o:p></o:p></span></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="color: blue; font-family: "Courier New"; font-size: 10pt;">From</span><span style="font-family: "Courier New"; font-size: 10pt;"> ManagedEntityGenericView<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="color: blue; font-family: "Courier New"; font-size: 10pt;">Where</span><span style="font-family: "Courier New"; font-size: 10pt;"> FullName <span style="color: grey;">Like</span> <span style="color: red;">'%SQLServer.Database%'</span> <span style="color: grey;">AND<o:p></o:p></span></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="color: grey; font-family: "Courier New"; font-size: 10pt;">NOT</span><span style="font-family: "Courier New"; font-size: 10pt;"> FullName <span style="color: grey;">Like</span> <span style="color: red;">'%Exchange%'</span> <span style="color: grey;">AND<o:p></o:p></span></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="font-family: "Courier New"; font-size: 10pt;">MonitoringClassId <span style="color: grey;">=</span> <span style="color: red;">'10C1C7F7-BA0F-5F9B-C74A-79A891170934'<o:p></o:p></span></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="color: blue; font-family: "Courier New"; font-size: 10pt;">ORDER</span><span style="font-family: "Courier New"; font-size: 10pt;"> <span style="color: blue;">By</span> <span style="color: blue;">Path</span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<br /></div>
<br />
If nothing is returned, try removing the filter for the Monitoring ClassId<br />
<br />
------------------------------------------------------------------------------------------<br />
<br />
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">Use OperationsManager<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="color: blue; font-family: "Courier New"; font-size: 10pt;">Select</span><span style="font-family: "Courier New"; font-size: 10pt;"> <span style="color: grey;">*<o:p></o:p></span></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="color: blue; font-family: "Courier New"; font-size: 10pt;">From</span><span style="font-family: "Courier New"; font-size: 10pt;"> ManagedEntityGenericView<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="color: blue; font-family: "Courier New"; font-size: 10pt;">Where</span><span style="font-family: "Courier New"; font-size: 10pt;"> FullName <span style="color: grey;">Like</span> <span style="color: red;">'%DBFile:%'</span> <span style="color: grey;">AND<o:p></o:p></span></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="color: grey; font-family: "Courier New"; font-size: 10pt;">NOT</span><span style="font-family: "Courier New"; font-size: 10pt;"> FullName <span style="color: grey;">Like</span> <span style="color: red;">'%Exchange%'<o:p></o:p></span></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="color: blue; font-family: "Courier New"; font-size: 10pt;">ORDER</span><span style="font-family: "Courier New"; font-size: 10pt;">
<span style="color: blue;">By</span> Id</span><o:p></o:p></div>
Dave Murphyhttp://www.blogger.com/profile/14038170973560613332noreply@blogger.com0tag:blogger.com,1999:blog-1807410337729170157.post-28944298692280160412012-08-01T09:47:00.001-07:002012-08-01T09:47:17.914-07:00AustraliaIf anyone would like some help on a project in Australia, I would love a reason to come out there, just saying :)Dave Murphyhttp://www.blogger.com/profile/14038170973560613332noreply@blogger.com0tag:blogger.com,1999:blog-1807410337729170157.post-3306534503519067442012-07-20T10:25:00.000-07:002012-07-20T10:25:36.793-07:00Background Intelligent Transfer Service is MissingAfter my niece used my computer this week, I came home to discover my system infected with a nasty virus that deleted the windows update service along with the Background Intelligent Transfer Service along with all sorts of other nasty things. This has nothing to do with System Center, but thought I would log it anyway since I had to create the service manually after an automated fix from Microsoft failed to restore the service to a functional state and I found no love in other forums.<br />
First, check this link, it may help:<br />
<a href="http://support.microsoft.com/kb/971058/en-us">http://support.microsoft.com/kb/971058/en-us</a><br />
<br />
From an Administrative command prompt, type the following to restore BITS (Background Intelligent Transfer Service)<br />
<br />
sc create BITS type= share start= delayed-auto binPath= "C:\Windows\System32\svchost.exe -k netsvcs" tag= no DisplayName= "Background Intelligent Transfer Service"<br />
<br />
There should be trailing spaces right after the equal signs. The service registered successfully and picked up the dependencies as well without having to add those manually. The service is dependent on RPCSs and EventSystem in the event you do have to add those.Dave Murphyhttp://www.blogger.com/profile/14038170973560613332noreply@blogger.com23tag:blogger.com,1999:blog-1807410337729170157.post-53285229596872629142012-07-18T11:17:00.001-07:002012-07-18T15:58:56.396-07:00Setup a Disk Report in SCOM 2012 - (Part 2)Now that we've started collecting disk space counters for logical drives in Part 1 of this series, let's whip together a quick report that shows the logical disk size, the logical disk space free and logical disk space used. <br />
<br />
I am going to start by saying some of the tactics in here are likely not Microsoft supported, but they work. Before you make changes, ensure you have the previous settings written down somewhere and your data backed up. While I have not encountered any issues with this procedure, I suppose something could happen that I have not seen in the environments I manage. <br />
<br />
There are also a few other ways of accomplishing the report writing, such as using Visual Studio. I wanted to use only free tools that are readily available for this exercise. The driving piece of this is getting access to the performance data. That has been a challenge for myself and many others out there. After this, you will be better prepared to pull a variety of performance metrics from your system in the way you want.<br />
<br />
Saban's blog was able to point me to the location of the tables used for the performance data and he uses the Visual Studio method for creating the report. Lot of good information in his blog. Ultimately, I chose a different SQL query method to make it easier (in my opinion) working with the data.<br />
<br />
<a href="http://skaraaslan.blogspot.com/2011/02/creating-custom-report-for-scom-2007-r2.html">http://skaraaslan.blogspot.com/2011/02/creating-custom-report-for-scom-2007-r2.html</a><br />
<br />
<ol>
<li>Go ahead and connect to the SQL server running the OperationsManagerDW database using the SQL Management Studio. If you don't have the SQL management studio on your desktop then you may want to terminal into your database server and connect from there.</li>
<div class="separator" style="clear: both; text-align: center;">
<img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlA9SCfR6S4ewNVKOVrGl8UUUtgijuyBuw4S7Yk4ynbzX1DTZsXQkyYBbcigtAnemdTOuCDtJu_ULh8Wg1xeT_59-qpKjk_FJIeAP1pQUXdH0_mlfodEcZfVWdQCGiuCUhNxvMYKHGUp8/s320/scom-disksize-report-1.jpg" width="254" /></div>
<br />
<li>When connecting, enter the SQL server name housing your OperationsManagerDW database.</li>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPsAGE7UOnrC5qfrO-C6hp8Lmw2anZLM3HC-DrmYRXEhC_LzCMku-gCkRuvgd2kFaUsVRpn7Filq9M6V_PYErXoY_dcPSxCMMj3l_yA3DKp2MebWC_HP_H6euMnChePEcUDgpfFSC-07w/s1600/scom-disksize-report-2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="236" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPsAGE7UOnrC5qfrO-C6hp8Lmw2anZLM3HC-DrmYRXEhC_LzCMku-gCkRuvgd2kFaUsVRpn7Filq9M6V_PYErXoY_dcPSxCMMj3l_yA3DKp2MebWC_HP_H6euMnChePEcUDgpfFSC-07w/s320/scom-disksize-report-2.jpg" width="320" /></a></div>
<br />
<li>Once in the SQL Management Studio, browse through the tree to the OperationsManagerDW view tab, where you will right-click on "Views" and select "New View".</li>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjD1PAMnDWYbM0TS5mbVxj0rVhbRad9gMmb3OWRIjLwowT-Q5zi2TAsIuylbdlivxQwAmbLp_eFsutkdMoIWUJz57RyOWNoKdIdVW6wgnIO4mWzCqoFrN0CpYLsG-SrBgAMII2QFWQs8tA/s1600/scom-disksize-report-3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjD1PAMnDWYbM0TS5mbVxj0rVhbRad9gMmb3OWRIjLwowT-Q5zi2TAsIuylbdlivxQwAmbLp_eFsutkdMoIWUJz57RyOWNoKdIdVW6wgnIO4mWzCqoFrN0CpYLsG-SrBgAMII2QFWQs8tA/s320/scom-disksize-report-3.jpg" width="274" /></a></div>
<br />
<li>A box will appear that allows you to grab specific tables or views to add for the query designer. Go ahead and just close this window.</li>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7KfhSwFsv-7qEWCfcVLPwCDueOiVmTYUNPhYRqeVh1jfS_F0MReMkYgj7u2mKE2hqPEImsFSWTCcMYLy1cmsUbaMWvXrBh44ERTzSaoH8h3RGKB7Uk-gVlMnZIbRC5mrCU3gGt59dH90/s1600/scom-disksize-report-4.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="250" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7KfhSwFsv-7qEWCfcVLPwCDueOiVmTYUNPhYRqeVh1jfS_F0MReMkYgj7u2mKE2hqPEImsFSWTCcMYLy1cmsUbaMWvXrBh44ERTzSaoH8h3RGKB7Uk-gVlMnZIbRC5mrCU3gGt59dH90/s320/scom-disksize-report-4.jpg" width="320" /></a></div>
<br /><br />
<li>You will then be presented with a three pane window, the fields should be blank. Post the following SQL statements into the bottom pane (replacing any existing information), after which the view should look like the image following the SQL statements. This view will filter the results to only show the logical disk counters. You could leave the filter out so that you can use this view to poll any performance data. For now, use these statements to only look for LogicalDisk metrics.</li>
<br /><br /><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">SELECT<span style="mso-spacerun: yes;"> </span></span></div>
<br /><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">Perf.vPerfHourly.AverageValue, </span></div>
<span style="font-family: Calibri;">dbo.vPerformanceRuleInstance.InstanceName, </span><br /><span style="font-family: Calibri;">dbo.vPerformanceRule.ObjectName, </span><br /><span style="font-family: Calibri;">dbo.vPerformanceRule.CounterName,<span style="mso-spacerun: yes;"> </span>dbo.vPerformanceRuleInstance.LastReceivedDateTime, </span><br /><span style="font-family: Calibri;">Perf.vPerfHourly.DateTime, </span><br /><span style="font-family: Calibri;">dbo.vManagedEntity.DWCreatedDateTime, </span><br />d<span style="font-family: Calibri;">bo.vManagedEntity.ManagedEntityGuid, </span><br /><span style="font-family: Calibri;">dbo.vManagedEntity.ManagedEntityDefaultName, </span><br /><span style="font-family: Calibri;">dbo.vManagedEntity.DisplayName, </span><br /><span style="font-family: Calibri;">dbo.vManagedEntity.Name, </span><br /><span style="font-family: Calibri;">dbo.vManagedEntity.Path, </span><br />d<span style="font-family: Calibri;">bo.vManagedEntity.FullName</span><br /><br /><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">FROM<span style="mso-spacerun: yes;"> </span></span></div>
<br /><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">Perf.vPerfHourly INNER JOIN </span><span style="font-family: Calibri;">dbo.vPerformanceRuleInstance ON Perf.vPerfHourly.PerformanceRuleInstanceRowId = dbo.vPerformanceRuleInstance.PerformanceRuleInstanceRowId INNER JOIN dbo.vManagedEntity ON Perf.vPerfHourly.ManagedEntityRowId = dbo.vManagedEntity.ManagedEntityRowId INNER JOIN </span><span style="font-family: Calibri;">dbo.vPerformanceRule ON dbo.vPerformanceRuleInstance.RuleRowId = dbo.vPerformanceRule.RuleRowId</span></div>
<br /><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<br />
<span style="font-family: "Calibri", "sans-serif"; font-size: 11pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">WHERE<span style="mso-spacerun: yes;"> </span>(dbo.vPerformanceRule.ObjectName = 'Logicaldisk')</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2LbphNGaP3ulS3H0xriGC_SHCt0dzlAMnPYhlQsPiDRfaVpLiXT7lV7mv36EUmpAOfNNHywdcVEFpr5FzO1llW-7dvEbrgoyQudt2w2jFySapgh4q3YdG35Dj7V19AdpkRK_ke_gpwxU/s1600/scom-disksize-report-5.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="282" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2LbphNGaP3ulS3H0xriGC_SHCt0dzlAMnPYhlQsPiDRfaVpLiXT7lV7mv36EUmpAOfNNHywdcVEFpr5FzO1llW-7dvEbrgoyQudt2w2jFySapgh4q3YdG35Dj7V19AdpkRK_ke_gpwxU/s320/scom-disksize-report-5.jpg" width="320" /></a></div>
<br />
<li>Run the query just to make sure data is getting polled correctly. If not, check to ensure everything has copied and pasted correctly and that the OperationsManagerDW database is selected to run the query against. After the query runs successfully, save the view.</li>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5ljziO_Nwkairq3YVbB_buPTWJbqnoQuYS0v1p5rUWKrGZGNpiahPhWxKeHUR1qkdXibg4EWfWGNYrMOJU0BaoimclKat35H9Hq5BxJw-Kin31wAMYa2K8fVExq5WGL3v_FMUb6Lkrlc/s1600/scom-disksize-report-6.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="149" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5ljziO_Nwkairq3YVbB_buPTWJbqnoQuYS0v1p5rUWKrGZGNpiahPhWxKeHUR1qkdXibg4EWfWGNYrMOJU0BaoimclKat35H9Hq5BxJw-Kin31wAMYa2K8fVExq5WGL3v_FMUb6Lkrlc/s320/scom-disksize-report-6.jpg" width="320" /></a></div>
<br /><br />
<li>When the save dialog appears, use the name as shown, as the remainder of this tutorial will be based on this view. Otherwise, remember to change the references to this name with the one you input. The query could also be changed to reflect daily information. Simply go back to the select statement above and change the joins to include <span style="font-family: Calibri;">Perf.vPerfDaily instead of Perf.vPerfHourly</span></li>
<br /><br /><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhS1hadeBk_N3BNtMHnsVWWk-80Jdfu5YudRbS2tj471wg2c1FCgXXnKPuEKZGV01M82JZO0jJqF1JmoMgKcv_Ix77js5nbE7VPnyi4kSpvMD8kXcjS-ltSYfdoaDOQ8z0M6uqRwEivd0s/s1600/scom-disksize-report-7.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="132" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhS1hadeBk_N3BNtMHnsVWWk-80Jdfu5YudRbS2tj471wg2c1FCgXXnKPuEKZGV01M82JZO0jJqF1JmoMgKcv_Ix77js5nbE7VPnyi4kSpvMD8kXcjS-ltSYfdoaDOQ8z0M6uqRwEivd0s/s320/scom-disksize-report-7.jpg" width="320" /></a></div>
<br />
<li>At this point, we need to make an adjustment to the reporting service. Open the "Reporting Services Configuration Manager" and select the "Execution Account". Take note of the account used here.</li>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjoNO9Zn6f18m51-0gF2gORO_a9jvgYbFSO29_jft1lhXllYlGfoIuc_nPaDM6GOZYDJKhsny4Q_IrOki0YZ7BO5DVuPrUMqWaNDR_i-zVicvDtR_rO4Ns1IHwoEf6KPMd8WhcOPforr6U/s1600/scom-disksize-report-8.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="161" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjoNO9Zn6f18m51-0gF2gORO_a9jvgYbFSO29_jft1lhXllYlGfoIuc_nPaDM6GOZYDJKhsny4Q_IrOki0YZ7BO5DVuPrUMqWaNDR_i-zVicvDtR_rO4Ns1IHwoEf6KPMd8WhcOPforr6U/s320/scom-disksize-report-8.jpg" width="320" /></a></div>
<br />
<li>Now open the web management console for the SQL Reporting Server that runs your SCOM reports and select the detailed view in the report manager screen. Look for the Data Warehouse Main data source. Hovering over the entry should bring up a drop down menu, select that and click manage to open the properties of the Data Warehouse Main data connection.</li>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0lzHjINU1BQaVsobZnpSFWAnezs2H3OPnMmWT5SXZzkgEOxLYCdvyxWnAcqQjZ7Fq5tF7IAqIrCluZzODTK2zBHT8vA_cY7JWM4TXQW6rFE_uJhkVwetVlHwYCKKzi5uf1f9k9VARqwQ/s1600/scom-disksize-report-9.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="143" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0lzHjINU1BQaVsobZnpSFWAnezs2H3OPnMmWT5SXZzkgEOxLYCdvyxWnAcqQjZ7Fq5tF7IAqIrCluZzODTK2zBHT8vA_cY7JWM4TXQW6rFE_uJhkVwetVlHwYCKKzi5uf1f9k9VARqwQ/s320/scom-disksize-report-9.jpg" width="320" /></a></div>
<br />
<li>Go to the "Connect String" properties of the data connector and input the execution account credentials in this spot and save the changes.</li>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDwmnFC3WPyEm6V04XLYntmMB9lgtFpAk9uPOH_sw2qNNtJ_hp4gu29j9AzM0WAn6C8yMkfN82TBy4-_cUcwkFKboJl0DRYK3u1-ONBS2XdIXKQX-4Ct3xKfdLA5csQMrCvNaDhLWeMNU/s1600/scom-disksize-report-10.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="138" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDwmnFC3WPyEm6V04XLYntmMB9lgtFpAk9uPOH_sw2qNNtJ_hp4gu29j9AzM0WAn6C8yMkfN82TBy4-_cUcwkFKboJl0DRYK3u1-ONBS2XdIXKQX-4Ct3xKfdLA5csQMrCvNaDhLWeMNU/s320/scom-disksize-report-10.jpg" width="320" /></a></div>
<br />
<li>Now you will want to download the Microsoft SQL Server 2008 R2 Report Builder 3.0 software, <span style="font-family: "Calibri", "sans-serif"; font-size: 11pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><a href="http://www.microsoft.com/en-us/download/details.aspx?id=6116"><span style="color: blue;">http://www.microsoft.com/en-us/download/details.aspx?id=6116</span></a> (If you do not have SQL 2008 R2 installed, then download Microsoft SQL Server Report Builder 2.0. Report Builder 3.0 only works with SQL 2008 R2)</span></li>
<br /><br />
<li>Once downloaded and installed, open the report builder and select the "Blank Report" option. You may be promopted for a login to the report server. You should be able to use your local credentials. If those do not work, you may need additional rights to login to the SQL server with your account.</li>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEim1KWSxotCpGqrIL_0ZsUyQ9fHCZxeZuFG_okRHQbsWFHGHLwD3ibDgDtZe6Hc_VtOqUglQLq6mn7laFnX_XGupvVBfKMZ1mMJxx8_LDhXccag-YEfGEFvTQ03SV56eiRBBKOvJPAOCWo/s1600/scom-disksize-report-11.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Logical Disk Used Space Report Builder" border="0" height="234" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEim1KWSxotCpGqrIL_0ZsUyQ9fHCZxeZuFG_okRHQbsWFHGHLwD3ibDgDtZe6Hc_VtOqUglQLq6mn7laFnX_XGupvVBfKMZ1mMJxx8_LDhXccag-YEfGEFvTQ03SV56eiRBBKOvJPAOCWo/s320/scom-disksize-report-11.jpg" title="System Center Operations Manager 2012" width="320" /></a></div>
<br />
<li>Once in the "Blank Report", you will need to add a data source. Browse through the tree view on the left and right-click ont he "Data Source" folder to add a Data Source.</li>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgu_trW4ccL4p_hTWvwyhZMeTARpWfHtZlximBngVNdAu6suXnaQlpjt6PNfmznj0b_Rb9PtSOJrcmVsDxoYYkUFwWgKc6Fdbpf7ahlBTQowKPmjueBoF2f7YfAESo6tRqOPpq5W1n24GI/s1600/scom-disksize-report-12.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgu_trW4ccL4p_hTWvwyhZMeTARpWfHtZlximBngVNdAu6suXnaQlpjt6PNfmznj0b_Rb9PtSOJrcmVsDxoYYkUFwWgKc6Fdbpf7ahlBTQowKPmjueBoF2f7YfAESo6tRqOPpq5W1n24GI/s1600/scom-disksize-report-12.jpg" /></a></div>
<br />
<li>From here you should be able to browse the datasources installed on the report server. The Data Warehouse Main connection should be found by browsing.</li>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhPliqSMJnXdjoVaYk-fxfXbT9iINBn32yB7YXdondeP7SOzmTZQX3Nsp8A0OsqDhtk4Ij8hz3YALqZt_bd8ixjIX9CZbeY9BZdZ4O0vBdoIWyAP6tkiuOBbhohtWNLqYqlSVxb2FuT1eE/s1600/scom-disksize-report-13.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="232" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhPliqSMJnXdjoVaYk-fxfXbT9iINBn32yB7YXdondeP7SOzmTZQX3Nsp8A0OsqDhtk4Ij8hz3YALqZt_bd8ixjIX9CZbeY9BZdZ4O0vBdoIWyAP6tkiuOBbhohtWNLqYqlSVxb2FuT1eE/s320/scom-disksize-report-13.jpg" width="320" /></a></div>
<br />
<li>With a datasource setup, you need to now add a dataset to pull the data. Browse the tree 5o "Datasets" and right-click to add a new dataset.</li>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIBar4r43oKbECy87P4eNl56hy57bQw6CU0OFc4GGRJE0wJEEoJ7y06JlQdptwI0NkmVrPFjd12f-J3G2h44Hejnclor5XlBepQ7S88mG9n_fhVDZTDPFm_jwCfA3CbJiMN-0qWLSrl0w/s1600/scom-disksize-report-14.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIBar4r43oKbECy87P4eNl56hy57bQw6CU0OFc4GGRJE0wJEEoJ7y06JlQdptwI0NkmVrPFjd12f-J3G2h44Hejnclor5XlBepQ7S88mG9n_fhVDZTDPFm_jwCfA3CbJiMN-0qWLSrl0w/s320/scom-disksize-report-14.jpg" width="260" /></a></div>
<br />
<li>In the "Dataset Properties", under the "Query" section, input the following code:</li>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
select </div>
<div class="separator" style="clear: both; text-align: left;">
[Total Disk Space], </div>
<div class="separator" style="clear: both; text-align: left;">
[Free Megabytes], </div>
<div class="separator" style="clear: both; text-align: left;">
[Total Disk Space]-[Free Megabytes] AS "Used Space", </div>
<div class="separator" style="clear: both; text-align: left;">
InstanceName, </div>
<div class="separator" style="clear: both; text-align: left;">
Path, </div>
<div class="separator" style="clear: both; text-align: left;">
DateTime from </div>
<div class="separator" style="clear: both; text-align: left;">
(</div>
<div class="separator" style="clear: both; text-align: left;">
select </div>
<div class="separator" style="clear: both; text-align: left;">
CounterName, </div>
<div class="separator" style="clear: both; text-align: left;">
AverageValue,</div>
<div class="separator" style="clear: both; text-align: left;">
InstanceName, </div>
<div class="separator" style="clear: both; text-align: left;">
Path,</div>
<div class="separator" style="clear: both; text-align: left;">
DateTime </div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
FROM vCustomHourlyLogicalDiskPerf) AS SourceTable PIVOT ( AVG (AverageValue) FOR CounterName IN ([Total Disk Space],[Free Megabytes])</div>
<div class="separator" style="clear: both; text-align: left;">
) AS PivotTable </div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
WHERE </div>
<div class="separator" style="clear: both; text-align: left;">
DateTime >= @Start_Date AND </div>
<div class="separator" style="clear: both; text-align: left;">
DateTime <= @End_Date AND </div>
<div class="separator" style="clear: both; text-align: left;">
NOT InstanceName = '_Total' AND </div>
<div class="separator" style="clear: both; text-align: left;">
NOT InstanceName Like '\\?\Volume%%'</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Alternatively, if you didn't setup or want to setup the WMI counters for logical disk size, you can extrapolate the information with the following query:</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
select </div>
[Free Megabytes],<br />[% Free Space],<br />[Free Megabytes]/([% Free Space]/100) AS "Total Disk Space",<br />([Free Megabytes]/([% Free Space]/100) - [Free Megabytes]) AS "Used Disk Space",<br />InstanceName,<br />Path,<br />DateTime<br />from<br />(select CounterName, AverageValue,InstanceName, Path,DateTime <br /> FROM vCustomHourlyLogicalDiskPerf) AS SourceTable<br />PIVOT<br />(<br />AVG (AverageValue) FOR CounterName IN ([Free Megabytes],[% Free Space])<br />) AS PivotTable<br />WHERE<br />DateTime >= '7/17/2012' AND<br />DateTime <= '7/18/2012' AND<br />NOT InstanceName = '_Total' AND<br />NOT InstanceName Like '\\?\Volume%%' AND<br />[% Free Space] > 0.000001<br /><br /><div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhK3KNlTTntIipy6PGwwQJg1HY8Ws5lNo6HrxoQMgOROlGxPyoy9MlRNcEbkd8Yom6v7wzOkXZ_z_WUp8IPfQRGQ3MsUNHDwhEEWgxveQwHBNzM0pHRWwsYbwPmzqxoIIs2w7CBoo_6byY/s1600/scom-disksize-report-15.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhK3KNlTTntIipy6PGwwQJg1HY8Ws5lNo6HrxoQMgOROlGxPyoy9MlRNcEbkd8Yom6v7wzOkXZ_z_WUp8IPfQRGQ3MsUNHDwhEEWgxveQwHBNzM0pHRWwsYbwPmzqxoIIs2w7CBoo_6byY/s320/scom-disksize-report-15.jpg" width="310" /></a></div>
<br />
<li>After saving the dataset, you should see the variables for the dataset apear in the left-hand pane.</li>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSd_Qf-6T_E-3tNmbbcfmHucUwF9AnnmtJL9wroWh3G4oV9LMCVqtvRPWy6NmSutBUUcVFobLZLIMPmzbXbo0M8H_LF_1BkFsodkhyupotue7oW3gMXi1SFxc84x5xP0SuP_5R1Nko2Og/s1600/scom-disksize-report-16.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSd_Qf-6T_E-3tNmbbcfmHucUwF9AnnmtJL9wroWh3G4oV9LMCVqtvRPWy6NmSutBUUcVFobLZLIMPmzbXbo0M8H_LF_1BkFsodkhyupotue7oW3gMXi1SFxc84x5xP0SuP_5R1Nko2Og/s320/scom-disksize-report-16.jpg" width="148" /></a></div>
<br />
<li>In the Report Builder menu at the top, select "Insert" and select the down arrow under "Matrix" to manually insert a matrix table.</li>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOGyZInwWcVW0XC6GpyubxrIc5Mwk_Gxj8PMFjx_cWOjyPUfm59V_eozVM-bjXix6vN_DTqkXuXvPAvkAbljxURGVJQeb4_kGSFuvJc3CWcvhPGPX0eFGvwnAfZUXs4gQ-APil59N_L8w/s1600/scom-disksize-report-17.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="179" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOGyZInwWcVW0XC6GpyubxrIc5Mwk_Gxj8PMFjx_cWOjyPUfm59V_eozVM-bjXix6vN_DTqkXuXvPAvkAbljxURGVJQeb4_kGSFuvJc3CWcvhPGPX0eFGvwnAfZUXs4gQ-APil59N_L8w/s320/scom-disksize-report-17.jpg" width="320" /></a></div>
<br />
<li>You should be presented with a two row, two column matrix table. Start by dragging the "Path" variable to the lower-left box.</li>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiK3ATNv1_EUPDFTqGI0e6TWGnDNpRWv7B-fa_zCOHB5PVMuo41qHSexMndRxFZXuJS7YGnwQW_aib0Eg3SLgDtzR6JQEs943-71DrP8fZbksz-oj3uoDVONNcUVXep2HO5MwHyCAlLDhM/s1600/scom-disksize-report-18.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiK3ATNv1_EUPDFTqGI0e6TWGnDNpRWv7B-fa_zCOHB5PVMuo41qHSexMndRxFZXuJS7YGnwQW_aib0Eg3SLgDtzR6JQEs943-71DrP8fZbksz-oj3uoDVONNcUVXep2HO5MwHyCAlLDhM/s1600/scom-disksize-report-18.jpg" /></a></div>
<br />
<li>Now click on the box with the [path] variable, right-click to bring up the context menu and browse down to "Add Group" and select a "Child Group" for the row.</li>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWZhS9Jl8Wiohgq6JGexFdOHKUOQ2y02ZQ3vdhE5gAXZI2vIRgn6h7MHF5WkOdiDd_nvFRO_4xjJSf5AthkrJY7-yiEWL7zzCZ3vxLT38N3e59FDJb8zr0xc1Bqz5QdRV5l7dxd-g2iRM/s1600/scom-disksize-report-19.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWZhS9Jl8Wiohgq6JGexFdOHKUOQ2y02ZQ3vdhE5gAXZI2vIRgn6h7MHF5WkOdiDd_nvFRO_4xjJSf5AthkrJY7-yiEWL7zzCZ3vxLT38N3e59FDJb8zr0xc1Bqz5QdRV5l7dxd-g2iRM/s320/scom-disksize-report-19.jpg" width="290" /></a></div>
<br />
<li>This will bring up a "Tablix group" dialog box. Select the [InstanceName] variable for this group.</li>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRV3OOxHjH3bedf7efr-2XlmKDXQmxrr2GvmZuySKG60EeUFm6EXsNYHAHhdP_qcoLpSJUp8Zb8f3HuohTEWMrhuBPfgSGmDgSywaeIVORVUIqPENCrTviOETtmed-BmLqJWyVy2W03GA/s1600/scom-disksize-report-20.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="137" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRV3OOxHjH3bedf7efr-2XlmKDXQmxrr2GvmZuySKG60EeUFm6EXsNYHAHhdP_qcoLpSJUp8Zb8f3HuohTEWMrhuBPfgSGmDgSywaeIVORVUIqPENCrTviOETtmed-BmLqJWyVy2W03GA/s320/scom-disksize-report-20.jpg" width="320" /></a></div>
<br />
<li>In the lower-right column, drag the [Total_Disk_Space] Variable to the box. This will want to change the value to the sum of all values. Right-click the field to bring up the expression option.</li>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibHmPh2n85S_nIccebvFqfM7xxrJCiMbpmy2BuQ4-dXCmjM7XNZfUVcJeoJrMO-WyLt2BrKhXgeCChS8aR2i3-XhqR0YePNj03QW8JRndjRcGUwI6i037dy8DejGVpaz6SvMoM57u8noc/s1600/scom-disksize-report-21.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="214" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibHmPh2n85S_nIccebvFqfM7xxrJCiMbpmy2BuQ4-dXCmjM7XNZfUVcJeoJrMO-WyLt2BrKhXgeCChS8aR2i3-XhqR0YePNj03QW8JRndjRcGUwI6i037dy8DejGVpaz6SvMoM57u8noc/s320/scom-disksize-report-21.jpg" width="320" /></a></div>
<br />
<li>Take out the SUM() calculation to leave just the "Total Disk Space" option.</li>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkjicojc_EvU0isFt1jns1u1R9PySkP0SE8LguShwT_z-1KNJySKYYJOZfNBNMaWsF4G0NeMrvKOlRZj6gCY5mw3EG2qDCFFEbiZEPC6t1edFe-TdNxA-yQ8KNIKLTRX7q-QMzGPbjzwk/s1600/scom-disksize-report-22.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="362" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkjicojc_EvU0isFt1jns1u1R9PySkP0SE8LguShwT_z-1KNJySKYYJOZfNBNMaWsF4G0NeMrvKOlRZj6gCY5mw3EG2qDCFFEbiZEPC6t1edFe-TdNxA-yQ8KNIKLTRX7q-QMzGPbjzwk/s400/scom-disksize-report-22.jpg" width="400" /></a></div>
<br />
<li>In the same column, right-click for the context menu and now lets select "Insert Column - Inside Group - > Right". Do this again to add another column.</li>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTmrDeaEuIdycFL50wYpM9C56OXDH49r6zoo9i_49KclsJ5lXxUq4b2xbiiEBHBr7g_xc7Ew9UrizoogvQq7QEXxRpPeRCI4je9pUCIS5eEVatqzWj1OeacQh-_49voF1r7Q-saVJ5LoY/s1600/scom-disksize-report-23.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="198" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTmrDeaEuIdycFL50wYpM9C56OXDH49r6zoo9i_49KclsJ5lXxUq4b2xbiiEBHBr7g_xc7Ew9UrizoogvQq7QEXxRpPeRCI4je9pUCIS5eEVatqzWj1OeacQh-_49voF1r7Q-saVJ5LoY/s320/scom-disksize-report-23.jpg" width="320" /></a></div>
<br />
<li>Select the top header, right-click for the context menu and select the option to "Split cells". Now you can drag the [Free_Megabytes] variable to the next to last column and the [Used_Space] to the last column.</li>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhi-KdloZdzf0eWCDKwD1YuHAcBH7jzy_4J4I_GUmRu_DejXUOgISSXoJSkS8k5TlRiTkGrHdmEgsUoXvE7jkWjjI1FdE9fUTTNB3NdmC1vP_ixyBqxmUHpm38RqvVB8o3NlJUMPbWwX3w/s1600/scom-disksize-report-24.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhi-KdloZdzf0eWCDKwD1YuHAcBH7jzy_4J4I_GUmRu_DejXUOgISSXoJSkS8k5TlRiTkGrHdmEgsUoXvE7jkWjjI1FdE9fUTTNB3NdmC1vP_ixyBqxmUHpm38RqvVB8o3NlJUMPbWwX3w/s320/scom-disksize-report-24.jpg" width="297" /></a></div>
<br />
<li>Your report should now look something close to this, two rows and five columns, each with unique variables and headers.</li>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiH1Gu1SRFPhsvJl2wPAl0uIg65gBP2PxNK4lcFVWMaL7Y-Epmr9-dnKCF5DdF4hA0GkYfnqKgtSeuPH_KYFD0RPGBk7juEE_WuUWqz-nqyWGwy2dUN9olPnypWqLYuFzAzmNgxAFGmF0c/s1600/scom-disksize-report-25.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Logical Disk Used Space Finished Report" border="0" height="95" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiH1Gu1SRFPhsvJl2wPAl0uIg65gBP2PxNK4lcFVWMaL7Y-Epmr9-dnKCF5DdF4hA0GkYfnqKgtSeuPH_KYFD0RPGBk7juEE_WuUWqz-nqyWGwy2dUN9olPnypWqLYuFzAzmNgxAFGmF0c/s400/scom-disksize-report-25.jpg" title="System Center Operations Manager 2012" width="400" /></a></div>
<br />
<li>Once you run the report and can see the data, go ahead and save the report directly to the SCOM Report Server. If you select the "My Reports" folder, your report will show in the reports page under "Authored Reports"</li>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhE_7MFHGUV599GfXU_aI_kPMGGm0ffblt04iMDBJQcqaAzBsvqa_NyxWbhyphenhyphenipvsZToAJxQBcxGDsRrX3Cax_zAmiR3h5mrTWEJJBhn2CqSlL85U9MIOSYXtJliqa-9p7yzPtmUFJY73DQ/s1600/scom-disksize-report-26.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="226" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhE_7MFHGUV599GfXU_aI_kPMGGm0ffblt04iMDBJQcqaAzBsvqa_NyxWbhyphenhyphenipvsZToAJxQBcxGDsRrX3Cax_zAmiR3h5mrTWEJJBhn2CqSlL85U9MIOSYXtJliqa-9p7yzPtmUFJY73DQ/s320/scom-disksize-report-26.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
</ol>
<br />
This is a super basic, excel like report. In Part-3, we'll take a stab at adding some graphics and formatting the output for Gigabytes, instead of Megabytes, use commas and only two decimal places for the output of the data. By using custom views, you can aggregate a lot of information to query more easily later and with much simpler SQL statements. Those views may get delted during an update, so that is something to keep in mind, since it is a bit of a hack. If you find that you're missing data, you may want to up your collection interval for the devices or check for WMI connection errors on the servers you are collecting WMI performance data agains from Part-1.Dave Murphyhttp://www.blogger.com/profile/14038170973560613332noreply@blogger.com16