Troubleshooting Alert Archiver Script

Hey all,

I'm stuck troubleshooting this PowerShell script. The purpose of the script is to backup alerts and store them in a folder as XML files. It is working flawlessly for the majority of alerts, however, there are 3 specific alerts that it is failing on. It goes as far as storing the alert XML file in the proper location but the file is empty. 

Any insight or assistance would be greatly appreciated!

Here is the error message and the 3 alerts that it's failing on. I've also included the full PowerShell script below:

Application Connection status is in Warning or Critical state

Exceeded AWS CloudWatch free polling limit

Exceeded Azure Cloud Monitor API free polling limit

Invoke-SwisVerb : ProvideFault failed, check fault information.
At C:\SW_Export\AlertArchiver.ps1:51 char:22
+ ... rtedAlert = Invoke-SwisVerb $swis Orion.AlertConfigurations Export $a ...
+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [Invoke-SwisVerb], FaultException`1
    + FullyQualifiedErrorId : SwisError,SwisPowerShell.InvokeSwisVerb

Import-Module pscx -Verbose

<#------------- FUNCTIONS -------------#>
Function Set-SwisConnection {
      [Parameter(Mandatory=$true, HelpMessage = "What SolarWinds server are you connecting to (Hostname or IP)?" ) ] [string] $solarWindsServer,
      [Parameter(Mandatory=$true, HelpMessage = "Do you want to use the credentials from PowerShell [Trusted], or a new login [Explicit]?" ) ] [ ValidateSet( 'Trusted', 'Explicit' ) ] [ string ] $connectionType,
      [Parameter(HelpMessage = "Which credentials should we use for an explicit logon type" ) ] $creds
  IF ( $connectionType -eq 'Trusted' ) {
    $swis = Connect-Swis -Trusted -Hostname $solarWindsServer
  } ELSEIF(!$creds) {
      $creds = Get-Credential -Message "Please provide a Domain or Local Login for SolarWinds"
      $swis = Connect-Swis -Credential $creds -Hostname $solarWindsServer
  } ELSE {
    $swis = Connect-Swis -Credential $creds -Hostname $solarWindsServer
  RETURN $swis

<#------------- ACTUAL SCRIPT -------------#>

$now = Get-Date -Format "yyyyMMdd_HHmm"
$script = $MyInvocation.MyCommand
try { $dir = Split-Path $script.path }
catch { }

$Logfile = "$dir\$($$now.log"
Start-Transcript -Path $Logfile -Append -IncludeInvocationHeader | Out-Null

while(!$swistest) {
  $hostname = Read-Host -Prompt "what server should we connect to?"
  $connectionType = Read-Host -Prompt "Should we use the current powershell credentials [Trusted], or specify credentials [Explicit]?"
  $swis = Set-SwisConnection $hostname $connectionType
  $swistest = get-swisdata $swis "SELECT TOP 1 servername FROM Orion.Websites"

"Connected to $hostname Successfully using $connectiontype credentials"

# set up path to current user desktop
$UserPath = "C:\SW_Export\Alerts\"
if((test-path $userpath) -eq $false) {$newfolder = md -path $UserPath}

# get enabled alerts
$Alerts = Get-SwisData -SwisConnection $swis -Query "SELECT AlertID, Name ,REPLACE(REPLACE(Name,':',''), '/', '') as NewName FROM Orion.AlertConfigurations WHERE Enabled = 'true' order by NewName"

# export the alerts to xml
foreach ($Alert in $Alerts) {
    $ExportedAlert = Invoke-SwisVerb $swis Orion.AlertConfigurations Export $alert.AlertID
    " Exporting alert named: $($alert.NewName) to $UserPath"
    $ExportedAlert | Format-Xml | Out-File ($UserPath + "$($alert.NewName).xml")


#Example of importing the alert back in
#$abc = ([xml](get-content -Path ($UserPath + "$($alert.Name).xml"))).return
#$result = Invoke-SwisVerb $swis Orion.AlertConfigurations Import $abc

Parents Reply Children
No Data