|
|
This appendix contains supplemental information about the TrafficDirector NSTREND_DB database, the statistics contained in each database table, and information on how TrafficDirector daemons work to retrieve and process the information you request when you generate reports.
When using reporting features, keep in mind that queries you submit to the database can span multiple agents and domains. The following eight types of report tables are available.
Each report table type can be classified into one or more of the following categories:
| Protocol | Contains media-independent domain (protocol) statistics common to all LAN and WAN types. Tables include packets and bytes only. |
| Segment | Contains media-specific segment statistics for Ethernet and Fast Ethernet, Token Ring, FDDI, and WAN. If you are using RMON2 probes, this table is useful for the remote monitoring (RMON) domain. |
| Host | Contains basic host statistics. |
| Conversations | Contains basic conversation statistics. |
| Round Trip Delay | Contains IP ping statistics. |
You can look at any of the preceding report tables for the following types of content.
For a complete list of the statistics that are logged in each database table, see the "Database Table Schemata" section.
Table B-1 lists all the tables in the database, a brief description, and the maximum row size.
| Table | Contents | Number of Bytes per Row |
|---|---|---|
| protocol_snap | Media-independent protocol statistics snapshots | 125 |
| protocol_detail | Media-independent protocol statistics details | 165 |
| protocol_summary | Media-independent protocol daily statistics | 165 |
| seg_et_snap | Ethernet segment statistics snapshots | 260 |
| seg_et_detail | Ethernet segment statistics details | 280 |
| set_et_summary | Ethernet segment daily statistics | 280 |
| seg_wan_snap | WAN segment statistics snapshots | 260 |
| seg_wan_detail | WAN segment statistics details | 280 |
| seg_wan_summary | WAN segment daily statistics | 280 |
| seg_fddi_snap | FDDI segment statistics snapshots | 260 |
| seg_fddi_detail | FDDI segment statistics details | 280 |
| seg_fddi_summary | FDDI segment daily statistics | 280 |
| seg_tr_snap | Token Ring segment statistics snapshots | 449 |
| seg_tr_detail | Token Ring segment statistics details | 469 |
| seg_tr_summary | Token Ring segment daily statistics | 469 |
| host_snap | Host statistics snapshots | 205 |
| host_detail | Host statistics details | 225 |
| host_summary | Host statistics daily statistics | 225 |
| conv_snap | Conversation statistics snapshots | 181 |
| conv_detail | Conversation statistics details | 201 |
| conv_summary | Conversation daily statistics | 201 |
| ip_ping_snap | Round Trip Delay statistics snapshots | 125 |
| ipping_detail | Round Trip Delay statistics details | 145 |
| ip_ping_summary | Round Trip Delay daily statistics | 145 |
Daemons are processes that run in the background and are disconnected from a process group and terminal. TrafficDirector uses specific daemons to create and update tables in the report database. Daemons work with related configuration files that rule how and when they are called to perform their roles. The following daemons work with the SQL database and Trend Reporter.:
| Snapshot daemon | Called dbsnapd, this daemon gets snapshots of raw statistics from agents and stores this information in a snapshot table. |
| Extraction daemon | Called dbextrad, this daemon gets information from the snapshot table, creates new rows in the details table, and deletes the oldest member of each pair of snapshot rows. |
| Rollup and aging daemon | Called dbrolld, this daemon performs two separate but related actions; it gets information from the details table to create new rows in the summary table, and deletes obsolete information from both the detail and summary tables. |
| SQL server daemon | Called msqld, this daemon listens for and processes SQL queries. |
The snapshot daemon, dbsnapd, gathers data from one or more probes and creates logs based on the intervals specified in the dbsnap.cfg configuration file. The snapshot daemon creates rows in snapshot tables, rather than individual log files. Snapshot rows are raw data that are temporarily stored until the dbextrad daemon clears out the snapshot area.
The ASCII configuration file, dbsnap.cfg, contains information that controls how the Snapshot daemon works. This file contains the agent/domain combinations you want to log, as well as the snapshot intervals that the daemon uses to gather raw data. You enable logging by installing a properties file on one or more agents that contains the logging intervals you want. When you install the properties file on the agent, logging information is automatically written to the dbsnap.cfg file.
The smallest selectable interval is one minute (although you can specify a different interval, depending on your needs). For example, you might want to use the one hour interval when you want to log protocol and segment statistics.
The Snapshot daemon reads the dbsnap.cfg file at the start of every defined interval, so that any changes to the file are effective for the next logging interval. For example, if you specify 04:00 as a logging interval, the daemon takes snapshots of data at midnight, 4 a.m., 8 a.m., 12 noon, and so on. Logging intervals you can specify in the dbsnap.cfg file are as follows:
Each line in the dbsnap.cfg file contains an agent name, domain name, and interval to log for protocol, segment, host, and conversation information. The sample below is similar to the contents of your dbsnap.cfg file.
#AgentDomainProtocolSegmentHostConversation wan105RMON00:0500:0500:3024:00 wan105IP00:05-02:0024:00 et132RMON00:0501:0002:0008:00 et132IP00:05-02:0004:00
Using the example above, for agent et132 and domain IP, TrafficDirector would log conversation statistics starting at midnight, and again at 4:00 a.m., 8:00 a.m., 12:00 p.m. (noon), 4:00 p.m., and 8:00 p.m. This means that every four hours (04:00), TrafficDirector takes a snapshot of the conversation statistics for agent et132.
The Extraction daemon, dbextrad, "follows" the Snapshot daemon, and creates entries in the detail tables derived from the snapshot pairs in snapshot tables. Whenever the Extraction daemon uses a pair of rows in the snapshot table, it also deletes the older of the two rows, since that snapshot information is no longer needed.
The Extraction daemon ignores snapshots taken more than 24 hours apart. After the Extraction daemon goes through a snapshot table, it deletes snapshots older than 48 hours; this is especially useful to delete snapshots for agent/domain combinations that no longer have logging enabled.
The ASCII configuration file, dbupdate.cfg, contains information that controls how the Extraction and Rollup & Aging daemons work. In this file are parameters you can customize as necessary. Remember, you cannot delete any of the tables in the database (they are permanent), but you can specify that old rows of information are deleted at specific intervals.
In the dbupdate.cfg file, you will find one line of information and parameters (shown in number of days) for each type of table (protocol, segment, host, and conversation). Also in the file are minimum utilization thresholds for the host and conversation tables only. The sample below is similar to the contents of your dbupdate.cfg file.
#Detail AgingSummary Aging Protocol:31366 Segment:31366 Host: 7 31 Conversation: 7 31 # #Minimum utilization percentage for inclusion in #host and conversation detail/summary tables HostThreshold:0.010
In this configuration file, there are only four types of parameters you can modify as follows:
| Detail Aging | This interval shows the number of days that information can age before the Rollup & Aging daemon deletes it from the details table. Using the example above, for a host details table, information is allowed to age for seven days and then it is deleted from that table. You must specify a value greater than 1 for any of the detail aging parameter values. |
| Daily Aging | This interval shows the number of days that information can age before the Rollup & Aging daemon deletes it from the summary table. Using the example above, for a protocol summary table, information is allowed to age for 366 days and then it is deleted from that table. You must specify a value greater than 1 for any of the daily aging parameter values. |
| HostThreshold | This number shows the minimum utilization percentage that a host (combined inbound and outbound) must meet before it is included in the host details or summary tables. This means that the Extraction daemon compares a host segment utilization percentage to this number and creates a row in the host details table only if the utilization percentage meets or exceeds this value. This is a useful feature that lets you save disk space by saving only certain information that meets the percentage you select. |
| Conversation Threshold | This number shows the minimum source-to- destination utilization percentage that a conversation must meet before it is included in the conversation details or summary tables. This means that the Extraction daemon compares a conversation source-to-destination utilization percentage to this number and creates a row in the conversation details table only if the utilization percentage meets or exceeds this value. This is a useful feature that lets you save disk space by saving only certain information that meets the percentage you select. |
The Rollup & Aging daemon, dbrolld, "wakes up" daily at 1:45 a.m. (the default setting). Once it is awake, it uses information in the details tables to create entries in the daily tables for the previous day. For example, if you have defined hourly protocol logging for the agent named et132 for domain TCP, the Rollup & Aging daemon looks at all 24 rows in the protocol detail table for agent et132 and domain TCP, summarizes the information into one row, and puts this summary row in the protocol daily table. The daemon does not delete the 24 rows in the protocol detail table at this point.
Once the Rollup & Aging daemon has looked through all the details tables, and extracted the information to put into the daily tables, it performs an "aging pass". This aging pass is when the daemon goes through both details and daily tables looking for old information that has aged past the limits set in the dbupdate.cfg file. When the Rollup & Aging daemon finds information that is aged past the limits, it deletes it.
The SQL server daemon, msqld, is really a server process that acts like, but is not technically a daemon (although for ease of use, we call it that in this book). When you start TrafficDirector, this wakes up the Snapshot daemon, which then wakes up the SQL server daemon.
The SQL server daemon job is basically to listen for SQL or database administration queries by using either a TCP/IP or a UNIX socket. The other action-oriented daemons (Snapshot, Extraction, and Rollup & Aging) are now able to connect to the database through the socket that the SQL server daemon uses.
All of the Trend Reporter true daemons (Snapshot, Extraction, and Rollup & Aging) record their activities by putting this information into log files. Control files are special files that contain code for the "keep alive" mechanism that helps TrafficDirector ensure that exactly one copy of each daemon is running at a given time.
We recommend that you occasionally check these log files to ensure that they are functioning correctly. To do so, use the tail-f Unix command. In the event that a daemon fails to perform an action, a daemon event message is generated and the Alert Monitor icon starts flashing to notify you. Table B-2 lists log files and the daemons that generate them.
| Daemon | Associated Logfile | Associated Control file |
|---|---|---|
| dbsnapd | dbsnap.log | dbsnap.ctl |
| dbextrad | dbextra.log | dbextra.ctl |
| dbrolld | dbroll.log | No control file is created |
Table schemata used in the database are included here. Tables in this section include:
| Field | Type | Description |
|---|---|---|
| Agent | char(26) | Agent name. |
| Domain | char(15) | Domain name. |
| TargetSnapTime | int | Target snapshot time. The actual snapshot may be taken after the target time. |
| TargetSnapTimeText | char(15) | Target snapshot time (text format). |
| ActualSnapTime | int | Actual snapshot time. |
| InstallTime | int | RMON table installation time (or 0 if unavailable). Used to detect domain re-installation. |
| IfSpeed | int | Agent interface speed in bits per second. |
| NetType | char(4) | Agent network type: ET, TR, FDDI, or WAN. |
| SysUpTime | int | Agent SysUpTime at time of snapshot; used to detect domain re-installation. |
| DomainId | int | Domain index. Used to detect domain re-installation. |
| Filler1 | int | Reserved for future use. |
| Octets | real | Value of octets counter at snaphot time. |
| Pkts | real | Value of packets counter at snaphot time |
| Filler2 | real | Reserved for future use. |
| Filler3 | real | Reserved for future use. |
| Field | Type | Description |
|---|---|---|
| Agent | char(26) | Agent name. |
| Domain | char(15) | Domain name. |
| TargetSnapTime | int | Target snapshot time. The actual snapshot may be taken after the target time. |
| TargetSnapTimeText | char(15) | Target snapshot time (text format). |
| ActualSnapTime | int | Actual snapshot time. |
| InstallTime | int | RMON table installation time (or 0 if unavailable). Used to detect domain re-installation. |
| IfSpeed | int | Agent interface speed in bits per second. |
| NetType | char(4) | Agent network type: ET, TR, FDDI, or WAN. |
| SysUpTime | int | Agent SysUpTime at time of snapshot; used to detect domain re-installation. |
| DomainId | int | Domain index. Used to detect domain re-installation. |
| Filler1 | int | Reserved for future use. |
| DropEvents | real | Drop events. This and remaining fields are absolute values of corresponding RMON counters at the time of the snapshot. |
| Octets | real | |
| Pkts | real | |
| BroadcastPkts | real | |
| MulticastPkts | real | |
| CRCErrors | real | |
| UndersizePkts | real | |
| OversizePkts | real | |
| Fragments | real | |
| Jabbers | real | |
| Collisions | real | |
| Pkts64 | real | |
| Pkts65to127 | real | |
| Pkts128to255 | real | |
| Pkts256to511 | real | |
| Pkts512to1023 | real | |
| Pkts1024to1518 | real | |
| Filler2 | real | Reserved for future use. |
| Filler3 | real | Reserved for future use. |
| Field | Type | Description |
|---|---|---|
| Agent | char(26) | Agent name. |
| Domain | char(15) | Domain name. |
| TargetSnapTime | int | Target snapshot time. The actual snapshot may be taken after the target time. |
| TargetSnapTimeText | char(15) | Target snapshot time (text format). |
| ActualSnapTime | int | Actual snapshot time. |
| InstallTime | int | RMON table installation time (or 0 if unavailable). Used to detect domain re-installation. |
| IfSpeed | int | Agent interface speed in bits per second. |
| NetType | char(4) | Agent network type: ET, TR, FDDI, or WAN. |
| SysUpTime | int | Agent SysUpTime at time of snapshot; used to detect domain re-installation. |
| DomainId | int | Domain index. Used to detect domain re-installation. |
| Filler1 | int | Reserved for future use. |
| DropEvents | real | Drop events. This and remaining fields are absolute values of corresponding RMON counters at the time of the snapshot. |
| Octets | real | |
| Pkts | real | |
| BroadcastPkts | real | |
| MulticastPkts | real | |
| CRCErrors | real | |
| Discards | real | |
| Aborts | real | |
| Congestions | real | |
| PktsLessThan64 | real | |
| Pkts64 | real | |
| Pkts65to127 | real | |
| Pkts128to255 | real | |
| Pkts256to511 | real | |
| Pkts512to1023 | real | |
| Pkts1024to1518 | real | |
| PktsGreaterThan1518 | real | |
| Filler2 | real | Reserved for future use. |
| Filler3 | real | Reserved for future use. |
| Field | Type | Description |
|---|---|---|
| Agent | char(26) | Agent name. |
| Domain | char(15) | Domain name. |
| TargetSnapTime | int | Target snapshot time. The actual snapshot may be taken after the target time. |
| TargetSnapTimeText | char(15) | Target snapshot time (text format). |
| ActualSnapTime | int | Actual snapshot time. |
| InstallTime | int | RMON table installation time (or 0 if unavailable). Used to detect domain re-installation. |
| IfSpeed | int | Agent interface speed in bits per second. |
| NetType | char(4) | Agent network type: ET, TR, FDDI, or WAN. |
| SysUpTime | int | Agent SysUpTime at time of snapshot; used to detect domain re-installation. |
| DomainId | int | Domain index. Used to detect domain re-installation. |
| Filler1 | int | Reserved for future use. |
| DropEvents | real | Drop events. This and remaining fields are absolute values of corresponding RMON counters at the time of the snapshot. |
| Octets | real | |
| Pkts | real | |
| BroadcastPkts | real | |
| MulticastPkts | real | |
| CRCAlignErrors | real | |
| PktsLessThan64 | real | |
| PktsGreaterThan1518 | real | |
| SmtFrames | real | |
| AverageTRT | real | |
| Tokens | real | |
| Pkts64 | real | |
| Pkts65to127 | real | |
| Pkts128to255 | real | |
| Pkts256to511 | real | |
| Pkts512to1023 | real | |
| Pkts1024to1518 | real | |
| Filler2 | real | Reserved for future use. |
| Filler3 | real | Reserved for future use. |
| Field | Type | Description |
|---|---|---|
| Agent | char(26) | Agent name. |
| Domain | char(15) | Domain name. |
| TargetSnapTime | int | Target snapshot time. The actual snapshot may be taken after the target time. |
| TargetSnapTimeText | char(15) | Target snapshot time (text format). |
| ActualSnapTime | int | Actual snapshot time. |
| InstallTime | int | RMON table installation time (or 0 if unavailable). Used to detect domain re-installation. |
| IfSpeed | int | Agent interface speed in bits per second. |
| NetType | char(4) | Agent network type: ET, TR, FDDI, or WAN. |
| SysUpTime | int | Agent SysUpTime at time of snapshot; used to detect domain re-installation. |
| DomainId | int | Domain index. Used to detect domain re-installation. |
| Filler1 | int | Reserved for future use. |
| MacDropEvents | real | (These are the MAC-layer statistics.) |
| MacOctets | real | |
| MacPkts | real | |
| PurgeEvents | real | |
| PurgePkts | real | |
| BeaconEvents | real | |
| BeaconTime | real | |
| BeaconPkts | real | |
| ClaimTokenEvents | real | |
| ClaimTokenPkts | real | |
| NAUNChanges | real | |
| LineErrors | real | |
| InternalErrors | real | |
| BurstErrors | real | |
| ACErrors | real | |
| AbortErrors | real | |
| LostFrameErrors | real | |
| CongestionErrors | real | |
| FrameCopiedErrors | real | |
| FrequencyErrors | real | |
| TokenErrors | real | |
| SoftErrorReports | real | |
| RingPollEvents | real | |
| DropEvents | real | (These are the promiscuous statistics.) |
| Octets | real | |
| Pkts | real | |
| DataBroadcastPkts | real | |
| DataMulticastPkts | real | |
| Pkts18to63 | real | |
| Pkts64to127 | real | |
| Pkts128to255 | real | |
| Pkts256to511 | real | |
| Pkts512to1023 | real | |
| Pkts1024to2047 | real | |
| Pkts2048to4095 | real | |
| Pkts4096to8191 | real | |
| Pkts8192to1800 | real | |
| PktsGreaterThan18K | real | |
| Filler2 | real | |
| Filler3 | real |
| Field | Type | Description |
|---|---|---|
| Agent | char(26) | Agent name. |
| Domain | char(15) | Domain name. |
| TargetSnapTime | int | Target snapshot time. The actual snapshot may be taken after the target time. |
| TargetSnapTimeText | char(15) | Target snapshot time (text format). |
| ActualSnapTime | int | Actual snapshot time. |
| InstallTime | int | RMON table installation time (or 0 if unavailable). Used to detect domain re-installation. |
| IfSpeed | int | Agent interface speed in bits per second. |
| NetType | char(4) | Agent network type: ET, TR, FDDI, or WAN. |
| SysUpTime | int | Agent SysUpTime at time of snapshot; used to detect domain re-installation. |
| DomainId | int | Domain index. Used to detect domain re-installation. |
| Filler1 | int | Reserved for future use. |
| AddressType | char(4) | Host address type. |
| Address | char(20) | Host address, hex-ASCII format. |
| InPkts | real | Packets in. This and remaining fields are absolute values of corresponding RMON counters at the time of the snapshot. |
| OutPkts | real | Packets out. |
| InOctets | real | Octets in. |
| OutOctets | real | Octets out. |
| OutErrors | real | Errors out. |
| OutBroadcastPkts | real | Broadcast packets out. |
| OutMulticastPkts | real | Multicast packets out. |
| OutNonUcastPkts | real | Non-unicast packets out. |
| Filler2 | real | Reserved for future use. |
| Filler3 | real | Reserved for future use. |
| Field | Type | Description |
|---|---|---|
| Agent | char(26) | Agent name. |
| Domain | char(15) | Domain name. |
| TargetSnapTime | int | Target snapshot time. The actual snapshot may be taken after the target time. |
| TargetSnapTimeText | char(15) | Target snapshot time (text format). |
| ActualSnapTime | int | Actual snapshot time. |
| InstallTime | int | RMON table installation time (or 0 if unavailable). Used to detect domain re-installation. |
| IfSpeed | int | Agent interface speed in bits per second. |
| NetType | char(4) | Agent network type: ET, TR, FDDI, or WAN. |
| SysUpTime | int | Agent SysUpTime at time of snapshot; used to detect domain re-installation. |
| DomainId | int | Domain index. Used to detect domain re-installation. |
| Filler1 | int | Reserved for future use. |
| AddressType | char(4) | Host address type. |
| SrcAddress | char(20) | Source host address, hex-ASCII format. |
| DstAddress | char(20) | Destination host address, hex-ASCII format. |
| Pkts | real | Packets source host to destination host. This and remaining fields are absolute values of corresponding RMON counters at the time of the snapshot. |
| Octets | real | Octets source host to destination host. |
| Errors | real | Errors source host to destination host. |
| Filler2 | real | Reserved for future use. |
| Filler3 | real | Reserved for future use. |
| Field | Type | Description |
|---|---|---|
| Agent | char(26) | Agent name. |
| Domain | char(15) | Domain name. |
| StartTime | int | Start time. |
| EndTime | int | End time. |
| StartTimeText | char(15) | Start time (text format). |
| EndTimeText | char(15) | End time (text format). |
| Duration | int | Actual duration of interval in seconds. |
| IfSpeed | int | Agent interface speed in bits per second. |
| NetType | char(4) | Agent network type: ET, TR, FDDI, or WAN. |
| Reinstalled | int | Reinstalled flag, non-zero if reinstalled. |
| Filler1 | int | Reserved for future use. |
| Utilization | real | Average segment utilization for the time interval. |
| Octets | real | |
| Pkts | real | |
| Filler2 | real | Reserved for future use. |
| Filler3 | real | Reserved for future use. |
| Field | Type | Description |
|---|---|---|
| Agent | char(26) | Agent name. |
| Domain | char(15) | Domain name. |
| StartTime | int | Start time. |
| EndTime | int | End time. |
| StartTimeText | char(15) | Start time (text format). |
| EndTimeText | char(15) | End time (text format). |
| Duration | int | Actual duration of interval in seconds. |
| IfSpeed | int | Agent interface speed in bits per second. |
| NetType | char(4) | Agent network type: ET, TR, FDDI, or WAN. |
| Reinstalled | int | Reinstalled flag, non-zero if reinstalled. |
| Filler1 | int | Reserved for future use. |
| Utilization | real | Average segment utilization for the time interval. |
| DropEvents | real | This and remaining fields are the "delta" values for corresponding RMON counters during the interval. |
| Octets | real | |
| Pkts | real | |
| BroadcastPkts | real | |
| MulticastPkts | real | |
| CRCAlignErrors | real | |
| UndersizePkts | real | |
| OversizePkts | real | |
| Fragments | real | |
| Jabbers | real | |
| Collisions | real | |
| Pkts64 | real | |
| Pkts65to127 | real | |
| Pkts128to255 | real | |
| Pkts256to511 | real | |
| Pkts512to1023 | real | |
| Pkts1024to1518 | real | |
| Filler2 | real | Reserved for future use. |
| Filler3 | real | Reserved for future use. |
| Field | Type | Description |
|---|---|---|
| Agent | char(26) | Agent name. |
| Domain | char(15) | Domain name. |
| StartTime | int | Start time. |
| EndTime | int | End time. |
| StartTimeText | char(15) | Start time (text format). |
| EndTimeText | char(15) | End time (text format). |
| Duration | int | Actual duration of interval in seconds. |
| IfSpeed | int | Agent interface speed in bits per second. |
| NetType | char(4) | Agent network type: ET, TR, FDDI, or WAN. |
| Reinstalled | int | Reinstalled flag, non-zero if reinstalled. |
| Filler1 | int | Reserved for future use. |
| Utilization | real | Average segment utilization for the time interval. |
| DropEvents | real | This and remaining fields are the "delta" values for corresponding RMON counters during the interval. |
| Octets | real | |
| Pkts | real | |
| BroadcastPkts | real | |
| MulticastPkts | real | |
| CRCErrors | real | |
| Discards | real | |
| Aborts | real | |
| Congestions | real | |
| PktsLessThan64 | real | |
| Pkts64 | real | |
| Pkts65to127 | real | |
| Pkts128to255 | real | |
| Pkts256to511 | real | |
| Pkts512to1023 | real | |
| Pkts1024to1518 | real | |
| PktsGreaterThan1518 | real | |
| Filler2 | real | Reserved for future use. |
| Filler3 | real | Reserved for future use. |
| Field | Type | Description |
|---|---|---|
| Agent | char(26) | Agent name. |
| Domain | char(15) | Domain name. |
| StartTime | int | Start time. |
| EndTime | int | End time. |
| StartTimeText | char(15) | Start time (text format). |
| EndTimeText | char(15) | End time (text format). |
| Duration | int | Actual duration of interval in seconds. |
| IfSpeed | int | Agent interface speed in bits per second. |
| NetType | char(4) | Agent network type: ET, TR, FDDI, or WAN. |
| Reinstalled | int | Reinstalled flag, non-zero if reinstalled. |
| Filler1 | int | Reserved for future use. |
| Utilization | real | Average segment utilization for the time interval. |
| DropEvents | real | This and remaining fields are the "delta" values for corresponding RMON counters during the interval. |
| Octets | real | |
| Pkts | real | |
| BroadcastPkts | real | |
| MulticastPkts | real | |
| CRCErrors | real | |
| SMTPkts | real | |
| AverageTRT | real | |
| TokenPkts | real | |
| PktsLessThan64 | real | |
| Pkts64Octets | real | |
| Pkts65to127 | real | |
| Pkts128to255 | real | |
| Pkts256to511 | real | |
| Pkts512to1023 | real | |
| Pkts1024to1518Octets | real | |
| PktsGreaterThan1518 | real | |
| Filler2 | real | Reserved for future use. |
| Filler3 | real | Reserved for future use. |
| Field | Type | Description |
|---|---|---|
| Agent | char(26) | Agent name. |
| Domain | char(15) | Domain name. |
| StartTime | int | Start time. |
| EndTime | int | End time. |
| StartTimeText | char(15) | Start time (text format). |
| EndTimeText | char(15) | End time (text format). |
| Duration | int | Actual duration of interval in seconds. |
| IfSpeed | int | Agent interface speed in bits per second. |
| NetType | char(4) | Agent network type: ET, TR, FDDI, or WAN. |
| Reinstalled | int | Reinstalled flag, non-zero if reinstalled. |
| Duration | int | Actual duration of interval in seconds. |
| Filler1 | int | Reserved for future use. |
| Utilization | real | Average segment utilization for the time interval. |
| MacDropEvents | real | (These are the MAC-layer statistics.) |
| MacOctets | real | |
| MacPkts | real | |
| PurgeEvents | real | |
| PurgePkts | real | |
| BeaconEvents | real | |
| BeaconTime | real | |
| BeaconPkts | real | |
| ClaimTokenEvents | real | |
| ClaimTokenPkts | real | |
| NAUNChanges | real | |
| LineErrors | real | |
| InternalErrors | real | |
| BurstErrors | real | |
| ACErrors | real | |
| AbortErrors | real | |
| LostFrameErrors | real | |
| CongestionErrors | real | |
| FrameCopiedErrors | real | |
| FrequencyErrors | real | |
| TokenErrors | real | |
| SoftErrorReports | real | |
| RingPollEvents | real | |
| DropEvents | real | (These are the promiscuous statistics.) |
| Octets | real | |
| Pkts | real | |
| DataBroadcastPkts | real | |
| DataMulticastPkts | real | |
| Pkts18to63 | real | |
| Pkts64to127 | real | |
| Pkts128to255 | real | |
| Pkts256to511 | real | |
| Pkts512to1023 | real | |
| Pkts1024to2047 | real | |
| Pkts2048to4095 | real | |
| Pkts4096to8191 | real | |
| Pkts8192to1800 | real | |
| PktsGreaterThan18K | real | |
| Filler2 | real | |
| Filler3 | real |
| Field | Type | Description |
|---|---|---|
| Agent | char(26) | Agent name. |
| Domain | char(15) | Domain name. |
| StartTime | int | Start time. |
| EndTime | int | End time. |
| StartTimeText | char(15) | Start time (text format). |
| EndTimeText | char(15) | End time (text format). |
| IfSpeed | int | Agent interface speed in bits per second. |
| NetType | char(4) | Agent network type: ET, TR, FDDI, or WAN. |
| Reinstalled | int | Reinstalled flag, non-zero if reinstalled. |
| Duration | int | Actual duration of interval in seconds. |
| Filler1 | int | Reserved for future use. |
| AddressType | char(4) | Host address type. |
| Address | char(20) | Host address, hex-ASCII format. |
| InUtilization | real | Average inbound utilization for time interval. |
| OutUtilization | real | Average outbound utilization for time interval. |
| InPkts | real | Packets in. |
| OutPkts | real | Packets out. |
| InOctets | real | Octets in. |
| OutOctets | real | Octets out. |
| OutErrors | real | Errors out. |
| OutBroadcastPkts | real | Broadcast packets out. |
| OutMulticastPkts | real | Multicast packets out. |
| Filler2 | real | Reserved for future use. |
| Filler3 | real | Reserved for future use. |
| Field | Type | Description |
|---|---|---|
| Agent | char(26) | Agent name. |
| Domain | char(15) | Domain name. |
| StartTime | int | Start time. |
| EndTime | int | End time. |
| StartTimeText | char(15) | Start time (text format). |
| EndTimeText | char(15) | End time (text format). |
| IfSpeed | int | Agent interface speed in bits per second. |
| NetType | char(4) | Agent network type: ET, TR, FDDI, or WAN. |
| Reinstalled | int | Reinstalled flag, non-zero if reinstalled. |
| Duration | int | Actual duration of interval in seconds. |
| Filler1 | int | Reserved for future use. |
| AddressType | char(4) | Host address type. |
| SrcAddress | char(20) | Source host address, hex-ASCII format. |
| DstAddress | char(20) | Destination host address, hex-ASCII format. |
| Utilization | real | Average utilization for time interval, source host to destination host. |
| Pkts | real | Packets source host to destination host. |
| Octets | real | Octets source host to destination host. |
| Errors | real | Errors source host to destination host. |
| Filler2 | real | Reserved for future use. |
| Filler3 | real | Reserved for future use. |
To run reports from the command line using the nsreport command, you must specify the agent, domain, period (start and end time) and report type that you want to run. You can also specify optional parameters such as output, database, format, and any additional configuration files or report files that contain specify parameters that you want to apply.
Parameters you must specify are as follows:
-agent agent-name [agent-name...] | @agent-group-name -switch switch-name | switch-name port-name [port-name...] -framerelay framerelay-agentname framerelay-agentname dlci-name [dlci-name...] -domain domain-name [domain-name...] -period 9701070800 9701080000 //YYMMDDHHMM -interval00:01 | 00:05 | 00:15 | 00:30 |01:00 | 02:00 | 04:00 | 04:00 | 24:00 -type segment-summary-et segment-summary-tr segment-summary-wan segment-summary-fddi segement-history-et segment-history-tr segment-history-wan segment-history-fddi conversation-summary conversation-history host-summary host-history vlan-usage dlci-usage router-backbone-usage multi-segment-history-mix multi-segment-summary-et (Specify any one stat) multi-segment-summary-tr (Specify any one stat) multi-segment-summary-wan (Specify any one stat) multi-segement-summary-fddi (Specify any one stat) network-availabililty-summary (%Network Link Down/one segment) network-availability-history (%Network Link Down/one segment) network-response-time (Average Round Trip Delay) wan-usage protocol-usage (ASCII format only) protocol-distribution (ASCII format only) host-verbose (ASCII format only) host-outbound (ASCII format only) billing (ASCII format only) Optional Parameters: -output[screen | [[print | file | appendfile | mail] name] ] -databasedetail | summary -format[plot | bar | sbar | pie | tabular | csv | tsv ] -cfg[filename | *.rt | *.rd | *.rr ] -titleoptional-title (Overrides the default report title) -header1optional-header1 -header2optional-header2 -footeroptional-footer -toptopN-value -sortstat-id -treedomain-tree-file (If other than domtree.inf) -departmentdepartment-file (Optional) -tarifftariff-file (Default equals $0.01 per kilobyte) -lpplines-per-page -statstat-id (Determines which stat is displayed in the first graph. Only on multi-segment-history/summary reports.)
|
|