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