Sure, you can send it to me - thanks! David
> -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David > Sent: Monday, November 19, 2012 4:16 PM > To: arslist@ARSLIST.ORG > Subject: Re: License analysis utitily to run locally > > David, > > I can send you that filter. You would need to define the number and who > should be notified. > > Dave > > On Nov 19, 2012, at 3:53 PM, "David Durling" <durl...@uga.edu> wrote: > > > Thanks, Dave. I might take your idea of monitoring the Server > > Statistics form on floating usage one day - > > > > David > > > >> -----Original Message----- > >> From: Action Request System discussion list(ARSList) > >> [mailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David > >> Sent: Friday, November 16, 2012 2:19 PM > >> To: arslist@ARSLIST.ORG > >> Subject: Re: License analysis utitily to run locally > >> > >> The free RRR version is online. You purchase you can run locally. > >> > >> Since it's tied to custom form it may not be that useful to you. > >> It's two filters (one for modify and one for submit) that updates a record > in a collector form. > >> It generates a count of the number of times an individual submits or > >> modifies a record in various forms during an hour. The count is not > >> as important as they actually performed an action that requires a > >> license within an hour. My perl script looks at how often a person > >> used a license within a given time period (normal business hours) over a > set time period. > >> > >> Since we are a global company, our highest usage of floating licenses > >> is between 9:00 AM and 11:00 AM. (This data can be found in the > >> Server Statistics form when enabled). > >> > >> So the perl script counts the number of times that an individual > >> creates/modifies at least one record within a given hour from 9:00 AM > >> up to > >> 11:00 AM, Monday through Friday, for say the last 8 weeks. (Our > >> greatest impact on licenses is from the US so we exclude US holidays > >> from the > >> analysis.) Since we are looking at a 2 hour block each day, 5 days a > >> week, over 8 weeks, the perl script can actually convert this to a > >> percentage of time, the person has needed a license to do their job > >> within that time period. The script also retrieves if the person has a > >> float > or a fixed license. > >> > >> We have a filter added to the Server Statistics form that triggers > >> based on 'Floating Write Lic Connections' greater than a certain > >> value to let us know when we are getting tight on licenses. When > >> that happens we will run the script to figure out how to rebalance > fixed/floating licenses. > >> > >> Misi's product uses a slightly different approach. His takes it up a > >> notch and looks at login and license release. His routine can also > >> give you a suggested fixed/floating count and with the paid version > >> who should have a fixed vs a floating. > >> > >> Dave > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"