Hi,
1. Find out which users are doing this, and talk to them
2. Ask the user about the info they need, and provide built-in
functionality to efficiently provide this to them
3. Move your users to the web client
4. Analyze the queries the users make and try to supply good indexes
5. Archive data from your main form when it is no longer needed on a daily
basis
6 ...
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> hi all once again,
>
> We did the server side setting for 1000 records to return but now our
> main performance issue is still not resolved as the user can still run a
> macro and few macros end up into very complex queries firing on the
> database
> which hogs the database bandwidth and hence our AR Server turns crazy.
>
> All in all the idea to restrict the number of result records does not
> restrict the user from doing the actions that will fire complex queries
> via
> macro.
>
> now my question is there any way to disable the functionality to run macro
> for the user via user tool??
>
> sounds ridiculous but well thats what we need as of now? any idea any one?
>
> Thanks,
> Viki
>
> Viki_kulkarni wrote:
>>
>> hi all,
>>
>> Thanks guys i think the server side restriction is working well..
>>
>> regards,
>> Viki
>>
>> Misi Mladoniczky wrote:
>>>
>>> Hi,
>>>
>>> If you are trying to limit access in that way, it is probably the wrong
>>> way.
>>>
>>> If you really need to limit the number of records returned, listen to
>>> Fred
>>> Grooms, do it on the server side.
>>>
>>> The other way to limit things are by permissions.
>>>
>>> The client side limit is always advisory. You can write API-programs or
>>> something to circumvent that kind of limitation.
>>>
>>> Macros look exactly the same to the server as ordinary user activity.
>>>
>>> Best Regards - Misi, RRR AB, http://www.rrr.se
>>>
>>> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
>>> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
>>> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy
>>> logs.
>>> Find these products, and many free tools and utilities, at
>>> http://rrr.se.
>>>
>>>> hi,
>>>>
>>>> No the names are in place as well. Is there any way we can disable
>>>> macros
>>>> to
>>>> run for any user? I mean is there any server setting to disable macros
>>>> globally.
>>>>
>>>> I am trying to look for it but not able to find anything about it.
>>>>
>>>> Thanks,
>>>> viki
>>>>
>>>>
>>>> Misi Mladoniczky wrote:
>>>>>
>>>>> Hi,
>>>>>
>>>>> Could it be that you have different server names in the Macro and in
>>>>> your
>>>>> Login? For example a hostname, IP-address or a fully qualified
>>>>> hostname?
>>>>>
>>>>> Best Regards - Misi, RRR AB, http://rrr.se
>>>>>
>>>>>> I too tried this on my 75 environment and it seems to work. Also one
>>>>>> more
>>>>>> strange think it is not happening for all forms..
>>>>>>
>>>>>> I changed the form to search with a similar macro and on that form
>>>>>> it
>>>>>> did
>>>>>> honor..
>>>>>>
>>>>>> Am i missing something??
>>>>>>
>>>>>> thanks,
>>>>>> Viki
>>>>>>
>>>>>> Misi Mladoniczky wrote:
>>>>>>>
>>>>>>> Hi,
>>>>>>>
>>>>>>> I recall that some settings could be changed during macro recording
>>>>>>> in
>>>>>>> the
>>>>>>> past. Apparently not the max-records-returned setting...
>>>>>>>
>>>>>>> I tried this on my 7.6.03 environment.
>>>>>>>
>>>>>>> The Macro honored the setting for my user regardless of the setting
>>>>>>> during
>>>>>>> the actual macro recording. This seems to be at odds with what you
>>>>>>> are
>>>>>>> seeing.
>>>>>>>
>>>>>>> I would not expect the version of the server to affect this.
>>>>>>>
>>>>>>> Best Regards - Misi, RRR AB, http://www.rrr.se
>>>>>>>
>>>>>>> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
>>>>>>> * RRR|License - Not enough Remedy licenses? Save money by
>>>>>>> optimizing.
>>>>>>> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy
>>>>>>> logs.
>>>>>>> Find these products, and many free tools and utilities, at
>>>>>>> http://rrr.se.
>>>>>>>
>>>>>>>> hi Misi,
>>>>>>>>
>>>>>>>> it still gives me more than 1000 records..
>>>>>>>>
>>>>>>>> Thanks,
>>>>>>>> Vikrant
>>>>>>>>
>>>>>>>> Misi Mladoniczky wrote:
>>>>>>>>>
>>>>>>>>> Hi,
>>>>>>>>>
>>>>>>>>> Try recording a new macro where you actually go in and change
>>>>>>>>> this
>>>>>>>>> setting
>>>>>>>>> to 1000 during the recording.
>>>>>>>>>
>>>>>>>>> You may have to set it to something other than 1000 before you
>>>>>>>>> start
>>>>>>>>> the
>>>>>>>>> recording...
>>>>>>>>>
>>>>>>>>> Best Regards - Misi, RRR AB, http://www.rrr.se
>>>>>>>>>
>>>>>>>>> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
>>>>>>>>> * RRR|License - Not enough Remedy licenses? Save money by
>>>>>>>>> optimizing.
>>>>>>>>> * RRR|Log - Performance issues or elusive bugs? Analyze your
>>>>>>>>> Remedy
>>>>>>>>> logs.
>>>>>>>>> Find these products, and many free tools and utilities, at
>>>>>>>>> http://rrr.se.
>>>>>>>>>
>>>>>>>>>> hi all,
>>>>>>>>>>
>>>>>>>>>> I have a macro running on a form that searches for all records
>>>>>>>>>> on
>>>>>>>>>> the
>>>>>>>>>> form
>>>>>>>>>> which has more than 1000 records.
>>>>>>>>>> now we have set the max number of records to retrieve = 1000 in
>>>>>>>>>> the
>>>>>>>>>> user
>>>>>>>>>> tools option.
>>>>>>>>>>
>>>>>>>>>> what we see is that when we make a search call explicit on that
>>>>>>>>>> form
>>>>>>>>>> we
>>>>>>>>>> get
>>>>>>>>>> only 1000 records as per the settings but if we perform the same
>>>>>>>>>> search
>>>>>>>>>> via
>>>>>>>>>> a simple search macro we get more than 1000 records in fact we
>>>>>>>>>> get
>>>>>>>>>> the
>>>>>>>>>> actual number of records.
>>>>>>>>>>
>>>>>>>>>> can any one share any idea how to avoid this?? we are on ARS
>>>>>>>>>> 5.0.1
>>>>>>>>>> and
>>>>>>>>>> user
>>>>>>>>>> tool is 701.
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Thanks,
>>>>>>>>>> Viki
>>>>>>>>>> --
>>>>>>>>>> View this message in context:
>>>>>>>>>> http://old.nabble.com/Macro-not-honoring-the-data-retrival-settings-tp30716698p30716698.html
>>>>>>>>>> Sent from the ARS (Action Request System) mailing list archive
>>>>>>>>>> at
>>>>>>>>>> Nabble.com.
>>>>>>>>>>
>>>>>>>>>> _______________________________________________________________________________
>>>>>>>>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>>>>>>>>> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>> _______________________________________________________________________________
>>>>>>>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>>>>>>>> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> View this message in context:
>>>>>>>> http://old.nabble.com/Macro-not-honoring-the-data-retrival-settings-tp30716698p30716858.html
>>>>>>>> Sent from the ARS (Action Request System) mailing list archive at
>>>>>>>> Nabble.com.
>>>>>>>>
>>>>>>>> _______________________________________________________________________________
>>>>>>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>>>>>>> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>>>>>>>>
>>>>>>>
>>>>>>> _______________________________________________________________________________
>>>>>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>>>>>> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>>>>>>>
>>>>>>>
>>>>>>
>>>>>> --
>>>>>> View this message in context:
>>>>>> http://old.nabble.com/Macro-not-honoring-the-data-retrival-settings-tp30716698p30717307.html
>>>>>> Sent from the ARS (Action Request System) mailing list archive at
>>>>>> Nabble.com.
>>>>>>
>>>>>> _______________________________________________________________________________
>>>>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>>>>> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>>>>>>
>>>>>
>>>>> _______________________________________________________________________________
>>>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>>>> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>>>>>
>>>>>
>>>>
>>>> --
>>>> View this message in context:
>>>> http://old.nabble.com/Macro-not-honoring-the-data-retrival-settings-tp30716698p30718799.html
>>>> Sent from the ARS (Action Request System) mailing list archive at
>>>> Nabble.com.
>>>>
>>>> _______________________________________________________________________________
>>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>>> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>>>>
>>>
>>> _______________________________________________________________________________
>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>>>
>>>
>>
>>
>
> --
> View this message in context:
> http://old.nabble.com/Macro-not-honoring-the-data-retrival-settings-tp30716698p30748303.html
> Sent from the ARS (Action Request System) mailing list archive at
> Nabble.com.
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
