Page 1 of 1

List of hosts available in search?

PostPosted: Fri Jul 20, 2012 1:40 pm
by bluefoxicy
Why not have a search page that allows for a list of hosts?

Syslog Facility and Severity are multi-select list boxes. The same could be done with hosts. Fill it with:

Code: Select all
SELECT DISTINCT FromHost FROM SystemEvents;


Of course you'll want an index on SystemEvents.FromHost (the schema provided with rsyslogd doesn't seem to provide any indexes):

Code: Select all
CREATE INDEX se_fromhost ON SystemEvents (FromHost);


(I also made indexes for (Facility), (Priority), (Facility,Priority), (DeviceReportedTime), (SysLogTag) on that table)