Comments
-
Thanks! That was the trick. This is what I now can display in the Custom Query chart: And, I just have to sort by Datetime field. (For some reason, when using the TOP XX statement in the query, it works in SWQL Studio, but, not in the web interface. No big deal.) This was the winning query for us: SELECT…
-
What is your path to this exe? Here are my possible choices:
-
Also, I'm getting weird results if I try and narrow it to the TOP XX: Query, without TOP XX: SELECT f.Router.Nodes.Caption, f.RouteDestination, f.CIDR, f.DateTime, f.Ip_Address_Type, f.Ip_Version, f.RouteNextHop FROM Orion.Routing.RoutingTableFlap f ORDER BY f.DateTime DESC Result (notice the NO-DL1-VSS router is most…
-
Ah, my apologies. I missed the trailing "f" That does work, as does the ORDER BY statement. As for the SWQL version, the executable is dated 2/15/2011. I can't find any others.
-
I'm not sure what the "f." represents, but, I can't get any query with "Router.Nodes.Caption" to work. I've tried several different forms of syntax. Also, another thing that's frustrating, shouldn't I be able to go to the SWQL Studio program and get the same results as the web page? They don't seem to be correlated. Am I…
-
Hey! That looks promising! I got results... Now, 2 questions: 1) How can I get a human-readable node name in this chart? 2) How is this data sorted?
-
So, I just was poking around and found the SWQL studio, ran the following query, and got results... Ultimately what I'd like to see is the same thing as the individual node results... Except a network wide query that can be seen from the Custom Query window on the web view of our choice. I appreciate all the help on this…
-
This was indeed helpful. Recently, we had a job that said it was finished, but, we never received the email. After turning on and checking the log files here: C:\Program Files (x86)\SolarWinds\Orion\NCM\Logging\, I was able to determine that it was failing to send an HTML file. Once I located the html file (and associated…
-
No worries. Nobody bats 100%. I appreciate your time.
-
NPM 10.6
-
I must be doing something wrong here.....
-
Thank you for the schema documentation. Interestingly, if I bring up the schema and search for "route" nothing shows up. I'm using Windows auth. to connect to the database, I believe. If I look at the SQL Server service, it's running as Local System.
-
If I use that query i get this: "Error: A query to the SolarWinds Information Service failed." Also, where are you finding these tables names: LastDiscovery, NextHop, etc.?
-
Just did this on Windows 10 server. Thought somebody might like this. Follow these steps: 1) Create a shortcut to this URL and leave it on the desktop for now: https://servername/orion/summaryview.aspx?ViewID=97&isnocview=true&accountid=username&password=password 2) Type "shell:startup" in the Run menu. A folder should…