-
Monitor Windows Log Text Files and Use Wildcards To Search for String Matches
Could you offer the ability for us to monitor application log files on windows servers? It would be great to add this functionality to the basic version of Log Analyzer. (The version that's free with NPM). This would improve the monitoring capabilities of SAM to monitor more granular without having to use the custom…
-
SWQL Single Character Wildcard / String Parsing
Does SWQL have a single character wildcard? I've been working with the SDK for a while and find string parsing to be the greatest difficulty. I'm still trying to find a way to work around for the lack of IP Address sorting. SWQL functions for IP Addresses https://thwack.solarwinds.com/ideas/10592 I generally find I need…
-
SWQL and IP Addresses
Since Solarwinds is all about managing IP Addresses, there should be some functions that aid with exactly that. Short of functions like INET_ATON, INET_NTOA, IS_IPV4, IS_IPV6 & ... (MySQL :: MySQL 8.0 Reference Manual :: 12.23 Miscellaneous Functions ), it'd be great to have: 1. A c# style split function to parse out…
-
SWQL Pad
Enhance SWQL to include PAD for text manipulation PAD([LEADING|TRAILING|BOTH] ARG [WITH CHARACTER] [TO LENGTH]) Example: SELECT N.IPAddress AS IP , N.DnsBackward , PAD(LEADING ARRAYVALUEAT(SPLITSTRINGTOARRAY(REPLACE(IP,'.','|§|§|')),0) WITH '0' TO 3) AS O1 , PAD(LEADING…
-
SWQL Alias reuse
Enhance SWQL statements to allow reuse of aliases in the preceding SELECTION. Examples: SELECT A , A * B AS AB , B , B / A AS BA , AB + BA AS ABBA FROM TABLE; SELECT N.IPAddress AS IP , N.DnsBackward NAME , CHARINDEX('.',IP,1)-1 AS P1 , CHARINDEX('.',IP,P1)-1 AS P2 , CHARINDEX('.',IP,P2)-1 AS P3 , CHARINDEX('.',IP,P3)-1 AS…
-
SWQL CAST
SWQL needs a way to cast an argument of one datatype to another: CAST(ARG AS DATATYPE [USING FORMAT ''] ) examples: CAST(ARG AS INT) CAST("0.0" AS DOUBLE) CAST(ARG AS DATETIME USING FORMAT 'YYYY-MM-DD HH:mm:ss') CAST(0.0 AS INT) More string parsing is also needed:
-
SWQL SubString enhancement
Enhance SubString to use the following syntax: SUBSRTING(# OF FIELD BETWEEN 'character') examples: SUBSTRING( 1 OF ARG BETWEEN '.') -- dot separator SUBSTRING( 4 OF ARG BETWEEN ',') -- comma delimiter SUBSTRING( 2 OF ARG BETWEEN ' ') -- spaces More string parsing is needed in general:
-
SWQL functions for IP Addresses
Since Solarwinds is all about managing IP Addresses, there should be some functions that aid with exactly that like INET_ATON, INET_NTOA, IS_IPV4, IS_IPV6 & ... (MySQL :: MySQL 8.0 Reference Manual :: 12.23 Miscellaneous Functions ). Short of that, it'd be helpful to have: 1. A c# style split function to parse out octets,…
-
XML parser still working?
Hi, we have an XML parser custom written in C#. It connects to the Orion API, retrieves a string, parses it, and populates a SQL table with the results. It was my understanding that the API has switched over from XML to JSON. I am wondering why the parser still works perfectly and if there are any changes upcoming that…
-
Palo Alto and Fortigate Logs
Hello Everyone, I am using Palo alto and Fortigate virtual appliances and testing it with LEM. Observed that most of the event information goes in to Extraneous field in the LEM's normalized events. With Palo Alto, observed that LEM is not able to understand the Palo Alto Custom Syslog format and most of the logs appear as…