Hi Tony,
This is easy if you create a simple data form and an active link that gets attached to all your active forms used by your users on Window open. I have created such a form for the same reason and it works well. You can use archiving to clear old data from this form. Also make sure you add the right permissions to the Active Link, form and fields. The entire exercise should take a matter of minutes to develop. Not a big job! For your particular purpose, you might even go a step further and create a second form that only tracks the last transaction per user in the first form and gets updated by an escalation once a day to make it easy to get a report on the info you want or to automate the account expiry workflow. I have created a couple of extra fields on the form we use, that also gets populated with standard keywords, and the stats we get from that is great! It has some other uses in terms of, for example, performance tuning, as well! The performance hit on this is negligible if you delete old data daily. Best Regards, Theo From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: 28 October 2013 21:26 To: arslist@ARSLIST.ORG Subject: Re: How to determine when a user last logged in ** Terry, One problem I have with the BMC's provided historical license usage form is that it doesn't cover 'all' users...only users with write licenses...why does this matter you ask? Well, Read and Read Restricted users are completely valid users of the system, but because their licenses don't cost anything, BMC doesn't deign it necessary to track their usage. As such, you can't track 'all' of your users through this method. A simple Active Link that makes a service call to a login audit form any time 'selected' forms are opened will track all of your users that utilize 'main' forms. On Mon, Oct 28, 2013 at 11:30 AM, tboot...@objectpath.com <mailto:tboot...@objectpath.com> <tboot...@objectpath.com <mailto:tboot...@objectpath.com> > wrote: ** You can investigate this: On the ARSystem Server configuration tab - enable the field : License Tracking Peridocially check the form called " ARSystem Administration: License Review" form for entries (userids) that do not appear in this form that appear in your User or appropriate CTM:People form. A quick outer join would give you the details. Check the admin manual for details on the License Tracking setting. Terry on Oct 28, 2013, SUBSCRIBE ARSLIST theReel <tony.r...@bt.com <mailto:tony.r...@bt.com> > wrote: Hi Guys, Is there a way to determine when a user last logged into Remedy/ITSM without having to enable the user logs. Basically I want to identify any user accounts that have not logged into Remedy in X months. We have a multi-tenant ITSM 8.1 environment and do not have full control of our user base leaving procedures. So if someone with a Remedy account was to leave one of our customers and they do not notify us then that persons account will remain active. To mitigate against this we are planning to supply the customers with an active users report to check and want to include the last time they each logged on and any other useful information. There is the user-cache table which has a timestamp column but that only seems to be updated when the user account is updated/changed and not when they login. Any ideas how I could achieve this or how do you identify unused accounts? Thanks Tony ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org <http://www.arslist.org> "Where the Answers Are, and have been for 20 years" _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"