CSV and XML File Production › CSV Record Types › The Data Record

The Data Record

The third record type is the Data record. Data records follow each time band record as the output is logically grouped. The data records contain replacement values for the elements named in the header record, followed by data values derived from EXTDATA record fields. There are 24 of these derived values, one for each hour of the day reported on, separated by commas. The following is an example of a CA NSM CSV PDS member. The lines are wrapped and separated by spaces for readability.

--------------------------------------------------------------------------------
"Machine Name","Resource, Type","Resource, Sub-type","Resource, Instance", "Date",,"Data ->"

"Time (HH:MM) ->",,,,,,00:00,01:00,02:00,03:00,04:00,05:00,06:00,07:00,08:00,09:00,10:00,11:00,12:00,13:00,14:00,15:00,16:00,17:00,18:00,19:00,20:00,21:00,22:00,23:00

"XAD1","XCF SYSTEM ACTIVITY","ACCUM MAX MSG BUFR SPACE (1K BLKS)","XAD1","02 April 2000","XCF SYSTEM
ACTIVITY->ACCUM MAX MSGBUFR SPACE (1K BLKS)",,,,,,,,,,,,,,,,,,,,,,,16000,32000

"XAD1","XCF SYSTEM ACTIVITY","ACCUM TRANSPORT CLASS MSG LENGTH","XAD1","02 April 2000","XCF SYSTEM
ACTIVITY->ACCUM TRANSPORT CLASS MSG LENGTH",,,,,,,,,,,,,,,,,,,,,,,16112,32224

"XAD1","XCF SYSTEM ACTIVITY","BIG MSGS EXCEEDING OPTIMUM LENGTH","XAD1","02 April 2000","XCF SYSTEM
ACTIVITY->BIG MSGS EXCEEDING OPTIMUM LENGTH",,,,,,,,,,,,,,,,,,,,,,,160,284

"XAD1","XCF SYSTEM ACTIVITY","MSGS - TOTAL","XAD1","02 April 2000","XCF SYSTEM ACTIVITY->MSGS - TOTAL"
,,,,,,,,,,,,,,,,,,,,,,,33336,65052

"XAD1","XCF SYSTEM ACTIVITY","MSGS FITTING DEFINED BUFFER","XAD1","02 April 2000","XCF SYSTEM ACTIVITY
->MSGS FITTING DEFINED BUFFER",,,,,,,,,,,,,,,,,,,,,,,632,1276

"XAD1","XCF SYSTEM ACTIVITY","MSGS LARGER THAN DEFINED BUFFER","XAD1","02 April 2000","XCF SYSTEM
ACTIVITY->MSGS LARGER THAN DEFINED BUFFER",,,,,,,,,,,,,,,,,,,,,,,208,334

"XAD1","XCF SYSTEM ACTIVITY","MSGS MIGRATED NO PATH","XAD1","02 April 2000","XCF SYSTEM ACTIVITY->
MSGS MIGRATED NO PATH",,,,,,,,,,,,,,,,,,,,,,,0,0

"XAD1","XCF SYSTEM ACTIVITY","MSGS PER SECOND REJECTED","XAD1","02 April 2000","XCF SYSTEM ACTIVITY
->MSGS PER SECOND REJECTED",,,,,,,,,,,,,,,,,,,,,,,0,0

"XAD1","XCF SYSTEM ACTIVITY","MSGS PER SECOND TOTAL","XAD1","02 April 2000","XCF SYSTEM ACTIVITY->MSGS
PER SECOND TOTAL",,,,,,,,,,,,,,,,,,,,,,,842.57904,1612.51753

"XAD1","XCF SYSTEM ACTIVITY","MSGS REJECTED","XAD1","02 April 2000","XCF SYSTEM ACTIVITY->MSGS REJECTED"
,,,,,,,,,,,,,,,,,,,,,,,0,0

"XAD1","XCF SYSTEM ACTIVITY","MSGS SMALLER THAN DEFINED BUFFER","XAD1","02 April 2000","XCF SYSTEM
ACTIVITY->MSGS SMALLER THAN DEFINED BUFFER",,,,,,,,,,,,,,,,,,,,,,,32496,63442

"XAD1","XCF SYSTEM ACTIVITY","PATHS IN SERVICE","XAD1","02 April 2000","XCF SYSTEM ACTIVITY->PATHS IN
SERVICE",,,,,,,,,,,,,,,,,,,,,,,12,24

Note: This CSV format is specific to CA NSM.