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
Bruce Campbell RIPE Systems/Network Engineer NCC www.ripe.net - PGP562C8B1B Operations/Security
rt-summarise.pl (39.9 KB)