Crossed emails :) thanks Francois I'll do that now. I wasn't sure if just deleting from nodes in SQL was OK or if there were other bits in other tables that needed to be cleaned up at the same time.
Mark -----Original Message----- From: Francois Gaudreault [mailto:[email protected]] Sent: 06 July 2012 13:44 To: [email protected] Subject: Re: [PacketFence-users] Clearing out nodes Hi Mark, > > How can I clear the old entries out? I ran the backup and maintenance script > but I guess that doesn't do it? Good old MySQL! Exemple: delete from node where status="unreg" AND detect_date <= NOW(); You can also potentially clear out old iplog closed entries and old locationlog closed entries. > > Regards, > > Mark > > > Nuffield College is a Registered Charity No. 1137506. Registered > Office: Nuffield College, New Road, Oxford, OX1 1NF > > ---------------------------------------------------------------------- > -------- > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. > Discussions will include endpoint security, mobile security and the > latest in malware threats. > http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > _______________________________________________ > PacketFence-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/packetfence-users > -- Francois Gaudreault, ing. jr [email protected] :: +1.514.447.4918 (x130) :: www.inverse.ca Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users Nuffield College is a Registered Charity No. 1137506. Registered Office: Nuffield College, New Road, Oxford, OX1 1NF ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
