Joe, We do this. (And more) The user activity log also could be used to log things like what data records the users was looking at. If the modified the record, if they pushed a specific button or not. (Basically just a form that is "open at submit" and active links do PUSH actions to create records. Add a push action where you want to do logging. Window Open, Active link, on interval, etc...) We even records client type, client version info too. :)
The only thing to be concerned about is data growth and system performance. (creating 10,000,000 records in a single table may not be the best thing to do searches against for every user when they want to open a new form. :) However, performance is generally a solvable problem with enough time and resources. :) And once the data is collected you can slice and dice it many different ways. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. Never ascribe to malice, that which can be explained by incompetence. On 7/20/06, Joe DeSouza <[EMAIL PROTECTED]> wrote:
** Roger, Interesting requirement... How about storing the name of the schema the user opens in db table and everytime a user opens a form up it stores that form name against his login name in a record if he has never opened that form before and sets a counter of the number of times he has opened it to 1. If they open it again increase that counter by 1... This could be done with a shared workflow, by excluding window opens if the open is via a DIALOG as that might not be a true representation of it being his favourite form... Exclude the home page too from this... Have the top 10 forms opened by this user by building a view form from a db view of this table... Hope this helps.. Regards Joe D'Souza Remedy Developer / Consultant, BearingPoint, Time Warner Cable Project, Virginia. ----- Original Message ---- From: "Nall, Roger" <[EMAIL PROTECTED]> To: [email protected] Sent: Thursday, July 20, 2006 4:28:04 PM Subject: Form Favorites ** ASR 6.3 patch 16 WIN2K SQL2K Does anyone know if there was a change to the way favorites are stored in the User tool in 6.0 or later? Thanks, Roger A. Nall OSSNMS Sr. Remedy Administrator/Developer T-Mobile USA Desk: 973-644-3963 Cell: 973-652-6723 FAX: 973-490-3296 sf49fanv AIM IM RogerNall Yahoo IM __20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
