Most environments, including multi-tenant environments, use Active Directory or an outside data source (Peoplesoft, Oracle Apps, etc.) to manage People entries and hence access. If that is the case with your environment, I strongly suggest that you reconcile against the outside data on a nightly or weekly basis rather than just allow it as a one-way feed. Why? I've been in environments that attempted to do what you are and the reality is that some users only use Remedy once in a blue moon. Several months go by and they need it for some sort of service request or to check on the validity of a complaint or something of the sort. When it happens, it is important to them that they access it without a problem but if you rely on usage records, they can be improperly inactivated which happened with an executive that was never in the system for one of my clients. Though these type of problems can be easily corrected by either activating or re-entering a person, the initial lockout can result in a lot of unnecessary pain and badmouthing of the system (which was the case with the executive).
With that being said, in addition to (not replacement of) the suggestions previously mentioned, you can generate a License Usage Report without starting or enabling anything. The servers collect the information on a 45 minute interval if I recall correctly. Though it captures counts on all the different license types except for Read and Read Restricted, it does give the user names of those with Fixed license types over the indicated date range whether you've tracked them or not. It's something if you have not had anything on since now. The report is generated through the Administration Console in the Add/Remove Licenses option. Good luck! On Monday, October 28, 2013 6:31 PM, Eric Roys <[email protected]> wrote: ** LJ, Sounds about right. I’m sure there was probably additional extrapolation beyond that even. Like I said, it’s been a few years. (early version 7ish). -Eric From:Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ LongWing Sent: Monday, October 28, 2013 4:07 PM To: [email protected] Subject: Re: How to determine when a user last logged in ** Misi, About a year ago I figured out a way to determine Floating-Read users. There are two methods (in Java)...one is .getLicenseType(), which gives you the users license type, then there is another of .getCurrentLicenseType(), which at least in the case of Floating users, if they are assigned a floating license, but don't currently have one assigned, the .getCurrentLicenseType() gives you a value of Constants.AR_LICENSE_TYPE_NONE. With this info I determine them to be Floating Read, instead of Floating Write. Hope that helps :) On Mon, Oct 28, 2013 at 2:53 PM, Misi Mladoniczky <[email protected]> wrote: Hi, Unfortunately the UserInfo-API-call does not give you information about if a FLOATING-READ has been granted because of a lack of licenses on the server, or because the user did not yet access any form data. I have also written a polling tool that produces a log file based periodic API-calls. Except for the above mentioned lack, it works great. 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/. > 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] > http://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 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_ >> >> ______________________________________________________________________ >> _________ UNSUBSCRIBE or access ARSlist Archives at http://www.arslist.org/ >> "Where the Answers Are, and have been for 20 years" >> > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at http://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 http://www.arslist.org/ > "Where the Answers Are, and have been for 20 years" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at 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_ 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. _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"
