Setting up a pre-production server.
Dear arlisters, Anyone would like to share the steps/experience on how to set up a pre-production/test environment for ARS7.1/CMDB2.1/ITSM7.0.3. We have a server group consisting of two nodes (node1 passive and node2 active) pointing to the same database: DB: Database MS SQL 2005 (X64) ARS 7.1.0 Patch 004 OS: MS 2003 Enterprise Edition SP2 (X64) WebServer: IBM WebSphere Application Server/6.1 Mid-Tier: 7.1.0 Patch 004 OS: Windows Server 2003 Java Version: 1.5.0 Node1 has been cloned to a VM-Ware and about to do the same with the databse instance. My question is what's next? re-run the server installer and use the upgrade option? Massage the config files for all the remedy services or re-run the installers? How do you get rid of all the server group refernces in the databse? How about licensing? etc etc... The whole process is really to test the new 7.5 version. Many thansk in advance frex ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: ARERR 1904
You simply need to create the ARSystem ODBC data source on the client. Drill down into your Control Panel and select ODBC if on Vista and create a new DSN using the AR System ODBC Driver. You should then be able to run the report. Craig Carter Information Technology Manager, RSP -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of ITN (Amanullah Bashir Ahmed) Sent: Monday, February 15, 2010 9:49 PM To: arslist@ARSLIST.ORG Subject: ARERR 1904 ** Hi there, Please how to get rid of the below error. An error occurred while generating the Crystal report: Failed to open the connection-ODBC data source: AR System ODBC Data Source (ARERR 1904). Please anybody help me urgently. Thanks Regards Amanullah Software Consultant DISCLAIMER:This e-mail message including any of its attachments is intended solely for the addressee(s) and may contain privileged information. If you are not the addressee or you have received this email message in error, please notify the sender who will remove your details from its database. You are not authorized to read, copy, disseminate, distribute or use this e-mail message or any attachment to it in any manner and must delete the email and destroy any hard copies of it. This e-mail message does not contain financial instructions or commitments of any kind. Any views expressed in this message are those of the individual sender and do not necessarily reflect the views of Emirates NBD PJSC, or any other related subsidiaries, entities or persons. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Unexplained Explorer behavior within Atrium Core Console
ARS 7.5 patch 003 Atrium CMDB 7.5 patch 003 Hi Listers, Administrators are supposed to have full access to the Atrium Console per documentation even though you lose access to the 'Class Manager' application once you map a group to the Role tied to accessing the 'Class Manager' application. This is not the issue I'm having but I wanted to mention it just in case it may have any bearing to the issue I have now. I also believe this issue occurred even before I mapped a role to 'Class Manager'. The problem I have now is while performing actions within the 'Explorer' application, you all of a sudden are not able to perform any searches from the Find section any more. i.e it doesn't show you any results no matter how open you leave your qualification and yes, I've checked the dataset value I'm searching against. I've noted how this begins. First, when you click on the 'Explorer' icon, you get the clock icon which spins once or twice but then disappears without opening the default BMC ASSET view. The Classes section is also blank. Within the New View icon I go and select BMC ASSET to open the view. I then try to perform a search from the Find section setting the Dataset option to BMC Asset, but I come up with no results. Once this behavior starts, you're unable to close the 'Explorer' window. You'd have to exit out of the browser or user tool to exit out of it. My current work around is to permission a different user with Administrator privileges and then use this user. Once I do that, everything starts working okay for a while and then the same behavior starts again. Hope someone has come across this issue because I've run out of options including : Restarting the webserver, servlet engine (tomcat 5), deleting the cache and cachetemp folders, and flushing the midtier cache. TIA, Chike This message and any attachments (the message) is intended solely for the addressees and is confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval. The internet can not guarantee the integrity of this message. BNP PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the message if modified. Please note that certain functions and services for BNP Paribas may be performed by BNP Paribas RCC, Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: ARERR 1904
Do you have an ODBC driver for your ARSystem? Assuming you're on windows, go to ODBC Data Source Administrator click Add Select ARSystem ODBC Driver Data Source Name: ARSystem Marcelo From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of ITN (Amanullah Bashir Ahmed) Sent: Monday, February 15, 2010 10:49 PM To: arslist@ARSLIST.ORG Subject: ARERR 1904 ** Hi there, Please how to get rid of the below error. An error occurred while generating the Crystal report: Failed to open the connection-ODBC data source: AR System ODBC Data Source (ARERR 1904). Please anybody help me urgently. Thanks Regards Amanullah Software Consultant DISCLAIMER:This e-mail message including any of its attachments is intended solely for the addressee(s) and may contain privileged information. If you are not the addressee or you have received this email message in error, please notify the sender who will remove your details from its database. You are not authorized to read, copy, disseminate, distribute or use this e-mail message or any attachment to it in any manner and must delete the email and destroy any hard copies of it. This e-mail message does not contain financial instructions or commitments of any kind. Any views expressed in this message are those of the individual sender and do not necessarily reflect the views of Emirates NBD PJSC, or any other related subsidiaries, entities or persons. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Update of Style Sheets and ARS 7.5 and ITSM 7.5
Folks, I am looking into the possibility to implement our branding standard for ITSM Suite 7.5 where the logo colour and fonts meets our own standard. Our external customers are exposed to the Requester Console and our marketing people don't like what they see. I have done this in previous versions of Remedy and have found these type of customizations extremely time consuming to implement. We are now running ARS 7.5 and ITSM 7.5p1. Before I spend any time on it - is there any success stories out there updating Style Sheets? I don't want to update all fields, forms and views accessed by our external customer. Update the Style Sheets must be the way to go! In general we are mainly talking of change in colours and fonts not font sizes. And BMC's logo has to go. Have anyone successfully updated the appearance of selected applications within the ITSM Suite using the style sheets? Thanks, Terje ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Custom notification fields
Looking to add custom fields to Notification Message Tag: CHG-APR-ApprovalNTForIndividual Can anyone help in identifying the filters which push data from CHG:APDetailSignature to NTE:SYS-NT Process Control. I have added my fields to the SYS:Form Field Selection form I have updated the filter NTE:SHR:TranslateNotificationMessageAPR_135 I have added my custom fields to the forms: NTE:SYS-NT Process Control ; NTE:SYS-Group NT Control ; NTE:SYS-Individual NT Control. Need to update filters which push data to the control forms. Thanks.. Marcelo Martinez ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Update of Style Sheets and ARS 7.5 and ITSM 7.5
Check out chapter three of the BMC Remedy Mid Tier Guide. It deals with which stylesheet rules to change for individual form elements. As far as the logo across the top of each form, I don't think that's defined in a CSS rule; I believe you have to specify a logo on each form you wish to change (that's how it was in earlier versions anyway). Mike -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Terje Moglestue Sent: Tuesday, February 16, 2010 9:05 AM To: arslist@ARSLIST.ORG Subject: Update of Style Sheets and ARS 7.5 and ITSM 7.5 Folks, I am looking into the possibility to implement our branding standard for ITSM Suite 7.5 where the logo colour and fonts meets our own standard. Our external customers are exposed to the Requester Console and our marketing people don't like what they see. I have done this in previous versions of Remedy and have found these type of customizations extremely time consuming to implement. We are now running ARS 7.5 and ITSM 7.5p1. Before I spend any time on it - is there any success stories out there updating Style Sheets? I don't want to update all fields, forms and views accessed by our external customer. Update the Style Sheets must be the way to go! In general we are mainly talking of change in colours and fonts not font sizes. And BMC's logo has to go. Have anyone successfully updated the appearance of selected applications within the ITSM Suite using the style sheets? Thanks, Terje ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Custom notification fields
Marcelo, See this doc: http://communities.bmc.com/communities/docs/DOC-8831 It's a generic document about customizing notifications in ITSM. The specific answer you are looking for (fields on approval related forms), I suspect, is not there, but it's a good reference document and might give you some leads. I was a self-described ITSM 7.x notification expert, but I haven't touched it in a while and I can't find my old notes at the moment. If I locate anything useful, I will send it your way. Worst case...turn on server side filter logging and trace the filters to see which one you need to update. Tedious, yes, but it's your ultimate and surefire weapon. Regards. On Tue, Feb 16, 2010 at 10:33 AM, Martinez, Marcelo A marc...@cpchem.com wrote: Looking to add custom fields to Notification Message Tag: CHG-APR-ApprovalNTForIndividual Can anyone help in identifying the filters which push data from CHG:APDetailSignature to NTE:SYS-NT Process Control. I have added my fields to the SYS:Form Field Selection form I have updated the filter NTE:SHR:TranslateNotificationMessageAPR_135 I have added my custom fields to the forms: NTE:SYS-NT Process Control ; NTE:SYS-Group NT Control ; NTE:SYS-Individual NT Control. Need to update filters which push data to the control forms. Thanks.. Marcelo Martinez ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Update of Style Sheets and ARS 7.5 and ITSM 7.5
Thanks Mike, I have done my homework and I am well aware of chapter three in the mid-tier manual. It gives you the basic principle of how to customize style sheets with AR System. In the past I have done plenty of work with Style Sheets with or without Remedy. I have not done any css work with ARS7.x or newer. One of the issues you will have is to find all tags used by ARS. It would have been great if ARSystem.css hold all the tags by default - or the system had a css file holding all the tags. Your only alternative is to find all the tags yourself by testing. www.cofeecup.com http://www.cofeecup.com/ got a good Style Sheet Editor for CSS - files. Back to my question? Any success stories out there? Changing the apparance of one the the ITSM 7.5 applications using style sheets? I do remember a old KB of style sheets and version 6.x but not anything related to Developer Studio, ARS 7.5 and ITSM 7.5. Thanks, Terje From: Action Request System discussion list(ARSList) on behalf of Mike Wallick Sent: Tue 16/02/2010 03:47 PM To: arslist@ARSLIST.ORG Subject: Re: Update of Style Sheets and ARS 7.5 and ITSM 7.5 Check out chapter three of the BMC Remedy Mid Tier Guide. It deals with which stylesheet rules to change for individual form elements. As far as the logo across the top of each form, I don't think that's defined in a CSS rule; I believe you have to specify a logo on each form you wish to change (that's how it was in earlier versions anyway). Mike -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Terje Moglestue Sent: Tuesday, February 16, 2010 9:05 AM To: arslist@ARSLIST.ORG Subject: Update of Style Sheets and ARS 7.5 and ITSM 7.5 Folks, I am looking into the possibility to implement our branding standard for ITSM Suite 7.5 where the logo colour and fonts meets our own standard. Our external customers are exposed to the Requester Console and our marketing people don't like what they see. I have done this in previous versions of Remedy and have found these type of customizations extremely time consuming to implement. We are now running ARS 7.5 and ITSM 7.5p1. Before I spend any time on it - is there any success stories out there updating Style Sheets? I don't want to update all fields, forms and views accessed by our external customer. Update the Style Sheets must be the way to go! In general we are mainly talking of change in colours and fonts not font sizes. And BMC's logo has to go. Have anyone successfully updated the appearance of selected applications within the ITSM Suite using the style sheets? Thanks, Terje ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Custom notification fields
Rabi, Thank you for the doc. I've briefly read it but will look at in more detail. I have done almost everything specified in the doc with the exception of modifying the filters which push data to the NTE:SYS.. control forms. For example: Filter NTE:SHR:TranslateNotificationMessageAPR_135 From: NTE:SYS-Group NT Control ; NTE:SYS-Individual NT Control Run If: 'Form Name01' = CHG:ChangeAPDetailSignature Action: Set Fields Read From: CURRENT TRANSACTION Field Name: z1D Translation Text Value: REPLACE($z1D Translation Text$, #Ticket ID#, $Request ID02 Ticket$) My take is that in order for this to work, a filter has already pushed the value for Request ID02 to the two NT Control forms. Correct? Well, I need to find out which filters are pushing that data so I can add my custom fields. Thanks for the DOC. Marcelo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rabi Tripathi Sent: Tuesday, February 16, 2010 10:26 AM To: arslist@ARSLIST.ORG Subject: Re: Custom notification fields Marcelo, See this doc: http://communities.bmc.com/communities/docs/DOC-8831 It's a generic document about customizing notifications in ITSM. The specific answer you are looking for (fields on approval related forms), I suspect, is not there, but it's a good reference document and might give you some leads. I was a self-described ITSM 7.x notification expert, but I haven't touched it in a while and I can't find my old notes at the moment. If I locate anything useful, I will send it your way. Worst case...turn on server side filter logging and trace the filters to see which one you need to update. Tedious, yes, but it's your ultimate and surefire weapon. Regards. On Tue, Feb 16, 2010 at 10:33 AM, Martinez, Marcelo A marc...@cpchem.com wrote: Looking to add custom fields to Notification Message Tag: CHG-APR-ApprovalNTForIndividual Can anyone help in identifying the filters which push data from CHG:APDetailSignature to NTE:SYS-NT Process Control. I have added my fields to the SYS:Form Field Selection form I have updated the filter NTE:SHR:TranslateNotificationMessageAPR_135 I have added my custom fields to the forms: NTE:SYS-NT Process Control ; NTE:SYS-Group NT Control ; NTE:SYS-Individual NT Control. Need to update filters which push data to the control forms. Thanks.. Marcelo Martinez ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Setting up a pre-production server.
You do not need to run the upgrade option. Since you have cloned both the application and the database servers, all you would need to do is, massage the configuration files, and services to reflect the new server names wherever applicable. Do not forget massaging the armonitor file as well. That file will have old server references as well. You may need to touch the host file as well depending on how your network is configured. Your second step would be to clean configuration data off any server references. Applications like AIE, SRM keep hard coded server references in the configuration data so if you have the AIE component installed as a part of CMDB, you will need to export the AIE configurations, and re-import them after cleaning the references. Export and import this data from the configuration utility using the export and import functions built there.. Ideally the workflow should be free of server references, but in the real world this hardly is ever true. So you might need to deal with cleaning server references, from the workflow, before you can really use the new pre-production/test environment. This may take you the longest time.. The easiest way to do this is to export all the def files to XML format, and look for the old server names both FQDN (do this first) and just the domain name after you look for FQDN's and replace these with @. Also look for old IP addresses in the workflow and replace these with @. I've seen numerous developers use IP addresses, to connect their development tool to the AR System leaving their workflow infested with server references by way of IP addresses. Do not really bother about licensing. Just install the new applicable licenses for the new server, the ARS will simply ignore the old licenses after it doesn't match that license with its new server name. If you really want to be anal about it (like I usually am), yes you can delete the license records of the old server. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Frex Popo Sent: Tuesday, February 16, 2010 5:45 AM To: arslist@ARSLIST.ORG Subject: Setting up a pre-production server. ** Dear arlisters, Anyone would like to share the steps/experience on how to set up a pre-production/test environment for ARS7.1/CMDB2.1/ITSM7.0.3. We have a server group consisting of two nodes (node1 passive and node2 active) pointing to the same database: DB: Database MS SQL 2005 (X64) ARS 7.1.0 Patch 004 OS: MS 2003 Enterprise Edition SP2 (X64) WebServer:IBM WebSphere Application Server/6.1 Mid-Tier:7.1.0 Patch 004 OS: Windows Server 2003 Java Version: 1.5.0 Node1 has been cloned to a VM-Ware and about to do the same with the databse instance. My question is what's next? re-run the server installer and use the upgrade option? Massage the config files for all the remedy services or re-run the installers? How do you get rid of all the server group refernces in the databse? How about licensing? etc etc... The whole process is really to test the new 7.5 version. Many thansk in advance frex ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Web Services - please enlight me!
Let me see if I have this correct... You created a web service thru the Admin tool and you can see the WSDL on the WSDL tab of the web service definition window. You try to create a filter to consume that web service and it reports the error. Did you copy and paste the URL viewed on the WSDL definition tab (of the web services definition window) into the Filter? Did you flush the cache on the Mid-Tier server? Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mark Milke Sent: Monday, February 15, 2010 3:43 AM To: arslist@ARSLIST.ORG Subject: Web Services - please enlight me! Hello everyone, we're still on 6.3. I'm trying to do something with the Web Services, so I got started by setting up the PO Example from the ARS manual, i.e. I've created the PO and Line Item forms and the PO Web Service. I want to try consume the Web Service from the same ARS machine. In order to do that, I've created a from called PO Consumer and a filter with a Set Fields action trying to query a the aforementioned Web Service. I've entered the WDSL URL from the Web Service into the 'Choose wdsl' field, I'' pressing the 'Load' button and get: ERROR: URI not found https://ourdomain/arsys/WSDL/public/the_ip_of_our_ARS_server/PO The funny thing is, that on the WDSL tab of the Web Service the same URL displays the WDSL contents. The same URL works just fine in a web broswer too. QUESTION: Which route/path is ARS taking when I specify the URL to the WDSL in a Set Fields action. Is it trying to go from the Admin Tool to the specified URL? Is it trying from the ARS server to the Mid-Tier? Or what else? I guess some firewall might be blocking here, but without knowing what ARS is trying to do here, I can't really help it. This is really confusing... Another Web Service question I have is this: When you go to the WDSL tab in a Web Service, it will display the contents of the WDSL. How do I get this stuff into a file? I tried with copy and paste, but this always causes some formatting problems resulting in ARS not accepting the file. Thanks, Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Consuming Complex External Web Service Help
Can this be done via filter mapping or does this require some middle-ware? I'm trying to consume a complex web service from an external source and have hit a snag with the filter mapping. The construct/hierarchy of the web service is: Location (top of hierarchy) //i.e. some address -name (primaryAttribute) Devices (0 or more child(ren) to Location) //i.e. a host at the address -name (primaryAttribute) -features (0 or more child(ren) contains array of Devices) //i.e. a host can have one or more components The results would look something like: Location -site123xxx Devices -device123 -feature array ref Devices -device123_component123 -feature array ref ... So the parent-child link gets blurred as device123_component123 is a child to device123- feature array ref not device123. And that can't be mapped in the filter mapping. Is there anyway to handle this natively? Have I missed something? Thanks, Eric ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
SQL help needed
Hello All, Below is the problem and way I was trying to handle it C_list contains comma separated values of group Id’s. this list contains all the group id’s associated to a particular login name. C_list= (1,15005,85,83,84,805) This variable will be holding up dynamically value in numbers. For group id numbers in simple sql statement we can get the result corresponding name using the below query, Select c105,c106 from t10 where c106 in (1, 101,102,104). Same query when I tried transforming in a cursor it throws up a compilation error. The error points out to a fetch statement where we try and fetch the data from the cursor for one particular group id. Declare cursor c1 as select c105,c106 from t10 where c106 in(c_list); Begin Open c1; Loop Fetch C1 into g_num,g_name; dbms_output.put_line(g_name); EXIT WHEN C1%NOTFOUND; END LOOP; Close c1; End; Hope it explains the problem I am facing. Any suggestions/Comments or previously implemented code will be helpful for me. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Import Asset Relationships
I am pulling asset records from a Remedy 5.5 system into a brand new Remedy 7.6 system. I have imported most of the records and poked them into their correct classes but now I need to build the asset-to-asset relationships and I have hit a wall. All component records in the 5.5 system were converted (prior to my hire date) from to asset records, that means that all the SHR:Association records are MAINASSET to MAINASSET relationships. Now, how do I import these records into the correct BMC_Dependency relationships? I can't decipher which are HostedComponents etc so I was just thinking of Dependency. Has anyone done anything similar? I guess that it would be the same process to import relationships from any pre-CMDB version into a CMDB version of Remedy so any help would be greatly appreciated. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: SQL help needed
Don't cursors have to run on the Primary Key? Or one has to exist on the table in question? I can't remember exactly but I do recall something about cursors not declaring correctly with a PK. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of amit dw Sent: Tuesday, February 16, 2010 3:20 PM To: arslist@ARSLIST.ORG Subject: SQL help needed ** Hello All, Below is the problem and way I was trying to handle it C_list contains comma separated values of group Id's. this list contains all the group id's associated to a particular login name. C_list= (1,15005,85,83,84,805) This variable will be holding up dynamically value in numbers. For group id numbers in simple sql statement we can get the result corresponding name using the below query, Select c105,c106 from t10 where c106 in (1, 101,102,104). Same query when I tried transforming in a cursor it throws up a compilation error. The error points out to a fetch statement where we try and fetch the data from the cursor for one particular group id. Declare cursor c1 as select c105,c106 from t10 where c106 in(c_list); Begin Open c1; Loop Fetch C1 into g_num,g_name; dbms_output.put_line(g_name); EXIT WHEN C1%NOTFOUND; END LOOP; Close c1; End; Hope it explains the problem I am facing. Any suggestions/Comments or previously implemented code will be helpful for me. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: SQL help needed
What is the error that you are getting? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of amit dw Sent: Tuesday, February 16, 2010 4:20 PM To: arslist@ARSLIST.ORG Subject: SQL help needed ** Hello All, Below is the problem and way I was trying to handle it C_list contains comma separated values of group Id’s. this list contains all the group id’s associated to a particular login name. C_list= (1,15005,85,83,84,805) This variable will be holding up dynamically value in numbers. For group id numbers in simple sql statement we can get the result corresponding name using the below query, Select c105,c106 from t10 where c106 in (1, 101,102,104). Same query when I tried transforming in a cursor it throws up a compilation error. The error points out to a fetch statement where we try and fetch the data from the cursor for one particular group id. Declare cursor c1 as select c105,c106 from t10 where c106 in(c_list); Begin Open c1; Loop Fetch C1 into g_num,g_name; dbms_output.put_line(g_name); EXIT WHEN C1%NOTFOUND; END LOOP; Close c1; End; Hope it explains the problem I am facing. Any suggestions/Comments or previously implemented code will be helpful for me. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: SQL help needed
the error points to the Fetch statement Fetch C1 into froup_id,group_name It will be great if somebody has done sql manipulations on the C104 filed of the t9(User Form) On Tue, Feb 16, 2010 at 3:37 PM, Joe D'Souza jdso...@shyle.net wrote: ** What is the error that you are getting? Joe -Original Message- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org]*on Behalf Of *amit dw *Sent:* Tuesday, February 16, 2010 4:20 PM *To:* arslist@ARSLIST.ORG *Subject:* SQL help needed ** Hello All, Below is the problem and way I was trying to handle it C_list contains comma separated values of group Id’s. this list contains all the group id’s associated to a particular login name. C_list= (1,15005,85,83,84,805) This variable will be holding up dynamically value in numbers. For group id numbers in simple sql statement we can get the result corresponding name using the below query, Select c105,c106 from t10 where c106 in (1, 101,102,104). Same query when I tried transforming in a cursor it throws up a compilation error. The error points out to a fetch statement where we try and fetch the data from the cursor for one particular group id. Declare cursor c1 as select c105,c106 from t10 where c106 in(c_list); Begin Open c1; Loop Fetch C1 into g_num,g_name; dbms_output.put_line(g_name); EXIT WHEN C1%NOTFOUND; END LOOP; Close c1; End; Hope it explains the problem I am facing. Any suggestions/Comments or previously implemented code will be helpful for me. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: SQL help needed
First, What database are you using? ( It looks like you may be using Oracle, but it would be nice to be sure) Second, What is it you are trying to do? Are you trying to get a list of all users that are in a specific group or a list of users that are all in a specific set of groups? Third, Remember the group list field in Remedy is a string of group IDs and the IDs can be in any order. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of remedy.help Sent: Tuesday, February 16, 2010 3:42 PM To: arslist@ARSLIST.ORG Subject: Re: SQL help needed ** the error points to the Fetch statement Fetch C1 into froup_id,group_name It will be great if somebody has done sql manipulations on the C104 filed of the t9(User Form) On Tue, Feb 16, 2010 at 3:37 PM, Joe D'Souza jdso...@shyle.net wrote: ** What is the error that you are getting? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of amit dw Sent: Tuesday, February 16, 2010 4:20 PM To: arslist@ARSLIST.ORG Subject: SQL help needed ** Hello All, Below is the problem and way I was trying to handle it C_list contains comma separated values of group Id's. this list contains all the group id's associated to a particular login name. C_list= (1,15005,85,83,84,805) This variable will be holding up dynamically value in numbers. For group id numbers in simple sql statement we can get the result corresponding name using the below query, Select c105,c106 from t10 where c106 in (1, 101,102,104). Same query when I tried transforming in a cursor it throws up a compilation error. The error points out to a fetch statement where we try and fetch the data from the cursor for one particular group id. Declare cursor c1 as select c105,c106 from t10 where c106 in(c_list); Begin Open c1; Loop Fetch C1 into g_num,g_name; dbms_output.put_line(g_name); EXIT WHEN C1%NOTFOUND; END LOOP; Close c1; End; Hope it explains the problem I am facing. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Server config
We are discovery 1.6. For our configuration, is it possible to separate the data files from the application binaries? To save space, our Management wants to put the Discovery application binaries on 1 drive, and the Discovery data files on another drive. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: SQL help needed
Have you tried retrieving the same using a simple select statement using a like clause? I do not see a distinct advantage of using a cursor to retrieve what you are trying to. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of remedy.help Sent: Tuesday, February 16, 2010 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: SQL help needed ** the error points to the Fetch statement Fetch C1 into froup_id,group_name It will be great if somebody has done sql manipulations on the C104 filed of the t9(User Form) On Tue, Feb 16, 2010 at 3:37 PM, Joe D'Souza jdso...@shyle.net wrote: ** What is the error that you are getting? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of amit dw Sent: Tuesday, February 16, 2010 4:20 PM To: arslist@ARSLIST.ORG Subject: SQL help needed ** Hello All, Below is the problem and way I was trying to handle it C_list contains comma separated values of group Id’s. this list contains all the group id’s associated to a particular login name. C_list= (1,15005,85,83,84,805) This variable will be holding up dynamically value in numbers. For group id numbers in simple sql statement we can get the result corresponding name using the below query, Select c105,c106 from t10 where c106 in (1, 101,102,104). Same query when I tried transforming in a cursor it throws up a compilation error. The error points out to a fetch statement where we try and fetch the data from the cursor for one particular group id. Declare cursor c1 as select c105,c106 from t10 where c106 in(c_list); Begin Open c1; Loop Fetch C1 into g_num,g_name; dbms_output.put_line(g_name); EXIT WHEN C1%NOTFOUND; END LOOP; Close c1; End; Hope it explains the problem I am facing. Any suggestions/Comments or previously implemented code will be helpful for me. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: SQL help needed
The second statement should be select count(*) from t9 where c104 like '1; %' or c104 like '% 1; %'; However I would rather use the view name of the user form which is user_x instead of t9 because if you are writing code that needs to be migrated across servers, writing SQL statements on the T tables may not be the best idea unless in your environment you are absolutely sure that you have the whole table structures migrated across systems maintaining the identical T numbers for those tables across environments.. So I would rather prefer the statement select count(*) from user_x where group_list like '1; %' or group_list like '% 1; %'; This statement will be good for all environments irrespective of how careful you are to ensure ideal case database migrations between different environments... As far as parsing the group ID's to real group names, if you absolutely have to do it using direct SQL queries why not try writing a stored procedure to do it? It may be a lot easier.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of remedy.help Sent: Tuesday, February 16, 2010 5:09 PM To: arslist@ARSLIST.ORG Subject: Re: SQL help needed ** What i need -- I need to pull out the group names from group list field(c104). Since it contains the group id and not the group names i need to convert it back to group names; Also can we do a select statement for group list field where we say select count(*) from t9 where c104 like '1'; I am on oracle DB and the list i have checked for every other string habits; regards On Tue, Feb 16, 2010 at 4:00 PM, Joe D'Souza jdso...@shyle.net wrote: ** Have you tried retrieving the same using a simple select statement using a like clause? I do not see a distinct advantage of using a cursor to retrieve what you are trying to. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of remedy.help Sent: Tuesday, February 16, 2010 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: SQL help needed ** the error points to the Fetch statement Fetch C1 into froup_id,group_name It will be great if somebody has done sql manipulations on the C104 filed of the t9(User Form) On Tue, Feb 16, 2010 at 3:37 PM, Joe D'Souza jdso...@shyle.net wrote: ** What is the error that you are getting? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of amit dw Sent: Tuesday, February 16, 2010 4:20 PM To: arslist@ARSLIST.ORG Subject: SQL help needed ** Hello All, Below is the problem and way I was trying to handle it C_list contains comma separated values of group Id’s. this list contains all the group id’s associated to a particular login name. C_list= (1,15005,85,83,84,805) This variable will be holding up dynamically value in numbers. For group id numbers in simple sql statement we can get the result corresponding name using the below query, Select c105,c106 from t10 where c106 in (1, 101,102,104). Same query when I tried transforming in a cursor it throws up a compilation error. The error points out to a fetch statement where we try and fetch the data from the cursor for one particular group id. Declare cursor c1 as select c105,c106 from t10 where c106 in(c_list); Begin Open c1; Loop Fetch C1 into g_num,g_name; dbms_output.put_line(g_name); EXIT WHEN C1%NOTFOUND; END LOOP; Close c1; End; Hope it explains the problem I am facing. Any suggestions/Comments or previously implemented code will be helpful for me. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: SQL help needed
Joe, Thanks for the response but the query on C104 doesnt catches it and if we give like '1%' it throws up lot of results. I was trying to write stored procedure for getting the names, but there also i am facing issues because of the variable containing mutliple values deliminated by ';' it will be great if you have something written on it and i can use it as model code ... On Tue, Feb 16, 2010 at 4:27 PM, Joe D'Souza jdso...@shyle.net wrote: ** The second statement should be select count(*) from t9 where c104 like '1; %' or c104 like '% 1; %'; However I would rather use the view name of the user form which is user_x instead of t9 because if you are writing code that needs to be migrated across servers, writing SQL statements on the T tables may not be the best idea unless in your environment you are absolutely sure that you have the whole table structures migrated across systems maintaining the identical T numbers for those tables across environments.. So I would rather prefer the statement select count(*) from user_x where group_list like '1; %' or group_list like '% 1; %'; This statement will be good for all environments irrespective of how careful you are to ensure ideal case database migrations between different environments... As far as parsing the group ID's to real group names, if you absolutely have to do it using direct SQL queries why not try writing a stored procedure to do it? It may be a lot easier.. Joe -Original Message- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org]*on Behalf Of *remedy.help *Sent:* Tuesday, February 16, 2010 5:09 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: SQL help needed ** What i need -- I need to pull out the group names from group list field(c104). Since it contains the group id and not the group names i need to convert it back to group names; Also can we do a select statement for group list field where we say select count(*) from t9 where c104 like '1'; I am on oracle DB and the list i have checked for every other string habits; regards On Tue, Feb 16, 2010 at 4:00 PM, Joe D'Souza jdso...@shyle.net wrote: ** Have you tried retrieving the same using a simple select statement using a like clause? I do not see a distinct advantage of using a cursor to retrieve what you are trying to. Joe -Original Message- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org]*on Behalf Of *remedy.help *Sent:* Tuesday, February 16, 2010 4:42 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: SQL help needed ** the error points to the Fetch statement Fetch C1 into froup_id,group_name It will be great if somebody has done sql manipulations on the C104 filed of the t9(User Form) On Tue, Feb 16, 2010 at 3:37 PM, Joe D'Souza jdso...@shyle.net wrote: ** What is the error that you are getting? Joe -Original Message- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org]*on Behalf Of *amit dw *Sent:* Tuesday, February 16, 2010 4:20 PM *To:* arslist@ARSLIST.ORG *Subject:* SQL help needed ** Hello All, Below is the problem and way I was trying to handle it C_list contains comma separated values of group Id’s. this list contains all the group id’s associated to a particular login name. C_list= (1,15005,85,83,84,805) This variable will be holding up dynamically value in numbers. For group id numbers in simple sql statement we can get the result corresponding name using the below query, Select c105,c106 from t10 where c106 in (1, 101,102,104). Same query when I tried transforming in a cursor it throws up a compilation error. The error points out to a fetch statement where we try and fetch the data from the cursor for one particular group id. Declare cursor c1 as select c105,c106 from t10 where c106 in(c_list); Begin Open c1; Loop Fetch C1 into g_num,g_name; dbms_output.put_line(g_name); EXIT WHEN C1%NOTFOUND; END LOOP; Close c1; End; Hope it explains the problem I am facing. Any suggestions/Comments or previously implemented code will be helpful for me. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Job: DC Metro - Clearable US Citizens - 6 Month Contract to Hire
If anyone is on the market for a permanent position in Fairfax, VA working for the FAA gives me a quick call tonight and I can go over logistics. I have 3 openings. Two of which is mid level Admins and one Senior level Developer Resource. Rates on Admin - 80-85K Rates on Developer - 90-110K Rates are dependent upon experience and education qualifications. This posting will expire in less than 12 hours. Respectfully, Joshua Kitchen Senior Recruiter | Kforce Federal Direct : 937.449.1749| Fax: 937.461.6888 | jkitc...@kforce.com mailto:jkitc...@kforce.com | www.govtrecruiter.com http://www.govtrecruiter.com Great People = Great Results Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
How to prevent others from modifying workflow/forms?
Dear All, I would like to know if there is a way that we can do some settings on forms and workflow objects (Active links , filters, escalations) to prevents any one else from doing any modification?? I am not sure if at all this can be done Please share your thoughts Regards Renjini ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: How to prevent others from modifying workflow/forms?
Any Administrator user has the right to modify any form.. The only possible way to do what you want to do (with some limitations), is to have only one single Administrator user whose access obviously is password protected, and a bunch of sub-Administrators each having an individual login and password.. Sub-Administrators can be assigned to specific forms with those Sub-Administrator rights leaving forms that need not be touched only privileged to the Administrator... Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Renjini Johney Sent: Tuesday, February 16, 2010 6:08 PM To: arslist@ARSLIST.ORG Subject: How to prevent others from modifying workflow/forms? ** Dear All, I would like to know if there is a way that we can do some settings on forms and workflow objects (Active links , filters, escalations) to prevents any one else from doing any modification?? I am not sure if at all this can be done Please share your thoughts Regards Renjini ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: SQL help needed
Appreciate the Pointer..Will work on that and update with the results; On Tue, Feb 16, 2010 at 4:57 PM, Joe D'Souza jdso...@shyle.net wrote: ** The reason that '1%' will throw a lot of results some of which are not relevant is because by that you are indicating that all records that have C104 end with 1 to be returned.. Instead if you use C104 like '1;%' or C104 like '% 1;%' (notice the space before 1), you will limit the results to wherever there is a 1; only.. I do not have a model code for your other example, but you could check the SQL that Remedy uses, to convert the string from ID's to name when you pull up a user record on the user form.. SQL logging will reveal that. They do not use a stored procedure, but you could use the same SQL logic that is used to write your own.. Joe -Original Message- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org]*on Behalf Of *remedy.help *Sent:* Tuesday, February 16, 2010 5:39 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: SQL help needed ** Joe, Thanks for the response but the query on C104 doesnt catches it and if we give like '1%' it throws up lot of results. I was trying to write stored procedure for getting the names, but there also i am facing issues because of the variable containing mutliple values deliminated by ';' it will be great if you have something written on it and i can use it as model code ... On Tue, Feb 16, 2010 at 4:27 PM, Joe D'Souza jdso...@shyle.net wrote: ** The second statement should be select count(*) from t9 where c104 like '1; %' or c104 like '% 1; %'; However I would rather use the view name of the user form which is user_x instead of t9 because if you are writing code that needs to be migrated across servers, writing SQL statements on the T tables may not be the best idea unless in your environment you are absolutely sure that you have the whole table structures migrated across systems maintaining the identical T numbers for those tables across environments.. So I would rather prefer the statement select count(*) from user_x where group_list like '1; %' or group_list like '% 1; %'; This statement will be good for all environments irrespective of how careful you are to ensure ideal case database migrations between different environments... As far as parsing the group ID's to real group names, if you absolutely have to do it using direct SQL queries why not try writing a stored procedure to do it? It may be a lot easier.. Joe -Original Message- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org]*on Behalf Of *remedy.help *Sent:* Tuesday, February 16, 2010 5:09 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: SQL help needed ** What i need -- I need to pull out the group names from group list field(c104). Since it contains the group id and not the group names i need to convert it back to group names; Also can we do a select statement for group list field where we say select count(*) from t9 where c104 like '1'; I am on oracle DB and the list i have checked for every other string habits; regards On Tue, Feb 16, 2010 at 4:00 PM, Joe D'Souza jdso...@shyle.net wrote: ** Have you tried retrieving the same using a simple select statement using a like clause? I do not see a distinct advantage of using a cursor to retrieve what you are trying to. Joe -Original Message- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org]*on Behalf Of *remedy.help *Sent:* Tuesday, February 16, 2010 4:42 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: SQL help needed ** the error points to the Fetch statement Fetch C1 into froup_id,group_name It will be great if somebody has done sql manipulations on the C104 filed of the t9(User Form) On Tue, Feb 16, 2010 at 3:37 PM, Joe D'Souza jdso...@shyle.net wrote: ** What is the error that you are getting? Joe -Original Message- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org]*on Behalf Of *amit dw *Sent:* Tuesday, February 16, 2010 4:20 PM *To:* arslist@ARSLIST.ORG *Subject:* SQL help needed ** Hello All, Below is the problem and way I was trying to handle it C_list contains comma separated values of group Id’s. this list contains all the group id’s associated to a particular login name. C_list= (1,15005,85,83,84,805) This variable will be holding up dynamically value in numbers. For group id numbers in simple sql statement we can get the result corresponding name using the below query, Select c105,c106 from t10 where c106 in (1, 101,102,104). Same query when I tried transforming in a cursor it throws up a compilation error. The error points out to a fetch statement where we try and fetch the data from the cursor for one particular group id. Declare cursor c1 as select c105,c106 from
Problem Investigation Cancelled Status Reasons
** Hello, Can anyone tell me what status reasons are available for a Cancelled problem investigation in ITSM 7.6? I didn't see a list in the docs anywhere and I don't have 7.6 installed anywhere. We are on ITSM 7.0.3 patch 9, and the only status reason for cancelled is Duplicate Investigation. One of my customers is asking for more status reasons for Cancelled and I'm hoping to put off that customization until we can get to 7.6. Thanks, Thad Esser Remedy Developer *IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature. * _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
Re: Problem Investigation Cancelled Status Reasons
Well, since those are stored as form data, technically, they wouldn't be customizations, just configuration changes, right? Rick On Tue, Feb 16, 2010 at 4:02 PM, Thad K Esser tkes...@regence.com wrote: ** Hello, Can anyone tell me what status reasons are available for a Cancelled problem investigation in ITSM 7.6? I didn't see a list in the docs anywhere and I don't have 7.6 installed anywhere. We are on ITSM 7.0.3 patch 9, and the only status reason for cancelled is Duplicate Investigation. One of my customers is asking for more status reasons for Cancelled and I'm hoping to put off that customization until we can get to 7.6. Thanks, *Thad Esser* Remedy Developer *IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature. * _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Problem Investigation Cancelled Status Reasons
** Almost. (This applies to 7.0.3, haven't seen 7.6 yet) There's a hidden enumerated field Invesitgation Status Reason (I just noticed the spelling - nice) that gets set with whatever the user chooses from the z1D_Status_Reason field (which is the one that they see and is display only). Workflow keeps them in sync. The display only field uses a search menu, so that is just configuration. But the hidden field is an enumerated field with fixed values for any possible status reason (not just cancelled). I can add values to that field, but it also shows up on a couple of other forms, and I'd have track down any related workflow. Plus I don't want to use an ID that will be overwritten in future versions. All in all, its not a super-duper hard customization, but I'd rather avoid customizing at all. Being able to point to options in the next version would help me make my case. Thanks, Thad Esser Remedy Developer From: Rick Cook remedyr...@gmail.com To: arslist@ARSLIST.ORG Date: 02/16/2010 04:05 PM Subject: Re: Problem Investigation Cancelled Status Reasons Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG ** Well, since those are stored as form data, technically, they wouldn't be customizations, just configuration changes, right? Rick On Tue, Feb 16, 2010 at 4:02 PM, Thad K Esser tkes...@regence.com wrote: ** Hello, Can anyone tell me what status reasons are available for a Cancelled problem investigation in ITSM 7.6? I didn't see a list in the docs anywhere and I don't have 7.6 installed anywhere. We are on ITSM 7.0.3 patch 9, and the only status reason for cancelled is Duplicate Investigation. One of my customers is asking for more status reasons for Cancelled and I'm hoping to put off that customization until we can get to 7.6. Thanks, Thad Esser Remedy Developer *IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature. * _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ *IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature. * _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
User Tool 7.5.00.004 hanging on ITSM 7.6 application consoles
We started seeing very intermittent problems with the User Tool not responding while testing 7.5.00.003a, mainly with the Incident Console and form. This may have coincided with the recent update of Adobe Flash Player, as well. It became a problem across the board after we installed 7.5.00.004. Today I put 7.5.00.003a on a Vista vm with the older (Oct 2009) Flash Player, and it loaded ALL consoles, no problem. As SOON as I updated it to patch 004, it would hang immediately on Incident, Problem, Asset, CMDB, sometimes Change. It still opens the Admin Consoles, SLM, AIE, Approval, RKM (anything NOT part of ITSM) without hanging - these have never been prone to hanging in any version. Updating the server to 7.5.00.004 from 003 did not help. It even hangs on the User Tool that is locally installed on the AR Server... which doesn't even have Flash installed. Anyone else seeing similar issues? We have seen the problem with clients on: XP Pro Sp3 Vista Ultimate Sp2 Windows 7 Ultimate Windows Server 2003 Ent x64 Sp2 Windows Server 2008 R2 Ent x64 Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: How to prevent others from modifying workflow/forms?
Well... You can also lock the workflow too. However that should only be done under extreme conditions. (Like trying to sell ARS applications.) Or was that removed in 7.5 ? [ I have not looked for it in that version.] -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Tue, Feb 16, 2010 at 6:28 PM, Joe D'Souza jdso...@shyle.net wrote: ** Any Administrator user has the right to modify any form.. The only possible way to do what you want to do (with some limitations), is to have only one single Administrator user whose access obviously is password protected, and a bunch of sub-Administrators each having an individual login and password.. Sub-Administrators can be assigned to specific forms with those Sub-Administrator rights leaving forms that need not be touched only privileged to the Administrator... Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Renjini Johney Sent: Tuesday, February 16, 2010 6:08 PM To: arslist@ARSLIST.ORG Subject: How to prevent others from modifying workflow/forms? ** Dear All, I would like to know if there is a way that we can do some settings on forms and workflow objects (Active links , filters, escalations) to prevents any one else from doing any modification?? I am not sure if at all this can be done Please share your thoughts Regards Renjini ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: How to prevent others from modifying workflow/forms?
It's still there - just not used anymore by BMC as a selling model. And yes, it'd be an extreme solution to this issue. ;-) -David J. Easter Sr. Product Manager, Solution Strategy and Development BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Carey Matthew Black Sent: Tuesday, February 16, 2010 6:39 PM To: arslist@ARSLIST.ORG Subject: Re: How to prevent others from modifying workflow/forms? Well... You can also lock the workflow too. However that should only be done under extreme conditions. (Like trying to sell ARS applications.) Or was that removed in 7.5 ? [ I have not looked for it in that version.] -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Tue, Feb 16, 2010 at 6:28 PM, Joe D'Souza jdso...@shyle.net wrote: ** Any Administrator user has the right to modify any form.. The only possible way to do what you want to do (with some limitations), is to have only one single Administrator user whose access obviously is password protected, and a bunch of sub-Administrators each having an individual login and password.. Sub-Administrators can be assigned to specific forms with those Sub-Administrator rights leaving forms that need not be touched only privileged to the Administrator... Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Renjini Johney Sent: Tuesday, February 16, 2010 6:08 PM To: arslist@ARSLIST.ORG Subject: How to prevent others from modifying workflow/forms? ** Dear All, I would like to know if there is a way that we can do some settings on forms and workflow objects (Active links , filters, escalations) to prevents any one else from doing any modification?? I am not sure if at all this can be done Please share your thoughts Regards Renjini ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Setting up a pre-production server.
Many thanks Joe. This is exactly what I needed to know. No need for manuals .-) --- En date de : Mar 16.2.10, Joe D'Souza jdso...@shyle.net a écrit : De: Joe D'Souza jdso...@shyle.net Objet: Re: Setting up a pre-production server. À: arslist@ARSLIST.ORG Date: Mardi 16 février 2010, 19h39 ** You do not need to run the upgrade option. Since you have cloned both the application and the database servers, all you would need to do is, massage the configuration files, and services to reflect the new server names wherever applicable. Do not forget massaging the armonitor file as well. That file will have old server references as well. You may need to touch the host file as well depending on how your network is configured. Your second step would be to clean configuration data off any server references. Applications like AIE, SRM keep hard coded server references in the configuration data so if you have the AIE component installed as a part of CMDB, you will need to export the AIE configurations, and re-import them after cleaning the references. Export and import this data from the configuration utility using the export and import functions built there.. Ideally the workflow should be free of server references, but in the real world this hardly is ever true. So you might need to deal with cleaning server references, from the workflow, before you can really use the new pre-production/test environment. This may take you the longest time.. The easiest way to do this is to export all the def files to XML format, and look for the old server names both FQDN (do this first) and just the domain name after you look for FQDN's and replace these with @. Also look for old IP addresses in the workflow and replace these with @. I've seen numerous developers use IP addresses, to connect their development tool to the AR System leaving their workflow infested with server references by way of IP addresses. Do not really bother about licensing. Just install the new applicable licenses for the new server, the ARS will simply ignore the old licenses after it doesn't match that license with its new server name. If you really want to be anal about it (like I usually am), yes you can delete the license records of the old server. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Frex Popo Sent: Tuesday, February 16, 2010 5:45 AM To: arslist@ARSLIST.ORG Subject: Setting up a pre-production server. ** Dear arlisters, Anyone would like to share the steps/experience on how to set up a pre-production/test environment for ARS7.1/CMDB2.1/ITSM7.0.3. We have a server group consisting of two nodes (node1 passive and node2 active) pointing to the same database: DB: Database MS SQL 2005 (X64) ARS 7.1.0 Patch 004 OS: MS 2003 Enterprise Edition SP2 (X64) WebServer: IBM WebSphere Application Server/6.1 Mid-Tier: 7.1.0 Patch 004 OS: Windows Server 2003 Java Version: 1.5.0 Node1 has been cloned to a VM-Ware and about to do the same with the databse instance. My question is what's next? re-run the server installer and use the upgrade option? Massage the config files for all the remedy services or re-run the installers? How do you get rid of all the server group refernces in the databse? How about licensing? etc etc... The whole process is really to test the new 7.5 version. Many thansk in advance frex_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Server config
Hi, As long as the files actually reside in different directories, you could allways have different directories go to different hard drives. In Unix/Linux it is very easy to link a directory, or even individual files, to wherever you want in the file system. On Windows, I think you must mount a hard drive exclusively to a specific directory (or drive letter). With this technique you can have Discovery think the files are in the original place. As for configurating the location of the Dirscovery data files, I do not know... Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. We are discovery 1.6. For our configuration, is it possible to separate the data files from the application binaries? To save space, our Management wants to put the Discovery application binaries on 1 drive, and the Discovery data files on another drive. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
AW: SQL help needed
if you turn on sql-logging and search for users belong to administrator group you will see a statement like this. SELECT * FROM ( SELECT T31.C1,C101,C536870913,C8,C536870912,C54000,C54002 FROM T31 WHERE ((T31.C104 LIKE '1;%') OR (T31.C104 LIKE '% 1;%') OR (T31.C104 LIKE '%;1;%')) ORDER BY 1 ASC ) This makes sense because in earlier versions of arsystem the groupids were separeted by ;space and now it's only separated by ; Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Joe D'Souza Gesendet: Dienstag, 16. Februar 2010 23:27 An: arslist@ARSLIST.ORG Betreff: Re: SQL help needed ** The second statement should be select count(*) from t9 where c104 like '1; %' or c104 like '% 1; %'; However I would rather use the view name of the user form which is user_x instead of t9 because if you are writing code that needs to be migrated across servers, writing SQL statements on the T tables may not be the best idea unless in your environment you are absolutely sure that you have the whole table structures migrated across systems maintaining the identical T numbers for those tables across environments.. So I would rather prefer the statement select count(*) from user_x where group_list like '1; %' or group_list like '% 1; %'; This statement will be good for all environments irrespective of how careful you are to ensure ideal case database migrations between different environments... As far as parsing the group ID's to real group names, if you absolutely have to do it using direct SQL queries why not try writing a stored procedure to do it? It may be a lot easier.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of remedy.help Sent: Tuesday, February 16, 2010 5:09 PM To: arslist@ARSLIST.ORG Subject: Re: SQL help needed ** What i need -- I need to pull out the group names from group list field(c104). Since it contains the group id and not the group names i need to convert it back to group names; Also can we do a select statement for group list field where we say select count(*) from t9 where c104 like '1'; I am on oracle DB and the list i have checked for every other string habits; regards On Tue, Feb 16, 2010 at 4:00 PM, Joe D'Souza jdso...@shyle.net wrote: ** Have you tried retrieving the same using a simple select statement using a like clause? I do not see a distinct advantage of using a cursor to retrieve what you are trying to. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of remedy.help Sent: Tuesday, February 16, 2010 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: SQL help needed ** the error points to the Fetch statement Fetch C1 into froup_id,group_name It will be great if somebody has done sql manipulations on the C104 filed of the t9(User Form) On Tue, Feb 16, 2010 at 3:37 PM, Joe D'Souza jdso...@shyle.net wrote: ** What is the error that you are getting? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of amit dw Sent: Tuesday, February 16, 2010 4:20 PM To: arslist@ARSLIST.ORG Subject: SQL help needed ** Hello All, Below is the problem and way I was trying to handle it C_list contains comma separated values of group Id's. this list contains all the group id's associated to a particular login name. C_list= (1,15005,85,83,84,805) This variable will be holding up dynamically value in numbers.