<div dir="ltr"><div>What kind of data do you need to report?</div><div><br></div><div>I usually do stuff like this using a python tool I wrote, called axlrows. Here is an example:</div><div><br></div><div>>>> gen = get_phones(name="SEP700B4F9C44B8")<br>>>> phones = get_phones(name="SEP700B4F9C44B8")<br>>>> for phone in phones:<br>        print(<a href="http://phone.name">phone.name</a>, ":", phone.description)<br>SEP700B4F9C44B8 : Hunter Fuller (Cisco 8851 SIP) - Home<br><br></div><div>It looks like to match "every" phone, you could write get_phones(protocol="SIP")</div><div><br></div><div>You can get the tool here, though it is admittedly poorly documented, so if you need assistance, let me know off-list.</div><div><br></div><div><a href="https://github.com/uah/axlrows">https://github.com/uah/axlrows</a></div><div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><br>--<br>Hunter Fuller (they)<br>Router Jockey<br>VBH Annex B-5<br>+1 256 824 5331<br><br>Office of Information Technology<br>The University of Alabama in Huntsville<br>Network Engineering</div></div></div></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Feb 18, 2021 at 12:47 PM Louis Koekemoer (MEA) <<a href="mailto:Louis.Koekemoer@dimensiondata.com">Louis.Koekemoer@dimensiondata.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">



<div style="overflow-wrap: break-word;" lang="EN-ZA"><p> </p><table style="padding-left:10px;color:rgb(68,68,68);line-height:22px" width="650px" cellspacing="0" cellpadding="0" border="0">


        <tbody>
            <tr>


                <td>


                    <div style="font-family:sans-serif;font-size:16px;width:1800px;line-height:25px">


                        <div class="gmail-m_4701664018681814705WordSection1">
<p class="MsoNormal"><span lang="EN-US">Hi,<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">I recently upgraded my CUCM clusters to CUCM 12.5su3. I hit a bit of an issue. 2 bugs. 1 on exporting all devices or all UDP, all details and 2 generating UDP reports or Phone reports. I need to do these on a weekly basis
 and I have 3 cluster with around 7000-1000 UDP per cluster and up to 33000 phones/devices per cluster. Now as per the below it breaks on around 700-800 devices. I logged a TAC case and this is what TAC identified. Firstly the customer is not happy with bleeding
 edge(Not released yet). I am not very clued up on API’s but is there possible a way I can either “export” all devices, all details via cli or with a API? I have a few more clusters to upgrade but all put on hold due to this.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">1. <a href="https://bst.cloudapps.cisco.com/bugsearch/bug/CSCvv67192" target="_blank">
