navprofiles.sql

Network Administration Visualized 网络管理可视化源码

	string:  0
	integer: 1
	ip adr:  2
*/

INSERT INTO MatchField (matchfieldid, datatype, name, valueid, valuename, valuecategory, valuesort, showlist, descr) VALUES 
(10, 0, 'Event type', 'eventtype.eventtypeid', 'eventtype.eventtypedesc|[ID]: [NAME]', null, 'eventtype.eventtypeid', true, 
'Event type: An event type describes a category of alarms. (Please note that alarm type is a more refined attribute. There are a set of alarm types within an event type.)');
INSERT INTO Operator (operatorid, matchfieldid) VALUES (0, 10);
INSERT INTO Operator (operatorid, matchfieldid) VALUES (11, 10);

INSERT INTO MatchField (matchfieldid, datatype, name, valueid, valuename, valuecategory, valuesort, showlist, descr) VALUES 
(11, 0, 'Alert type', 'alerttype.alerttype', 'alerttype.alerttypedesc|[ID]: [NAME]', 'alerttype.eventtypeid', 'alerttype.alerttypeid', true, 
'Alert type: An alert type describes the various values an event type may take.');
INSERT INTO Operator (operatorid, matchfieldid) VALUES (0, 11);
INSERT INTO Operator (operatorid, matchfieldid) VALUES (11, 11);


INSERT INTO MatchField (matchfieldid, datatype, name, valueid, valuename, valuecategory, valuesort, showlist, descr,valuehelp) VALUES 
(12, 1, 'Severity', 'alertq.severity', null, null, null, false, 
'Severity: Limit your alarms based on severity.',
'Range: Severities are in the range 0-100, where 100 is most severe.');
INSERT INTO Operator (operatorid, matchfieldid) VALUES (0, 12);
INSERT INTO Operator (operatorid, matchfieldid) VALUES (1, 12);
INSERT INTO Operator (operatorid, matchfieldid) VALUES (2, 12);
INSERT INTO Operator (operatorid, matchfieldid) VALUES (3, 12);
INSERT INTO Operator (operatorid, matchfieldid) VALUES (4, 12);
INSERT INTO Operator (operatorid, matchfieldid) VALUES (5, 12);


INSERT INTO MatchField (matchfieldid, datatype, name, valueid, valuename, valuecategory, valuesort, showlist, descr) VALUES 
(13, 0, 'Category', 'cat.catid', 'cat.descr|[ID]: [NAME]', null, 'cat.catid', true, 
'Category: All equipment is categorized in 7 main categories.');
INSERT INTO Operator (operatorid, matchfieldid) VALUES (0, 13);
INSERT INTO Operator (operatorid, matchfieldid) VALUES (11, 13);

INSERT INTO MatchField (matchfieldid, datatype, name, valueid, valuename, valuecategory, valuesort, showlist, descr) VALUES 
(14, 0, 'Sub category', 'subcat.subcatid', 'subcat.descr|[ID]: [NAME]', 'subcat.catid', 'subcat.descr', true, 
'Sub category: Within a catogory user-defined subcategories may exist.');
INSERT INTO Operator (operatorid, matchfieldid) VALUES (0, 14);
INSERT INTO Operator (operatorid, matchfieldid) VALUES (11, 14);

