Re: SLM Met

2009-05-29 Thread Rohini Prasher
Hi Tim, You can define custom qualification for SVT with Priority 'Low'. Regards, Rohini Prasher From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Tim Rondeau Sent: Thursday, May 28, 2009 10:34 PM To:

Re: Close window without saving

2009-05-29 Thread Nicky Madjarov
John, You may consider displaying the message in another dialog window, this way you can pass the user selection back to the original dialog and respond accordingly. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com -

Re: OT:Server Configuration

2009-05-29 Thread Nicky Madjarov
Hi Roger, The 7.5 64 bit apps are for unix, so, in order to take advantage of more memory you have to change the os. If I remember correct, the Windows apps are still 32 bit, they can run on 64 bit windows OS, and they will not utilize well the wintel memory (to the limit of how much memory 32

Join forms using join field that are not indexed.

2009-05-29 Thread Frex Popo
Dear all,   I am looking at an issue with some join forms. I found a couple using fields - in the join criteria - that are not indexed. However since we have over a 100 join forms and would like to check them all, I would like to know if anyone - without reinventing the wheel - has a sql query

Re: SLM Met

2009-05-29 Thread Rohini Prasher
Create another SVT with Qualification like TR.Priority=Low and DB.Priority != $NULL$. Create a SVT group. Include, the two SVTs in the same group. Regards, Rohini Prasher From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On

ADM:timing Test

2009-05-29 Thread Daniel Bloom
10:36a.m. EST (according to my watch) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

Re: Walking through table - server side, maybe? - Resolved

2009-05-29 Thread Brandi Barbour
Thank you Lyle and Tim.. It is working now. Thanks again for your help. Brandi | | From: | | | |Lyle Taylor

Question About Data Parsing

2009-05-29 Thread Begosh, Kevin
I have a data set that I am trying to parse out. The comes in as an example of 123-456, and 12-3456, and 1234-56. I know how to pull the data out based on how many characters there are say from the left side but was you can see this is dynamic. Is there any way in remedy to say, all

Re: Question About Data Parsing

2009-05-29 Thread Lyle Taylor
Take a look at the STRSTR function. You can use it to find the index of the '-', and then use the result as an argument to SUBSTR to tell it how many characters to pull out. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Begosh, Kevin

Re: Question About Data Parsing

2009-05-29 Thread Rick Cook
Yes. The STRSTR function allows you to base your actions on a character found rather than a static position. You then use the position of the character as a variable in your LEFT, RIGHT, etc statements. You can put them in separate actions or nest them within one. Rick -Original

Re: Question About Data Parsing

2009-05-29 Thread Begosh, Kevin
Okay well I got that to work. How about if there was a second one, like 123-456-789? How would I try and find the second - Kevin Begosh From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Friday, May 29, 2009 9:15 AM To:

Re: Question About Data Parsing

2009-05-29 Thread Lyle Taylor
After you find the first one, you could break off the next part of the string using RIGHT or SUBSTR and then do a STRSTR on that string to find the next one. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Begosh, Kevin Sent: Friday, May 29,

Re: Question About Data Parsing

2009-05-29 Thread Begosh, Kevin
Okay, so start the next string at that integers #? Kevin Begosh, RSP Tech Ops Enterprise Business Services 301-791-3540 Phone 410-422-3623 Cell kevin.beg...@lmco.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Friday, May 29,

Re: Question About Data Parsing

2009-05-29 Thread Rick Cook
Two ways come to mind: 1) Take the position of the first one you found, add one to it, and then use that as a basis for further searches. 2) Actually parse a copy of the original string and chop the first part off of it, then re-run the STRSTR. Rick On Fri, May 29, 2009 at 8:43 AM, Begosh,

Re: Question About Data Parsing

2009-05-29 Thread Lyle Taylor
If you're using SUBSTR, you'd probably use the result of STRSTR + 1 to start just after the '-'. For example SUBSTR($string$, STRSTR($string$, '-') + 1) Would return the portion of the string after the first hyphen. Lyle From: Action Request System discussion list(ARSList)

Re: Question About Data Parsing

2009-05-29 Thread Lyle Taylor
Sorry, I need to correct my syntax a bit - shouldn't have used single quotes: SUBSTR($string$, STRSTR($string$, -) + 1) Lyle From: Lyle Taylor Sent: Friday, May 29, 2009 10:02 AM To: 'arslist@ARSLIST.ORG' Subject: RE: Question About Data Parsing If you're using SUBSTR, you'd probably use the

Re: Question About Data Parsing

2009-05-29 Thread Begosh, Kevin
Yes that works too. These are all great ideas. Thanks guys for your help. Kevin Begosh From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Friday, May 29, 2009 10:02 AM To: arslist@ARSLIST.ORG Subject: Re: Question About Data