https://bst.cloudapps.cisco.com/bugsearch/bug/CSCvv67192</a><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span lang="EN-US">Symptom:<u></u><u></u></span></b></p>
<p class="MsoNormal"><span lang="EN-US">Export of Bulk Phones Job , stays in "Processing" State and does not "Completes"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Export of Bulk UDP Job , stays in "Processing" State and does not "Completes"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span lang="EN-US">Conditions:<u></u><u></u></span></b></p>
<p class="MsoNormal"><span lang="EN-US">Export fails if it's more than 520 phone records through Phone -> Export Phone/UDP -> All Details<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span lang="EN-US">Workaround:<u></u><u></u></span></b></p>
<p class="MsoNormal"><span lang="EN-US">1. Export phones around 400 records through Phone -> Export Phone -> Specific Details<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">2. Export 800+ records through Import/Export -> Export operation.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span lang="EN-US">The known fixed version is CCM.12.5(1.14900.42) but is going to be released in late February.<u></u><u></u></span></b></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">2. <a href="https://bst.cloudapps.cisco.com/bugsearch/bug/CSCvw44625" target="_blank">
https://bst.cloudapps.cisco.com/bugsearch/bug/CSCvw44625</a><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span lang="EN-US">Symptom:<u></u><u></u></span></b></p>
<p class="MsoNormal"><span lang="EN-US">When customer submits bat job for (Bulk Administration --> Phones --> Generate Phone Reports) failed event can be observed from Job Scheduler page.
<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="background:yellow none repeat scroll 0% 0%" lang="EN-US">Issue started after upgrading to CUCM 12.5 SU3</span><span lang="EN-US"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span lang="EN-US">Conditions:<u></u><u></u></span></b></p>
<p class="MsoNormal"><span lang="EN-US">Generate Phone Report under Bulk Administration<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span lang="EN-US">Workaround:<u></u><u></u></span></b></p>
<p class="MsoNormal"><span lang="EN-US">While Generating the  Phone Report, <u></u>
<u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Bulk Administration --> Phones --> Generate Phone Reports  after selecting mandatory fields,<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">under IP Phone services fields two checkboxes are there for speed dial services and IP Phone services, if the user can checked those boxes and run the job Report will generate successfully<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> <u></u><u></u></span></p>
<p class="MsoNormal"><b><span lang="EN-US">The known fixed version is CCM.12.5(1.14900.42) but is going to be released in late February.<u></u><u></u></span></b></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
</div>


                    </div>




                </td>


            </tr>


        </tbody>
    </table>
 <p></p> <p>

            </p><table width="640" cellspacing="0" cellpadding="0" border="0" align="left">
                <tbody><tr>
                    <td style="width:109px" valign="top">
                        <table style="width:109px" width="109" cellspacing="0" cellpadding="0" border="0">
                            <tbody><tr>
                            <td valign="top" align="left">
                                <table cellspacing="0" cellpadding="0" border="0"><tbody><tr><td><img alt="ddlogo" src="cid:177b68014712c91aec2" border="0"></td></tr></tbody></table>
                            </td>
                            </tr>
                        </tbody></table>
                    </td>
                    <td colspan="2" style="width:353px;margin-top:0px;padding:0px" width="355" valign="top" align="left">
                        <table width="100%" cellspacing="0" cellpadding="0" border="0">
                            <tbody><tr>
                                <td colspan="2" style="width:353px;padding:0px 7px 0px 0px" valign="top">
                                    <span style="font-size:20px;color:rgb(146,208,80);font-weight:bold;line-height:1">
                                        Louis Koekemoer (MEA)
                                    </span>
                                </td>           
                            </tr>
                            <tr>
                                <td colspan="2" style="width:353px;padding:0px 7px 0px 0px" valign="top">
                                    <span style="font-size:12px;font-weight:bold;line-height:1">
                                        Engineer - IPT - L4
                                    </span>
                                </td>
                            </tr>
                            <tr>
                                <td style="font-size:16px;line-height:16px" height="16"> </td>
                            </tr>
                            <tr>
                                <td style="width:100px;padding:0px 7px 0px 0px" width="100">
                                    <span style="margin-bottom:0px;line-height:1">
                                        <b>
                                            <span style="font-size:12px">m. </span>
                                        </b>
                                        <span style="font-size:12px">
                                            +27 71 6808790
                                        </span>
                                    </span>
                                </td>
                                <td style="width:200px;padding:0px 7px 0px 0px" width="250">
                                    <span style="margin-bottom:0px;line-height:1">
                                        <b>
                                            <span style="font-size:12px">t.</span>
                                        </b>
                                        <span style="font-size:12px">
                                            +27 11 5754317
                                        </span>
                                    </span>
                                </td>
                            </tr>
                            <tr>
                                <td colspan="2" style="width:353px;padding:0px 7px 0px 0px" valign="top">
                                    <span style="margin-bottom:0px;line-height:1">
                                        <b>
                                            <span style="font-size:12px">email. </span>
                                        </b>
                                        <span style="font-size:12px;text-decoration:none;color:black">
                                            <a href="mailto:louis.koekemoer@dimensiondata.com" target="_blank">louis.koekemoer@dimensiondata.com</a>
                                        </span>
                                    </span>
                                </td>
                            </tr>
                            <tr>
                                <td style="font-size:16px;line-height:16px" height="16"> </td>
                            </tr>
                            <tr>
                                <td colspan="2" style="width:353px;padding:0px 7px 0px 0px">
                                    <span style="margin-bottom:0px;line-height:1">
                                        <b>
                                            <span style="font-size:12px"><a href="https://www.dimensiondata.com/" style="text-decoration:none;color:black" target="_blank">dimensiondata.com</a> </span>
                                        </b>
                                    </span>
                                </td>
                            </tr>
                          
                            <tr>
                                <td colspan="2">
                                    <table style="padding-top:5px" cellspacing="0" cellpadding="0" border="0">
                                        <tbody><tr>
                                            <td style="padding-right:4px">
                                                <span><a href="https://twitter.com/DiDataMEA" style="text-decoration:none;color:black" target="_blank"><table cellspacing="0" cellpadding="0" border="0"><tbody><tr><td><a href="https://twitter.com/DiDataMEA" target="_blank"><img alt="ddtwitter" src="cid:177b680148130162a86" border="0"></a></td></tr></tbody></table></a></span><a href="https://twitter.com/DiDataMEA" style="text-decoration:none;color:black" target="_blank">
                                            </a></td>
                                            <td style="padding-right:4px">
                                                <span><a href="https://www.linkedin.com/company/dimension-data-middle-east-and-africa" style="text-decoration:none;color:black" target="_blank"><table cellspacing="0" cellpadding="0" border="0"><tbody><tr><td><a href="https://www.linkedin.com/company/dimension-data-middle-east-and-africa" target="_blank"><img alt="ddlinkedin" src="cid:177b68014772e533a64" border="0"></a></td></tr></tbody></table></a></span><a href="https://www.linkedin.com/company/dimension-data-middle-east-and-africa" style="text-decoration:none;color:black" target="_blank">
                                            </a></td>
                                            <td style="padding-right:4px">
                                                <span><a href="https://www.facebook.com/DiDataMEA" style="text-decoration:none;color:black" target="_blank"><table cellspacing="0" cellpadding="0" border="0"><tbody><tr><td><a href="https://www.facebook.com/DiDataMEA" target="_blank"><img alt="ddfacebook" src="cid:177b680147f2f34b275" border="0"></a></td></tr></tbody></table></a></span><a href="https://www.facebook.com/DiDataMEA" style="text-decoration:none;color:black" target="_blank">
                                           </a></td>
