+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, Eportal Audit Trail query in Technical; I'm trying to fish some information out of the audittrail table via sql. Actions taken by a user in Eportal ...
  1. #1
    ChrisJ's Avatar
    Join Date
    Mar 2006
    Location
    Birmingham
    Posts
    136
    Thank Post
    37
    Thanked 19 Times in 18 Posts
    Rep Power
    21

    Eportal Audit Trail query

    I'm trying to fish some information out of the audittrail table via sql.

    Actions taken by a user in Eportal to be precise. However this table returns the ePortal username value eg. sta001aff (UserRespon in AUDITTRAIL).

    Does anyone know of a table that might contain this username value alongside the staff ID?

    I'm wanting to return the staff name as part of my query rather than having to look at the resource passwords list in Facility.

    I've looked in RESPASSWORDS and can see that has an encrypted value PwdData that is linked to the staff ID. Knowing my luck the username is scrambled in that.

    Anyone managed to find what I'm after in the maze of Facility tables?

  2. #2

    Join Date
    Jun 2007
    Location
    Wakefield, West Yorkshire
    Posts
    626
    Thank Post
    96
    Thanked 130 Times in 101 Posts
    Rep Power
    67
    You're right in what you said, it's encrypted. The only thing I can think of is that you populate your own table in another db manually containing the userid and the staff name so that you can then automate the dump of data from audittrail. I would expectusernames will rarely change and new ones will be created on large at certain times of year. It's not perfect but it's a workaround. May I ask why you're doing this, out of interest?

  3. #3
    ChrisJ's Avatar
    Join Date
    Mar 2006
    Location
    Birmingham
    Posts
    136
    Thank Post
    37
    Thanked 19 Times in 18 Posts
    Rep Power
    21
    Thought that might be the case. I found all the information I needed, just wanted to see if I could get a bit more. I'll explain my logic in a PM.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Tutorial "Audit Trail"
    By DeeGee in forum MIS Systems
    Replies: 4
    Last Post: 13th April 2012, 02:21 PM
  2. IEP Writer - Audit-trail reviews
    By Rammie in forum MIS Systems
    Replies: 2
    Last Post: 1st December 2011, 03:23 PM
  3. Audit trails - Does your MIS have them?
    By pete in forum MIS Systems
    Replies: 24
    Last Post: 15th November 2011, 09:10 AM
  4. Exchange Server 2003 licensing query
    By tarquel in forum Windows
    Replies: 5
    Last Post: 4th July 2005, 01:56 PM
  5. EZ_GPO usage and helpfulness query
    By tarquel in forum Windows
    Replies: 6
    Last Post: 21st June 2005, 02:00 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •