Search This Blog

Friday, November 15, 2013

SCOM 2012 Powershell - Retrieving a List of Computers in a Group

Had 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.

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.

  • Open the Operations Manager Shell powershell console

Image illustratin the correct System Center 2012 Operations Manager Shell to open for running the powershell commands
  • Type in : Get-SCOMGroup
Image shows the sample output of running the SCOM 2012 Get-SCOMGroup command in powershell
  • Search for the group you want to retrieve members from
  • Now type in: $Group = Get-SCOMGroup |  where {$_.DisplayName -eq "SQL Computers"} (or insert the group your looking for instead of SQL Computers")
Image illustrates running the Get-SCOMGroup command with a filter for a specific group and assigning to a variable

  • Next, type in: $Members = $Group.GetRelatedMonitoringObjects()
 
Illustrates the use of the command GetRelatedMonitoringObjects() for retriving a list of group members and assigning them to a variable

  • Now, you can simply type: $Members
 
Illustrates the output of members captured in the previous step using GetRelatedMonitoringObject(). Should show three headings and then the server members from the group

  • Or, pipe the command out to a file: $Members | Sort DisplayName | FT DisplayName | out-file C:\Scripts\Servers.txt
 
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


Posted by at 10:43 AM
Labels: , , , , ,

7 comments:

  1. UnknownAugust 26, 2015 at 9:34 PM

    It was helpful. Thank you

    ReplyDelete
  2. gr75801September 7, 2016 at 4:46 PM

    Hi There,

    Thanks for the command, It seems to work on 1 specific management group.
    But when i enter the 2nd command $Members = $Group.GetRelatedMonitoringObjects()

    I get the below error:
    You cannot call a method on a null-valued expression.
    At line:1 char:1
    + $Members = $Group.GetRelatedMonitoringObjects()
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull

    Any idea ?

    ReplyDelete
    Replies
    1. gr75801September 7, 2016 at 5:00 PM

      Ok i found the issue here.

      I was giving the wrong group / incorrect group name in command 1 which caused command 2 to throw that error.

      Delete
    2. Dave MurphySeptember 8, 2016 at 4:04 PM

      :) Happens all the time

      Delete
  3. ManiFebruary 1, 2017 at 2:27 AM

    If you face error in the last line, either create a C:\Scripts folder or use the following line instead:

    $Members | Sort DisplayName | FT DisplayName | out-file C:\Servers.txt

    ReplyDelete
  4. KITS TechnologiesJune 13, 2021 at 6:39 PM

    This comment has been removed by a blog administrator.

    ReplyDelete
  5. sankarAugust 9, 2021 at 4:28 AM

    This comment has been removed by a blog administrator.

    ReplyDelete

Subscribe to: Post Comments (Atom)