mburgeso

Here you go: Online regex tester and debugger: PHP, PCRE, Python, Golang and JavaScript

Not just for Report Writer or Web Reports, but also for any dashboard, view, or screen. This is pretty standard in other tools, such as Splunk, AppDynamics, or OpsView. By adding customized user selection criteria prior to the selection of the data, it would potentially eliminate/reduce the number of reports/screens…

This works for me within Report Writer. Good luck.

A large pot of Cowboy coffee with Bacon&Eggs to start the day, work for a bit, hit the gym, then enjoy a couple homemade Chocolate Stouts. 

As far as the purpose of the JOIN, they are typically used in a select statement to form the bond between tables that share keys. If some of the your required attribute data is in another table and the tables are linked via keys then you need to create that selection criteria with the JOIN statement to get to those…

Or is it? Hebrew Date Converter - 7th of Adar II, 5779 | Hebcal Jewish Calendar

If you'd rather have a SQL query instead of SWQL, then here is a simple SQL for pulling out the Current Muted Nodes/Entities. First this SQL grabs the NodeID (via a regex) from the AlertSuppress2 table then loads the NodeID, along with the From/To DataTime fields into a temp table. Then joins the small temp table (via the…

Upgrading to the hardware, OS, and Solarwinds (Orion2019.2HF3) after quite a lot of slowness issues. These steps seem to have improved the performance greatly, probably in DB calls improvements. Regardless of which one had the most impact, this combination has a much improved the Solarwinds UI and poller response times.…

And another SQL showing the comparison of To/From Times. Note: in this example, the 'fromtime' and 'totime' are derived from the WebReport layout (i.e. Past 2 hours). SELECT aa.[timestamp] AS TriggeredDateTime , aa.message,ac.severity, (CASE aa.eventtype WHEN 0 then 'Triggered' WHEN 1 THEN 'Reset' WHEN 2 THEN…

The following shows the use of the GetDate and comparison of dates but can easily be changed to compare Date/Times. DECLARE @StartDate DateTime DECLARE @EndDate DateTime declare @Results TABLE (SysName varchar(255),InterfaceAlias varchar(255),CountOfEventType int) SET @StartDate = CAST((ROUND(CAST(GetDate() - 365 AS…

Yang, We had the same issue after any upgrade to from SAM 6.7 to SAM 6.9.1 where the JMX Connection was failing in Solarwinds. As you can probably guess, having JMX functionality down is a MAJOR impact to APM monitoring since it is the eyes into the Java processes and when the MBean attributes are not obtained then the…

Throughout my 15+ years of java experience, I have used the following methods of monitoring the JVM: 1) Log-based Scrapping the GC logs for GC information and displaying the data in a logging tool, such as Splunk. Probably not the most effecient use of Splunk but it worked for a stand alone app at an Ivy League university.…

I spilt this setup into two pieces, mainly because each piece has a different owner: Server-Side setup and Solarwinds setup. Server-Side JMX setup 1) Enable the JVM attributes for JMX and also setup a Username/Password for remote authentication. Configure the JMX attributes in the JVM settings:…

PI Day does not exist in Europe (DD-MM-YYY). Unless, of course, you are using a Julian Date (314 = November 10th). And every 4th year the Julian PI Date will fall on November 9th. Nothing happening for us on the American PI Day, but the day after on 3-15-2019 we are celebrating St Patty's Day at work; which I will be…

use regex, such as: <span class="str" style="font-style:inherit;font-weight:inherit;font-family:inherit;color:#7d2727;">([a-zA-Z0-9._-]+@[a-zA-Z0-9._-]+\.[a-zA-Z0-9_-]+)</span>