isdnrep



isdnrep(1)                   Linux System Commands                  isdnrep(1)




NAME

       isdnrep - report isdn activity


DESCRIPTION

       Isdnrep  reads  the  isdnlog log files, generates reports, does statis-
       tics, and other things. It can also generate HTML output for use with a
       web server.


OPTIONS

       -V     show version information and exit.

       -a   all
              Show  all  connections  registered. If this option is not given,
              show only the connections made today.

       -S   Summary
              Show a summary (no individual calls) for selected date range. If
              this  option  is  given  twice, the summaries per day are hidden
              too. Don’t use with -h

       -h   no header
              There will be no header for each day, nor will  the  summary  at
              the  end  of each day and at the end of the report be generated.
              This is useful if the output is to be processed by another  pro-
              gram.
              This option doesn’t work if the -wX is also given.

       -n   numbers
              Display numbers instead of the aliases for those numbers.

       -fFILE The  file  from  which  to  generate the report. This is usually
              /var/log/isdn.log,    or    whatever    is     configured     in
              /etc/isdn/isdn.conf  as LOGFILE = .  The -f option will override
              the setting in /etc/isdn/isdn.conf.

       -t time span   time="time span"
              With this option a specific time span covered by  the  log  file
              can be displayed, e.g. all calls in November 1995, or on January
              3rd 1996 between 03:00 and 09:45.

              The format in which times are given  is  described  below.   The
              time span has the following syntax:

              time-time display from begin time up to end time
              time-     display from given time up to "now"
              -time     display from beginning of log file up to given time
              time      display the given month, day, hour, ...


       -d -time  delete="time"
              Delete  entries  from the log file up to (but not including) the
              specified time. The format is the same as  for  the  -t  option.
              The  minus  before the time must be given! It is not possible to
              define begin and end times; entries are always deleted from  the
              beginning up to the time given.

              Warning!  Entries are really deleted from the file. Careless use
              can result in all entries being deleted, e.g. with  "isdnrep  -d
              -".

       -E   print Errors
              Display  all  connections  and connection attempts. Without this
              option, only successful connections are displayed.

       -v   verbose
              Display warnings on startup.

       -c   ignore default options
              Do not append the "REPOPTIONS" setting from  /etc/isdn/isdn.conf
              to the commandline.

       -p [n][m]number[,[m]number...] phonenumber
              Display only selected phone numbers.

              "number"  is  specified  in  the same format as in configuration
              files (see isdn.conf(5)). E.g. wildcards can be used.

              If the flag ’m’ is given, the corresponding MSN is meant.  E.g.:
              "m2"  means  MSN#2. If "m0" is given, all numbers are to be dis-
              played.

              If the flag ’n’ is given, the given number is  not  to  be  dis-
              played.

       -U [_][.]number default source number
              Use ’number’ as source number for outgoing calls with an unknown
              source number ("?").  ’.’ is replaced by country and  area  code
              from isdn.conf.

              With  ’_’ the default source number is used internally (e.g. for
              fetching the right zone names from the ratefile) but it  is  not
              displayed.

       -i   incoming
              Only incoming connections are displayed.

       -o   outgoing
              Only outgoing connections are displayed.

       -xX  include/exclude calls
              Select  calls  by day and/or hour.  The following selections are
              possible and can specified in any combination and quantity using
              : as separator:
              ddaylist
                     only days matching daylist
              Ddaylist
                     all days not matching daylist
              htimelist
                     only hours matching timelist
              Htimelist
                     all hours not matching timelist

              daylist  and timelist have the same syntax as described in rate-
              files(5).  If a day or an hour is included and excluded it  will
              be excluded.

              Example
              -xd2-4:DH:h9-17:H12-15
              This  will  display all calls on Tuesdays, Wednesdays, or Thurs-
              days that are no holidays with a start time  between  09:00  and
              12:00 or 15:00 and 17:00.

       -u   unknown caller
              At  the  end  of  the  report,  all  numbers not aliased in cal-
              lerid.conf or ~/.isdn are displayed. This option is  not  avail-
              able when HTML output is requested.

       -LX  summary lists
              Select  the  summaries  in  the footer by any combination of the
              following letters:
              i,I    foreign numbers of incoming calls
              o,O    foreign numbers of outgoing calls
              c,C    foreign numbers of all calls
              z,Z    zones of outgoing calls
              p,P    providers of outgoing calls
              m,M    MSNs (own subscriber numbers) of outgoing calls

              Upper case letters deselect, lower case letters  select  a  sum-
              mary.   With  at  least one lower case letter, only the selected
              summaries are shown, as long as they are  not  also  deselected.
              -LiI  for  example will show no summary at all.  Per default all
              summaries are displayed.

       -rPROV recompute
              Recompute the connection fees with the current ratefile  instead
              of  showing  the  amounts  stored  in the logfile as usual.  The
              provider PROV for recomputation is selected in one of  the  fol-
              lowing ways:

              -         Use the logged provider.
              pNUM      Use  provider  with  Pnum  NUM (according to P: tag in
                        ratefile).   The  provider  variant  is   taken   from
                        rate.conf where the provider must be enabled.
              pNUM_VAR  Use  provider with Pnum NUM and variant VAR (according
                        to  P:NUM,VAR  in  ratefile).   No  requirements   for
                        rate.conf.
              vVBN
              vVBN_VAR  Similar to pNUM[_VAR] but the provider is selected via
                        VBN (B: tag in ratefile) instead of Pnum.
              b         Use  the  cheapest  of  all  booked  providers.    The
                        provider selection is done per call.  Booked providers
                        are those, which are enabled in rate.conf
              B         Like b but allow all providers, not only the booked.

       -m[*|/]number  modify call costs
              Multiply (*) or divide (/) the stored or recalculated call costs
              by  number before displaying them.  If neither * nor / is given,
              multiply.

       -wX  WWW
              isdnrep can give its output in HTML format; this is switched  on
              with this option. Two modes are possible:

              0      The HTML header is suppressed. Useful if the output is to
                     be included into an existing page.
              1      A complete HTML page is generated.

       -sX  format string
              The output generated by isdnrep can be  modified  by  specifying
              the format of the line generated for each connection. The syntax
              is similar to that used by printf. The following parameters  are
              possible  (the  x  where given means that a width for the field,
              also known as the precision, must be given):

              %X  time without date
                  e.g. 23:54:06
              %x  the date
                  e.g. 25/07/97
              %y  date without year
                  e.g. Sun May 04
              %Y  year, in four digits
                  e.g. 1997
              %D  duration of connection
                  e.g. 00:03:34
              %xH the local MSN; if an alias can be found, that will  be  dis-
                  played instead
              %xh the  local MSN, only as a number; no aliases will be substi-
                  tuted
              %xF the remote number; if an alias can be found,  that  will  be
                  displayed instead
              %xf the remote number, only as a number; no aliases will be sub-
                  stituted
              %xL the town corresponding to the local MSN if known;  an  empty
                  string otherwise
              %xl the  town  corresponding  to  the remote number if known; an
                  empty string otherwise
              %T  an arrow indicating the direction of  the  connection  ("->"
                  outgoing  or  "<-"  incoming);  the local MSN should be dis-
                  played on the left side of this.
              %t  an  arrow  indicating  the  direction  of  the   connection,
                  reversed  ("<-"  outgoing  or  "->" incoming); the local MSN
                  should be displayed on the right side of this.
              %xu the charge units, if known
                  e.g. 6 EH
              %U  the cost, if known
                  e.g. 2,28 DM
              %xj the name of the used provider
              %v  the VBN (carrier selection prefix) of the provider
                  e.g. 01012
              %V  the VBN and variant of the provider
                  e.g. 01012_3
              %I  amount of INPUT data
              %O  amount of OUTPUT data
              %P  INPUT throughput (bps)
              %p  OUTPUT throughput (bps)
              %S  Service Indicator
              %G  displays a HTTP link to the corresponding fax,  when  a  fax
                  was  received  by mgetty. This fax can be displayed by using
                  the link in a HTTP browser.
                  This option is only valid when used with -wx, see below  for
                  more information.
              %C  displays a HTTP link to the corresponding voice file, when a
                  call was recorded by vbox.  This option is only  valid  when
                  used with -wx, see below for more information.

              The default format string for (non-HTML output) is

                  "  %X %D %15.15H %T %-15.15F %7u %U %I %O"

              With  the  following  string all the important data is displayed
              while keeping the total length to 80:

                  "%X%D %10.10H%T%-14.14F%U%I %O"

              The above string  is  put  into  isdn.conf  at  installation  as
              REPFMTSHORT and can be used with -Fshort.

              Without showing the transfered bytes, this string also fits into
              80 chars:

                  "  %X %D %16.16H %T %-25.25F %U"

              It is included as REPFMTNIO.

       -FX  format
              format strings can be specified in  isdn.conf;  this  option  is
              used  to select one of these. Entries can be defined in the sec-
              tion [ISDNLOG] with names beginning with  "REPFMT".  The  string
              after  the  -F  option  is  added  to REPFMT to find the correct
              entry. Case is not sensitive. E.g.:

              REPFMT1        = ... # -> isdnrep -F1
              REPFMTMYSTRING = ... # -> isdnrep -Fmystring or
                                        isdnrep -F MYSTRING


