How to add PING monitors without IPNetwork client?

How to add monitor without using the IPNetwork interface? Q:Is there a way of adding ping monitors without using IPNetwork client? E.g., using some kind of script? A: Yes. You can do something like the following (save SQL script below as create.sql): 
CONNECT '127.0.0.1/3055:C:\ProgramData\IPNetwork Monitor\data\nms.fdb' user 'SYSDBA' password 'masterkey';

SET HEADING;

set term ^ ;

EXECUTE BLOCK RETURNS (newMonitorID INTEGER)
AS
   DECLARE VARIABLE newHostID INTEGER;
--   DECLARE VARIABLE newMonitorID INTEGER;
   DECLARE VARIABLE currentTime TIMESTAMP;

BEGIN

-- Get the current data/time
SELECT 'NOW' FROM RDB$DATABASE INTO :currentTime;

-- Generate ID for new host
SELECT NEXT VALUE FOR HOSTS_ID_G0 FROM RDB$DATABASE     INTO :newHostID;

-- Generate ID for new monitor
SELECT NEXT VALUE FOR MONITORS_ID_G0 FROM RDB$DATABASE  INTO :newMonitorID;

-- Add new host

INSERT INTO HOSTS
(
    ID, 
    HOST_TYPE_ID,	-- reference to the HOST_TYPES table (groups of hosts)
    DISPLAY_NAME,
    NOTES,
    HOSTNAME,
    IP,
    A_PROFILE_KIND,
    A_PROFILE_GLOBAL_ID,
    CREATED,
    WEBINTERFACE_URL
)
VALUES
(
    :newHostID,
    0,			-- put new host to the "Servers" group
    'Google',
    'Created by script, ' || :currentTime,
    'google.com',
    '74.125.39.104',
    0,			-- use one of the global Alerting rules
    1,			-- 'Default Alerting Rule' in particular
    :currentTime,
    'http://google.com:80'
);

-- Add new PING monitor for the added host

INSERT INTO MONITORS
(
    ID,
    HOST_ID,
    MONITOR_TYPE_ID,	-- reference to the MONITOR_TYPES table
    DISPLAY_NAME,
    NOTES,
    INTERVAL,
    ACTIVITY,
    STATE,
    STATE_ACK,
    T_INHERITED,
    P_INHERITED,
    A_PROFILE_KIND, A_PROFILE_GLOBAL_ID,
    CREATED,
    RES_LOG_START
)
VALUES
(
    :newMonitorID,
    :newHostID,
    1,			-- this monitor is a PING monitor
    'PING google web site',
    'Created by script, ' || :currentTime,
    30,			-- polling interval 30 seconds
    0,			-- create started
    -1,			-- create in UNKNOWN state
    'n',
    'y',		-- inherit the 'Availability Monitoring' settings
    'y',		-- inherit the 'Performance Monitoring' settings
    2,			-- inherit alerting rule from monitor type
    1,			-- the 'Default Alerting Rule' is used in particular
    :currentTime,
    :currentTime
);

-- Add properties of the monitor created.
-- PING monitor has only one property: 'Packet Size, bytes'

INSERT INTO M_SETTINGS_FOR_MONITORS
(
    M_SETTING_TYPE_ID,
    MONITOR_ID,
    V_INT,
    V_STRING,
    V_BIGSTR
)
VALUES
(
    1,			-- id of the 'Packet Size, bytes' property
    :newMonitorID,
    32,			-- use the 32 bytes packets
    NULL,		-- is not used obsolete
    NULL		-- is not used since this property is integer, use this field for
			-- string properties
);


RDB$SET_CONTEXT('USER_SESSION', 'monitorID', :newMonitorID);
RDB$SET_CONTEXT('USER_SESSION', 'hostID', :newHostID);

END
^

set term ; ^

SELECT RDB$GET_CONTEXT('USER_SESSION', 'monitorID') FROM RDB$DATABASE;
SELECT RDB$GET_CONTEXT('USER_SESSION', 'hostID') FROM RDB$DATABASE;
and run this script: 
"C:\Program Files\IPNetwork Monitor\firebird\bin\isql.exe" -q -i create.sql
(replace path to IPNetwork Monitor installation folder if necessary) The script writes directly into the IPNetwork’s database and creates a new host for the google.com and adds a PING monitor. You need to restart both the IPNetwork service and client to let them detect the new monitor/host.
Related topics
How can I access or modify monitoring data?

Share: