76 IBM Tivoli Netcool Service Quality Manager Data Mediation Gateway Development
A sample Motorola GGSN CSV file
Example A-1 lists a sample Motorola GGSN CSV file.
Example: A-1 Sample GGSN raw data
systemName,systemIPAddress,index,day,startTime,endTime,cgprsAccPtActive
Pdps,cgprsAccPtDestAddrViolTpdus,cgprsAccPtDhcpAddrReleases,cgprsAccPtD
hcpAddrRequests,cgprsAccPtDownstreamPacketCount,cgprsAccPtGgsnDeactivat
edPdps,cgprsAccPtIpv6DownstreamPackets,cgprsAccPtIpv6DownstreamTrafficV
olume,cgprsAccPtIpv6GgsnDeactivatedPdps,cgprsAccPtIpv6GgsnSuccDeactivat
edPdps,cgprsAccPtIpv6MsActivatedDynPdps,cgprsAccPtIpv6MsActivatedPdps,c
gprsAccPtIpv6MsDeactivatedPdps,cgprsAccPtIpv6MsSuccActivatedDynPdps,cgp
rsAccPtIpv6MsSuccActivatedPdps,cgprsAccPtIpv6MsSuccDeactivatedPdps,cgpr
sAccPtIpv6NetworkInitDeactPdps,cgprsAccPtIpv6NetworkInitDeactSuccPdps,c
gprsAccPtIpv6UpstreamPackets,cgprsAccPtIpv6UpstreamTrafficVolume,cgprsA
ccPtMsActivatedDynPdps,cgprsAccPtMsActivatedPdps,cgprsAccPtMsDeactivate
dPdps,cgprsAccPtNetworkInitPdps,cgprsAccPtRedirInterMobilTraffic,cgprsA
ccPtRevDownstrTrafficVol,cgprsAccPtRevUpstreamTrafficVol,cgprsAccPtSour
ceAddrViolTpdus,cgprsAccPtSuccDhcpAddrRequests,cgprsAccPtSuccGgsDeactiv
atedPdps,cgprsAccPtSuccMsActivatedDynPdps,cgprsAccPtSuccMsActivatedPdps
,cgprsAccPtSuccMsDeactivatedPdps,cgprsAccPtSuccNetworkInitPdps,cgprsAcc
PtUpstreamPacketCount
gs1-ggsn-3,212.47.101.248,3,07Oct2008,56420,57320,1826,0,0,0,5268959,14
7,,,,,,,,,,,,,,,762,762,636,0,0,4543225140,703822395,4012,0,148,763,763
,635,0,4923866
gs1-ggsn-3,212.47.101.248,1000,07Oct2008,56420,57320,0,0,0,0,0,0,,,,,,,
,,,,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
gs1-ggsn-3,212.47.101.248,46,07Oct2008,56420,57320,0,0,0,0,0,0,,,,,,,,,
,,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
gs1-ggsn-3,212.47.101.248,1,07Oct2008,56420,57320,0,0,0,0,0,0,,,,,,,,,,
,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
gs1-ggsn-3,212.47.101.248,253,07Oct2008,56420,57320,66,0,0,0,63526,9,,,
,,,,,,,,,,,,34,34,31,0,0,39535903,15369164,0,0,9,35,35,31,0,93194
Sample first level PIF data file
A sample first level PIF is shown in Example A-2 on page 77.