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_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
