Andre Lorbach wrote: > Hi again, > > I want to inform you all that the search within phpLogCon has been > extended to support full and partial searches in Version 2.5.3, > available for download here: http://www.phplogcon.org/downloads > > I first tests have shown, that filtering by hostname and other string > based fields performs much better on database sources now. > You can use the submenu buttons on each field within the messages view > to perform such a search. If you want to do manual searches, it is very > simple. Here is a sample: > > Search for a full hostname: source:=SERVERNAME (Will only find if the > match is 100% = SERVERNAME) > Search for a partial hostname source:SERVER (Willmatch if the hostname > is SERVER or SERVERNAME). > Thanks for the quick change.
Now I have another question, which is more sql but I thought I'd ask it anyway. What I'd like to do is keep 3 months worth of data, but rotate and merge my tables after a set amount of time to keep search times low. Tables more than 3 months old would be dropped. If anyone has a nice, canned script for this, it would be appreciated. Otherwise, I'll read the mysql manuals. 8-) thx _______________________________________________ rsyslog mailing list http://lists.adiscon.net/mailman/listinfo/rsyslog
