Подскажите, как можно искать ноды по snmp sysname?
заранее спасибо!
заранее спасибо!
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Show posts Menuselect
N.SNMP_OID,N.UNAME
from netxms.nodes N
left JOIN netxms.interfaces I on I.NODE_ID = N.id
and N.PRIMARY_IP = I.IP_ADDR
where I.IP_ADDR is null;
INSERT INTO dashboard_elements (dashboard_id,element_id,element_type,element_data,layout_data) VALUES (142571,0,1,'
___Много_строк_xml____
')"): ORA-01704: string literal too long
to_clob( 'value of 1500 characters' )
...
...
[16-Jun-2014 16:03:42.590] [DEBUG] * Syncer * Unable to delete object with id 115018 because it is being referenced 3 time(s)
[16-Jun-2014 16:03:42.590] [DEBUG] * Syncer * Unable to delete object with id 115019 because it is being referenced 3 time(s)
[16-Jun-2014 16:03:42.590] [DEBUG] * Syncer * Unable to delete object with id 115020 because it is being referenced 12 time(s)
[16-Jun-2014 16:03:42.677] [DEBUG] * Syncer * Unable to delete object with id 115781 because it is being referenced 4 time(s)
[16-Jun-2014 16:03:42.677] [DEBUG] * Syncer * Unable to delete object with id 115786 because it is being referenced 4 time(s)
[16-Jun-2014 16:03:42.791] [DEBUG] * Syncer * Unable to delete object with id 117912 because it is being referenced 4 time(s)
[16-Jun-2014 16:03:42.791] [DEBUG] * Syncer * Unable to delete object with id 117913 because it is being referenced 4 time(s)
[16-Jun-2014 16:03:42.809] [DEBUG] * Syncer * Unable to delete object with id 118928 because it is being referenced 3 time(s)
[16-Jun-2014 16:03:42.809] [DEBUG] * Syncer * Unable to delete object with id 120795 because it is being referenced 4 time(s)
[16-Jun-2014 16:03:42.809] [DEBUG] * Syncer * Unable to delete object with id 120796 because it is being referenced 4 time(s)
[16-Jun-2014 16:03:42.810] [DEBUG] * Syncer * Unable to delete object with id 120799 because it is being referenced 3 time(s)
[16-Jun-2014 16:03:42.810] [DEBUG] * Syncer * Unable to delete object with id 120800 because it is being referenced 3 time(s)
[16-Jun-2014 16:03:42.810] [DEBUG] * Syncer * Unable to delete object with id 120801 because it is being referenced 3 time(s)
[16-Jun-2014 16:03:42.810] [DEBUG] * Syncer * Unable to delete object with id 120802 because it is being referenced 3 time(s)
[16-Jun-2014 16:03:42.810] [DEBUG] * Syncer * Unable to delete object with id 120803 because it is being referenced 3 time(s)
[16-Jun-2014 16:03:42.810] [DEBUG] * Syncer * Unable to delete object with id 120804 because it is being referenced 13 time(s)
[16-Jun-2014 16:03:42.810] [DEBUG] * Syncer * Unable to delete object with id 121911 because it is being referenced 4 time(s)
[16-Jun-2014 16:03:42.810] [DEBUG] * Syncer * Unable to delete object with id 121912 because it is being referenced 4 time(s)
[16-Jun-2014 16:03:42.828] [DEBUG] * Syncer * Unable to delete object with id 123238 because it is being referenced 4 time(s)
[16-Jun-2014 16:03:42.828] [DEBUG] * Syncer * Unable to delete object with id 123239 because it is being referenced 4 time(s)
[16-Jun-2014 16:03:42.828] [DEBUG] * Syncer * Unable to delete object with id 123241 because it is being referenced 3 time(s)
[16-Jun-2014 16:03:42.828] [DEBUG] * Syncer * Unable to delete object with id 123242 because it is being referenced 3 time(s)
[16-Jun-2014 16:03:42.828] [DEBUG] * Syncer * Unable to delete object with id 123243 because it is being referenced 3 time(s)
[16-Jun-2014 16:03:42.828] [DEBUG] * Syncer * Unable to delete object with id 123264 because it is being referenced 3 time(s)
[16-Jun-2014 16:03:42.828] [DEBUG] * Syncer * Unable to delete object with id 124560 because it is being referenced 3 time(s)
[16-Jun-2014 16:03:42.828] [DEBUG] * Syncer * Unable to delete object with id 124561 because it is being referenced 7 time(s)
[16-Jun-2014 16:03:42.828] [DEBUG] * Syncer * Unable to delete object with id 124588 because it is being referenced 3 time(s)
...
...
[10-Jun-2014 12:01:19.794] [DEBUG] EVENT 100001 (ID:4533657 F:0x0001 S:0 TAG:"") FROM I0______: Mail data collection item "rttMonCtrlOperTimeoutOccurred 81101" (Parameter: 1.3.6.1.4.1.9.9.42.1.2.9.1.6.81101; Threshold value: 0x00001B05; Actual value: 81101)
[10-Jun-2014 12:01:19.794] [DEBUG] *actions* Action 2 (emailDeveloper) is disabled and will not be executed
[10-Jun-2014 12:01:19.794] [DEBUG] *actions* Executing action 3 (EmailASOP2) of type SEND EMAIL
[10-Jun-2014 12:01:19.794] [DEBUG] *actions* Sending mail to ____@________: "Target: 1.3.6.1.4.1.9.9.42.1.2.9.1.6.81101
Device: I0______
IP: 0.0.0.0
Alert: rttMonCtrlOperTimeoutOccurred 81101
State: Normal
Value: 81101
Thresholds: Normal:0x00001B05
LastCheck: 10-Jun-2014 12:01:19"
System Description=Cisco IOS Software, s2t54 Software (s2t54-IPSERVICESK9-M), Version 15.0(1)SY2, RELEASE SOFTWARE (fc4) Technical Support: http://www.cisco.com/techsupport Copyright (c) 1986-2012 by Cisco Systems, Inc. Compiled Tue 10-Jul-12 13:35 by prod_rel_team
SNMP Object ID=.1.3.6.1.4.1.9.1.896)