INSERT INTO MatchField (matchfieldid, datatype, name, valueid, valuename, valuecategory, valuesort, showlist, descr, valuehelp) VALUES 
(15, 0, 'Sysname', 'netbox.netboxid', null, null, null, false, 
'Sysname: Limit your alarms based on sysname.',
'Sysname examples:<blockquote>
<b>Starts with:</b> samson.<br>
<b>Ends with:</b> .stud.ntnu.no<br>
<b>Contains:</b> .studby.<br>
<b>Regexp:</b> [sbm][0-2][0-9]{2}[a-z]\\.studby\\.ntnu\\.no</blockquote>');
INSERT INTO Operator (operatorid, matchfieldid) VALUES (0, 15);
INSERT INTO Operator (operatorid, matchfieldid) VALUES (5, 15);
INSERT INTO Operator (operatorid, matchfieldid) VALUES (6, 15);
INSERT INTO Operator (operatorid, matchfieldid) VALUES (7, 15);
INSERT INTO Operator (operatorid, matchfieldid) VALUES (8, 15);
INSERT INTO Operator (operatorid, matchfieldid) VALUES (9, 15);


INSERT INTO MatchField (matchfieldid, datatype, name, valueid, valuename, valuecategory, valuesort, showlist, descr, valuehelp) VALUES 
(16, 2, 'IP address', 'netbox.ip', null, null, null, false,
'Limit your alarms based on an IP address/range (prefix)',
'examples:<blockquote>
129.241.190.190<br>
129.241.190.0/24</br>
129.241.0.0/16</blockquote>');
INSERT INTO Operator (operatorid, matchfieldid) VALUES (0, 16);
INSERT INTO Operator (operatorid, matchfieldid) VALUES (11, 16);


INSERT INTO MatchField (matchfieldid, datatype, name, valueid, valuename, valuecategory, valuesort, showlist, descr) VALUES 
(17, 0, 'Room', 'room.roomid', 'room.descr|[ID]: [NAME]', 'room.locationid', 'room.roomid', true, 
'Room: Limit your alarms based on room.');
INSERT INTO Operator (operatorid, matchfieldid) VALUES (0, 17);
INSERT INTO Operator (operatorid, matchfieldid) VALUES (11, 17);


INSERT INTO MatchField (matchfieldid, datatype, name, valueid, valuename, valuecategory, valuesort, showlist, descr) VALUES 
(18, 0, 'Location', 'location.locationid', 'location.descr|[NAME] ([ID])', null, 'location.descr', true, 
'Location: Limit your alarms based on location (a location contains a set of rooms) ');
INSERT INTO Operator (operatorid, matchfieldid) VALUES (0, 18);
INSERT INTO Operator (operatorid, matchfieldid) VALUES (11, 18);


INSERT INTO MatchField (matchfieldid, datatype, name, valueid, valuename, valuecategory, valuesort, showlist, descr) VALUES 
(19, 0, 'Organization', 'org.orgid', 'org.descr|[NAME] ([ID])', null, 'org.descr', true, 
'Organization: Limit your alarms based on the organization ownership of the alarm in question.');
INSERT INTO Operator (operatorid, matchfieldid) VALUES (0, 19);
INSERT INTO Operator (operatorid, matchfieldid) VALUES (11, 19);


INSERT INTO MatchField (matchfieldid, datatype, name, valueid, valuename, valuecategory, valuesort, showlist, descr) VALUES 
(20, 0, 'Usage', 'usage.usageid', 'usage.descr', null, 'usage.descr', true, 
'Usage: Different network prefixes are mapped to usage areas.');
INSERT INTO Operator (operatorid, matchfieldid) VALUES (0, 20);
INSERT INTO Operator (operatorid, matchfieldid) VALUES (11, 20);


INSERT INTO MatchField (matchfieldid, datatype, name, valueid, valuename, valuecategory, valuesort, showlist, descr) VALUES 
(21, 0, 'Type', 'type.typename', 'type.descr', 'type.vendorid', 'type.descr', true, 
'Type: Limit your alarms equipment type');
INSERT INTO Operator (operatorid, matchfieldid) VALUES (0, 21);
INSERT INTO Operator (operatorid, matchfieldid) VALUES (11, 21);


INSERT INTO MatchField (matchfieldid, datatype, name, valueid, valuename, valuecategory, valuesort, showlist, descr) VALUES 
(22, 0, 'Equipment vendor', 'vendor.vendorid', 'vendor.vendorid', null, 'vendor.vendorid', true,
'Equipment vendor: Limit alert by the vendor of the netbox.');
INSERT INTO Operator (operatorid, matchfieldid) VALUES (0, 22);
INSERT INTO Operator (operatorid, matchfieldid) VALUES (11, 22);









-- INSERT DEFAULT FILTERS AND FILTER GROUPS

-- Table:Utstyrgruppe

INSERT INTO utstyrgruppe (id, accountid, navn, descr) VALUES (71, NULL, 'G01: All alerts', 'This filter group matches every alert. The group can i.e. be used to give a group permission to receive all alerts.');
INSERT INTO utstyrgruppe (id, accountid, navn, descr) VALUES (62, NULL, 'G02: All router alerts', '');
INSERT INTO utstyrgruppe (id, accountid, navn, descr) VALUES (63, NULL, 'G03: All switch (core and edge) alerts', '');

INSERT INTO utstyrgruppe (id, accountid, navn, descr) VALUES (64, NULL, 'G04: All core switch alerts', '');
INSERT INTO utstyrgruppe (id, accountid, navn, descr) VALUES (65, NULL, 'G05: All edge switch alert', '');
INSERT INTO utstyrgruppe (id, accountid, navn, descr) VALUES (68, NULL, 'G06: All alerts from wireless boxes', '');
INSERT INTO utstyrgruppe (id, accountid, navn, descr) VALUES (69, NULL, 'G07: All alerts from servers', '');
INSERT INTO utstyrgruppe (id, accountid, navn, descr) VALUES (70, NULL, 'G08: All alerts from OTHER equipment', '');
INSERT INTO utstyrgruppe (id, accountid, navn, descr) VALUES (72, NULL, 'G09: All boxState alerts', '');
INSERT INTO utstyrgruppe (id, accountid, navn, descr) VALUES (73, NULL, 'G10: All box up/down alerts', '');
INSERT INTO utstyrgruppe (id, accountid, navn, descr) VALUES (74, NULL, 'G11: All box sunny/shadow alerts', '');
INSERT INTO utstyrgruppe (id, accountid, navn, descr) VALUES (75, NULL, 'G12: All boxState early warnings', '');
INSERT INTO utstyrgruppe (id, accountid, navn, descr) VALUES (76, NULL, 'G13: All module outage alerts', '');
INSERT INTO utstyrgruppe (id, accountid, navn, descr) VALUES (77, NULL, 'G14: All services alerts', '');
INSERT INTO utstyrgruppe (id, accountid, navn, descr) VALUES (78, NULL, 'G15: All threshold alerts', '');
INSERT INTO utstyrgruppe (id, accountid, navn, descr) VALUES (79, NULL, 'G16: All device change alerts', '');
INSERT INTO utstyrgruppe (id, accountid, navn, descr) VALUES (81, NULL, 'G17: All alerts with severity >= Warning', '');
INSERT INTO utstyrgruppe (id, accountid, navn, descr) VALUES (82, NULL, 'G18: All alerts with severity >= Errors', '');
INSERT INTO utstyrgruppe (id, accountid, navn, descr) VALUES (83, NULL, 'G19: All alerts with severity >= Critical', '');
INSERT INTO utstyrgruppe (id, accountid, navn, descr) VALUES (84, NULL, 'G20: All alerts with severity = Emergency', '');

-- Table:Utstyrfilter

INSERT INTO utstyrfilter (id, accountid, navn) VALUES (13, NULL, 'F01: All alerts');
INSERT INTO utstyrfilter (id, accountid, navn) VALUES (29, NULL, 'F02: All router alerts');
INSERT INTO utstyrfilter (id, accountid, navn) VALUES (30, NULL, 'F03: All switch (core and edge) alerts');
INSERT INTO utstyrfilter (id, accountid, navn) VALUES (31, NULL, 'F04: All core switch alerts');
INSERT INTO utstyrfilter (id, accountid, navn) VALUES (32, NULL, 'F05: All edge switch alerts');
INSERT INTO utstyrfilter (id, accountid, navn) VALUES (33, NULL, 'F06: All alerts from wireless boxes');
INSERT INTO utstyrfilter (id, accountid, navn) VALUES (34, NULL, 'F07: All alerts from servers');
INSERT INTO utstyrfilter (id, accountid, navn) VALUES (35, NULL, 'F08: All alerts from OTHER equipment');
INSERT INTO utstyrfilter (id, accountid, navn) VALUES (36, NULL, 'F09: All boxState alerts');
INSERT INTO utstyrfilter (id, accountid, navn) VALUES (14, NULL, 'F10: All box up/down alerts');
INSERT INTO utstyrfilter (id, accountid, navn) VALUES (15, NULL, 'F11: All box sunny/shadow alerts');
INSERT INTO utstyrfilter (id, accountid, navn) VALUES (25, NULL, 'F12: All boxState early warnings');
INSERT INTO utstyrfilter (id, accountid, navn) VALUES (16, NULL, 'F13: All module outage alerts');
INSERT INTO utstyrfilter (id, accountid, navn) VALUES (26, NULL, 'F14: All services alerts');
INSERT INTO utstyrfilter (id, accountid, navn) VALUES (27, NULL, 'F15: All threshold alerts');
INSERT INTO utstyrfilter (id, accountid, navn) VALUES (28, NULL, 'F16: All device change alerts');
INSERT INTO utstyrfilter (id, accountid, navn) VALUES (20, NULL, 'F17: All alerts with severity >= Warning');
INSERT INTO utstyrfilter (id, accountid, navn) VALUES (21, NULL, 'F18: All alerts with severity >= Errors');
INSERT INTO utstyrfilter (id, accountid, navn) VALUES (23, NULL, 'F19: All alerts with severity >= Critical');
INSERT INTO utstyrfilter (id, accountid, navn) VALUES (24, NULL, 'F20: All alerts with severity = Emergency');




-- Table: gruppetilfilter

INSERT INTO gruppetilfilter (inkluder, positiv, prioritet, utstyrfilterid, utstyrgruppeid) VALUES (true, true, 1, 29, 62);
INSERT INTO gruppetilfilter (inkluder, positiv, prioritet, utstyrfilterid, utstyrgruppeid) VALUES (true, true, 1, 30, 63);
INSERT INTO gruppetilfilter (inkluder, positiv, prioritet, utstyrfilterid, utstyrgruppeid) VALUES (true, true, 2, 31, 64);
INSERT INTO gruppetilfilter (inkluder, positiv, prioritet, utstyrfilterid, utstyrgruppeid) VALUES (true, true, 1, 32, 65);
INSERT INTO gruppetilfilter (inkluder, positiv, prioritet, utstyrfilterid, utstyrgruppeid) VALUES (true, true, 1, 33, 68);
INSERT INTO gruppetilfilter (inkluder, positiv, prioritet, utstyrfilterid, utstyrgruppeid) VALUES (true, true, 1, 34, 69);
INSERT INTO gruppetilfilter (inkluder, positiv, prioritet, utstyrfilterid, utstyrgruppeid) VALUES (true, true, 1, 13, 71);
INSERT INTO gruppetilfilter (inkluder, positiv, prioritet, utstyrfilterid, utstyrgruppeid) VALUES (true, true, 1, 35, 70);
INSERT INTO gruppetilfilter (inkluder, positiv, prioritet, utstyrfilterid, utstyrgruppeid) VALUES (true, true, 1, 36, 72);
INSERT INTO gruppetilfilter (inkluder, positiv, prioritet, utstyrfilterid, utstyrgruppeid) VALUES (true, true, 1, 14, 73);
INSERT INTO gruppetilfilter (inkluder, positiv, prioritet, utstyrfilterid, utstyrgruppeid) VALUES (true, true, 1, 15, 74);
INSERT INTO gruppetilfilter (inkluder, positiv, prioritet, utstyrfilterid, utstyrgruppeid) VALUES (true, true, 1, 25, 75);
INSERT INTO gruppetilfilter (inkluder, positiv, prioritet, utstyrfilterid, utstyrgruppeid) VALUES (true, true, 1, 16, 76);
INSERT INTO gruppetilfilter (inkluder, positiv, prioritet, utstyrfilterid, utstyrgruppeid) VALUES (true, true, 1, 26, 77);
INSERT INTO gruppetilfilter (inkluder, positiv, prioritet, utstyrfilterid, utstyrgruppeid) VALUES (true, true, 1, 27, 78);
INSERT INTO gruppetilfilter (inkluder, positiv, prioritet, utstyrfilterid, utstyrgruppeid) VALUES (true, true, 1, 28, 79);
--INSERT INTO gruppetilfilter (inkluder, positiv, prioritet, utstyrfilterid, utstyrgruppeid) VALUES (true, true, 1, 19, 80);
INSERT INTO gruppetilfilter (inkluder, positiv, prioritet, utstyrfilterid, utstyrgruppeid) VALUES (true, true, 1, 20, 81);
INSERT INTO gruppetilfilter (inkluder, positiv, prioritet, utstyrfilterid, utstyrgruppeid) VALUES (true, true, 1, 21, 82);
INSERT INTO gruppetilfilter (inkluder, positiv, prioritet, utstyrfilterid, utstyrgruppeid) VALUES (true, true, 1, 23, 83);
INSERT INTO gruppetilfilter (inkluder, positiv, prioritet, utstyrfilterid, utstyrgruppeid) VALUES (true, true, 1, 24, 84);

-- Table: filtermatch

INSERT INTO filtermatch (id, utstyrfilterid, matchfelt, matchtype, verdi) VALUES (26, 29, 13, 11, 'GSW|GW');
INSERT INTO filtermatch (id, utstyrfilterid, matchfelt, matchtype, verdi) VALUES (27, 13, 12, 4, '100');
INSERT INTO filtermatch (id, utstyrfilterid, matchfelt, matchtype, verdi) VALUES (25, 30, 13, 11, 'EDGE|GSW|SW');
INSERT INTO filtermatch (id, utstyrfilterid, matchfelt, matchtype, verdi) VALUES (28, 31, 13, 11, 'GSW|SW');
INSERT INTO filtermatch (id, utstyrfilterid, matchfelt, matchtype, verdi) VALUES (29, 14, 11, 11, 'boxDown|boxUp');
INSERT INTO filtermatch (id, utstyrfilterid, matchfelt, matchtype, verdi) VALUES (30, 15, 11, 11, 'boxShadow|boxSunny');
INSERT INTO filtermatch (id, utstyrfilterid, matchfelt, matchtype, verdi) VALUES (31, 25, 11, 11, 'boxDownWarning|boxShadowWarning');
INSERT INTO filtermatch (id, utstyrfilterid, matchfelt, matchtype, verdi) VALUES (32, 16, 10, 0, 'moduleState');
INSERT INTO filtermatch (id, utstyrfilterid, matchfelt, matchtype, verdi) VALUES (43, 32, 13, 0, 'EDGE');
INSERT INTO filtermatch (id, utstyrfilterid, matchfelt, matchtype, verdi) VALUES (44, 33, 13, 0, 'WLAN');
INSERT INTO filtermatch (id, utstyrfilterid, matchfelt, matchtype, verdi) VALUES (45, 34, 13, 0, 'SRV');
INSERT INTO filtermatch (id, utstyrfilterid, matchfelt, matchtype, verdi) VALUES (46, 35, 13, 0, 'OTHER');
INSERT INTO filtermatch (id, utstyrfilterid, matchfelt, matchtype, verdi) VALUES (47, 36, 10, 0, 'boxState');
INSERT INTO filtermatch (id, utstyrfilterid, matchfelt, matchtype, verdi) VALUES (52, 26, 10, 0, 'serviceState');
INSERT INTO filtermatch (id, utstyrfilterid, matchfelt, matchtype, verdi) VALUES (53, 27, 10, 0, 'thresholdState');
INSERT INTO filtermatch (id, utstyrfilterid, matchfelt, matchtype, verdi) VALUES (55, 20, 12, 2, '20');
--INSERT INTO filtermatch (id, utstyrfilterid, matchfelt, matchtype, verdi) VALUES (56, 19, 12, 2, '0');
INSERT INTO filtermatch (id, utstyrfilterid, matchfelt, matchtype, verdi) VALUES (57, 21, 12, 2, '40');
INSERT INTO filtermatch (id, utstyrfilterid, matchfelt, matchtype, verdi) VALUES (58, 28, 10, 0, 'deviceChanged');
INSERT INTO filtermatch (id, utstyrfilterid, matchfelt, matchtype, verdi) VALUES (59, 23, 12, 2, '60');
INSERT INTO filtermatch (id, utstyrfilterid, matchfelt, matchtype, verdi) VALUES (61, 24, 12, 2, '80');


-- Table: Rettighet

INSERT INTO rettighet (accountgroupid, utstyrgruppeid) VALUES (1, 71);


-- Table: defaultutstyr

INSERT INTO defaultutstyr (accountgroupid, utstyrgruppeid) VALUES (1, 71);
INSERT INTO defaultutstyr (accountgroupid, utstyrgruppeid) VALUES (1, 62);
INSERT INTO defaultutstyr (accountgroupid, utstyrgruppeid) VALUES (1, 63);
INSERT INTO defaultutstyr (accountgroupid, utstyrgruppeid) VALUES (1, 64);
INSERT INTO defaultutstyr (accountgroupid, utstyrgruppeid) VALUES (1, 65);
INSERT INTO defaultutstyr (accountgroupid, utstyrgruppeid) VALUES (1, 68);
INSERT INTO defaultutstyr (accountgroupid, utstyrgruppeid) VALUES (1, 69);
INSERT INTO defaultutstyr (accountgroupid, utstyrgruppeid) VALUES (1, 70);
INSERT INTO defaultutstyr (accountgroupid, utstyrgruppeid) VALUES (1, 72);
INSERT INTO defaultutstyr (accountgroupid, utstyrgruppeid) VALUES (1, 73);
INSERT INTO defaultutstyr (accountgroupid, utstyrgruppeid) VALUES (1, 74);
INSERT INTO defaultutstyr (accountgroupid, utstyrgruppeid) VALUES (1, 75);
INSERT INTO defaultutstyr (accountgroupid, utstyrgruppeid) VALUES (1, 76);
INSERT INTO defaultutstyr (accountgroupid, utstyrgruppeid) VALUES (1, 77);
INSERT INTO defaultutstyr (accountgroupid, utstyrgruppeid) VALUES (1, 78);
INSERT INTO defaultutstyr (accountgroupid, utstyrgruppeid) VALUES (1, 79);
INSERT INTO defaultutstyr (accountgroupid, utstyrgruppeid) VALUES (1, 81);
INSERT INTO defaultutstyr (accountgroupid, utstyrgruppeid) VALUES (1, 82);
INSERT INTO defaultutstyr (accountgroupid, utstyrgruppeid) VALUES (1, 83);
INSERT INTO defaultutstyr (accountgroupid, utstyrgruppeid) VALUES (1, 84);



-- Table: defaultfilter

INSERT INTO defaultfilter (accountgroupid, utstyrfilterid) VALUES (1, 13);
INSERT INTO defaultfilter (accountgroupid, utstyrfilterid) VALUES (1, 29);
INSERT INTO defaultfilter (accountgroupid, utstyrfilterid) VALUES (1, 30);
INSERT INTO defaultfilter (accountgroupid, utstyrfilterid) VALUES (1, 31);
INSERT INTO defaultfilter (accountgroupid, utstyrfilterid) VALUES (1, 32);
INSERT INTO defaultfilter (accountgroupid, utstyrfilterid) VALUES (1, 33);
INSERT INTO defaultfilter (accountgroupid, utstyrfilterid) VALUES (1, 34);
INSERT INTO defaultfilter (accountgroupid, utstyrfilterid) VALUES (1, 35);
INSERT INTO defaultfilter (accountgroupid, utstyrfilterid) VALUES (1, 36);
INSERT INTO defaultfilter (accountgroupid, utstyrfilterid) VALUES (1, 14);
INSERT INTO defaultfilter (accountgroupid, utstyrfilterid) VALUES (1, 15);
INSERT INTO defaultfilter (accountgroupid, utstyrfilterid) VALUES (1, 25);
INSERT INTO defaultfilter (accountgroupid, utstyrfilterid) VALUES (1, 16);
INSERT INTO defaultfilter (accountgroupid, utstyrfilterid) VALUES (1, 26);
INSERT INTO defaultfilter (accountgroupid, utstyrfilterid) VALUES (1, 27);
INSERT INTO defaultfilter (accountgroupid, utstyrfilterid) VALUES (1, 28);
INSERT INTO defaultfilter (accountgroupid, utstyrfilterid) VALUES (1, 20);
INSERT INTO defaultfilter (accountgroupid, utstyrfilterid) VALUES (1, 21);
INSERT INTO defaultfilter (accountgroupid, utstyrfilterid) VALUES (1, 23);
INSERT INTO defaultfilter (accountgroupid, utstyrfilterid) VALUES (1, 24);




/*
------------------------------------------------------
 EOF
------------------------------------------------------
*/