#Serial communication protocol analyzer how to#
#Serial communication protocol analyzer 64 Bit#
#Serial communication protocol analyzer serial#
#Serial communication protocol analyzer 32 bit#
#Serial communication protocol analyzer software#

#Serial communication protocol analyzer 64 Bit#

, dnptime('') returns current time as 64 bit dnptime and dnptime(dnptime('')) returns current time as mm/dd/yyyy hh:mm:ss.msec. To get a date time formatted string instead of an integer simply call the function twice e.g.

#Serial communication protocol analyzer 32 bit#

Passing an empty string to dnptime(), wintime() or unixtime() returns the current time value as 64 bit (or 32 bit in case of unixtime()) integer.

Therefore you can also use a user supplied 64 (or 32) bit time value or DNP Time object as a parameter in dnptime() e.g.

dnptime(), wintime() and unixtime() are overloaded functions and they can accept a 64 bit integer (32 bit in case of unixtime()) value directly instead of string date time format.

), bits(x, starting bit offset, number of bits), dnptime('mm/dd/yyyy hh:mm:ss.msec'), wintime('mm/dd/yyyy hh:mm:ss.msec'), unixtime('mm/dd/yyyy hh:mm:ss')

Expression can be a combination of user supplied constant values, variables from protocol packets (SQL columns), operators such as =,>,=,!=,%,+,-,/,*,^,AND,OR,BETWEEN,NOT,IN, LIKE, IS NULL, IS NOT NULL,string concat, string length, string advanced pattern matching using regular expressions,abs(x), sin(x), cos(x), tan(x), asin(x), acos(x), atan(x), log(x), log10(x), ceil(x), floor(x), sinh(x), cosh(x), tanh(x), deg(x), rad(x), min(a,b,c.), max(a,b,c.), change(`col1`, `col2`.

SmartPA does that for you automatically using a pseudo memory table 'P' and pseudo memory variable columns based on the SCADA protocol.

Unlike SQL servers, you do not have to create any SQL table, or define any SQL columns.

SELECT `column1`, `column2`, expression1. SmartPA SQL supports the following SQL SELECT syntaxДЎ.

#Serial communication protocol analyzer how to#

If you know basic SQL Select statement, know what a MODBUS register is or what DNP analog and digital points are, then you already know how to use SmartPA SQL. SmartPA SQL uses a subset of standard SQL SELECT syntax and operators with some SmartPA SQL only functions (e.g., change(), dnptime(), wintime(), unixtime(), bits() etc.) designed for SCADA specific use. SmartPA SQL is our own implementation of SQL SELECT parser and it does not depend or use any SQL server. SmartPA SQL converts raw hex bytes from real time serial/network communication or saved communication logs (including PCAP files) into English and then converts it into a pseudo SQL fast memory table with pseudo rows and pseudo variable columns that you can query using SQL Select statement where the column names are SCADA protocol fields like MODBUS register 4001 or DNP point 30.2.0, 2.2.0.Time for timestamp or 2.2.0.Status for status flags. SmartPA SQL is the solution if you value your eye health and your time.

#Serial communication protocol analyzer serial#

There are many solutions that will allow you to capture serial and network SCADA traffic and even decode it, but none of them offer an easy way to find packets based on engineering values except by tedious visual inspection of packets. SmartPA SQL is an optional feature of Smart Protocol Analyzer that makes the process of finding, marking, printing and saving target packets, even among a million packets, extremely fast and extremely simple. Multiple users access even for a single terminal server data monitor portДЄllowing you to decode data interactively, type-in or copy-pasteДЇilters to hide/un hide unwanted protocol data Multiple protocol decoders on one port or multiple ports Transparently sniffing the network or COM ports without extra hardware or any disruptionД¬apture data from multiple ports simultaneously Some key features offered in our Smart Protocol Analyzer: Smart PA is rich in features and is easy to setup and use.

#Serial communication protocol analyzer software#

Once the software is installed, you are ready to capture your serial or ethernet data in real time. In addition, serial monitoring can also be performed by using special sniffer adapter/cables. The Analyzer's serial monitor, captures serial port traffic transparently, non-intrusively, without requiring any special setup. Our Analyzer also captures ethernet traffic directly from the LAN as well as dial-up PPP connections and supports socket based terminal server monitoring. It can decode industrial protocols like:ДЄnd any other SCADA industrial protocol which is transmitted over serial link (RS485, RS422, RS232), dial up modem, radio modem, TCP/IP, UDP/IP, PPP and CDPD. Smart Protocol Analyzer test set translates protocols into plain English.