Thanks Olivier, I talked with one of our programmers and hashed out a sql statement.... I am going to attempt using the last_arp values.. I just thought that I would ask to see if there was one.
David Bulanda [email protected] Indiana Tech -----Original Message----- From: Olivier Bilodeau [mailto:[email protected]] Sent: Friday, August 12, 2011 9:49 AM To: [email protected] Subject: Re: [Packetfence-users] Database cleanup Hi David, > I was wondering if there was a script to clean out the packetfence > database for the violations and nodes which are older than a certain > date. I am still running on version 1.6.2. I have not be able to > devote the time to configure a newer version to my environment. Not that I am aware of for such an old schema. I haven't worked on anything older than 1.8 to be honest. But, in any case, it's very easy to figure it out. Install your favorite db admin tool (command line mysql, phpmyadmin, etc.) look at the schema and try to find a way to delete the entries you don't want anymore. last_arp or last_dhcp maybe? Cheers! -- Olivier Bilodeau [email protected] :: +1.514.447.4918 *115 :: www.inverse.ca Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) ------------------------------------------------------------------------------ Get a FREE DOWNLOAD! and learn more about uberSVN rich system, user administration capabilities and model configuration. Take the hassle out of deploying and managing Subversion and the tools developers use with it. http://p.sf.net/sfu/wandisco-dev2dev _______________________________________________ Packetfence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users ------------------------------------------------------------------------------ FREE DOWNLOAD - uberSVN with Social Coding for Subversion. Subversion made easy with a complete admin console. Easy to use, easy to manage, easy to install, easy to extend. Get a Free download of the new open ALM Subversion platform now. http://p.sf.net/sfu/wandisco-dev2dev _______________________________________________ Packetfence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
