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