<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)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@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;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
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;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Arial","sans-serif";
color:navy;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</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 lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='color:#1F497D'>Sean – That worked great,
thank you! I can write up a simple php function to convert everything…
Any idea what the rest of the OID might reveal?<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>SNMPv2-SMI::enterprises.2352.2.27.1.1.1.1.3.<span
style='background:yellow;mso-highlight:yellow'>4.116.101.115.116</span>.<span
style='background:aqua;mso-highlight:aqua'>25.48.50.48.50.48.48.51.70.54.56.48.48.51.57.50.48.45.52.66.69.52.50.56.66.56</span>
= STRING: "3/3:1 vpi-vci 18 37 pppoe 37"<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Username: <span
style='background:yellow;mso-highlight:yellow'>test</span><o:p></o:p></span></p>
<p class=MsoNormal><span style='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"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Sean Maguire
[mailto:smaguire@talktalkplc.com] <br>
<b>Sent:</b> Friday, May 07, 2010 2:51 AM<br>
<b>To:</b> Brent; redback-nsp@puck.nether.net<br>
<b>Subject:</b> RE: [rbak-nsp] SNMP Session list - SE400<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Hi Brent,<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>From memory, the PPP username, along with the length, is encoded as
part of the OID when you walk the SUBSCRIBER-ACTIVE MIB. For example, if you
walk the OID tree that you mentioned and you have a user
“fred@example.com”, the OID returned would be:<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>SNMPv2-SMI::enterprises.2352.2.27.1.1.1.1.3.16.102.114.101.100.64.101.120.97.109.112.108.101.46.99.111.109<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>The 16 is the length of the username, followed by the decimal ASCII
code of all the characters in the username. It’s pretty trivial to write
a Perl script to convert usernames and OIDs into each other.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Regarding the MAC addresses for each user, you might be able to
find them somewhere in ifTable, which has an entry for all subscribers
connected to the device since these are regarded as circuits. I would have
guessed that, if the value was present, it would have been returned in
ifPhysAddress (1.3.6.1.2.1.2.2.1.6) but a quick walk on one of our devices
seems to show that this value is blank in most cases, so you might be out of
luck.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Regards,<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Sean<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><span
style='font-size:12.0pt;font-family:"Times New Roman","serif"'>
<hr size=2 width="100%" align=center>
</span></div>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
redback-nsp-bounces@puck.nether.net
[mailto:redback-nsp-bounces@puck.nether.net] <b>On Behalf Of </b>Brent<br>
<b>Sent:</b> 06 May 2010 16:28<br>
<b>To:</b> redback-nsp@puck.nether.net<br>
<b>Subject:</b> [rbak-nsp] SNMP Session list - SE400</span><span
style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
</div>
<p class=MsoNormal><span lang=EN-GB><o:p> </o:p></span></p>
<p class=MsoNormal>Does anyone know if it’s possible to get useful
session information (like ppp username, or mac address) for all active sessions
via snmp? I can get this: 4/3 vlan-id 2020 pppoe 17168 using this OID:
SNMPv2-SMI::enterprises.2352.2.27.1.1.1.1.3.3…. but I can’t really
extrapolate anything externally from that.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Thanks,<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Brent<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<pre><span lang=EN-GB><o:p> </o:p></span></pre><pre><span lang=EN-GB>##############################################################################<o:p></o:p></span></pre><pre><span
lang=EN-GB>This communication together with any attachments transmitted with it<o:p></o:p></span></pre><pre><span
lang=EN-GB>("this E-Mail") is intended only for the use of the addressee and may contain<o:p></o:p></span></pre><pre><span
lang=EN-GB>information which is privileged and confidential. If the reader of this E-Mail<o:p></o:p></span></pre><pre><span
lang=EN-GB>is not the intended recipient or the employee or agent responsible for<o:p></o:p></span></pre><pre><span
lang=EN-GB>delivering it to the intended recipient you are hereby notified that any use,<o:p></o:p></span></pre><pre><span
lang=EN-GB>dissemination, forwarding, printing or copying of this E-Mail is strictly<o:p></o:p></span></pre><pre><span
lang=EN-GB>prohibited. Addressees should check this E-mail for viruses. The Company makes<o:p></o:p></span></pre><pre><span
lang=EN-GB>no representations as regards the absence of viruses in this E-Mail. If you<o:p></o:p></span></pre><pre><span
lang=EN-GB>have received this E-Mail in error please notify our IT Service Desk<o:p></o:p></span></pre><pre><span
lang=EN-GB>immediately by e-mail at abuse@opaltelecom.co.uk Please then immediately<o:p></o:p></span></pre><pre><span
lang=EN-GB>delete, erase or otherwise destroy this E-Mail and any copies of it.<o:p></o:p></span></pre><pre><span
lang=EN-GB><o:p> </o:p></span></pre><pre><span lang=EN-GB>Any opinions expressed in this E-Mail are those of the author and do not<o:p></o:p></span></pre><pre><span
lang=EN-GB>necessarily constitute the views of the Company. Nothing in this E-Mail shall<o:p></o:p></span></pre><pre><span
lang=EN-GB>bind the Company in any contract or obligation.<o:p></o:p></span></pre><pre><span
lang=EN-GB><o:p> </o:p></span></pre><pre><span lang=EN-GB>For the purposes of this E-Mail "the Company" means TalkTalk Telecom Group PLC<o:p></o:p></span></pre><pre><span
lang=EN-GB>and/or any of its subsidiaries.<o:p></o:p></span></pre><pre><span
lang=EN-GB><o:p> </o:p></span></pre><pre><span lang=EN-GB>Please feel free to visit our website: www.talktalkgroup.com <o:p></o:p></span></pre><pre><span
lang=EN-GB><o:p> </o:p></span></pre><pre><span lang=EN-GB>TalkTalk Telecom Group Plc (Registered in England & Wales No. 7105891)<o:p></o:p></span></pre><pre><span
lang=EN-GB>11 Evesham Street, London W11 4AR<o:p></o:p></span></pre><pre><span
lang=EN-GB>##############################################################################<o:p></o:p></span></pre></div>
</body>
</html>