投稿済み Fri, 13 Nov 2020 22:33:45 GMT 、投稿者 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.
投稿済み Sat, 14 Nov 2020 15:44:21 GMT 、投稿者 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.
投稿済み Mon, 16 Nov 2020 17:38:01 GMT 、投稿者 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?
投稿済み Mon, 16 Nov 2020 20:14:51 GMT 、投稿者 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!
投稿済み Wed, 25 Nov 2020 04:14:00 GMT 、投稿者 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
 

フォーラムに投稿するためにはログインが必要です。