Veröffentlicht Fri, 13 Nov 2020 22:33:45 GMT von 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.
Veröffentlicht Sat, 14 Nov 2020 15:44:21 GMT von 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.
Veröffentlicht Mon, 16 Nov 2020 17:38:01 GMT von 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?
Veröffentlicht Mon, 16 Nov 2020 20:14:51 GMT von 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!
Veröffentlicht Wed, 25 Nov 2020 04:14:00 GMT von 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
 

Sie müssen angemeldet sein um Beiträge in den Foren zu erstellen.