Message from David Slimmon via eLinkHi everyone,Had to put together a silly little LiveReport recently which has been reallyhandy for us here at Open Text and I thought I'd share it with everyone.The question was asked, "Can you generate a LiveReport to show me whichlogins have been created by X user". Originally, I thought this might be inthe DAudit table, but it's not. The best bet is just to go straight to theUser table (KUAF) and look for the OwnerID.For example:select * from Kuaf where OwnerID=X and TYPE=0Will show the list of users that have been created where X = the ID of theperson you're interested in Auditing!Handy...Cheers,Dave___________________________________________O P E N T E X T C O R P O R A T I O NDavid Slimmon, M.L.I.S.Supervisor - Customer Support
https://knowledge.opentext.comdslimmon@opentext.com
