Rt-summarise: 1.3

The attached file does two things (selectable):

a) a basic job of summarising all requests received by a given
   queue over a given time period, from a given domain name, from
   a particular company (or some of the above), in your choice of
   'full' or 'brief' formats.

   As an example:

	rt-summarise.pl --summary brief --queue DNS
	--start "2002-11-06 00:00:00" --domain "ripe.net"

	Summary for:
	        Queue: DNS
	        Starting: 2002-11-06 00:00:00
	        Total Found: 4

	RIPE NCC - Operations Group             :           1
	RIPE NCC - Registration Services        :           3

b) Modify the Organization field all RT::User objects in a certain
   domain according to fields in a certain file.  In the case of
   the RIPE NCC, we've modified every RT User object with an email
   address @ripe.net to have:

	'RIPE NCC - Name of section'

   with the intent that the company option to (a) just takes the
   first section.  Some modification of an internal routine is
   required to use this, as the format of file that I use for
   reference (an employee listing file) probably won't meet with
   your requirements.

   I run something like:

	rt-summarise.pl --company "RIPE NCC" --domain "ripe.net"
	--matchfile employees.lst

   On a monthly basis to keep RT up to date with staff changes.

Note that a lot of the guff in the program file is basically Getopt::Long
on drugs.

Regards,

                         Bruce Campbell                            RIPE
               Systems/Network Engineer                             NCC
             www.ripe.net - PGP562C8B1B             Operations/Security

rt-summarise.pl (39.9 KB)

The attached file does two things (selectable):

a) a basic job of summarising all requests received by a given

Note that I’ve actually jumped the gun on this. RT::Tickets in 2.0.15
(and below) is broken and will not work properly with this code.

2.0.16 will be released with the patched version, or you can retrieve the
patched version of Tickets.pm from fsck.com’s bugtracker
(www.fsck.com/rt2/ guest:guest #1729 )

                         Bruce Campbell                            RIPE
               Systems/Network Engineer                             NCC
             www.ripe.net - PGP562C8B1B             Operations/Security