Ensemble Event Log

Question

Question

Jenna Poindexter · Oct 27, 2016

Hi-

I was wondering whether or not the Ensemble Event Log was accessible using SQL? If so, what schema and table would that be contained in?

Thanks

Discussion (4)1

Log in or sign up to continue

Jenna Poindexter · Oct 27, 2016

I found what I was looking for. I was looking at EnsLib.HL7.Message looking for a way to correlate that to Ens.MessageHeader when I should have been looking from the reverse order.

In Ens.MessageHeader there is a field MessageBodyClassName which contains the name of the class containing the message body. In this case EnsLib.HL7.Message

There is also a field in Ens.MessageHeader called MessageBodyId which contains the ID of the corresponding message body.

1 0

score 0 · Answer 1 · 2016-10-27T08:33:28-04:00

Jenna Poindexter · Oct 27, 2016

The event log is stored in the table Ens_Util.Log

0 0

score 2 · Answer 2 · 2016-10-27T08:41:05-04:00

Tirthankar Bachhar · Oct 27, 2016

I would suggest to look at both the below classes,
Ens_Util.IOLog, and Ens_Util.Log

2 0

score 0 · Answer 3 · 2016-10-27T09:37:42-04:00

Thanks Bachhar,

Expanding on this a bit, we also have the need to be able to query the message store for messages we have sent/received from a given interface. These are all HL7 messages, which means they are stored in EnsLib.HL7.Message.

I'm assuming there is a way to correlate a message in EnsLib.HL7.Message with either Ens.MessageBody or Ens.MessageHeader where regular Ensemble messages are stored.

What would be the proper way to correlate these? I looked at the fields in EnsLib.HL7.Message but don't see anything that stands out as obvious connection between the two tables.