So last time I created some simple scripts for the Horizon View vCheck. This time I wanted to add some information about the Composer, Connection, security servers and the event database. So all in all I added four scripts that might seem to do the same but since the api’s treat the types of servers differently I decided to make separate scripts as well.
Please pull the scripts from Github since by the time you read this post things might have changed.
05 Connection Servers Status.ps1
This plugin pulls some information about the connection servers, if the status is ok and gives a warning if the Certificate will expire within 30 days. This period is something I need to change in the future to a setting so it will be customizable.
# Start of Settings
# End of Settings
$date=get-date
$datemaxexp=(get-date).adddays(30)
$conserverstatus=@()
$conservers=$services1.connectionserverhealth.connectionserverhealth_list()
foreach ($conserver in $conservers) {
if ($conserver.CertificateHealth.ExpirationTime -lt $date){
$expiring="Already Expired"
}
elseif ($conserver.CertificateHealth.ExpirationTime -lt $datemaxexp){
$expiring="Expiring in 30 days"
}
else {
$expiring="False"
}
$conserverstatus+=New-Object PSObject -Property @{"Name" = $conserver.name;
"Status" = $conserver.Status;
"Version" = $conserver.Version;
"Build" = $conserver.Build
"Certificate_Status" = $conserver.CertificateHealth.Valid;
"Certificate_Expiration_Time" = $conserver.CertificateHealth.ExpirationTime;
"Certificate_Expiring" = $expiring;
"Certificate_Invalidation_Reason" = $conserver.CertificateHealth.InValidReason;
}
}
$conserverstatus | select name,Status,Version,Build,Certificate_Status,Certificate_Expiring,Certificate_Expiration_Time,Certificate_Invalidation_Reason
$Title = "Connection Servers Status"
$Header = "Connection Servers Status"
$Comments = "These are the used Connection Servers"
$Display = "Table"
$Author = "Wouter Kursten"
$PluginVersion = 0.1
$PluginCategory = "View"
06 Security Servers Status.ps1
Almost the same as the connection servers but this time it checks for the security servers. I don’t run the appliance yet so will need to check on those somewhere as well.
# Start of Settings
# End of Settings
$date=get-date
$datemaxexp=(get-date).adddays(30)
$secserverstatus=@()
$secservers=$services1.securityserverhealth.securityserverhealth_list()
foreach ($secserver in $secservers) {
if ($secserver.CertificateHealth.ExpirationTime -lt $date){
$expiring="Already Expired"
}
elseif ($secserver.CertificateHealth.ExpirationTime -lt $datemaxexp){
$expiring="Expiring in 30 days"
}
else {
$expiring="False"
}
$secserverstatus+=New-Object PSObject -Property @{"Name" = $secserver.name;
"Status" = $secserver.Status;
"Version" = $secserver.Version;
"Build" = $secserver.Build
"Certificate_Status" = $secserver.CertificateHealth.Valid;
"Certificate_Expiration_Time" = $secserver.CertificateHealth.ExpirationTime;
"Certificate_Expiring" = $expiring;
"Certificate_Invalidation_Reason" = $secserver.CertificateHealth.InValidReason;
}
}
$secserverstatus | select name,Status,Version,Build,Certificate_Status,Certificate_Expiring,Certificate_Expiration_Time,Certificate_Invalidation_Reason
$Title = "Security Servers Status"
$Header = "Security Servers Status"
$Comments = "These are the used Security Servers"
$Display = "Table"
$Author = "Wouter Kursten"
$PluginVersion = 0.1
$PluginCategory = "View"
07 Composer Servers Status.ps1
Strangely enough the composer server doesn’t have a status in the api’s. I would have expected at least something for it being available or not. Because of this I only added information and the vCenter server it is connecting to. Another weird thing (might be me offcourse) is that the vcentername actually gives a plural output even though composer and vCenter have a 1on1 relation,
# Start of Settings
# End of Settings
$comserverstatus=@()
$comservers=$services1.viewcomposerhealth.viewcomposerhealth_list()
foreach ($comserver in $comservers) {
$vcenters=$comserver.data.virtualcenters
foreach ($vcenter in $vcenters){
if ($vcenternames){
$vcenternames+=","
$vcenternames+=($services1.virtualcenterhealth.virtualcenterhealth_get($vcenter)).data.name
}
else{
$vcenternames+=($services1.virtualcenterhealth.virtualcenterhealth_get($vcenter)).data.name
}
}
$comserverstatus+=New-Object PSObject -Property @{"Name" = $comserver.ServerName;
"Version" = $comserver.Data.Version;
"Build" = $comserver.Data.Build;
"vCenter_Server"= $vcenternames
}
}
$comserverstatus | select name,Version,Build,vcenter_server
$Title = "Composer Servers Status"
$Header = "Composer Servers Status"
$Comments = "These are the used Composer Servers"
$Display = "Table"
$Author = "Wouter Kursten"
$PluginVersion = 0.1
$PluginCategory = "View"
08 Event Database Status.ps1
For the event database I decided to give as much information as possible from the api’s. Maybe in the future it could pull some information from the sql server itself but I think that should be covered by a sql check.
# Start of Settings
# End of Settings
$eventdbstatus=@()
$eventdb=$services1.EventDatabaseHealth.EventDatabaseHealth_get()
if ($eventdb.configured -eq $True){
$eventdbstatus+=New-Object PSObject -Property @{"Servername" = $eventdb.data.Servername;
"Port" = $eventdb.data.Port;
"Status" = $eventdb.data.State;
"Username" = $eventdb.data.Username;
"DatabaseName" = $eventdb.data.DatabaseName
"TablePrefix" = $eventdb.data.TablePrefix;
"State" = $eventdb.data.State;
"Error" = $eventdb.data.Error;
}
}
$eventdbstatus | select Servername,Port,Status,Username,DatabaseName,TablePrefix,State,Error
$Title = "Event Database Status"
$Header = "Event Database Status"
$Comments = "These are the settings for the Event Database"
$Display = "Table"
$Author = "Wouter Kursten"
$PluginVersion = 0.1
$PluginCategory = "View"
The result
