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
from bash or whatever run csession to log into your instance. then
and off it goes
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()
^
<SYNTAX>
typo in first (mailed) version: DO $SYSTEM.SQL.Shell()
dot instead of colon.
Thanks, worked this time great.