Auditing

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:

• None turns the logging off.
• Activity logs the user or system name performing the interaction along with the date and time.
• Member is the most extensive level of logging. This means that the user/system name, date, time, member record affected, and value changes are logged.

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