I wrote something with java api a few years back that would track the user login, license consumed, whether they were denied a token because there were not enough available at the time, and then correlate it with which company/org, and other things that mattered in an MSP environment. It ran as java plugin and updated data into data form(s) in Remedy for historical purposes. This is independent of ITSM, user log, and statistics. It was a fun bit of code to write. I don't have it any longer but if there is enough interest I'm sure I could reconstitute it.
Eric Roys Solutions Engineer Avnet Services (formerly Seamless Technologies Inc.) [email protected] www.seamlessti.com -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Misi Mladoniczky Sent: Monday, October 28, 2013 2:56 PM To: [email protected] Subject: Re: How to determine when a user last logged in Hi, Even more importantly, from a cost perspective, the AR System Historical License Usage form does not track FLOATING-READ licenses, only FIXED-WRITE and FLOATING-WRITE... Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > 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, [email protected] < > [email protected]> 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* <[email protected]> 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 >> "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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" CONFIDENTIALITY NOTICE: This email communication is intended only for the personal and confidential use of the recipient(s) designated above and may contain information which is subject to Federal and/or State privacy laws. In the event that you are not the intended recipient or the agent of the intended recipient, you are hereby notified that any review, disclosure, or use of the information contained herein is strictly prohibited. Do not copy or use the information contained within this communication, or allow it to be read, copied or utilized in any manner by any other person(s). If you have received this communication in error, please notify the sender immediately, either by response e-mail or by phone, and permanently delete the original e-mail, any attachment(s), and copies. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"

