NuPoint Call Directory Call Flow Reports - Automated

[ralph]

There's a very useful report in the NuPoint under Call Directory -->Reports-->View Call Flow Reports

My boss would like to see these reports daily.
The problem is, I have to reset the report the Call Flow Report daily in order to see the details for a single day.

Does anyone know of a way to automatically run the report daily, email it and then reset it?

Ralph

[ZuluAlpha]

That would be really nice. I have some contact centers that get hit after the Call Directors so MiCC doesn't report on anything before the calls get there.

[BoiseBorn]

Enjoy this ability to while you can. Mitel has moved the Nupoint call tree into the latest version of MiVB and renamed it VM Call Flow Administration (This form is available only for cMIVB, EX Controller, MiVoice Business Virtual, and MiVoice Business for ISS).

There is no option that I've found to produce the same report from the MiVB. On the plus side if they do add the ability you could probably figure out a way to use the scheduler to produce the report...maybe.

[lundah]

I don't know of any way to do this. Call Flow reporting has always been limited at best, not sure why Mitel never made any improvements to it. My current gig uses the OpenText/AVST CX-E platform which is also sold as MiCollab Advanced Messaging, and the reporting capabilities of that is light years ahead.

[johnp]

Not sure about getting the report emailed, but in theory you could use chown to run a delete file for the stats at midnight and when another call comes in, the file I believe is recreated. These are in /usr/vm/val5/CallFlows/xxxx_yyyy_stats.xml where xxxx... represents the flow desired. It might also make sense to use this file instead of the report. One could at 11:59 have an automated download of it via a sftp client, just prior to reset.

[ralph]

Oooo....   I like that.
Perhaps a crontab to copy the file to another directory, change the file name to the current date and then email.

I'll have to play with that a bit.

Thank you, John!

Ralph

[ralph]

I'm playing with it now.
I deleted the file to see if it resets overnight.

JohnP, after some internal discussions we another question though, would it be possible to connect to the database directly?
Do we know what database it's using?  i.e. Postgres, MySQL, etc?

Ralph

[lundah]

Not sure about getting the report emailed, but in theory you could use chown to run a delete file for the stats at midnight and when another call comes in, the file I believe is recreated. These are in /usr/vm/val5/CallFlows/xxxx_yyyy_stats.xml where xxxx... represents the flow desired. It might also make sense to use this file instead of the report. One could at 11:59 have an automated download of it via a sftp client, just prior to reset.

I was trying to find my copy of an old doc with all the batch commands, wondering if there was something in there, but this is good. Once you have your commands worked out you could add it to the daily cron tab that already runs.

[johnp]

From what I know this file will be recreated upon the next call, so deleting should not be an issue IMHO

[ralph]

I was able to write a bash script to copy the file and email it.
The script works as I hoped.

But...

I added it to the root crontab.  It worked.  Until it didn't.
It stopped working so I checked the crontab again and the entry for it was missing.
It appear that something overwrites the crontab. 

Any suggestions?

Ralph

[lundah]

I was able to write a bash script to copy the file and email it.
The script works as I hoped.

But...

I added it to the root crontab.  It worked.  Until it didn't.
It stopped working so I checked the crontab again and the entry for it was missing.
It appear that something overwrites the crontab. 

Any suggestions?

Ralph

Which cron file did you add it to? There's a few. Try /usr/vm/bin/cron.daily or /etc/cron.daily/89NPMdaily

[ralph]

Which cron file did you add it to? There's a few. Try /usr/vm/bin/cron.daily or /etc/cron.daily/89NPMdaily

Thanks for the tip.
I'll take a look at that.  I've never edited a crontab other than using the crontab -e command.

Ralph

[ralph]

lunduh,
How do I edit those crontab? It looks like I need to know what the user is before i can edit it.
What would the user be?

Ralph

[lundah]

lunduh,
How do I edit those crontab? It looks like I need to know what the user is before i can edit it.
What would the user be?

Ralph

I

[ralph]

lunduh, I don't understand your post?

Ralph