Fluke Computer Accessories Appendix 2 CSV File Format, Chart CSV format, Pie chart CSV format

Page 85

User’s Guide – version 3.5

NetFlow Tracker

Appendix 2: CSV File Format

Every standard chart and tabular report can be converted to comma-separated-value format for importing into a database server or spreadsheet.

Chart CSV format

Each section is separated by a row of “=” signs. The first section is the chart title; the second is the time range and filter.

Each subsequent section represents a single chart, equivalent to the tabs above the chart in interactive mode. The first line of the section is the name of the chart. The next two rows contain the start and end time of each sample in milliseconds UTC. Each has an empty column at the start to accommodate the description of each data row below. Each data row consists of a description followed by a usage, octet count or packet count for each sample.

Pie chart CSV format

Each section is separated by a row of “=” signs. The first section is the chart title; the second is the time range and filter.

Each subsequent section represents a single chart, equivalent to the tabs above the chart in interactive mode. The first line of the section is the name of the chart, followed by a row for each charted element consisting of a description followed by a usage, octet count or packet count.

Tabular report CSV format

Each section is separated by a row of “=” signs. The first section is the report title; the second is the time range and filter.

The third section starts with the title of each column, separated by a comma. Each subsequent line in the section is a row with each value separated by a comma, and text values contained within double quotes. There are several differences between a report viewed in a browser and one converted to CSV; in CSV format all rows are included, information normally available by hovering the mouse over a label is unavailable, and traffic and packets passed are output as simple counts rather than rates.

The fourth section contains column totals, again separated by commas. There will usually be empty values in the total row corresponding to non-numeric columns.

85

Image 85
Contents NetFlow Tracker Contents LONG-TERM Reports Appendix 2 CSV File Format Grant of Licence and Payment of Fees Software License AgreementCopyright Customer Remedies Confidential Information and Security User’s Guide version NetFlow Tracker Definitions Support Charges Support ServicesUndertakings by You Supplier’s UndertakingsIntellectual Property Rights Limitation of Liability and indemnityTermination Miscellaneous Confidential Information and SecuritySupport Hours Exceptions to Support ServicesResponse Times What is NetFlow Tracker? What is NetFlow?Features and Benefits IntroductionUser’s Guide version NetFlow Tracker Pre-installation Checks InstallationMinimum System Requirements Operating System SupportInstallation on Microsoft Windows Installation on Linux Post-installation Tasks Set up web front-end security Set up Snmp community stringsConfigure your routers and switches Add listener portsUsing NetFlow Tracker Interfaces Device traffic metersChanging the displayed chart Working with ChartsChart legend Per-AS dataView a standard chart as a tabular report View a standard chart as a pie chartZooming Zooming outExport a chart to another application Alter the filter applied to a standard chartPrint the chart Open the chart in a new windowWorking with Tabular Reports Working with Pie ChartsExamine a single row Sort a tabular reportAddress Reports Report TemplatesSession Reports Network Reports QoS ReportsInterface Reports Creating Filtered ReportsTraffic Identification Reports Other ReportsSample size Report templateSource data Start timeSource device Time zoneInterface Out interfaceSource port ProtocolDest port Src/dest portTraffic class DiffServSource AS Dest ASDevices and Interfaces Long-term ReportsPer-device and Per-interface Long-term Reports Filter EditorUser’s Guide version NetFlow Tracker Reports General Form Report URL FormatReport Format Parameters 0024 00230025 0026Pie ChartNumber TrueSections Features128 256Time Range Parameters Hour MillisDay WeekCalendar-based advanced Time range will extend for this number of unitsApplying a time-of-day mask to the time range HHmmDay1-day2/time1-time2 105 110100 113120 115140 125300 285Minute DailyFilter Parameters Addr1-addr2 NamePort1-port2 Port/number Port/namePort1-port2/name Port1-port2/numberTos PrecPrec%20tos CodeMask Addr/maskSecurity Parameters PasswordUsername Secret Management Portal Access Control ParametersNull VPN Out VPN Chart selection headers Chart scrollbarFilter Editor button, if applicable Refresh and Resolve All buttons, if applicableDatabase Server Settings Performance TuningDisk Speed Query SizeSnmp Settings Configuration GuideLicensing Listener PortsDevice Settings Device SettingsDevice List Sampled Data Scaling VPNs Security SettingsHttp//proxy/tracker1/report1 Management Portal SettingsHttp//tracker1/report.jsp?portalsecret=secret&aclif= Http//proxy/tracker1/report.jsp?portalacl=RewriteEngine On Using Apache as a Portal ServerRewriteRule /tracker1/.*$ http//1.2.3.4/$1 P,L,QSA ProxyPassReverse /tracker1/ http//1.2.3.4General Settings Report SettingsReal-time Reports Scheduled Reports Saved FiltersLong-term Reports Executive Reports Span class=repdesctextTest/span Content Nelements=5 and chartWidth=400Sub-reports User’s Guide version NetFlow Tracker IP Application Names Hostname Resolution SettingsDiffServ Names AS Names Database SettingsSubnet Names Backup Archiving Memory SettingsPerformance Counters Traffic Described NetFlow Data ReceivedIgnored Flows Unprocessed FlowsetsNo In Interface AboutEnabling Netflow Export on an IOS Device Appendix 1 Device ConfigurationIp cef Ip flow-export destination addressIp flow-cache timeout inactive Ip flow-cache timeout activeShow ip flow export Show ip cache flow Show ip cache verbose flowMls netflow Ip route-cache flow infer-fieldsMls nde sender version Mls aging longUser’s Guide version NetFlow Tracker Set mls nde enable Set mls bridged-flow-statistics enable vlanlistSet system name name Set mls nde addressEnabling Flow Detail Records on a Packeteer Device Flow-sampler-map allflows mode random one-out-of 1 exitEnabling NetFlow on an Enterasys Device Pie chart CSV format Chart CSV formatAppendix 2 CSV File Format Tabular report CSV formatPie chart XML format Chart XML formatAppendix 3 XML Format Tabular report XML formatAppendix 4 Third Party Software Components JspSmartUpload Quartz