Select Statement Output
Date: December 14, 2009 02:58PM
I loaded Kiwi on a windows VM to handle all of my syslog data, then I'm shipping the data through a MySQL ODBC connection to a MySQL database. The "MsgText" field as you can see from the output below contains a good bit of information. When I run a select query I only want to display specific data in the query results window. Do you know what syntax I would need to pull specific data from the MsgText column? Example, It would be nice to display just the following text "denied udp 169.254.1.255". Also, when people build dynamic front-end web pages what do they use to pull data from a back-end database, Apache coupled with PHP?
select MsgTime, MsgText from Syslogd where MsgText like '%5000%' and MsgTime < '8:00:00' order by MsgTime DESC limit 0,8;
**Snippet of the MsgText Data**
Dec 13 2009 05:45:33: %PIX-2-106100: access-list out denied udp outside/169.254.1.136(44890) -> outside/169.254.1.255(5000) hit-cnt 20 300-second interval [0x6a852657, 0x0
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.