Re: Question About Data Parsing

2009-05-29 Thread Dane Huish
Do you NEED to maintain the original format, or are you just trying to get the raw numbers?  My guess would be you want to normalize the data by removing the random formatting, then possibly putting it into a consistent format?  You could just use the REPLACE function to replace all dashes with

CRQ's Assignment

2009-05-29 Thread Tim Rondeau
Running ars 7.0.1 patch 2 on SQL 2005, ITSM Currently having issues which only happens now and then, but causes issues. Basically a Change Request is assigned to a group or individual, but it looks like to that person it really is not assigned to there group or that person. I found

ARERR [311] Field ID is not related to this form : 200000020

2009-05-29 Thread Dwayne Martin
Dear List, I have a form (Form A) with 20,000 records. I can open the form in the client User tool, and run an unqualified query and retrieve all records. On Form B and C I have buttons that call Active Links, which are supposed to open particular records in Form A. But instead I get the

Re: CRQ's Assignment

2009-05-29 Thread Lyle Taylor
I've seen issues like this when people simply type or copy and paste into the assignment fields. Make sure that people are either selecting groups/people using the menus or pressing the Enter key after typing or pasting into the fields to make sure the system accepts them. The ITSM apps are

LDAP question

2009-05-29 Thread Shane Buchholz
We are trying to configure Remedy to set the Profile Status to Obsolete in the CTM:People form when they have been deleted from Active Directory. The most logical approach is to use an escalation that will fire at regular intervals to keep the CTM:People form as up to date as possible, but the

Re: Asset Management 7.01

2009-05-29 Thread Lyle Taylor
Well, you can get close by looking at the CMDB CDM diagram. It lists at least most of the attributes, and probably the majority of those attributes are represented somehow on the Asset Forms as well. Other than that, I'm not aware of anything. Lyle From: Action Request System discussion

Re: LDAP question

2009-05-29 Thread Lyle Taylor
If you created an outer-join form between CTM:People and your AD form, you could run a query or have a table qualification where you have a value from CTM:People but the corresponding value from the AD form is NULL. That would give you all the records that are in CTM:People but not in AD. For

Re: ARERR [311] Field ID is not related to this form : 200000020

2009-05-29 Thread remedy
Is any additional workflow being triggered on Display, Window Open, Search etc.. If so, perhaps one of those is referencing that field. Dear List, I have a form (Form A) with 20,000 records. I can open the form in the client User tool, and run an unqualified query and retrieve all records.

Designating a Manager in CTM:People

2009-05-29 Thread bruce sisk
I am sure I should know this, but... How does one designate\identify a Manager in ITSM 7x?? Pre 7 the SHR:People form had a Manager Yes | No drop down list. I cannot seem to find where you do the equivalent in 7. Any help for the unknowing is appreciated. Bruce Sisk BFS Enterprises

Re: ARERR [311] Field ID is not related to this form : 200000020

2009-05-29 Thread Dwayne Martin
Thanks, but I've run Active Link and Filter logs, and there is no workflow triggered that references 20020. Dwayne Original message Date: Fri, 29 May 2009 15:26:36 -0400 From: rem...@arutilities.com Subject: Re: ARERR [311] Field ID is not related to this form : 20020 To:

Re: Designating a Manager in CTM:People

2009-05-29 Thread Charles Baldi
Bruce, I have not used it much but I think what you do is put the manager's name in the Manager's Name+ field of their subordinates' People records. You don't identify someone *as* a manager but you identify managers of People records. It does make identifying all the managers more tricky.

Re: LDAP question

2009-05-29 Thread Nicky Madjarov
How many people records do you work with? Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Shane Buchholz Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG

Re: LDAP question

2009-05-29 Thread Shane Buchholz
Lyle, This is the first approach I attempted, but inetorgperson is a vendor form and does not show up in the list of possible forms to join. I was trying to avoid creating another form to store the same data, but it sounds like that may be the only option available. Shane From: Action

Re: LDAP question

2009-05-29 Thread Pierson, Shawn
I built a custom Vendor form on my own so I could pull in some fields that I wanted and leave out others. Anyway, if you set up an escalation or filter to modify People data (I use a filter, with the escalation pushing to a staging form where all the transformation and other filters take

Re: ARERR [311] Field ID is not related to this form : 200000020

2009-05-29 Thread Nicky Madjarov
You may want to check your menus for this field as well. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Dwayne Martin marti...@jmu.edu Newsgroups: public.remedy.arsystem.general To:

Re: LDAP question

2009-05-29 Thread Lyle Taylor
That makes me think of another possibility. You could potentially have a form with a table on it that points to CTM:People. You could loop over the table and look up each person individually on the AD form. If the person isn't there, you can mark them as Obsolete. That wouldn't be terribly