From owner-freebsd-isp Wed Oct 20 1:17:31 1999 Delivered-To: freebsd-isp@freebsd.org Received: from di.nl (di.nl [194.134.3.197]) by hub.freebsd.org (Postfix) with ESMTP id 286ED1A864 for ; Wed, 20 Oct 1999 01:17:03 -0700 (PDT) (envelope-from joep@di.nl) Received: (from joep@localhost) by di.nl (8.9.3/8.9.3) id KAA33109; Wed, 20 Oct 1999 10:09:54 +0200 (CEST) (envelope-from joep) Date: Wed, 20 Oct 1999 10:09:54 +0200 From: Joep Grooten To: Deepwell Internet Cc: freebsd-isp@FreeBSD.ORG Subject: Re: Trouble ticket software. Message-ID: <19991020100954.A33084@di.nl> References: <4.2.0.58.19991014175047.00cefd40@mail1.dcomm.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 1.0pre1i In-Reply-To: <4.2.0.58.19991014175047.00cefd40@mail1.dcomm.net> Sender: owner-freebsd-isp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org On Thu, Oct 14, 1999 at 06:06:41PM -0700, Deepwell Internet wrote: > I'm thinking of developing a trouble ticket system for an ISP. I just > thought I'd check here and see if anyone knows of a solution I could use to > do this without writing it from scratch. We've just released a ticketing system for FreeBSD called Loggie, you'll find it on: http://www.di.nl/loggie/ Currently it only supports MySQL but later this week a Solid Server version will be released. Work on a PostgreSQL version is on it's way... > The system could break down reports about the types of customer problems > and the regions. It could report on a sudden increase in disconnects or > low-connect-speeds above what is normal for a given switch. Then, I could > print a list of telephone prefixes for those customers to send off to the > telco. Reporting is still missing in Loggie but you can generate your own reports using the data from the tickets in the database... Joep -- +----------+----------------------------+ | \ / | Joep Grooten / joep@di.nl | |---\\\\---| Digital Intelligence B.V. | | / \ | tel: +31.20 670 70 70 | +----------+ fax: +31.20 670 78 78 | +----------------------------+ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-isp" in the body of the message