Starting an external program on Servers

This starts an external program on your 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.
   

   Note

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

2. Add to folder <Directory where C-Werk 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).
3. Select the 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).

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