Logging users' prompt entries

[system]

Is this information stored somewhere?

I know we can pull it from the DB side from the logged SQL statement, but I’m looking for something similar to the audit DB that we’ve been using to log activities.

Is this in the audit DB??? If it is, I haven’t been able to find it.

Thank you,
Rob

---

wubertatwork (BOB member since 2011-01-19)

[system]

It’s in there, but only if enabled – See CMC -> Auditing -> Set Events

---

joepeters (BOB member since 2002-08-29)

[system]

Hi!

Yep, we do have it enabled. I’ve confirmed that (screen shot).

Another thread (link below) refers to an Action Name, but I haven’t found that yet. Would you (or anyone else reading this!) by chance know?

Can Auditor log prompt values

Could you tell me where to find the Action Name? I’ve looked through the tables in the Audit DB (shown in my screen shot) and while I do see ACTION_ID in ADS_EVENT, I don’t see a reference table for the Action Name. I also dumped out all of the reference tables and then searched for some values from ADS_EVENT.ACTION_ID and didn’t match up to anything. Confused! And like the others, looking for user prompt entries in the Audit information. Thank you, Rob [Untitled.png] wubertatwork (…

Thank you,
Rob

---

wubertatwork (BOB member since 2011-01-19)

[system]

I’ve found the data. I’ll share after I confirm how I’m going to pull it out.

---

wubertatwork (BOB member since 2011-01-19)

[system]

I’ve attached a write-up. Hopefully this will help future Audit DB users get started.
Audit DB and Prompt Values.doc (376.0 KB)

---

wubertatwork (BOB member since 2011-01-19)

[system]

My doc is updated for date prompts. They are recorded in the audit DB in epoch time!

---

wubertatwork (BOB member since 2011-01-19)