Welcome to part two. In part one I described how and where to find login attempts. This post explains how to connect and extract login infos via Integration Services.
By default, Datazen creates logfiles for several days. You can adjust this setting in a config file.  Thus, we have to loop through each available log file.
For each log file, we store extracted login information to a table (e.g. “T_DZ_LOGINS”).
My Data Flow Task for extracting logins looks like this.
LOAD LOGFILE: Loads log file as File System Task.
EXTRACT LOGIN ATTEMPTS: Searches login attempts using Conditional Split Transformation Task.
EXTRACT USER_NAME: Extracts username via Expressions in a Derived Column Transformation
STRING_CONVERSION: Converting to DT_WSTR
TRANSFER TO BI_TOOL: Simple task for saving to table.
Extract Login Attempts
SSIS Expression:=FINDSTRING(ROW, “Datazen.Server.Core.Providers.AdAuthentificationProvider Attempt AD FindByIdentity:”,1)>0
Get Username and Date
USER_NAME=REPLACE(ROW, “Datazen.Server.Core.Providers.AdAuthentificationProvider Attempt AD FindByIdentity:”,””)