PI Services

##############################################################################

# SCRIPT DE RECUPERATION DES ALERTES D'UNE APPLIANCE HPONEVIEW ET MISE EN ETAT CLEARED
# author: cjourdan

 

# PARAMETRES:
# $ApplianceName: Nom de l'appliance
# $RessourceName: Nom de la ressource (Server,Enclosure ...).
# $DomainName: Domaine AD.
# $AlertSeverity: Critical, Warning, OK, Unknown, Disabled
# $AlertState: Active, Locked, Cleared, Pending, Running, Completed, Interrupted, Error, Warning, Terminated, Killed.
# $DescInclude: Chaine de caractère dans la champ Description a inclure dans la recherche.
# $DescExclude: Chaine de caractère dans la champ Description a exclure de la recherche.
# $DayOffset = Recuperer les alertes plus recente que J-DayOffset.


# Apres Recuperation des alertes, le script demande validation pour mettre les alertes en état Cleared


Param(

[Parameter(Mandatory=$false)]

$ApplianceName = "MyAppliance",

[Parameter(Mandatory=$false)]

# Server,Enclosure ...

$RessourceName = "MyResource",

[Parameter(Mandatory=$false)]

$DomainName = "MyDomain",

[Parameter(Mandatory=$false)]

$AlertSeverity = "Critical",

[Parameter(Mandatory=$false)]

$AlertState = "Cleared",

$DescInclude = "*",

$DescExclude = "azerty",

$DayOffset = 2

)

 

$user = Read-Host -Prompt "Enter MyDomain Credential without Domain" 

$passwd = Read-Host -Prompt "Password" -AsSecureString

 

if (-not (get-module HPOneview.200)) 

{
 

    Import-Module HPOneView.200
 

}

 

# Connexion a l'appliance OneView

if (-not($global:ConnectedSessions))

{ 
       

       Connect-HPOVMgmt -Hostname $ApplianceName -UserName $user -Password $passwd -AuthLoginDomain $DomainName
 

}

 

write-host -BackgroundColor White -ForegroundColor Blue "APPLIANCE ONEVIEW: $ApplianceName"`n

 

# NB: Preciser au minimum un filtre de recherche avant le '|' afin de reduire le temps de recuperation des alertes

Try

{

    $Alerts = Get-HPOVAlert -ApplianceConnection $ApplianceName -Severity $AlertSeverity | Where-Object {$_.AlertState -eq $AlertState `

    -AND $_.associatedresource -like "*$RessourceName*" `

    -AND $_.description -like "*$DescInclude*" `

    -AND $_.description -notlike "*$DescExclude*"`

    -AND $([datetime]$_.created) -gt $(get-date).AddDays(-$DayOffset)

    } 

 

    $FormAlerts = foreach ($alert in $Alerts)

        {

        Write-output "DESCRIPTION: "$alert.description"" ;

        Write-Output "SEVERITY: "$alert.severity"" ;

        Write-Output "STATE: "$alert.alertState"" ;

        Write-Output "CREATED: "(get-date -format G $alert.Created)"" ;

        Write-Output "CLEARED: "(get-date -format G $alert.clearedtime)"" ;

        Write-Output "RESSOURCE_NAME: "$alert.associatedresource.resourcename"" ; 

        Write-Output "APPLIANCE: "$alert.ApplianceConnection.Name"" ;

        Write-Output "" ; 

        Write-Output "*******************" ;

        Write-Output ""

        } 

 

    write-host -BackgroundColor White -ForegroundColor Blue "CRITERES DE RECHERCHE: Resource: $RessourceName / Severity: $AlertSeverity / Status: $AlertState /  a inclure: $DescInclude / a exclure: $DescExclude / Plus recentes que: J-$DayOffset"`n

    $count=$Alerts | Measure-Object | select count -ExpandProperty count

    write-host -BackgroundColor White -ForegroundColor Blue "NOMBRE D ALERTES: $count" `n

    $FormAlerts

 

}

 

Catch

{

       Write-Error -ErrorRecord $_ -ErrorAction Stop

}


$answer = Read-Host -Prompt "VOULEZ VOUS MODIFIER L'ETAT DES CES ALERTES EN ETAT 'CLEARED' ?: Y/N"
 

switch($answer)

    {

        "Y" {"MISE EN ETAT CLEARED"}

        "N" {"AUCUNE ACTION" ; exit}

        default {"MAUVAISE REPONSE - AUCUNE ACTION" ; exit}

    }

 

# Clear Alerts


         Try

         {

          $updatedAlert = $Alerts | set-HPOVAlert -Cleared
         
         }

             Catch

             {
             Write-Error -ErrorRecord $_ -ErrorAction Stop
             }


    $updatedAlert

 

    Write-Host -ForegroundColor Green "MISE EN ETAT CLEARED TERMINEE SANS ERREUR !"

#SCOM - SCRIPT DE REQUETE D'ETAT DES OBJETS D'UNE LISTE DE CLASSE


#Variables
$MGroup = "MyGroup"
$MS= "MyMS"
$cred = Get-Credential "MyDomain\"

#Liste de classe a recuperer
$ClassList = ('SQL DB Engine','SQL Database','SQL DB File','SQL Agent','SQL Reporting Services','SQL Analysis Services')


#Import du module SCOM
try
{
Import-Module -Name OperationsManager -ErrorAction stop
}
catch
{
write-host -ForegroundColor red "Erreur lors de l'import du module SCOM"
}


#Connection au management group $MGroup
New-SCOMManagementGroupConnection -ComputerName $MS -Credential $cred


#Recuperation des classes
$MonitoringClasses = $ClassList | foreach {Get-SCOMClass -DisplayName $_}

if ($MonitoringClasses -eq $null)
    {
    write-host "ERROR - UNABLE TO RETRIEVE CLASSES" -ForegroundColor red
    }


write-host "#################################################### `n"
write-host "SCOM Management Group: $MGroup `n"
write-host "#################################################### `n`n"


#Recuperation des instances de chaque classe
foreach ($class in $MonitoringClasses)
{
        $MonitoringObjects =  $class | Get-SCOMClassInstance -erroraction silentlycontinue | Sort-Object -Descending -Property HealthState
 

        write-host -BackgroundColor white -ForegroundColor blue "         **************************************************************** `n"
        write-host -BackgroundColor white -ForegroundColor blue "         *** OBJETS DE LA CLASSE "$class.displayname" `n"
        write-host -BackgroundColor white -ForegroundColor blue "         **************************************************************** `n`n"

 

        write-host "         --- $(get-date -Format F) --- `n`n"

        write-host "         NUMBER OF OBJECT: $($MonitoringObjects | measure-object | select-object -property count -expandproperty count) `n`n"

        write-host "         STATE ----------------- OBJECT`n`n"

 

            foreach ($object in $MonitoringObjects)
            {
            switch ($object.HealthState)
                {
                "Success"          {write-host "         " -NoNewline ; write-host -ForegroundColor green $object.HealthState -NoNewline ; write-host " -------- " -NoNewline ; write-host  $object.FullName}
                "Error"            {write-host "         " -NoNewline ; write-host -ForegroundColor red $object.HealthState -NoNewline ; write-host " -------- " -NoNewline ;write-host  $object.FullName}
                "Warning"          {write-host "         " -NoNewline ; write-host -ForegroundColor yellow $object.HealthState -NoNewline ; write-host " -------- " -NoNewline ;write-host  $object.FullName}
                "Uninitialized"    {write-host "         " -NoNewline ; write-host -ForegroundColor blue $object.HealthState -NoNewline ; write-host " -------- " -NoNewline ;write-host  $object.FullName}
                }

            }

         "`n"

}

#Fermeture de la connexion
Get-SCOMManagementGroupConnection | Remove-SCOMManagementGroupConnection
 

 

 

#SCOM - SCRIPT DE REQUETE D'ETAT DES OBJETS D'UNE LISTE DE CLASSE (AVEC GENERATION RAPPORT HTML)
 

#Variables
$MGroup = "MyGroup"
$MS= "MyMS"
$cred = Get-Credential "MyDomain"

#Liste de classe a recuperer
$ClassList = ('SQL DB Engine','SQL Database','SQL DB File','SQL Agent','SQL Reporting Services','SQL Analysis Services')
$backcolor = "#E0ECF8"
 

#Import du module SCOM
try
{
Import-Module -Name OperationsManager -ErrorAction stop
}
catch
{
write-host -ForegroundColor red "Erreur lors de l'import du module SCOM"
}
 

#Connection au management group $MGroup
New-SCOMManagementGroupConnection -ComputerName $MS -Credential $cred
 