HTML USE

       isdnrep can generate a HTML page containing links to files generated by
       vbox and mgetty (faxes), so that the messages and faxes can be heard or
       seen from within a browser. However, a couple of things need to be con-
       figured first.

       answering machine messages

       The  %C  can  be  used in the isdnrep output format to make a link to a
       voice recording file.  For this to work, the following entry is  needed
       in the [ISDNLOG] section in isdn.conf:

           VBOXPATH= /var/spool/vbox/fred/incoming # incoming directory pathname

       Now  isdnrep  can  find  the file correctly. Clicking on this link will
       cause the file to be sent. These files are in ZyXEL format; the browser
       cannot use these directly. The type is given by isdnrep as follows:

           Content-Type: application/x-zyxel4

       The  correct  application (helper) for this has to be configured in the
       browser. Alternatively, a conversion program can be specified  to  isd-
       nrep  which  will convert the ZyXEL format. The pathname of the file to
       convert is given as a parameter to the program.

       In the [ISDNLOG] section of isdn.conf an  entry  as  follows  specifies
       which conversion program to use:

           VBOXCMD1 = /usr/bin/program1

       for versions 0.x and 1.x of vbox, and

           VBOXCMD2 = /usr/bin/program2

       for versions 2.x of vbox. Both entries can be given, isdnrep recognizes
       which version created the recording.

       The program must first output a line with the content-type, followed by
       the  data itself. To convert the ZyXEL format into a WAV file, the fol-
       lowing script may be used:

           #! /bin/sh
           ##
           ## script to play voice messages from vbox-2.0
           ##
           ## WARNING! If the paths are not set correctly,
           ## netscape may simply crash!

           PATH=$PATH:"path to sox":"path to pvftools":"path to vbox"
           FILENAME1=/tmp/voxplay.$$.voc
           FILENAME2=/tmp/voxplay.$$.wav
           VOLUME=8

           vboxtoau <$1             | \
                     autopvf        | \
                     pvfamp $VOLUME | \
                     pvfcut 0.20    | \
                           pvftovoc > $FILENAME1

           sox $FILENAME1 $FILENAME2

           echo Content-Type: audio/x-wav
           echo
           cat $FILENAME2

           rm -f $FILENAME1 $FILENAME2

       The script above needs the packages sox  and  pvftools.   Additionally,
       the browser needs to be told how to handle "audio/x-wav".  This is done
       by adding the following lines to the files listed:

           ~/.mime.types
               type=audio/x-wav    \
               desc="auWAV Audio"  \
               exts="wav"

           ~/.mailcap
               audio/x-wav;/usr/bin/auplay %s

       The package NAS (Network Audio System) may be needed.

       Now, when the browser is started, it will recognize WAV files and start
       the corresponding program to handle these. The WAV format has been cho-
       sen as this can also be played from a Windows pc.


       faxes received by mgetty

       When %G is used in the isdnrep output format,  any  faxes  received  by
       mgetty  will  be  accessible via a HTML link, in the same manner as the
       ansering machine messages.

       For the faxes the following entry in the [ISDNLOG] section in isdn.conf
       is needed:

           MGETTYPATH = /var/spool/fax/incoming

       WARNING:  if  isdnrep  doesn’t  have permission to read the files, they
       will not be displayed; there will be no error message.

       When isdnrep passes these files back to the browser, they have  the  G3
       format. The following header is used to notify the browser of this:

           Content-Type: application/x-faxg3

       As  the  browser probably doesn’t understand this format, the following
       changes to the files listed are needed:

           ~/.mime.types
               type=application/x-faxg3  \
               desc="G3-Fax Format"      \
               exts="fax,g3"

           ~/.mailcap
               pplication/x-faxg3;/usr/X11/bin/g3view %s

       The program g3view has to be installed for this to work.

       If now the link is clicked on, the browser will automatically start the
       external g3view to handle this data.

       If  you  prefer another format (instead of G3) such as JPEG, the format
       has to be converted. The following entry in the  [ISDNLOG]  section  of
       isdn.conf takes care of this:

       VBOXCMD = /usr/bin/g3tojpeg # example

       The script g3tojpeg can be something like this:

           #! /bin/sh
           ##
           ## command to display faxes in a browser
           ##
           ## WARNING! If the paths are not set correctly,
           ## netscape may simply crash!

           export PATH=$PATH:"path to g3topbm":"path to convert"

           echo Content-Type: image/jpeg
           echo

           g3topbm < $1 | convert pbm:- jpeg:-

       The  packages  ImageMagick  and  mgetty  are needed. Mgetty is probably
       already installed if you want to use this feature :-)

       The advantage of the JPEG format is that it can also be displayed by  a
       browser running on a Windows pc.

       summary

       A suitable value for REPFMTWWW is

           REPFMTWWW = "%X %D %17.17H %T %-17.17F %-20.20l SI: %S %9u %U %I %O %G %C"

       Netscape  3.0  Gold and Arena have been tested, and both work fine with
       isdnrep’s HTML output, although Arena’s display is not as colourful  as
       Netscape’s.

       A  known problem (which is impossible to solve completely) is determin-
       ing the relationship between an isdn  connection  and  a  fax  or  vbox
       recording.   Unfortunately  the times for isdnrep, mgetty and vbox dif-
       fer. Isdnrep tries to make the best guess,  but  it’s  always  possible
       that e.g. a fax is connected to the wrong isdn connection.


