Home page logo
/

nanog logo nanog mailing list archives

Re: Customer Notification System.
From: Daniel Rohan <drohan () gmail com>
Date: Wed, 22 Feb 2012 19:00:13 +0300

On Feb 22, 2012 6:35 PM, "R. Scott Evans" <nanog () rsle net> wrote:

** NOTE - this is off the top of my head, ie.. not tested.  That said,
it's more or less a simplified version of what we do.


whoa. best humble brag I've seen in a few weeks, Scott. And that's saying a
lot considering this is NANOG.
 On Feb 22, 2012 6:35 PM, "R. Scott Evans" <nanog () rsle net> wrote:

What, no programmers in your NOC to roll your own?

---
#!/usr/bin/perl

use DBI;

# define variables ($sendmail, $from, $database... etc)

$dbh = DBI->connect("DBI:mysql:$database:$server", $user, $pass);
$mysearch = $dbh->prepare("SELECT customer,cid,email FROM $table WHERE
$find);
$mysearch->execute;

while (($customer,$cid,$email) = $mysearch->fetchrow_array) {
       open(MAIL, "| $sendmail -t");
       print MAIL "From: $from\n";
       print MAIL "To: $email\n";
       print MAIL "Subject: $subject\n\n";
       print MAIL "$customer,\nYour circuit $cid is going down bla bla
bla.";
       close(MAIL);
}
$dbh->disconnect;
---

** NOTE - this is off the top of my head, ie.. not tested.  That said,
it's more or less a simplified version of what we do.

-Scott

On Tue, 21 Feb 2012 17:58:19 -0500, "James Wininger"
<jwininger () ifncom net> wrote:
We are a smaller ISP in Indiana. We are growing quite rapidly (yeah for
us). We have a need for a customer notification system. We have simply
out grown the ability to send emails to our customers manually. We need
to have a better way of notifying our customers of maintenance etc.

We would need to send notifications out to say about 400 customers.
Ideally the system would send an attached PDF. It would be great if this
system were SQL based etc.

Does anyone know of a system that is out there that does this? We have
looked at a few applications (windows based) but integration with
billing etc seems to be a caveat. I have thought of possibly using a
mailing list type approach, but that gets us back to (almost) where we
are today. Any pointers would be greatly appreciated.

--
Jim Wininger
jwininger () ifncom net




  By Date           By Thread  

Current thread:
[ Nmap | Sec Tools | Mailing Lists | Site News | About/Contact | Advertising | Privacy ]
AlienVault