The log file is as below that have two columns, one is status and the other one is the time taking the status:
=================sc-status time-taken 200 1015
I want to know how to configure logmon to capture the values for such table like log files.
1. how to do it if it's excel table with fix arrangement
2. how to do it if it's text-file table with different positions of string
3. Is that possible to generated alert if status changed, for example change from 200 to 400?
So logmon can only read ascii files not excel so this rules out option one.
If the columns are fixed regex really does not have a good way in my option of doing this but you could do something like
Teh above will pull out the the 4 digits starting at position 13 in your example.
If this is not always a 4 digit number you would have to modify for that.
Logmon does not retain information from one run to another to be able to tell when you go from 200 to 400.
usually you would just monitor for 400 and send an alarm at that time.
hope this helps