how to change temporary the submitter on the fly

2009-04-03 Thread Remedy Maniac
dear listers, I have to fulfill the following requirements: only the submitter of a ticket and people in the CC list should have access to the ticket. The CC list being basically a character field My question is then: how do I need to proceed? Right now I am completely stuck. Any great idea

Re: Problems with BMC Developer Network

2009-04-03 Thread Kelly Deaver
** if you experience problems email bm...@bmc.com Kelly Deaver kdea...@kellydeaver.com (Yes, I work for BMC. This post reflects the opinions of the poster and not the official opinion of BMC) Original Message Subject: Problems with BMC Developer NetworkFrom: bruce sisk

Re: AR Inside with 7.5

2009-04-03 Thread support
Dear list, The Document functionality of ARSmarts is currently in an advanced phase of development. We plan a beta program sometime in May. The Document feature produces an HTML documentation of AR System objects. It includes the cross-references. It works with cascading style sheets to

Re: Direct SQL action to a Linked MS SQL Server db

2009-04-03 Thread Reiser, John J
Nicky, Thanks. I tried this select ProductType='HARDWARE' into SW_License from PL_MR_LineItems where MRNumber = 'TM099' and got 1 row affected. I am not a dba so I am winging this. I don't fully understand what this statement means. ProductType='HARDWARE' is the column and data in my

Re: how to change temporary the submitter on the fly

2009-04-03 Thread jham36
Take a look at Dynamic Groups. I have not used them and I am not sure it will solve your problem, but it's worth looking into. Refer to the Form and Application Objects document. I just noticed your server is 6.0. I don't know if dynamic groups are available for 6.0. James On Apr 3, 4:06 am,

Re: Direct SQL action to a Linked MS SQL Server db

2009-04-03 Thread Nicky Madjarov
Direct SQL action to a Linked MS SQL Server dbJohn, I'm sorry, I did not realized that you can run your insert statement from the sql directly. Select into copies records from one table to another, if you specify fields, it will just copy these fields. Now, on your problem. When you run your

Re: how to change temporary the submitter on the fly

2009-04-03 Thread Nicky Madjarov
Hi, It depends what is the content of your CC field, user names, full names, etc. Based on it the approach could be quite different. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From:

SRM and Reopening Inicdents

2009-04-03 Thread SCOTT PHILBEN
All: I have SRM 2.2 patch 002 and I have an existing Request which created an Incident. When the Support Person Resolves the Incident, a Survey request is created for the User. When the User fills in the Survey and selects the Reopen the Service Request option shouldn't the system reopen the

Re: Direct SQL action to a Linked MS SQL Server db

2009-04-03 Thread Reiser, John J
Nicky, Thanks. That really helped. For some reason the old setup was working fine. Using the new ARS 7.1 and a New DB version seems to be causing conflicts with the column names. It looks like I need to rewrite my Direct SQL and correct the column names. Thanks for your help. --- John J.

Re: SRM and Reopening Inicdents

2009-04-03 Thread Savant, don...@dts
Yes, we ran into this issue and debated it with BMC but it is working 'as designed'. The only thing we could do with it is route the Work Order to the Service Desk and have them update the back office entry accordingly. -Original Message- From: Action Request System discussion

Re: SRM and Reopening Inicdents -- SOLVED

2009-04-03 Thread SCOTT PHILBEN
Looks like I found the answer on BMC's website: Problem 20005347 Please refer to the updated Service Request Management 2.2.00 Release Notes page 16. These release notes were refreshed on the support web site, so be sure to have the most recent copy. Defect SW00261294 When working on the

Re: SRM and Reopening Inicdents -- SOLVED

2009-04-03 Thread Tanner, Doug
Your Business, BMC's way! -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of SCOTT PHILBEN Sent: Friday, April 03, 2009 1:45 PM To: arslist@ARSLIST.ORG Subject: Re: SRM and Reopening Inicdents -- SOLVED Looks like I found

FW: Am I making this more difficult than it is?

2009-04-03 Thread Kemes, Lisa
I have a record with a Start Date field of: 4/12/2009 12:00:00 AM and an End Date field of: 4/30/2009 12:00:00 AM. If someone were to create another record with a Start Date of: 4/1/2009 12:00:00 AM and an End Date field of 4/15/2009 12:00:00 AM, I want it to error because this would

Re: External Condition in Active Link Set Field - SQL Action

2009-04-03 Thread Mueller, Doug
Vijayalakshmi, The situation you are dealing with here is where we have to make a call with what to do. There are syntax issues and requirements of SQL and we are trying to help the right thing happen. Most commonly, the substitution into a command is of a value. You can substitute entire

Re: Am I making this more difficult than it is?

2009-04-03 Thread Lyle Taylor
It's simpler than it seems at first. If you're trying to find if there is a conflicting record, you're looking for something like this: Existing_start_date new_end_date and existing_end_date new_start_date That is, in order for the new time period to overlap the old one, the new time period

Re: Am I making this more difficult than it is?

2009-04-03 Thread Givens, Gregory CONT
Simple answer.. Yes Think a Push fields action. Query 'Start Date' = $Start Date$ and 'End Date' = $End Date$ For a match Display an error message No Match take no action since you are submitting the ticket anyway Greg Givens -Original Message- From: Action Request System discussion

Re: Am I making this more difficult than it is?

2009-04-03 Thread ARSmarts Support
Hi Lisa, I think you need to create a filter with a Set Field action that will check the condtion hereafter, and a second one that will raise an error if the first filter found a matching record. Let's assume that your form is called Sample You create a display-only field on that form

Re: Am I making this more difficult than it is?

2009-04-03 Thread Kemes, Lisa
This works! Thanks so much Lyle!! Lisa From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Friday, April 03, 2009 2:45 PM To: arslist@ARSLIST.ORG Subject: Re: Am I making this more difficult than

Re: SRM and Reopening Inicdents -- SOLVED

2009-04-03 Thread Lyle Taylor
I understand where you're coming from, however I think I can also see where BMC is coming from. The problem is that an SRD can involve a complex set of tasks that may involve several different record types. For example, if you create an SRD to onboard an employee, there will be multiple

ARS 7.1 SQL 2005 Server install error

2009-04-03 Thread tina flores
I'm installing ARS 7.1 (Server) on SQL 2005 on Windows Environment. Installation is completed with error: Unable to start the AR System service. The AR System Server could not be started. You can start it manually using the Services in the Control Panel. Checking the DB logs, it says:

Re: 75 Install and Database Administrator username/password (SOLVED)

2009-04-03 Thread Lyle Taylor
Thanks, all for your help. I finally figured out what the deal was. So, the issue was due to the fact that we are using an Oracle RAC which has multiple database servers hitting the same database for redundancy. The issue is that, while for most clients, the service name is the service name,

Re: 75 Install and Database Administrator username/password (SOLVED)

2009-04-03 Thread Nicky Madjarov
Lyle, Thanks for sharing, it is diffinitelly very insightfull and certainly keeper. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Lyle Taylor Newsgroups: