Check out two forms: AR System Administration:Manage User Licenses AR System Administration:Lisense Review /Rune Sorlid
2013/3/18 Karthick <[email protected]> > ** > Hi, > > Let me check on that if I try to workflow I ll let you know. Thanks once > again. > > Sent from my iPhone > > On 18-Mar-2013, at 5:35 PM, Bira Mata <[email protected]> wrote: > > ** I'm still working on this option as well, as I want to capture the > current login. because the current login is a display only form and gets > this information from a file it isn't in the database so it can't be query. > My colleague and I have an idea to develop a workflow to get its > information from the file. just haven't worked yet but it's expect to work > fine. If you can just go for it and share with us > =] > > > On Mon, Mar 18, 2013 at 5:23 PM, Karthick <[email protected]> wrote: > >> ** >> Hi, >> >> Is that possible to capture the last logged and current login. Whether >> the user is currently using remedy or not for more than one month. >> >> Sent from my iPhone >> >> On 18-Mar-2013, at 4:53 PM, Karthick <[email protected]> wrote: >> >> Thanks a lot , let me check and update on the same. >> >> Sent from my iPhone >> >> On 18-Mar-2013, at 3:39 PM, Bira Mata <[email protected]> wrote: >> >> ** I never tried to monitor it. But when I need to get some information I >> do a query into the db. you can try to run the query and create a stored >> procedure to run it periodically and exporting to a file then use any >> monitoring product to read it to you >> >> here is the query that I run >> >> select m.Full_Name,m.login_name,n.Group_Name,m.Email_Address,n.Group_Name, >> case when m.License_Type ='1' then 'Fixed' else 'Floating' end as >> License_Type >> from Group_x n, User_x m >> where m.Group_List like '%;'+ CONVERT(varchar, n.Group_ID) + ';%' >> and m.License_Type like '[1-2]' and n.Group_Name not like '[0-9]%' >> order by m.Full_Name asc >> >> =] >> >> Bira >> >> On Mon, Mar 18, 2013 at 2:48 PM, Karthick <[email protected]> wrote: >> >>> > Hi All, >>> > >>> > Can any one help me in monitoring the license usage for individual >>> user jn remedy. >>> > >>> > Really I don't want to try the free utility to monitor the license >>> usage, is there any other way to check the license usage >>> > >>> > Remedy Environment: >>> > >>> > Remedy ARS : 7.1 >>> > DB : SQL 2005 >>> > Platform : Windows 2003 >>> > >>> > >>> > Sent from my iPhone >>> >>> >>> _______________________________________________________________________________ >>> 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_ >> >> _ARSlist: "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"
