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 Menunxget -I X.X.X.X | grep Net.Interface
Net.Interface.64BitCounters INT "Is 64bit interface counters supported"
Net.Interface.AdminStatus(*) INT "Administrative status of interface {instance}"
Net.Interface.BytesIn(*) UINT "Number of input bytes on interface {instance}"
Net.Interface.BytesOut(*) UINT "Number of output bytes on interface {instance}"
Net.Interface.InErrors(*) UINT "Number of input errors on interface {instance}"
Net.Interface.OperStatus(*) INT "Operational status of interface {instance}"
Net.Interface.OutErrors(*) UINT "Number of output errors on interface {instance}"
Net.Interface.PacketsIn(*) UINT "Number of input packets on interface {instance}"
Net.Interface.PacketsOut(*) UINT "Number of output packets on interface {instance}"
Net.Interface.BytesIn64(*) UINT64 "Number of input bytes on interface {instance}"
Net.Interface.BytesOut64(*) UINT64 "Number of output bytes on interface {instance}"
Net.Interface.InErrors64(*) UINT64 "Number of input errors on interface {instance}"
Net.Interface.OutErrors64(*) UINT64 "Number of output errors on interface {instance}"
Net.Interface.PacketsIn64(*) UINT64 "Number of input packets on interface {instance}"
Net.Interface.PacketsOut64(*) UINT64 "Number of output packets on interface {instance}"
nxget -ne0 X.X.X.X "Net.Interface.BytesOut64(igb0)"
404: Unknown parameter
Quote from: 2c2i on February 27, 2017, 04:20:48 PM
Используйте 64бит счетчик
Net.Interface.BytesIn64({instance})
return int64($1) * 8;
[15-Feb-2017 14:44:21.451] [DEBUG] DataCollector: sleeping for 60 seconds
[15-Feb-2017 14:44:58.330] [DEBUG] Incoming connection from 192.168.10.10
[15-Feb-2017 14:44:58.330] [DEBUG] Connection from 192.168.10.10 accepted
[15-Feb-2017 14:44:58.330] [DEBUG] Session registered for 192.168.10.10
[15-Feb-2017 14:44:58.330] [DEBUG] [session:1] Message dump:
** 00B60020000000100000000000000000
** code=0x00B6 (CMD_GET_NXCP_CAPS) flags=0x0020 id=0 size=16 numFields=0
[15-Feb-2017 14:44:58.330] [DEBUG] [session:1] Received control message CMD_GET_NXCP_CAPS
[15-Feb-2017 14:44:58.330] [DEBUG] [session:1] Sending message CMD_NXCP_CAPS (size 16)
[15-Feb-2017 14:44:58.330] [DEBUG] [session:1] Outgoing message dump:
** 00B70020000000100000000003000000
** code=0x00B7 (CMD_NXCP_CAPS) flags=0x0020 id=0 size=16 numFields=50331648
** message format error (pos > size - 8)
[15-Feb-2017 14:44:58.330] [DEBUG] [session:1] Message dump:
** 01340000000000280000000100000003
** 00000097030100010000021703010001
** 0000021803010001
** code=0x0134 (CMD_SET_SERVER_CAPABILITIES) flags=0x0000 id=1 size=40 numFields=3
** [ 151] INT16 1
** [ 535] INT16 1
** [ 536] INT16 1
[15-Feb-2017 14:44:58.330] [DEBUG] [session:1] Received message CMD_SET_SERVER_CAPABILITIES
[15-Feb-2017 14:44:58.331] [DEBUG] [session:1] Sending message CMD_REQUEST_COMPLETED (size 32)
[15-Feb-2017 14:44:58.331] [DEBUG] [session:1] Outgoing message dump:
** 001D0000000000200000000100000001
** 0000001C000000000000000000000000
** code=0x001D (CMD_REQUEST_COMPLETED) flags=0x0000 id=1 size=32 numFields=1
** [ 28] INT32 0
[15-Feb-2017 14:44:58.331] [DEBUG] [session:1] Message dump:
** 00760000000000100000000200000000
** code=0x0076 (CMD_GET_PARAMETER_LIST) flags=0x0000 id=2 size=16 numFields=0
[15-Feb-2017 14:44:58.331] [DEBUG] [session:1] Received message CMD_GET_PARAMETER_LIST
[15-Feb-2017 14:44:58.332] [DEBUG] [session:1] Sending message CMD_REQUEST_COMPLETED (size 40880)
[15-Feb-2017 14:44:58.336] [DEBUG] [session:1] Outgoing message dump:
** 001D000000009FB000000002000002F2
** 0000001C000000000000000000000000
** 10000000010000000000003200410067
** 0065006E0074002E0041006300630065
** 00700074006500640043006F006E006E
** 0065006300740069006F006E00730000
** 10000001010000000000004E004E0075
** 006D0062006500720020006F00660020
** 0063006F006E006E0065006300740069
** 006F006E007300200061006300630065
** 00700074006500640020006200790020
** 006100670065006E0074000000000000
** 10000002030000011000000301000000
** 00000024004100670065006E0074002E
** 00410063006300650070007400450072
** 0072006F007200731000000401000000
** 0000003C004E0075006D006200650072
** 0020006F006600200061006300630065
** 0070007400280029002000630061006C
** 006C0020006500720072006F00720073
** 10000005030000011000000601000000
** 0000002E004100670065006E0074002E
** 0041006300740069007600650043006F
** 006E006E0065006300740069006F006E
** 00730000000000001000000701000000
** 0000004A004E0075006D006200650072
** 0020006F006600200061006300740069
** 0076006500200063006F006E006E0065
** 006300740069006F006E007300200074
** 006F0020006100670065006E00740000
** 10000008030000011000000901000000
** 00000038004100670065006E0074002E
** 00410075007400680065006E00740069
** 0063006100740069006F006E00460061
** 0069006C007500720065007300000000
** 1000000A0100000000000042004E0075
** 006D0062006500720020006F00660020
** 00610075007400680065006E00740069
** 0063006100740069006F006E00200066
** 00610069006C00750072006500730000
** 1000000B030000011000000C01000000
** 00000032004100670065006E0074002E
** 0043006F006E00660069006700750072
** 006100740069006F006E005300650072
** 00760065007200001000000D01000000
** 000000620043006F006E006600690067
** 00750072006100740069006F006E0020
** 00730065007200760065007200200061
** 00640064007200650073007300200073
** 006500740020006F006E002000610067
** 0065006E007400200073007400610072
** 00740075007000001000000E03000004
** 1000000F010000000000003800410067
** 0065006E0074002E0044006100740061
** 0043006F006C006C006500630074006F
** 00720051007500650075006500530069
** 007A0065000000001000001001000000
** 0000003E004100670065006E00740020
** 006400610074006100200063006F006C
** 006C006500630074006F007200200071
** 0075006500750065002000730069007A
** 00650000000000001000001103000001
** 10000012010000000000002800410067
** 0065006E0074002E004600610069006C
** 00650064005200650071007500650073
** 00740073000000001000001301000000
** 00000044004E0075006D006200650072
** 0020006F00660020006600610069006C
** 00650064002000720065007100750065
** 00730074007300200074006F00200061
** 00670065006E00741000001403000001
** 10000015010000000000002800410067
** 0065006E0074002E00470065006E0065
** 00720061007400650064005400720061
** 00700073000000001000001601000000
** 00000044004E0075006D006200650072
** 0020006F006600200074007200610070
** 0073002000670065006E006500720061
** 00740065006400200062007900200061
** 00670065006E00741000001703000003
** 10000018010000000000003200410067
** 0065006E0074002E0049007300530075
** 0062006100670065006E0074004C006F
** 00610064006500640028002A00290000
** 10000019010000000000004200430068
** 00650063006B00200069006600200067
** 006900760065006E0020007300750062
** 006100670065006E0074002000690073
** 0020006C006F00610064006500640000
** 1000001A030000001000001B01000000
** 00000024004100670065006E0074002E
** 004C0061007300740054007200610070
** 00540069006D00651000001C01000000
** 0000004000540069006D006500730074
** 0061006D00700020006F00660020006C
** 006100730074002000670065006E0065
** 00720061007400650064002000740072
** 00610070000000001000001D03000003
** 1000001E010000000000002E00410067
** 0065006E0074002E00500072006F0063
** 00650073007300650064005200650071
** 00750065007300740073000000000000
** 1000001F010000000000004A004E0075
** 006D0062006500720020006F00660020
** 00720065007100750065007300740073
** 002000700072006F0063006500730073
** 00650064002000620079002000610067
** 0
[15-Feb-2017 14:45:03.335] [DEBUG] [session:1] Message receiving error (MSGRECV_CLOSED)
[15-Feb-2017 14:45:03.335] [DEBUG] [session:1] Session with 192.168.10.10 closedlistening on igb0, link-type EN10MB (Ethernet), capture size 65535 bytes
14:47:14.703864 IP SERVER.IP.39578 > AGENT.IP.4700: Flags [SEW], seq 552614118, win 65535, options [mss 8960,nop,wscale 14,sackOK,TS val 1510402760 ecr 0], length 0
14:47:14.703928 IP AGENT.IP.4700 > SERVER.IP.39578: Flags [S.E], seq 3068699694, ack 552614119, win 17896, options [mss 8960,nop,nop,TS val 162865196 ecr 1510402760], length 0
14:47:14.703957 IP SERVER.IP.39578 > AGENT.IP.4700: Flags [.], ack 1, win 65535, options [nop,nop,TS val 1510402760 ecr 162865196], length 0
14:47:14.703984 IP SERVER.IP.39578 > AGENT.IP.4700: Flags [P.], seq 1:17, ack 1, win 65535, options [nop,nop,TS val 1510402760 ecr 162865196], length 16
14:47:14.704113 IP AGENT.IP.4700 > SERVER.IP.39578: Flags [.], ack 17, win 17896, options [nop,nop,TS val 162865196 ecr 1510402760], length 0
14:47:14.704274 IP AGENT.IP.4700 > SERVER.IP.39578: Flags [P.], seq 1:17, ack 17, win 17896, options [nop,nop,TS val 162865196 ecr 1510402760], length 16
14:47:14.704394 IP SERVER.IP.39578 > AGENT.IP.4700: Flags [P.], seq 17:57, ack 17, win 65535, options [nop,nop,TS val 1510402761 ecr 162865196], length 40
14:47:14.704518 IP AGENT.IP.4700 > SERVER.IP.39578: Flags [P.], seq 17:49, ack 57, win 17896, options [nop,nop,TS val 162865196 ecr 1510402761], length 32
14:47:14.704637 IP SERVER.IP.39578 > AGENT.IP.4700: Flags [P.], seq 57:73, ack 49, win 65535, options [nop,nop,TS val 1510402761 ecr 162865196], length 16
14:47:14.706562 IP AGENT.IP.4700 > SERVER.IP.39578: Flags [.], seq 49:8997, ack 73, win 17896, options [nop,nop,TS val 162865196 ecr 1510402761], length 8948
14:47:14.706633 IP AGENT.IP.4700 > SERVER.IP.39578: Flags [.], seq 8997:17945, ack 73, win 17896, options [nop,nop,TS val 162865196 ecr 1510402761], length 8948
14:47:14.706651 IP SERVER.IP.39578 > AGENT.IP.4700: Flags [.], ack 17945, win 62636, options [nop,nop,TS val 1510402764 ecr 162865196], length 0
14:47:14.707007 IP AGENT.IP.4700 > SERVER.IP.39578: Flags [.], seq 17945:26893, ack 73, win 17896, options [nop,nop,TS val 162865196 ecr 1510402761], length 8948
14:47:14.707020 IP AGENT.IP.4700 > SERVER.IP.39578: Flags [P.], seq 26893:35841, ack 73, win 17896, options [nop,nop,TS val 162865196 ecr 1510402761], length 8948
14:47:14.707034 IP SERVER.IP.39578 > AGENT.IP.4700: Flags [.], ack 35841, win 53688, options [nop,nop,TS val 1510402764 ecr 162865196], length 0
14:47:14.707036 IP AGENT.IP.4700 > SERVER.IP.39578: Flags [P.], seq 35841:41153, ack 73, win 17896, options [nop,nop,TS val 162865196 ecr 1510402761], length 5312
14:47:14.708907 IP SERVER.IP.39578 > AGENT.IP.4700: Flags [F.], seq 73, ack 41153, win 48376, options [nop,nop,TS val 1510402765 ecr 162865196], length 0
14:47:14.709136 IP AGENT.IP.4700 > SERVER.IP.39578: Flags [F.], seq 41153, ack 74, win 17896, options [nop,nop,TS val 162865197 ecr 1510402765], length 0
14:47:14.709156 IP SERVER.IP.39578 > AGENT.IP.4700: Flags [.], ack 41154, win 48375, options [nop,nop,TS val 1510402765 ecr 162865197], length 0
14:47:23.055766 IP SERVER.IP.39580 > AGENT.IP.4700: Flags [SEW], seq 2755998765, win 65535, options [mss 8960,nop,wscale 14,sackOK,TS val 2133096580 ecr 0], length 0
14:47:23.055898 IP AGENT.IP.4700 > SERVER.IP.39580: Flags [S.E], seq 1461289513, ack 2755998766, win 26844, options [mss 8960,nop,nop,TS val 672675082 ecr 2133096580], length 0
14:47:23.055929 IP SERVER.IP.39580 > AGENT.IP.4700: Flags [.], ack 1, win 65535, options [nop,nop,TS val 2133096580 ecr 672675082], length 0
14:47:23.055955 IP SERVER.IP.39580 > AGENT.IP.4700: Flags [P.], seq 1:17, ack 1, win 65535, options [nop,nop,TS val 2133096580 ecr 672675082], length 16
14:47:23.056061 IP AGENT.IP.4700 > SERVER.IP.39580: Flags [.], ack 17, win 26844, options [nop,nop,TS val 672675082 ecr 2133096580], length 0
14:47:23.056453 IP AGENT.IP.4700 > SERVER.IP.39580: Flags [P.], seq 1:17, ack 17, win 26844, options [nop,nop,TS val 672675083 ecr 2133096580], length 16
14:47:23.056571 IP SERVER.IP.39580 > AGENT.IP.4700: Flags [P.], seq 17:57, ack 17, win 65535, options [nop,nop,TS val 2133096581 ecr 672675083], length 40
14:47:23.057012 IP AGENT.IP.4700 > SERVER.IP.39580: Flags [P.], seq 17:49, ack 57, win 26844, options [nop,nop,TS val 672675083 ecr 2133096581], length 32
14:47:23.057133 IP SERVER.IP.39580 > AGENT.IP.4700: Flags [P.], seq 57:73, ack 49, win 65535, options [nop,nop,TS val 2133096581 ecr 672675083], length 16
14:47:23.300666 IP SERVER.IP.39580 > AGENT.IP.4700: Flags [P.], seq 57:73, ack 49, win 65535, options [nop,nop,TS val 2133096826 ecr 672675083], length 16
14:47:23.300782 IP AGENT.IP.4700 > SERVER.IP.39580: Flags [.], ack 73, win 26844, options [nop,nop,TS val 672675327 ecr 2133096826], length 0
14:47:28.058190 IP SERVER.IP.39580 > AGENT.IP.4700: Flags [F.], seq 73, ack 49, win 65535, options [nop,nop,TS val 2133101582 ecr 672675083], length 0
14:47:28.058562 IP AGENT.IP.4700 > SERVER.IP.39580: Flags [F.], seq 40929, ack 74, win 26844, options [nop,nop,TS val 672680085 ecr 2133101582], length 0
14:47:28.058584 IP SERVER.IP.39580 > AGENT.IP.4700: Flags [.], ack 49, win 65535, options [nop,nop,TS val 2133101583 ecr 672675083], length 0
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
# Time: 161205 12:13:27
# User@Host: netxms[netxms] @ [127.0.0.1]
# Query_time: 101.202518 Lock_time: 0.000060 Rows_sent: 30 Rows_examined: 6502043
use netxms;
SET timestamp=1480929207;
SELECT msg_timestamp,source_object_id,facility,severity,hostname,msg_tag,msg_text FROM syslog WHERE msg_id<=11313990 AND (source_object_id = 38025) ORDER BY msg_timestamp DESC LIMIT 1000;
mysql> EXPLAIN SELECT msg_timestamp,source_object_id,facility,severity,hostname,msg_tag,msg_text FROM syslog WHERE msg_id<=11313990 AND (source_object_id = 38025) ORDER BY msg_timestamp DESC LIMIT 1000;
+----+-------------+--------+-------+---------------+--------------------------+---------+------+------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+--------+-------+---------------+--------------------------+---------+------+------+-------------+
| 1 | SIMPLE | syslog | index | PRIMARY | idx_syslog_msg_timestamp | 4 | NULL | 2000 | Using where |
+----+-------------+--------+-------+---------------+--------------------------+---------+------+------+-------------+
1 row in set (0.00 sec)
Uptime: 87 days 15 hours 26 min 22 sec
Threads: 14 Questions: 3302913014 Slow queries: 504 Opens: 5677 Flush tables: 1 Open tables: 4130 Queries per second avg: 436.178
select count(*) from syslog;
+----------+
| count(*) |
+----------+
| 6502281 |
+----------+
1 row in set (2.01 sec)
mysql> set profiling=1;
Query OK, 0 rows affected (0.00 sec)
mysql> show profile for query 1;
+--------------------------------+-----------+
| Status | Duration |
+--------------------------------+-----------+
| starting | 0.000085 |
| Waiting for query cache lock | 0.000007 |
| checking query cache for query | 0.000074 |
| checking permissions | 0.000010 |
| Opening tables | 0.000029 |
| System lock | 0.000012 |
| Waiting for query cache lock | 0.000034 |
| init | 0.000035 |
| optimizing | 0.000019 |
| statistics | 0.000103 |
| preparing | 0.000047 |
| executing | 0.000008 |
| Sorting result | 0.000012 |
| Sending data | 19.243185 |
| end | 0.000030 |
| query end | 0.000012 |
| closing tables | 0.000011 |
| freeing items | 0.000024 |
| logging slow query | 0.000006 |
| logging slow query | 0.000097 |
| cleaning up | 0.000009 |
+--------------------------------+-----------+
21 rows in set (0.00 sec)
EXPLAIN SELECT msg_timestamp,source_object_id,facility,severity,hostname,msg_tag,msg_text FROM syslog WHERE msg_id<=9880640 AND (source_object_id = 29124) ORDER BY msg_timestamp DESC LIMIT 1000;
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: syslog
type: index
possible_keys: PRIMARY
key: idx_syslog_msg_timestamp
key_len: 4
ref: NULL
rows: 2000
Extra: Using where
1 row in set (0.00 sec)
show create table syslog;
+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| syslog | CREATE TABLE `syslog` (
`msg_id` bigint(20) NOT NULL,
`msg_timestamp` int(11) NOT NULL,
`facility` int(11) NOT NULL,
`severity` int(11) NOT NULL,
`source_object_id` int(11) NOT NULL,
`hostname` varchar(127) DEFAULT NULL,
`msg_tag` varchar(32) DEFAULT NULL,
`msg_text` text,
PRIMARY KEY (`msg_id`),
KEY `idx_syslog_msg_timestamp` (`msg_timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)
mysql> SELECT msg_timestamp,source_object_id,facility,severity,hostname,msg_tag,msg_text FROM syslog WHERE msg_id<=15375265 AND (source_object_id = 11102) ORDER BY msg_timestamp DESC LIMIT 1000;
1000 rows in set (23.48 sec)
CREATE INDEX idx_syslog_source ON syslog(source_object_id);
Query OK, 0 rows affected (43.65 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> SELECT msg_timestamp,source_object_id,facility,severity,hostname,msg_tag,msg_text FROM syslog WHERE msg_id<=15375265 AND (source_object_id = 11102) ORDER BY msg_timestamp DESC LIMIT 1000;
1000 rows in set (0.11 sec)
show index from syslog\G
1. row
Table: syslog
Non_unique: 0
Key_name: PRIMARY
Seq_in_index: 1
Column_name: msg_id
Collation: A
Cardinality: 7444594
Sub_part: NULL
Packed: NULL
Null:
Index_type: BTREE
Comment:
Index_comment:
2. row
Table: syslog
Non_unique: 1
Key_name: idx_syslog_msg_timestamp
Seq_in_index: 1
Column_name: msg_timestamp
Collation: A
Cardinality: 7444594
Sub_part: NULL
Packed: NULL
Null:
Index_type: BTREE
Comment:
Index_comment:
3. row
Table: syslog
Non_unique: 1
Key_name: idx_syslog_source
Seq_in_index: 1
Column_name: source_object_id
Collation: A
Cardinality: 200
Sub_part: NULL
Packed: NULL
Null:
Index_type: BTREE
Comment:
Index_comment:
3 rows in set (0.00 sec)
Quote from: Victor Kirhenshtein on January 16, 2017, 10:13:36 AM
Switch OID - value of .1.3.6.1.2.1.1.2.0. For example, on my H3C switch:
victor@hp8570w ~ $ /opt/netxms/bin/nxsnmpget 10.5.4.1 .1.3.6.1.2.1.1.2.0
.1.3.6.1.2.1.1.2.0 [OBJECT IDENTIFIER]: .1.3.6.1.4.1.43.1.16.4.3.83
Port layout - just specify how many rows and how numbering goes. Same H3C example:
2 rows, numbering down-up then left-right:
2 4 6 8 ...
1 3 5 7 ...
Best regards,
Victor
Quote from: Victor Kirhenshtein on January 14, 2017, 11:13:30 AM
When reporting devices, please specify it's SNMP OID and actual port layout - that will save us lot of time looking for that information.
Quote from: Tatjana Dubrovica on January 09, 2017, 04:00:12 PM
We have implemented option to have different switch port layouts on "Ports" tab (non default like down-to-up, right-to-left). For now we have changed port layout only for HP A-series (former H3C) as we have one. If you know other SNMP devices that have non standard port layout configuration please share. Will be happy to set correct configuration for them.