Author Topic: Need to pull a report...  (Read 3036 times)

Offline evan631

  • Sr. Member
  • ****
  • Posts: 228
  • Karma: +1/-0
    • View Profile
Need to pull a report...
« on: December 09, 2013, 11:14:29 AM »
I need to pull a listing of all phones with certain COS.  What would the best way to do that?  Is there a command I can run, or would you just suggest I print out the COS form?

Thanks.


Offline jrg0852

  • Sr. Member
  • ****
  • Posts: 309
  • Country: us
  • Karma: +3/-0
  • Look out for the next tech. because it may be you!
    • View Profile
Re: Need to pull a report...
« Reply #1 on: December 09, 2013, 11:31:27 AM »
If you go to Users and Devices, Advanced Config., Station Attributes you can print, or export it and do what you need with it. Thanks.

Offline evan631

  • Sr. Member
  • ****
  • Posts: 228
  • Karma: +1/-0
    • View Profile
Re: Need to pull a report...
« Reply #2 on: December 09, 2013, 11:33:06 AM »
If you go to Users and Devices, Advanced Config., Station Attributes you can print, or export it and do what you need with it. Thanks.

That's exactly what I am looking for.

Thanks!!!

Offline petr.necas

  • Sr. Member
  • ****
  • Posts: 393
  • Country: cz
  • Karma: +8/-0
    • View Profile
Re: Need to pull a report...
« Reply #3 on: December 09, 2013, 11:54:44 AM »
I started working on a simple tool that would take backup file and extract the configuration data from and save is as a readable text of XML. Sometimes when I need to know what configuration has been done, e.g. which COS options have been changed to their default values it is really pain. Another use would be to be able to provide the customer some documentation with all the programing being done.

Offline ralph

  • Mitel Forums Admin
  • Hero Member
  • *****
  • Posts: 5767
  • Country: us
  • Karma: +469/-0
  • Published Author: http://amzn.to/2dcYSY5
    • View Profile
Re: Need to pull a report...
« Reply #4 on: December 09, 2013, 11:57:35 AM »
A
Quote
simple tool
?

That would be awesome!
I would be that creating a tool for that would be much more that "simple" though.


Ralph

Offline petr.necas

  • Sr. Member
  • ****
  • Posts: 393
  • Country: cz
  • Karma: +8/-0
    • View Profile
Re: Need to pull a report...
« Reply #5 on: December 09, 2013, 12:14:26 PM »
Hi Raplh, so far it just a set of python scripts doing the job I need, I may later create something more robust in C#. Attached is an example output of Class Of Service file showing all options that have been changed. As an input can serve an export file from the Class Of Services form or a COS_OPTIONS.xxx file extracted from the backup tar file.

<?xml version="1.0" encoding="UTF-8"?>
<mitel>
   <ClassofServiceOptions>
      <item>
         <ClassOfServiceNumber value="1"/>
         <Comment value="RAD port" default=""/>
         <DoNotDisturb value="No" default="Yes"/>
         <HotDeskLoginAccept value="No" default="Yes"/>
         <MessageWaiting value="No" default="Yes"/>
         <PublicNetworkAccessviaDPNSS value="Yes" default="No"/>
         <RecordedAnnouncementDevice value="Yes" default="No"/>
         <SMDRExternal value="Yes" default="No"/>
         <SMDRInternal value="Yes" default="No"/>
         <SuppressSimulatedCCMafterISDNProgress value="Yes" default="No"/>
         <AnswerPlusExpectedOffhookTimer value="121" default="30"/>
         <AnswerPlusMessageLengthTimer value="120" default="10"/>
      </item>
      <item>
         <ClassOfServiceNumber value="2"/>
         <Comment value="Mitel sets" default=""/>
         <ACDSilentMonitorAccept value="Yes" default="No"/>
         <ACDSilentMonitorAllowed value="Yes" default="No"/>
         <CallForwardingExternalDestination value="Yes" default="No"/>
         <DisplayANIISDNCallingNumberOnly value="Yes" default="No"/>
         <DisplayANIDNISISDNCallingCalledNumber value="Yes" default="No"/>
         <DisplayCallerIDonmulticallkeylines value="Yes" default="No"/>
         <DisplayDNISCalledNumberBeforeDigitModification value="Yes" default="No"/>
         <ExecutiveBusyOverride value="Yes" default="No"/>
         <HandsetVolumeAdjustmentSaved value="Yes" default="No"/>
         <NonPrimePublicNetworkIdentity value="Yes" default="No"/>
         <PublicNetworkAccessviaDPNSS value="Yes" default="No"/>
         <RecordACallActive value="Yes" default="No"/>
         <RecordACallSaveRecordingonHangup value="Yes" default="No"/>
         <RingingLineSelect value="Yes" default="No"/>
         <SMDRExternal value="Yes" default="No"/>
         <SMDRInternal value="Yes" default="No"/>
         <VoiceMailSoftkey value="Yes" default="No"/>
         <AfterAnswerDisplayTime value="5" default=""/>
         <GroupPresenceControl value="Yes" default="No"/>
         <GroupPresenceThirdPartyControl value="Yes" default="No"/>
      </item>
      <item>
         <ClassOfServiceNumber value="3"/>
         <Comment value="Hotdesk sets" default=""/>
         <BusyOverrideSecurity value="Yes" default="No"/>
         <CamponToneSecurity value="Yes" default="No"/>
         <DisplayCallerIDonmulticallkeylines value="Yes" default="No"/>
         <PublicNetworkAccessviaDPNSS value="Yes" default="No"/>
         <SMDRExternal value="Yes" default="No"/>
         <SMDRInternal value="Yes" default="No"/>
         <VoiceMailSoftkey value="Yes" default="No"/>
         <FaxCapable value="Yes" default="No"/>
      </item>
....

Petr

Offline ralph

  • Mitel Forums Admin
  • Hero Member
  • *****
  • Posts: 5767
  • Country: us
  • Karma: +469/-0
  • Published Author: http://amzn.to/2dcYSY5
    • View Profile
Re: Need to pull a report...
« Reply #6 on: December 09, 2013, 01:23:08 PM »
Is your tool creating the XML file or is that how it is in the tar file?

Ralph

Offline petr.necas

  • Sr. Member
  • ****
  • Posts: 393
  • Country: cz
  • Karma: +8/-0
    • View Profile
Re: Need to pull a report...
« Reply #7 on: December 10, 2013, 04:59:56 AM »
Hi Ralph, the tool is creating the XML from the data in the tar file or from the exported CSV files from ICP 3300. It can either generate XML files will all the data or just with the changed data to their default values. If you send me a backup tar file (MCD 5.0+) I will send you back the XML files.
Petr

Offline PC77375

  • Full Member
  • ***
  • Posts: 191
  • Country: us
  • Karma: +6/-0
    • View Profile
Re: Need to pull a report...
« Reply #8 on: November 06, 2015, 12:05:36 PM »
IS this tool available? I need to extract form data from backups....Ugly SDS ARS issue around the globe.

Thanks!!


 

Sitemap 1 2 3 4 5 6 7 8 9 10