1)We have 2 Solarwinds silos. With one silo we are able to connect and run queries with accounts that have read access to Solarwinds.
$swis = Connect-Swis -Hostname silo1
Get-SwisData -SwisConnection $swis -Query 'SELECT DNS FROM Orion.Nodes'
2)With silo 2, we get an error message. We can only run queries that have Admin in the Solarwinds console and that are in the administrative group on primary application server. We get this error message:
$swis = Connect-Swis -Hostname silo2
Get-SwisData -SwisConnection $swis -Query 'SELECT DNS FROM Orion.Nodes'
PS C:\Users\wh24xu> C:\Powershell\SWIS\SWIS-get-node-names-ATC.ps1
cmdlet Connect-Swis at command pipeline position 1
Supply values for the following parameters:
(Type !? for Help.)
Get-SwisData : An error occurred when verifying security for the message.
At C:\Powershell\SWIS\SWIS-get-node-names-ATC.ps1:2 char:1
+ Get-SwisData -SwisConnection $swis -Query 'SELECT DNS FROM Orion.Node ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [Get-SwisData], MessageSecurityException
+ FullyQualifiedErrorId : SwisError,SwisPowerShell.GetSwisData
We opened a support case, but they do not support troubleshooting these problems. I am thinking there is some type of permission we need to set on silo 2's application/primary poller. I'm just not sure what security setting we need to set. I get this error if I use an account that has admin in the Solarwinds console, but does not have admin on the app server. We need to provide accounts with read access the ability to run SWIS queries.
Thanks in advance.
