Page History

General information

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

Configuring an action

To configure this action, do the following:

1. Allow interaction of the server NGP Host service with

the

2. desktop: Start → Control Panel → Administrative Tools → Services →

Net Logon

3. Netlogon → Properties → Log On.
   Image Modified

   Info
   title Note
   For the Failover server and client installation type (

see

4. see Installation), you

have to

5. must allow the NGP RaFT supervisor service to interact with desktop.

6. Add to folder
<Directory where
7. <Axxon One
is installed>
8. installation directory>\UserScripts\ one or more .bat files with the application startup command.

The
9.  The command
should
10. must include a path to the executable file of the program. You can specify a network path
and
11. , command
-
12. line
options (see Starting an external program on Clients).Select the
13. parameters (see Run external application on client) and use templates (see Text templates in the action settings).
14. Go to the Programming tab.
15. In the Event rules or Cycle rules list, click Create... (see Configuring macros).
16. Select a start condition that triggers a macro (see Configuring start conditions).
17. Click the Image Added button below start conditions.
18. From the drop-down list, select General: Run external application on server.
19. In the Launch external program on server parameter, select the server where you want to run the program
(1)
20. .
    
Image RemovedSelect
21. Image Added
    
22. In the Executable files parameter, select a .bat file with the run command
(2)
23. .
Enter
24. In the Launch parameters parameter, enter templates, if they were set
via
25. in a .bat file
(3).
26. .
    

    Note
    title Attention!
    If you expect a wildcard 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.

27. Click the Apply Image Added button.
    

Configuration of the Run external application on server action is complete.

Example use

Example 1

If you use a bat file with contentsExample 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 results in the following message:

Image RemovedImage Added

Example 2

Export events about camera status changes (signal lost/restored) in csv format, a bat file with contents: 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

Export of all input events in csv format, a bat file with contents:: 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

...