Hi can anyone please let me know how to pull logs out of the database to use with the ESI tool.
ESI online help has a small chapter on this. see if this helps?
Before using the LSData utility, you must push the logs from the event source that you want to integrate into enVision using the configured protocol.
To use lsdata to obtain a file in syslog format:
lsdata -events Syslog options -time start end -devices "devicespec"
start is the starting time of returned data.
end is the ending time of returned data.
"devicespec" is the specification for an event source. You can enter more than one "devicespec" value in the command.
Just for completeness:
lsdata -d 0 -time hour now -devices "foo" > e:\tempfolder\foodevice.unx
ESI will then ask you if you received these logs from lsdata.
Retrieving data ...