Comments
-
Here are a few links to other custom/modified resources, as well as some other, very useful, work done from other members of the community. Custom Node & Polling, Combined Details Resource Custom User Links, Modified User Links Resource Custom Query Resources, Increased Default Workspace SWQL Custom Views Manager Gob…
-
CourtesyIT I think this should remove the SAM part of it for you... However, I am not in a position to test anything at the moment. And, as always, there is a super high possibility I am just flat out wrong. Remove the following lines. (Sorry, I am unable to attach the edited file, and when I posted the entire script, it…
-
CourtesyIT Have you adjusted each of the alert thresholds to qualify a majority to test with? ie. (a.Status=1 AND a.CPULoad > 95) -- Node is up but CPU load is high lower the 95 to 0, and see if it shows everything. (a.Status=1 AND a.CPULoad > 95) -- Node is up but CPU load is high Also, you're probably not going to need…
-
Somebody give this guy a raise!!
-
sotherls It's actually the exact same code. The only differences are just taking the entire div line at the bottom, and moving it to another custom HTML widget. This is what one of my custom HTML widgets on the left contains. (Just make sure it's removed from the main HTML widget too.)
-
dunky2k I'm glad you got everything working in your query. I am running SWQL Studio version 2.5.0.214, as well as the following Orion product versions: Orion Platform 2018.4 HF3, SCM 1.1.0, NCM 7.9, NPM 12.4, DPAIM 11.1.1, VMAN 8.4.0, SAM 6.8.0, NetPath 1.1.4 I am connecting via the v3 option. The chain icons have been…
-
dunky2k As far as SWQL goes, you can actually use native/implied joins for the majority of commonly linked data/tables. For example, using looking between the Orion.Nodes table and Orion.Events table, you can navigate either way without creating a join. Starting with the Orion.Events table: You can see the little…
-
dunky2k, As it is currently, the provided examples are actually pulling the data via SWQL, not SQL. While SWQL ultimately pulls the same data from the same place, it is done differently. If you have not already done so, I would definitely take a look at the Orion SDK, GitHub - solarwinds/OrionSDK: SDK for the SolarWinds…
-
timt Sorry you had to wait so long for a response, I must have missed it. jfaldmo appears to have provided a working answer for you. (Thank you, sir.) I have updated the main file with a 3rd option/version, which will add the recent events table below the pie charts. Thank you, -Will
-
Just wanted to add a screenshot of our updated events calendar page. It's basically the same as before, only now it's broken out into different widgets. Everything still works the same way too, just click a day on the calendar, and the other widgets populate with the corresponding data dynamically... I like this layout…
-
132098 You will need to apply the exclusions in each of the SWQL query sections within the code. This is for the main/calendar section. This is the section for the first pie chart. Adding your exclusions to each pie chart after should be done the same way. (Likely on/around lines 106, 149, & 194) Just make sure to keep it…
-
SCHWEET!!! I have been waiting for this functionality for a long time now... This is simply great. Outstanding Job, sir!
-
132098 Sure, to filter out results, you will need to add/modify the "WHERE" part of the query. WHERE Vendor != 'Cisco' Or you could keep all Cisco devices except anything with "Cisco IE-" in the MachineType name: WHERE MachineType NOT LIKE 'Cisco IE-%' In regards to moving/resizing the pie charts, you will need to adjust…
-
I like the combination of those two styles. It looks like that would be really helpful. I will be adding your version to a couple of our pages, as I think it might work better than what we have. Great job, jhaas! Thank you, -Will
-
jhaas That sounds very interesting. I'd love to see it when you're finished. Please keep us posted on how it goes, and feel free to share your adventures getting it there. I'm sure THWACK Nation would also love to see where you take this, and how you use it. Thank you, -Will
-
jhaas Unfortunately, as far as I know, this particular chart will only show a full year or more. I don't currently have the time available to research it, but there are endless other options out there, just waiting for someone to tinker with them and implement. I know we saw other options when we were working on this…
-
neokevin I believe the default/included query is simply selecting the records from the "Orion.AlertHistory" table. You can change it to point to whatever results you want. We just figured we would leave it on alerts as that would give us some solid data to work with. You could also have it include everything, then break…
-
21122012 Glad you got it working.
-
21122012 Perhaps just adjust the "WHERE" part to specifically show results from the current year? *Should be near top, on/around line 9.* CHANGE THIS: WHERE TOLOCAL(TimeStamp) > GETDATE()-177 TO THIS: WHERE (YEAR(TimeStamp)) = YEAR(GETUTCDATE()) Try that, and let us know how it works for you, please. Thank you, -Will
-
Great job nickzourdos! It's always great to find new/better ways accomplish tasks. Way better than waiting around.
-
marcv Well, the part about showing 2 calendars is actually the default behavior for this type of chart. It will populate the entire year if you have even 1 data point within that year. So, it seems you have some data from the end of last year which is why that 2018 calendar is showing. Now, in regards to the only showing…
-
dunky2k Well, unfortunately Google does NOT provide an option to host the files locally, as I just learned it is against their ToS. That being said, if we were in a world where they didn't provide a download option, but it wasn't against their ToS, it would look like the only way to get all those files would be a bunch of…
-
antonis.athanasiou Also, don't forget to tag CourtesyIT when you are posting new ways to customize the Orion environments so he can add it to "The List"... How to do various customizations with your Solarwinds That list is a great place for the Thwack community to reference when looking to improve their site(s).
-
dunky2k Ah, yes, good catch. I didn't even think of it until you mentioned the DNS error. The script, as it stands, needs to connect to the base .js file, which is hosted by Google. To get around this, you can download the file from the first line or two of the code, and place it on your server. Then just redirect the…
-
Super cool stuff, antonis.athanasiou! Now we need to add some progress bars and time converter thingies too. Anything in the works to add more default options like this one, tdanner?
-
dunky2k Which version of the script are you running? Also, which browser are you using, and does that browser have any plugins/extensions installed? When the page loads, do you see any errors in the browser console log? (Chrome = F12/inspect page, then click on console to look at errors) If you are using the version with…
-
rschroeder I'm glad to hear you got it up and working with ease. While I'd love to take credit for this, my coworker, mblackburn, actually did all the heavy lifting. For the most part, the only thing I did was post it on Thwack. mblackburn is really the person deserving all the praise.
-
xtraspecialj I think that is a preset Google thing. I did not find any options for this, as I was definitely looking. I'm sure there is a way to do it, just sitting there out on the interwebs of life, waiting to be utilized. I don't really care to have the entire year up there either, but I have not yet found a way to do…
-
gundamunit1 Ah, I see... You can just add the following to the end of the query. ORDER BY VM.Name That should always order the list by name.
-
bavautom5 Yes, we did something similar with our event logs. We use the calendar to pick the day, which populates the pie charts, showing us a break down of where/how things were happening that day. Additionally, it also populates a paged list of the event logs in a simple table format. This, for whatever reason, loads…
