AnthonyBaileyCDW

8 Apr 2013 6:51 PM

Nice script! Works great, however I've had issues with this on SCOM 2012. If I have a server and all its contained objects in Maintenance Mode the server doesn't show up in "Agents where Health State is not Green" It does show the # of objects in maintenance mode under "ObjectCount" though. If I place a single object into MM like a website, I actually get an error in the Script:

Exception setting "ObjectCount": "Cannot set Column 'ObjectCount' to be null. Please use DBNull instead."

At C:\scripts\SCOMHealthCheck.ps1:210 char:1

+ $NewRow.ObjectCount = $ObjectsFound.Count

+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

+ CategoryInfo : NotSpecified: (:) [], SetValueInvocationException

+ FullyQualifiedErrorId : CatchFromBaseAdapterSetValue

Jason Rydstrand

10 Apr 2013 6:16 PM

AnthonyBaileyCDW: Thank you for pointing this out. I should have mentioned that this script was created for SCOM 2007 R2.

Liam Bailey

14 May 2013 10:59 AM

Great script, provides so much value

Jerent Chao

1 Jul 2013 2:35 PM

I am a newbie on SCOM 2012..

Can you tell me how to setup / deploy the script into SCOM console ....

Many thank

regards

Jerent Chao

David Michael

22 Jul 2013 7:39 PM

I am running the script against 2007 R2 and I've also run into "Exception setting "ObjectCount": "Cannot set Column 'ObjectCount' to be null. Please use DBNull instead." At C:\scripts\SCOM_Daily_Status\SCOMHealth-Check.ps1:210 char:9 + $NewRow. <<<< ObjectCount = $ObjectsFound.Count.

Robert Ryan UK

27 Sep 2013 11:44 AM

Excellent Script Jason, I am now using it to report on my 2012 Environment. I did have a few scripting issues which involved me changing/adding a few things:

I run two management groups which caused errors performing 'Get-ManagementGroup' due to two results being returned. I have changed this to only get the management group that relates to the management group of the RMS server that I specify.

Placed a Null value check around the objects in grey state to ensure the code block only run if these existed.

Placed a -gt 0 check on the count section to ensure it only fires when objects exist.

Changed a cpl of console colors from yellow as I am going blind in my old age :D

Great work, cheers

Robert

Sahanawaz

4 Nov 2013 12:16 PM

Using SCOM 2007 R2 ans running the script. its completing with below error but no reports are generating on specified path in script.

Count = $ObjectsFound.Count

Exception setting "ObjectCount": "Cannot set Column 'ObjectCount' to be null. Please use DBNull instead."

At line:1 char:9

+ $NewRow. <<<< ObjectCount = $ObjectsFound.Count

+ CategoryInfo : InvalidOperation: (:) [], RuntimeException

+ FullyQualifiedErrorId : PropertyAssignmentException

Anonymous

10 Jan 2014 12:32 AM

Rober: Do you have a copy of the changes you made to work on SCOM 2012? I have changed all my cmdlets but have a few issues with those null values and would love some help if possible, thanks

David

27 Feb 2014 9:23 PM

I'm trying to update this PS Script to make it work with 2012 but still failing, please share if you have one It will be really nice to have it. Thanks for all the hard work

Jason

9 Apr 2014 6:38 PM

Awesome script! Updated the cmdlets to use the 2012 versions (see http://bit.ly/1egnH1u) and had to adjust the Management Pack Overrides section based on suggestions from this post: http://bit.ly/1n0Poes

Pandey

23 May 2014 11:19 AM

Getting following error while running this script on SCOM 2012

At C:\Users\Desktop\ops_report.ps1:183 char:118
+ $OverrideCount = Get-SCOMManagementPack | where {$_.DisplayName -match "Default Management Pack"} | Get-SCOMOverride
<<<< | measure-object
+ CategoryInfo : InvalidArgument: ([Microsoft.Syst...er.DefaultUser]:PSObject) [Get-SCOMOverride], Parame
terBindingException
+ FullyQualifiedErrorId : InputObjectNotBound,Microsoft.SystemCenter.OperationsManagerV10.Commands.GetSCOverrideCo
mmand

Exception setting "ObjectCount": "Cannot set Column 'ObjectCount' to be null. Please use DBNull instead."
At C:\Users\Desktop\ops_report.ps1:202 char:9
+ $NewRow. <<<< ObjectCount = $ObjectsFound.Count
+ CategoryInfo : InvalidOperation: (:) [], RuntimeException
+ FullyQualifiedErrorId : PropertyAssignmentException Desktop\ops_report.ps1:183 char:118
+ $OverrideCount = Get-SCOMManagementPack | where {$_.DisplayName -match "Default Management Pack"} | Get-SCOMOverride
<<<< | measure-object
+ CategoryInfo : InvalidArgument: ([Microsoft.Syst...er.DefaultUser]:PSObject) [Get-SCOMOverride], Parame
terBindingException
+ FullyQualifiedErrorId : InputObjectNotBound,Microsoft.SystemCenter.OperationsManagerV10.Commands.GetSCOverrideCo
mmand

Exception setting "ObjectCount": "Cannot set Column 'ObjectCount' to be null. Please use DBNull instead."
At C:\Users\ Desktop\ops_report.ps1:202 char:9
+ $NewRow. <<<< ObjectCount = $ObjectsFound.Count
+ CategoryInfo : InvalidOperation: (:) [], RuntimeException
+ FullyQualifiedErrorId : PropertyAssignmentException

Could you please suggest me.