How to call Event Log from cache prompt

Question

Question

Maxim Chekalin · Jan 19, 2022

How to execute it from the command line? I am able to use SQL in Management Portal, but I need to do it in Unix

select * from Ens_Util.Log where ConfigName='SFTPTo.HQ.SAFETRACE.DFT' AND Text LIKE '%Put Stream%' and TimeLogged LIKE '%2021-10-16%'

Product version: IRIS 2021.2

Discussion (4)0

Log in or sign up to continue

Maxim Chekalin · Jan 20, 2022

Thanks

Oops, I got this error

irissession R-ENGINE

Node: coltuhengine01, Instance: R-ENGINE

PROD1-HL7>ZN "PROD1-HL7"

PROD1-HL7>do $system:SQL.Shell()

DO $SYSTEM:SQL.Shell()

^

0 0

Robert Cemper · Jan 20, 2022

typo in first (mailed) version: DO $SYSTEM.SQL.Shell()
dot instead of colon.

0 0

Maxim Chekalin · Jan 20, 2022

Thanks, worked this time great.

0 0

score 0 · Answer 1 · 2022-01-19T15:52:00-05:00

from bash or whatever run csession to log into your instance. then

user>ZN "myNamespace"
nsp>do $system.SQL.Shell()
nsp>>select * from Ens_Util.Log where ConfigName='SFTPTo.HQ.SAFETRACE.DFT' AND Text LIKE '%Put Stream%' and TimeLogged LIKE '%2021-10-16%'

and off it goes