Page History

General information

This action starts an external program on the selected Server 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 must allow the NGP RaFT supervisor service to interact with desktop.

5. Add to folder <Axxon One installation directory>\UserScripts\ one or more .bat files with the application startup command.

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

    Note
    title Attention!
    If

the

22. you expect a wildcard

is expected

23. 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 (

“”

24. ""). For example,

“

25. "{rectangles}

”

26. ". 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 apply the following use a bat file with contents:

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 : Exporting events about camera status change changes (offlinesignal lost/online) to a csv.bat file containing the followingrestored) in csv format, a bat file with contents:

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 events from all inputs 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

...