I'm trying to clean out are voicemail system and was wondering if there was a command I could issue in our Intuity Audix that will let me know when the last time someone tried to access there voicemail box. I would like to start deleting voicemail accounts of people who haven't accessed there voicemail boxes in the last 90 days.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Intuity Audix, anway of knowing when the mailbox was last accessed? 1
- Thread starter PhoneTeck
- Start date
montyzummer
IS-IT--Management
you could try li hi , works in asa not sure about Audix may give you a nudge in the right direction , on the other hand it mmay show nothing or a list of programming history ...anyway try and let me know i would be interested to know if this is possible too
APSS (SME)
ACSS (SME)
APSS (SME)
ACSS (SME)
- Thread starter
- #4
- Thread starter
- #6
The system is old and none of the suggestions are doing what I need to do. Basically I just need a command that's going to list all of the subscribers that haven't logged in, in the past 90 days to there voicemail boxes. None of the commands mentioned does that for me.
Oh well
Oh well
PhoneTeck, I don't believe there is a command in Audix that will give you a list of mailboxes that haven't been accessed in a while. I know you can do it in MM, but not Audix. I use all of the above for checking a few, but it sounds like you have more than a couple to check.
-
1
- #9
gabber4858
Technical User
I use this trick on LXs and MAP 40/100s.
1) Use ASA to to export a list of all the subscribers in Audix
a. This is done by using the Export Data function in ASA under Advanced (on the left)
i. Note: Select Audix, but do not log in.
ii. Select “Export Fields to File”
iii. Map it somewhere easy to find (like Documents)
2) Let Excel do the heavy lifting
a. Get the exported txt file into Excel (if export as tab, none, import it as tab none)
b. Use Concatenate to make entries for a batch run
i. =CONCATENATE("li meas sub mon ", A1," 01/12 ;") to get something that resembles list measurements subscriber month Extension 01/12;
ii. Apply this formula to the remaining subscribers
iii. Take the new entries and copy and paste them back in as “Text Only”
iv. Copy manageable amounts of the commands ( for 1k subscribers, you might need to do this in sections of 2 or 3) and use the Paste Special “Transpose” option to paste then into another Tab, or section of Excel.
v. Select this newly creates horizontal group and paste it into Notepad
vi. Copy it from Notepad and paste it into Word
vii. Use Find/Replace to Find all the “tab” spaces and replace with nothing (blank).
viii. Select all and paste back into Notepad (this makes it ASCII again)
3) Use ASA to run a “Report” (Under the Advanced tab just like before)
a. Make sure to “Export Fields to file”
b. Paste in the new “batch” (only run a couple hundred at a time)
4) Back to Excel
a. Import the results back into excel (Tab/None, or whatever you exported it as)
b. Sort by the first field and remove all the garbage
c. Resort by the Subscriber number (its now a few months of usage)
d. Sum the fields that indicate usage. You can use the Reports manual to ID these fields (Most likely going to be 2 groups 1 =SUM(E2:AM2) and 2= =SUM(AP2:CG2)
e. Sum the 2 Groups
f. Create a Pivot Table to get a MAX usage for all of the months (or import into a database and run a query)Zero = Damn Safe to remove
5) You now have a really good list to start with (use discretion on the accounts, don’t blow out a new hire or VP )
6) Use the same principal to “remove sub XXXX” and you will have a nice export to rebuild any mistakes
Test, Test, Test!!! Using a batch could be career ender if you’re not paying attention.
1) Use ASA to to export a list of all the subscribers in Audix
a. This is done by using the Export Data function in ASA under Advanced (on the left)
i. Note: Select Audix, but do not log in.
ii. Select “Export Fields to File”
iii. Map it somewhere easy to find (like Documents)
2) Let Excel do the heavy lifting
a. Get the exported txt file into Excel (if export as tab, none, import it as tab none)
b. Use Concatenate to make entries for a batch run
i. =CONCATENATE("li meas sub mon ", A1," 01/12 ;") to get something that resembles list measurements subscriber month Extension 01/12;
ii. Apply this formula to the remaining subscribers
iii. Take the new entries and copy and paste them back in as “Text Only”
iv. Copy manageable amounts of the commands ( for 1k subscribers, you might need to do this in sections of 2 or 3) and use the Paste Special “Transpose” option to paste then into another Tab, or section of Excel.
v. Select this newly creates horizontal group and paste it into Notepad
vi. Copy it from Notepad and paste it into Word
vii. Use Find/Replace to Find all the “tab” spaces and replace with nothing (blank).
viii. Select all and paste back into Notepad (this makes it ASCII again)
3) Use ASA to run a “Report” (Under the Advanced tab just like before)
a. Make sure to “Export Fields to file”
b. Paste in the new “batch” (only run a couple hundred at a time)
4) Back to Excel
a. Import the results back into excel (Tab/None, or whatever you exported it as)
b. Sort by the first field and remove all the garbage
c. Resort by the Subscriber number (its now a few months of usage)
d. Sum the fields that indicate usage. You can use the Reports manual to ID these fields (Most likely going to be 2 groups 1 =SUM(E2:AM2) and 2= =SUM(AP2:CG2)
e. Sum the 2 Groups
f. Create a Pivot Table to get a MAX usage for all of the months (or import into a database and run a query)Zero = Damn Safe to remove
5) You now have a really good list to start with (use discretion on the accounts, don’t blow out a new hire or VP )
6) Use the same principal to “remove sub XXXX” and you will have a nice export to rebuild any mistakes
Test, Test, Test!!! Using a batch could be career ender if you’re not paying attention.
- Thread starter
- #10
Gabber, this first part in your directions
ii. Select "Export Fields to File"
iii. Map it somewhere easy to find (like Documents
After export to file i click next and it says select the fields that you wish to export. What fields would I want to choose to be able to tell when a subscriber last logged into there voicemail box?
ii. Select "Export Fields to File"
iii. Map it somewhere easy to find (like Documents
After export to file i click next and it says select the fields that you wish to export. What fields would I want to choose to be able to tell when a subscriber last logged into there voicemail box?
gabber4858
Technical User
At this point, you are just getting a current list of all the subscribers in Audix. You really only need the extension number at this point. You will later use this information to create the list measure command for each subscriber in Audix. This is not a canned report.....but a series of work arounds. Let me know if you get stuck again.
- Thread starter
- #12
gabber4858
Technical User
Not bad, you need to put the formula in the B column (one formula for every extension) I'm at gm ail, you can email me the file and I will send it back. This does get pretty in depth, but after we are done.....you will have some powerful skills (import/export = huge time savings).
- Thread starter
- #14
- Thread starter
- #15
gabber4858
Technical User
Ok, new to adding files like this, but I made you some examples.
You can jump straight the the .txt file labeled Step 5 and copy a few to test. That would put you at Step 3 "Run a Report" from the above instructions.
Again, let me know if you get stuck
You can jump straight the the .txt file labeled Step 5 and copy a few to test. That would put you at Step 3 "Run a Report" from the above instructions.
Again, let me know if you get stuck
- Status
Similar threads
- Locked
- Question
- Locked
- Question