EXAMPLE OUTPUT

       With the default configuration the following output can be generated on
       stdout (whitespace slightly edited for clarity):

   $ isdnrep -v -t 6/1/96
   I S D N  Connection Report  -  Tue Aug 26 22:21:19 1997


   Sat Jan  6 1996
     00:54:19                 UNKNOWN -> UNKNOWN     No user responding      (4)
   [...]
     16:33:24  0:03:23        UNKNOWN -> UNKNOWN        7 EH      0,84 DM
     17:33:47                 UNKNOWN -> UNKNOWN     Unallocated (unassigned)(5)
                                                     number
     20:02:28  0:02:37     Phone/HDLC <- UNKNOWN                             (1)
     20:09:53  0:07:01     Modem/X.75 -> T-Online       3 EH      0,36 DM    (2)
     21:27:56                 UNKNOWN -> UNKNOWN     User busy               (3)
     22:09:41  0:29:36        UNKNOWN -> UNKNOWN       43 EH      9,89 DM*
   ======================================================================
     1 IN= 0:02:37,  13 OUT= 3:40:14,   3 failed      210 EH     25,20 DM
   (6)^^^^^^^^^^^^  (7)^^^^^^^^^^^^^  (8)^^^^^^^   (9)^^^^^^ (10)^^^^^^^^


   DIALOUT Summary for Sat Jan  6 1996                                      (11)
   -----------------------------------------------------------
   T-Online         1 call(s)  0:07:01     3 EH    0,36 DM
   UNKNOWN         11 call(s)  0:17:00    20 EH    2,40 DM


   DIALIN Summary for Sat Jan  6 1996                                       (12)
   -----------------------------------------------------------
   UNKNOWN          1 call(s)  0:02:37


   Zone 1 : City              2 call(s)  2:23:13     50 EH    6,00 DM       (13)
   Zone x : UNKNOWN          11 call(s)  0:17:00     20 EH    2,40 DM


       Notes
         (1) "xxx <- xxx" was an incoming call, so doesn’t cost anything
         (2) "xxx -> xxx" was an outgoing call lasting  203  seconds,  so  for
             City zone, off-peak time (Saturday), 3 charge units = DM 0,36
         (3) there was no connection, as the called party was busy
         (4) there  was  no connection, as the called party didn’t pick up the
             phone
         (5) "the number you have dialled is not connected. Hang up  and  dial
             again. ..."
         (6) total time for incoming calls
         (7) total time for outgoing calls
         (8) 3 calls failed; busy (3), no answer (4) and error in dialing (5)
         (9) total charge units incurred for one day
        (10) total costs incurred for one day
        (11) outgoing calls grouped per number
        (12) incoming calls grouped per number
        (13) outgoing and incoming calls grouped per tariff zone

       If  the  charge  units are marked with "*", the PTT switch did not give
       charge info; these are the number of units guestimated by isdnrep.



