List of hosts available in search?

This forum covers ideas and discussions on future phpLogCon versions. Most importantly, all discussions on the upcoming version 2 should go here.

Google Ads


List of hosts available in search?

Postby bluefoxicy » Fri Jul 20, 2012 1:40 pm

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)
bluefoxicy
New
 
Posts: 3
Joined: Wed Jul 18, 2012 7:06 pm

Urgent Question?

  • Pulling out your Hair?
  • Wasting Time and Money?
  • Deadline Approaching?

Google Ads


Return to Future Versions

Who is online

Users browsing this forum: No registered users and 2 guests

cron