Starting an external program on Servers

This starts an external program on your Axxon-domain.

Attention!

Any software containing a GUI is not recommended to be executed on the Server. If you encounter a problem launching interactive services, please refer to the Windows OS user manual.

To configure, do the following:

Allow interaction of the server NGP Host service with the desktop: Start → Control Panel → Administrative Tools → Services → Net Logon → Properties → Log on.
Note
For Failover Server and Client installation type (see Installation), you have to allow the NGP RaFT supervisor service to interact with desktop.
Add to folder <Directory where Axxon One is installed>\UserScripts\ one or more bat files with the application startup command.
The command should include a path to the executable file. You can specify a network path and command-line options (see Starting an external program on Clients).
Select the server where you want to run the program (1).
Select a bat. file with the run command (2).
Enter templates, if they were set via a bat file (3).
Attention!
If it is expected that the query result contains spaces and/or some special shell characters (> & | < etc.), then the template should be enclosed in quotation marks (""). For example, "{rectangles}". The entire template string should be enclosed in quotation marks.

Example 1: If you apply the following bat file:

SET "datatime=%1"
SET "cameraIpAddress=%2"
 
msg * Current time is %datatime%, IP-address: %cameraIpAddress%

executing the macro will lead to the following message:

Example 2: Exporting camera connection status events (offline/online) to a csv.bat file containing the following:

SELECT "timestamp"
    ,REGEXP_REPLACE("object_id", 'hosts/', '') as device,
    CASE
                                WHEN ("any_values"::json->>'state') = '4' THEN 'Signal Lost'
                                WHEN ("any_values"::json->>'state') = '3' THEN 'Signal Restored'
                                ELSE ''
        END as state
FROM public."t_json_event"
WHERE type = '0' AND ("any_values"::json->>'state'='3' OR "any_values"::json->>'state'='4') AND timestamp >= '20200211T0000'
ORDER by timestamp DESC

Example 3: Exporting detection tools triggering events to a csv.bat file containing the following:

SELECT "timestamp",
        REGEXP_REPLACE("object_id", 'hosts/', '') as device,
        CASE
                                WHEN ("any_values"::json->>'phase') = '1' THEN 'Closed'
                                WHEN ("any_values"::json->>'phase') = '2' THEN 'Opened'
                                ELSE ''
        END as state
FROM public."t_json_event"
WHERE type = '1' AND timestamp >= '20200209T110000' AND "object_id" LIKE '%ray%'
ORDER by timestamp DESC

Page tree

Documentation for Axxon One 1.0.