NuPoint Call Directory Call Flow Reports - Automated

[lundah]

Note sure what happened to the rest of it. You need to put your shell commands in the

[lundah]

Note sure what happened to the rest of it. You need to put your shell commands in the

Odd that something keeps eating my comment text. I

[lundah]

Ok, back from a few days off and on my regular machine. No idea why my comments were getting eaten when posting from my iPad, I tried different browsers, did a Preview before posting, no luck.

Based on the info in several KMS articles, it looks like everything in /etc/cron.daily is run during the NP nightly maintenance, I'm not sure on exactly how, but the /etc/crontab file specifically warns not to edit as it will get overwritten, so Mitel is doing something weird under the hood. To make things simple, just add your commands to the /etc/cron.daily/89NPMdaily file. Grab a copy of the original file first, of course. Open it up in vi or nano (ssh in, go to the /etc/cron.daily and "nano 89NPMdaily" or "vi 89NPMdaily"), add a comment line and then your shell commands, then save the file. Save a copy as well, as I would imagine this will get overwritten on an upgrade.

[ralph]

So /etc/cron.daily is a directory, not a file.  It contains several scripts.
So my guess would be that anything in the directory will get executed daily.
I'll test that by putting in my script.

Ralph

[johnp]

Check this out https://wiki.koozali.org/Cron_entry This tells how to make changes survive upgrades. This is based on Mitel Linux i.e e-smith

[johnp]

Ralph, did you every get this working? If so do you have any instructions on doing this> I have someone asking for similar things. Thanks, John

[ralph]

Ralph, did you every get this working? If so do you have any instructions on doing this> I have someone asking for similar things. Thanks, John

Yes, I did. 
Now.... you would think I could remember how I did it.
Here's today's output:

Xxml version="1.1" encoding="UTF-8" standalone="no" ?
 stats startDate="01/06/2025" startTime="07:01:53"
     totalSeconds 66
     numCalls 39
     internalCalls 30
     externalCalls 9
     hourlyTotals
         hour00 0
         hour01 0
         hour02 0
         hour03 0
         hour04 0
         hour05 0
         hour06 0
         hour07 6
         hour08 12
         hour09 1
         hour10 6
         hour11 3
         hour12 3
         hour13 4
         hour14 0
         hour15 3
         hour16 1
         hour17 0
         hour18 0
         hour19 0
         hour20 0
         hour21 0
         hour22 0
         hour23 0
   
     nodes
         001" name="Main Sched" type="Schedule"
             entryCount 39
             exitCounts
                 Off_Hours targetNodeName="After Hours Schedule" 0
                 On_Hours targetNodeName="Day Sched" 39
           
       
         002" name="Bld Txfer Aftr Hrs to Google Num [REDACTED]" type="Blind transfer"
             entryCount 0
           
       
         003" name="Bld Txfer [REDACTED] HlpDsk" type="Blind transfer"
             entryCount 39
           
       
         004" name="Day Sched" type="Schedule"
             entryCount 39
             exitCounts
                 Off_Hours targetNodeName="Bld Txfer Google Number [REDACTED]" 0
                 On_Hours targetNodeName="Bld Txfer [REDACTED] HlpDsk" 39
           
       
         005" name="Bld Txfer Google Number [REDACTED]" type="Blind transfer"
             entryCount 0
           
       
         006" name="After Hours Schedule" type="Schedule"
             entryCount 0
             exitCounts
                 Off_Hours targetNodeName="Bld Txfer Aftr Hrs to Google Num [REDACTED]" 0
                 On_Hours targetNodeName="Blind Xfer to [REDACTED]Key" 0
           
       
         007" name="Blind Xfer to [REDACTED] Key" type="Blind transfer"
             entryCount 0
           
       
   

Note: Created by /etc/cron.daily/send_stats.sh

The actual file to create the magic is a shell program.  /etc/cron.daily/send_stats.sh
It has to be in the /etc/cron.daily directory.

#!/bin/bash
#copy file to stats directory.
#cp /usr/vm/val5/CallFlows/mbox_[MBOX REDACTED]_stats.xml /usr/vm/val5/CallFlows/stats/"$(date +"%m-%d-%y")_CallStats.xml"


cat /usr/vm/val5/CallFlows/mbox_[MBOX REDACTED]_stats.xml | sed 's/<[^>]*\/>//g' | sed 's/<\/[^>]*>//g' | sed 's/[<>]/ /g' | sed 's/node id="//g' > /u$

#adding a note at end of file as a reminder where this shell script resides.
echo "Note: Created by /etc/cron.daily/send_stats.sh" >> /usr/vm/val5/CallFlows/stats/"$(date +"%m-%d-%y")_CallStats.xml"


#send the file via email
cat /usr/vm/val5/CallFlows/stats/"$(date +"%m-%d-%y")_CallStats.xml" | mailx -s "Helpdesk Stats" s[EMAIL REDACTED]

cat /usr/vm/val5/CallFlows/stats/"$(date +"%m-%d-%y")_CallStats.xml" | mailx -s "Helpdesk Stats" [EMAIL REDACTED]


#delete the original file after emailing. This resets the stats.
rm /usr/vm/val5/CallFlows/mbox_[MAILBOX]_stats.xml

[johnp]

Thanks