SW_United · SolarWinds Consultant · ✭✭✭✭✭

Great insight into SQWL. looking forward to reading more of this...

 This would be really helpful for endpoint devices, especially laptops and desktops.

Yep @"bluefunelemental" is correct, we've configured our F5 using Sticky session and also Source IP. This works well with IIS majority of the time. Only time I've seen slight issues are when your publishing the URL through Citrix Apps and multiple sessions during changes, have to keep flushing the browser cache. 

Good call. I think this would also be extremely useful for auditing purposes.

bump

This would make so much sense to the polling engine's performance. I imagine it isn't too difficult to achieve either.

Looking forward to seeing this information, especially about the documentation on least privileges and perhaps some pentesting advise. 

Surely if your using Groups with your Custom Properties, the Custom Properties are already available on the left hand side pane

Another update; I've found Threshold table;…

So it appears there is a I just need to figure out if I can just copy/paste some of these sections into one massive report and it display the data in multiple data blocks. I'll keep trying and update this post if I find anything

So lets say I've got these two reports that I've exported, but I want to combine these two within one report without having to re-create/update the report. Can I copy a selection of the XML code and then paste into another report and import this XML which contains both sections. Hope that explains it better.…

That's brilliant cheers @"stuartd" Could you also possibly help me filter on if this has been active for 30 minutes or more. I think it might be this; SELECT [data].CustomProperties.TestServers, [data].[DisplayName] AS [DisplayName],[data].[InstanceSiteID] AS [InstanceSiteID],[data].[PercentMemoryUsed] AS…

This has a hot topic for many other Thwack posts, I've found this post probably the closest, with thanks to @"bobmarley" [mention:4fcf6b1a560c4f60b49dc6a9af7ecc10:fb5d84b10a5745448a7a45dafc1faa43] Hope this helps

Can you give an idea of what sort of Parent-Child groupings your talking about. I can think of Site > Nodes, but anything else?

Nice dash, can this be found on the Content Exchange?

Sounds like they are looking for a Health Status dashboard for ServiceNow. That would be a nice to have, however I'd be more interested in a dashboard that relates Alerts and ServiceNow incident numbers etc... so NOC can see all active alerts and SNOW related ticket number.

Yep correct on only directly in the group. Duplicate Custom Properties that go across nodes, applications, volumes, interfaces, hypervisor etc.. that's an admin nightmare. Yeah, I'm currently adding loads dynamic queries to fill up my different groups, but they take so long to create. The Groups I can create via a script,…

Sorry for the delay on updating this; So this is the information that we received from Tech Support and it seemed to resolve the issue Recommendation: - Ensure the hostname is set to your-host-name.local (make sure it is set as same on AD DNS) - Generated new cert as per SEM - SEM - How to setup CA Signed Certificates…

Hi michael.kent Yes I'm a full admin. I'm in the process of a) Obtaining SQL permissions to cleanse the data through the SQL dB and b) Will raise a support ticket with SW

Argh OK thanks, I'll try that Component name now. As for the groups, I think I'll leave the CP to do the filtering. I'll need to find a way of doing an automated SQL task to keep checking if new nodes have been added to my groups and then add it to the CP field, if that makes sense.

OK, I've managed to update this a bit more, however I'm now looking for UrlLinks to drill down into the component issues that != 'Up'. This code shows my Down KPI for a particular application, however I've done it on the individual App ID's, I'd like it to filter on Custom Groups but I'm not able to get it working with…

I believe you need to have the squiggly brackets in the formatting on the table. {0.00%} If memory serves me correctly

Thanks for the replies, but I personally am restricted to only Web GUI, currently don't have any admin access beyond the GUI level. I will certainly request the SQL remove and/or raise a support call with SW. Cheers

So I created something similar to an administrator's guide to maintaining a clients environment. The key areas I focused on were; SolarWinds Orion Basics Introduction to SolarWinds Orion Platform Log in to the Orion Web Console Browser Requirements Pre-Requisites for logging into SolarWinds SolarWinds Website Login…

Cheers Zak

This sounds awesome, any chance of sharing this query for the Modern Dashboard?

Here is an update to what I think it should be however still not working yet, would really appreciate someone's help with this; SELECT [Nodes].Caption , '/Orion/images/StatusIcons/Small-' + [Nodes].StatusIcon AS [_IconFor_Caption] , [Nodes].NodesPercentMemoryUsedThreshold , [Nodes].DetailsUrl AS [_LinkFor_Caption] FROM…

The top one is SQL server and the others show additional servers

Thanks @"KMSigma.SWI". I like your script output layout so will use yours. Much appreciated 

OK I've managed to get a PowerShell script to work; $Servers = Get-Content "C:\SolarWinds\PowerShell\TEST-servers.txt" $listServices =…