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