Logging users' prompt entries

building reports webintelligence
1

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 :us: (BOB member since 2011-01-19)

2

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

joepeters :us: (BOB member since 2002-08-29)

3

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?

https://bobj-board.org/t/59157/8

Thank you,
Rob
Untitled.png

wubertatwork :us: (BOB member since 2011-01-19)

4

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

wubertatwork :us: (BOB member since 2011-01-19)

5

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 :us: (BOB member since 2011-01-19)

6

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

wubertatwork :us: (BOB member since 2011-01-19)