<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Or, using a bit more set theory - <div><br></div><div>* get mac address table and cdp neighbor data from every switch</div><div>* if a port has a phone AND that port has 2 learned mac addresses then the attached phone has a device connected to the access port.</div><div><br></div><div>Alternatively, check the status of the access port on the phone web page.</div><div><br></div><div>-wes</div><div><br><div><div>On Apr 9, 2013, at 6:18 PM, Stephen Welsh <<a href="mailto:stephen.welsh@unifiedfx.com">stephen.welsh@unifiedfx.com</a>> wrote:</div><br class="Apple-interchange-newline">
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">
<div>Hi Wes,</div>
<div><br>
</div>
<div>Yes, out of the 'box' PhoneView queries the "network" page on all IP Phones in a cluster(s) so the 99% scenarios is covered. If there are a number of PC's with Cisco software installed that broadcast CDP data then we could easily extend PhoneView to also
gather the CDP data from the "access" page too.</div>
<div><br>
</div>
<div>Based on Jonathan's original question if it's just MAC addresses per port then a SNMP table query on each access switch to get the phone's mac address and all devices connected behind it:</div>
<div><br>
</div>
<div><a href="https://supportforums.cisco.com/thread/2106563">https://supportforums.cisco.com/thread/2106563</a></div>
<div><br>
</div>
<div>Alternatively a favourite switch feature of mine (if available) is 'ip device tracking':</div>
<div><br>
</div>
<div><a href="http://www.cisco.com/en/US/docs/switches/lan/catalyst3560/software/release/12.2_55_se/command/reference/cli1.html#wpmkr13241721">http://www.cisco.com/en/US/docs/switches/lan/catalyst3560/software/release/12.2_55_se/command/reference/cli1.html#wpmkr13241721</a></div>
<div><br>
</div>
<div>Thanks</div>
<div><br>
</div>
<div>Stephen Welsh</div>
<div>
<div style="font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; ">
CTO</div>
<br class="Apple-interchange-newline" style="font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; ">
<span><image003.png></span>
</div>
<br>
<div>
<div>On 9 Apr 2013, at 18:59, Wes Sisk <<a href="mailto:wsisk@cisco.com">wsisk@cisco.com</a>></div>
<div> wrote:</div>
<br class="Apple-interchange-newline">
<blockquote type="cite">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">
CDP is *generally* only going to come from the switch. The "network" and "access" web pages from the phone show the connection status of the respective ethernet interfaces on the phone. Does UnifiedFX have access to this information via any existing vehicle?
<div><br>
</div>
<div>-wes</div>
<div><br>
<div>
<div>On Apr 8, 2013, at 3:16 PM, Stephen Welsh <<a href="mailto:stephen.welsh@unifiedfx.com">stephen.welsh@unifiedfx.com</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div>
<div style="word-wrap:break-word">Hi Jonathan,
<div><br>
</div>
<div>As some others have stated you can get details about device connectivity using CDP, this is either from each switch using command line or SNMP. Alternatively you can query the IP Phone(s) web-server.</div>
<div><br>
</div>
<div>When querying the IP Phone web-server the following URL gets the switch port details:</div>
<div><br>
</div>
<div><a href="http://[Phone">http://[Phone</a> IP]/PortInformationX?port=0</div>
<div><br>
</div>
<div>An extract of the XML response includes the following:</div>
<div><br>
</div>
<div>
<div class="x_line" style="font-family:monospace; font-size:13px"><span class="x_webkit-html-tag"><CDPNeighborDeviceId></span><span class="x_text">UFXB2SW1</span><span class="x_webkit-html-tag"></CDPNeighborDeviceId></span></div>
<div class="x_line" style="font-family:monospace; font-size:13px"><span class="x_webkit-html-tag"><CDPNeighborIP></span><span class="x_text">10.1.25.254</span><span class="x_webkit-html-tag"></CDPNeighborIP></span></div>
<div class="x_line" style="font-family:monospace; font-size:13px"><span class="x_webkit-html-tag"><CDPNeighborIPv6/></span></div>
<div class="x_line" style="font-family:monospace; font-size:13px"><span class="x_webkit-html-tag"><CDPNeighborPort></span><span class="x_text">GigabitEthernet0/6</span><span class="x_webkit-html-tag"></CDPNeighborPort></span></div>
</div>
<div><br>
</div>
<div>In-fact you can actually get CDP data for the PC Port too:</div>
<div><br>
</div>
<div><a href="http://[Phone">http://[Phone</a> IP]/PortInformationX?port=1</div>
<div><br>
</div>
<div>Note: Technically if you have a Cisco product installed on your PC's like VT Advantage or IP Communicator, the PC will advertise CDP to the phone, so it may be possible to gather some PC related information too ;)<br>
</div>
<div><br>
</div>
<div>In order to gather and collate all this data it can be a bit of a challenge, happy to discuss the technicalities in more detail if you are looking to pull this together yourself.</div>
<div><br>
</div>
<div>Because gathering asset and inventory data is a common requirements there are multiple 3rd Party products/tools that can do this, obviously each have their pros\cons (i.e. limited phone model support, single purpose tool etc.) so you probably have some
research to do ;)</div>
<div><br>
</div>
<div>In terms of UnifiedFX we have a product called <b>PhoneView</b> the most advanced endpoint management product available that can do literally anything with one, many or all your phones remotely, a bold claim but we are happy to stand by it ;)</div>
<div><br>
</div>
<div>In your case one of the features is gathering and exporting a whole range of phone/user data from CUCM/Phones (including CDP data), I've attached a small sample spreadsheet to give you an idea of some of the information available. We value customer feedback,
if there is anything not in there that we can obtain through our existing interactions we will happily add it in.</div>
<div><br>
</div>
<div>You can download PhoneView for Free, it's limited to 50 Phones but has most of the features enabled, if you need to try on more than 50 phones you can request a trial here:</div>
<div><br>
</div>
<div><a href="http://www.unifiedfx.com/phoneview/trial">http://www.unifiedfx.com/phoneview/trial</a></div>
<div><br>
</div>
<div>We are working hard on some more unique features and additional free functionality in our next release (3.1), if you register on our website you'll be notified with the details when it's ready.</div>
<div><br>
</div>
<div>Kind Regards.</div>
<div><br>
<div>
<div style="font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; ">
Stephen Welsh, CCIE #12345</div>
<div style="font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; ">
CTO</div>
<div><a href="http://www.unifiedfx.com/">http://www.unifiedfx.com</a></div>
<br class="x_Apple-interchange-newline" style="font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; ">
<span></span></div>
</div>
</div>
<div><span><image003.png></span> </div>
<div style="word-wrap:break-word">
<div>
<div><span></span></div>
<div><br>
</div>
<div><br>
</div>
<div></div>
</div>
</div>
<div style="word-wrap:break-word">
<div>
<div></div>
<br>
<div>
<div>On 8 Apr 2013, at 16:50, "Madziarczyk, Jonathan" <<a href="mailto:jmad@cityofevanston.org">jmad@cityofevanston.org</a>></div>
<div> wrote:</div>
<br class="x_Apple-interchange-newline">
<blockquote type="cite">
<div lang="EN-US" style="font-family:Helvetica; font-size:medium; font-style:normal; font-variant:normal; font-weight:normal; letter-spacing:normal; line-height:normal; orphans:2; text-indent:0px; text-transform:none; white-space:normal; widows:2; word-spacing:0px">
<div class="x_WordSection1" style="">
<div style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
I’m trying to do a rough inventory of PCs/network devices on one of our sites, I can easily see which ports are in use on my switches (show ip interface brief). However a number of those devices are 7900 series phones, and I’m looking for an easy way to find
out if they have PCs connected to them. </div>
<div style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
</div>
<div style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
And if possible, there’s a couple of phones that have switches connected to the PC port and I’d like to see how many devices (mac addresses) are behind those phones too.</div>
<div style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
</div>
<div style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
Suggestions?</div>
<div style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
</div>
<div style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
</div>
</div>
_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net" style="color:purple; text-decoration:underline">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" style="color:purple; text-decoration:underline">https://puck.nether.net/mailman/listinfo/cisco-voip</a></div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
<span><PhoneViewData_Sample.xlsx></span>_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
</div>
<br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</div><br></div></body></html>