Posted Fri, 13 Nov 2020 22:33:45 GMT by Jon Weston File IT Solutions Sr Application Developer and RIM specialist
I like the new Audit Reports section but I have a use-case where it'd be a lot easier if I knew where the data was kept so I can generate real-time stats and hook some slick report templates into the data for reporting purposes, in particular regarding last login dates of users, rather than having to manually export to a CSV file every time.  I've done some digging but can't find anything in the tables - can someone let me know where to look? I'm using DW 7.3.
Posted Sat, 14 Nov 2020 15:44:21 GMT by Craig Heintz SE
I went thru the same issue you are having.  It turns out that the data is all held in blobs in one of the new cabinet tables.  Therefore it is not directly accessible any more.

The API is the only way to access the data.
Posted Mon, 16 Nov 2020 17:38:01 GMT by Jon Weston File IT Solutions Sr Application Developer and RIM specialist
Thanks for the reply, Craig.  I've had a look in the code samples for the .NET API and I'm not seeing anything in there that looks user-related.  Am I missing something? Can you point me to the appropriate new cabinet table that would have info about last login dates of users?
Posted Mon, 16 Nov 2020 20:14:51 GMT by Tim Ohm
Once enabled, user login/out activity appears to go to DWSYSTEM.DWOrgSettingsAudit.  Each file cabinet logs to its own table under DWDATA - <FCName>.AUD (from the architecture document!).  You'll need to do a little comparison between the GUI and the DB Tables, as all the events are stored as a numeric value...just need to come up with a conversion chart!
Posted Wed, 25 Nov 2020 04:14:00 GMT by Craig Heintz SE
Tim is right for the specific system audit data.  I was referring to the cabinet and workflow data.
So...
Once login/logout has been enabled in the Audit Reports, Organization, User Login/Logout check box,

Then in table DB [dwsystem].[dbo].[DWOrgSettingsAudit] seems a eventType 3 is a Log In and an eventType 4 is a Log Off
 

You must be signed in to post in this forum.