Setting up a pre-production server.

2010-02-16 Thread Frex Popo
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

Re: ARERR 1904

2010-02-16 Thread Craig Carter
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

Unexplained Explorer behavior within Atrium Core Console

2010-02-16 Thread Ob1 Kenobi
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.

Re: ARERR 1904

2010-02-16 Thread Martinez, Marcelo A
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

Update of Style Sheets and ARS 7.5 and ITSM 7.5

2010-02-16 Thread Terje Moglestue
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

Custom notification fields

2010-02-16 Thread Martinez, Marcelo A
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

Re: Update of Style Sheets and ARS 7.5 and ITSM 7.5

2010-02-16 Thread Mike Wallick
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

Re: Custom notification fields

2010-02-16 Thread Rabi Tripathi
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

Re: Update of Style Sheets and ARS 7.5 and ITSM 7.5

2010-02-16 Thread Terje Moglestue
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

Re: Custom notification fields

2010-02-16 Thread Martinez, Marcelo A
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

Re: Setting up a pre-production server.

2010-02-16 Thread Joe D'Souza
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

Re: Web Services - please enlight me!

2010-02-16 Thread Grooms, Frederick W
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

Consuming Complex External Web Service Help

2010-02-16 Thread Roys, Eric D
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

SQL help needed

2010-02-16 Thread amit dw
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

Import Asset Relationships

2010-02-16 Thread Tommy Morris
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

Re: SQL help needed

2010-02-16 Thread Tommy Morris
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

Re: SQL help needed

2010-02-16 Thread Joe D'Souza
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,

Re: SQL help needed

2010-02-16 Thread remedy.help
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

Re: SQL help needed

2010-02-16 Thread Grooms, Frederick W
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,

Server config

2010-02-16 Thread Kathy Morris
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.

Re: SQL help needed

2010-02-16 Thread Joe D'Souza
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

Re: SQL help needed

2010-02-16 Thread Joe D'Souza
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

Re: SQL help needed

2010-02-16 Thread remedy.help
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

Job: DC Metro - Clearable US Citizens - 6 Month Contract to Hire

2010-02-16 Thread Kitchen, Joshua
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

How to prevent others from modifying workflow/forms?

2010-02-16 Thread Renjini Johney
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

Re: How to prevent others from modifying workflow/forms?

2010-02-16 Thread Joe D'Souza
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

Re: SQL help needed

2010-02-16 Thread remedy.help
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

Problem Investigation Cancelled Status Reasons

2010-02-16 Thread Thad K Esser
** 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.

Re: Problem Investigation Cancelled Status Reasons

2010-02-16 Thread Rick Cook
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

Re: Problem Investigation Cancelled Status Reasons

2010-02-16 Thread Thad K Esser
** 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

User Tool 7.5.00.004 hanging on ITSM 7.6 application consoles

2010-02-16 Thread strauss
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

Re: How to prevent others from modifying workflow/forms?

2010-02-16 Thread Carey Matthew Black
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 =

Re: How to prevent others from modifying workflow/forms?

2010-02-16 Thread Easter, David
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

Re: Setting up a pre-production server.

2010-02-16 Thread Frex Popo
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 **

Re: Server config

2010-02-16 Thread Misi Mladoniczky
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

AW: SQL help needed

2010-02-16 Thread Conny Martin
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