Re: Database CI Configuration Advice
Good point. Thank you Chris. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Danaceau, Chris Sent: Monday, June 23, 2008 2:28 PM To: arslist@ARSLIST.ORG Subject: Re: Database CI Configuration Advice We've captured databases/data servers for each platform. They are, in fact, distict entities. Look at this from a Change Management perspective. You would execute a production change that was related to a database on that particular platform (i.e. modify a table). Presumably you would have tested out your ddl changes on a lower environment (QA) database before hand. That's two distinct Infrastructure Changes on two separate databases. This e-mail and its attachments are confidential and solely for the intended addressee(s). Do not share or use them without Fannie Mae's approval. If received in error, contact the sender and delete them. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio Sent: Monday, June 23, 2008 2:06 PM To: arslist@ARSLIST.ORG Subject: Database CI Configuration Advice Good Afternoon List, I am looking for a little advice to see how you all are tracking Database CIs in the CMDB. We would like to track our databases using the CMDB for all of our platforms: Development, QA, UAT and Production. My question is should I create one CI for each platform or should I create just one CI and then relate it to all the platform servers: Development, QA, UAT and Production? Just looking for some guidance. Thank you in advance, Lou p.s. We are running AR Applications v 7.0.1 patch 006, CMDB v 2.0 under Windows 2003 Server and MS SQL 2005. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Database CI Configuration Advice
Good Afternoon List, I am looking for a little advice to see how you all are tracking Database CIs in the CMDB. We would like to track our databases using the CMDB for all of our platforms: Development, QA, UAT and Production. My question is should I create one CI for each platform or should I create just one CI and then relate it to all the platform servers: Development, QA, UAT and Production? Just looking for some guidance. Thank you in advance, Lou p.s. We are running AR Applications v 7.0.1 patch 006, CMDB v 2.0 under Windows 2003 Server and MS SQL 2005. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Trying to Load Assets into CMDB/Asset Inventory
Brian, I did just down load AIE, but I thought that I could only get data from another database. I didn't realize I could pull in data from a flat file too. And I was already putting the data into my SandBox dataset. Thanks for the info. Lou Sent from my Verizon Wireless Blackberry - Original Message - From: Action Request System discussion list(ARSList) To: arslist@ARSLIST.ORG Sent: Fri Jun 20 15:28:47 2008 Subject: Re: Trying to Load Assets into CMDB/Asset Inventory Another option is the Atrium Integration Engine. It allows you to map directly into CMDB classes as well as normal AR forms. It will map from flat files or other databases. I'm pulling asset data from SQL Server into Remedy. I would caution you however, the AIE is incredibly temperamental. But when it works it's really easy. I have found it a good idea to create a staging dataset from the CMDB console, and then setup a reconciliation job to move the data it into your production dataset. This allows you to import from multiple data sources and configure precedences. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio Sent: Friday, June 20, 2008 12:13 PM To: arslist@ARSLIST.ORG Subject: Re: Trying to Load Assets into CMDB/Asset Inventory Hi Claire, I thought about importing directly into the AST form first but I get a little paranoid moving any data directly from a spreadsheet to a system form I like to stage it to make sure that all the data is clean. Also I was hoping to automate this process for when we receive new equipment and for inventory moves. Importing works great for the first load but I don't think it will work well in the long run when I just need update and asset. How do you update your asset locations changes and such? Thank you, Lou -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sanford, Claire Sent: Friday, June 20, 2008 2:58 PM To: arslist@ARSLIST.ORG Subject: Re: Trying to Load Assets into CMDB/Asset Inventory I import them directly to the AST:ComputerSystem. it does the push to the other forms all on it's own. I make sure I set several of the hidden/background fields and it works well. I did about 34K assets this way! -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pam Hollis Sent: Friday, June 20, 2008 1:51 PM To: arslist@ARSLIST.ORG Subject: Re: Trying to Load Assets into CMDB/Asset Inventory We loaded our assets into the system. It isn't easy but first import into the BMC_CORE:BMC-BaseElement Form and then export out into an arx file each Class ID - So you may have BMC_CORE:BMC-Equipment, ComputerSystem etc. Then you import each individual one into corresponding form - example Equipment goes into the BMC_CORE:BMC_Equipment_ form and Printer go into the BMC:CORE_BMC_Printer_ and BMC:CORE_BMC_HardwareSystemComponent_ Form. Use the Update Existing Record when importing into this form. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio Sent: Friday, June 20, 2008 1:38 PM To: arslist@ARSLIST.ORG Subject: Trying to Load Assets into CMDB/Asset Inventory Hi List, I am hoping someone can help me out. I am in the process of trying to load our Server Assets into Remedy Asset Inventory and into the CMDB. We are running CMDB v 2.0 and our AR apps are v 7.0.1 patch 006, on Windows 2003 Server and MS SQL 2005. I have a csv file listing out our server assets; I've loaded the data from the csv into a custom form via the Remedy Import Tool. I've then created a Filter to "Push" the data from the custom form into the AST:ComputerSystem form. I am receiving the following error message when the Filter fires: The Product Categorization Tiers, Product Name and Manufacturer combination is not valid. Please use the menus provided for these fields to select this information. (ARERR 44901) I did create the Categorization Tiers, Product Name and Manufacturer fields on the custom form as Character fields and I am trying to "Push" the data from these fields to the corresponding fields on AST:ComputerSystem. I am using the same Name Values for the above fields in the custom form that are being used on the AST:ComputerSystem form. So I thought that this should work fine. If I am reading the error right, I guess I should have created selection fields instead of character ones on the custom form and use the same Name Values for each field. But I would have to think there must be an easier way of getting this data into the system. I noticed that the same fields in question are character fields on the BMC.Core:BMC_ComputerSystem - Join form. Should I have the Filter "Push" to this form instead of
Re: Trying to Load Assets into CMDB/Asset Inventory
Hi Claire, I thought about importing directly into the AST form first but I get a little paranoid moving any data directly from a spreadsheet to a system form I like to stage it to make sure that all the data is clean. Also I was hoping to automate this process for when we receive new equipment and for inventory moves. Importing works great for the first load but I don't think it will work well in the long run when I just need update and asset. How do you update your asset locations changes and such? Thank you, Lou -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sanford, Claire Sent: Friday, June 20, 2008 2:58 PM To: arslist@ARSLIST.ORG Subject: Re: Trying to Load Assets into CMDB/Asset Inventory I import them directly to the AST:ComputerSystem. it does the push to the other forms all on it's own. I make sure I set several of the hidden/background fields and it works well. I did about 34K assets this way! -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pam Hollis Sent: Friday, June 20, 2008 1:51 PM To: arslist@ARSLIST.ORG Subject: Re: Trying to Load Assets into CMDB/Asset Inventory We loaded our assets into the system. It isn't easy but first import into the BMC_CORE:BMC-BaseElement Form and then export out into an arx file each Class ID - So you may have BMC_CORE:BMC-Equipment, ComputerSystem etc. Then you import each individual one into corresponding form - example Equipment goes into the BMC_CORE:BMC_Equipment_ form and Printer go into the BMC:CORE_BMC_Printer_ and BMC:CORE_BMC_HardwareSystemComponent_ Form. Use the Update Existing Record when importing into this form. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio Sent: Friday, June 20, 2008 1:38 PM To: arslist@ARSLIST.ORG Subject: Trying to Load Assets into CMDB/Asset Inventory Hi List, I am hoping someone can help me out. I am in the process of trying to load our Server Assets into Remedy Asset Inventory and into the CMDB. We are running CMDB v 2.0 and our AR apps are v 7.0.1 patch 006, on Windows 2003 Server and MS SQL 2005. I have a csv file listing out our server assets; I've loaded the data from the csv into a custom form via the Remedy Import Tool. I've then created a Filter to "Push" the data from the custom form into the AST:ComputerSystem form. I am receiving the following error message when the Filter fires: The Product Categorization Tiers, Product Name and Manufacturer combination is not valid. Please use the menus provided for these fields to select this information. (ARERR 44901) I did create the Categorization Tiers, Product Name and Manufacturer fields on the custom form as Character fields and I am trying to "Push" the data from these fields to the corresponding fields on AST:ComputerSystem. I am using the same Name Values for the above fields in the custom form that are being used on the AST:ComputerSystem form. So I thought that this should work fine. If I am reading the error right, I guess I should have created selection fields instead of character ones on the custom form and use the same Name Values for each field. But I would have to think there must be an easier way of getting this data into the system. I noticed that the same fields in question are character fields on the BMC.Core:BMC_ComputerSystem - Join form. Should I have the Filter "Push" to this form instead of the AST:ComputerSystem form? If I do "Push" to the BMC form will I see the data in the AST form once the Reconciliation Engine runs? I've also recently downloaded the AIE product, should I be using that instead of the Import Tool & Filter process? Any suggestions will be very helpful. Thank you, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Trying to Load Assets into CMDB/Asset Inventory
Hi List, I am hoping someone can help me out. I am in the process of trying to load our Server Assets into Remedy Asset Inventory and into the CMDB. We are running CMDB v 2.0 and our AR apps are v 7.0.1 patch 006, on Windows 2003 Server and MS SQL 2005. I have a csv file listing out our server assets; I've loaded the data from the csv into a custom form via the Remedy Import Tool. I've then created a Filter to "Push" the data from the custom form into the AST:ComputerSystem form. I am receiving the following error message when the Filter fires: The Product Categorization Tiers, Product Name and Manufacturer combination is not valid. Please use the menus provided for these fields to select this information. (ARERR 44901) I did create the Categorization Tiers, Product Name and Manufacturer fields on the custom form as Character fields and I am trying to "Push" the data from these fields to the corresponding fields on AST:ComputerSystem. I am using the same Name Values for the above fields in the custom form that are being used on the AST:ComputerSystem form. So I thought that this should work fine. If I am reading the error right, I guess I should have created selection fields instead of character ones on the custom form and use the same Name Values for each field. But I would have to think there must be an easier way of getting this data into the system. I noticed that the same fields in question are character fields on the BMC.Core:BMC_ComputerSystem - Join form. Should I have the Filter "Push" to this form instead of the AST:ComputerSystem form? If I do "Push" to the BMC form will I see the data in the AST form once the Reconciliation Engine runs? I've also recently downloaded the AIE product, should I be using that instead of the Import Tool & Filter process? Any suggestions will be very helpful. Thank you, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: CMDB Behavior
Thanks for the information Brian. You've confirmed what I thought. I am also in the process of downloading AIE and its documentation. Thanks for your help, Lou -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Brian Gillock Sent: Tuesday, June 17, 2008 9:52 AM To: arslist@ARSLIST.ORG Subject: Re: CMDB Behavior Hey Lou, From what I've seen, you generally want to use a staging dataset and then reconcile the data into your production dataset. Which it sounds like is where you are at. The CMDB Install & Config guide shows how to setup the reconciliation. Also, I don't know if you thought about it, but the Integration Engine will push directly to a CMDB class. It works pretty good and is pretty easy to setup. Hope that helps, Brian -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio Sent: Tuesday, June 17, 2008 6:19 AM To: arslist@ARSLIST.ORG Subject: CMDB Behavior Good Morning List, We are running CMDB v 2.0 under AR System v 7.0.1 patch 006. I am in the process of trying to load Asset Data to Remedy Asset Inventory, also v 7.0.1 patch 006. I've loaded data to a regular form via the Remedy Import Tool. I've then created an Active Link to "Push" the data to the AST:Database form. It looks like I can only push the data to the CMDB into the dataset of Sandbox.Is this normal behavior? We are a windows shop w/Windows Server 2003 & MS-SQL 2005. Thank you, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
CMDB Behavior
Good Morning List, We are running CMDB v 2.0 under AR System v 7.0.1 patch 006. I am in the process of trying to load Asset Data to Remedy Asset Inventory, also v 7.0.1 patch 006. I've loaded data to a regular form via the Remedy Import Tool. I've then created an Active Link to "Push" the data to the AST:Database form. It looks like I can only push the data to the CMDB into the dataset of Sandbox.Is this normal behavior? We are a windows shop w/Windows Server 2003 & MS-SQL 2005. Thank you, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
FW: Edit Menu List....
Good Morning List, I'll apologize up front for what is a very dumb question.I am trying to edit an existing/out of the box Menu. Here is what I've done so far I captured an active link log which allowed me to track both the menu and its corresponding form and field.When I select the field on the form I find that that field is also a menu. I then tracked down that menu to its corresponding form and field and I get yet another menu. I seem to be going in circles I am trying to add a new "Role" of IT Owner and Test Owner, under the People Tab on the AST:Application form. We are running AR Applications v 7.0.1 Patch 006; under Windows Server 2003 & MS-SQL 2005. Any help would be great. Thank you, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Reconciliation Engine issue
Thanks Gary, I'll give logs a look. Lou -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Tuesday, June 10, 2008 10:57 AM To: arslist@ARSLIST.ORG Subject: Re: Reconciliation Engine issue Louis, check your logs to see if you are getting any database errors at the time. If so, trace down the first database error you get related to the issue, and then note if you SQL Server, or if your windows server were either one restarted at that time. If so, you might be running into the same issue that one other person and myself have had where remedy tries to start before sql server is up clean. It's just a stab in the dark, but it's something to rule out. Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio Sent: Tuesday, June 10, 2008 9:10 AM To: arslist@ARSLIST.ORG Subject: Reconciliation Engine issue Good Morning List, Quick question, is anyone seeing any issues with the Reconciliation Engine scheduled jobs? We have jobs running Monday through Friday @ 12:00 AM. It seems like every 10 to 15 days the jobs just stop. The jobs will run again as soon as I restart the AR System and then it will follow it's schedule for the next 10 to 15 days. We are running AR applications v 7.0.1 patch 006 w/CMDB v 2.0, under Windows Server 2003 and SQL 2005. Thank you, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Reconciliation Engine issue
Good Morning List, Quick question, is anyone seeing any issues with the Reconciliation Engine scheduled jobs? We have jobs running Monday through Friday @ 12:00 AM. It seems like every 10 to 15 days the jobs just stop. The jobs will run again as soon as I restart the AR System and then it will follow it's schedule for the next 10 to 15 days. We are running AR applications v 7.0.1 patch 006 w/CMDB v 2.0, under Windows Server 2003 and SQL 2005. Thank you, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Very Easy TR. Format Question.....
Thanks Doug! Lou --Original Message-- From: Doug Blair To: arslist@ARSLIST.ORG ReplyTo: arslist@ARSLIST.ORG Sent: May 30, 2008 3:13 PM Subject: Re: Very Easy TR. Format Question. Lou, In addition to the points about TR values in filters, you can compare the status field with the (hidden) Change Request Prev Status field in an active link in Change 7 or with the similar PreviousStatus field in Incident 7. These fields hold the DB status value and are set by workflow when the form displays. That way you can display your message before the user hits Save. Hope this helps! Doug .. Original Message ... On Fri, 30 May 2008 11:46:26 -0400 Louis Cobuccio <[EMAIL PROTECTED]> wrote: >Happy Friday List! > >I've got what should be a very, very simple question for the list. I'm >trying to get an active Link to fire when the Status field is being >moved >from its current value to Closed. I've tried adding the statement >below >in the Run If on the Basic tab but keep getting an error, also listed >below: > >Statement: 'TR.Change Request Status' = "Closed" >Error: Unexpected character (ARERR 2291) > [Qualification line error at position 26] > >Position 26 seems to be the ' after status. I then try to remove both >single quotes and I get the same error except this time it is at >position 9 >which seams to be the space between Change and Request. > >We run AR applications v 7.0.1 patch 006 in a Windows environment with >SQL >2005 database. > >Thanks, >Lou > >___ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org --Original Message Truncated-- Sent from my Verizon Wireless Blackberry
Re: Very Easy TR. Format Question.....
Thank you Matt, Rick and Elia filter will work fine for this. Have a great weekend all, Lou -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matt Reinfeldt Sent: Friday, May 30, 2008 11:55 AM To: arslist@ARSLIST.ORG Subject: Re: Very Easy TR. Format Question. Louis, TR and DB values do not work in Active Links, only server side processing. Sorry! To achieve the same affect, you would need to store the 'orig' value in a temp field and compare it to the value at the time of processing. Good luck! Matt R. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio Sent: Friday, May 30, 2008 10:46 AM To: arslist@ARSLIST.ORG Subject: Very Easy TR. Format Question. Happy Friday List! I've got what should be a very, very simple question for the list. I'm trying to get an active Link to fire when the Status field is being moved from its current value to Closed. I've tried adding the statement below in the Run If on the Basic tab but keep getting an error, also listed below: Statement: 'TR.Change Request Status' = "Closed" Error: Unexpected character (ARERR 2291) [Qualification line error at position 26] Position 26 seems to be the ' after status. I then try to remove both single quotes and I get the same error except this time it is at position 9 which seams to be the space between Change and Request. We run AR applications v 7.0.1 patch 006 in a Windows environment with SQL 2005 database. Thanks, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Very Easy TR. Format Question.....
Happy Friday List! I've got what should be a very, very simple question for the list. I'm trying to get an active Link to fire when the Status field is being moved from its current value to Closed. I've tried adding the statement below in the Run If on the Basic tab but keep getting an error, also listed below: Statement: 'TR.Change Request Status' = "Closed" Error: Unexpected character (ARERR 2291) [Qualification line error at position 26] Position 26 seems to be the ' after status. I then try to remove both single quotes and I get the same error except this time it is at position 9 which seams to be the space between Change and Request. We run AR applications v 7.0.1 patch 006 in a Windows environment with SQL 2005 database. Thanks, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Changing a Field to Required
Hi Roger, Thank you and all for the emails. Sorry I haven't replied sooner, we are in the middle of audit season :-( Anyway, here is my Run if statement: ( 'Actual Start Date' != $NULL$ ) AND ( 'z1D_Activity Type*' != "Closure Information" ) AND ( 'z1D_Summary' = $NULL$ ). My If Action is simple, Message w/Type of Error, Please enter "Closure Information" into the Work Info section of the change ticket in order to "Complete" the ticket. I've set the Execution order to 0. It looks like the action works, but it is rather shaky. The Error Message pops up as needed but the status still shows Completed and you have to refresh the screen in order for it to go back to Implementation in Progress. Also it still populates the Actual Start and End dates. Thank you, Lou -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Wednesday, May 07, 2008 1:26 PM To: arslist@ARSLIST.ORG Subject: Re: Changing a Field to Required Louis, What are the Execute On conditions and Execution Order of your Active Link? That may point you in the right direction. HTH, Roger A. Nall Manager, OSSNMS Remedy T-Mobile USA Desk: 813-348-2556 Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio Sent: Wednesday, May 07, 2008 1:17 PM To: arslist@ARSLIST.ORG Subject: Changing a Field to Required Good Afternoon List, I've been asked to make a "Work Info" entry required when a Change Ticket has been moved to a status of Completed. I thought it might be easiest to make the z1D_Summary required on the Dialog View - Close view. But it seem that the Field Change Function doesn't allow for making a field required, just visable and font changes seem to be the only changes allowed. I also tried creating a simple error message active link but it is firing after all the "Completed" workflow function fires. The error messages comes up but ticket shows Completed even though no entry was made. Any thoughts would be great. We run AR applications and System v 7.0.01 patch 006, all on Windows 2003 Servers and MS SQL 2005. Thank you ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Changing a Field to Required
Good Afternoon List, I've been asked to make a "Work Info" entry required when a Change Ticket has been moved to a status of Completed. I thought it might be easiest to make the z1D_Summary required on the Dialog View - Close view. But it seem that the Field Change Function doesn't allow for making a field required, just visable and font changes seem to be the only changes allowed. I also tried creating a simple error message active link but it is firing after all the "Completed" workflow function fires. The error messages comes up but ticket shows Completed even though no entry was made. Any thoughts would be great. We run AR applications and System v 7.0.01 patch 006, all on Windows 2003 Servers and MS SQL 2005. Thank you ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Permissions On A Join Form
That makes sense, since I no longer see those forms in the Asset Inventory Application form list. Any ideas on how I can make them part of Asset Inventory? Sorry am still pretty new to v 7. Thanks, Lou -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Scott Parrish Sent: Friday, April 18, 2008 6:02 PM To: arslist@ARSLIST.ORG Subject: Re: Permissions On A Join Form My guess is that your AST:EV:DataFeed form is no longer part of the Asset Management Deployable application and, therefore, cannot "see" the other permissions. (Yes, this can occur with custom classes when upgrading to Patch 006). The CMDB Write Security permission is a Dynamic Group (an actual field on a form with the same database id as the group id) so it will exist whether the form is part of the deployable application or not. Scott Parrish IT Prophets, LLC (770) 653-5203 www.itprophets.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio Sent: Friday, April 18, 2008 3:47 PM To: arslist@ARSLIST.ORG Subject: FW: Permissions On A Join Form Good Afternoon List, I am having an issue with some CMDB and Asset Inventory forms and permissions. All our AR Applications are running v 7.0.01 and we are on patch 006 on all apps. Issue started once we went to patch 006. We run everything under Windows Server 2003 and our Database is SQL 2005. We have a form called AST:EV:DataFeed which is a Join form. The permission on field in question as viewed on AST:EV:DataFeed is listed as CMDB Write Security which has write access, where as the source field on BMC.Core:EV_DataFeed shows permission of, CMDB Data Change, CMDB Data Change All, CMDB Data View, CMDB Data View All and CMDB Write Security. BMC.Core:EV_DataFeed form is also a Join form, and the permission are passed from that source properly to this form. I thought that if I ran a Sync Search Database process that perhaps that would refresh the database. However when I got to run the process the status shows as Running and the last synchronized time is listed as June 2007?! Any help would be great. Thanks, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Permissions On A Join Form
Thanks Scott that makes sense. I no longer see the form in the Asset Inventory deployable app. Is there anyway to get this form back into Asset Inventory? Thank you, Lou Sent from my Verizon Wireless Blackberry - Original Message - From: Action Request System discussion list(ARSList) To: arslist@ARSLIST.ORG Sent: Fri Apr 18 18:02:24 2008 Subject: Re: Permissions On A Join Form My guess is that your AST:EV:DataFeed form is no longer part of the Asset Management Deployable application and, therefore, cannot "see" the other permissions. (Yes, this can occur with custom classes when upgrading to Patch 006). The CMDB Write Security permission is a Dynamic Group (an actual field on a form with the same database id as the group id) so it will exist whether the form is part of the deployable application or not. Scott Parrish IT Prophets, LLC (770) 653-5203 www.itprophets.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio Sent: Friday, April 18, 2008 3:47 PM To: arslist@ARSLIST.ORG Subject: FW: Permissions On A Join Form Good Afternoon List, I am having an issue with some CMDB and Asset Inventory forms and permissions. All our AR Applications are running v 7.0.01 and we are on patch 006 on all apps. Issue started once we went to patch 006. We run everything under Windows Server 2003 and our Database is SQL 2005. We have a form called AST:EV:DataFeed which is a Join form. The permission on field in question as viewed on AST:EV:DataFeed is listed as CMDB Write Security which has write access, where as the source field on BMC.Core:EV_DataFeed shows permission of, CMDB Data Change, CMDB Data Change All, CMDB Data View, CMDB Data View All and CMDB Write Security. BMC.Core:EV_DataFeed form is also a Join form, and the permission are passed from that source properly to this form. I thought that if I ran a Sync Search Database process that perhaps that would refresh the database. However when I got to run the process the status shows as Running and the last synchronized time is listed as June 2007?! Any help would be great. Thanks, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
FW: Permissions On A Join Form
Good Afternoon List, I am having an issue with some CMDB and Asset Inventory forms and permissions. All our AR Applications are running v 7.0.01 and we are on patch 006 on all apps. Issue started once we went to patch 006. We run everything under Windows Server 2003 and our Database is SQL 2005. We have a form called AST:EV:DataFeed which is a Join form. The permission on field in question as viewed on AST:EV:DataFeed is listed as CMDB Write Security which has write access, where as the source field on BMC.Core:EV_DataFeed shows permission of, CMDB Data Change, CMDB Data Change All, CMDB Data View, CMDB Data View All and CMDB Write Security. BMC.Core:EV_DataFeed form is also a Join form, and the permission are passed from that source properly to this form. I thought that if I ran a Sync Search Database process that perhaps that would refresh the database. However when I got to run the process the status shows as Running and the last synchronized time is listed as June 2007?! Any help would be great. Thanks, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Patch 006, CMDB, Custom Form, Permissions
Nope users prevs stayed the same too. Lou Sent from my Verizon Wireless Blackberry - Original Message - From: Action Request System discussion list(ARSList) To: arslist@ARSLIST.ORG Sent: Fri Apr 11 15:58:56 2008 Subject: Re: Patch 006, CMDB, Custom Form, Permissions ** You mentioned that the perms on your form hadn't changed - how about that of the users accessing it? Remedy's patches sometimes do strange things. Rick On Fri, Apr 11, 2008 at 12:53 PM, Louis Cobuccio <[EMAIL PROTECTED]> wrote: ** Sorry. We applied the 006 patch to AR System, ITSM, Approval, Mid-Tier, Email Engine, Flashboards, Migrator, AR User and AR Admin. Thanks, Lou From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Friday, April 11, 2008 3:28 PM To: arslist@ARSLIST.ORG Subject: Re: Patch 006, CMDB, Custom Form, Permissions ** What sort of patch are you talking about? OS, AR System, or Application? Which patch(es)? Rick On Fri, Apr 11, 2008 at 12:06 PM, Louis Cobuccio <[EMAIL PROTECTED]> wrote: Good Afternoon everyone, We've are a Windows shop, Server 2003, MS SQL 2005, AR applications v 7.0.01 Patch 006. I've got an issue regrading a custom form which isn't working correctly since we've patch our system. We use Asset Inventory and the CMDB. We I have users that were able write data to the form prior to the upgrade, but now they can only search the form, and the search details actually appear as blank rows. The permission on the form are the exact same as in the pre-patched version, I had the old database restored in order to troublshoot, so I can't figure out why he gets only blank results and why he can't edit the data. Any thoughts would be helpful. Thank you, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___
Re: Patch 006, CMDB, Custom Form, Permissions
Sorry. We applied the 006 patch to AR System, ITSM, Approval, Mid-Tier, Email Engine, Flashboards, Migrator, AR User and AR Admin. Thanks, Lou From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Friday, April 11, 2008 3:28 PM To: arslist@ARSLIST.ORG Subject: Re: Patch 006, CMDB, Custom Form, Permissions ** What sort of patch are you talking about? OS, AR System, or Application? Which patch(es)? Rick On Fri, Apr 11, 2008 at 12:06 PM, Louis Cobuccio <[EMAIL PROTECTED]> wrote: Good Afternoon everyone, We've are a Windows shop, Server 2003, MS SQL 2005, AR applications v 7.0.01 Patch 006. I've got an issue regrading a custom form which isn't working correctly since we've patch our system. We use Asset Inventory and the CMDB. We I have users that were able write data to the form prior to the upgrade, but now they can only search the form, and the search details actually appear as blank rows. The permission on the form are the exact same as in the pre-patched version, I had the old database restored in order to troublshoot, so I can't figure out why he gets only blank results and why he can't edit the data. Any thoughts would be helpful. Thank you, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Patch 006, CMDB, Custom Form, Permissions
Good Afternoon everyone, We've are a Windows shop, Server 2003, MS SQL 2005, AR applications v 7.0.01 Patch 006. I've got an issue regrading a custom form which isn't working correctly since we've patch our system. We use Asset Inventory and the CMDB. We I have users that were able write data to the form prior to the upgrade, but now they can only search the form, and the search details actually appear as blank rows. The permission on the form are the exact same as in the pre-patched version, I had the old database restored in order to troublshoot, so I can't figure out why he gets only blank results and why he can't edit the data. Any thoughts would be helpful. Thank you, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Licensing Error Message - Production Down
J.T. & Gary, I guess our server team enabled "NIC Teaming". Once this was disabled we restarted the services and the system came back clean. Thank you both very much! I owe you both a drink if you are ever up in Boston! Lou -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman Sent: Thursday, April 10, 2008 10:00 AM To: arslist@ARSLIST.ORG Subject: Re: Licensing Error Message - Production Down Is the AR Server multihomed? That is, does it have multiple network cards? If so it may have picked up the wrong card and now your server has a different Host ID. You can verify this by going into the add licenses screen and trying to add a new license. Verify the host ID matches the existing licenses. If not, that is your cause. I may have some suggestions from there. --- J.T. Shyman -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio Sent: Thursday, April 10, 2008 9:56 AM To: arslist@ARSLIST.ORG Subject: Licensing Error Message - Production Down Importance: High Good Morning All, I hope someone has seen this before or can help me trouble shoot this issue. We lost some network connectivity in our datacenter due a software bug last night and our network team needed "applied a code upgrade to the core devices". Once the network crashed we recieved the following entries in the arerror.log, "Wed Apr 09 20:12:40 2008 [DBNETLIB][ConnectionRead (recv ()).]General network error. Check your network documentation. (SQL Server 11) Wed Apr 09 20:13:59 2008 390635 : Failure while trying to connect to the SQL database. Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550) Wed Apr 09 20:13:59 2008 Wed Apr 09 20:13:59 2008 390635 : Cannot initialize contact with SQL database (ARERR 551) Wed Apr 09 20:13:59 2008 Stop server Wed Apr 09 20:13:59 2008 390635 : AR System server terminated -- fatal error encountered (ARNOTE 21) Wed Apr 09 20:14:01 2008 390600 : This version of the Action Request System (R) is ready for use or evaluation without purchasing or activating an authorization key. For unlimited capabilities, contact your sales representative. (ARNOTE 27)" We can log into our system but we get licensing error messages when trying to select any of the application consoles, "The application is not licensed : BMC:Atrium CMDB (ARERR 9858) The preceding message occurred during the execution of active link CHG:SHR:Set_DatasetName_Default -- action 1. (ARNOTE 1101)". I've tried removing the multilicense file but that didn't help. We are running AR applications v 7.0.01 patch 006 in a windows shop, Server 2003 SQL 2005. The application and database are on seporate servers. I've logged a call with BMC support, but it's been an hour and half with no update. Thanks, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Licensing Error Message - Production Down
Thanks J.T. and Gary. I am checking with the server team. I did just try to add a new license and I do get a different Host ID. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman Sent: Thursday, April 10, 2008 10:00 AM To: arslist@ARSLIST.ORG Subject: Re: Licensing Error Message - Production Down Is the AR Server multihomed? That is, does it have multiple network cards? If so it may have picked up the wrong card and now your server has a different Host ID. You can verify this by going into the add licenses screen and trying to add a new license. Verify the host ID matches the existing licenses. If not, that is your cause. I may have some suggestions from there. --- J.T. Shyman -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio Sent: Thursday, April 10, 2008 9:56 AM To: arslist@ARSLIST.ORG Subject: Licensing Error Message - Production Down Importance: High Good Morning All, I hope someone has seen this before or can help me trouble shoot this issue. We lost some network connectivity in our datacenter due a software bug last night and our network team needed "applied a code upgrade to the core devices". Once the network crashed we recieved the following entries in the arerror.log, "Wed Apr 09 20:12:40 2008 [DBNETLIB][ConnectionRead (recv ()).]General network error. Check your network documentation. (SQL Server 11) Wed Apr 09 20:13:59 2008 390635 : Failure while trying to connect to the SQL database. Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550) Wed Apr 09 20:13:59 2008 Wed Apr 09 20:13:59 2008 390635 : Cannot initialize contact with SQL database (ARERR 551) Wed Apr 09 20:13:59 2008 Stop server Wed Apr 09 20:13:59 2008 390635 : AR System server terminated -- fatal error encountered (ARNOTE 21) Wed Apr 09 20:14:01 2008 390600 : This version of the Action Request System (R) is ready for use or evaluation without purchasing or activating an authorization key. For unlimited capabilities, contact your sales representative. (ARNOTE 27)" We can log into our system but we get licensing error messages when trying to select any of the application consoles, "The application is not licensed : BMC:Atrium CMDB (ARERR 9858) The preceding message occurred during the execution of active link CHG:SHR:Set_DatasetName_Default -- action 1. (ARNOTE 1101)". I've tried removing the multilicense file but that didn't help. We are running AR applications v 7.0.01 patch 006 in a windows shop, Server 2003 SQL 2005. The application and database are on seporate servers. I've logged a call with BMC support, but it's been an hour and half with no update. Thanks, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Licensing Error Message - Production Down
Good Morning All, I hope someone has seen this before or can help me trouble shoot this issue. We lost some network connectivity in our datacenter due a software bug last night and our network team needed "applied a code upgrade to the core devices". Once the network crashed we recieved the following entries in the arerror.log, "Wed Apr 09 20:12:40 2008 [DBNETLIB][ConnectionRead (recv ()).]General network error. Check your network documentation. (SQL Server 11) Wed Apr 09 20:13:59 2008 390635 : Failure while trying to connect to the SQL database. Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550) Wed Apr 09 20:13:59 2008 Wed Apr 09 20:13:59 2008 390635 : Cannot initialize contact with SQL database (ARERR 551) Wed Apr 09 20:13:59 2008 Stop server Wed Apr 09 20:13:59 2008 390635 : AR System server terminated -- fatal error encountered (ARNOTE 21) Wed Apr 09 20:14:01 2008 390600 : This version of the Action Request System (R) is ready for use or evaluation without purchasing or activating an authorization key. For unlimited capabilities, contact your sales representative. (ARNOTE 27)" We can log into our system but we get licensing error messages when trying to select any of the application consoles, "The application is not licensed : BMC:Atrium CMDB (ARERR 9858) The preceding message occurred during the execution of active link CHG:SHR:Set_DatasetName_Default -- action 1. (ARNOTE 1101)". I've tried removing the multilicense file but that didn't help. We are running AR applications v 7.0.01 patch 006 in a windows shop, Server 2003 SQL 2005. The application and database are on seporate servers. I've logged a call with BMC support, but it's been an hour and half with no update. Thanks, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Set Integer Field Based on Group ID
That got it. Thank you Dave. I am still trying to get up to speed on v 7. Have a great day, Lou -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of David Sanders Sent: Tuesday, April 08, 2008 4:06 PM To: arslist@ARSLIST.ORG Subject: Re: Set Integer Field Based on Group ID Lou It should be the Group ID field value from the standard Group form. I assume this value may be held in another field in your Support Group form, or there is a value there that will link to a real record in the Group form. David Sanders Remedy Solution Architect Enterprise Service Suite @ Work == ARS List Award Winner 2005 Best 3rd party Remedy Application See the ESS Concepts Guide tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio Sent: Tuesday, April 08, 2008 9:01 PM To: arslist@ARSLIST.ORG Subject: Re: Set Integer Field Based on Group ID Hi Dave, SGP0121 is the Support Group ID I got from the Application Administration Console under the Support Group link for the group I wanted to use. Did I look in the wrong place? I did try it without the SGP and the leading zeros but it still did set the value to 1. The link does fire according to the Active Link log. Thanks, Lou -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of David Sanders Sent: Tuesday, April 08, 2008 3:43 PM To: arslist@ARSLIST.ORG Subject: Re: Set Integer Field Based on Group ID Lou The Application-Confirm-Group process takes the Group ID as an input, not a Request ID. It should look something like: $PROCESS$ @@:Application-Confirm-Group 73400 HTH David Sanders Remedy Solution Architect Enterprise Service Suite @ Work == ARS List Award Winner 2005 Best 3rd party Remedy Application See the ESS Concepts Guide tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio Sent: Tuesday, April 08, 2008 8:02 PM To: arslist@ARSLIST.ORG Subject: Set Integer Field Based on Group ID Good Afternoon, I am trying to set an integer field based on the group id of user opening the a form. I then hope to leverage this field for an active link. We are a Windows shop, Windows Server 2003, MS SQL 2005, AR applications v 7.0.01 patch 006. I've done this before in AR Systems 6.3 and Change v 5.6. Here is how I setup the active link in the old system Execute on Window Loaded, no Run If Qualification. If Action has a Set Field action where the field Name is the zTmpInteger field and the value is $PROCESS$ @@:Application-Confirm-Group SGP0121. So if you are a member of Support Group Id SGP0121 then the zTmpInteger field would be set to 1. This worked great under the old system, I just want to confirm that this same command works in the new version. Any thoughts would be great. Thank you all, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Set Integer Field Based on Group ID
Hi Dave, SGP0121 is the Support Group ID I got from the Application Administration Console under the Support Group link for the group I wanted to use. Did I look in the wrong place? I did try it without the SGP and the leading zeros but it still did set the value to 1. The link does fire according to the Active Link log. Thanks, Lou -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of David Sanders Sent: Tuesday, April 08, 2008 3:43 PM To: arslist@ARSLIST.ORG Subject: Re: Set Integer Field Based on Group ID Lou The Application-Confirm-Group process takes the Group ID as an input, not a Request ID. It should look something like: $PROCESS$ @@:Application-Confirm-Group 73400 HTH David Sanders Remedy Solution Architect Enterprise Service Suite @ Work == ARS List Award Winner 2005 Best 3rd party Remedy Application See the ESS Concepts Guide tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio Sent: Tuesday, April 08, 2008 8:02 PM To: arslist@ARSLIST.ORG Subject: Set Integer Field Based on Group ID Good Afternoon, I am trying to set an integer field based on the group id of user opening the a form. I then hope to leverage this field for an active link. We are a Windows shop, Windows Server 2003, MS SQL 2005, AR applications v 7.0.01 patch 006. I've done this before in AR Systems 6.3 and Change v 5.6. Here is how I setup the active link in the old system Execute on Window Loaded, no Run If Qualification. If Action has a Set Field action where the field Name is the zTmpInteger field and the value is $PROCESS$ @@:Application-Confirm-Group SGP0121. So if you are a member of Support Group Id SGP0121 then the zTmpInteger field would be set to 1. This worked great under the old system, I just want to confirm that this same command works in the new version. Any thoughts would be great. Thank you all, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Set Integer Field Based on Group ID
Good Afternoon, I am trying to set an integer field based on the group id of user opening the a form. I then hope to leverage this field for an active link. We are a Windows shop, Windows Server 2003, MS SQL 2005, AR applications v 7.0.01 patch 006. I've done this before in AR Systems 6.3 and Change v 5.6. Here is how I setup the active link in the old system Execute on Window Loaded, no Run If Qualification. If Action has a Set Field action where the field Name is the zTmpInteger field and the value is $PROCESS$ @@:Application-Confirm-Group SGP0121. So if you are a member of Support Group Id SGP0121 then the zTmpInteger field would be set to 1. This worked great under the old system, I just want to confirm that this same command works in the new version. Any thoughts would be great. Thank you all, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Reopening a Closed Change Ticket
Thank you Eli. I'll give it a go. Have a great day, Lou -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eli Schilling Sent: Monday, April 07, 2008 1:28 PM To: arslist@ARSLIST.ORG Subject: Re: Reopening a Closed Change Ticket Lou, Open the form SYS:Status Transition rules - in here there is an entry that controls all status changes. I took the entry for Application Manager where 'From Status' - 'To Status' = "Completed" - "Implementation in Progress" and set the record to offline. However, you need to be careful when doing this because there is a lot of workflow around approvals and tasks. I built workflow so that if a change is moved from Completed to any previous status the task and approval functionality is locked down. Cheers! -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio Sent: Monday, April 07, 2008 10:22 AM To: arslist@ARSLIST.ORG Subject: Reopening a Closed Change Ticket Good Afternoon Everyone, I've got a real simple question today, at least I hope it is simple. I need to reopen a Change Management Case which was automatically set to a Closed status when all its tasks were closed.In older versions I was always able to reopen tickets as the admin of the system, set the status back to Scheduled, but it looks like that functionality might be locked down in this version. Any ideas? We run a Window Shop w/Server 2003 MS SQL 2005 & AR apps, v7.0.1 Patch 006. Thanks, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Reopening a Closed Change Ticket
Good Afternoon Everyone, I've got a real simple question today, at least I hope it is simple. I need to reopen a Change Management Case which was automatically set to a Closed status when all its tasks were closed.In older versions I was always able to reopen tickets as the admin of the system, set the status back to Scheduled, but it looks like that functionality might be locked down in this version. Any ideas? We run a Window Shop w/Server 2003 MS SQL 2005 & AR apps, v7.0.1 Patch 006. Thanks, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Include Related Items on Approval Email Notifications
Hi Ron, Yes I did mean the later, but we would have settled for an attachment if need be. Thank you for the instructions. I'll try this out in our development environment this week and let you know my results. Thanks again, Lou From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ron Tavares Sent: Tuesday, March 18, 2008 12:29 PM To: arslist@ARSLIST.ORG Subject: Re: Include Related Items on Approval Email Notifications ** Are you looking to ad the related items as attachments or just the details of the related items, such as request id, desc, etc? Assuming you meant the later, this is one way to do it: - Create a hidden character field on parent form. For this example, z-DetailsCapture - Create a Filter with one Set Field action that reads the rows you want from the 'Related Item' table and ADDs them to the character field. You can add the label of each row, followed by the value. Like this, z-DetailsCapture = z-DetailsCapture + (" Request ID: " + $Col_RequestID$). This filter should have no 'Execute On' settings. Also, ad a carriage return at the end of the set-field string so that multiple items will each show on it's own line. - Create Filter Guide that fires the Filter above. Be sure to check off 'Table Loop'. - Modify your existing filter which sends out the notification as follows: 1) Call the guide above before initiating the Notify action. 2) Ad 'z-DetailsCapture' field into your Notify action. On 3/18/08, Louis Cobuccio <[EMAIL PROTECTED]> wrote: AR v 7.0.01 Patch 006 Windows Server 2003 MS SQL 2005 Good Morning Gang, I have a request to include related items on the approval email message that is generated requesting an approval. Is this possible since all of the related item details are on a form other than CHG:Infrastructure Change? Any thoughts would be helpful. Thank you, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Include Related Items on Approval Email Notifications
AR v 7.0.01 Patch 006 Windows Server 2003 MS SQL 2005 Good Morning Gang, I have a request to include related items on the approval email message that is generated requesting an approval. Is this possible since all of the related item details are on a form other than CHG:Infrastructure Change? Any thoughts would be helpful. Thank you, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Audit Log for Deleted Tickets
Will do. Lou -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Thursday, March 13, 2008 8:31 AM To: arslist@ARSLIST.ORG Subject: Re: Audit Log for Deleted Tickets Try it - if you still get stuck email me back. Ty On Thu, Mar 13, 2008 at 8:24 AM, T. Dee <[EMAIL PROTECTED]> wrote: > No, I am talking about "Task" - it is due to the fact that someone is > blanking out the "Assignee", but Remedy is not blanking out the hidden > Assigned To field. Do a report with the Assignee and Assigned To and > you will see the problem. > > Ty > > > On Wed, Mar 12, 2008 at 4:12 PM, Louis Cobuccio > > <[EMAIL PROTECTED]> wrote: > > Ty, > > > > I don't see any hidden or temp fields for Assignee on either the Task or > > the Change form. I also just tried running a report through crystal > > against the Change form where the Infrastructure Change ID is equal to > > the change request id I see on the task form, and that didn't return any > > data, so I am thinking that this change ticket doesn't exist in the > > system any more. > > > > Lou > > > > -Original Message- > > From: Action Request System discussion list(ARSList) > > [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee > > > > Sent: Wednesday, March 12, 2008 1:44 PM > > To: arslist@ARSLIST.ORG > > Subject: Re: Audit Log for Deleted Tickets > > > > Lou - did it work? > > > > On 3/12/08, Louis Cobuccio <[EMAIL PROTECTED]> wrote: > > > Thanks Ty I'll give that a go. > > > > > > Lou > > > > > > -Original Message- > > > From: Action Request System discussion list(ARSList) > > > [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee > > > Sent: Wednesday, March 12, 2008 11:44 AM > > > To: arslist@ARSLIST.ORG > > > Subject: Re: Audit Log for Deleted Tickets > > > > > > I had this happen to - it is due to the fact that someone is blanking > > > out the "Assignee", but Remedy is not blanking out the hidden Assigned > > > To field. Do a report with the Assignee and Assigned To and you will > > > see the problem. > > > > > > Hope this helps. > > > > > > Ty > > > > > > > > > On 3/12/08, Louis Cobuccio <[EMAIL PROTECTED]> wrote: > > > > Good morning List, > > > > > > > > I've got a couple of strange ones for the list this morning. One > > of > > > > our > > > > techs found serveral Task Tickets that were in a status of Staging > > in > > > > the > > > > system. > > > > > > > > He was the only tech who could see the tickets in the console window > > > > even > > > > though the tasks are assigned only at the group level, so anyone > > else > > > in > > > > > > > > his group should see them in the console too but don't. That is > > > strange > > > > item one. > > > > > > > > Strange item two is that after sucessfully search for the tasks, I > > > can't > > > > > > > > open or search for the parent Change ticket. Here is the warning > > > > message I > > > > am receiveing: > > > > > > > > The owner request does not exist yet and cannot be opened. (ARWARN > > > > 45162) > > > > > > > > The preceding message occurred during the execution of active link > > > > TMS:SHR:OpenRootRequestDoesNotExist -- action 1. (ARNOTE 1101) > > > > > > > > My thought is that perhaps the parent change tickets were deleted > > from > > > > the > > > > system. Does that make sense? Any other thoughts on this? Is > > there > > > > any sort of audit that takes place for when an item is deleted from > > > the > > > > system? > > > > > > > > We are running version 7.0.01 patch 006 in a Windows environment > > with > > > > SQL 2005. > > > > > > > > > > > > > > > > ___ > > > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > > > > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > > > > > > > > > > > ___
Re: Audit Log for Deleted Tickets
Ty, I don't see any hidden or temp fields for Assignee on either the Task or the Change form. I also just tried running a report through crystal against the Change form where the Infrastructure Change ID is equal to the change request id I see on the task form, and that didn't return any data, so I am thinking that this change ticket doesn't exist in the system any more. Lou -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Wednesday, March 12, 2008 1:44 PM To: arslist@ARSLIST.ORG Subject: Re: Audit Log for Deleted Tickets Lou - did it work? On 3/12/08, Louis Cobuccio <[EMAIL PROTECTED]> wrote: > Thanks Ty I'll give that a go. > > Lou > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee > Sent: Wednesday, March 12, 2008 11:44 AM > To: arslist@ARSLIST.ORG > Subject: Re: Audit Log for Deleted Tickets > > I had this happen to - it is due to the fact that someone is blanking > out the "Assignee", but Remedy is not blanking out the hidden Assigned > To field. Do a report with the Assignee and Assigned To and you will > see the problem. > > Hope this helps. > > Ty > > > On 3/12/08, Louis Cobuccio <[EMAIL PROTECTED]> wrote: > > Good morning List, > > > > I've got a couple of strange ones for the list this morning. One of > > our > > techs found serveral Task Tickets that were in a status of Staging in > > the > > system. > > > > He was the only tech who could see the tickets in the console window > > even > > though the tasks are assigned only at the group level, so anyone else > in > > > > his group should see them in the console too but don't. That is > strange > > item one. > > > > Strange item two is that after sucessfully search for the tasks, I > can't > > > > open or search for the parent Change ticket. Here is the warning > > message I > > am receiveing: > > > > The owner request does not exist yet and cannot be opened. (ARWARN > > 45162) > > > > The preceding message occurred during the execution of active link > > TMS:SHR:OpenRootRequestDoesNotExist -- action 1. (ARNOTE 1101) > > > > My thought is that perhaps the parent change tickets were deleted from > > the > > system. Does that make sense? Any other thoughts on this? Is there > > any sort of audit that takes place for when an item is deleted from > the > > system? > > > > We are running version 7.0.01 patch 006 in a Windows environment with > > SQL 2005. > > > > > > ___ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Audit Log for Deleted Tickets
Sorry Tyjust getting back to my desk nowcrazy afternoon. I'll try this now. Thanks, Lou -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Wednesday, March 12, 2008 1:44 PM To: arslist@ARSLIST.ORG Subject: Re: Audit Log for Deleted Tickets Lou - did it work? On 3/12/08, Louis Cobuccio <[EMAIL PROTECTED]> wrote: > Thanks Ty I'll give that a go. > > Lou > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee > Sent: Wednesday, March 12, 2008 11:44 AM > To: arslist@ARSLIST.ORG > Subject: Re: Audit Log for Deleted Tickets > > I had this happen to - it is due to the fact that someone is blanking > out the "Assignee", but Remedy is not blanking out the hidden Assigned > To field. Do a report with the Assignee and Assigned To and you will > see the problem. > > Hope this helps. > > Ty > > > On 3/12/08, Louis Cobuccio <[EMAIL PROTECTED]> wrote: > > Good morning List, > > > > I've got a couple of strange ones for the list this morning. One of > > our > > techs found serveral Task Tickets that were in a status of Staging in > > the > > system. > > > > He was the only tech who could see the tickets in the console window > > even > > though the tasks are assigned only at the group level, so anyone else > in > > > > his group should see them in the console too but don't. That is > strange > > item one. > > > > Strange item two is that after sucessfully search for the tasks, I > can't > > > > open or search for the parent Change ticket. Here is the warning > > message I > > am receiveing: > > > > The owner request does not exist yet and cannot be opened. (ARWARN > > 45162) > > > > The preceding message occurred during the execution of active link > > TMS:SHR:OpenRootRequestDoesNotExist -- action 1. (ARNOTE 1101) > > > > My thought is that perhaps the parent change tickets were deleted from > > the > > system. Does that make sense? Any other thoughts on this? Is there > > any sort of audit that takes place for when an item is deleted from > the > > system? > > > > We are running version 7.0.01 patch 006 in a Windows environment with > > SQL 2005. > > > > > > ___ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Audit Log for Deleted Tickets
Thanks Ty I'll give that a go. Lou -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Wednesday, March 12, 2008 11:44 AM To: arslist@ARSLIST.ORG Subject: Re: Audit Log for Deleted Tickets I had this happen to - it is due to the fact that someone is blanking out the "Assignee", but Remedy is not blanking out the hidden Assigned To field. Do a report with the Assignee and Assigned To and you will see the problem. Hope this helps. Ty On 3/12/08, Louis Cobuccio <[EMAIL PROTECTED]> wrote: > Good morning List, > > I've got a couple of strange ones for the list this morning. One of > our > techs found serveral Task Tickets that were in a status of Staging in > the > system. > > He was the only tech who could see the tickets in the console window > even > though the tasks are assigned only at the group level, so anyone else in > > his group should see them in the console too but don't. That is strange > item one. > > Strange item two is that after sucessfully search for the tasks, I can't > > open or search for the parent Change ticket. Here is the warning > message I > am receiveing: > > The owner request does not exist yet and cannot be opened. (ARWARN > 45162) > > The preceding message occurred during the execution of active link > TMS:SHR:OpenRootRequestDoesNotExist -- action 1. (ARNOTE 1101) > > My thought is that perhaps the parent change tickets were deleted from > the > system. Does that make sense? Any other thoughts on this? Is there > any sort of audit that takes place for when an item is deleted from the > system? > > We are running version 7.0.01 patch 006 in a Windows environment with > SQL 2005. > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Audit Log for Deleted Tickets
Good morning List, I've got a couple of strange ones for the list this morning. One of our techs found serveral Task Tickets that were in a status of Staging in the system. He was the only tech who could see the tickets in the console window even though the tasks are assigned only at the group level, so anyone else in his group should see them in the console too but don't. That is strange item one. Strange item two is that after sucessfully search for the tasks, I can't open or search for the parent Change ticket. Here is the warning message I am receiveing: The owner request does not exist yet and cannot be opened. (ARWARN 45162) The preceding message occurred during the execution of active link TMS:SHR:OpenRootRequestDoesNotExist -- action 1. (ARNOTE 1101) My thought is that perhaps the parent change tickets were deleted from the system. Does that make sense? Any other thoughts on this? Is there any sort of audit that takes place for when an item is deleted from the system? We are running version 7.0.01 patch 006 in a Windows environment with SQL 2005. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Very Simple Question
Thanksactually I don't think the set field will work in this active link. I think I might just need to create another active link or build a guide. Here is the whole scenario We are trying to track Access Card Ids and we want to know every time a card is replaced. So I've created two fields on CTM:People, Access Card and Rplcmnt Access Card Count. I've also created an Rplcmnt Access Card field on CHG:Infrastructure Change that only becomes visible and writable when the proper Operational Categorization is selected. I then created an Active Link which will fire on Modification of the Chg form when the Rplcmnt Access Card field != $NULL$. The If Action is a Push Field to the People form if the ('Access Card'!= $Rplcmnt Access Card$) AND ('Remedy Log In ID' = $CustomerLogInID$) I am pushing $Rplcmnt Access Card$ to 'Access Card' field on People, and then I'd like to add 1 to the Rplcmnt Access Card Count also on the people form. But I can't add a set field action in the current Active Link because it is firing against the chg form. So I think the only way to get this to work the way I want it to is to create another Active Link just to do a Set Field action on Rplcmnt Access Card Count field if TR.Access Card != DB.Access Card? Does that sound right? Lou -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: Wednesday, March 05, 2008 4:35 PM To: arslist@ARSLIST.ORG Subject: Re: Very Simple Question Cool, since you are new, I'll give you a pointer. Set is for getting information from somewhere else (or current transaction) and updating fields on this record with the values. Push is for updating another record with information. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio Sent: Wednesday, March 05, 2008 2:25 PM To: arslist@ARSLIST.ORG Subject: Re: Very Simple Question I was using a Push Field action. I'll add a Set Field. Thanks Gang, Lou -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: Wednesday, March 05, 2008 4:19 PM To: arslist@ARSLIST.ORG Subject: Re: Very Simple Question Setfield action $Field$ + 1 This will increment the value if $Field$ is an integer field -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio Sent: Wednesday, March 05, 2008 1:55 PM To: arslist@ARSLIST.ORG Subject: Very Simple Question Okay guys I have a real easy one for you. We are running AR System 7.0.1 patch 006 in a Windows environment. I am trying to build an active link which needs to add "1" to the current value in an integer field on a form when the criteria is met. I can't for the life of me figure out the syntax needed to accomplish this. Any help would be great; the field name is Rplcmnt Access Card Count. Thank you guys, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Very Simple Question
I was using a Push Field action. I'll add a Set Field. Thanks Gang, Lou -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: Wednesday, March 05, 2008 4:19 PM To: arslist@ARSLIST.ORG Subject: Re: Very Simple Question Setfield action $Field$ + 1 This will increment the value if $Field$ is an integer field -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio Sent: Wednesday, March 05, 2008 1:55 PM To: arslist@ARSLIST.ORG Subject: Very Simple Question Okay guys I have a real easy one for you. We are running AR System 7.0.1 patch 006 in a Windows environment. I am trying to build an active link which needs to add "1" to the current value in an integer field on a form when the criteria is met. I can't for the life of me figure out the syntax needed to accomplish this. Any help would be great; the field name is Rplcmnt Access Card Count. Thank you guys, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Very Simple Question
Okay guys I have a real easy one for you. We are running AR System 7.0.1 patch 006 in a Windows environment. I am trying to build an active link which needs to add "1" to the current value in an integer field on a form when the criteria is met. I can't for the life of me figure out the syntax needed to accomplish this. Any help would be great; the field name is Rplcmnt Access Card Count. Thank you guys, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Approval Server Issues....
Hey Gang, I am running into an issue with one of our approval processes. We are a Windows Shop, Windows Server 2003, MS SQL 2005 and IIS 6 w/TomCat. We are running version 7.0.01 patch 006 for everything BMC Remedy. Here is the process in question, We have a 24 hour approval process for our "major" Change Management tickets. All IT managers have 24 hours to review, approve or reject the request. If no action is taken by a manager in the 24 hour window then the system will automatically give his/her approval. The end result being that the ticket should automatically be approved if no management rejects occur. Here is the issue, The Change Ticket looks great under the approval tab after the 24 hour period. There is no one listed under Pending and if you look under Approved you see the signatures of those managers that approved and you don't see a signature just the status of Approved for those managers who took no action either way. However the tickets overall approval status still shows as Pending. Also I do receive Approval Engine error emails, one for each manager that the system automatically approved. The error message is "The approval engine encountered an error for a process for which you are an administrator. The error is as follows: A process was specified but no process by that name exists" I have a ticket logged with support but they seem to be dragging their feet. Any help would be great. Thank you, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Work Info Types in Change Managment v7.0.01 ptch 6
Good afternoon List, I've been seeing some inconsistencies within Change Management and was wondering if anyone else is seeing the same. I've seen this issue with both patch 5 & 6 for v 7.0.01. Some Work Info Types show Locked* Yes and others show Locked* No when Viewing them in a Change Ticket. There doesn't seem to be a rhyme or reason for this. As a matter of fact if there are two separate entries with the same type listed one shows Locked while the other shows "Un"Locked. This is causing a bit of an issue as some users are trying to added attachments and edit existing Work Info entries only to see them not take or to see the other entry with the same type get updated instead. We are a Windows shop, Windows Server 2003 w/SQL 2005 database. AR System 7.0.01 Patch 6. Thanks, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Email Engine Patch 006
Thanks Craig. It turned out to be a bad password. We had assumed that they went with the remedy default admin password when they had originally setup the system. Turns out they didn't. We found the right password and updated the password in the admin tool. Thanks again, Lou -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Craig Carter Sent: Thursday, February 14, 2008 9:47 AM To: arslist@ARSLIST.ORG Subject: Re: Email Engine Patch 006 If you are getting the "failed to login to MAPI" error, this is usually because the Outlook profile was not set up while logged in as the user the service is running under or that login cannot connect to the mail server. The standard authentication error is usually a result of the application service password entered when you installed the Email Engine does not match the application service password in the database. //SIGNED// Craig Carter Software Engineer, RSP -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio Sent: Thursday, February 14, 2008 5:41 AM To: arslist@ARSLIST.ORG Subject: Re: Email Engine Patch 006 Thank you Joe, Sorry it was a very late night last night, and I did post my issue prior to digging deeper. Basically we are getting an Authentication Failed error when we try to start the email engine service. We are running out going mail only under MAPI using MS Outlook. Thank you all, Lou -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Thursday, February 14, 2008 1:14 AM To: arslist@ARSLIST.ORG Subject: Re: Email Engine Patch 006 Lou, Look up your AR Email Error Message form and see what errors have been written to it since your upgrade.. Also it would help if you could let the list know what OS your Email engine is installed on.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Louis Cobuccio Sent: Wednesday, February 13, 2008 8:37 PM To: arslist@ARSLIST.ORG Subject: Email Engine Patch 006 Hey Gang, I just installed Email Engine Patch 006 for v 7.0.01. I am not receiving emails after installation of the patch. Searching the AR System Email Messages form I see the test email I tried to send, however the Send Message column show "Yes" instead of "Sent" or "Error". So it looks like I can't connect to the email server, however the configuration looks good. Any thoughts? Thank you Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Email Engine Patch 006
Hey gang, This issue is resolved. We set the wrong Admin password during the installation process. Thank you, Lou -Original Message- From: Louis Cobuccio Sent: Thursday, February 14, 2008 7:41 AM To: arslist@ARSLIST.ORG Subject: RE: Email Engine Patch 006 Thank you Joe, Sorry it was a very late night last night, and I did post my issue prior to digging deeper. Basically we are getting an Authentication Failed error when we try to start the email engine service. We are running out going mail only under MAPI using MS Outlook. Thank you all, Lou -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Thursday, February 14, 2008 1:14 AM To: arslist@ARSLIST.ORG Subject: Re: Email Engine Patch 006 Lou, Look up your AR Email Error Message form and see what errors have been written to it since your upgrade.. Also it would help if you could let the list know what OS your Email engine is installed on.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Louis Cobuccio Sent: Wednesday, February 13, 2008 8:37 PM To: arslist@ARSLIST.ORG Subject: Email Engine Patch 006 Hey Gang, I just installed Email Engine Patch 006 for v 7.0.01. I am not receiving emails after installation of the patch. Searching the AR System Email Messages form I see the test email I tried to send, however the Send Message column show "Yes" instead of "Sent" or "Error". So it looks like I can't connect to the email server, however the configuration looks good. Any thoughts? Thank you Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Email Engine Patch 006
Thank you Joe, Sorry it was a very late night last night, and I did post my issue prior to digging deeper. Basically we are getting an Authentication Failed error when we try to start the email engine service. We are running out going mail only under MAPI using MS Outlook. Thank you all, Lou -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Thursday, February 14, 2008 1:14 AM To: arslist@ARSLIST.ORG Subject: Re: Email Engine Patch 006 Lou, Look up your AR Email Error Message form and see what errors have been written to it since your upgrade.. Also it would help if you could let the list know what OS your Email engine is installed on.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Louis Cobuccio Sent: Wednesday, February 13, 2008 8:37 PM To: arslist@ARSLIST.ORG Subject: Email Engine Patch 006 Hey Gang, I just installed Email Engine Patch 006 for v 7.0.01. I am not receiving emails after installation of the patch. Searching the AR System Email Messages form I see the test email I tried to send, however the Send Message column show "Yes" instead of "Sent" or "Error". So it looks like I can't connect to the email server, however the configuration looks good. Any thoughts? Thank you Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Email Engine Patch 006
Hey Gang, I just installed Email Engine Patch 006 for v 7.0.01. I am not receiving emails after installation of the patch. Searching the AR System Email Messages form I see the test email I tried to send, however the Send Message column show "Yes" instead of "Sent" or "Error". So it looks like I can't connect to the email server, however the configuration looks good. Any thoughts? Thank you Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Patch 006 Question.....
Peter, I installed the User Tool patch 006 on our test system and when I go into Help/About User Tool it shows as patch 6. However, I did not uninstall the previous version I just installed right over it. Lou From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Tuesday, February 12, 2008 2:48 PM To: arslist@ARSLIST.ORG Subject: Re: Patch 006 Question. ** Sometimes they forget to update the part of the executable that shows the current version, causing it to display an incorrect value. Add that to the list of QA issues on patches. I would check the registry to see what the real version is. Rick On Feb 12, 2008 11:14 AM, Lammey, Peter A. <[EMAIL PROTECTED]> wrote: ** Has anyone downloaded and installed the Remedy User client 7.01 patch 006 yet? I just downloaded it today and then tried installing it but after the install runs according to Help / About the version is 7.01 patch 002. Ive uninstalled my old client at least twice, cleared out the entire directory where the executables were and ran the install again but I still get the same result. Im wondering if it is just me or if others have found the same thing. Thanks Peter Lammey ESPN MIT Technical Services & Applications Management 860-766-4761 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman Sent: Tuesday, February 12, 2008 7:00 AM To: arslist@ARSLIST.ORG Subject: Re: Patch 006 Question. ** Joe, I think that is incorrect. The latest patch for AR Server 7.0.1 is 006. The latest patch for the ITSM suite is 7.0.2 is 006. And there are differences in the Admin tool, and probably the user tool too, from patch release to patch release. I'd recommend using a matching version to your server. J.T. Shyman Column Technologies From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Tuesday, February 12, 2008 2:55 AM To: arslist@ARSLIST.ORG Subject: Re: Patch 006 Question. The patch level of the User tool has very little to do with the upgrade of a patch level of your ITSM application. And if you are using ARS 7.0.1, the user tool and the ARS Server is still on Patch 3.. If you are on ARS 7.1, the latest patch is Patch 1. Its only the ITSM applications 7.0 that have got 6 patches released till date.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Louis Cobuccio Sent: Monday, February 11, 2008 2:49 PM To: arslist@ARSLIST.ORG Subject: Patch 006 Question. ** Hey Gang, I am about to install AR Server, Mid-Tier Server, Email Engine, Flashboards, Approval Server and ITSM patch 006 of version 7.0.01, in production. Can my users still use patch 005 of the User Tool for a bit or do I need to update them with patch 006 of the User Tool at the same time I am patching my system? Any help would be great. Thank you, Louis Cobuccio Eaton Vance Management, Inc. 2 Oliver Street Boston, MA. 02109 (d) 617.598.8822 (c) 617.429.1113 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Reserved Field Id Range for v 7.0.01
Thank you. We used 99600 @ my old company and in v 6.3. I think I'll still with that range here too. Thanks again, Lou -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of strauss Sent: Tuesday, February 12, 2008 1:38 PM To: arslist@ARSLIST.ORG Subject: Re: Reserved Field Id Range for v 7.0.01 They teach using Field IDs 536870913 to 2147483647 (pg 85 of the UserWorld 2007 tutorial book "In-depth Analysis into Best Practices of BMC Remedy IT Service Management 7.x" for all of your custom work, but when I did some digging I found that EIE/AIE and AP have used a lot of custom range IDs between 536870913 and 6. Other parts of ITSM 7 have strayed into the 10 and 15368# custom ranges. >From other vendors, Kinetic apps use IDs all over the map from 6 to 770003###, and EffectTech uses 8. Those are the only ones I have installed to see what they use. In the past I used the 6 ranges for customizations, so anything I imported from my 5.5 application used those column IDs. All of my new development is using the 9000# range and specifically 940## (940 is our area code, so it's easy to remember), but I do have some in 7110 that I got from another developer. Field ID Ranges BMC Reserved to 536870912 536870913++ EIE, KS, AP 6 KS 61### KS 63### KS 64### KS 60008 KS 71### KS Survey 710001###+ KS Survey 70001 KS 7005# KS Calendar 702## KS Request 7100# KS Survey 71100 UNT 77000 KS Request 770003000 KS Calendar 8 EffectTech 9000# UNT 940## UNT 10 ITSM 15368# ITSM CTM 2147483647 BMC Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio > Sent: Tuesday, February 12, 2008 12:05 PM > To: arslist@ARSLIST.ORG > Subject: Reserved Field Id Range for v 7.0.01 > > Hey Gang, > > Did BMC create a Reserved Field Id range for customizations > in v 7? And if so, what it is? If not what are you guys using? > > Thanks, > Lou > > __ > _ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Reserved Field Id Range for v 7.0.01
Hey Gang, Did BMC create a Reserved Field Id range for customizations in v 7? And if so, what it is? If not what are you guys using? Thanks, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Patch 006 Question.....
Hey Gang, I am about to install AR Server, Mid-Tier Server, Email Engine, Flashboards, Approval Server and ITSM patch 006 of version 7.0.01, in production. Can my users still use patch 005 of the User Tool for a bit or do I need to update them with patch 006 of the User Tool at the same time I am patching my system? Any help would be great. Thank you, Louis Cobuccio Eaton Vance Management, Inc. 2 Oliver Street Boston, MA. 02109 (d) 617.598.8822 (c) 617.429.1113 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Approval Patch 6 for v 7.0.01
Hi group, I am about to install approval server patch 6 for v 7.0.01. We are a windows shop, Windows Server 2003, MS SQL 2000. I got a bit confused reading through the "Required post-installation steps for patch 006". It talks about opening a two way join form that was created when first installing the Approval server. It references reviewing "Connecting an application to the Approval Server" section of the User and Admin guide. Needless to say I was not here when they first installed Approval server and of course I can't get my hands on any documentation regarding the installation/configuration. Plus I believe my company may have already installed patch 5 and may have missed this step. Anyway my question is, is this step needed if the only application that is utilizing the Approval Server is Remedy Change Management? I would have assumed that since they are both BMC/Remedy application it would create the join automatically. Am I assuming too much? Has anyone installed this patch yet? Any help would be great. Thank you, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"