forked from aigarskadikis/aigarskadikis.github.io
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy path2040000.sql
100 lines (100 loc) · 9.79 KB
/
2040000.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
SELECT `userid` FROM `acknowledges` WHERE `userid` NOT IN (SELECT `userid` FROM `users`);
SELECT `eventid` FROM `acknowledges` WHERE `eventid` NOT IN (SELECT `eventid` FROM `events`);
SELECT `actionid` FROM `alerts` WHERE `actionid` NOT IN (SELECT `actionid` FROM `actions`);
SELECT `eventid` FROM `alerts` WHERE `eventid` NOT IN (SELECT `eventid` FROM `events`);
SELECT `userid` FROM `alerts` WHERE `userid` NOT IN (SELECT `userid` FROM `users`);
SELECT `mediatypeid` FROM `alerts` WHERE `mediatypeid` NOT IN (SELECT `mediatypeid` FROM `media_type`);
SELECT `applicationid` FROM `application_template` WHERE `applicationid` NOT IN (SELECT `applicationid` FROM `applications`);
SELECT `templateid` FROM `application_template` WHERE `templateid` NOT IN (SELECT `applicationid` FROM `applications`);
SELECT `hostid` FROM `applications` WHERE `hostid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `userid` FROM `auditlog` WHERE `userid` NOT IN (SELECT `userid` FROM `users`);
SELECT `auditid` FROM `auditlog_details` WHERE `auditid` NOT IN (SELECT `auditid` FROM `auditlog`);
SELECT `proxy_hostid` FROM `autoreg_host` WHERE `proxy_hostid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `actionid` FROM `conditions` WHERE `actionid` NOT IN (SELECT `actionid` FROM `actions`);
SELECT `druleid` FROM `dchecks` WHERE `druleid` NOT IN (SELECT `druleid` FROM `drules`);
SELECT `druleid` FROM `dhosts` WHERE `druleid` NOT IN (SELECT `druleid` FROM `drules`);
SELECT `dhostid` FROM `dservices` WHERE `dhostid` NOT IN (SELECT `dhostid` FROM `dhosts`);
SELECT `dcheckid` FROM `dservices` WHERE `dcheckid` NOT IN (SELECT `dcheckid` FROM `dchecks`);
SELECT `regexpid` FROM `expressions` WHERE `regexpid` NOT IN (SELECT `regexpid` FROM `regexps`);
SELECT `itemid` FROM `functions` WHERE `itemid` NOT IN (SELECT `itemid` FROM `items`);
SELECT `triggerid` FROM `functions` WHERE `triggerid` NOT IN (SELECT `triggerid` FROM `triggers`);
SELECT `graphid` FROM `graph_discovery` WHERE `graphid` NOT IN (SELECT `graphid` FROM `graphs`);
SELECT `templateid` FROM `graphs` WHERE `templateid` NOT IN (SELECT `graphid` FROM `graphs`);
SELECT `graphid` FROM `graphs_items` WHERE `graphid` NOT IN (SELECT `graphid` FROM `graphs`);
SELECT `itemid` FROM `graphs_items` WHERE `itemid` NOT IN (SELECT `itemid` FROM `items`);
SELECT `groupid` FROM `group_discovery` WHERE `groupid` NOT IN (SELECT `groupid` FROM `groups`);
SELECT `hostid` FROM `group_prototype` WHERE `hostid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `templateid` FROM `group_prototype` WHERE `templateid` NOT IN (SELECT `group_prototypeid` FROM `group_prototype`);
SELECT `hostid` FROM `host_discovery` WHERE `hostid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `hostid` FROM `host_inventory` WHERE `hostid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `hostid` FROM `hostmacro` WHERE `hostid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `templateid` FROM `hosts` WHERE `templateid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `hostid` FROM `hosts_groups` WHERE `hostid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `groupid` FROM `hosts_groups` WHERE `groupid` NOT IN (SELECT `groupid` FROM `groups`);
SELECT `hostid` FROM `hosts_templates` WHERE `hostid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `templateid` FROM `hosts_templates` WHERE `templateid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `httptestid` FROM `httpstep` WHERE `httptestid` NOT IN (SELECT `httptestid` FROM `httptest`);
SELECT `httpstepid` FROM `httpstepitem` WHERE `httpstepid` NOT IN (SELECT `httpstepid` FROM `httpstep`);
SELECT `itemid` FROM `httpstepitem` WHERE `itemid` NOT IN (SELECT `itemid` FROM `items`);
SELECT `hostid` FROM `httptest` WHERE `hostid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `templateid` FROM `httptest` WHERE `templateid` NOT IN (SELECT `httptestid` FROM `httptest`);
SELECT `httptestid` FROM `httptestitem` WHERE `httptestid` NOT IN (SELECT `httptestid` FROM `httptest`);
SELECT `itemid` FROM `httptestitem` WHERE `itemid` NOT IN (SELECT `itemid` FROM `items`);
SELECT `iconmapid` FROM `icon_mapping` WHERE `iconmapid` NOT IN (SELECT `iconmapid` FROM `icon_map`);
SELECT `hostid` FROM `interface` WHERE `hostid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `interfaceid` FROM `interface_discovery` WHERE `interfaceid` NOT IN (SELECT `interfaceid` FROM `interface`);
SELECT `parent_interfaceid` FROM `interface_discovery` WHERE `parent_interfaceid` NOT IN (SELECT `interfaceid` FROM `interface`);
SELECT `itemid` FROM `item_condition` WHERE `itemid` NOT IN (SELECT `itemid` FROM `items`);
SELECT `itemid` FROM `item_discovery` WHERE `itemid` NOT IN (SELECT `itemid` FROM `items`);
SELECT `parent_itemid` FROM `item_discovery` WHERE `parent_itemid` NOT IN (SELECT `itemid` FROM `items`);
SELECT `hostid` FROM `items` WHERE `hostid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `templateid` FROM `items` WHERE `templateid` NOT IN (SELECT `itemid` FROM `items`);
SELECT `applicationid` FROM `items_applications` WHERE `applicationid` NOT IN (SELECT `applicationid` FROM `applications`);
SELECT `itemid` FROM `items_applications` WHERE `itemid` NOT IN (SELECT `itemid` FROM `items`);
SELECT `maintenanceid` FROM `maintenances_groups` WHERE `maintenanceid` NOT IN (SELECT `maintenanceid` FROM `maintenances`);
SELECT `groupid` FROM `maintenances_groups` WHERE `groupid` NOT IN (SELECT `groupid` FROM `groups`);
SELECT `maintenanceid` FROM `maintenances_hosts` WHERE `maintenanceid` NOT IN (SELECT `maintenanceid` FROM `maintenances`);
SELECT `hostid` FROM `maintenances_hosts` WHERE `hostid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `maintenanceid` FROM `maintenances_windows` WHERE `maintenanceid` NOT IN (SELECT `maintenanceid` FROM `maintenances`);
SELECT `timeperiodid` FROM `maintenances_windows` WHERE `timeperiodid` NOT IN (SELECT `timeperiodid` FROM `timeperiods`);
SELECT `valuemapid` FROM `mappings` WHERE `valuemapid` NOT IN (SELECT `valuemapid` FROM `valuemaps`);
SELECT `userid` FROM `media` WHERE `userid` NOT IN (SELECT `userid` FROM `users`);
SELECT `mediatypeid` FROM `media` WHERE `mediatypeid` NOT IN (SELECT `mediatypeid` FROM `media_type`);
SELECT `operationid` FROM `opcommand` WHERE `operationid` NOT IN (SELECT `operationid` FROM `operations`);
SELECT `operationid` FROM `opcommand_grp` WHERE `operationid` NOT IN (SELECT `operationid` FROM `operations`);
SELECT `operationid` FROM `opcommand_hst` WHERE `operationid` NOT IN (SELECT `operationid` FROM `operations`);
SELECT `operationid` FROM `opconditions` WHERE `operationid` NOT IN (SELECT `operationid` FROM `operations`);
SELECT `actionid` FROM `operations` WHERE `actionid` NOT IN (SELECT `actionid` FROM `actions`);
SELECT `operationid` FROM `opgroup` WHERE `operationid` NOT IN (SELECT `operationid` FROM `operations`);
SELECT `operationid` FROM `opmessage` WHERE `operationid` NOT IN (SELECT `operationid` FROM `operations`);
SELECT `operationid` FROM `opmessage_grp` WHERE `operationid` NOT IN (SELECT `operationid` FROM `operations`);
SELECT `operationid` FROM `opmessage_usr` WHERE `operationid` NOT IN (SELECT `operationid` FROM `operations`);
SELECT `operationid` FROM `optemplate` WHERE `operationid` NOT IN (SELECT `operationid` FROM `operations`);
SELECT `userid` FROM `profiles` WHERE `userid` NOT IN (SELECT `userid` FROM `users`);
SELECT `groupid` FROM `rights` WHERE `groupid` NOT IN (SELECT `usrgrpid` FROM `usrgrp`);
SELECT `id` FROM `rights` WHERE `id` NOT IN (SELECT `groupid` FROM `groups`);
SELECT `templateid` FROM `screens` WHERE `templateid` NOT IN (SELECT `hostid` FROM `hosts`);
SELECT `screenid` FROM `screens_items` WHERE `screenid` NOT IN (SELECT `screenid` FROM `screens`);
SELECT `serviceid` FROM `service_alarms` WHERE `serviceid` NOT IN (SELECT `serviceid` FROM `services`);
SELECT `triggerid` FROM `services` WHERE `triggerid` NOT IN (SELECT `triggerid` FROM `triggers`);
SELECT `serviceupid` FROM `services_links` WHERE `serviceupid` NOT IN (SELECT `serviceid` FROM `services`);
SELECT `servicedownid` FROM `services_links` WHERE `servicedownid` NOT IN (SELECT `serviceid` FROM `services`);
SELECT `serviceid` FROM `services_times` WHERE `serviceid` NOT IN (SELECT `serviceid` FROM `services`);
SELECT `userid` FROM `sessions` WHERE `userid` NOT IN (SELECT `userid` FROM `users`);
SELECT `slideshowid` FROM `slides` WHERE `slideshowid` NOT IN (SELECT `slideshowid` FROM `slideshows`);
SELECT `screenid` FROM `slides` WHERE `screenid` NOT IN (SELECT `screenid` FROM `screens`);
SELECT `selementid` FROM `sysmap_element_url` WHERE `selementid` NOT IN (SELECT `selementid` FROM `sysmaps_elements`);
SELECT `sysmapid` FROM `sysmap_url` WHERE `sysmapid` NOT IN (SELECT `sysmapid` FROM `sysmaps`);
SELECT `sysmapid` FROM `sysmaps_elements` WHERE `sysmapid` NOT IN (SELECT `sysmapid` FROM `sysmaps`);
SELECT `linkid` FROM `sysmaps_link_triggers` WHERE `linkid` NOT IN (SELECT `linkid` FROM `sysmaps_links`);
SELECT `triggerid` FROM `sysmaps_link_triggers` WHERE `triggerid` NOT IN (SELECT `triggerid` FROM `triggers`);
SELECT `sysmapid` FROM `sysmaps_links` WHERE `sysmapid` NOT IN (SELECT `sysmapid` FROM `sysmaps`);
SELECT `selementid1` FROM `sysmaps_links` WHERE `selementid1` NOT IN (SELECT `selementid` FROM `sysmaps_elements`);
SELECT `selementid2` FROM `sysmaps_links` WHERE `selementid2` NOT IN (SELECT `selementid` FROM `sysmaps_elements`);
SELECT `triggerid_down` FROM `trigger_depends` WHERE `triggerid_down` NOT IN (SELECT `triggerid` FROM `triggers`);
SELECT `triggerid_up` FROM `trigger_depends` WHERE `triggerid_up` NOT IN (SELECT `triggerid` FROM `triggers`);
SELECT `triggerid` FROM `trigger_discovery` WHERE `triggerid` NOT IN (SELECT `triggerid` FROM `triggers`);
SELECT `templateid` FROM `triggers` WHERE `templateid` NOT IN (SELECT `triggerid` FROM `triggers`);
SELECT `userid` FROM `user_history` WHERE `userid` NOT IN (SELECT `userid` FROM `users`);
SELECT `usrgrpid` FROM `users_groups` WHERE `usrgrpid` NOT IN (SELECT `usrgrpid` FROM `usrgrp`);
SELECT `userid` FROM `users_groups` WHERE `userid` NOT IN (SELECT `userid` FROM `users`);