Can I use SWQL Studio to delete nodes based on set criteria?

peter.lewis_NetWolves

I would like to delete nodes based on the following SWQL select statement:

SELECT DISTINCT NodeID FROM Orion.Nodes WHERE Status = 9 AND UnManageFrom < ADDYEAR(-1,GETDATE())

(3948 nodes)

I could do this with SQL Management Studio but am afraid this would break table relationships. Whereas, SWQL Studio enforces them.

The equivalent SQL would be as follows:

DELETE
FROM [NetWolves_Orion_NPM].[dbo].[NodesData]
WHERE [NodesData].[Status] = 9
AND CONVERT(date,[NetWolves_Orion_NPM].[dbo].[NodesData].[UnManageFrom] ) < CONVERT(date,DATEADD(year,-1,GETDATE()))

Please help. Thanks in advance. 

KMSigma.SWI

# Build a connection to your SolarWinds Orion Platform
$SwisConnection = Connect-Swis -Hostname "MyOrionServer.Domain.Local" -Username "MyUsername" -Password "myComplexPassword"

# This is your query - just reformmated and adding the URI as a returned property (for deletion) and caption (for pretty output)
$Query = @"
   SELECT DISTINCT [Nodes].NodeID
                 , [Nodes].Caption
                 , [Nodes].Uri
   FROM Orion.Nodes AS [Nodes]
   WHERE [Nodes].Status = 9
      AND [Nodes].UnManageFrom < ADDYEAR(-1,GETDATE())


# Get a list of nodes to delete
$NodesToDelete = Get-SwisData -SwisConnection $SwisConnection -Query $Query

# BEFORE YOU RUN THE BELOW THING, BE 100% - no 1,000% it's what you want, else you'll be restoring your database
ForEach ( $Node in $NodesToDelete ) {
   Write-Host "We're going to delete $( $Node.Caption )"
   #Remove-SwisObject -SwisConnection $SwisConnection -Uri $Node.Uri
}
# When you are ACTUALLY ready to run this, just remove the '#' from the front of the Remove-SwisObject function.