Page History

This action starts an external program on your the selected Server of the Axxon-domain.

To configure, do the following:

1. Allow interaction of the server NGP Host service with the desktop: Start → Control Panel → Administrative Tools → Services → Net Logon → Properties → Log On.
   

   Info
   title Note
   For the Failover server and client installation type (see Installation), you have to must allow the NGP RaFT supervisor service to interact with desktop.

   
   

2. Add to folder <Directory where <Axxon One is installed> installation directory>\UserScripts\ one or more .bat files with the application startup command.
   The command should must include a path to the executable file. You can specify a network path and , command - line options parameters (see Starting an Run external program on Clientsapplication on client) and use templates (see Text templates in the action settings).
3. Select the server Server where you want to run the program (1).
   
4. Select a .bat file with the run command (2).
5. Enter templates, if they were set via a .bat file (3).
   

   Note
   title Attention!
   If the wildcard is expected to contain spaces and/or some special shell characters (> & | <, and so on) as a result of the query, the template must be enclosed in quotation marks (“”). For example, “{rectangles}”. It is necessary to quote the entire template string.

Example 1: If you apply the following bat file:

...

executing the macro will lead to the following message:

Example 2: Exporting events about camera connection status events change (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 from all inputs to a csv.bat file containing the following: 

...