PI Services

###########################################################################################################################################
## SCRIPT TO START/STOP/DISPLAY MAINTENANCE MODE FOR HEALTH SERVICE WATCHER OBJECTS THAT DEPENDS FROM SPECIFIC MANAGEMENT SERVER OR GATEWAY
## Author: CJOURDAN
###########################################################################################################################################
#Parameters
    # $MGroup : Management Group to connect to
    # $MStoConnect : Management server to connect to
    # $PrimMS : Management server or Gateway FQDN from which depend agents.
    # $Reason : Reason for Maintenance Mode (Valid Reason are: PlannedOther
    #                                                          UnPlannedOther
    #                                                          PlannedHardwareMaintenance 
    #                                                          UnplannedHardwareMaintenance 
    #                                                          PlannedHardwareInstallation
    #                                                          UnplannedHardwareInstallation
    #                                                          PlannedOperatingSystemReconfiguration
    #                                                          UnplannedOperatingSystemReconfiguration
    #                                                          PlannedApplicationMaintenance
    #                                                          ApplicationInstallation
    #                                                          ApplicationUnresponsive
    #                                                          ApplicationUnstable
    #                                                          SecurityIssue
    #                                                          LossOfNetworkConnectivity)
    # 
    # $Comment : Comment for Maintenance Mode
    # $MMAction : START or STOP OR DISPLAY Maintenance Mode
    # $MMDuration : Maintenance Mode Duration in minutes (only valuable for START $MMAction)

    # EXAMPLES:
    # Display Health Service Watcher Maintenance Mode Status for agents primary managed by MyPriMaryMS.mydomain.home
        # .\ScomSwitchMM.ps1 -MGroup MyMGROUP -MStoConnect MyMS.mydomain.home -PrimMS MyPriMaryMS.mydomain.home -MMAction display
    # Start Health Service Watcher Maintenance Mode for agents primary managed by MyPriMaryMS.mydomain.home during 60 min
        # .\ScomSwitchMM.ps1 -MGroup MyMGROUP -MStoConnect MyMS.mydomain.home -PrimMS MyPriMaryMS.mydomain.home -MMAction start -MMDuration 60






Param(
[Parameter(Mandatory=$false)]
$ClassName = "Health Service Watcher",
[Parameter(Mandatory=$false)]
$MGroup = "MyMGROUP",
[Parameter(Mandatory=$false)]
$MStoConnect= "MyMS.mydomain.home",
[Parameter(Mandatory=$true)]
$PrimMS= "MyPriMaryMS.mydomain.home",
[Parameter(Mandatory=$false)]
$Reason = "PlannedOther",
[Parameter(Mandatory=$false)]
$Comment = "",
[Parameter(Mandatory=$true)]
$MMAction = $(Read-Host -Prompt "PROVIDE TYPE OF MAINTENANCE MODE ACTION: START or STOP OR DISPLAY"),
[Parameter(Mandatory=$false)]
# $MMDuration in minutes
$MMDuration = 0
)



if ($MMAction -notmatch ".*STOP.*|.*START.*|.*DISPLAY.*")
{
write-host -ForegroundColor Yellow "YOU MUST PROVIDE VALID MAINTENANCE MODE ACTION TYPE: START or STOP or DISPLAY"
EXIT 1
}