TIME FORMAT

       For the -d and -t options, the time is specified in the following  for-
       mats:

       [DD/][M]M/[[YY]YY]
              specifies the month or day.

              Examples:

              7/        July of the current year
              8/1996    August 1996
              29/6/05   June 29th 2005
              6/6/      error,  is not June 6th of the current year; it’s June
                        1906

       [D]D   day of current month

       [D]D.[M]M.[[[CC]Y]Y]
              specifies a day.  If century or year and  century  are  missing,
              they will be taken from the current date.

              Examples:

              23.5.     May 23rd in the current year
              19.01.38  January 19th 2038
              16.10.1998
                        October 16th 1998

       [MM]DD[hhmm[[CC]YY][.ss]]
              specifies an exact time. Unspecified parts are defined as 0 when
              interpreted as a begin time, and 23 or 59 when interpreted as an
              end time.
              If a year is to be specified, the hours and minutes must also be
              specified.
              The format is copied from the date command.

              Examples:

              0107   January 1st in the current year
              0107173196.25
                     January 7th 1996 17:31:25
              010717311996
                     January 7th 1996 17:31:00 (or 17:31:59)
              12141995
                     error: not December 12th 1995, but December 12th  of  the
                     current year at 19:95, so it’s garbage.

              Examples of time spans and their meaning:

              6/95-081214381996.25
                     all  entries  between  June  1st 1995 00:00:00 and August
                     12th 14:38:25
              0912030495.20-12/95
                     all entries between  September  12th  1995  03:04:20  and
                     December 31st 1995 23:59:59
              09.06.2006-9/7/6
                     all  entries  between June 6th 2006 00:00:00 and July 7th
                     2006 00:00:00
              7/95   all entries between July 1st 1995 00:00:00 and July  31st
                     1995 23:59:59
              0908   all  entries  between  September  8th in the current year
                     00:00:00 and September 8th in the current year 23:59:59
              3      third day of the current month

       [CC]YY-MM-DDThh:mm:ss
              specifies a year, a moment, or something between.  Each  sepera-
              tor  ´-’,  ’T’, and ’:’ can be omitted or not.  If the first ’-’
              is missing, the century must be given.

              This notation cannot be combined with the above notations.  Time
              spans  are noted with ’--’ instead of ’-’.  If no ’--’ is given,
              ´i’ must be noted after the -t option.

              Examples:

              i2002  the entire year 2002 from January 1st 00:00:00 to  Decem-
                     ber 31st 23:59:59
              i200306
                     the entire month June 2003
              200308--200309
                     August and September 2003
              2003-10-03T17--
                     all entries after October 3rd 2003 16:59:59
              2003-08-27T11:51:25--20030827115128
                     4 seconds at August 27th 2003
              200306 error: neither ’i’ nor ’--’ given
              2003-1-4
                     error: leading zeros (at month and day) must not omitted

       "y"    yesterday,
       "yy"   the day before yesterday,
       "yyy"  three days ago and so on.  For time spans these can also be used
              in conjunction with the notations explained above.


FILES

       /var/log/isdn.log or /var/lib/isdn/calls
              isdnlog log file with information about all calls.

       /etc/isdn/isdn.conf
              general configuration

       /etc/isdn/callerid.conf
              aliases for telephone numbers


SEE ALSO

       isdnlog(5) isdnlog(8) isdn.conf(5)


AUTHOR

       This manual page was  adapted  from  isdnlog/README  by  Paul  Slootman
       <paul@isdn4linux.de>, for Debian GNU/Linux and isdn4linux.



ISDN 4 Linux 3.7                  2005/01/22                        isdnrep(1)

Man(1) output converted with man2html