New post
Question
Maxim Chekalin · Jan 19, 2022

How to call Event Log from cache prompt

#SQL #HealthShare

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
0
0 138
Discussion (4)0
Log in or sign up to continue
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

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>

0 0
Robert Cemper · Jan 20, 2022

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

0 0