$cred = $(Get-Credential -Credential "MyDomain\")

    


#Import du module SCOM
try
{
Import-Module -Name OperationsManager -ErrorAction stop
}
catch
{
write-host -ForegroundColor red "Error during import of SCOM PS Module"
EXIT 1
}


#Connection au management group $MGroup
try
{
New-SCOMManagementGroupConnection -ComputerName $MStoConnect -Credential $cred
}
catch
{
write-host -ForegroundColor red "Error during connection to MS $MStoConnect - CHECK CREDENTIALS USED"
EXIT 1
}



# Get Scom agents that have $PrimMS as Primary Management Server
$agents = get-scomagent | where {$_.PrimaryManagementServerName -eq $PrimMS}

if (!($agents))
    {
    write-host "NO SCOM AGENTS FOUND FOR SERVER $PrimMS - CHECK THAT THE NAME IS CORRECT (YOU MUST PROVIDE FQDN) OR THAT THIS SERVER BELONG TO $MGroup MANAGEMENT GROUP"
    EXIT 1
    }

# Get "Health Service Watcher" Class Instances
$class = Get-SCOMClass -DisplayName $ClassName




switch($MMAction)
    {
    START
                          {


                            # Get instances of "Health Service Watcher" Class
                            $ClassInstances = Get-SCOMClassInstance -Class $class

                            # Class to put in MM Table
                            $ClassInstToMM = @()

                            # Get class instances that match agents
                            foreach ($agent in $agents)
                            { 
                            $ClassInstToMM += ($ClassInstances | Where-Object {$_.DisplayName -eq $agent.displayname})
                            }


                            $starttime = $(get-date).ToUniversalTime()  
                            $endtime = $(get-date).AddMinutes($MMDuration).ToUniversalTime()

                            # PUT IN Maintenance Mode
                            $($ClassInstToMM | foreach {$_.schedulemaintenancemode($starttime,$endtime,$Reason,$Comment)})


                            # Display effective instances in MM
                            write-host "EFFECTIVE INSTANCES OF CLASS '$ClassName' IN MAINTENANCE MODE (Primary Managed by $PrimMS):"

                                # Get instances of "Health Service Watcher" Class
                                $ClassInstances = Get-SCOMClassInstance -Class $class

                                $ClassInstInMM = @()

                                # Get class instances that match agents
                                foreach ($agent in $agents)
                                { 
                                $ClassInstInMM += ($ClassInstances | Where-Object {$_.DisplayName -eq $agent.displayname})
                                }

                                $ClassInstInMM

                            }

    STOP
                                 {


                            # Get instances of "Health Service Watcher" Class
                            $ClassInstances = Get-SCOMClassInstance -Class $class

                            # Class to put out of MM Table
                            $ClassInstOoMM = @()

                            # Get class instances that match agents
                            foreach ($agent in $agents)
                            { 
                            $ClassInstOoMM += ($ClassInstances | Where-Object {$_.DisplayName -eq $agent.displayname})
                            }

                            # Only Endttime in necessary and it is now
                            $endtime = $(get-date).ToUniversalTime()  
                            

                            # PUT IN Maintenance Mode
                            $($ClassInstOoMM | foreach {$_.stopmaintenancemode($endtime)})


                            # Display effective instances in MM
                            write-host "EFFECTIVE INSTANCES OF CLASS '$ClassName' OUT OF MAINTENANCE MODE (Primary Managed by $PrimMS):"

                                # Get instances of "Health Service Watcher" Class
                                $ClassInstances = Get-SCOMClassInstance -Class $class

                                $ClassInstOoMM = @()

                                # Get class instances that match agents
                                foreach ($agent in $agents)
                                { 
                                $ClassInstOoMM += ($ClassInstances | Where-Object {$_.DisplayName -eq $agent.displayname})
                                }

                                $ClassInstOoMM

                            }


    DISPLAY                  
    
                                {

                            # Display effective instances in MM
                            write-host "`n INSTANCES OF CLASS '$ClassName' MAINTENANCE MODE STATE (Primary Managed by $PrimMS):"

                                # Get instances of "Health Service Watcher" Class
                                $ClassInstances = Get-SCOMClassInstance -Class $class

                                $ClassInstMM = @()
                                
                                # Get class instances that match agents
                                foreach ($agent in $agents)
                                { 
                                $ClassInstMM += ($ClassInstances | Where-Object {$_.DisplayName -eq $agent.displayname})
                                }

                                $ClassInstMM

                                }



    }

declare @StartDate  datetime
declare @EndDate    datetime
set @EndDate = GETDATE()
set @StartDate = DATEADD(day,-60,@EndDate)
 
SELECT DISTINCT MP.MPFriendlyName AS 'Management Pack'
, aov.ParentType AS 'Type'
,(CASE 
       WHEN AOV.OverrideType = 'RuleProperty' THEN R.RuleName 
       WHEN AOV.OverrideType = 'MonitorProperty' THEN M.MonitorName 
       WHEN AOV.OverrideType = 'RuleConfiguration' THEN R.RuleName 
       WHEN AOV.OverrideType = 'MonitorConfiguration' THEN M.MonitorName 
 END) AS 'NameType',
mt.DisplayName AS ContextDisplayName
, aov.OverrideableParameterName
, aov.Value,
(CASE Enforced 
       WHEN '0' THEN 'False' 
       WHEN '1' THEN 'True' 
  END) AS 'Enforced'
  , aov.LastModified
  , aov.TimeAdded
  ,(CASE 
  WHEN AOV.OverrideType = 'RuleProperty' THEN 
             (CASE R.RuleEnabled 
             WHEN '0' THEN 'False' 
             WHEN '2' THEN 'True' 
             WHEN '3' THEN 'True' 
             WHEN '4' THEN 'True' 
             END)
 
  WHEN AOV.OverrideType = 'MonitorProperty' THEN 
             (CASE M.MonitorEnabled 
             WHEN '0' THEN 'False' 
             WHEN '2' THEN 'True' 
             WHEN '3' THEN 'True' 
             WHEN '4' THEN 'True' 
             END)
 
  WHEN AOV.OverrideType = 'RuleConfiguration' THEN 
             (CASE R.RuleEnabled 
             WHEN '0' THEN 'False' 
             WHEN '2' THEN 'True' 
             WHEN '3' THEN 'True' 
             WHEN '4' THEN 'True' 
             END)
             
  WHEN AOV.OverrideType = 'MonitorConfiguration' THEN 
             (CASE M.MonitorEnabled 
             WHEN '0' THEN 'False' 
             WHEN '2' THEN 'True' 
             WHEN '3' THEN 'True'
             WHEN '4' THEN 'True' 
             END) 
END) AS 'Enable_by_default', MPSTORE.MPFriendlyName AS 'MP Stored'
 
FROM AllOverrideView AS aov 
LEFT OUTER JOIN Rules AS R WITH (nolock) ON aov.TargetId = R.RuleId AND (aov.OverrideType = 'RuleProperty' OR aov.OverrideType = 'RuleConfiguration') 
LEFT OUTER JOIN Monitor AS M WITH (nolock) ON aov.TargetId = M.MonitorId AND (aov.OverrideType = 'MonitorProperty' OR aov.OverrideType = 'MonitorConfiguration') 
LEFT OUTER JOIN  ManagementPack AS MP WITH (nolock) ON (CASE 
                                                                                              WHEN AOV.OverrideType = 'RuleProperty' THEN R.ManagementPackId 
                                                                                              WHEN AOV.OverrideType = 'RuleConfiguration' THEN R.ManagementPackId
                                                                                              WHEN AOV.OverrideType = 'MonitorProperty' THEN M.ManagementPackId 
                                                                                              WHEN AOV.OverrideType = 'MonitorConfiguration' THEN M.ManagementPackId
                                                                                              END) = MP.ManagementPackId 
INNER JOIN ManagementPack AS MPSTORE WITH (nolock) ON MPSTORE.ManagementPackId = aov.ManagementPackId 
LEFT OUTER JOIN ManagedTypeView AS mt WITH (nolock) ON mt.Id = aov.ContextId 
LEFT OUTER JOIN ManagedTypeView AS mtv WITH (nolock) ON mtv.Id = aov.ContextObjectId
 
WHERE (MP.MPFriendlyName IS NOT NULL) 
AND (aov.LastModified BETWEEN @StartDate AND @EndDate) 
OR (MP.MPFriendlyName IS NOT NULL) 
AND (aov.TimeAdded BETWEEN @StartDate AND @EndDate)
 
ORDER BY aov.TimeAdded DESC

 
 
# Fonction de recuperation de compteur de performance dans la base OperationsManager
 
    Function GetPerfValueFromScomv2($managementServer,$user,$passwd,$criteria,$monitoringClassId = $null,$monitoringObjectName = $null,$monitoringObjectDisplayName = $null,$objectName = $null,$counterName = $null,$instanceName = $null,$HourOffset,$startTime = (Get-Date).AddHours(-$HourWindow),$endTime = (Get-Date))
    {
 

#Fonction d'ajout de critere a la requete 
function Add-Criteria() 
{ 
    param($criteria,$clause) 
     
    if ($criteria -ne $null) 
        {$criteria += " AND $clause"} 
    else 
        {$criteria = $clause} 
         
    return($criteria) 
} 
 
 

#Import du module Scom 
import-module OperationsManager 
 
#Connexion au management server 
 
 
$mgConn = New-Object Microsoft.EnterpriseManagement.ManagementGroupConnectionSettings($managementServer)
$mgConn.UserName = $user
$mgConn.Password = $passwd
$mg = New-Object Microsoft.EnterpriseManagement.ManagementGroup($mgConn)
 
 
if ($criteria -eq $null) { 
    if ($monitoringClassId -ne $null) { $criteria = Add-Criteria -criteria $criteria -clause "MonitoringClassId = '{$monitoringClassId}'" } 
    if ($monitoringObjectDisplayName -ne $null) { $criteria = Add-Criteria -criteria $criteria -clause "MonitoringObjectDisplayName = '$monitoringObjectDisplayName'" } 
    if ($monitoringObjectName -ne $null) { $criteria = Add-Criteria -criteria $criteria -clause "MonitoringObjectName = '$monitoringObjectName'" } 
    if ($objectName -ne $null) { $criteria = Add-Criteria -criteria $criteria -clause "ObjectName = '$objectName'" } 
    if ($counterName -ne $null) { $criteria = Add-Criteria -criteria $criteria -clause "CounterName = '$counterName'" } 
    if ($instanceName -ne $null) { $criteria = Add-Criteria -criteria $criteria -clause "InstanceName = '$instanceName'" } 
} 
 
#Creation du reader 
$reader = $mg.GetMonitoringPerformanceDataReader($criteria) 
while ($reader.Read()) 
{ 
    #Creation de l'objet de performance
    $perfData = $reader.GetMonitoringPerformanceData() 
    $valueReader = $perfData.GetValueReader($startTime,$endTime) 
 
    #Renvoi des valeurs 
    while ($valueReader.Read()) 
    { 
        $perfValue = $valueReader.GetMonitoringPerformanceDataValue() 
        $perfValue 
    } 
}
 
}