I've been looking at the db structure. According to the Accounts table, there are 2 columns related to the password : "password" and "password-hash" Question : Is the password purely managed by SQL ? if so, how can it be updated ? Otherwise, does the SWIS API can manage account passwords ? I've been looking for a way for users to update…(Show moreShow less)
Hi. I'm using Swis through PowerShell to copy data from a different, disconnected monitoring system into SolarWinds. I'm able to update Nodes with all the information we care about, but we need to add to the ResponseTime table so we monitor through charting, etc. The other system provides a time-stamped history of various modem parameters,…(Show moreShow less)
This is not something that is supported by the API at this time. If you wanted to hack it in, you could probably come up with a table insert statement that would work. That method may break in a future version - those table schemas may change in the future.
Hi Guys. I have written a simple bash script for reserving/claiming ipnodes. I would like to ask how to limit (and/or offset) SWQL swiss query to exclude like first 10 IP's (ipnodes) and start with f.e. 192.168.0.10? There's a "SkipScan" property which i'm checking to skip broadcast and subnet, should i use this to mark the nodes i would like to…(Show moreShow less)
Does anyone know how I can use an API call to an external, 3rd party, web site to update the status of nodes? This is the API I want to use: https://portal.<Not a SolarWinds server>.net/api/modems?api_key=<key>. The API is polling another vendor that is exposing the status of some devices for us. I cannot directly poll the end devices, I can…(Show moreShow less)
Orion SDK 2.4 has been released. This release contains a set of nice SWQL Studio UI upgrades: Fancy tabs with Visual Studio-like behavior courtesy of DockPanelSuite The query parameter window has been converted into a docking panel that automatically tracks the names of the query parameters used by the current query Adds a toolbar Combobox on…(Show moreShow less)
Hi all, im trying to get the top 500 syslogs per some spefic nodes (not 500 total, 500 per node) and have been advised the below query should work with MSSQL, however SWQL is slightly different, currently the query fails with the error: requests.exceptions.HTTPError: 400 Client Error: no viable alternative at input 'OVER' in Select clause for…(Show moreShow less)
No, SWQL does not support the ROW_NUMBER() feature from SQL. Off hand I can't think of a reasonable way to match these results using only SWQL features. If the number of nodes to fetch logs for is not large, you could get by with running a separate "TOP 500" query for each one.
Hi Everyone, We have a vm template that has the agent installed on the system already. Once a system is provisioned, our C.M. activates the agent and it shows up in Orion but with no resources listed. I am trying to figure out how to perform the same functions as list resources would, from research I am guessing I would have to do a…(Show moreShow less)