isdnrep(1) report isdn activity

DESCRIPTION

Isdnrep reads the isdnlog log files, generates reports, does statistics, 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 program.

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/lib/isdn/calls, 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 displayed.

If the flag 'n' is given, the given number is not to be displayed.

-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 Thursdays 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 callerid.conf or
~/.isdn are displayed. This option is not available 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 summary. 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 following 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 displayed instead
%xh
the local MSN, only as a number; no aliases will be substituted
%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 substituted
%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 displayed 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 section [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 configured 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 isdnrep 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 following 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 chosen 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 determining the relationship between an isdn connection and a fax or vbox recording. Unfortunately the times for isdnrep, mgetty and vbox differ. 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 formats:

[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 separator '-', '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 December 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/lib/isdn/calls 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

AUTHOR

This manual page was adapted from isdnlog/README by Paul Slootman <[email protected]>, for Debian GNU/Linux and isdn4linux.