Re: 3 Fields into one Selection Field
Hi, Why not have a char-menu show the values Work Phone, Home Phone and Cell Phone. Then have active-links that triggers on Menu Choise that populates the fields with the right value. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. I'm creating an on call system and I have three fields, Work Phone, Home Phone and Cell Phone. I also have three other fields called Call First, Call Second, Call Third. I'd like to have the Numbers in the first three fields be a selection on a drop down menu for each of the other three fields. Is there a way to do this? (I don't think so). I have it set up the they can choose from a set of responses like Work Home and Cell but I would rather have the actual phone numbers for them to choose from. Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
CMDB / Asset CI - Templates for documenting CI's
All, I am trying to provide different business groups a template/spreadsheet for listing out their devices with the config information that they know about it. We are currently in process of rolling out server/network discovery tools but want to manually load Server/Network CI's. We already have CDI (config discovery for clients). For example, the Network Ops group can have a Server template that they can fill out with the server name, components (memory, HD, NIC), so that I can then use AIE to load into the CMDB. Is there some sort of standard template floating around out there that you use? I am just trying to see if there is a standard so I am not re-inventing the wheel. I looked on BMCDN but have had no luck... Thank you. ITSM 7.0.3 , CMDB 2.1 -Tauf Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Informatics-Infrastructure Office: 631.858.7765 Mobile:646.483.2779 ** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Webservices
That list reminded me about another one that bugs me. I don't like how when an external webservice times out, the client tells you there is a problem with the plugin server and tells you to contact your Remedy Administrator. In this case, there is NOTHING wrong with Remedy, the issue is with the external webservice not responding, but the only way to tell that is to recreate the situation with logging on, then call the other team with the log in hand. It would be nice if Remedy would say something like 'Unable to contact web service at this target URI 'blah' -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Carey Matthew Black Sent: Saturday, May 09, 2009 7:29 AM To: arslist@ARSLIST.ORG Subject: Re: Webservices Axton, My Web Services experience is only current through v6.3. ( Which is now EOL'ed. :( ) So maybe some of these ideas have been addressed partially or totally in 7.5, but I doubt it. First I will divide this question it to two questions: Q1) What do you think about how ARSystem publishes WebServices? A1) Overall Grade: B. Major Areas that need improvement; * Error handling -- Log to ARS form -- To ARS Group (for real time notifications) * support for missing complex XML structures Improvement ideas: * Allow for one or more XSLT transformations before/after the WebService * Never allow for a break in functionality like what happened at v7.0.1. G. Which broke ARS connectivity from Mid-Tiers newer than x and ARS servers that were older than x(the same version). Q2) What do you think about how ARSystem consumes WebServices? A2) Overall Grade: C. Major Areas that need improvement; * Advanced mode for Set field from a Web Service - Support data driven Method, InputMap, and/or OutputMap values - Provide a way for an Alias to be used to MAP a WebService URL from ar.conf . ( To allow prod and dev to be coded [filter objects identical] the same but the ARServer points at different target URLs at runtime.) * Better fail/retry options. Maybe retry N times then throw the ARERROR. Maybe support On fail call WebService 'other' instead of ARERROR Maybe support On fail call FilterGuide 'fGuide' instead of ARERROR * Allow for each consuming action to control the timeout for that external call. Instead of only having one global setting on the AR Server level let the action define a more restrictive value for that action. * Allow for one or more XSLT transformations before/after the WebService * Support the full XML standard without restrictions for some XML structures. Even if ARS can not publish all XML structures it should be able to consume them all. :) I am sure there are other ideas that have slipped into the void over the time I have used ARS WebService interfaces... but that is what comes to mind right now. Hope that helps. In general, I look forward to the day that all attributes of ARS workflow(AKA: every setting of every action) can be data driven. That will be a very big step forward for the platform. -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Fri, May 8, 2009 at 10:26 AM, Axton axton.gr...@gmail.com wrote: ** I wanted to get a feel from the group on some of the headaches and limitations of the Remedy web services implementation. I've avoided the interface, much like the palgue, since it was first adopted. I'm looking for limitations when people interface bi-directionally with other applications, performing operations like creating incidents, in relation to things like not being able to support certain data types, not being able to query certain outside webservices due to how they are structured, etc. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Slow to Switch between records in the search results list
I would turn on API and SQL Logging before doing the switch and see if you can see any delays in the logs _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of kiran kodali Sent: Monday, May 11, 2009 7:12 AM To: arslist@ARSLIST.ORG Subject: Slow to Switch between records in the search results list ** Hi All, It is taking much time to switch between records in the search results list in user client. Did anybody experience the same problem? It happens even with the forms having less data(500 records). Please let me know the parameters that would be affecting this dealy in switching b/w records. Thanks. ARS 7.1 P006 Oracle 10G/Solaris -- Regards, Kiran Kodali Ph: 940-231-8524 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: What would $--1$ relate to?
I don't recall if it was 7.0 or 7.1...but I thought it was funny that they removed the 'convert macro actions' admin tool optionthat was really the end of when I used macros in every day workflow. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Carey Matthew Black Sent: Sunday, May 10, 2009 5:47 PM To: arslist@ARSLIST.ORG Subject: Re: What would $--1$ relate to? Thorin, I understand that Macros continue to work. ( Well, as far as I can tell.) But just for the record: AdvancedGuide-630.pdf , page 250 Macros stopped being supported in the AR System 5.x release. You can view reports created using run macro report actions with releases prior to AR System 5.x in Remedy User, or on the Web, by converting them to an equivalent active link. And since v6.3 is now unsupported. Well, that clearly puts Macros on the shelf for me. Note: I still use them too. :) But if the vendor can not support them, then neither can I. -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Sun, May 10, 2009 at 3:13 PM, Marty.Thorin thorin.ma...@we-energies.com wrote: I do not have a problem with macros in 2009. At We Energies we do not use the MidTier to directly support our users. All users use the Windows User Tool. We were using macros when I got here in 1999. We are still using macros and all users have been upgraded to the 7.1 user tool. 7.5 is being implemented. We have not had a problem yet. Our issues all relate to reports. We use Crystal Reports 9 reports with the 7.1 Patch 2 user tool (Crystal Reports IX) and a Remedy 6.3 report server (CR 9). Now that is interesting. Thorin -Original Message- From: Carey Matthew Black [mailto:black@gmail.com] Sent: Friday, May 08, 2009 3:57 PM Subject: Re: What would $--1$ relate to? Robert, I would not use it. ($--1$) Macros are technically not supported since version ARS 5. The idea that they records $NULL$ as bla...bla...bla is not a detail that I want to deal with anymore. :) The fact that they still work in the v7.5 User Tool appears to be... well... almost unexplainable. However I would use the keyword of $ NULL $ as necessary. I know that is vague, but I am not trying to be flippant or anything. It is just hard to explain the type of situation you would use a screw driver without saying something like When I need to do something with a screw. I have almost totally given up on Macros. I keep waiting for Macros v2.0 to happen, but that has yet to show itself. :) Maybe in v8.0? (or v8.5... or v9.0?) If I could only figure out why some of my Open Window actions (to run reports) seem to quietly fail for some forms and/or qualifications... maybe I could replace all of the functionality of Macros with custom workflow. G (Still stuck in v6.3 land.) -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Macros in 2009 (was What would $--1$ relate to?)
Dear Carey: I agree with you that all Macro actions can now be done with Active Links. When we find an old Active Link using a Macro we automatically upgrade it. But the Windows User Tool has a macro drop-down list with about 150 active entries. They are heavily used to prompt and then generate our reports. These macros would be difficult to eliminate without creating a 'macro page'. Plus our user community maintain their own macros. (They do this by replacing the old one. Any editing of a macro is reserved for the true Remedy Administrators.) We do not encourage creation of new macros but do not have the time to implement their reports as Active Links. (And they are happier tweaking their own reports and search paths. Many of these power users have access to Crystal Reports developer.) So macros are alive and maintained in our environment. Thorin Marty We Energies Milwaukee, WI -Original Message- From: Carey Matthew Black [mailto:black@gmail.com] Sent: Sunday, May 10, 2009 6:47 PM Subject: Re: What would $--1$ relate to? Thorin, I understand that Macros continue to work. ( Well, as far as I can tell.) But just for the record: AdvancedGuide-630.pdf , page 250 Macros stopped being supported in the AR System 5.x release. You can view reports created using run macro report actions with releases prior to AR System 5.x in Remedy User, or on the Web, by converting them to an equivalent active link. And since v6.3 is now unsupported. Well, that clearly puts Macros on the shelf for me. Note: I still use them too. :) But if the vendor can not support them, then neither can I. -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Sun, May 10, 2009 at 3:13 PM, Marty.Thorin thorin.ma...@we-energies.com wrote: I do not have a problem with macros in 2009. At We Energies we do not use the MidTier to directly support our users. All users use the Windows User Tool. We were using macros when I got here in 1999. We are still using macros and all users have been upgraded to the 7.1 user tool. 7.5 is being implemented. We have not had a problem yet. Our issues all relate to reports. We use Crystal Reports 9 reports with the 7.1 Patch 2 user tool (Crystal Reports IX) and a Remedy 6.3 report server (CR 9). Now that is interesting. Thorin -Original Message- From: Carey Matthew Black [mailto:black@gmail.com] Sent: Friday, May 08, 2009 3:57 PM Subject: Re: What would $--1$ relate to? Robert, I would not use it. ($--1$) Macros are technically not supported since version ARS 5. The idea that they records $NULL$ as bla...bla...bla is not a detail that I want to deal with anymore. :) The fact that they still work in the v7.5 User Tool appears to be... well... almost unexplainable. However I would use the keyword of $ NULL $ as necessary. I know that is vague, but I am not trying to be flippant or anything. It is just hard to explain the type of situation you would use a screw driver without saying something like When I need to do something with a screw. I have almost totally given up on Macros. I keep waiting for Macros v2.0 to happen, but that has yet to show itself. :) Maybe in v8.0? (or v8.5... or v9.0?) If I could only figure out why some of my Open Window actions (to run reports) seem to quietly fail for some forms and/or qualifications... maybe I could replace all of the functionality of Macros with custom workflow. G (Still stuck in v6.3 land.) -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Possibly spam: Using FPA ( Function Point Analysis ) with Remedy ARS
I was on an effort many years ago that used FPA to establish construction and maintenance of our internal system while we were moving to CMM level 3. We carried out a successful effort and integrated our efforts into a Remedy application for future project tracking and future estimates. You will need to know the following to move forward successfully: Since Remedy is a WYSIWYG programming tool, you cannot compare it directly to line-coded programming languages. Remedy is the equivalent of a 5th-generation programming language, allowing Remedy developers to develop far faster than coders write. We're talking around 6 orders of magnitude. You can compare Remedy to Remedy, but you can't compare Remedy to COBOL. FPA falls apart for a meaningful analysis between languages. Line-coded languages are very comment-intensive. Remedy doesn't provide a meaningful method to include comments with workflow. This, too, will skew your FPA between languages, since you will have to perform your documentation via some external method. Our team broke down workflow by relative complexity assigning a weight to each type of workflow and using the included number of actions and difficulty of the qualification to arrive at the total complexity of each piece of workflow. In this way, we were able to track each project by total pieces of workflow generated, tested, and implemented, using those numbers for future projects and extrapolating them to dollars and cents. Looking back, I still think it was an excellent system. Please let me know how your team decides to perform your analysis. Best of luck attaining CMMI level 3. I've always enjoyed working with CMMI. Regards, Jennifer Meyer Remedy Technical Support Specialist State of North Carolina Office Of Information Technology Services Service Delivery Division ITSM ITAM Services Office: 919-754-6543 ITS Service Desk: 919-754-6000 jennifer.me...@its.nc.govmailto:jennifer.me...@its.nc.gov http://its.state.nc.us E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mario Roberto Porto Fº Sent: Sunday, May 10, 2009 9:02 PM To: arslist@ARSLIST.ORG Subject: Possibly spam: Using FPA ( Function Point Analysis ) with Remedy ARS Hi there In my company we decided to use FPA ( Function Point Analisys ) as the standart to estimate construction and maintenance of our internal system ( We are also in proccess of establish CMMI level 2-3 ) Id like to know if someone already had the expirence of counting FPA for ARS development. If so, what are the points of attention, results, its ok or not. Thanks a lot Mario Roberto Sao Paulo - Brazil _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Webservices
LJ, I do feel your pain. :) I think that in v7.1 (with the advent of Filter Error handlers) you could move the Web Service call to a filter all it's own and have it call an Error handler that does that for the user. My previous point is that as an integration feature such things should be specific to the integration feature. More to the point any integration feature should _expect_ that the needs for each integration type might be different than the needs for the overall workflow engine, or other integration types. (AKA: WebServices might require special integration needs that Run Processes, $PROCESS$, AR Plugin calls, Flashboard, etc.. need.) The way an integration is built into the overall workflow engine should deal with those details without conflicting with other integration methods. Which lead me to ask for error handling during consumes of WebServices action that is specific to the action/web service being consumed. -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Mon, May 11, 2009 at 9:24 AM, LJ Longwing lj.longw...@gmail.com wrote: That list reminded me about another one that bugs me. I don't like how when an external webservice times out, the client tells you there is a problem with the plugin server and tells you to contact your Remedy Administrator. In this case, there is NOTHING wrong with Remedy, the issue is with the external webservice not responding, but the only way to tell that is to recreate the situation with logging on, then call the other team with the log in hand. It would be nice if Remedy would say something like 'Unable to contact web service at this target URI 'blah' -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Carey Matthew Black Sent: Saturday, May 09, 2009 7:29 AM To: arslist@ARSLIST.ORG Subject: Re: Webservices Axton, My Web Services experience is only current through v6.3. ( Which is now EOL'ed. :( ) So maybe some of these ideas have been addressed partially or totally in 7.5, but I doubt it. First I will divide this question it to two questions: Q1) What do you think about how ARSystem publishes WebServices? A1) Overall Grade: B. Major Areas that need improvement; * Error handling -- Log to ARS form -- To ARS Group (for real time notifications) * support for missing complex XML structures Improvement ideas: * Allow for one or more XSLT transformations before/after the WebService * Never allow for a break in functionality like what happened at v7.0.1. G. Which broke ARS connectivity from Mid-Tiers newer than x and ARS servers that were older than x(the same version). Q2) What do you think about how ARSystem consumes WebServices? A2) Overall Grade: C. Major Areas that need improvement; * Advanced mode for Set field from a Web Service - Support data driven Method, InputMap, and/or OutputMap values - Provide a way for an Alias to be used to MAP a WebService URL from ar.conf . ( To allow prod and dev to be coded [filter objects identical] the same but the ARServer points at different target URLs at runtime.) * Better fail/retry options. Maybe retry N times then throw the ARERROR. Maybe support On fail call WebService 'other' instead of ARERROR Maybe support On fail call FilterGuide 'fGuide' instead of ARERROR * Allow for each consuming action to control the timeout for that external call. Instead of only having one global setting on the AR Server level let the action define a more restrictive value for that action. * Allow for one or more XSLT transformations before/after the WebService * Support the full XML standard without restrictions for some XML structures. Even if ARS can not publish all XML structures it should be able to consume them all. :) I am sure there are other ideas that have slipped into the void over the time I have used ARS WebService interfaces... but that is what comes to mind right now. Hope that helps. In general, I look forward to the day that all attributes of ARS workflow(AKA: every setting of every action) can be data driven. That will be a very big step forward for the platform. -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Fri, May 8, 2009 at 10:26 AM, Axton axton.gr...@gmail.com wrote: ** I wanted to get a feel from the group on some of the headaches and limitations of the Remedy web services implementation. I've avoided the interface,
Is there anyway to pass a parameter to SQL Menu?
The documentation doesnt mention whether this can be done or not. I need to pass the current request number (or instance ID) into this SQL Menu Query so it will return a list based on data within the active request. See the SQL Statement below. I should not have to hard code the Instance ID and of course this will only serve one record. Any word on this? We are on ARS 7.01 / Oracle / Solaris SELECT [FIRST VALUE] FROM [FORM_NAME] TBL1 WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 AND EXISTS ( SELECT [FORM_NAME_INSTANCE_ID], COUNT(DISTINCT [FIRST VALUE]) FROM [FORM_NAME] WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 GROUP BY [FORM_NAME_INSTANCE_ID] HAVING COUNT(DISTINCT [FIRST VALUE]) = 1 ) UNION SELECT [FIRST VALUE] FROM [FORM_NAME] TBL1 WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 AND EXISTS ( SELECT [FORM_NAME_INSTANCE_ID], COUNT(DISTINCT [FIRST VALUE]) FROM [FORM_NAME] WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 GROUP BY [FORM_NAME_INSTANCE_ID]HAVING COUNT(DISTINCT [FIRST VALUE]) = 1 ) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Mid-Tier 7.5 Install on Windows - can give you an error.
FYI - Interesting problem discovered with the 7.5 installer (base and patch-1 installers) - since the installer logfiles are so large - it was difficult to find the one line to pinpoint the issue... Found that the 7.5-patch-1 installer is obviously not looking at the Envirronment Variables for the msiexec.exe application. you will receive an error message of: LOG EVENT {Description=[install iis redirector],Detail=[Exception running command: Cannot run program C:\WINDOWS\system32\msiexec (in directory C:\WINDOWS\system32): CreateProcess error=3, The system cannot find the path specified]} If the windows installation location is not C:\Windows. Our customer had a C:\WINNT installation location - we had to simply create C:\WINDOWS\System32 and copy the file there - then Mid-Tier installed correctly. Please open a product defect on the 7.5 installer to have this corrected. Thanks Robert Molenda ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Is there anyway to pass a parameter to SQL Menu?
You should be able to use $Field Name$ from the form you intent to attach the menu to to get it to substitute that value in. _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Marquez Rankin Sent: Monday, May 11, 2009 9:27 AM To: arslist@ARSLIST.ORG Subject: Is there anyway to pass a parameter to SQL Menu? ** The documentation doesnt mention whether this can be done or not. I need to pass the current request number (or instance ID) into this SQL Menu Query so it will return a list based on data within the active request. See the SQL Statement below. I should not have to hard code the Instance ID and of course this will only serve one record. Any word on this? We are on ARS 7.01 / Oracle / Solaris SELECT [FIRST VALUE] FROM [FORM_NAME] TBL1 WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 AND EXISTS ( SELECT [FORM_NAME_INSTANCE_ID], COUNT(DISTINCT [FIRST VALUE]) FROM [FORM_NAME] WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 GROUP BY [FORM_NAME_INSTANCE_ID] HAVING COUNT(DISTINCT [FIRST VALUE]) = 1 ) UNION SELECT [FIRST VALUE] FROM [FORM_NAME] TBL1 WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 AND EXISTS ( SELECT [FORM_NAME_INSTANCE_ID], COUNT(DISTINCT [FIRST VALUE]) FROM [FORM_NAME] WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 GROUP BY [FORM_NAME_INSTANCE_ID]HAVING COUNT(DISTINCT [FIRST VALUE]) = 1 ) _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: 3 Fields into one Selection Field
Brilliant! Works like a charm. Thanks s much!! Lisa From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Friday, May 08, 2009 3:53 PM To: arslist@ARSLIST.ORG Subject: Re: 3 Fields into one Selection Field ** Oh... It sounds like you need 3 SQLs unioned together then Try SELECT field1 FROM tablex WHERE fieldontablex = '$fieldonopenform$' UNION SELECT field2 FROM tablex WHERE fieldontablex = '$fieldonopenform$' UNION SELECT field3 FROM tablex WHERE fieldontablex = '$fieldonopenform$' Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa Sent: Friday, May 08, 2009 2:46 PM To: arslist@ARSLIST.ORG Subject: Re: 3 Fields into one Selection Field Thanks, the vertical bars worked. But now I'm just getting one field to select from 717-555-2408 717-555-3254 I want the customer to choose 717-555-2408 OR 717-555-3254... Lisa From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Friday, May 08, 2009 3:21 PM To: arslist@ARSLIST.ORG Subject: Re: 3 Fields into one Selection Field What Database are you using? For Oracle you use 2 vertical bars SELECT DISTINCT(field1 || ' ' || field2 || ' ' || field3) FROM tablex WHERE fieldontablex = '$fieldonopenform$' Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa Sent: Friday, May 08, 2009 1:48 PM To: arslist@ARSLIST.ORG Subject: Re: 3 Fields into one Selection Field I get an invalid number when I plug this into the menu and try the select field on the form. Lisa From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jason Sent: Friday, May 08, 2009 1:51 PM To: arslist@ARSLIST.ORG Subject: Re: 3 Fields into one Selection Field Lisa, You can combine multiple fields into 1 menu using a SQL menu type. SELECT DISTINCT(field1 + ' ' + field2 + ' ' + field3) FROM tablex WHERE fieldontablex = '$fieldonopenform$' Jason Bess Remedy Engineer Camp Victory, Iraq From: Kemes, Lisa lisa.ke...@tycoelectronics.com To: arslist@ARSLIST.ORG Sent: Friday, May 8, 2009 7:12:58 PM Subject: 3 Fields into one Selection Field I'm creating an on call system and I have three fields, Work Phone, Home Phone and Cell Phone. I also have three other fields called Call First, Call Second, Call Third. I'd like to have the Numbers in the first three fields be a selection on a drop down menu for each of the other three fields. Is there a way to do this? (I don't think so). I have it set up the they can choose from a set of responses like Work Home and Cell but I would rather have the actual phone numbers for them to choose from. Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Slow to Switch between records in the search results list
Does the form have one or more tables on it that pull in data from other forms (or even the same form)? If so, make sure that the form it is pulling data from has an index that covers the qualification the table uses to pull data. I've also seen it take a long time where there is workflow configured to iterate over the rows in the table, and the processing took a while. That's just one possibility. I would agree with the logging. I would also turn on Active Link logging. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Monday, May 11, 2009 7:28 AM To: arslist@ARSLIST.ORG Subject: Re: Slow to Switch between records in the search results list ** I would turn on API and SQL Logging before doing the switch and see if you can see any delays in the logs From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of kiran kodali Sent: Monday, May 11, 2009 7:12 AM To: arslist@ARSLIST.ORG Subject: Slow to Switch between records in the search results list ** Hi All, It is taking much time to switch between records in the search results list in user client. Did anybody experience the same problem? It happens even with the forms having less data(500 records). Please let me know the parameters that would be affecting this dealy in switching b/w records. Thanks. ARS 7.1 P006 Oracle 10G/Solaris -- Regards, Kiran Kodali Ph: 940-231-8524 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message 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 email and destroy all copies of the original message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Mid-Tier 7.5 Install on Windows - can give you an error.
Robert, Are you asking someone from the ARSList to open that defect for you? _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Robert Molenda Sent: Monday, May 11, 2009 9:53 AM To: arslist@ARSLIST.ORG Subject: Mid-Tier 7.5 Install on Windows - can give you an error. ** FYI - Interesting problem discovered with the 7.5 installer (base and patch-1 installers) - since the installer logfiles are so large - it was difficult to find the one line to pinpoint the issue... Found that the 7.5-patch-1 installer is obviously not looking at the Envirronment Variables for the msiexec.exe application. you will receive an error message of: LOG EVENT {Description=[install iis redirector],Detail=[Exception running command: Cannot run program C:\WINDOWS\system32\msiexec (in directory C:\WINDOWS\system32): CreateProcess error=3, The system cannot find the path specified]} If the windows installation location is not C:\Windows. Our customer had a C:\WINNT installation location - we had to simply create C:\WINDOWS\System32 and copy the file there - then Mid-Tier installed correctly. Please open a product defect on the 7.5 installer to have this corrected. Thanks Robert Molenda _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Mid-Tier 7.5 Install on Windows - can give you an error.
Whoops - no - sorry - I have already opened the defect with BMC already!!! Sorry list - not enough cafe this morning... Just wanted the list to have this information about non-standard windows install loctions, etc. Thanks for asking - and sorry for my bad... Robert On Mon, May 11, 2009 at 8:57 AM, LJ Longwing lj.longw...@gmail.com wrote: ** Robert, Are you asking someone from the ARSList to open that defect for you? -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Robert Molenda *Sent:* Monday, May 11, 2009 9:53 AM *To:* arslist@ARSLIST.ORG *Subject:* Mid-Tier 7.5 Install on Windows - can give you an error. ** FYI - Interesting problem discovered with the 7.5 installer (base and patch-1 installers) - since the installer logfiles are so large - it was difficult to find the one line to pinpoint the issue... Found that the 7.5-patch-1 installer is obviously not looking at the Envirronment Variables for the msiexec.exe application. you will receive an error message of: LOG EVENT {Description=[install iis redirector],Detail=[Exception running command: Cannot run program C:\WINDOWS\system32\msiexec (in directory C:\WINDOWS\system32): CreateProcess error=3, The system cannot find the path specified]} If the windows installation location is not C:\Windows. Our customer had a C:\WINNT installation location - we had to simply create C:\WINDOWS\System32 and copy the file there - then Mid-Tier installed correctly. Please open a product defect on the 7.5 installer to have this corrected. Thanks Robert Molenda _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ -- If it were not for the gutter, my mind would be homeless! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: 3 Fields into one Selection Field
H, this might even be better, because another complexity I have is that if the user selects HOME for Call First I don't want HOME to be a selection for Call Second since it's already been selected. ANOTHER brilliant solution! Thanks so much!! Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky Sent: Monday, May 11, 2009 7:11 AM To: arslist@ARSLIST.ORG Subject: Re: 3 Fields into one Selection Field Hi, Why not have a char-menu show the values Work Phone, Home Phone and Cell Phone. Then have active-links that triggers on Menu Choise that populates the fields with the right value. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. I'm creating an on call system and I have three fields, Work Phone, Home Phone and Cell Phone. I also have three other fields called Call First, Call Second, Call Third. I'd like to have the Numbers in the first three fields be a selection on a drop down menu for each of the other three fields. Is there a way to do this? (I don't think so). I have it set up the they can choose from a set of responses like Work Home and Cell but I would rather have the actual phone numbers for them to choose from. Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: A little 6.3 mid tier help if you please!
Thanks Fred. I suspected that would be the only way to do this...I just didn't want to log anyone out... Oh bother! On Sat, May 9, 2009 at 6:29 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: ** Go ahead and logout the technician using the Logout Servlet. Use the goto parameter to re-open your signature (which will also force a login for the client). Something like… /arsys/servlet/LogoutServlet?goto=/arsys/forms/…. ?eid= Fred *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Warren Baltimore *Sent:* Saturday, May 09, 2009 4:22 PM *To:* arslist@ARSLIST.ORG *Subject:* A little 6.3 mid tier help if you please! ARS 6.3 Mid Tier 6.3 Apache Here's the deal I have a form used by the field techs when refreshing new equipment. Once the tech has provisioned all of the equipment, and they have finished recording which equipment the customer is getting, he/she clicks a check box that pushes the information to a signature page. So far so good The problem that I have is I want to instantly pop a window that will allow the customer to login and sign for the equipment. My problem is this, the tech is going to be signed on using the Mid Tier. I am using the ViewFormServlet to indicate which form and Request to open, but I need it to open NOT as the tech, but as the customer. I've tried using the username= paramater, but no matter what I do, the form opens as the Technician. By the way, I'm not doing an open window to the form. Instead, I am opening a display only form with a view field. I am setting that view field to the page I want. Is there a way for me to get to where I want to be? I don't want to send a notification to the user via email as that will be subject to the vagaries of email and time! I want the tech to be able to just click and go. Get the sig and be done. I know that if I logout the tech, then the whole thing is going to die (at least that's what I expect to happen.) I suspect that there is a way of opening that new browser in the view field independant of the technician's session. Any ideas? Or do I just need to swallow and go the email route? Thanks in Advance! -- Warren R. Baltimore II Remedy Developer 410-533-5367 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ -- Warren R. Baltimore II Remedy Developer 410-533-5367 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: A little 6.3 mid tier help if you please!
Thanks Matt! I think I'm going to stick with just logging out the tech Warren On Sat, May 9, 2009 at 7:09 PM, Carey Matthew Black black@gmail.comwrote: Warren, Ok... how about this... :) Put together a small JSP page that would authenticate against the ARS Server then submit a record and then logout. If you know a little Java and HTML it should not be to hard to whip that up. -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Sat, May 9, 2009 at 6:49 PM, Carey Matthew Black black@gmail.com wrote: Warren, Oh... strike that.. that only checks the current users password. Doh... -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Sat, May 9, 2009 at 6:40 PM, Carey Matthew Black black@gmail.com wrote: Warren, I would think about this as an idea... BasicGuide-630.2006.05.09.pdf Pg: 619 -- Application-Confirm-Password You can build a dialog to capture the other users password and submit it it as a customer signature record. If the password is valid then a record would be created. If not, then an error should be thrown. Then the tech can finish up anything they need to and submit the whole set of data. :) Or workflow can auto trigger all of that from the dialog when the customer signature submit works. :) Just make sure that the customer could login and sign the records later too and I think you should be good to go. That way the tech could finish it pending a signature when the customer is not there, and the customer could sign for it later. -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Sat, May 9, 2009 at 5:21 PM, Warren Baltimore warrenbaltim...@gmail.com wrote: ** ARS 6.3 Mid Tier 6.3 Apache Here's the deal I have a form used by the field techs when refreshing new equipment. Once the tech has provisioned all of the equipment, and they have finished recording which equipment the customer is getting, he/she clicks a check box that pushes the information to a signature page. So far so good The problem that I have is I want to instantly pop a window that will allow the customer to login and sign for the equipment. My problem is this, the tech is going to be signed on using the Mid Tier. I am using the ViewFormServlet to indicate which form and Request to open, but I need it to open NOT as the tech, but as the customer. I've tried using the username= paramater, but no matter what I do, the form opens as the Technician. By the way, I'm not doing an open window to the form. Instead, I am opening a display only form with a view field. I am setting that view field to the page I want. Is there a way for me to get to where I want to be? I don't want to send a notification to the user via email as that will be subject to the vagaries of email and time! I want the tech to be able to just click and go. Get the sig and be done. I know that if I logout the tech, then the whole thing is going to die (at least that's what I expect to happen.) I suspect that there is a way of opening that new browser in the view field independant of the technician's session. Any ideas? Or do I just need to swallow and go the email route? Thanks in Advance! -- Warren R. Baltimore II Remedy Developer 410-533-5367 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist: Where the Answers Are -- Warren R. Baltimore II Remedy Developer 410-533-5367 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Mid-Tier 7.5 Install on Windows - can give you an error.
:)we all understand the Monday mind isn't quite awake till noon...:) _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Robert Molenda Sent: Monday, May 11, 2009 10:02 AM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier 7.5 Install on Windows - can give you an error. ** Whoops - no - sorry - I have already opened the defect with BMC already!!! Sorry list - not enough cafe this morning... Just wanted the list to have this information about non-standard windows install loctions, etc. Thanks for asking - and sorry for my bad... Robert On Mon, May 11, 2009 at 8:57 AM, LJ Longwing lj.longw...@gmail.com wrote: ** Robert, Are you asking someone from the ARSList to open that defect for you? _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Robert Molenda Sent: Monday, May 11, 2009 9:53 AM To: arslist@ARSLIST.ORG Subject: Mid-Tier 7.5 Install on Windows - can give you an error. ** FYI - Interesting problem discovered with the 7.5 installer (base and patch-1 installers) - since the installer logfiles are so large - it was difficult to find the one line to pinpoint the issue... Found that the 7.5-patch-1 installer is obviously not looking at the Envirronment Variables for the msiexec.exe application. you will receive an error message of: LOG EVENT {Description=[install iis redirector],Detail=[Exception running command: Cannot run program C:\WINDOWS\system32\msiexec (in directory C:\WINDOWS\system32): CreateProcess error=3, The system cannot find the path specified]} If the windows installation location is not C:\Windows. Our customer had a C:\WINNT installation location - we had to simply create C:\WINDOWS\System32 and copy the file there - then Mid-Tier installed correctly. Please open a product defect on the 7.5 installer to have this corrected. Thanks Robert Molenda _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ -- If it were not for the gutter, my mind would be homeless! _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Possibly spam: Using FPA ( Function Point Analysis ) with Remedy ARS
Remedy is the equivalent of a 5th-generation programming language, allowing Remedy developers to develop far faster than coders write. We're talking around 6 orders of magnitude. That's not my experience. Simple development and prototyping can be very fast in Remedy. Significant development with complex applications with good user interaction is difficult and time consuming in Remedy and seems to get exponentially more difficult to manage and maintain the larger and more complex the application gets. I would not even say that Remedy is an order of magnitude faster (10 times faster) than traditional development even for simple applications, let alone 6 orders of magnitude. For some things it can be much faster, but it depends entirely on what you're trying to accomplish and the level of refinement you're trying to achieve when it comes to user interaction. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Meyer, Jennifer L Sent: Monday, May 11, 2009 7:57 AM To: arslist@ARSLIST.ORG Subject: Re: Possibly spam: Using FPA ( Function Point Analysis ) with Remedy ARS ** I was on an effort many years ago that used FPA to establish construction and maintenance of our internal system while we were moving to CMM level 3. We carried out a successful effort and integrated our efforts into a Remedy application for future project tracking and future estimates. You will need to know the following to move forward successfully: Since Remedy is a WYSIWYG programming tool, you cannot compare it directly to line-coded programming languages. Remedy is the equivalent of a 5th-generation programming language, allowing Remedy developers to develop far faster than coders write. We're talking around 6 orders of magnitude. You can compare Remedy to Remedy, but you can't compare Remedy to COBOL. FPA falls apart for a meaningful analysis between languages. Line-coded languages are very comment-intensive. Remedy doesn't provide a meaningful method to include comments with workflow. This, too, will skew your FPA between languages, since you will have to perform your documentation via some external method. Our team broke down workflow by relative complexity assigning a weight to each type of workflow and using the included number of actions and difficulty of the qualification to arrive at the total complexity of each piece of workflow. In this way, we were able to track each project by total pieces of workflow generated, tested, and implemented, using those numbers for future projects and extrapolating them to dollars and cents. Looking back, I still think it was an excellent system. Please let me know how your team decides to perform your analysis. Best of luck attaining CMMI level 3. I've always enjoyed working with CMMI. Regards, Jennifer Meyer Remedy Technical Support Specialist State of North Carolina Office Of Information Technology Services Service Delivery Division ITSM ITAM Services Office: 919-754-6543 ITS Service Desk: 919-754-6000 jennifer.me...@its.nc.govmailto:jennifer.me...@its.nc.gov http://its.state.nc.us E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mario Roberto Porto Fº Sent: Sunday, May 10, 2009 9:02 PM To: arslist@ARSLIST.ORG Subject: Possibly spam: Using FPA ( Function Point Analysis ) with Remedy ARS Hi there In my company we decided to use FPA ( Function Point Analisys ) as the standart to estimate construction and maintenance of our internal system ( We are also in proccess of establish CMMI level 2-3 ) Id like to know if someone already had the expirence of counting FPA for ARS development. If so, what are the points of attention, results, its ok or not. Thanks a lot Mario Roberto Sao Paulo - Brazil _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are__Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message 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 email and destroy all copies of the original message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Job: Remedy Developer - Dayton, OH - WPAFB
Looking for a Remedy Developer with 5 years experience. WPAFB - Dayton, OH 3 Month Temp to Hire Must possess a NAC/Secret/Top Secret Clearance US Citizen No Telecommute Rates - 40/HR W2 Hourly w/Benefits. Can not work on a C2C or 1099. Sorry that is all I know about the project right now. Just got released. Joshua Kitchen Recruiter Kforce Professional Staffing Two Prestige Place Suite 350 Miamisburg, Ohio 45342 937.449.1749 Office 937.461.6888 Fax 937.416.3456 Cell http://www.linkedin.com/in/joshkitchen Search Dayton, Ohio Jobs today! http://www.kforce.com/tech-jobs-Ohio http://www.kforce.com/Jobs/Search.aspx?Location=1039Specialty=Technolo gy-Jobsid=2189 Great People = Great Results(r) Confidentiality Notice: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are image002.gifimage004.jpgimage006.gifimage008.jpg
Re: Is there anyway to pass a parameter to SQL Menu?
Yeah we tried that with no success. Has this worked for you before? On Mon, May 11, 2009 at 10:53 AM, LJ Longwing lj.longw...@gmail.com wrote: ** You should be able to use $Field Name$ from the form you intent to attach the menu to to get it to substitute that value in. -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Marquez Rankin *Sent:* Monday, May 11, 2009 9:27 AM *To:* arslist@ARSLIST.ORG *Subject:* Is there anyway to pass a parameter to SQL Menu? ** The documentation doesnt mention whether this can be done or not. I need to pass the current request number (or instance ID) into this SQL Menu Query so it will return a list based on data within the active request. See the SQL Statement below. I should not have to hard code the Instance ID and of course this will only serve one record. Any word on this? We are on ARS 7.01 / Oracle / Solaris SELECT [FIRST VALUE] FROM [FORM_NAME] TBL1 WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 AND EXISTS ( SELECT [FORM_NAME_INSTANCE_ID], COUNT(DISTINCT [FIRST VALUE]) FROM [FORM_NAME] WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 GROUP BY [FORM_NAME_INSTANCE_ID] HAVING COUNT(DISTINCT [FIRST VALUE]) = 1 ) UNION SELECT [FIRST VALUE] FROM [FORM_NAME] TBL1 WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 AND EXISTS ( SELECT [FORM_NAME_INSTANCE_ID], COUNT(DISTINCT [FIRST VALUE]) FROM [FORM_NAME] WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 GROUP BY [FORM_NAME_INSTANCE_ID]HAVING COUNT(DISTINCT [FIRST VALUE]) = 1 ) _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Is there anyway to pass a parameter to SQL Menu?
Have you tried using $FieldID$ instead of Field Name. It would be something like ='$536870923$' From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Marquez Rankin Sent: Monday, May 11, 2009 11:22 AM To: arslist@ARSLIST.ORG Subject: Re: Is there anyway to pass a parameter to SQL Menu? Yeah we tried that with no success. Has this worked for you before? On Mon, May 11, 2009 at 10:53 AM, LJ Longwing lj.longw...@gmail.com wrote: You should be able to use $Field Name$ from the form you intent to attach the menu to to get it to substitute that value in. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Marquez Rankin Sent: Monday, May 11, 2009 9:27 AM To: arslist@ARSLIST.ORG Subject: Is there anyway to pass a parameter to SQL Menu? The documentation doesnt mention whether this can be done or not. I need to pass the current request number (or instance ID) into this SQL Menu Query so it will return a list based on data within the active request. See the SQL Statement below. I should not have to hard code the Instance ID and of course this will only serve one record. Any word on this? We are on ARS 7.01 / Oracle / Solaris SELECT [FIRST VALUE] FROM [FORM_NAME] TBL1 WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 AND EXISTS ( SELECT [FORM_NAME_INSTANCE_ID], COUNT(DISTINCT [FIRST VALUE]) FROM [FORM_NAME] WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 GROUP BY [FORM_NAME_INSTANCE_ID] HAVING COUNT(DISTINCT [FIRST VALUE]) = 1 ) UNION SELECT [FIRST VALUE] FROM [FORM_NAME] TBL1 WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 AND EXISTS ( SELECT [FORM_NAME_INSTANCE_ID], COUNT(DISTINCT [FIRST VALUE]) FROM [FORM_NAME] WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 GROUP BY [FORM_NAME_INSTANCE_ID]HAVING COUNT(DISTINCT [FIRST VALUE]) = 1 ) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Webservices
LJ, Error handling for webservices is virtually non-existent in the AR System. Our XML Gateway product handles this nicely for you with a message handling framework. Tim is right - webservices were a nice idea, but in practice, so much extra work needs to go around them to make them much use. De-coupling systems via messaging is the best way forward, and one of our clients (with a little help from Tim) has done this very successfully. The AR System is separated from Siebeil (if I recall) via a BEA Weblogic server and Java Messaging Services. The integration has failover, error handling, reporting, and all the things you'd expect from something designed for the real world. I'm happy to discuss it in more detail if you're interested. John -- John Baker, Java System Solutions. http://www.javasystemsolutions.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Is there anyway to pass a parameter to SQL Menu?
yes... $fieldID$ is actually what we tried. I have not tried $field_name$ have you done this and had it work? On Mon, May 11, 2009 at 11:25 AM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: ** Have you tried using $FieldID$ instead of Field Name. It would be something like =’$536870923$’ *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Marquez Rankin *Sent:* Monday, May 11, 2009 11:22 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Is there anyway to pass a parameter to SQL Menu? Yeah we tried that with no success. Has this worked for you before? On Mon, May 11, 2009 at 10:53 AM, LJ Longwing lj.longw...@gmail.com wrote: You should be able to use $Field Name$ from the form you intent to attach the menu to to get it to substitute that value in. -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Marquez Rankin *Sent:* Monday, May 11, 2009 9:27 AM *To:* arslist@ARSLIST.ORG *Subject:* Is there anyway to pass a parameter to SQL Menu? The documentation doesnt mention whether this can be done or not. I need to pass the current request number (or instance ID) into this SQL Menu Query so it will return a list based on data within the active request. See the SQL Statement below. I should not have to hard code the Instance ID and of course this will only serve one record. Any word on this? We are on ARS 7.01 / Oracle / Solaris SELECT [FIRST VALUE] FROM [FORM_NAME] TBL1 WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 AND EXISTS ( SELECT [FORM_NAME_INSTANCE_ID], COUNT(DISTINCT [FIRST VALUE]) FROM [FORM_NAME] WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 GROUP BY [FORM_NAME_INSTANCE_ID] HAVING COUNT(DISTINCT [FIRST VALUE]) = 1 ) UNION SELECT [FIRST VALUE] FROM [FORM_NAME] TBL1 WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 AND EXISTS ( SELECT [FORM_NAME_INSTANCE_ID], COUNT(DISTINCT [FIRST VALUE]) FROM [FORM_NAME] WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 GROUP BY [FORM_NAME_INSTANCE_ID]HAVING COUNT(DISTINCT [FIRST VALUE]) = 1 ) _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Is there anyway to pass a parameter to SQL Menu?
Frederick is correct, you use the field ID in the format he states. There are OOB menus that use direct SQL that you can use as a model. One such (in Change Management 7.0.3) is SYS:MNU:ChangeTimingReason-S. Regards, Chuck Baldi On Mon, May 11, 2009 at 12:25 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: ** Have you tried using $FieldID$ instead of Field Name. It would be something like =’$536870923$’ *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Marquez Rankin *Sent:* Monday, May 11, 2009 11:22 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Is there anyway to pass a parameter to SQL Menu? Yeah we tried that with no success. Has this worked for you before? On Mon, May 11, 2009 at 10:53 AM, LJ Longwing lj.longw...@gmail.com wrote: You should be able to use $Field Name$ from the form you intent to attach the menu to to get it to substitute that value in. -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Marquez Rankin *Sent:* Monday, May 11, 2009 9:27 AM *To:* arslist@ARSLIST.ORG *Subject:* Is there anyway to pass a parameter to SQL Menu? The documentation doesnt mention whether this can be done or not. I need to pass the current request number (or instance ID) into this SQL Menu Query so it will return a list based on data within the active request. See the SQL Statement below. I should not have to hard code the Instance ID and of course this will only serve one record. Any word on this? We are on ARS 7.01 / Oracle / Solaris SELECT [FIRST VALUE] FROM [FORM_NAME] TBL1 WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 AND EXISTS ( SELECT [FORM_NAME_INSTANCE_ID], COUNT(DISTINCT [FIRST VALUE]) FROM [FORM_NAME] WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 GROUP BY [FORM_NAME_INSTANCE_ID] HAVING COUNT(DISTINCT [FIRST VALUE]) = 1 ) UNION SELECT [FIRST VALUE] FROM [FORM_NAME] TBL1 WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 AND EXISTS ( SELECT [FORM_NAME_INSTANCE_ID], COUNT(DISTINCT [FIRST VALUE]) FROM [FORM_NAME] WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 GROUP BY [FORM_NAME_INSTANCE_ID]HAVING COUNT(DISTINCT [FIRST VALUE]) = 1 ) _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
ITSM 7 Network Bandwidth
All, I have seen this posted a few months ago and nobody answered. Does anyone have any numbers on ITSM 7 bandwidth utilization? I know a number of variables goes into this, but does BMC or anyone have any way to calculate this? We are using SQL server 2005 and Windows 2003 Server. The db and applications (Entire ITSM suite) are on separate servers and we have about 30 users creating about 150 tickets a day. The BMC Remedy thick client is going to be leveraged by the user community too. Has anyone performed a study on this or is their a good way to measure this? Thanks, Bala Patel Remedy Admin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Is there anyway to pass a parameter to SQL Menu?
I have done it in Search menus successfully...don't think I've tried it with SQLtry turning on SQL Logging in the client when you open the window and verify that the SQL being passed is correct. _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Marquez Rankin Sent: Monday, May 11, 2009 10:22 AM To: arslist@ARSLIST.ORG Subject: Re: Is there anyway to pass a parameter to SQL Menu? ** Yeah we tried that with no success. Has this worked for you before? On Mon, May 11, 2009 at 10:53 AM, LJ Longwing lj.longw...@gmail.com wrote: ** You should be able to use $Field Name$ from the form you intent to attach the menu to to get it to substitute that value in. _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Marquez Rankin Sent: Monday, May 11, 2009 9:27 AM To: arslist@ARSLIST.ORG Subject: Is there anyway to pass a parameter to SQL Menu? ** The documentation doesnt mention whether this can be done or not. I need to pass the current request number (or instance ID) into this SQL Menu Query so it will return a list based on data within the active request. See the SQL Statement below. I should not have to hard code the Instance ID and of course this will only serve one record. Any word on this? We are on ARS 7.01 / Oracle / Solaris SELECT [FIRST VALUE] FROM [FORM_NAME] TBL1 WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 AND EXISTS ( SELECT [FORM_NAME_INSTANCE_ID], COUNT(DISTINCT [FIRST VALUE]) FROM [FORM_NAME] WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 GROUP BY [FORM_NAME_INSTANCE_ID] HAVING COUNT(DISTINCT [FIRST VALUE]) = 1 ) UNION SELECT [FIRST VALUE] FROM [FORM_NAME] TBL1 WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 AND EXISTS ( SELECT [FORM_NAME_INSTANCE_ID], COUNT(DISTINCT [FIRST VALUE]) FROM [FORM_NAME] WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 GROUP BY [FORM_NAME_INSTANCE_ID]HAVING COUNT(DISTINCT [FIRST VALUE]) = 1 ) _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Is there anyway to pass a parameter to SQL Menu?
Hi Marquez, You can pass field variables in sql menus. You just have to use the field ID instead of the name. SELECT value FROM table WHERE field = '$REMEDYFIELDID$' I use that in many sql menus, works just fine... Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Monday, May 11, 2009 12:57 PM To: arslist@ARSLIST.ORG Subject: Re: Is there anyway to pass a parameter to SQL Menu? I have done it in Search menus successfully...don't think I've tried it with SQLtry turning on SQL Logging in the client when you open the window and verify that the SQL being passed is correct. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Marquez Rankin Sent: Monday, May 11, 2009 10:22 AM To: arslist@ARSLIST.ORG Subject: Re: Is there anyway to pass a parameter to SQL Menu? ** Yeah we tried that with no success. Has this worked for you before? On Mon, May 11, 2009 at 10:53 AM, LJ Longwing lj.longw...@gmail.com wrote: ** You should be able to use $Field Name$ from the form you intent to attach the menu to to get it to substitute that value in. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Marquez Rankin Sent: Monday, May 11, 2009 9:27 AM To: arslist@ARSLIST.ORG Subject: Is there anyway to pass a parameter to SQL Menu? ** The documentation doesnt mention whether this can be done or not. I need to pass the current request number (or instance ID) into this SQL Menu Query so it will return a list based on data within the active request. See the SQL Statement below. I should not have to hard code the Instance ID and of course this will only serve one record. Any word on this? We are on ARS 7.01 / Oracle / Solaris SELECT [FIRST VALUE] FROM [FORM_NAME] TBL1 WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 AND EXISTS ( SELECT [FORM_NAME_INSTANCE_ID], COUNT(DISTINCT [FIRST VALUE]) FROM [FORM_NAME] WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 GROUP BY [FORM_NAME_INSTANCE_ID] HAVING COUNT(DISTINCT [FIRST VALUE]) = 1 ) UNION SELECT [FIRST VALUE] FROM [FORM_NAME] TBL1 WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 AND EXISTS ( SELECT [FORM_NAME_INSTANCE_ID], COUNT(DISTINCT [FIRST VALUE]) FROM [FORM_NAME] WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 GROUP BY [FORM_NAME_INSTANCE_ID]HAVING COUNT(DISTINCT [FIRST VALUE]) = 1 ) _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Prepending information to 'Notes' field on a Task (on Create)
any takers on this? On Thu, May 7, 2009 at 2:28 PM, Marquez Rankin marquezran...@gmail.comwrote: The 'Notes' information in TMS:Task comes from TMS:TaskTemplateSelection which gets it from TMS:Template. I've been trying to drill back to where this advanced formating for field happens. I need to prepend some data before the template 'Note' data. Has anyone done this before, BMC Support told me this is not possible (in terms of prepending a text blob like the one below): Example: Access Request Information: Brief Summary: Brief Summary Target Date: Target Date Requester: Requester Request Type: Request Type LLogin/Name Login ID 1 Full Name 1 Login ID 2 Full Name 2 Login ID 3 Full Name 3 Item Name: List Item 1 Access Item Access Level: List Item 1 Access Level Environment: List Item 1 Environment Access Rights: List Item 1 Access Rights --- (Task Template HyperText Here) -- Now let's all take a moment to ponder the depth, brilliance, and emotional gravity of Mr. Rankin's above statements. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: ITSM 7 Network Bandwidth
This isn't really the answer you're looking for, but it sounds like you actually have a fairly light load - at least from a user perspective. From my experience so far, network latency has more of an effect on performance than raw throughput. If you've got 100 Mb networks between your servers and database, your server should have good performance so long as latency is low. From the user perspective, latency between them and the AR server(s) will also be very important. In general, there isn't necessarily a lot of data transferred between the server and the client, but the client is very chatty (lots of small transactions and messages to the server), so it's very important to keep the time it takes for those packets to get back and forth down to a minimum. I've noticed that people that sit close to the AR server(s) will get good performance with the thick client. People that are farther away, especially across a WAN, generally get better performance with the web client, even if overall throughput on the WAN is very good. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Bala Patel Sent: Monday, May 11, 2009 10:50 AM To: arslist@ARSLIST.ORG Subject: ITSM 7 Network Bandwidth ** All, I have seen this posted a few months ago and nobody answered. Does anyone have any numbers on ITSM 7 bandwidth utilization? I know a number of variables goes into this, but does BMC or anyone have any way to calculate this? We are using SQL server 2005 and Windows 2003 Server. The db and applications (Entire ITSM suite) are on separate servers and we have about 30 users creating about 150 tickets a day. The BMC Remedy thick client is going to be leveraged by the user community too. Has anyone performed a study on this or is their a good way to measure this? Thanks, Bala Patel Remedy Admin _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message 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 email and destroy all copies of the original message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Is there anyway to pass a parameter to SQL Menu?
I didn't see this response when I responded earlier... I agree, this should be working for you. Sorry for being repetitive. Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Marquez Rankin Sent: Monday, May 11, 2009 12:45 PM To: arslist@ARSLIST.ORG Subject: Re: Is there anyway to pass a parameter to SQL Menu? ** yes... $fieldID$ is actually what we tried. I have not tried $field_name$ have you done this and had it work? On Mon, May 11, 2009 at 11:25 AM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: ** Have you tried using $FieldID$ instead of Field Name. It would be something like ='$536870923$' From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Marquez Rankin Sent: Monday, May 11, 2009 11:22 AM To: arslist@ARSLIST.ORG Subject: Re: Is there anyway to pass a parameter to SQL Menu? Yeah we tried that with no success. Has this worked for you before? On Mon, May 11, 2009 at 10:53 AM, LJ Longwing lj.longw...@gmail.com wrote: You should be able to use $Field Name$ from the form you intent to attach the menu to to get it to substitute that value in. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Marquez Rankin Sent: Monday, May 11, 2009 9:27 AM To: arslist@ARSLIST.ORG Subject: Is there anyway to pass a parameter to SQL Menu? The documentation doesnt mention whether this can be done or not. I need to pass the current request number (or instance ID) into this SQL Menu Query so it will return a list based on data within the active request. See the SQL Statement below. I should not have to hard code the Instance ID and of course this will only serve one record. Any word on this? We are on ARS 7.01 / Oracle / Solaris SELECT [FIRST VALUE] FROM [FORM_NAME] TBL1 WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 AND EXISTS ( SELECT [FORM_NAME_INSTANCE_ID], COUNT(DISTINCT [FIRST VALUE]) FROM [FORM_NAME] WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 GROUP BY [FORM_NAME_INSTANCE_ID] HAVING COUNT(DISTINCT [FIRST VALUE]) = 1 ) UNION SELECT [FIRST VALUE] FROM [FORM_NAME] TBL1 WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 AND EXISTS ( SELECT [FORM_NAME_INSTANCE_ID], COUNT(DISTINCT [FIRST VALUE]) FROM [FORM_NAME] WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 GROUP BY [FORM_NAME_INSTANCE_ID]HAVING COUNT(DISTINCT [FIRST VALUE]) = 1 ) _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Prepending information to 'Notes' field on a Task (on Create)
Are you trying to get it to prepend what's in the template to the Notes field, or do you want to add something else (perhaps hard-coded) before the text contained in the template? Either way, if task template processing is anything like Incident template processing, then there is a set of filters that run in a filter guide that handle the template processing - one of those filters will handle setting the value of the task Notes field based on the template. You would probably either need to modify that filter to include the text you want prepended, or add another filter that runs after the template processing filters that resets the value of the field to something like My Prepended Text + $Notes$. To find the filters involved, your best bet would probably be to turn on filter logging and then create a task from a template to see which workflow is involved. Hope that helps a little. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Marquez Rankin Sent: Monday, May 11, 2009 11:13 AM To: arslist@ARSLIST.ORG Subject: Re: Prepending information to 'Notes' field on a Task (on Create) ** any takers on this? On Thu, May 7, 2009 at 2:28 PM, Marquez Rankin marquezran...@gmail.commailto:marquezran...@gmail.com wrote: The 'Notes' information in TMS:Task comes from TMS:TaskTemplateSelection which gets it from TMS:Template. I've been trying to drill back to where this advanced formating for field happens. I need to prepend some data before the template 'Note' data. Has anyone done this before, BMC Support told me this is not possible (in terms of prepending a text blob like the one below): Example: Access Request Information: Brief Summary: Brief Summary Target Date: Target Date Requester: Requester Request Type: Request Type LLogin/Name Login ID 1 Full Name 1 Login ID 2 Full Name 2 Login ID 3 Full Name 3 Item Name: List Item 1 Access Item Access Level: List Item 1 Access Level Environment: List Item 1 Environment Access Rights: List Item 1 Access Rights --- (Task Template HyperText Here) -- Now let's all take a moment to ponder the depth, brilliance, and emotional gravity of Mr. Rankin's above statements. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message 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 email and destroy all copies of the original message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Is there anyway to pass a parameter to SQL Menu?
Yes, it does need to be in single quotes for the sql menu. I am also using Remedy 7 on Solaris/Oracle so that should work for you as well. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Marquez Rankin Sent: Monday, May 11, 2009 1:28 PM To: arslist@ARSLIST.ORG Subject: Re: Is there anyway to pass a parameter to SQL Menu? ** So the syntax is '$FIELDID$' not $FIELDID$ ? I will try the former because the latter is what I have not and is not working On Mon, May 11, 2009 at 12:12 PM, Barnhill, Jason (Jason) jbarnh...@avaya.com wrote: ** Hi Marquez, You can pass field variables in sql menus. You just have to use the field ID instead of the name. SELECT value FROM table WHERE field = '$REMEDYFIELDID$' I use that in many sql menus, works just fine... Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Monday, May 11, 2009 12:57 PM To: arslist@ARSLIST.ORG Subject: Re: Is there anyway to pass a parameter to SQL Menu? I have done it in Search menus successfully...don't think I've tried it with SQLtry turning on SQL Logging in the client when you open the window and verify that the SQL being passed is correct. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Marquez Rankin Sent: Monday, May 11, 2009 10:22 AM To: arslist@ARSLIST.ORG Subject: Re: Is there anyway to pass a parameter to SQL Menu? ** Yeah we tried that with no success. Has this worked for you before? On Mon, May 11, 2009 at 10:53 AM, LJ Longwing lj.longw...@gmail.com wrote: ** You should be able to use $Field Name$ from the form you intent to attach the menu to to get it to substitute that value in. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Marquez Rankin Sent: Monday, May 11, 2009 9:27 AM To: arslist@ARSLIST.ORG Subject: Is there anyway to pass a parameter to SQL Menu? ** The documentation doesnt mention whether this can be done or not. I need to pass the current request number (or instance ID) into this SQL Menu Query so it will return a list based on data within the active request. See the SQL Statement below. I should not have to hard code the Instance ID and of course this will only serve one record. Any word on this? We are on ARS 7.01 / Oracle / Solaris SELECT [FIRST VALUE] FROM [FORM_NAME] TBL1 WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 AND EXISTS ( SELECT [FORM_NAME_INSTANCE_ID], COUNT(DISTINCT [FIRST VALUE]) FROM [FORM_NAME] WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 GROUP BY [FORM_NAME_INSTANCE_ID] HAVING COUNT(DISTINCT [FIRST VALUE]) = 1 ) UNION SELECT [FIRST VALUE] FROM [FORM_NAME] TBL1 WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 AND EXISTS ( SELECT [FORM_NAME_INSTANCE_ID], COUNT(DISTINCT [FIRST VALUE]) FROM [FORM_NAME] WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 GROUP BY [FORM_NAME_INSTANCE_ID]HAVING COUNT(DISTINCT [FIRST VALUE]) = 1 ) _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ -- Now let's all take a moment to ponder the depth, brilliance, and emotional gravity of Mr. Rankin's above statements. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Is there anyway to pass a parameter to SQL Menu?
So the syntax is '$FIELDID$' not $FIELDID$ ? I will try the former because the latter is what I have not and is not working On Mon, May 11, 2009 at 12:12 PM, Barnhill, Jason (Jason) jbarnh...@avaya.com wrote: ** Hi Marquez, You can pass field variables in sql menus. You just have to use the field ID instead of the name. SELECT value FROM table WHERE field = ‘$REMEDYFIELDID$’ I use that in many sql menus, works just fine… Jason -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *LJ Longwing *Sent:* Monday, May 11, 2009 12:57 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Is there anyway to pass a parameter to SQL Menu? I have done it in Search menus successfully...don't think I've tried it with SQLtry turning on SQL Logging in the client when you open the window and verify that the SQL being passed is correct. -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Marquez Rankin *Sent:* Monday, May 11, 2009 10:22 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Is there anyway to pass a parameter to SQL Menu? ** Yeah we tried that with no success. Has this worked for you before? On Mon, May 11, 2009 at 10:53 AM, LJ Longwing lj.longw...@gmail.com wrote: ** You should be able to use $Field Name$ from the form you intent to attach the menu to to get it to substitute that value in. -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Marquez Rankin *Sent:* Monday, May 11, 2009 9:27 AM *To:* arslist@ARSLIST.ORG *Subject:* Is there anyway to pass a parameter to SQL Menu? ** The documentation doesnt mention whether this can be done or not. I need to pass the current request number (or instance ID) into this SQL Menu Query so it will return a list based on data within the active request. See the SQL Statement below. I should not have to hard code the Instance ID and of course this will only serve one record. Any word on this? We are on ARS 7.01 / Oracle / Solaris SELECT [FIRST VALUE] FROM [FORM_NAME] TBL1 WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 AND EXISTS ( SELECT [FORM_NAME_INSTANCE_ID], COUNT(DISTINCT [FIRST VALUE]) FROM [FORM_NAME] WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 GROUP BY [FORM_NAME_INSTANCE_ID] HAVING COUNT(DISTINCT [FIRST VALUE]) = 1 ) UNION SELECT [FIRST VALUE] FROM [FORM_NAME] TBL1 WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 AND EXISTS ( SELECT [FORM_NAME_INSTANCE_ID], COUNT(DISTINCT [FIRST VALUE]) FROM [FORM_NAME] WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS1 GROUP BY [FORM_NAME_INSTANCE_ID]HAVING COUNT(DISTINCT [FIRST VALUE]) = 1 ) _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ -- Now let's all take a moment to ponder the depth, brilliance, and emotional gravity of Mr. Rankin's above statements. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
OT: Experienced Remedy Developer looking for remote or C2C contract.
10+ years experience as a Remedy Developer looking for remote or contract work. Resume and references furnished upon request. Please contact off-line. Thank you. -- Best Regards, Steve Casey 813-334-5949 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Prepending information to 'Notes' field on a Task (on Create)
Thanks I need to do the latter I will look for those filters. On Mon, May 11, 2009 at 12:20 PM, Lyle Taylor tayl...@ldschurch.org wrote: ** Are you trying to get it to prepend what’s in the template to the Notes field, or do you want to add something else (perhaps hard-coded) before the text contained in the template? Either way, if task template processing is anything like Incident template processing, then there is a set of filters that run in a filter guide that handle the template processing – one of those filters will handle setting the value of the task Notes field based on the template. You would probably either need to modify that filter to include the text you want prepended, or add another filter that runs after the template processing filters that resets the value of the field to something like “My Prepended Text” + $Notes$. To find the filters involved, your best bet would probably be to turn on filter logging and then create a task from a template to see which workflow is involved. Hope that helps a little. Lyle *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Marquez Rankin *Sent:* Monday, May 11, 2009 11:13 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Prepending information to 'Notes' field on a Task (on Create) ** any takers on this? On Thu, May 7, 2009 at 2:28 PM, Marquez Rankin marquezran...@gmail.com wrote: The 'Notes' information in TMS:Task comes from TMS:TaskTemplateSelection which gets it from TMS:Template. I've been trying to drill back to where this advanced formating for field happens. I need to prepend some data before the template 'Note' data. Has anyone done this before, BMC Support told me this is not possible (in terms of prepending a text blob like the one below): Example: Access Request Information: Brief Summary: Brief Summary Target Date: Target Date Requester: Requester Request Type: Request Type LLogin/Name Login ID 1 Full Name 1 Login ID 2 Full Name 2 Login ID 3 Full Name 3 Item Name: List Item 1 Access Item Access Level: List Item 1 Access Level Environment: List Item 1 Environment Access Rights: List Item 1 Access Rights --- (Task Template HyperText Here) -- Now let's all take a moment to ponder the depth, brilliance, and emotional gravity of Mr. Rankin's above statements. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message 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 email and destroy all copies of the original message. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ -- Now let's all take a moment to ponder the depth, brilliance, and emotional gravity of Mr. Rankin's above statements. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Webservices
A clarification; You does not need XML Gateway to de-couple systems, but still it is a better system handling XML that the builtin support in AR System. -- Jarl 2009/5/11 John Baker jba...@javasystemsolutions.com: LJ, Error handling for webservices is virtually non-existent in the AR System. Our XML Gateway product handles this nicely for you with a message handling framework. Tim is right - webservices were a nice idea, but in practice, so much extra work needs to go around them to make them much use. De-coupling systems via messaging is the best way forward, and one of our clients (with a little help from Tim) has done this very successfully. The AR System is separated from Siebeil (if I recall) via a BEA Weblogic server and Java Messaging Services. The integration has failover, error handling, reporting, and all the things you'd expect from something designed for the real world. I'm happy to discuss it in more detail if you're interested. John -- John Baker, Java System Solutions. http://www.javasystemsolutions.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Webservice - sample script for a basic Remedy form
Hi everyone, Can anyone assist me with the following please. I am starting work on our first web service and was wondering if there are any sample scripts knocking around or have BMC supplied any in the past ?, for passing some test data through to a test form with the basic fields mandatory fields to create a ticket, and then to receive the response back ? If anyone knows of any script (preferably Perl) or was able to share then i would be more than grateful or alternatively, any other pointers. Many thanks in advance guys/gals. rgds, Sean ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Webservice - sample script for a basic Remedy form
Take a look at SoapUI. Not a script but should do what you're looking for. http://www.soapui.org/ Tony Worthington Sr. Technical Analyst Kohl's Department Stores N56 W17000 Ridgewood Drive Menomonee Falls, WI 53051 262.703.7763 (phone) tony.worthing...@kohls.com www.kohls.com From: Sean Harrodine sean_rem...@yahoo.co.uk To: arslist@ARSLIST.ORG Date: 05/11/2009 01:54 PM Subject: Webservice - sample script for a basic Remedy form Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG ** Hi everyone, Can anyone assist me with the following please. I am starting work on our first web service and was wondering if there are any sample scripts knocking around or have BMC supplied any in the past ?, for passing some test data through to a test form with the basic fields mandatory fields to create a ticket, and then to receive the response back ? If anyone knows of any script (preferably Perl) or was able to share then i would be more than grateful or alternatively, any other pointers. Many thanks in advance guys/gals. rgds, Sean _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ** CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages by authorized Kohl's Associates at any time without any further consent. image/jpeg
Re: Webservice - sample script for a basic Remedy form
You can use Groovy script with SoapUI. -- Jarl 2009/5/11 Tony Worthington tony.worthing...@kohls.com: Take a look at SoapUI. Not a script but should do what you're looking for. http://www.soapui.org/ Tony Worthington Sr. Technical Analyst Kohl's Department Stores N56 W17000 Ridgewood Drive Menomonee Falls, WI 53051 262.703.7763 (phone) tony.worthing...@kohls.com www.kohls.com From: Sean Harrodine sean_rem...@yahoo.co.uk To: arslist@ARSLIST.ORG Date: 05/11/2009 01:54 PM Subject: Webservice - sample script for a basic Remedy form Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG ** Hi everyone, Can anyone assist me with the following please. I am starting work on our first web service and was wondering if there are any sample scripts knocking around or have BMC supplied any in the past ?, for passing some test data through to a test form with the basic fields mandatory fields to create a ticket, and then to receive the response back ? If anyone knows of any script (preferably Perl) or was able to share then i would be more than grateful or alternatively, any other pointers. Many thanks in advance guys/gals. rgds, Sean _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages by authorized Kohl's Associates at any time without any further consent. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Webservice - sample script for a basic Remedy form
I have used the SOAP::Lite module in Perl to send and receive data thru Remedy web services. I seem to remember some examples in the Remedy BMCDN http://communities.bmc.com/communities/community/bmcdn From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sean Harrodine Sent: Monday, May 11, 2009 1:55 PM To: arslist@ARSLIST.ORG Subject: Webservice - sample script for a basic Remedy form Hi everyone, Can anyone assist me with the following please. I am starting work on our first web service and was wondering if there are any sample scripts knocking around or have BMC supplied any in the past ?, for passing some test data through to a test form with the basic fields mandatory fields to create a ticket, and then to receive the response back ? If anyone knows of any script (preferably Perl) or was able to share then i would be more than grateful or alternatively, any other pointers. Many thanks in advance guys/gals. rgds, Sean ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Remedy in Amazon Computing Cloud?
Ken, To answer your questions, theoritically, the Oracle server can be in your own server and the ARS server can be EC2 or vice versa, or as we did, we put both in the cloud. During our initial efforts to put ARS in the cloud, we found an AMI created by Oracle (AMI ami-7acb2f13) There are several AMIs available from Oracle which you could use. We chose this one for no particular reason other than 11g. When you start the AMI and login the first time, it will configure a database for you. You will find once the database is created, if you do not shut it down, it will persist (including reboots). However when you terminate the AMI, all the information (database, configurations, etc) will be lost. I would strongly encourage you to learn how to create your own AMI. After we created the database and was able to access it locally and remotely, we created our own copy of the database server AMI. But there is some gotchas which border on water-boarding torture. Oracle created a partition and stored the database on this partition, but when you create the AMI, it is not recognized as a seperate partition, just as a directory (/u02). When you start your AMI, the /etc/fstab mounts the partition but the data is not there, it is in the space reserverd for /u02 on the root partition. I'll let you figure out how to get around this. Also, if you are not a dba, you should involve a dba to help with backing up and restoring a database. Each time the AMI is shutdown, all the data, configuration, etc will be lost. You will have to implement some type of method to deploy/restore a database each time it is restored. You will not have this problem with reboots. Some sales consultants may find this adventageious since they don't have to rebuild a presentation server. Stop it and your back where you begin. The ARS server was initially placed on the same AMI (no we haven't shut it down yet) as a proof of simple concept. You can also install your own oracle server, start a MS AMI which has SQL-Server and install ARS on Windows 2003 Server. There is no real limit to what you can do in EC2. Good Luck, ==Mac On Mon, May 4, 2009 at 9:01 AM, Leihkauff, Kenneth kenneth.g.leihka...@saic.com wrote: ** Thanks for the reply. Does the Oracle 11g database need to be installed in Amazon’s EC2 environment using the “Oracle Enterprise Linux” operating system? So, do you install Remedy ARS 7.1 on a Red Hat Linux instance, and the Oracle database on a separate instance (AMI) using Oracle Enterprise Linux OS? Thanks. Ken L. -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Geoffrey Endresen *Sent:* Tuesday, April 28, 2009 1:44 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Remedy in Amazon Computing Cloud? ** Here is my outline from the presentation yesterday at NW RUG CARS (Cloud AR System) FIRST TRY Mac McMillan and Geoff Endresen Amazon.com Workflow Applications Team Presented 04/27/2009 to the NWRUG (North West Remedy User Group) Seattle,WA hosted by Amazon.com What are the services we are using? •Amazon EC2 – elastic compute cloud used to provision new hosts •Amazon S3 – simple storage solution used to store machine images •We are using BMC AR System 7.1 in our example today. What is the cloud ? •It’s elastic IP Addresses and servers allocated on demand. •How many do you need? Ask for a server get a server •Pay by the hour, month, day, even more options •AWS is a great way to reduce capital expense. •BMC wants to help you reduce Operating expense. Steps to get your AR System running in the cloud •1) Get an AWS account •2) Sign up for EC2 (Elastic Compute Cloud) •3) Use the AWS Console to Provision DB Host •4) Install AR System •5) Login via the driver, •6) still working on port settings for access via the User Tool Links and Getting started 1) Get an Amazon Web Services Account http://aws.amazon.com 2) Sign up for Amazon EC2 http://aws.amazon.com/ec2 3) Use the AWS Console to provision a DB Host •https://console.aws.amazon.com/ •https://console.aws.amazon.com/ec2/home •See video here: (how to use the console) •http://media.amazonwebservices.com/console/AwsConsole.html •Login as root 4) Install AR System •The first time we did these steps •ssh to the host using the keys •Created an oracle database •Verified via sqlplus •get the arsystem-tar file to the host •Created a non-root user (arsys) •su - arsys •./ar_install 5) Login via driver •Add the host name and port •Login as Demo •cd /opt/ar/api/src/driver •ssp 2 •Log •Demo •2 •Init •Gls •List of schemas 6) What’s next? •Setup security ports to access externally •Install a Mid-Tier web server •Storing file attachments in
Re: Using FPA ( Function Point Analysis ) with Remedy ARS
Wouldn't that define the .NET framework as a 5th generation (or higher) programming tool used to generate lower-level code? Jennifer Meyer From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Monday, May 11, 2009 3:56 PM To: arslist@ARSLIST.ORG Subject: Re: Using FPA ( Function Point Analysis ) with Remedy ARS No, I haven't done the actual analysis, I'm just speaking from my impressions based on my experience on both sides of the coin. I would agree that if you're comparing this to C programs, there's a very wide gap, and Remedy will win. However, there are now several nice frameworks available that make building applications, including database applications, much easier and quicker, and that, I believe, narrow that gap and may even invert it in some cases, depending on what you are trying to do. For example, the .NET framework and associated tools keep getting better and can make writing applications quite quick and easy. It, too, will translate much of your design to code for you, leaving you to implement things like event handlers and your business logic, which is essentially what Remedy leaves you, too. You're also left designing your own database, for the most part, but they include tools to help with that as well. My recent experience has been that I have been able to put together usable application GUIs quicker in .NET than I have in Remedy. The database portion of that takes longer (primarily because it doesn't happen as a byproduct of creating a form). The logic portion depends on the complexity of the logic and what is being done. If you want to have an N-tier architecture, then it does get more complicated, as that is already provided for you with Remedy. Again, no hard numbers, just impressions, but I would be surprised if your numbers came out anywhere near what you got for C programs if you did it again with more modern application building frameworks and tools. I would also think that the numbers would change depending on what you're trying to implement including aspects of user interaction and logic within the application, as well as the size of the application you are developing. My personal experience has been that it has been easier for me to test and maintain complex but well written programs in C++ or .NET than it has been to do the same with things like the ITSM applications, primarily due to the way the Remedy environment was designed and the tools that I have available to me for the other environments. Then again, it may also have a bit to do with my relative levels of experience in the different domains... I don't mean to try to invalidate your points about FPA when comparing Remedy to code, I think they're valid. I just had a hard time with the 6 orders of magnitude difference. I think the results will be different depending on what you're comparing Remedy development to. Lyle _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Webservice - sample script for a basic Remedy form
thanks for all the input guys ! Appreciated. Sean From: LJ Longwing lj.longw...@gmail.com To: arslist@ARSLIST.ORG Sent: Monday, 11 May, 2009 20:14:51 Subject: Re: Webservice - sample script for a basic Remedy form ** Here is a snipit of a perl script I use (provided by Carey) that calls a Remedy Webservice use SOAP::Lite; my @data = ( SOAP::Data-name('Status')-value('Send'), SOAP::Data-name('Submitter')-value('PerlScript'), SOAP::Data-name('To')-value($C{email}), SOAP::Data-name('Subject')-value(Order Detail Report - $C{Order_ID}), SOAP::Data-name('Att1_attachmentName')-value($C{Order_ID}.pdf), SOAP::Data-name('Att1_attachmentData')-value($filestring) ); my $result = $soap-OpCreate(@data); if ($result-fault){ print Error calling Webservice\n; print Fault :, $result-faultstring, \n; print Faultcode :,$result-faultcode, \n; print Faultdetail :, %{$result-faultdetail}, \n; } You should be able to easily modify this to fit your needs. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sean Harrodine Sent: Monday, May 11, 2009 12:55 PM To: arslist@ARSLIST.ORG Subject: Webservice - sample script for a basic Remedy form ** Hi everyone, Can anyone assist me with the following please. I am starting work on our first web service and was wondering if there are any sample scripts knocking around or have BMC supplied any in the past ?, for passing some test data through to a test form with the basic fields mandatory fields to create a ticket, and then to receive the response back ? If anyone knows of any script (preferably Perl) or was able to share then i would be more than grateful or alternatively, any other pointers. Many thanks in advance guys/gals. rgds, Sean _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Using FPA ( Function Point Analysis ) with Remedy ARS
No, I don't think so. You still need to program, and the languages used to program are 3GLs. There just happen to be tools that allow you to quickly create and maintain certain types of code such as the code used to build a GUI, interact with a database, etc. You still have to maintain the code that does the real work. I think you're still in a 3G environment, just with better tools to support it. I'm also not sure that Remedy represents a 5GL as I understand it, it seems more like a 4GL. You still have to program in Remedy, you're just not typing out most of the statements like you do in other program environments - instead, you're pointing and clicking, selecting from a known subset of commands. Then, once you get beyond what that can provide, you're typing in things like keywords and functions, run process commands, etc. The approach is different (and much more limited), but it amounts to the same thing - you're designing a system with algorithms to work on the data, and you still have to do the designing and then enter that into the system. The difference in Remedy is that Remedy is intended specifically for Enterprise database applications, whereas the .NET framework and associated tools are much more generic. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Meyer, Jennifer L Sent: Monday, May 11, 2009 3:40 PM To: arslist@ARSLIST.ORG Subject: Re: Using FPA ( Function Point Analysis ) with Remedy ARS ** Wouldn't that define the .NET framework as a 5th generation (or higher) programming tool used to generate lower-level code? Jennifer Meyer From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Monday, May 11, 2009 3:56 PM To: arslist@ARSLIST.ORG Subject: Re: Using FPA ( Function Point Analysis ) with Remedy ARS No, I haven't done the actual analysis, I'm just speaking from my impressions based on my experience on both sides of the coin. I would agree that if you're comparing this to C programs, there's a very wide gap, and Remedy will win. However, there are now several nice frameworks available that make building applications, including database applications, much easier and quicker, and that, I believe, narrow that gap and may even invert it in some cases, depending on what you are trying to do. For example, the .NET framework and associated tools keep getting better and can make writing applications quite quick and easy. It, too, will translate much of your design to code for you, leaving you to implement things like event handlers and your business logic, which is essentially what Remedy leaves you, too. You're also left designing your own database, for the most part, but they include tools to help with that as well. My recent experience has been that I have been able to put together usable application GUIs quicker in .NET than I have in Remedy. The database portion of that takes longer (primarily because it doesn't happen as a byproduct of creating a form). The logic portion depends on the complexity of the logic and what is being done. If you want to have an N-tier architecture, then it does get more complicated, as that is already provided for you with Remedy. Again, no hard numbers, just impressions, but I would be surprised if your numbers came out anywhere near what you got for C programs if you did it again with more modern application building frameworks and tools. I would also think that the numbers would change depending on what you're trying to implement including aspects of user interaction and logic within the application, as well as the size of the application you are developing. My personal experience has been that it has been easier for me to test and maintain complex but well written programs in C++ or .NET than it has been to do the same with things like the ITSM applications, primarily due to the way the Remedy environment was designed and the tools that I have available to me for the other environments. Then again, it may also have a bit to do with my relative levels of experience in the different domains... I don't mean to try to invalidate your points about FPA when comparing Remedy to code, I think they're valid. I just had a hard time with the 6 orders of magnitude difference. I think the results will be different depending on what you're comparing Remedy development to. Lyle _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are__Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message 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 email and destroy all copies of the original
Strange Error
Hi All We are experiencing a strange error. It is only happening with some 4 or 5 machines currently. The error is as follows ARERR[326]Required field cannot be reset to a NULL value-SRM:WorkInfo:WorkInfoType. The problem as I said before is that it is occurring on only some machines, the only thing different i have been able to find out is that these machines are running Windows Vista as opposed to Windows XP, where this error is not happening. I can log in as the Users who are getting these error from another machine and do not get the error. I have checked all the forms and work flow permissions etc and they are all fine. The only thing is according to the users these errors started after we upgraded to ITSM patch 9. Anyone seen this error before? or can point me in the correct direction? Much appreciated. just to let you know the steps we have gone through. checked the local permissions, all directories are write able, deleted all arf and arv files, checked all permissions for users and workflow in the Remedy system. The two things pending I am trying to find out from the users(they happen to be in Israel), are, what is the value of the Work Info Type field when the Incident is being submitted and what version is the User Tool. ARS 7.01 Oracle 10.2 ITSM 7.1 patch 9 ( recently upgraded) Many thanks as usual for any help. Shafqat Ayaz ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Webservices
True enough, Jarl. However, to clarify even further, John never said you *needed* XML Gateway. You can always roll your own solution, and then maintain and support it throughout its life-cycle. It's just nice to have a product that can do so many things -- not the least of which is to take advantage of JMS, along with a decoupled, message-based data infrastructure -- right off the shelf. --Tim From: Jarl Grøneng jarl.gron...@gmail.com To: arslist@ARSLIST.ORG Sent: Monday, May 11, 2009 1:25:36 PM Subject: Re: [ARSLIST] Webservices A clarification; You does not need XML Gateway to de-couple systems, but still it is a better system handling XML that the builtin support in AR System. -- Jarl 2009/5/11 John Baker jba...@javasystemsolutions.com: LJ, Error handling for webservices is virtually non-existent in the AR System. Our XML Gateway product handles this nicely for you with a message handling framework. Tim is right - webservices were a nice idea, but in practice, so much extra work needs to go around them to make them much use. De-coupling systems via messaging is the best way forward, and one of our clients (with a little help from Tim) has done this very successfully. The AR System is separated from Siebeil (if I recall) via a BEA Weblogic server and Java Messaging Services. The integration has failover, error handling, reporting, and all the things you'd expect from something designed for the real world. I'm happy to discuss it in more detail if you're interested. John -- John Baker, Java System Solutions. http://www.javasystemsolutions.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Strange Error
Hi, Before going any further you may want to clean the ar user cached forms on these machines. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Shafqat Ayaz shafq...@yahoo.com Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Monday, May 11, 2009 6:23 PM Subject: Strange Error Hi All We are experiencing a strange error. It is only happening with some 4 or 5 machines currently. The error is as follows ARERR[326]Required field cannot be reset to a NULL value-SRM:WorkInfo:WorkInfoType. The problem as I said before is that it is occurring on only some machines, the only thing different i have been able to find out is that these machines are running Windows Vista as opposed to Windows XP, where this error is not happening. I can log in as the Users who are getting these error from another machine and do not get the error. I have checked all the forms and work flow permissions etc and they are all fine. The only thing is according to the users these errors started after we upgraded to ITSM patch 9. Anyone seen this error before? or can point me in the correct direction? Much appreciated. just to let you know the steps we have gone through. checked the local permissions, all directories are write able, deleted all arf and arv files, checked all permissions for users and workflow in the Remedy system. The two things pending I am trying to find out from the users(they happen to be in Israel), are, what is the value of the Work Info Type field when the Incident is being submitted and what version is the User Tool. ARS 7.01 Oracle 10.2 ITSM 7.1 patch 9 ( recently upgraded) Many thanks as usual for any help. Shafqat Ayaz ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Repost:Strange Error
Hi All We are getting a strange error only on some machines running Windows Vista. The error is as follows. ARERR[326]Required field cannot be set to a NULL value-SRM:WorkInfo:Work Info Type The issue is that it is occurring only on some machines and does not seem to be related to the User profile. The users can log in from a Windows XP machine and submit a ticket fine, but not from Vista machines. Have deleted all .arf and .arv files from the home directory, checked all permissions on directories on the machines, all are in order. checked the field on all the relevant forms, all are fine, the permissions are fine. If anyone has encountered this error or know what could be causing this, please help! Many thanks as usual in advance for any help/hints. ARS 7.01 ITSM 7.1 Patch 9 Oracle 10.2 Solaris Shafqat ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Strange Error
You may also want to have the user's turn on logging to see exactly what is happening -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Shafqat Ayaz Sent: Monday, May 11, 2009 5:24 PM To: arslist@ARSLIST.ORG Subject: Strange Error Hi All We are experiencing a strange error. It is only happening with some 4 or 5 machines currently. The error is as follows ARERR[326]Required field cannot be reset to a NULL value-SRM:WorkInfo:WorkInfoType. The problem as I said before is that it is occurring on only some machines, the only thing different i have been able to find out is that these machines are running Windows Vista as opposed to Windows XP, where this error is not happening. I can log in as the Users who are getting these error from another machine and do not get the error. I have checked all the forms and work flow permissions etc and they are all fine. The only thing is according to the users these errors started after we upgraded to ITSM patch 9. Anyone seen this error before? or can point me in the correct direction? Much appreciated. just to let you know the steps we have gone through. checked the local permissions, all directories are write able, deleted all arf and arv files, checked all permissions for users and workflow in the Remedy system. The two things pending I am trying to find out from the users(they happen to be in Israel), are, what is the value of the Work Info Type field when the Incident is being submitted and what version is the User Tool. ARS 7.01 Oracle 10.2 ITSM 7.1 patch 9 ( recently upgraded) Many thanks as usual for any help. Shafqat Ayaz ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Respuesta automatica de Ruben Arellano
entre el 12 y 13 de mayo estare en viaje de negocios sin acceso al correo electronico Cualquier requerimiento puedes contactar a Raidy Ferres(r...@djcs.com.ve) Este mensaje no esta siendo reenviado ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Repost:Strange Error
I would have your Vista users try the exact same actions using FireFox. If your users are on Vista, then they likely have IE 7.0 installed as that is the default browser. IE 7.0 has given us some problems with some forms (although not SRMS). We enabled a workaround by going to FireFox while we research the issue. Note: IE 8.0 does not seem to have the same issues as IE 7.0. Paul -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Shafqat Ayaz Sent: Monday, May 11, 2009 10:03 PM To: arslist@ARSLIST.ORG Subject: Repost:Strange Error Hi All We are getting a strange error only on some machines running Windows Vista. The error is as follows. ARERR[326]Required field cannot be set to a NULL value-SRM:WorkInfo:Work Info Type The issue is that it is occurring only on some machines and does not seem to be related to the User profile. The users can log in from a Windows XP machine and submit a ticket fine, but not from Vista machines. Have deleted all .arf and .arv files from the home directory, checked all permissions on directories on the machines, all are in order. checked the field on all the relevant forms, all are fine, the permissions are fine. If anyone has encountered this error or know what could be causing this, please help! Many thanks as usual in advance for any help/hints. ARS 7.01 ITSM 7.1 Patch 9 Oracle 10.2 Solaris Shafqat ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are