stuartd · Senior Dogsbody · ✭✭✭✭✭

I shall attempt this :)

As ever Will @"wluther" my thanks for the replies. And, more reading for me In answer to the why I want/need o use the DB Manager instead of other option, it is simply because this is a secure, air-gapped environment that requires multiple hoops to be jumped whilst doing a back-flip and landing on one finger before they…

I hate leaving questions unanswered, and as I have had no responses I have wasted a fair bit of time finding one. To save someone else the grief of this then here is my completed query code. I forget what report I took this from now, but I adapted it to suit my need which was to have a report show me when a device was last…

@wluther many thanks Will and as Bill & Ted were fond of saying: "Excellent". I guess you did go a bit of topic (for my query) but what you've written is all good stuff and helps me a lot. I will spend some time going through those old posts and try to really get my head wrapped around this thing. And, DUH (me that is), of…

Good to get on the same page (pun appreciated) and understand where you are at... So, in reverse.. I'd never used the views manager before so visually would skip over it, but now I know it is there and found and deleted the one view I created. Having now found that page, it tells me we have 200 views. I've left the views…

I thought I understood your reply, but in all honesty I'm probably just being dull as I don't. All I've done is added the custom query widget and pasted in the code your provided. The result looks like this: The screenshot just shows the first 3 of 199 returned, and of these 3, only the first returns anything. As I say,…

@"wluther" Thanks for this - as we are delving more and more into SolarWInds we are finding shortcomings that folks like yourself are resolving. And I can assure, if your SWQL skills are at the bottom of the pool then mine are somewhere in the rear-view mirror of that pool So, I have copied/pasted and all works as…

@"wluther" So, found some time and needed to do bit of tweaking. The SQL you've pasted is a bit beyond me but I sort of understand what it is doing, just not necessarily the how. At first I was getting errors being thrown up as it couldn't find: NodeProperties.Nodes.CustomProperties.Area - managed to locate and edit that…

Thank you @"wluther" I shall look at this tomorrow but it looks like it will be what I'm after.

WOW - down for 50 days. We'd get strung up for an hour or so for scheduled maintenance

@"sum_giais" @"jblankjblank" this here is one big reason we still haven't even begun to use Orion maps. If links on maps auto disappear then that is simply not acceptable to us. Our maps are also our physical documentation for that network, and as such it needs to be accurate, including any faults. We still very much…

Not to my knowledge, as our remit has never been about monitoring/supporting servers or applications - though we do have a few on monitoring (mostly the SolarWinds boxes).

OK - so I've built the alert now but left it that it only eMails me. If/when I get an eMail that should also correlate with the dual alert functionality I've already deployed. Once I know it's working then we can reduce to just the new alert. And would certainly ease ongoing support for when new Fortigates come onboard -…

Again the reply is appreciated... The problem we have is that a lot of our Forti's are virtual and I don't know if that causes an issue, but whomever set them up decided not to set up individual management and a cluster IP so the name change option won't work in these instances. As I mentioned to @"Seashore" I'm going to…

@"Seashore" now that looks intriguing, and longer term is a **bleep** site easier to manage then having my current workaround. I can see how that SWQL works, just I know I never would have been able to create it. I will give it a try sometime and report back. Diolch yn fawr.

OK thank you again - I will raise a case I think.

And found it ... I've changed the UnDP to a get next as pointed out by @"dpad" above but somehow I overlooked that. Now I have 103 items in scope that would be triggered - now whilst that number seems high (it is) at least I'm moving forward.

Fab - where I can I will always help and happy to have been able to do so here.

And to prove I've followed this through then I followed the: IsPollingDisabled' table. This is taken from dbo.APM_HardwareInfo which is itself yet another view, but something I spotted is that the IsPollingDisabled doesn't actually exist as a heading, and is instead a rename of the IsDisabled entry(table/record ??) -…

In our usage no, there is minimal resource usage. But I don't know your setup so YMMV and it may be that any other app running on that server hogs resources and so adding the SDK there tips it over the edge. But you don't blame the SDK for that. I also believe you can run it remotely anyway.

>> what is the difference between lightweight and standard installation. which one is recommended. I believe @"ChrystalT" has already answered that bit when she said: There are a lot of unknowns to your question - namely how large your installation is or is likely to get, what modules you are installing aside from the…

Thank you - I did not know that.

Thanks @"Seashore" I knew that was there but hadn't made that leap in logic to copy and paste that to SWQL Studio. The code becomes: SELECT E0.[Uri], E0.[DisplayName] FROM Orion.NPM.CustomPollerAssignmentOnNode AS E0 WHERE ( ( E0.[CustomPoller].[UniqueName] = 'fgVdEntHaState' ) AND (…

@"dpad" your screenshots didn't come through - it tells me they aren't available. You can copy & paste them direct into the reply if that helps. That said, if I understand you correctly, you said this is working for you. Have you been able to test a failover??

Glad my vague pointers helped in getting you where you needed to be. Nice work.

Sorry, I meant to say, the line with the firewall name and config file name can added in a rinse and repeat fashion as many times as you need to do so.

@"dunky2k" yes we do and that little bit of info is absolute gold. Thank you.

@"Seashore" it most certainly does help some but also adds some confusion I had high hopes of the pandemic being over sooner than it is, and then I could get my Comp Sci child to visit and he could do me a face to face "walk through" of SQL and get me started. But with him being a crtitical national infrastructure (CNI)…

@"bobmarley" thanks for that but I feel I need a step back from that and need to understand what I'm looking at better first. As to providing examples, then I'm all up for that when I have something concrete to ask for, but sadly that has not been my experience to date.

I truly appreciate that Marc and actually that code I am able to follow it through**. One option I can see is rather than having a "live map" is that we export all their current maps and use your code to associate the group and map name together. So when a 'relevant' piece of kit is looked at it 'associates' the map to it.…