Written by

Question Maxim Chekalin · Jan 19, 2022

How to call Event Log from cache prompt

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

Add reply

Comments

Robert Cemper · Jan 19, 2022

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

0 0

Maxim Chekalin Jan 20, 2022 to Robert Cemper

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 to Maxim Chekalin

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

0 0

Maxim Chekalin Jan 20, 2022 to Robert Cemper

Thanks, worked this time great.

0 0