messages.log/cconsole.log in SQL?
Do we have messages.log/cconsole.log projection in SQL?
I was sure we do, but unable to find it.
Discussion (5)0
Comments
try:
;
set file=$system.Util.ManagerDirectory()_"messages.log"
open file:("RS"):1 w $T open 2:99
try { for n=1:1 use file read lin use 2 write lin,! } catch { close 2,file write n_" lines",! }
;then use ^SPOOL mapping (OEX) to work on it with SQL
Why would you need it with SQL?
I want to get logs in a structured way.
Hi @Eduard Lebedyuk,
How about a custom class query (that read cconsole\messages.log) to solve your problem. ?
(Robert's solution would be faster to code.)
I believe new iris release has structured message log. forget since which release.