Publicado Fri, 13 Nov 2020 22:33:45 GMT por 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.
Publicado Sat, 14 Nov 2020 15:44:21 GMT por 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.
Publicado Mon, 16 Nov 2020 17:38:01 GMT por 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?
Publicado Mon, 16 Nov 2020 20:14:51 GMT por Tim Ohm
Once enabled, user login/out activity appears to go to DWSYSTEM.DWOrgSettingsAudit.  Each file cabinet logs to its own table under DWDATA - .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!
Publicado Wed, 25 Nov 2020 04:14:00 GMT por 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.