#Recuperation des classes
$MonitoringClasses = $ClassList | foreach {Get-SCOMClass -DisplayName $_}

if ($MonitoringClasses -eq $null)

    {
    write-host "ERROR - UNABLE TO RETRIEVE CLASSES" -ForegroundColor red
    }

    $report = "<style>BODY{background-color:$backcolor;}</style>"
 

    $report = $report + "<br/>"
    $report = $report + "############################################################################## <br/>"
    $report = $report + "SCOM Management Group: <b>$MGroup</b> <br/>"
    $report = $report + "############################################################################## <br/><br/>"

 

#Recuperation des instances de la classe
foreach ($class in $MonitoringClasses)

{
    $MonitoringObjects = $class | Get-SCOMClassInstance -erroraction silentlycontinue | Sort-Object -Descending -Property HealthState
    $classdisplayname = $class.displayname

    $report = $report + "&emsp;&emsp;**************************************************************** <br/>"
    $report = $report + "&emsp;&emsp;*** OBJECTS OF CLASS <b>$classdisplayname</b> <br/>"
    $report = $report + "&emsp;&emsp;**************************************************************** <br/>"
     
    $report = $report + "&emsp;&emsp;--- $(get-date -Format F) --- <br/><br/>"
    
    $report = $report + "&emsp;&emsp;NUMBER OF OBJECT: $($MonitoringObjects | measure-object | select-object -property count -expandproperty count) <br/><br/>"
    
    $report = $report + "&emsp;&emsp;STATE ---------- OBJECT <br/><br/>"

  

    foreach ($object in $MonitoringObjects)
                {
                switch ($object.HealthState)
                {
                "Success"          {$report = $report + $("&emsp;&emsp;"; "<font color=#00DF00>" ; $object.HealthState ; "</font>" ; "--------" ; $object.FullName ; "<br/>")}
                "Error"            {$report = $report + $("&emsp;&emsp;";"<font color=#FF0000>" ; $object.HealthState ; "</font>" ; "--------" ; $object.FullName ; "<br/>")}
                "Warning"          {$report = $report + $("&emsp;&emsp;";"<font color=#FFFF00>" ; $object.HealthState ; "</font>" ; "--------" ; $object.FullName ; "<br/>")}
                "Uninitialized"    {$report = $report + $("&emsp;&emsp;";"<font color=#0000FF>" ; $object.HealthState ; "</font>" ; "--------" ; $object.FullName ; "<br/>")}
                }

            }
             

         $report = $report + "<br/><br/><br/>"
          

}

 
ConvertTo-Html -Body $report | Set-Content P:\InstanceList.htm

 
#Fermeture de la connexion
Get-SCOMManagementGroupConnection | Remove-SCOMManagementGroupConnection
 

#Execution du html
Invoke-Expression P:\InstanceList.htm

#SCOM - SCRIPT DE REQUETE D'ETAT DES OBJETS D'UNE LISTE DE CLASSE


#Variables
$MGroup = "MyGroup"
$MS= "MyMS"
$cred = Get-Credential "MyDomain\"

#Liste de classe a recuperer
$ClassList = ('SQL DB Engine','SQL Database','SQL DB File','SQL Agent','SQL Reporting Services','SQL Analysis Services')


#Import du module SCOM
try
{
Import-Module -Name OperationsManager -ErrorAction stop
}
catch
{
write-host -ForegroundColor red "Erreur lors de l'import du module SCOM"
}


#Connection au management group $MGroup
New-SCOMManagementGroupConnection -ComputerName $MS -Credential $cred


#Recuperation des classes
$MonitoringClasses = $ClassList | foreach {Get-SCOMClass -DisplayName $_}

if ($MonitoringClasses -eq $null)
    {
    write-host "ERROR - UNABLE TO RETRIEVE CLASSES" -ForegroundColor red
    }


write-host "#################################################### `n"
write-host "SCOM Management Group: $MGroup `n"
write-host "#################################################### `n`n"