<td style="padding-right:4px">
                                                <span><a href="https://www.instagram.com/_dimensiondata_/" style="text-decoration:none;color:black" target="_blank"><table cellspacing="0" cellpadding="0" border="0"><tbody><tr><td><a href="https://www.instagram.com/_dimensiondata_" target="_blank"><img alt="ddinstagram" src="cid:177b68014632bb036b1" border="0"></a></td></tr></tbody></table></a></span><a href="https://www.instagram.com/_dimensiondata_/" style="text-decoration:none;color:black" target="_blank">
                                              
                                        </a></td></tr>
                                    </tbody></table>
                                </td>
                            </tr>
                        </tbody></table>
                    </td>
                </tr>
 <tr>                                    <td style="font-size:3px;line-height:3px" height="3"> </td>                                </tr>
                         <tr>
                    <td colspan="2" style="width:350px;height:70px" width="350" valign="top" height="70">

                        <table width="100%" cellspacing="0" cellpadding="0" border="0">
                            <tbody>
                                <tr>
                                    <td valign="top" align="left">
                                    <table cellspacing="0" cellpadding="0" border="0"><tbody><tr><td><a href="https://www.dimensiondata.com" target="_blank"><img alt="Logo" src="cid:177b68014732d7326d3" border="0"></a></td></tr></tbody></table> <span style="color:rgb(255,255,255)">.</span>
                                    </td>
                                </tr>
                            </tbody>
                        </table>
                    </td> 
                 <td> <span style="color:rgb(255,255,255)">.</span></td> 
                </tr>    
        </tbody></table> <p></p><p>
</p><table style="width:100%;padding-left:10px;color:rgb(68,68,68);line-height:22px" width="900" cellspacing="0" cellpadding="0" border="0">


        <tbody>
            <tr>


                <td>


                    <div style="font-family:sans-serif;font-size:16px;width:1800px;line-height:25px">


                        


                    </div>




                </td>


            </tr>


        </tbody>
    </table> <p><font size="2px" face="arial" color="#000000">
This email and all contents are subject to the following disclaimer:<br>

<a href="https://www.dimensiondata.com/email-disclaimer" target="_blank">https://www.dimensiondata.com/email-disclaimer</a>

</font>
<font color="white"></font></p></div>
_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" rel="noreferrer" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
</blockquote></div>