The Auditing tab enables you to establish audit logging for Initiate® interactions and the users performing these interactions. Logging is set individually for each interaction and can be set at one of three levels:
For example, assume that the MemPut interaction is set to “Member.” IBM® Initiate Inspector user “johnbell” retrieves a record for Patty Countryman. During the review of the record, johnbell changes the home phone number attribute and saves the record. A record of this transaction is written in the Hub database MPI_audxmem table.
You can view audit information in directly from the database via SQL. The following is sample SQL that can be used to extract the information:
select u.usrlogin as "User ID", a.audctime as "Activity Time",
s.srccode as "Source", h.memidnum "ID", i.ixnlabel as "Activity"
from mpi_usrhead u, mpi_audhead a, mpi_srchead s,
mpi_memhead h, mpi_audxmem x, mpi_ixnhead i
where u.usrrecno = a.usrrecno
and x.audrecno = a.audrecno
and x.memrecno = h.memrecno
and s.srcrecno = h.srcrecno
and i.ixnrecno = a.ixnrecno
To limit the results to a single user, add the following to the end of the above statement:
and a.usrid = 'rwuser'
The output from the above query (requesting all users) will be similar to:
rwuser 2005-07-29 11:33:15.000 RMC 870504 Search Members
rwuser 2005-07-29 11:33:15.000 RMC 558090 Search Members
rwuser 2005-07-29 11:33:15.000 PHYS 76690 Search Members
rwuser 2005-07-29 11:33:15.000 PHYS 899000 Search Members
billp 2005-07-29 11:33:15.000 ARH 1003702 Search Members
rwuser 2005-07-29 11:33:43.000 RMC 279776 Search Members
rwuser 2005-07-29 11:33:43.000 RMC 788888 Search Members
billp 2005-07-29 11:33:43.000 FGH 266785 Search Members
billp 2005-07-29 11:33:43.000 OUTP 111256 Search Members
rwuser 2005-07-29 11:33:43.000 ARH 278867 Search Members
rwuser 2005-07-29 11:33:43.000 MH 271268 Search Members