#Recuperation des instances de chaque classe
foreach ($class in $MonitoringClasses)
{
        $MonitoringObjects =  $class | Get-SCOMClassInstance -erroraction silentlycontinue | Sort-Object -Descending -Property HealthState
 

        write-host -BackgroundColor white -ForegroundColor blue "         **************************************************************** `n"
        write-host -BackgroundColor white -ForegroundColor blue "         *** OBJETS DE LA CLASSE "$class.displayname" `n"
        write-host -BackgroundColor white -ForegroundColor blue "         **************************************************************** `n`n"

 

        write-host "         --- $(get-date -Format F) --- `n`n"

        write-host "         NUMBER OF OBJECT: $($MonitoringObjects | measure-object | select-object -property count -expandproperty count) `n`n"

        write-host "         STATE ----------------- OBJECT`n`n"

 

            foreach ($object in $MonitoringObjects)
            {
            switch ($object.HealthState)
                {
                "Success"          {write-host "         " -NoNewline ; write-host -ForegroundColor green $object.HealthState -NoNewline ; write-host " -------- " -NoNewline ; write-host  $object.FullName}
                "Error"            {write-host "         " -NoNewline ; write-host -ForegroundColor red $object.HealthState -NoNewline ; write-host " -------- " -NoNewline ;write-host  $object.FullName}
                "Warning"          {write-host "         " -NoNewline ; write-host -ForegroundColor yellow $object.HealthState -NoNewline ; write-host " -------- " -NoNewline ;write-host  $object.FullName}
                "Uninitialized"    {write-host "         " -NoNewline ; write-host -ForegroundColor blue $object.HealthState -NoNewline ; write-host " -------- " -NoNewline ;write-host  $object.FullName}
                }

            }

         "`n"

}

#Fermeture de la connexion
Get-SCOMManagementGroupConnection | Remove-SCOMManagementGroupConnection
 

 

 

#SCRIPT DE RAPPORT DES CERTIFICATS ARRIVANT A EXPIRATION
# ! : La variable $computername doit contenir imperativement le FQDN du serveur ADCS 


#Parametres 
param( 
  [string]$computername = "$env:computername.$env:userdnsdomain",
  $offset = 60,
  $WarnNbCert = 1
  )


$Scriptname = "Check_ADCS_Certificat_Expiration"

#Verification de l'existence d'une source ayant le nom du script dans l'eventlog Application pour loguer certains events
Function NewEventSource
{
if(!(Test-Path "HKLM:\SYSTEM\CurrentControlSet\services\eventlog\Application\$Scriptname"))
    {
    New-EventLog -LogName "Application" -Source $Scriptname
    }
}


#Log du lancement du script
NewEventSource
Write-EventLog -LogName application -Source $Scriptname -EntryType Information -EventId 1002 -Message "Execution du script $Scriptname"

#Write-Host 
Write-Host “Rapport des certificats délivrés par $computername arrivant a expiration dans $offset jours” -ForegroundColor “Yellow” 



#Import PSPKI PowerShell module 
if(Get-Module -Name PSPKI | Where-Object { $_.name -eq “PSPKI” }) 
{ 
Write-Host “PSPKI PowerShell module already imported…” -ForegroundColor “Yellow” 
} 
else 
{ 
Write-Host “Importing PSPKI PowerShell module…” -ForegroundColor “Yellow” 
    try
    {
    Import-Module -Name PSPKI
    }
    catch
    {
    write-host "Erreur lors de l'import du module PSPKI - Verifier que le module est disponible"
    } 
} 
Write-Host


Write-Host 
$caname = $computername.ToLower() 
$todaysdate = Get-Date
$count = Get-CertificationAuthority $caname | Get-IssuedRequest -Filter “NotAfter -ge $todaysdate”, “NotAfter -le $((Get-Date).AddDays($offset))” | Measure-Object | Select-Object -Property Count -ExpandProperty count
$countdisplay = "Nombre de certificats délivrés par $computername arrivant a expiration dans $offset jours: $count `n"
write-host -BackgroundColor white -ForegroundColor Blue $countdisplay

$display = $(Get-CertificationAuthority $caname | Get-IssuedRequest -Filter "NotAfter -ge $todaysdate", "NotAfter -le $((Get-Date).AddDays($offset))")
write-host "DETAILS:"
$display

$result = $display | foreach {$_.CommonName ; ":" ; $_.NotAfter ; " **** "}


# Ajout a l'eventlog
if ($count -ge $WarnNbCert)
{
NewEventSource
Write-EventLog -LogName application -Source $Scriptname -EntryType Warning -EventId 1001 -Message "$countdisplay (CommonName : NotAfter) `n $result"
}
Else
{
NewEventSource
Write-EventLog -LogName application -Source $Scriptname -EntryType Information -EventId 1000 -Message "$countdisplay"
}