Run process to open FORM on second server
Hi ARSlist users, *BackGround*: Have a Prod app and Rpt server. SQL level replication is enabled to replicate data b/w the 2 in real time. ARADMIN access is disabled on RPT to avoid users updating records. *Issue:* Users are performing free text searches on Notes field, Resolution and summary field of Incident Form leading to timeout errors. *Proposed solution:* Plan is to provide a button on Prod Incident form. By pressing this button, Active Link will fire and open incident FORM on Reporting, where users can perform adv searches. This will work only if user have same access in both Prod and RPT. *Road Block*: Since data is getting replcated from Prod to Rpt, so users permissions also get replicated from Prod to RPT. Now each access is connected to server license so the permission replicated to Reporting is connected to Prod server and reporting server license. As a result even though user have admin access in Prod, it will work as Read only account on Reporting. (ARADMIN is locked on RPT and needs a CRQ to remove this lock for even account that needs to be udpated on Rpt). If there is a RUN Process command that can be used in AL so we can pass a authentication, then i can hard code a generic account (which has all needed ITSM access) and that should do the trick. Any help is appreciated. Alternate solutions are also welcome. Regards, Kumar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Reg: Data Comparison
Hi List, My client is facing a bit of configuration data mismatch issue. As we have Remedy Process Engine installed, we have loads of configuration that is done which runs the workflow. Every time we move the configuration data from Dev to UAT or UAT to Pre Prod, business team has got no confidence in data integrity. Due to some past experience hey had, they do not trust Remedy Import tool and needs a second opinion as the data is huge and they want to be doubly sure. So could anyone of you suggest any third party tool that can compare the data b/w two environments if form name is provided? (Other then panacea, as my client can't afford it) Environment: ARS 6.3, CS 5.6, Process Engine, SQL 2000. Regards, AV ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Instance ID
Hi Arlist, I have ARS 6.03 installed on SQL 2000. Some of the instance Id's produced by Remedy inclueds characters like '[' (ex: SH00110A5FEA769fTbRgY[X4QgbTsG) which are unable to be resolved by SQL 2000. Please let me know if i can restrict the system to generate instance ID independent of '[' character, if not is their a way in which SQL 2000 can read this data. Awaiting a speedy reply, Regards, AV ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Instance ID
Hi Arlist, I have ARS 6.03 installed on SQL 2000. Some of the instance Id's produced by Remedy inclueds characters like '[' (ex: SH00110A5FEA769fTbRgY[X4QgbTsG) which are unable to be resolved by SQL 2000. Please let me know if i can restrict the system to generate instance ID independent of '[' character, if not is their a way in which SQL 2000 can read this data. Awaiting a speedy reply, Regards, AV ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Reg: Deletion of Cases
I need to delete data from my UAT environment which is used by more then 40 testers. I have a data of around 12k out of which i am looking to delete 10k cases. I have created an excalation to delete only one entry (escaltion running every min) but still it doesn't work. RUN IF: 'Issue ID' = "CASE01008123" RUN PROCESS: $PROCESS$ @@ :Application-Delete-Entry "SPRT:ISSUE" $Issue ID$; The escaltion logs says: process passed. Regards, AV On 8/22/07, Marc Simmons <[EMAIL PROTECTED]> wrote: > > ** AV, > > The "Run If" qualification would find the records to delete. Then all you > need is an "If" action that does a "Run Process" with the command line > syntax being: > > Application-Delete-Entry <*form_name*> <*entry_ID* > > > Marc Simmons > > > On 8/22/07, remedy arlist <[EMAIL PROTECTED]> wrote: > > > ** Hi List. > > > > We are using Remedy Customer Service product 6.0. I am > > required to delete cases older then a specific date using a escalation. But > > i am not able to get it working. The Escalation has the below mentioned SQL > > statement. > > > > DELETE * from SPRT_Issue where Issue_ID = 'CASE1234' > > > > Please help me achieve the same. > > > > Regards, > > > > AV > > __20060125___This posting was submitted with HTML in > > it___ > > > > > -- > Marc Simmons > Remedy Administrator > > "Everyday above ground is a good day... the rest is a choice!" > __20060125___This posting was submitted with HTML in > it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Is there a way to logoff users if logged in and did not use the system for more than an hour
Could you help me to understand where and how you confirgured this.(1 Hr lockout). I am also looking out for something like this AV On 8/22/07, Syed Basith (sbasith) <[EMAIL PROTECTED]> wrote: > > > Hi all, > > We have some issues with the Floating License and the want the users to > be logged of from the system if he is connected and not used for form > than one hour. I set the Floating License Timeout to one hour. Will this > help or is there any other way to logoff the user if he is not using ? > > Thanks > > Syed Abdul Basith > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Deletion of Cases
Hi Guys, The command Application-Delete-Entry "$SCHEMA$" $Request ID$; can be used to perform single delete only. Do anyone knows how to perform deletion for bulk of data. Using of create date less then a specific date was not a bull's eye in my case. Please advice. Regards, AV On 8/22/07, CONDREA, Daniel <[EMAIL PROTECTED]> wrote: > > ** Hi All, > > Suppose that you need to trim records in a form named Form1. > > Open Admin tool. Search for CleanupAlertEvents escalation. Save > CleanupAlertEvents escalation as CleanUpForm1. Modify CleanUpForm1 to run on > Form1. > > The run if condition for CleanUpForm1 shoud be: > > ( 'Create Date' + (((30 * 24) * 100) * 60)) <= $TIMESTAMP$ > > Best regards, > Daniel > > -- > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *remedy arlist > *Sent:* Wednesday, August 22, 2007 11:37 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Reg: Deletion of Cases > > > ** Hi List. > > We are using Remedy Customer Service product 6.0. I am required > to delete cases older then a specific date using a escalation. But i am not > able to get it working. The Escalation has the below mentioned SQL > statement. > > DELETE * from SPRT_Issue where Issue_ID = 'CASE1234' > > Please help me achieve the same. > > Regards, > > AV > __20060125___This posting was submitted with HTML in > it___ > __20060125___This posting was submitted with HTML in > it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Reg: Deletion of Cases
Hi List. We are using Remedy Customer Service product 6.0. I am required to delete cases older then a specific date using a escalation. But i am not able to get it working. The Escalation has the below mentioned SQL statement. DELETE * from SPRT_Issue where Issue_ID = 'CASE1234' Please help me achieve the same. Regards, AV ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"