Hi,
Yes it is possible to enumerate the event information (by ID) in OCUM using the SDK. The database schema between OCUM6.3\6.4 has changed so you would need to modify the query. I'd recommend invoking a ZAPI call rather than a SQL query to enumerate the event information as the schema might change in future. To do this you will need to download the SDK as the "ManageOntap.dll" file is required. This file is located in the "netapp-manageability-sdk-5.6\lib\DotNet" folder when you extract the download.
Note that if you are using WFA you can also copy the file from the "\PoSH\Modules\WFAWrapper" folder in your WFA installation directory (default "C:\Program Files\NetApp\WFA\PoSH\Modules\WFAWrapper"). Although I'd recommend using the latest "ManageOntap.dll" file from the NMSDK though to ensure the ZAPI's work with OCUM6.4\7.0. You can download the NMSDK here:
http://mysupport.netapp.com/NOW/download/software/nmsdk/5.6/
Here is some "example" source code that enumerates OCUM event information by Event ID. If you are attaching a script to an alarm then the Event ID is $args[1].
Example Event (OCUM GUI)
Example Output:
PS C:\Scripts\PowerShell\Projects\OCUM> .\ocum.ps1 -EventId 7 Loaded file "C:\Scripts\PowerShell\Projects\OCUM\ManageOntap.dll" Invoking API "dfm-about" to check connectivity to "TESTOC64" using the "HTTPS" protocol Event About: Availability of spare disks for aggregates in a cluster Event Category: Cluster with Low Spare Disks Event Condition: The cluster lacks spare disks on nodes - testc2n1. Event Impact Area: availability Event Impact Area: risk Event Name: Cluster Lacks Spare Disks Event Type: cluster.spares Event Source Type: cluster Event Source Name: cluster2 Event Source Resource Key: b3e53f0a-dc85-11e6-acfc-005056ac4ac8:type=cluster,uuid=b3e53f0a-dc85-11e6-acfc-005056ac4ac8 Event State: NEW Event Time: 01/18/2017 11:09:28
Note: You need to save the "ManageOntap.dll" file in the same folder as the script. EG:
C:\Scripts\PowerShell\Projects\OCUM>dir /b ManageOntap.dll ocum.ps1
It the code below you will be securely prompted for credentials for the admin OCUM user. If you want to automate the process you will need to cache\encrypt administrative credentials on your OCUM server (IE to a file or registry key)
Source Code:
Param(
[Parameter(Mandatory = $True, HelpMessage = "The OCUM Event ID to enumerate")]
[Int]$EventId
)
#'------------------------------------------------------------------------------
Function ConvertFrom-UnixTimestamp{
[CmdletBinding()]
Param(
[Parameter(Position=0,
Mandatory=$True,
ValueFromPipeLine=$True,
ValueFromPipeLineByPropertyName=$True)]
[String]$Timestamp
)
[TimeZone]::CurrentTimeZone.ToLocalTime(([DateTime]'1/1/1970').AddSeconds($Timestamp))
}#End Function
#'------------------------------------------------------------------------------
Function New-ZapiServer{
<#
.SYNOPSIS
Cmdlet to create a new ZAPI server object.
.DESCRIPTION
The cmdlet creates a ZAPI object from which Data ONTAP or Unified Manager ZAPIs can be called.
.PARAMETER Host
The server hostname or IP address
.PARAMETER Port
The port number to connet to. For HTTPS, use 443
.PARAMETER Type
The connecting server type. Valid values are FILER for Data ONTAP and
DFM for a Unified Manager server.
.PARAMETER VFiler
The vFiler unit name in the Filer. Used with the type "FILER" for running ZAPIs on the
specified vFiler unit.
.EXAMPLE
New-ZapiServer -Host $DFMServerName -Type DFM -Credentials $credentials
#>
Param(
[Parameter(Mandatory = $True)]
[String]$HostName,
[Parameter(Mandatory = $False)]
[Int]$PortNumber,
[Parameter(Mandatory = $True)]
[ValidateSet("FILER", "DFM")]
[String]$ZapiType,
[Parameter(Mandatory = $True)]
[System.Management.Automation.PSCredential]$Credentials,
[Parameter(Mandatory = $False)]
[String]$VFiler
)
#'---------------------------------------------------------------------------
#'Create the NaServer server object based on the ZAPI type.
#'---------------------------------------------------------------------------
If($ZapiType -eq "DFM"){
[NetApp.Manage.NaServer]$zapiServer = New-Object NetApp.Manage.NaServer($HostName, "1", "0")
}Else{
[NetApp.Manage.NaServer]$zapiServer = New-Object NetApp.Manage.NaServer($HostName, "1", "14")
If($VFiler -And $VFiler.Length -gt 0){
$zapiServer.SetVfilerTunneling($VFiler)
}
}
#'---------------------------------------------------------------------------
#'Enumerate the username and password from the credential object.
#'---------------------------------------------------------------------------
[String]$domain = $credentials.GetNetworkCredential().domain
[String]$user = $credentials.GetNetworkCredential().username
[String]$password = $credentials.GetNetworkCredential().password
If($domain -ne "" -Or $domain -ne $Null){
If($domain.Contains(".")){
[String]$userName = "$user`@$domain"
}Else{
If($credentials.UserName.Contains("\") -And $credentials.UserName.SubString(0, 1) -ne "\"){
[String]$userName = $credentials.UserName
}Else{
[String]$userName = $user
}
}
}
#'---------------------------------------------------------------------------
#'Set the username and password for the NaServer object.
#'---------------------------------------------------------------------------
$zapiServer.SetAdminUser($userName, $password)
$zapiServer.ServerType = $ZapiType
If($PortNumber){
$zapiServer.port = $PortNumber
}
#'---------------------------------------------------------------------------
#'Check connectivity using HTTPS
#'---------------------------------------------------------------------------
$zapiServer.TransportType = 'HTTPS'
$result = Check-ZapiConnection -ZapiServer $zapiServer -ZapiType $ZapiType -HostName $HostName -ProtocolName "HTTPS"
If($result -eq -1){
Write-Host "Failed connecting to ""$HostName"" using the ""HTTPS"" protocol"
#'------------------------------------------------------------------------
#'Check connectivity using HTTP
#'------------------------------------------------------------------------
$zapiServer.TransportType = 'HTTP'
$result = Check-ZapiConnection -ZapiServer $zapiServer -ZapiType $ZapiType -HostName $HostName -ProtocolName "HTTP"
If($result -eq -1){
Write-Warning -Message $("Failed connecting to ""$HostName"" using the ""HTTP"" protocol")
Return -1;
}
}
Return $zapiServer;
}#End Function
#'------------------------------------------------------------------------------
Function Check-ZapiConnection{
Param(
[Parameter(Mandatory = $True)]
[NetApp.Manage.NaServer]$ZapiServer,
[Parameter(Mandatory = $True)]
[ValidateSet("FILER", "DFM")]
[String]$ZapiType,
[Parameter(Mandatory = $True)]
[String]$HostName,
[Parameter(Mandatory = $True)]
[String]$ProtocolName
)
#'---------------------------------------------------------------------------
#'invoke the API based on the ZAPI type.
#'---------------------------------------------------------------------------
If($ZapiType -eq "DFM"){
Try{
[String]$apiName = "dfm-about"
Write-Host "Invoking API ""$apiName"" to check connectivity to ""$HostName"" using the ""$ProtocolName"" protocol"
$output = $ZapiServer.Invoke($apiName)
}Catch{
Return -1
}
}Else{
Try{
[String]$apiName = "system-get-version"
Write-Host "Invoking API ""$apiName"" to check connectivity to ""$HostName"" using the ""$ProtocolName"" protocol"
$output = $ZapiServer.Invoke($apiName)
}Catch{
Return -1
}
}
Return 0;
}#End Function
#'------------------------------------------------------------------------------
#'Initialization Section. Define Global Variables.
#'------------------------------------------------------------------------------
[String]$scriptPath = Split-Path($MyInvocation.MyCommand.Path)
[String]$scriptSpec = $MyInvocation.MyCommand.Definition
[String]$scriptBaseName = (Get-Item $scriptSpec).BaseName
[String]$scriptName = (Get-Item $scriptSpec).Name
[String]$fileSpec = "$scriptPath\ManageOntap.dll"
[String]$zapiType = "DFM"
[Int]$zapiPortNumber = 443
[String]$hostname = $env:computername
#'------------------------------------------------------------------------------
#'Load the "ManageONTAP.dll" file
#'------------------------------------------------------------------------------
Try{
[Reflection.Assembly]::LoadFile($fileSpec) | Out-Null
Write-Host "Loaded file ""$fileSpec"""
}Catch{
Write-Warning -Message $("Failed loading file ""$fileSpec"". Error " + $_.Exception.Message)
Break;;
}
#'------------------------------------------------------------------------------
#'Prompt for OCUM credentials.
#'------------------------------------------------------------------------------
[System.Management.Automation.PSCredential]$ocumCredentials = Get-Credential -Credential admin
#'------------------------------------------------------------------------------
#'Create a ZAPI connection to the DFM server.
#'------------------------------------------------------------------------------
$naServer = New-ZapiServer -HostName $hostName -PortNumber $zapiPortNumber -ZapiType $zapiType -Credentials $ocumCredentials
#'------------------------------------------------------------------------------
If($naServer -eq -1){
Write-Warning -Message "Failed creating ZAPI connection to ""$HostName"""
Break;
}
#'------------------------------------------------------------------------------
#'Invoke the ZAPI.
#'------------------------------------------------------------------------------
Try{
$naElement = New-Object NetApp.Manage.naElement("event-iter")
$naElement.AddNewChild("event-id", $eventID)
$naElement.AddNewChild("max-records", "1");
[Xml]$output = $naServer.InvokeElem($naElement)
}Catch{
Write-Warning -Message $("Failed invoking ZAPI on ""$HostName"". Error " + $_.Exception.Message)
Break;
}
#'------------------------------------------------------------------------------
#'Set variables from ZAPI results.
#'------------------------------------------------------------------------------
$events = $output.results.'records'.'event-info'
ForEach($event In $events){
[String]$eventAbout = $event.'event-about'
[String]$eventCategory = $event.'event-category'
[String]$eventCondition = $event.'event-condition'
[String]$eventImpactArea = $event.'event-impact-area'
[String]$eventImpactLevel = $event.'event-impact-level'
[String]$eventName = $event.'event-name'
[String]$eventType = $event.'event-type'
[String]$eventSeverity = $event.'event-severity'
[String]$eventSourceType = $event.'event-source-type'
[String]$eventSourceName = $event.'event-source-name'
[String]$eventSourceResourceKey = $event.'event-source-resource-key'
[String]$eventState = $event.'event-state'
[String]$eventTime = ConvertFrom-UnixTimestamp -TimeStamp $($event.'event-time')
}
#'------------------------------------------------------------------------------
#'Display the event information.
#'------------------------------------------------------------------------------
Write-Host "Event About: $eventAbout"
Write-Host "Event Category: $eventCategory"
Write-Host "Event Condition: $eventCondition"
Write-Host "Event Impact Area: $eventImpactArea"
Write-Host "Event Impact Area: $eventImpactLevel"
Write-Host "Event Name: $eventName"
Write-Host "Event Type: $eventType"
Write-Host "Event Source Type: $eventSourceType"
Write-Host "Event Source Name: $eventSourceName"
Write-Host "Event Source Resource Key: $eventSourceResourceKey"
Write-Host "Event State: $eventState"
Write-Host "Event Time: $eventTime"
#'------------------------------------------------------------------------------Hope that helps
/Matt
Public