Comments
-
Well, dhanson, I think I finally accomplished my goal here... I took your advice, the query example you provided, a bunch of time, and a ton of research... and I was able to come up with the following. --[SWNPMDB].[dbo].[CustomPollers]-- [UniqueName]-- entitySoftwareRev-- entitySoftwareRevExtWITH a AS(SELECT…
-
dhanson Thank you very much for the information provided. I have only spent a small amount of time working through your suggestion, so far, however, I have not had much success yet. At first, the query failed, as you stated it might. So, I made the recommended changes, and I was able to get the query to process, although,…
-
nafees.khan It appears to still be working for me. From the error message you are getting, I would say there would be something wrong with the way you have the query entered. Perhaps you can simplify the query, and see if it works any better? I would make sure the basic part of the query works first, just to make sure…
-
martian monster If your logs are there, for that Windows Server, you should be able to see them in the "Orion.APM.WindowsEvent" table with this SWQL query. SELECT EventCode ,TOLOCAL(TimeGeneratedUtc) AS TimeStamp ,ComputerName ,SourceName ,User ,Message FROM Orion.APM.WindowsEvent WHERE EventCode = 10028
-
martian monster Are you actually pulling, or sending, those events to Orion, or are you just having Orion check them and return and yes/no?
-
conguir That is very nice! You Prosperon guys are great! Thank you very much for sharing. -Will
-
smttysmth02gt If you want more details, then create your new post and tag me so I can find it. This way we don't mix topics here.
-
smttysmth02gt If it's just a simple list of device captions and serials (using Cisco devices as the example), you shouldn't need more than a few lines of SWQL. SELECT n.Caption ,n.NodeProperties.CiscoChassis.ChassisSerialNumberString FROM Orion.Nodes AS n (This option is via SWQL)…
-
amehlman Wow, so it sounds like you have already been through the ringer on this one. Unfortunately, I don't think I will be any help on this adventure, as I have nothing more to offer. I really wish my notes were better so I could tell you what we found when we had this issue. (Though, I believe we had it when we went to…
-
mrs.alterego No, it is not your opinion, it is a scientific fact!! But you are correct, either way, Leia definitely takes rank over the rest... Princess Toadstool/Peach and Zelda can fight it out for second and third place... (Disney or not...) Disney should just go ahead and bench all those other so called princess…
-
She actually uses my SolarWinds snuggie when she watches her Star Wars Rebels cartoon...
-
@"martin.lkab" You might need to refresh/clear cache. Also, if you have multiple web servers, you will need to make the changes, and clear cache, on all web servers.
-
k1gaudineer If you do not see any files in those inetpub sub-folders, check your config wizard settings/file (\Program Files (x86)\SolarWinds\Orion\ConfigurationWizard.exe.config). On/around line 24 you should see something about "PrecompiledWebsiteDisabled". The current/default value is set as "false". Change this: <add…
-
I agree. I only wish they would separate these hotfixes from the product upgrades. We should be able to FIX product "A" without being FORCED to upgrade (not fix) product "B". I really like their new installation method, however, fixing and upgrading should be two completely separate actions. I mean, upgrading should fix…
-
Oh man, talk about bad good news. They want you to work more and play less? Well that's no fun! Tell them you want your old job back so you can stay here and play more!!!
-
How dare you, Jfrazier! Bringing that dirty 4-letter word in to a family friendly environment. This is no place for the "w" word. Shame on you, sir.
-
@"james.heads" First rule of THWACK club... Always talk about THWACK club!! Wait, wrong thread... I use Notepad++, Visual Studio Code, and (of course) the Orion SDK. https://code.visualstudio.com/ https://github.com/solarwinds/OrionSDK Also, you should be able to test your code (minus the "live" data) in something…
-
johnny ringo Just signed myself up for a +1 there... I'm definitely with you on that one.
-
jokerfest No worries, happy to help. Glad it works for you. Thank you, -Will
-
I know I have it setup to take full backups nightly. As for upgrades, we were finally running fairly smooth, with no upgrades having happened, NTA turned off (service on main server, and storage service on NTA storage server), and our log size was around 2gb and steady for about a week or so. After re-enabling the NTA…
-
@"hebron1212" This is the join I have on one of my displays, showing how many times a node has been down in the past 24 hours/1 day. It joins on the Orion.Nodes table. I snagged it from someone's THWACK post a long time ago, but perhaps it could be used for your purpose. LEFT JOIN (SELECT n.Events.NetworkNode, COUNT(*) AS…
-
troyison Ah, I see, so you have your alert action set to execute the batch file, then automatically repeat every hour. I used to do something similar to make sure the alerts were working. (v11.x gave us some troubles and this helped fix it) So, your batch file works fine when executed manually, but fails when ran by the…
-
jhouser Hmmm... We ran into issues having a fairly large DB too, only having NPM, NCM, and NTA at the time, and found that NTA was really bogging us down. We went from around 170GB+ using all 3 modules, down to around 50GB after shutting down NTA. Our system has been running smoothly ever since. We are currently around…
-
The best use case I have is for our NOC and Engineering teams. We have several views that are extremely graph intensive, basically having 50-100 graphs per page, so we can get a very specific, and broad, overview of various device traffic patterns. Before SolarWinds, we used MRTG to view the graphs, allowing us to…
-
yeah, I actually didn't even notice that there... I reckon someone (had to be anyone in the world but me, of course) must have added it again to test and forgot to change it back... hehe..
-
npereira1 No worries, happy to help. Thank you, -Will
-
adatole I will catch up to you... someday...
-
cnorborg I just tested your query, however, the results show the total number of the different rules in violation. This is actually good info to have for the report as well. While I was in there, I started looking around, and I think I found where they keep that list of occurrences.…
-
cnorborg Thank you very much for the suggestion. I will test it out shortly. As for my goal(s)... Starting out in a single node environment, for the sake of the example... node = "DSLAM-01" DSLAM-01 provides service to a maximum of 48 customers, dsl interfaces 1-48. Each of those individual interfaces requires 2 different…
-
DanielleH I was wondering about those bobbleheads... I picked out my extra special picture, just for that bobblehead. I hope it works out.
