I realise I've had answers that include implicit joins but no matter how many times I read them I just can't get my head around creating a query of my own from scratch that uses this functionality. So in SWQL Studio I want to run a report showing me the licensed status of nodes and then JOIN in the caption names. I can do…
We have recently upgraded from an older version of Orion to 2020.02.0896 and SWIS authentication no longer works in the existing scripts. The error returned is "Get-SwisData : Invalid username or password." This is the original code. $swis = Connect-Swis -Hostname Server -Credential $DomainCredential Get-SwisData $swis…
Hello, I am very new to SolarWinds. I have no background in SQL/SWQL. I have been doing some online learning through the THWACK youtube channel and am looking for a SWQL query to give me a count of down managed nodes. There appear to be lots of queries for nodes that are up but not too many showing alerts if they are down.…
Hi again, Is there a way or a work arround to delete account that its type is 4 (AD Account member) from the database? I tried using the DeleteAccount verb of the SDK but it retruns 404 error saying that cannot delete windows group member account. If possible i don't want to delete it directly from sql query cause i don't…
What would be the command to update an alarm custom property. We have an action that creates an incident in our SM tool via a powershell script from an alarm. I want to be able to return the incident number (and maybe an embedded link back to the incident in the sm tool) back to a custom alarm property I have created…
Hello All, I Founded when looking in my enterprise database an account with accountType=4. I know that: 1=individual account 2=windowsuser account 3=windowsgroup account 5=samluser account 6=samlgroup account but what is 4?? I haven't try logging in to see if it can actually be logged in but i was curious about this.…
Hi everybody, We have a number of new devices to be added to Solarwinds and they have different pollers to measure temperature, power phases and humidity. All these are custom pollers that should be added/enabled by the script too. The challenge here for me is to find a way to add a particular poller, say I have…
Is it possible to add a device incl. correct SNMPv3 credential set. Don't want to use discovery option in script. Can SNMPv3 work like SNMPv2 does. Example could be: ... $newNodeProps = @{ IPAddress = $ip; EngineID = 1; # SNMP v2 specific ObjectSubType = "SNMP"; SNMPVersion = 3; SNMPv3Credentials = "SNMPv3CredSet" DNS =…
Hi All, Was trying to update customproperties on srm object earlier, found I had to build the customrproperties uri manually as it was unfilled in the DB for at least the StorageArray and Vserver tables. Is that intentional? Shouldnt this either be filled or removed? SELECT TOP 5 n.uri, n.customproperties.uri from…
It looks like you're new here. Sign in or register to get started.