<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body bgcolor=white lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Interesting – thanks… I’ll definitely have to check that out…<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Paul<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'> dhcp-users-bounces+paul=paulstewart.org@lists.isc.org [mailto:dhcp-users-bounces+paul=paulstewart.org@lists.isc.org] <b>On Behalf Of </b>Tom Martinson<br><b>Sent:</b> Wednesday, January 19, 2011 12:18 PM<br><b>To:</b> dhcp-users@lists.isc.org<br><b>Subject:</b> Re: Tracking GB Usage<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='font-size:10.0pt'>IPDR was developed for just this use case. <br><br>In the basic DOCSIS IPDR implimentation (all CMTSs have to do IPDR to pass cable labs, and your Cisco and Arris both do theses) the following is the information that is tied together. All you have to do is set the CMTS to export IPDR records and then setup a server to collect them. <br><br>Tom.<br><br>CMTShostName Name of the CMTS CMTSipAddress IP Address of the CMTS <br>CMTSsysUpTime SysUpTime taken from the CMTS <br>CMTScatvIfName CATV interface name from the Interfaces Group <br>CMTScatvIfIndex CATV interface index <br>CMTSupIfName Upstream interface name <br>CMTSupIfType Upstream interface type<br>CMTSdownIfName Downstream interface name <br>CMmacAddress The MAC address of the Cable Modem<br>CMdocsisMode The registration mode for this modem (1.0, 1.1 or 2.0)<br>CMipAddress The IP address of the Cable Modem<br>CMCPEipAddress List of IP address assigned to CPE’s behind the Cable Modem<br>Rectype Interim indicating that the Service Flow is still running. Stop indicating that it has completed<br>RecCreationTime UTC time of record creation<br>serviceIdenifier Service Flow ID or DOCSIS 1.0 SID<br>GateID GateID for PacketCable initiated service flows <br>serviceClassName Service Class Names applied to the service flow by the CMTS if implemented<br>serviceDirection Upstream or Downstream<br>serviceOctetsPassed Current or final count of octets passed by this service flow (usage counting)<br>servicePktsPassed Current or final count of packets passed by this service flow<br>serviceSlaDropPkts Number of packets dropped by the CMTS when enforcing a QoS SLA<br>serviceSlaDelayPkts Number of packets delayed by the CMTS when enforcing a QoS SLA<br>serviceTimeCreated The CMTS sysUpTime when the service was created</span><br><br><br><br>On 01/19/2011 11:59 AM, Simon Hobson wrote: <o:p></o:p></p><p class=MsoNormal>Paul Stewart wrote: <br><br><br><o:p></o:p></p><p class=MsoNormal>I should have elaborated a bit more though - if we used flow data as an example we would need a way to "bind" the cable modem MAC to the usage..? <o:p></o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'><br>Monitor log files to pick up changes/assignments ? <br>Add "on <something>" events to your DHCP config to update an external table ? <br><br>Once you've extracted information from DCHP to relate devices/addresses/users then it's left as an exercise for you to then capture traffic flows. If they are your own cable modems, then potentially you could just use SNMP to capture interface counters. <o:p></o:p></p></div></body></html>