Re: Enhancement: Schema ID on AR Admin tool...
Remedy had(has?) a tool to convert sql logfile schemaid's and fieldis to schemanames and fieldnames. -- Jarl On 10/23/06, Joe DeSouza <[EMAIL PROTECTED]> wrote: ** Troubleshooting one of my customers application for performance, so since SQL logs show T on SQL logs, I have to query the arschema table all the time before opening the form in question in the Admin tool.. which is where I found that if the admin tool listed the schemaId's with their corresponding schema Id's, it would have been easier for me to identify the form by the ID instead of its name.. also it would have been nice to have the View by feature modified to show a form or a list of forms by schema ID's.. Personally I do not think it will be too hard to modify the Admin tool code to display the schemaid along with the schema name.. Rgds Joe D'Souza Remedy Developer / Consultant, Shyle Networks, New Jersey. - Original Message From: Axton <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Sunday, October 22, 2006 11:53:21 AM Subject: Re: Enhancement: Schema ID on AR Admin tool... It would be nice, would also be nice to see a list of forms/fields a menu is attached to. Joe, what are you doing where the schemaid would be useful? In my direct sql workflow, I set an integer field to the schemaid and use that as a variable in the direct sql action. I do this because the schemaid can vary from server to server. I refrain from using the views for several reasons (the naming has changed in the past; permissions get dropped from views on each form change; etc.). Axton Grams On 10/22/06, Jarl Grøneng <[EMAIL PROTECTED]> wrote: > I dont see the problem. Active links can be a part of unlimited number of forms. > > This is an enhancment I would like to se. I had to create a sql-stmt > to list which active links and filters that are not part of a guide > > -- > Jarl > > > On 10/22/06, Joe D'Souza <[EMAIL PROTECTED]> wrote: > > That might be nice but you got to remember that an AL or a filter could be a > > part of more than one guide... and I do not think there is a limit to the > > number of guides you can tie a AL or Filter to... > > > > Joe > > > > -Original Message- > > From: Action Request System discussion list(ARSList) > > [mailto:[EMAIL PROTECTED] Behalf Of Jay Rohrer > > Sent: Saturday, October 21, 2006 8:07 PM > > To: arslist@ARSLIST.ORG > > Subject: Re: Enhancement: Schema ID on AR Admin tool... > > > > > > I would not find that nearly as useful as having a tab on ALs and FILs that > > tell me which Guides they are a part of. > > > > Jay Rohrer __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARServer 7.0.01 SEGV
Yes, had the same on a server ugraded from 5.1.2 to 7.0.1 running on solaris and oracle. The last action in sql log was a select against the Role form. The last action when truss'ing the arserverd was something about display properties. However, when doign the upgrade again and then from 5.1.2 to 6.3, and then to 7.0.1, then the server crash was gone. The server has several forms with web fixed view. -- Jarl On 10/23/06, Axton <[EMAIL PROTECTED]> wrote: Has anyone received an error along these lines when starting ARServer 7.0.01? Mon Oct 23 14:38:18 2006 390600 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Mon Oct 23 14:38:18 2006 11 Timestamp: Mon Oct 23 2006 14:38:18.9069 Thread Id: 4 Version: 7.0.01 200609271856 Sep 27 2006 19:28:30 ServerName: Database: SQL -- Oracle Hardware: sun4u OS: SunOS 5.9 RPC Id: 0 RPC Call: 0 RPC Queue: 390600 Protocol Version: 12 Client IP Address: Logging On: API Escalation Filter SQL User Thread Stacks: /prod/sys/remedyb/bin/arserverd:DumpStackTrace+0x88 /prod/sys/remedyb/bin/arserverd:SignalTrapProc+0x160 /usr/lib/libthread.so.1:0x15bac /usr/lib/libthread.so.1:0xf804 /usr/lib/libthread.so.1:0xf9b4 /usr/lib/libc.so.1:0x4762c [ Signal 11 (SEGV)] /usr/lib/libc.so.1:0x47100 /usr/lib/libc.so.1:malloc+0x20 /prod/sys/remedyb/bin/arserverd:MallocLob+0x110 /prod/sys/remedyb/bin/arserverd:LoadFieldIntoValue+0x428 /prod/sys/remedyb/bin/arserverd:LoadDisplayInfoList+0x46c /prod/sys/remedyb/bin/arserverd:LoadInitialSchemaInfo+0x5d0 /prod/sys/remedyb/bin/arserverd:InitializeServerCache+0xec /prod/sys/remedyb/bin/arserverd:WorkerThread+0x230 /prod/sys/remedyb/bin/arserverd:RestartableThreadMain+0x60 /prod/sys/remedyb/bin/arserverd:UnixThreadStartRoutine+0xe8 /usr/lib/libthread.so.1:0x15854 This happens at startup time, so the server never comes up completely. Environment Info: - Solaris 9 (en_US.UTF8) - Remote Oracle 9i (UTF8) - Oracle 10g client () - ARServer 7.0.01 The arsql.log shows the following as the last select statement during the attempted startup: SELECT schemaId,fieldId,vuiId,propShort,propLong FROM field_dispprop ORDER BY 1 ASC,2 ASC,3 ASC arthread.log shows the following: */ Thread Trace Log -- ON */ Limits found: current rlimit=4096 - max rlimit=4096 */ Thread Id 2 (thread number 0) Thread Manager started. */ Thread Id 3 (thread number 1) timed call thread started. */ Thread Id 4 (thread number 2) on ADMIN queue started. */ Thread Trace Log -- OFF None of the other logs are written to. There is no core file created. One of the following actions may have led to the unstartable application server: - Import view defs from 6.0.1 (web fixed) - Import workflow containing direct sql workflow - Copy views from web fixed to standard - Delete web fixed views - Alter the query field (fid 40076) on FB:Variable (change length from 255 to 3999 chars) - Applied custom CSS tags to fields in the admin tool using the field properties - hide the toolbar - remove the preferences table label from table fields - hide the toolbar for forms for web mode Has anyone else performed any of the above actions on a 7.0.01 server and experienced these issues afterwards? Also, if you have performed any of the above actions and have not had these issues, that info would be helpful as well. This server was working fine all last week, but something happened between the last good start and the bad start, which has to be one of the above actions. Please share what you can. Thanks, Axton Grams ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARS as a development system
Hi All, "Rapid Dev environment" for this reason I hope that soon I get rid of ARS and replace with Windows Workflow Foundation. Regards, Daniel -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of David Charters Sent: 23 October 2006 23:42 To: arslist@ARSLIST.ORG Subject: Re: ARS as a development system I have been a consultant in the Remedy world for 10 years now. I can tell you there are countless companies that use ARS as a development environment. There are also companies (I believe Buoyant Solutions is one) that have developed custom products for sale in ARS. I would say there is huge benefit and it is a standard practice to using it as a Rapid Dev environment. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hendershot,Bruce D. Sent: Monday, October 23, 2006 4:28 PM To: arslist@ARSLIST.ORG Subject: Re: ARS as a development system Rick, Do you think anyone at that bank would be willing to have a phone conversation with me or an email exchange on the subject? Or, If you're willing to share their name with me or my BMC Rep. I'll go through the proper protocol for requesting it. Bruce [EMAIL PROTECTED] -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick cook Sent: Sunday, October 22, 2006 10:00 PM To: arslist@ARSLIST.ORG Subject: Re: ARS as a development system I agree with the Rapid development system. We can build functioning systems in less time than many platforms take to build a prototype. Many of us have done just that. I know of one large national bank that has many of its internal functions and applications built on a custom Remedy platform. They do it in part because of the short time it takes to build and modify them. That adds a nimbleness to their applications, so that they can keep up with a rapidly changing business model. Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Davis, David CTR NAVSURFWARCENDIV Crane, Code 0552 Sent: Sunday, October 22, 2006 3:22 PM To: arslist@ARSLIST.ORG Subject: Re: ARS as a development system Well Bruce, here is a real stretch concerning Remedy as a development tool. How about as a Rapid Development Environment (RDE). Remedy has a lot of the same benefits for rapid development as does MS Access with one better Remedy can create SQL and/or Oracle Data Tables. In truth we use Remedy for all types of applications that require track of actions or tasks. If we want to email notifications and we need escalations to keep track of a particular action items; we use Remedy Action Request System. Remedy has limitations such as document management and complex mathematics functions but all in all we use it to create applications requiring a quite turn-around. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hendershot,Bruce D. Sent: Sunday, October 22, 2006 10:59 To: arslist@ARSLIST.ORG Subject: Re: ARS as a development system I'm resurrecting a topic from several months ago concerning using ARS as a development environment. Over the past 10 years we've used it to build our IT service management tools but also several non IT Service Management applications, some of which were built solely for the business as opposed to being IT internal tools. We'd like to do more of this because we can develop the applications quickly and inexpensively, as opposed to using .Net technologies for example. We would limit it to being used for specific types of applications based on guidelines. The major concern among our IT strategists is that BMC doesn't officially recognize, or at least market it as a general development tool. Another issue is that we have other systems that have workflow components to them such as SharePoint and SAP. I'm interesting in knowing how many shops are using the AR System as a general development tool. If you've gone through the same decision process, what was the result and what were the key drivers that led you to that decision? Thanks. Bruce Hendershot Air Products and Chemicals, Inc. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Tuesday, July 18, 2006 4:13 PM To: arslist@ARSLIST.ORG Subject: Re: ARS as a development system As soon as I saw ITSM 7, I knew that's the direction they were taking. ITSM 4-6 has been around for long enough that there are lots of people who know the app well enough to customize it. This version is not only new to us all, but is bigger. That gives BMC's own P.S. people a leg up on it over partners and in-house developers, especially since training won't be available until late September-ish, which means that for all practical purposes, the expertise won't be wi
Re: Remedy Support Site - STILL broken
** Rick I submitted a ticket about all the issues I am having with the new support website on Friday. I came in to work today to find an email in my Inbox. The support rep who looked at my ticket only stated that he had passed my issues on to management, and opened an internal customer service ticket to deal with the problems I outlined in the email. I am not sure who "management" entails exactly, but have not heard anything more on my issues. Good luck. -James - Original Message From: Rick cook <[EMAIL PROTECTED]>To: arslist@ARSLIST.ORGSent: Monday, October 23, 2006 5:23:24 PMSubject: Remedy Support Site - STILL broken** Still broken, and no word (that I've heard, anyway) from BMC/Remedy on what they're doing about it or an ETA for a fix. I've had tickets open for up to a week now (related to the broken support site) that have not been addressed, and the issues reported are impacting my ability to perform work for my customer. I know I'm not the only one being impacted by this unprecedented incompetence on BMC's part. What makes it worse is the feeling of being ignored. Has anyone even heard anything from a sales rep attempting to placate the masses? I haven't. Any announcement on the Support or front page? Nope. Where's the leadership from BMC in all this? Not where they need to be, that's for sure. Someone at BMC/Remedy want to address those issues with this group? (Hint: NOW would be a good time). Rick Cook Cook Enterprises 253-278-4112__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Remedy Support Site - STILL broken
** I'm glad you got what you needed - my issues go beyond yours, I'm afraid, and no one has even attempted to get me past them. No excuses even offerred. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Lammey, Peter A.Sent: Monday, October 23, 2006 2:42 PMTo: arslist@ARSLIST.ORGSubject: Re: Remedy Support Site - STILL broken ** When I had login issues before I forwarded them to my Sales Rep and eventually got a person to help but I didnt figure out how to solve it until I saw a response from Jim McKenzie on ARSList. On a Support ticket, I did also note to the tech support analyst that I couldnt attach anything to a support ticket but he never noted that as an issue. We just worked on a way to FTP the files to Remedy BMC or if he could obtain them from our FTP site. Thanks Peter Lammey ESPN MIT Technical Services & Applications Management 860-766-4761 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick cookSent: Monday, October 23, 2006 5:23 PMTo: arslist@ARSLIST.ORGSubject: Remedy Support Site - STILL broken ** Still broken, and no word (that I've heard, anyway) from BMC/Remedy on what they're doing about it or an ETA for a fix. I've had tickets open for up to a week now (related to the broken support site) that have not been addressed, and the issues reported are impacting my ability to perform work for my customer. I know I'm not the only one being impacted by this unprecedented incompetence on BMC's part. What makes it worse is the feeling of being ignored. Has anyone even heard anything from a sales rep attempting to placate the masses? I haven't. Any announcement on the Support or front page? Nope. Where's the leadership from BMC in all this? Not where they need to be, that's for sure. Someone at BMC/Remedy want to address those issues with this group? (Hint: NOW would be a good time). Rick Cook Cook Enterprises 253-278-4112__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Remedy Support Site - STILL broken
** When I had login issues before I forwarded them to my Sales Rep and eventually got a person to help but I didnt figure out how to solve it until I saw a response from Jim McKenzie on ARSList. On a Support ticket, I did also note to the tech support analyst that I couldnt attach anything to a support ticket but he never noted that as an issue. We just worked on a way to FTP the files to Remedy BMC or if he could obtain them from our FTP site. Thanks Peter Lammey ESPN MIT Technical Services & Applications Management 860-766-4761 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick cookSent: Monday, October 23, 2006 5:23 PMTo: arslist@ARSLIST.ORGSubject: Remedy Support Site - STILL broken ** Still broken, and no word (that I've heard, anyway) from BMC/Remedy on what they're doing about it or an ETA for a fix. I've had tickets open for up to a week now (related to the broken support site) that have not been addressed, and the issues reported are impacting my ability to perform work for my customer. I know I'm not the only one being impacted by this unprecedented incompetence on BMC's part. What makes it worse is the feeling of being ignored. Has anyone even heard anything from a sales rep attempting to placate the masses? I haven't. Any announcement on the Support or front page? Nope. Where's the leadership from BMC in all this? Not where they need to be, that's for sure. Someone at BMC/Remedy want to address those issues with this group? (Hint: NOW would be a good time). Rick Cook Cook Enterprises 253-278-4112__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Using a 7.0 Midtier with a 5.1.2 Server
** Norm, You didn't specify what patch level of 5.1.2 server you are on. As I remember you had to be at patch 1389 or higher to use the Mid-Tier 6.3 with the 5.1.2 server. Could that be the problem? Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CG/SCWOESent: Monday, October 23, 2006 4:14 PMTo: arslist@ARSLIST.ORGSubject: Re: Using a 7.0 Midtier with a 5.1.2 Server ** Rick, Yes, I've synchronized the passwords in the Admin tool and the Midtier config page. So your suggestion of the 7.0 authentication not playing nice with the old 5.1.2 way was what bubbled to my mind first...but I was hoping we could confirm that to be true. Norm From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick CookSent: Monday, October 23, 2006 3:23 PMTo: arslist@ARSLIST.ORGSubject: Re: Using a 7.0 Midtier with a 5.1.2 Server ** Norm, I think that's probably the result of ARS 7.0 requiring authentication in ways that previous versions of ARS did not. Ensure that in your Admin tool's connection settings, you have set your MT Password. Rick On 10/23/06, Kaiser Norm E CIV USAF 96 CG/SCWOE <[EMAIL PROTECTED]> wrote: ** Hello everyone, Is it possible to use a 7.0 Midtier and a 5.1.2 server? Has anyone ever tried to do such a thing? I know it sounds weird, but I have good reason for trying this. As it stands, I'm getting the "Athentication Failed" error and am wondering if this is due to the old server version not being compatible with the new 7.0 version of the Midtier or if it's because I simply have something misconfigured somewhere. Does anyone know? Thanks, Norm __20060125___This posting was submitted with HTML in it___
Remedy Support Site - STILL broken
** Still broken, and no word (that I've heard, anyway) from BMC/Remedy on what they're doing about it or an ETA for a fix. I've had tickets open for up to a week now (related to the broken support site) that have not been addressed, and the issues reported are impacting my ability to perform work for my customer. I know I'm not the only one being impacted by this unprecedented incompetence on BMC's part. What makes it worse is the feeling of being ignored. Has anyone even heard anything from a sales rep attempting to placate the masses? I haven't. Any announcement on the Support or front page? Nope. Where's the leadership from BMC in all this? Not where they need to be, that's for sure. Someone at BMC/Remedy want to address those issues with this group? (Hint: NOW would be a good time). Rick Cook Cook Enterprises 253-278-4112 __20060125___This posting was submitted with HTML in it___
Re: Using a 7.0 Midtier with a 5.1.2 Server
** Hi, Norm: Did you also check the Authentication Server field on the General Settings page of the Mid-tier Config tool? Michelle From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CG/SCWOESent: Monday, October 23, 2006 4:14 PMTo: arslist@ARSLIST.ORGSubject: Re: Using a 7.0 Midtier with a 5.1.2 Server ** Rick, Yes, I've synchronized the passwords in the Admin tool and the Midtier config page. So your suggestion of the 7.0 authentication not playing nice with the old 5.1.2 way was what bubbled to my mind first...but I was hoping we could confirm that to be true. Norm From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick CookSent: Monday, October 23, 2006 3:23 PMTo: arslist@ARSLIST.ORGSubject: Re: Using a 7.0 Midtier with a 5.1.2 Server ** Norm, I think that's probably the result of ARS 7.0 requiring authentication in ways that previous versions of ARS did not. Ensure that in your Admin tool's connection settings, you have set your MT Password. Rick On 10/23/06, Kaiser Norm E CIV USAF 96 CG/SCWOE <[EMAIL PROTECTED]> wrote: ** Hello everyone, Is it possible to use a 7.0 Midtier and a 5.1.2 server? Has anyone ever tried to do such a thing? I know it sounds weird, but I have good reason for trying this. As it stands, I'm getting the "Athentication Failed" error and am wondering if this is due to the old server version not being compatible with the new 7.0 version of the Midtier or if it's because I simply have something misconfigured somewhere. Does anyone know? Thanks, Norm __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Using a 7.0 Midtier with a 5.1.2 Server
** Rick, Yes, I've synchronized the passwords in the Admin tool and the Midtier config page. So your suggestion of the 7.0 authentication not playing nice with the old 5.1.2 way was what bubbled to my mind first...but I was hoping we could confirm that to be true. Norm From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook Sent: Monday, October 23, 2006 3:23 PM To: arslist@ARSLIST.ORG Subject: Re: Using a 7.0 Midtier with a 5.1.2 Server ** Norm, I think that's probably the result of ARS 7.0 requiring authentication in ways that previous versions of ARS did not. Ensure that in your Admin tool's connection settings, you have set your MT Password. Rick On 10/23/06, Kaiser Norm E CIV USAF 96 CG/SCWOE <[EMAIL PROTECTED]> wrote: ** Hello everyone, Is it possible to use a 7.0 Midtier and a 5.1.2 server? Has anyone ever tried to do such a thing? I know it sounds weird, but I have good reason for trying this. As it stands, I'm getting the "Athentication Failed" error and am wondering if this is due to the old server version not being compatible with the new 7.0 version of the Midtier or if it's because I simply have something misconfigured somewhere. Does anyone know? Thanks, Norm __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: ARS as a development system
I have been a consultant in the Remedy world for 10 years now. I can tell you there are countless companies that use ARS as a development environment. There are also companies (I believe Buoyant Solutions is one) that have developed custom products for sale in ARS. I would say there is huge benefit and it is a standard practice to using it as a Rapid Dev environment. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hendershot,Bruce D. Sent: Monday, October 23, 2006 4:28 PM To: arslist@ARSLIST.ORG Subject: Re: ARS as a development system Rick, Do you think anyone at that bank would be willing to have a phone conversation with me or an email exchange on the subject? Or, If you're willing to share their name with me or my BMC Rep. I'll go through the proper protocol for requesting it. Bruce [EMAIL PROTECTED] -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick cook Sent: Sunday, October 22, 2006 10:00 PM To: arslist@ARSLIST.ORG Subject: Re: ARS as a development system I agree with the Rapid development system. We can build functioning systems in less time than many platforms take to build a prototype. Many of us have done just that. I know of one large national bank that has many of its internal functions and applications built on a custom Remedy platform. They do it in part because of the short time it takes to build and modify them. That adds a nimbleness to their applications, so that they can keep up with a rapidly changing business model. Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Davis, David CTR NAVSURFWARCENDIV Crane, Code 0552 Sent: Sunday, October 22, 2006 3:22 PM To: arslist@ARSLIST.ORG Subject: Re: ARS as a development system Well Bruce, here is a real stretch concerning Remedy as a development tool. How about as a Rapid Development Environment (RDE). Remedy has a lot of the same benefits for rapid development as does MS Access with one better Remedy can create SQL and/or Oracle Data Tables. In truth we use Remedy for all types of applications that require track of actions or tasks. If we want to email notifications and we need escalations to keep track of a particular action items; we use Remedy Action Request System. Remedy has limitations such as document management and complex mathematics functions but all in all we use it to create applications requiring a quite turn-around. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hendershot,Bruce D. Sent: Sunday, October 22, 2006 10:59 To: arslist@ARSLIST.ORG Subject: Re: ARS as a development system I'm resurrecting a topic from several months ago concerning using ARS as a development environment. Over the past 10 years we've used it to build our IT service management tools but also several non IT Service Management applications, some of which were built solely for the business as opposed to being IT internal tools. We'd like to do more of this because we can develop the applications quickly and inexpensively, as opposed to using .Net technologies for example. We would limit it to being used for specific types of applications based on guidelines. The major concern among our IT strategists is that BMC doesn't officially recognize, or at least market it as a general development tool. Another issue is that we have other systems that have workflow components to them such as SharePoint and SAP. I'm interesting in knowing how many shops are using the AR System as a general development tool. If you've gone through the same decision process, what was the result and what were the key drivers that led you to that decision? Thanks. Bruce Hendershot Air Products and Chemicals, Inc. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Tuesday, July 18, 2006 4:13 PM To: arslist@ARSLIST.ORG Subject: Re: ARS as a development system As soon as I saw ITSM 7, I knew that's the direction they were taking. ITSM 4-6 has been around for long enough that there are lots of people who know the app well enough to customize it. This version is not only new to us all, but is bigger. That gives BMC's own P.S. people a leg up on it over partners and in-house developers, especially since training won't be available until late September-ish, which means that for all practical purposes, the expertise won't be widespread until 2007. BMC is basing its business (and therefore sales) model on ITIL buy-in from the customer base. ITSM will get a customer to ITIL compliance far faster than a custom app set would, even if the developers were ITIL-trained. ITIL also works better in an integrated platform solution, which means more product sales. It's not like we can go out and build a
Re: ARS as a development system
Thanks Tayler. We're in a similar situation in that we purchased the AR System about 10 years ago to build our ITSM tools and have since expanded it's scope significantly within IT, but only in a few instances outside of IT. Do you have any documented guidelines stating when it's appropriate to use the ARS? Would you be willing to have a telephone discussion or a direct email exchange to expand on your use for your shared service centres? I completely understand if you'd prefer not to. Time is precious for us IT types these days. Bruce [EMAIL PROTECTED] -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tayler McLean Sent: Monday, October 23, 2006 12:33 AM To: arslist@ARSLIST.ORG Subject: Re: ARS as a development system We have leveraged ARS as a development platform but we were only able to so because we do run ITSM and hence this justified building the Remedy infrastructure and purchasing a large quantity of licenses in the first place. Strategically we are using Remedy to close the loop on all of our shared service centres such as IT (of course), HR, Facilities and Marketing. We are increasingly using Remedy to develop business applications but generally restrict these to some form of 'request tracking system'. We also have a .NET development team and Remedy certainly does have advantages WHERE IT MAKES SENSE. It is easy to support since we already have a large Remedy infrastructure established, and the turnaround time for a functional application is usually less. However, for some small applications it doesn't make sense to use Remedy due to the license costs for users, or if we need more integration options such as advanced web services with other MS applications. The bottom line is that because we have an existing Remedy infrastructure it gives us the option to develop other Remedy applications if it makes sense, and we are more than happy to use Remedy in these cases. Regards, Tayler McLean ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
ARServer 7.0.01 SEGV
Has anyone received an error along these lines when starting ARServer 7.0.01? Mon Oct 23 14:38:18 2006 390600 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Mon Oct 23 14:38:18 2006 11 Timestamp: Mon Oct 23 2006 14:38:18.9069 Thread Id: 4 Version: 7.0.01 200609271856 Sep 27 2006 19:28:30 ServerName: Database: SQL -- Oracle Hardware: sun4u OS: SunOS 5.9 RPC Id: 0 RPC Call: 0 RPC Queue: 390600 Protocol Version: 12 Client IP Address: Logging On: API Escalation Filter SQL User Thread Stacks: /prod/sys/remedyb/bin/arserverd:DumpStackTrace+0x88 /prod/sys/remedyb/bin/arserverd:SignalTrapProc+0x160 /usr/lib/libthread.so.1:0x15bac /usr/lib/libthread.so.1:0xf804 /usr/lib/libthread.so.1:0xf9b4 /usr/lib/libc.so.1:0x4762c [ Signal 11 (SEGV)] /usr/lib/libc.so.1:0x47100 /usr/lib/libc.so.1:malloc+0x20 /prod/sys/remedyb/bin/arserverd:MallocLob+0x110 /prod/sys/remedyb/bin/arserverd:LoadFieldIntoValue+0x428 /prod/sys/remedyb/bin/arserverd:LoadDisplayInfoList+0x46c /prod/sys/remedyb/bin/arserverd:LoadInitialSchemaInfo+0x5d0 /prod/sys/remedyb/bin/arserverd:InitializeServerCache+0xec /prod/sys/remedyb/bin/arserverd:WorkerThread+0x230 /prod/sys/remedyb/bin/arserverd:RestartableThreadMain+0x60 /prod/sys/remedyb/bin/arserverd:UnixThreadStartRoutine+0xe8 /usr/lib/libthread.so.1:0x15854 This happens at startup time, so the server never comes up completely. Environment Info: - Solaris 9 (en_US.UTF8) - Remote Oracle 9i (UTF8) - Oracle 10g client () - ARServer 7.0.01 The arsql.log shows the following as the last select statement during the attempted startup: SELECT schemaId,fieldId,vuiId,propShort,propLong FROM field_dispprop ORDER BY 1 ASC,2 ASC,3 ASC arthread.log shows the following: */ Thread Trace Log -- ON */ Limits found: current rlimit=4096 - max rlimit=4096 */ Thread Id 2 (thread number 0) Thread Manager started. */ Thread Id 3 (thread number 1) timed call thread started. */ Thread Id 4 (thread number 2) on ADMIN queue started. */ Thread Trace Log -- OFF None of the other logs are written to. There is no core file created. One of the following actions may have led to the unstartable application server: - Import view defs from 6.0.1 (web fixed) - Import workflow containing direct sql workflow - Copy views from web fixed to standard - Delete web fixed views - Alter the query field (fid 40076) on FB:Variable (change length from 255 to 3999 chars) - Applied custom CSS tags to fields in the admin tool using the field properties - hide the toolbar - remove the preferences table label from table fields - hide the toolbar for forms for web mode Has anyone else performed any of the above actions on a 7.0.01 server and experienced these issues afterwards? Also, if you have performed any of the above actions and have not had these issues, that info would be helpful as well. This server was working fine all last week, but something happened between the last good start and the bad start, which has to be one of the above actions. Please share what you can. Thanks, Axton Grams ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARS as a development system
Rick, Do you think anyone at that bank would be willing to have a phone conversation with me or an email exchange on the subject? Or, If you're willing to share their name with me or my BMC Rep. I'll go through the proper protocol for requesting it. Bruce [EMAIL PROTECTED] -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick cook Sent: Sunday, October 22, 2006 10:00 PM To: arslist@ARSLIST.ORG Subject: Re: ARS as a development system I agree with the Rapid development system. We can build functioning systems in less time than many platforms take to build a prototype. Many of us have done just that. I know of one large national bank that has many of its internal functions and applications built on a custom Remedy platform. They do it in part because of the short time it takes to build and modify them. That adds a nimbleness to their applications, so that they can keep up with a rapidly changing business model. Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Davis, David CTR NAVSURFWARCENDIV Crane, Code 0552 Sent: Sunday, October 22, 2006 3:22 PM To: arslist@ARSLIST.ORG Subject: Re: ARS as a development system Well Bruce, here is a real stretch concerning Remedy as a development tool. How about as a Rapid Development Environment (RDE). Remedy has a lot of the same benefits for rapid development as does MS Access with one better Remedy can create SQL and/or Oracle Data Tables. In truth we use Remedy for all types of applications that require track of actions or tasks. If we want to email notifications and we need escalations to keep track of a particular action items; we use Remedy Action Request System. Remedy has limitations such as document management and complex mathematics functions but all in all we use it to create applications requiring a quite turn-around. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hendershot,Bruce D. Sent: Sunday, October 22, 2006 10:59 To: arslist@ARSLIST.ORG Subject: Re: ARS as a development system I'm resurrecting a topic from several months ago concerning using ARS as a development environment. Over the past 10 years we've used it to build our IT service management tools but also several non IT Service Management applications, some of which were built solely for the business as opposed to being IT internal tools. We'd like to do more of this because we can develop the applications quickly and inexpensively, as opposed to using .Net technologies for example. We would limit it to being used for specific types of applications based on guidelines. The major concern among our IT strategists is that BMC doesn't officially recognize, or at least market it as a general development tool. Another issue is that we have other systems that have workflow components to them such as SharePoint and SAP. I'm interesting in knowing how many shops are using the AR System as a general development tool. If you've gone through the same decision process, what was the result and what were the key drivers that led you to that decision? Thanks. Bruce Hendershot Air Products and Chemicals, Inc. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Tuesday, July 18, 2006 4:13 PM To: arslist@ARSLIST.ORG Subject: Re: ARS as a development system As soon as I saw ITSM 7, I knew that's the direction they were taking. ITSM 4-6 has been around for long enough that there are lots of people who know the app well enough to customize it. This version is not only new to us all, but is bigger. That gives BMC's own P.S. people a leg up on it over partners and in-house developers, especially since training won't be available until late September-ish, which means that for all practical purposes, the expertise won't be widespread until 2007. BMC is basing its business (and therefore sales) model on ITIL buy-in from the customer base. ITSM will get a customer to ITIL compliance far faster than a custom app set would, even if the developers were ITIL-trained. ITIL also works better in an integrated platform solution, which means more product sales. It's not like we can go out and build a discovery platform in ARS. We'd be hard-pressed to build ITSM 7 ourselves, which is not something we'd say about previous versions. So the decision point that some customers are at right now is whether ITIL is a standard that they will embrace now, or put off until later, or until something better comes along. ARS custom development will be a very strong alternative in those non-ITIL shops. Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mark Powell Sent: Tuesday, July 18, 2006 12:24 PM To: arslist@ARSLIST.ORG Subject: Re: ARS
Re: Using a 7.0 Midtier with a 5.1.2 Server
** Norm, I think that's probably the result of ARS 7.0 requiring authentication in ways that previous versions of ARS did not. Ensure that in your Admin tool's connection settings, you have set your MT Password. Rick On 10/23/06, Kaiser Norm E CIV USAF 96 CG/SCWOE <[EMAIL PROTECTED]> wrote: ** Hello everyone, Is it possible to use a 7.0 Midtier and a 5.1.2 server? Has anyone ever tried to do such a thing? I know it sounds weird, but I have good reason for trying this. As it stands, I'm getting the "Athentication Failed" error and am wondering if this is due to the old server version not being compatible with the new 7.0 version of the Midtier or if it's because I simply have something misconfigured somewhere. Does anyone know? Thanks, Norm__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Cannot find Escalated? Escalation RESOLVED
Title: Cannot find Escalated? Escalation ** Thats the one. Don't know how I missed that. Must be Monday. Thanks, Shane -Original Message-From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Thomas BeanSent: Monday, October 23, 2006 11:49 AMTo: arslist@ARSLIST.ORGSubject: Re: Cannot find Escalated? Escalation** I'm using Help Desk 5.5, but I'm guessing the workflow probably didn't change much in version 5.6. The escalation that triggers the process is "RSM:ESC-SendNotification", this updates the RSM:Escalation form. A filter on this form named "RSM:ESC-SendHPDNotif" includes a Push Fields action to update the 'Escalated?' field on the source help desk case. Another similar filter named "RSM:ESC-SendCHGNotif" does the same for change requests. HTH, Thomas - Original Message - From: Shane Buchholz Newsgroups: gmane.comp.crm.arsystem.general Sent: Monday, October 23, 2006 12:20 Subject: Cannot find Escalated? Escalation ** ARS 6.3 Help Desk 5.6 SQL 2000 Windows 2003 Server I was hoping someone might have an idea what escalation updates the Escalated? field in Help Desk. I have been trying to backtrack the workflow, but cannot seem to trace the escalation. I have the issue currently where this field should change to "Yes" when a certain time criteria is met. The field will eventually change, but is not changing when the ticket is esclated which leads me to believe that the escalation is not firing often enough. Any help would be appreciated. Thanks, Shane Buchholz Call Center Supervisor Samaritan Health Services [EMAIL PROTECTED] Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. __20060125___This posting was submitted with HTML in it_20060125___This posting was submitted with HTML in it___ Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. __20060125___This posting was submitted with HTML in it___
Using a 7.0 Midtier with a 5.1.2 Server
** Hello everyone, Is it possible to use a 7.0 Midtier and a 5.1.2 server? Has anyone ever tried to do such a thing? I know it sounds weird, but I have good reason for trying this. As it stands, I'm getting the "Authentication Failed" error and am wondering if this is due to the old server version not being compatible with the new 7.0 version of the Midtier or if it's because I simply have something misconfigured somewhere. Does anyone know? Thanks, Norm __20060125___This posting was submitted with HTML in it___
Re: "distinct" search on a table field
** You got it :)On 10/23/06, Halstead, Robert <[EMAIL PROTECTED]> wrote: ** ahh, I get it now. I create a database view then attach the view form to that database view. Bob Halstead From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Frank CarusoSent: Monday, October 23, 2006 1:51 PMTo: arslist@ARSLIST.ORGSubject: Re: "distinct" search on a table field ** YOu create the view of the Remedy form after the form is creates\modified. Something like:create view test_view as select DISTINCT col1,col2,col3 from view_nameCheck out page 174 in the Basic Guide v6.3 On 10/23/06, Halstead, Robert <[EMAIL PROTECTED]> wrote: ** how would I do the SQL query? doesn't seem like I can do it with the creation of the view form. Sorry, kindof dumb when it comes to the view form. I haven't used it much at all. Bob Halstead From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Frank CarusoSent: Monday, October 23, 2006 1:26 PMTo: arslist@ARSLIST.ORGSubject: Re: "distinct" search on a table field ** That is correct. You can use the Remedy View name. You could also use the table name (T142,etc) but that would mean all your Remedy servers would need to have the same ID for that table. it would also make the SQL al little more involved. On 10/23/06, Halstead, Robert <[EMAIL PROTECTED]> wrote: ** would I be able to use a view form on a form inside remedy? I'd just use the form name as the table name? Bob Halstead From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Frank CarusoSent: Monday, October 23, 2006 1:21 PMTo: arslist@ARSLIST.ORGSubject: Re: "distinct" search on a table field ** Nothing like a KEYWORD but you could create a View form of the table and use DISTINCT in the SQL statement. Then use that View form in your table field. On 10/23/06, Halstead, Robert <[EMAIL PROTECTED]> wrote: ** I was wondering if it's possible to do a "distinct" search on a table qualification. Distinct meaning SQL's "distinct" keyword. I have a form built kindof like how CTI is designed and I would like to return, in this case, the Type but not have the duplicate results. Is there a search keyword I can use to do this? Robert Halstead__20060125___This posting was submitted with HTML in it___ -- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineer www.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ -- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineer www.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ -- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineer www.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ -- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineerwww.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___
Re: "distinct" search on a table field
** ahh, I get it now. I create a database view then attach the view form to that database view. Bob Halstead From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank CarusoSent: Monday, October 23, 2006 1:51 PMTo: arslist@ARSLIST.ORGSubject: Re: "distinct" search on a table field ** YOu create the view of the Remedy form after the form is creates\modified. Something like:create view test_view as select DISTINCT col1,col2,col3 from view_nameCheck out page 174 in the Basic Guide v6.3 On 10/23/06, Halstead, Robert <[EMAIL PROTECTED]> wrote: ** how would I do the SQL query? doesn't seem like I can do it with the creation of the view form. Sorry, kindof dumb when it comes to the view form. I haven't used it much at all. Bob Halstead From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Frank CarusoSent: Monday, October 23, 2006 1:26 PMTo: arslist@ARSLIST.ORGSubject: Re: "distinct" search on a table field ** That is correct. You can use the Remedy View name. You could also use the table name (T142,etc) but that would mean all your Remedy servers would need to have the same ID for that table. it would also make the SQL al little more involved. On 10/23/06, Halstead, Robert <[EMAIL PROTECTED]> wrote: ** would I be able to use a view form on a form inside remedy? I'd just use the form name as the table name? Bob Halstead From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Frank CarusoSent: Monday, October 23, 2006 1:21 PMTo: arslist@ARSLIST.ORGSubject: Re: "distinct" search on a table field ** Nothing like a KEYWORD but you could create a View form of the table and use DISTINCT in the SQL statement. Then use that View form in your table field. On 10/23/06, Halstead, Robert <[EMAIL PROTECTED]> wrote: ** I was wondering if it's possible to do a "distinct" search on a table qualification. Distinct meaning SQL's "distinct" keyword. I have a form built kindof like how CTI is designed and I would like to return, in this case, the Type but not have the duplicate results. Is there a search keyword I can use to do this? Robert Halstead__20060125___This posting was submitted with HTML in it___ -- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineerwww.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ -- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineerwww.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ -- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineerwww.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: "distinct" search on a table field
** YOu create the view of the Remedy form after the form is creates\modified. Something like:create view test_view as select DISTINCT col1,col2,col3 from view_nameCheck out page 174 in the Basic Guide v6.3 On 10/23/06, Halstead, Robert <[EMAIL PROTECTED]> wrote: ** how would I do the SQL query? doesn't seem like I can do it with the creation of the view form. Sorry, kindof dumb when it comes to the view form. I haven't used it much at all. Bob Halstead From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Frank CarusoSent: Monday, October 23, 2006 1:26 PMTo: arslist@ARSLIST.ORGSubject: Re: "distinct" search on a table field ** That is correct. You can use the Remedy View name. You could also use the table name (T142,etc) but that would mean all your Remedy servers would need to have the same ID for that table. it would also make the SQL al little more involved. On 10/23/06, Halstead, Robert <[EMAIL PROTECTED]> wrote: ** would I be able to use a view form on a form inside remedy? I'd just use the form name as the table name? Bob Halstead From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Frank CarusoSent: Monday, October 23, 2006 1:21 PMTo: arslist@ARSLIST.ORGSubject: Re: "distinct" search on a table field ** Nothing like a KEYWORD but you could create a View form of the table and use DISTINCT in the SQL statement. Then use that View form in your table field. On 10/23/06, Halstead, Robert <[EMAIL PROTECTED]> wrote: ** I was wondering if it's possible to do a "distinct" search on a table qualification. Distinct meaning SQL's "distinct" keyword. I have a form built kindof like how CTI is designed and I would like to return, in this case, the Type but not have the duplicate results. Is there a search keyword I can use to do this? Robert Halstead__20060125___This posting was submitted with HTML in it___ -- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineer www.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ -- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineer www.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ -- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineerwww.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___
Re: "distinct" search on a table field
** how would I do the SQL query? doesn't seem like I can do it with the creation of the view form. Sorry, kindof dumb when it comes to the view form. I haven't used it much at all. Bob Halstead From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank CarusoSent: Monday, October 23, 2006 1:26 PMTo: arslist@ARSLIST.ORGSubject: Re: "distinct" search on a table field ** That is correct. You can use the Remedy View name. You could also use the table name (T142,etc) but that would mean all your Remedy servers would need to have the same ID for that table. it would also make the SQL al little more involved. On 10/23/06, Halstead, Robert <[EMAIL PROTECTED]> wrote: ** would I be able to use a view form on a form inside remedy? I'd just use the form name as the table name? Bob Halstead From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Frank CarusoSent: Monday, October 23, 2006 1:21 PMTo: arslist@ARSLIST.ORGSubject: Re: "distinct" search on a table field ** Nothing like a KEYWORD but you could create a View form of the table and use DISTINCT in the SQL statement. Then use that View form in your table field. On 10/23/06, Halstead, Robert <[EMAIL PROTECTED]> wrote: ** I was wondering if it's possible to do a "distinct" search on a table qualification. Distinct meaning SQL's "distinct" keyword. I have a form built kindof like how CTI is designed and I would like to return, in this case, the Type but not have the duplicate results. Is there a search keyword I can use to do this? Robert Halstead__20060125___This posting was submitted with HTML in it___ -- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineerwww.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ -- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineerwww.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: "distinct" search on a table field
** That is correct. You can use the Remedy View name. You could also use the table name (T142,etc) but that would mean all your Remedy servers would need to have the same ID for that table. it would also make the SQL al little more involved. On 10/23/06, Halstead, Robert <[EMAIL PROTECTED]> wrote: ** would I be able to use a view form on a form inside remedy? I'd just use the form name as the table name? Bob Halstead From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Frank CarusoSent: Monday, October 23, 2006 1:21 PMTo: arslist@ARSLIST.ORGSubject: Re: "distinct" search on a table field ** Nothing like a KEYWORD but you could create a View form of the table and use DISTINCT in the SQL statement. Then use that View form in your table field. On 10/23/06, Halstead, Robert <[EMAIL PROTECTED]> wrote: ** I was wondering if it's possible to do a "distinct" search on a table qualification. Distinct meaning SQL's "distinct" keyword. I have a form built kindof like how CTI is designed and I would like to return, in this case, the Type but not have the duplicate results. Is there a search keyword I can use to do this? Robert Halstead__20060125___This posting was submitted with HTML in it___ -- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineer www.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ -- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineerwww.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___
Re: "distinct" search on a table field
** would I be able to use a view form on a form inside remedy? I'd just use the form name as the table name? Bob Halstead From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank CarusoSent: Monday, October 23, 2006 1:21 PMTo: arslist@ARSLIST.ORGSubject: Re: "distinct" search on a table field ** Nothing like a KEYWORD but you could create a View form of the table and use DISTINCT in the SQL statement. Then use that View form in your table field. On 10/23/06, Halstead, Robert <[EMAIL PROTECTED]> wrote: ** I was wondering if it's possible to do a "distinct" search on a table qualification. Distinct meaning SQL's "distinct" keyword. I have a form built kindof like how CTI is designed and I would like to return, in this case, the Type but not have the duplicate results. Is there a search keyword I can use to do this? Robert Halstead__20060125___This posting was submitted with HTML in it___ -- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineerwww.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: "distinct" search on a table field
** Nothing like a KEYWORD but you could create a View form of the table and use DISTINCT in the SQL statement. Then use that View form in your table field.On 10/23/06, Halstead, Robert <[EMAIL PROTECTED]> wrote: ** I was wondering if it's possible to do a "distinct" search on a table qualification. Distinct meaning SQL's "distinct" keyword. I have a form built kindof like how CTI is designed and I would like to return, in this case, the Type but not have the duplicate results. Is there a search keyword I can use to do this? Robert Halstead __20060125___This posting was submitted with HTML in it___ -- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineerwww.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___
Re: Enhancement: Schema ID on AR Admin tool...
Title: RE: Enhancement: Schema ID on AR Admin tool... ** Les: I used to work in a shop where we built a custom form that would list the available schemas, the schemaid. This was done through an SQL Menu. Clicking on one of the available schemas gave you the current value of the nextid. This was for testing so we could step backwards and forwards through a to see another field on a different form. James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of [EMAIL PROTECTED] Sent: Monday, October 23, 2006 12:10 PM To: arslist@ARSLIST.ORG Subject: Re: Enhancement: Schema ID on AR Admin tool... ARUtilities lists all the schema IDs with the schema names. When doing a "View By" the schema IDs are included. Hope this helps. Les > Troubleshooting one of my customers application for performance, so > since SQL logs show T on SQL logs, I have to query the > arschema table all the time before opening the form in question in the > Admin tool.. which is where I found that if the admin tool listed the > schemaId's with their corresponding schema Id's, it would have been > easier for me to identify the form by the ID instead of its name.. > also it would have been nice to have the View by feature modified to show a form or a list of forms by schema ID's.. > > Personally I do not think it will be too hard to modify the Admin tool > code to display the schemaid along with the schema name.. > > Rgds > > Joe D'Souza > Remedy Developer / Consultant, > Shyle Networks, > New Jersey. > > > > - Original Message > From: Axton <[EMAIL PROTECTED]> > To: arslist@ARSLIST.ORG > Sent: Sunday, October 22, 2006 11:53:21 AM > Subject: Re: Enhancement: Schema ID on AR Admin tool... > > > It would be nice, would also be nice to see a list of forms/fields a > menu is attached to. > > Joe, what are you doing where the schemaid would be useful? In my > direct sql workflow, I set an integer field to the schemaid and use > that as a variable in the direct sql action. I do this because the > schemaid can vary from server to server. I refrain from using the > views for several reasons (the naming has changed in the past; > permissions get dropped from views on each form change; etc.). > > Axton Grams > > On 10/22/06, Jarl Grøneng <[EMAIL PROTECTED]> wrote: > > I dont see the problem. Active links can be a part of unlimited > > number of > forms. > > > > This is an enhancment I would like to se. I had to create a sql-stmt > > to list which active links and filters that are not part of a guide > > > > -- > > Jarl > > > > > > On 10/22/06, Joe D'Souza <[EMAIL PROTECTED]> wrote: > > > That might be nice but you got to remember that an AL or a filter > > > could > be a > > > part of more than one guide... and I do not think there is a limit > > > to the number of guides you can tie a AL or Filter to... > > > > > > Joe > > > > > > -Original Message- > > > From: Action Request System discussion list(ARSList) > > > [mailto:arslist@ARSLIST.ORG]On Behalf Of Jay Rohrer > > > Sent: Saturday, October 21, 2006 8:07 PM > > > To: arslist@ARSLIST.ORG > > > Subject: Re: Enhancement: Schema ID on AR Admin tool... > > > > > > > > > I would not find that nearly as useful as having a tab on ALs and > > > FILs > that > > > tell me which Guides they are a part of. > > > > > > Jay Rohrer > > > > ___ > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
"distinct" search on a table field
** I was wondering if it's possible to do a "distinct" search on a table qualification. Distinct meaning SQL's "distinct" keyword. I have a form built kindof like how CTI is designed and I would like to return, in this case, the Type but not have the duplicate results. Is there a search keyword I can use to do this? Robert Halstead __20060125___This posting was submitted with HTML in it___
Re: Enhancement: Schema ID on AR Admin tool...
ARUtilities lists all the schema IDs with the schema names. When doing a "View By" the schema IDs are included. Hope this helps. Les > Troubleshooting one of my customers application for performance, so since SQL > logs show T on SQL logs, I have to query the arschema table all the > time before opening the form in question in the Admin tool.. which is where I > found that if the admin tool listed the schemaId's with their corresponding > schema Id's, it would have been easier for me to identify the form by the ID > instead of its name.. also it would have been nice to have the View by > feature modified to show a form or a list of forms by schema ID's.. > > Personally I do not think it will be too hard to modify the Admin tool code > to display the schemaid along with the schema name.. > > Rgds > > Joe D'Souza > Remedy Developer / Consultant, > Shyle Networks, > New Jersey. > > > > - Original Message > From: Axton <[EMAIL PROTECTED]> > To: arslist@ARSLIST.ORG > Sent: Sunday, October 22, 2006 11:53:21 AM > Subject: Re: Enhancement: Schema ID on AR Admin tool... > > > It would be nice, would also be nice to see a list of forms/fields a > menu is attached to. > > Joe, what are you doing where the schemaid would be useful? In my > direct sql workflow, I set an integer field to the schemaid and use > that as a variable in the direct sql action. I do this because the > schemaid can vary from server to server. I refrain from using the > views for several reasons (the naming has changed in the past; > permissions get dropped from views on each form change; etc.). > > Axton Grams > > On 10/22/06, Jarl Grøneng <[EMAIL PROTECTED]> wrote: > > I dont see the problem. Active links can be a part of unlimited number of > forms. > > > > This is an enhancment I would like to se. I had to create a sql-stmt > > to list which active links and filters that are not part of a guide > > > > -- > > Jarl > > > > > > On 10/22/06, Joe D'Souza <[EMAIL PROTECTED]> wrote: > > > That might be nice but you got to remember that an AL or a filter could > be a > > > part of more than one guide... and I do not think there is a limit to the > > > number of guides you can tie a AL or Filter to... > > > > > > Joe > > > > > > -Original Message- > > > From: Action Request System discussion list(ARSList) > > > [mailto:[EMAIL PROTECTED] Behalf Of Jay Rohrer > > > Sent: Saturday, October 21, 2006 8:07 PM > > > To: arslist@ARSLIST.ORG > > > Subject: Re: Enhancement: Schema ID on AR Admin tool... > > > > > > > > > I would not find that nearly as useful as having a tab on ALs and FILs > that > > > tell me which Guides they are a part of. > > > > > > Jay Rohrer > > > > ___ > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Cannot find Escalated? Escalation
Title: Cannot find Escalated? Escalation ** I'm using Help Desk 5.5, but I'm guessing the workflow probably didn't change much in version 5.6. The escalation that triggers the process is "RSM:ESC-SendNotification", this updates the RSM:Escalation form. A filter on this form named "RSM:ESC-SendHPDNotif" includes a Push Fields action to update the 'Escalated?' field on the source help desk case. Another similar filter named "RSM:ESC-SendCHGNotif" does the same for change requests. HTH, Thomas - Original Message - From: Shane Buchholz Newsgroups: gmane.comp.crm.arsystem.general Sent: Monday, October 23, 2006 12:20 Subject: Cannot find Escalated? Escalation ** ARS 6.3 Help Desk 5.6 SQL 2000 Windows 2003 Server I was hoping someone might have an idea what escalation updates the Escalated? field in Help Desk. I have been trying to backtrack the workflow, but cannot seem to trace the escalation. I have the issue currently where this field should change to "Yes" when a certain time criteria is met. The field will eventually change, but is not changing when the ticket is esclated which leads me to believe that the escalation is not firing often enough. Any help would be appreciated. Thanks, Shane Buchholz Call Center Supervisor Samaritan Health Services [EMAIL PROTECTED] Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Web View Help Text
Hello Listers, When a Requester presses the Help button to read the help text, they are seeing the help for the form and all the fields, even if "Hide this help text in web views" is checked. I checked the documentation and it states that it worked for previous version, but not for ver 6.3. I looked at the source for the html help file and the individual fields are using a class called FieldContainer. I am thinking about just hiding the class via the style sheet. This way only the form help will show to requesters via the web, but all field help will be available to Support via the Windows Client. Does anyone know if this class is used anywhere else? Does anyone have any other suggestions to hide the support help text from the Requester help text? Thanks! Carolyn Wixson ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Sensing more than 1 table row selected
Anybody have any quick ways of telling whether a user has selected more than 1 row in a table field? I know I can do a table walk but that will require roughly 3-4 objects. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Cannot find Escalated? Escalation
Title: Cannot find Escalated? Escalation ** ARS 6.3 Help Desk 5.6 SQL 2000 Windows 2003 Server I was hoping someone might have an idea what escalation updates the Escalated? field in Help Desk. I have been trying to backtrack the workflow, but cannot seem to trace the escalation. I have the issue currently where this field should change to "Yes" when a certain time criteria is met. The field will eventually change, but is not changing when the ticket is esclated which leads me to believe that the escalation is not firing often enough. Any help would be appreciated. Thanks, Shane Buchholz Call Center Supervisor Samaritan Health Services [EMAIL PROTECTED] Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. __20060125___This posting was submitted with HTML in it___
Re: Creating an Email Template to Search Using a Qualification
** SMR, Query templates and results templates are totally different concepts in the Email Engine and it is very confusing that they call them both the templates. The query template is supplied in the Text field of the Notify Action. It contains the qualification for the report. The result template resides in the AR System Email Templates form. It contains the format for the report. See the "Sample HTML result template" in the Remedy Email Engine Guide. I found the hard way that it does not work (for me anyway) if I begin a line in the result template with #. By the way, I'm on 6.3. Julie At 09:41 AM 10/23/2006, you wrote: ** Thank you Julie, I guess my confusion lies at the template level. What is the content of your template if the text notification contains the query? Perhaps I'm misreading. -SMR On 10/23/06, Julie Rockwood <[EMAIL PROTECTED]> wrote: ** SMR, Here is a slightly updated version (from the August thread " automatically generate email with report included" of how I do it. By using the key rather than a password, anyone who stole the key would only be able to use it to perform email queries. Has anyone else found a more secure way of doing it? This escalation will eventually create 3 records in the AR System Email Messages form. The outgoing message that the escalation generated will generate an incoming query which will generate the outgoing report. Just have your escalation run the following notify action Text: Server: $SERVER$ User: myMailQueryUser Key: myKey Schema: mySchema Action: Query Result: myResultTemplate Qualification: 'Create-date' > ($\TIMESTAMP$ - (60*60*24)) User Name: [EMAIL PROTECTED] Mechanism: Email Subject: Tickets Created Today Include Fields: None Reply To: [EMAIL PROTECTED] HTH, Julie At 09:00 AM 10/23/2006, you wrote: ** This seems like it could work well for simple reporting requirements. It is detailed in the Email Engine Guide but I have not had success with this. Has anyone gotten this to work? -SMR __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: OT: DB design multiple joins
Carey, Scott, Axton & Rick, Thanks for the ideas. I will give the GUID a try but I also have to account for the migration of data that is not in the exact same table structure as I am creating here. I plan to make my import files with Request_IDs for keys and then I can enable and distribute the GUIDs. The reason for the change to using GUID is that I was informed by the user that "all of the steps (child/grandchild records) can be entered at one time". With GUID available before the Submit, as you all have noted, this is handled easily. So now I get to learn the practical application of the GUID. Thanks for all the help, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Sunday, October 22, 2006 1:22 PM To: arslist@ARSLIST.ORG Subject: Re: OT: DB design multiple joins Scott, I can see one reason to use 'Request ID' instead of a GUID. The 'Request ID' column is the clustered index column for an ARS table. Performance on that index will always out perform any other index that you might add to the GUID field. However, all of the other reason to use a GUID (IMHO) out ways the "cost" difference between the clustered index and an ordinary index. If you find yourself developing in the special case that the parent record is _always_ created before the children, then you likely should use the 'Request ID' value as the glue. But if there is a potential that the creation even of the parent would actually also create one or more children too, then you likely need to use GUID's. (Even if they are only temporary keys to cross map the parent 'Request ID' after it is known.) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 10/21/06, Scott Parrish <[EMAIL PROTECTED]> wrote: > John, > In general, I can't think of a single reason to utilize the request ID > over a GUID to create and maintain parent/child relationships. I > think, overall, it is a much cleaner way of establishing > relationships. You can utilize a set fields $PROCESS$ to generate a > GUID at any time so this is especially valuable if you are using > Display Only forms for data entry and creating one-to-many or many-to-many relationships. > > For instance, Remedy's Customer Service and Support application > utilizes the concept of an OperationID. If you were utilizing a > display only form to create your MR and at the same time it's > associated POs and Line Items, then suddenly decided that you wanted > to complete None of this, you could reference the Operation ID to > delete the MR and all of it's relationships using a single field of > reference. You would just generate the Operation ID using a GUID when > the initial Display Only form were opened, then push it to create all relationships. > > There are many, many other reasons for utilizing the GUID over the > Request_ID field and I'm sure others on this list can give you > different examples. I think once you start using the GUID in your > workflow you'll see how easy and powerful it can be. > > Remember that a GUID is ALWAYS unique. If you were combining two > Remedy systems into one, such as HD, if you utilized GUIDs to maintain > relationships you would never have to worry about how duplicate > Request IDs might affect your relationships. > > Scott Parrish > IT Prophets, LLC > (770) 653-5203 > http://www.itprophets.com > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J > Sent: Saturday, October 21, 2006 11:42 AM > To: arslist@ARSLIST.ORG > Subject: Re: OT: DB design multiple joins > > Axton, > > I will probably use joins in some fashion, maybe for a report form. > At the top level I think it will be the main form with tables and DO > fields to display data, with Open Window actions to create/modify children records. > > I wasn't planning on using the GUID, instead I was just going to use > the Request_ID of the parent. Child records are created from modify screens. > Aside from the lack of a Request ID at the create time of the parent > are ther other benefits to the GUID? Or where you using the general term guid? > > > Thanks for the reminder about indexing. > > ARS 6.3 Patch 003 > Midtier 6.3 Patch 14 > MS SQL 2000 SP2 on a remote SAN > > John J. Reiser > Software Development Analyst > Remedy Administrator/Developer > Lockheed Martin - MS2 > The star that burns twice as bright burns half as long. > Pay close attention and be illuminated by its brilliance. - > paraphrased by me > > ___
Re: Creating an Email Template to Search Using a Qualification
** Thank you Julie, I guess my confusion lies at the template level. What is the content of your template if the text notification contains the query? Perhaps I'm misreading. -SMR On 10/23/06, Julie Rockwood <[EMAIL PROTECTED]> wrote: ** SMR,Here is a slightly updated version (from the August thread "automatically generate email with report included" of how I do it. By using the key rather than a password, anyone who stole the key would only be able to use it to perform email queries. Has anyone else found a more secure way of doing it?This escalation will eventually create 3 records in the AR System Email Messages form. The outgoing message that the escalation generated will generate an incoming query which will generate the outgoing report. Just have your escalation run the following notify action Text: Server: $SERVER$ User: myMailQueryUser Key: myKey Schema: mySchema Action: Query Result: myResultTemplate Qualification: 'Create-date' > ($\TIMESTAMP$ - (60*60*24)) User Name: [EMAIL PROTECTED] Mechanism: Email Subject: Tickets Created Today Include Fields: None Reply To: [EMAIL PROTECTED] HTH, Julie At 09:00 AM 10/23/2006, you wrote: ** This seems like it could work well for simple reporting requirements. It is detailed in the Email Engine Guide but I have not had success with this. Has anyone gotten this to work? -SMR__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Creating an Email Template to Search Using a Qualification
** SMR, Here is a slightly updated version (from the August thread "automatically generate email with report included" of how I do it. By using the key rather than a password, anyone who stole the key would only be able to use it to perform email queries. Has anyone else found a more secure way of doing it? This escalation will eventually create 3 records in the AR System Email Messages form. The outgoing message that the escalation generated will generate an incoming query which will generate the outgoing report. Just have your escalation run the following notify action Text: Server: $SERVER$ User: myMailQueryUser Key: myKey Schema: mySchema Action: Query Result: myResultTemplate Qualification: 'Create-date' > ($\TIMESTAMP$ - (60*60*24)) User Name: [EMAIL PROTECTED] Mechanism: Email Subject: Tickets Created Today Include Fields: None Reply To: [EMAIL PROTECTED] HTH, Julie At 09:00 AM 10/23/2006, you wrote:** This seems like it could work well for simple reporting requirements. It is detailed in the Email Engine Guide but I have not had success with this. Has anyone gotten this to work? -SMR __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Creating an Email Template to Search Using a Qualification
** This seems like it could work well for simple reporting requirements. It is detailed in the Email Engine Guide but I have not had success with this. Has anyone gotten this to work? -SMR __20060125___This posting was submitted with HTML in it___
Re: Enhancement: Schema ID on AR Admin tool...
** Troubleshooting one of my customers application for performance, so since SQL logs show T on SQL logs, I have to query the arschema table all the time before opening the form in question in the Admin tool.. which is where I found that if the admin tool listed the schemaId's with their corresponding schema Id's, it would have been easier for me to identify the form by the ID instead of its name.. also it would have been nice to have the View by feature modified to show a form or a list of forms by schema ID's.. Personally I do not think it will be too hard to modify the Admin tool code to display the schemaid along with the schema name.. Rgds Joe D'Souza Remedy Developer / Consultant, Shyle Networks, New Jersey. - Original Message From: Axton <[EMAIL PROTECTED]>To: arslist@ARSLIST.ORGSent: Sunday, October 22, 2006 11:53:21 AMSubject: Re: Enhancement: Schema ID on AR Admin tool... It would be nice, would also be nice to see a list of forms/fields amenu is attached to.Joe, what are you doing where the schemaid would be useful? In mydirect sql workflow, I set an integer field to the schemaid and usethat as a variable in the direct sql action. I do this because theschemaid can vary from server to server. I refrain from using theviews for several reasons (the naming has changed in the past;permissions get dropped from views on each form change; etc.).Axton GramsOn 10/22/06, Jarl Grøneng <[EMAIL PROTECTED]> wrote:> I dont see the problem. Active links can be a part of unlimited number of forms.>> This is an enhancment I would like to se. I had to create a sql-stmt> to list which active links and filters that are not part of a guide>> --> Jarl>>> On 10/22/06, Joe D'Souza <[EMAIL PROTECTED]> wrote:> > That might be nice but you got to remember that an AL or a filter could be a> > part of more than one guide... and I do not think there is a limit to the> > number of guides you can tie a AL or Filter to...> >> > Joe> >> > -Original Message-> > From: Action Request System discussion list(ARSList)> > [mailto:[EMAIL PROTECTED] Behalf Of Jay Rohrer> > Sent: Saturday, October 21, 2006 8:07 PM> > To: arslist@ARSLIST.ORG> > Subject: Re: Enhancement: Schema ID on AR Admin tool...> >> >> > I would not find that nearly as useful as having a tab on ALs and FILs that> > tell me which Guides they are a part of.> >> > Jay Rohrer __20060125___This posting was submitted with HTML in it___
Re: BMC Discovery Suite
Title: BMC Discovery Suite ** For a competitor, try FrontRange ITSM if you want. The problem may be that it shows very well, and has a couple of very nice features that Remedy doesn't have, but the engineering and support underneath it is not nearly as good as ARS. Also, don't even try to get expert help from their techies - there's like two of them, and they're stretched very thin. Price is similar to Remedy. So I'd use them as a comparison if your management understands that how things work is more important than how they look. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pierson, ShawnSent: Monday, October 23, 2006 6:12 AMTo: arslist@ARSLIST.ORGSubject: BMC Discovery Suite ** Hello folks, My company is looking into using the BMC Discovery Suite (Foundation, Topology, Configuration) to populate our CMDB and leverage that for our ITSM applications. I'm wondering if any of you have experience with it and what your general opinion is. Additionally, do any of you know of any competitors of Remedy for AR System and ITSM that are out there. I need to be able to show my management that the Remedy suite of products are the best (and they are, in my experience), but the only real competitor in the same space that I am aware of is CA, which is nowhere near as good as ITSM. Thanks, Shawn Pierson The information in this e-mail, and any files transmitted with it, is intended for the exclusive use of the recipient(s) to which it is addressed and may contain confidential, proprietary or privileged information. If you are not an intended recipient, you have received this transmission in error and any use, review, dissemination, distribution, printing or copying of this information is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately of the erroneous transmission by reply e-mail, immediately delete this e-mail and all electronic copies of it from your system and destroy any hard copies of it that you may have made. Thank you. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: ARERR [90] Cannot establish a network connection to the AR System server : arserver (0) : RPC: Program not registered (U)
Title: Message ** UNCLASSIFIED Great! Sandra Hennigan OSD Remedy Administrator Office # 703-602-2525 x251 CACI - Ever Vigilant™ Apparently, there is nothing that cannot happen today. Mark Twain -Original Message-From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dan CaissieSent: Monday, October 23, 2006 9:11 AMTo: arslist@ARSLIST.ORGSubject: Re: ARERR [90] Cannot establish a network connection to the AR System server : arserver (0) : RPC: Program not registered (U)** This fixed the issue with a little tweaking. Thanks! Dan Caissie Remedy Administrator / Developer United Natural Foods, Inc From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hennigan, Sandra H CTR OSD-CIOSent: Friday, October 20, 2006 3:56 PMTo: arslist@ARSLIST.ORGSubject: Re: ARERR [90] Cannot establish a network connection to the AR System server : arserver (0) : RPC: Program not registered (U) UNCLASSIFIED What process did you use when you moved the database? If backup/restore, you will need to take ownership of the database. This KM on Remedy Support details the steps that need to be taken. I have attached for you. Creation Date: 2/5/2003 3:30:11 PM Last Modified Date: 06/23/2004 10:18:40 Review Date: 8/13/2003 2:03:25 PM Author: Dan Stolarik Document ID: KM-00011545 Product(s): undefined Sandra Hennigan OSD Remedy Administrator Office # 703-602-2525 x251 CACI - Ever Vigilant™ Apparently, there is nothing that cannot happen today. Mark Twain -Original Message-From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Dan CaissieSent: Friday, October 20, 2006 3:48 PMTo: arslist@ARSLIST.ORGSubject: ARERR [90] Cannot establish a network connection to the AR System server : arserver (0) : RPC: Program not registered ** Has anyone run into this problem while moving a database over to a DEV server? When I try to login to Remedy on the server this is what I get for a message. AR Server 6.03 Patch 5 SLQ 2000 Windows 2003 ARERR [90] Cannot establish a network connection to the AR System server : carserver (0) : RPC: Program not registered user: Demo, server: arserver Cannot login to arserver as a preference server. user: Demo, server: ctdayrem04 Unable to successfully log in to any server. Thanks, Dan Caissie Remedy Administrator / Developer United Natural Foods, Inc __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it_20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
BMC Discovery Suite
Title: BMC Discovery Suite ** Hello folks, My company is looking into using the BMC Discovery Suite (Foundation, Topology, Configuration) to populate our CMDB and leverage that for our ITSM applications. I'm wondering if any of you have experience with it and what your general opinion is. Additionally, do any of you know of any competitors of Remedy for AR System and ITSM that are out there. I need to be able to show my management that the Remedy suite of products are the best (and they are, in my experience), but the only real competitor in the same space that I am aware of is CA, which is nowhere near as good as ITSM. Thanks, Shawn Pierson The information in this e-mail, and any files transmitted with it, is intended for the exclusive use of the recipient(s) to which it is addressed and may contain confidential, proprietary or privileged information. If you are not an intended recipient, you have received this transmission in error and any use, review, dissemination, distribution, printing or copying of this information is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately of the erroneous transmission by reply e-mail, immediately delete this e-mail and all electronic copies of it from your system and destroy any hard copies of it that you may have made. Thank you. __20060125___This posting was submitted with HTML in it___
Re: ARERR [90] Cannot establish a network connection to the AR System server : arserver (0) : RPC: Program not registered (U)
Title: Message ** This fixed the issue with a little tweaking. Thanks! Dan Caissie Remedy Administrator / Developer United Natural Foods, Inc From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hennigan, Sandra H CTR OSD-CIO Sent: Friday, October 20, 2006 3:56 PM To: arslist@ARSLIST.ORG Subject: Re: ARERR [90] Cannot establish a network connection to the AR System server : arserver (0) : RPC: Program not registered (U) UNCLASSIFIED What process did you use when you moved the database? If backup/restore, you will need to take ownership of the database. This KM on Remedy Support details the steps that need to be taken. I have attached for you. Creation Date: 2/5/2003 3:30:11 PM Last Modified Date: 06/23/2004 10:18:40 Review Date: 8/13/2003 2:03:25 PM Author: Dan Stolarik Document ID: KM-00011545 Product(s): undefined Sandra Hennigan OSD Remedy Administrator Office # 703-602-2525 x251 CACI - Ever Vigilant™ Apparently, there is nothing that cannot happen today. Mark Twain -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Dan Caissie Sent: Friday, October 20, 2006 3:48 PM To: arslist@ARSLIST.ORG Subject: ARERR [90] Cannot establish a network connection to the AR System server : arserver (0) : RPC: Program not registered ** Has anyone run into this problem while moving a database over to a DEV server? When I try to login to Remedy on the server this is what I get for a message. AR Server 6.03 Patch 5 SLQ 2000 Windows 2003 ARERR [90] Cannot establish a network connection to the AR System server : carserver (0) : RPC: Program not registered user: Demo, server: arserver Cannot login to arserver as a preference server. user: Demo, server: ctdayrem04 Unable to successfully log in to any server. Thanks, Dan Caissie Remedy Administrator / Developer United Natural Foods, Inc __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Enhancement: Schema ID on AR Admin tool...
Jay, Did you already submit an enhancement request for this? Because I would definitely see the benefit in this. I'll go one a little further. Add an extra tab to the AL/FIL guide that lists all of the AL/FILs that actually do the calling. I too had to grab this through SQL. Michelle -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jay Rohrer Sent: Saturday, October 21, 2006 7:07 PM To: arslist@ARSLIST.ORG Subject: Re: Enhancement: Schema ID on AR Admin tool... I would not find that nearly as useful as having a tab on ALs and FILs that tell me which Guides they are a part of. Jay Rohrer ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
RE : Badly displayed forms ** FIXED ***
** A member of the ARLIST helped me resolve this ... The midtier was not set to prefer windows view over Web view!! In case someone forgets to set this option and wonders why the hell the forms are all over the place :) thanks to everyone for their assistance FrexpopoFrex Popo <[EMAIL PROTECTED]> a écrit :Hello, I have a couple of forms that display fine in client. Once in the browser these forms are all over the place. Have to drag them from the sides to be able to see the whole form. Do you know of any way I could fix this? Thanks in advance Frexpopo Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Demandez à ceux qui savent sur Yahoo! Questions/Réponses. Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Demandez à ceux qui savent sur Yahoo! Questions/Réponses. __20060125___This posting was submitted with HTML in it___
Re: How to determine a filter which denies deleting requests from a form? - Resolved
Hi Misi, Yes you're right. The problem was in MenuAccess for the current View. My assuption about filter limitations was wrong. Thank you. Kind Regards / C ? Dmitry Bezhenar -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Misi Mladoniczky Sent: Monday, October 23, 2006 2:28 PM To: arslist@ARSLIST.ORG Subject: Re: How to determine a filter which denies deleting requests from a form? Hi Dmitry, What do you mean by "frozen"? Do you mean disabled? In that case, I would check ARAdmin->Form->CurrentView->Properties->MenuAccess->Delete. A filter stopping the operation should give you an Error Message. Best Regards - Misi, RRR AB, http://www.rrr.se > Hello List, > > I am trying to delete requests from a form using "Ctrl + D", but nothing > happens. Actions -> Delete button in also "frozen". It seems to me that > some filter denies deletes on this form, but I can not determine which one > exactly. Could anybody tell me what should I search for in the list of > filters related to this form? > > Thank you. > > PS: I am in the "Administrator" group on this server. > > Kind Regards / C ? > Dmitry Bezhenar > > > ___ > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: How to determine a filter which denies deleting requests from a form?
Hi Dmitry, What do you mean by "frozen"? Do you mean disabled? In that case, I would check ARAdmin->Form->CurrentView->Properties->MenuAccess->Delete. A filter stopping the operation should give you an Error Message. Best Regards - Misi, RRR AB, http://www.rrr.se > Hello List, > > I am trying to delete requests from a form using "Ctrl + D", but nothing > happens. Actions -> Delete button in also "frozen". It seems to me that > some filter denies deletes on this form, but I can not determine which one > exactly. Could anybody tell me what should I search for in the list of > filters related to this form? > > Thank you. > > PS: I am in the "Administrator" group on this server. > > Kind Regards / C ? > Dmitry Bezhenar > > > ___ > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
How to determine a filter which denies deleting requests from a form?
** Hello List, I am trying to delete requests from a form using "Ctrl + D", but nothing happens. Actions -> Delete button in also "frozen". It seems to me that some filter denies deletes on this form, but I can not determine which one exactly. Could anybody tell me what should I search for in the list of filters related to this form? Thank you. PS: I am in the "Administrator" group on this server. Kind Regards / C уважениемDmitry Bezhenar __20060125___This posting was submitted with HTML in it___
Re: Report on Users in Groups
** Hi Harold,I recently had to provide this information, which I did via SQL MS-SQL version: select group_name, full_name from group_x join user_x on (group_list like '%' + cast(group_id as varchar(50)) + ';%') group by group_name, full_nameOracle version: select group_name, full_name from group_x, user_x where group_list like '%' || ltrim(rtrim(to_char(group_id))) || '%' order by group_name, full_nameRegards,GarethOn 16/10/06, Harold Link < [EMAIL PROTECTED]> wrote:**Listers,I need a way to run a report [or populate a form] that contains a record for each user in each group. This would be similar to the data containedin the SHR:Assignments form in the Service Desk module, but alas, thelarge company I am working for does not have the module in place. They are using a form called Group Membership but the records are out of sync withthe User form.For example, a sample ID in User form shows Group List as500;1188;499;501;511;5169;510;453; [GroupIDs] but the Group Membership shows 504;1188;500;.This company has over 1200 groups and 6000 Remedy users, so doing thismanually is out of the picture.Main goal was to have a table in an administrator utility form thatdisplays the groups that the user belongs to. The admins [these are helpdesk and Remedy admins that only have permissions to add/modify usersand groups] would use the table to add and remove groups.Current work around is running filters against the Group List field that adds or removes a Group ID and this works fine for now. But would stilllike to develop the table concept. I have used this in the QM module butmy current data is out of sync as mentioned above.Hope this isn't too long ___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___