Methods for Display and Format of CSV File Contents
The HDR collector transmits data to a CSV file in standard format. Each file is formatted as <Unix timestamp>.csv (for example, 1302041977.csv). Within the file, each record also has an associated record timestamp. The filename timestamp is the time that the CSV file was create. The record timestamp is the window of time that the HDR collector used to collect the data. For more information on windows of time, see Windows of Time.
When the HDR collector has created a CSV file, you can open the file in any of the following ways:
- using the UNIX command cat <timestamp>.csv at the UNIX root prompt (displays raw data)
- using the Microsoft command type <timestamp>.csv at a Microsoft® Windows DOS command prompt (displays raw data)
- using a rendering agent application (such as a Microsoft® application)
The following examples show each of these methods.
Example 1 - Using the UNIX Command
The following shows the use of the cat <timestamp>.csv UNIX command to display the contents of a system group CSV file in raw data format.
[AcmePacket]$ cat 1302041977.csv TimeStamp,CPU Utilization,Memory Utilization,Health Score,Redundancy State,Signaling Sessions, Signaling Rate (CPS),CAM Utilization (NAT), CAM Utilization (ARP),I2C Bus State,License Capacity, Current Cached SIP Local Contact Registrations, Current MGCP Public Endpoint Gateway Registrations, Current H323 Number of Registrations, Application Load Rate 1302041977,39,22,50,active,0,0,0,0,online,0,0,0,0,39 1302042037,100,22,50,active,0,0,0,0,online,0,0,0,0,100
Example 2 - Using the DOS Command
The following shows the use of the type <timestamp>.csv Microsoft® Windows DOS command to display the contents of a sip-sessions group CSV file in raw data format.
C:\AcmePacket> type 1301702284.csv Timestamp,Sessions,Sessions Initial, Sessions Early,Sessions Established,Sessions Terminated,Dialogs,Dialogs Early, Dialogs Confirmed,Dialogs Terminated 1301702288,45,45,28,35,10,35,35,35,0 1301702456,35,35,21,35,0,0,0,0,0
Example 3 - Using a Rendering Agent
The following shows the use of a rendering agent (a Microsoft application) to display the contents of a sip-sessions group CSV file in table format.
Timestamp Sessions Sessions Initial Sessions Early ... 130170228 45 45 28 ... 1301702456 35 35 35 ...
The formats in the examples above pertain to all of the HDR groups specified in HDR Groups and Group Statistics, except the sip-invite Group. For information on the sip-invite HDR data format in the CSV file, see the next section.
