Cleanup is usually required on a weekly basis. This can be made easier by automation.
This SQL script delete volumes we don't really need monitored, but got pulled in accidentally.
$ErrorActionPreference = 'Stop'
Add-PSSnapin SwisSnapin
$swis = Connect-Swis -Hostname 1.1.1.1 -Username "admin" -Password "admin"
$volumes = Get-SwisData -SwisConnection $swis -Query "SELECT top 400 FullName, Status, StatusDescription,Caption, Type, Responding, VolumeDescription, Uri FROM Orion.Volumes v where v.node.Vendor like 'net-%' and v.type like 'fixed%'"
$urisToDelete=@()
foreach ($volume in $volumes) {
Write-Output "Volume: $($volume.fullname)"
$urisToDelete += $volume.Uri
}
#Take out the comment once you have verified that the correct volumes are selected
#$urisToDelete | Remove-SwisObject -SwisConnection $swis
I have had clients run these types of cleanup scripts after every discovery
Thank you
Amit
email: ashah@loop1.com
Loop1 Systems - SolarWinds Training and Professional Services
