Conversion between Character fields and Date fields.

[Jerry Niman]

Dear listers,

I have been having an issue where I was trying to read a value from a character 
field
into a date field.

Try as I might, I couldn't get correct behaviour for years in the early part of 
the
century (this was necessary as I was trying to capture dates of birth).

I tried setting ARDATEONLY and NLS_DATE_FORMAT but couldn't get it to work.

I eventually found a work-round parsing the character string down into day. 
month and
year components, then converting the month to a month number and then using 
DATEADD to
re-assemble the bits into a Date value.

However, this is of course less than satisfactory.

I am told that BMC do not support converting a Character field into a Date 
field.

Does anyone else think that this would be a REALLY GOOD THING?

Can I drum up support for this enhancement?

Jerry

Jerry NimanTel+44 (0)161-247 1474
Head of Information and Communication Technology Services Email 
[EMAIL PROTECTED]
the Manchester Metropolitan University Mobile +44 (0)7770 638104

Before acting on this email or opening any attachments you should read the 
Manchester
Metropolitan University’s email disclaimer available on its website
http://www.mmu.ac.uk/emaildisclaimer

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Has any one used MS SQL Express edition 2005 on arserver 7.1?

[brian . bishop]

I have Version 7.1 installed on my laptop with MS SQL express 2005. It works
fine.

 

Only issue I had was with identifying the server. My install expected
\SQLEXPRESS after my laptop name which is what I used when installing SQL.

 

It was actually easier than using full blown SQL!

 

Brian Bishop

Goldstag Consultants Ltd

Tel: +44(0)7973 746832

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Howard Richter
Sent: 07 March 2008 02:13
To: arslist@ARSLIST.ORG
Subject: Has any one used MS SQL Express edition 2005 on arserver 7.1?

 

** 

Good morning, evening or afternoon all,

 

Has anyone been able to used the MS SQL express edition on arserver 7.1?

 

Thanks,

 

hbr

-- 
Howard Richter
ITIL Foundation Certified
Red Hat Certified Technician
CompTIA Linux+ Certified
[EMAIL PROTECTED]
Resume = http://hotjobs.yahoo.com/resumes/hrichter_1/masterresume20(2) 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

CMDB 2.1 Custom Attribute Permission

[Bhagawat, Prashanth]

 
Hi Listers,
 
Has any one tried of giving custom permissions to the attributes of the
class in CMDB. 
 
I want to add couple of new attributes to class  define custom
permission to those attributes , such that any user who is accessing CI
from the asset management console , should have visibility to the field
if he belongs to the custom group. i.e if the custom group is part of
the group list.
 
BMC claims that this is straight forward, which seems to be not working.
Please can any one share how this can be done. 
 
Current Environment:

ARS 7.1 Patch 1
CMDB 2.1 Patch 2 
7.0.3 Asset Management Patch 7 
 

Regards, 

Prashanth Bhagawat 


 


This e-mail and any attachment is for authorised use by the intended 
recipient(s) only. It may contain proprietary material, confidential 
information and/or be subject to legal privilege. It should not be copied, 
disclosed to, retained or used by, any other party. If you are not an intended 
recipient then please promptly delete this e-mail and any attachment and all 
copies and inform the sender. Thank you.


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Remedy SSO Implementation - Help needed

[Thivagar Sankaran]

Hi List,

 

I am into the process of implementing SSO. I have the architecture as below:


ARS 6.3 
Windows Server 2003 
Web Server - Sun Apps Server

Mid Tier 6.3

I wanted to create a custom SSO. When I read into the white paper from
remedy, they have asked to create a java file. I created a java file called
AreaLdapAuthenticator from the sample they attached. I experience some
problems while compiling the AreaLdapAuthenticator.java file.

I execute the following command -

javac -classpath "C:\Sun\AppServer\lib\j2ee.jar" AreaLdapAuthenticator.java

And get the following errors -

C:\Documents and Settings\Administrator\Desktop>javac
AreaLdapAuthenticator.java

AreaLdapAuthenticator.java:11: package com.remedy.arsys.session does not
exist
import com.remedy.arsys.session.Authenticator;
^
AreaLdapAuthenticator.java:12: package com.remedy.arsys.session does not
exist
import com.remedy.arsys.session.UserCredentials;
^
AreaLdapAuthenticator.java:14: cannot resolve symbol
symbol  : class Authenticator
location: class com.naviline.ssoAreaLdap.AreaLdapAuthenticator
public class AreaLdapAuthenticator implements Authenticator {
  ^
AreaLdapAuthenticator.java:23: cannot resolve symbol
symbol  : class UserCredentials
location: class com.naviline.ssoAreaLdap.AreaLdapAuthenticator
public UserCredentials
getAuthenticatedCredentials(HttpServletRequest request, HttpServletResponse
response) throws IOException {
   ^
AreaLdapAuthenticator.java:47: cannot resolve symbol
symbol  : class UserCredentials
location: class com.naviline.ssoAreaLdap.AreaLdapAuthenticator
return new UserCredentials(user,"recipe",null);
   ^
5 errors

Did I miss something in class path? Please help me to sort this out.

Thanks & Regards,
Thivagar Sankaran
Remedy Team

 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"


smime.p7s
Description: S/MIME cryptographic signature

Re: LDAP arplugin failure problem

[Heider, Stephen]

Maria,

 

Another option to get around the LDAP query limitation is to create a
single SQL View comprised of multiple SELECTs that are UNIONed together.
You can then query this view and retrieve all LDAP entries.

 

See the email from January 9 entitled "Re: LDAP Question".  There is a
script attached that can be used to create the SQL View.

 

Stephen

Remedy Skilled Professional

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Thomas Bean
Sent: Thursday, March 06, 2008 7:20 PM
To: arslist@ARSLIST.ORG
Subject: Re: LDAP arplugin failure problem

 

Hi Maria,

I would guess that your LDAP server has an entry count limit on the
number of records that can be returned by a search.  This is fairly
common -- usually LDAP servers are set to an entry count limit of 1 or 2
thousand records.  If the LDAP admin is unwilling or unable to alter
this setting, you might try breaking it up into multiple escalations
that search for the users in manageable chunks (e.g., all users with
user names starting with "A", then "B", then "C", etc.).  Each letter of
the alphabet would have to return fewer entries than the LDAP entry
count limit, of course.  That would a whopping 26 escalations instead of
one, but it might work, depending upon how many users you have in LDAP.

 

If you can go another route, I have found that it is much easier to set
up this kind of import using a view form to an external database rather
than an vendor form using the ARDBC LDAP plugin.

 

--Thomas

 

- Original Message - 

From: Maria C Delagarza
  

Newsgroups: gmane.comp.crm.arsystem.general

To: arslist@ARSLIST.ORG 

Sent: Thursday, March 06, 2008 1:07 PM

Subject: LDAP arplugin failure problem

 

** 

Hi Listers,

 

I am appealing to people smarter than myself.  I currently am
having an issue with an LDAP import.  Here is the scenario:

 

We are connected to the LDAP and can run queries on the Vendor
Form that return the record we want to see.  However, when we run the
same query through a filter escalation the arplugin fails and does not
give an error messageit fails around 50K records or so.  Any
thoughts?

 

We are running ARS 7.1 Patch 006

MS SQL 2005

Windows Server 2003

 

Any help is much appreciated, we are trying to get to a pilot on
Monday and this problem is preventing our CTM:People population.

 

 

Thanks.

 

MCD

Maria C Delagarza

AR System Specialist

Eluri Designs

eluridesign.com

[EMAIL PROTECTED]

 

 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the
Answers Are" html___ 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Incoming Emails

[John Kovalcik]

Listers,

Does anyone know how to re-parse and incoming email ?   If the 
incoming email has an error and you want to re-parse it after the error is 
corrected, how do you do it ?


  Thanks,
John M. Kovalcik
Service Management Sr. Analyst
   ITIL Foundations Certified
Global Information Technology
Kennametal Inc.


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Remedy custom SSO Implementation - Help needed

[remprof]

Hi List,

 

I am into the process of implementing SSO. I have the architecture as below: 

ARS 6.3 
Windows Server 2003 
Web Server – Sun Apps Server

Mid Tier 6.3

I wanted to create a custom SSO. When I read into the white paper from
remedy, they have asked to create a java file. I created a java file called
AreaLdapAuthenticator from the sample they attached. I experience some
problems while compiling the AreaLdapAuthenticator.java file.

I execute the following command -

javac -classpath "C:\Sun\AppServer\lib\j2ee.jar" AreaLdapAuthenticator.java

And get the following errors -

C:\Documents and Settings\Administrator\Desktop>javac
AreaLdapAuthenticator.java

AreaLdapAuthenticator.java:11: package com.remedy.arsys.session does not
exist
import com.remedy.arsys.session.Authenticator;
^
AreaLdapAuthenticator.java:12: package com.remedy.arsys.session does not
exist
import com.remedy.arsys.session.UserCredentials;
^
AreaLdapAuthenticator.java:14: cannot resolve symbol
symbol  : class Authenticator
location: class com.naviline.ssoAreaLdap.AreaLdapAuthenticator
public class AreaLdapAuthenticator implements Authenticator {
  ^
AreaLdapAuthenticator.java:23: cannot resolve symbol
symbol  : class UserCredentials
location: class com.naviline.ssoAreaLdap.AreaLdapAuthenticator
public UserCredentials
getAuthenticatedCredentials(HttpServletRequest request, HttpServletResponse
response) throws IOException {
   ^
AreaLdapAuthenticator.java:47: cannot resolve symbol
symbol  : class UserCredentials
location: class com.naviline.ssoAreaLdap.AreaLdapAuthenticator
return new UserCredentials(user,"recipe",null);
   ^
5 errors

Did I miss something in class path? Please help me to sort this out.

Thanks & Regards,
Thivagar Sankaran
Remedy Team
-- 
View this message in context: 
http://www.nabble.com/Remedy-custom-SSO-Implementation---Help-needed-tp15891208p15891208.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Output of field contents to file via a filter action

[Heider, Stephen]

Fred,

 

That's cool.  I did not know that about that part of the Notify command.
For reference, in ARS 6.3, the BasicGuide-630.pdf describes it on page
524.

 

In my testing this morning I am not sure if I can use it here.  I see
three challenges to overcome:

 

1.  The first 8 lines and the last 3 need to be removed from the
file. This is extra text inserted by the Notify command.

a.  The application or process that ultimately receives the
file will need to remove these extra lines.

 

2.  Each time the Notify command is run it appends to the existing
file.

a.  After each run the file needs to be deleted or renamed.

 

3.  The filename is not unique.  For example, "notify4.arn".  This
prevents multiple simultaneous users from running this command.  Even
though you can have up to 80 different file names (notify4.arn through
notify83.arn) there is no guarantee that two users will not run the
process that creates these files at the same time.

a.  An indirect work-around is to create a queue for these
command whereby only one command is run at one time.

 

Since this a new command for me, are there any work-arounds for these
items?  Items 2 and 3 could have been dealt with if ARS allowed for
custom (unique) filenames.

 

 

Stephen

Remedy Skilled Professional

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Thursday, March 06, 2008 9:28 PM
To: arslist@ARSLIST.ORG
Subject: Re: Output of field contents to file via a filter action

 

An easier way to do it would be to use the Notify action.  Change the
Mechanism field to Other and put a number (4 and above) in the Other
Code.  This will create a file on your server.  The Other mechanism is
documented in the Workflow Objects manual (pg 76 for 7.0.x)

 

Fred  

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: Thursday, March 06, 2008 2:52 PM
To: arslist@ARSLIST.ORG
Subject: Re: Output of field contents to file via a filter action

Mike,

 

Here is one option (there are probably many).

 

Since you are on Windows create a small .Net console app with the .Net
ARS API that retrieves the email contents by querying the form, then
creates a text file of the contents of the email, then attaches the file
to an Attachment Field in Remedy.

 

Your filters would first determine the length of the email, and then
only call the console app when it is greater than a certain number.
When you call the console app you would pass in the $1$ value so it
knows which record to work with.

 

 

Afterwards, if you wanted to take this concept further you could design
the console app to work with any form, and field, and any attachment
field.  You could then use this with other forms.

 

Stephen

Remedy Skilled Professional

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mike Balogh
Sent: Thursday, March 06, 2008 3:28 PM
To: arslist@ARSLIST.ORG
Subject: Output of field contents to file via a filter action

 

Hi everyone -

 

I'm attempting to output the contents of a large character field to a
file via a filter action.  I must use a filter because this process will
be used for processing emails coming in to our server.  Above a certain
size I want to output the email body to a file and then attach that file
to a Helpdesk ticket.  I've tried using the following via as a Run
Process command:

 

%ComSpec% /C Echo $FieldValue$ >> c:\file.txt

 

This works great until the field has a carriage return in the value.
Once a carriage return is introduced into the field, the process fails
completely and the file is not created at all.  Unfortunately, virtually
every time we use this process, the field value is going to have
potentially thousands of carriage returns in it.  I've tried various
combinations with the /A and /S switches as well as putting
double-quotes around the $FieldValue$.  Anyone have any other
suggestions or a completely different way I could try to do this?

 

Windows Server 2003 Enterprise

MS SQL 2005

ARS 7.0.01 p2

 

Thanks in advance!

~Mike

 

---

Michael J Balogh

Wingspan Systems Inc.

[EMAIL PROTECTED]  

 

 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Output of field contents to file via a filter action

[Carey Matthew Black]

Stephen,

I am certain that the design intent was that there would be a process
that parses the file and does the right thing with what it finds in
the file. So #2 and #3 are totally by design. Also the process was
envisioned as a standing "server" process and not something that is
invoked over and over again. But I guess you could do that too. You
just have to manage the "high water mark" for the entries that you
have already processed between invocations.

If you need to pass data to the process that is monitoring the file
then the value needs to be a field that is written to the entry in the
file. The process parses the entry and does what it needs to do from
there.


If my vague memory is correct, I would be careful about
altering/renaming/moving the file while the ARS server is running. You
may find that multiple users are writing to the file and that there
are some "bad times" to alter the file. Also the ARS server may be
confused by the files length changing or disappearing out from
underneath it too. ( I seem to remember issues like that from when I
played with this many years ago. But my memory might be poor about the
details from that long ago. Do some testing at least.)

The thing that I do not like about the approach is that it builds in a
queue. (and thus a likely delay in the process) If what you need is
"in line processing" then look toward the Filter Plugin. If the queue
effect it desired and/or helpful then the Notify-Other model may work
well for you too.

HTH.

-- 
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.


On Fri, Mar 7, 2008 at 7:53 AM, Heider, Stephen <[EMAIL PROTECTED]> wrote:
> **
>
>
>
> Fred,
>
>
>
> That's cool.  I did not know that about that part of the Notify command.
> For reference, in ARS 6.3, the BasicGuide-630.pdf describes it on page 524.
>
>
>
> In my testing this morning I am not sure if I can use it here.  I see three
> challenges to overcome:
>
>
>
> The first 8 lines and the last 3 need to be removed from the file. This is
> extra text inserted by the Notify command.
>
> The application or process that ultimately receives the file will need to
> remove these extra lines.
>
>
>
> Each time the Notify command is run it appends to the existing file.
>
> After each run the file needs to be deleted or renamed.
>
>
>
> The filename is not unique.  For example, "notify4.arn".  This prevents
> multiple simultaneous users from running this command.  Even though you can
> have up to 80 different file names (notify4.arn through notify83.arn) there
> is no guarantee that two users will not run the process that creates these
> files at the same time.
>
> An indirect work-around is to create a queue for these command whereby only
> one command is run at one time.
>
>
>
> Since this a new command for me, are there any work-arounds for these items?
> Items 2 and 3 could have been dealt with if ARS allowed for custom (unique)
> filenames.
>
>
> Stephen
> Remedy Skilled Professional

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Output of field contents to file via a filter action

[Heider, Stephen]

Carey,

Precisely. Thanks for the confirmation.

I don't think I can make use of this command for the purpose of creating
a file from the contents of an ARS field.

Stephen
Remedy Skilled Professional

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black
Sent: Friday, March 07, 2008 8:42 AM
To: arslist@ARSLIST.ORG
Subject: Re: Output of field contents to file via a filter action

Stephen,

I am certain that the design intent was that there would be a process
that parses the file and does the right thing with what it finds in
the file. So #2 and #3 are totally by design. Also the process was
envisioned as a standing "server" process and not something that is
invoked over and over again. But I guess you could do that too. You
just have to manage the "high water mark" for the entries that you
have already processed between invocations.

If you need to pass data to the process that is monitoring the file
then the value needs to be a field that is written to the entry in the
file. The process parses the entry and does what it needs to do from
there.


If my vague memory is correct, I would be careful about
altering/renaming/moving the file while the ARS server is running. You
may find that multiple users are writing to the file and that there
are some "bad times" to alter the file. Also the ARS server may be
confused by the files length changing or disappearing out from
underneath it too. ( I seem to remember issues like that from when I
played with this many years ago. But my memory might be poor about the
details from that long ago. Do some testing at least.)

The thing that I do not like about the approach is that it builds in a
queue. (and thus a likely delay in the process) If what you need is
"in line processing" then look toward the Filter Plugin. If the queue
effect it desired and/or helpful then the Notify-Other model may work
well for you too.

HTH.

-- 
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.


On Fri, Mar 7, 2008 at 7:53 AM, Heider, Stephen <[EMAIL PROTECTED]>
wrote:
> **
>
>
>
> Fred,
>
>
>
> That's cool.  I did not know that about that part of the Notify
command.
> For reference, in ARS 6.3, the BasicGuide-630.pdf describes it on page
524.
>
>
>
> In my testing this morning I am not sure if I can use it here.  I see
three
> challenges to overcome:
>
>
>
> The first 8 lines and the last 3 need to be removed from the file.
This is
> extra text inserted by the Notify command.
>
> The application or process that ultimately receives the file will need
to
> remove these extra lines.
>
>
>
> Each time the Notify command is run it appends to the existing file.
>
> After each run the file needs to be deleted or renamed.
>
>
>
> The filename is not unique.  For example, "notify4.arn".  This
prevents
> multiple simultaneous users from running this command.  Even though
you can
> have up to 80 different file names (notify4.arn through notify83.arn)
there
> is no guarantee that two users will not run the process that creates
these
> files at the same time.
>
> An indirect work-around is to create a queue for these command whereby
only
> one command is run at one time.
>
>
>
> Since this a new command for me, are there any work-arounds for these
items?
> Items 2 and 3 could have been dealt with if ARS allowed for custom
(unique)
> filenames.
>
>
> Stephen
> Remedy Skilled Professional


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: LDAP arplugin failure problem

[Maria C Delagarza]

Thanks for the great advice!  I knew I could count on smart people J As it
turned out we did not have enough qualifications in the Vendor form table
properties.  When we limited the table properties to A-E etc as some of you
suggested we were able to retrieve all of the records in 5 escalations.
Many thanks!

 

MCD

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: Friday, March 07, 2008 6:31 AM
To: arslist@ARSLIST.ORG
Subject: Re: LDAP arplugin failure problem

 

** 

Maria,

 

Another option to get around the LDAP query limitation is to create a single
SQL View comprised of multiple SELECTs that are UNIONed together.  You can
then query this view and retrieve all LDAP entries.

 

See the email from January 9 entitled "Re: LDAP Question".  There is a
script attached that can be used to create the SQL View.

 

Stephen

Remedy Skilled Professional

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Thomas Bean
Sent: Thursday, March 06, 2008 7:20 PM
To: arslist@ARSLIST.ORG
Subject: Re: LDAP arplugin failure problem

 

Hi Maria,

I would guess that your LDAP server has an entry count limit on the number
of records that can be returned by a search.  This is fairly common --
usually LDAP servers are set to an entry count limit of 1 or 2 thousand
records.  If the LDAP admin is unwilling or unable to alter this setting,
you might try breaking it up into multiple escalations that search for the
users in manageable chunks (e.g., all users with user names starting with
"A", then "B", then "C", etc.).  Each letter of the alphabet would have to
return fewer entries than the LDAP entry count limit, of course.  That would
a whopping 26 escalations instead of one, but it might work, depending upon
how many users you have in LDAP.

 

If you can go another route, I have found that it is much easier to set up
this kind of import using a view form to an external database rather than an
vendor form using the ARDBC LDAP plugin.

 

--Thomas

 

- Original Message - 

From: Maria C Delagarza   

Newsgroups: gmane.comp.crm.arsystem.general

To: arslist@ARSLIST.ORG 

Sent: Thursday, March 06, 2008 1:07 PM

Subject: LDAP arplugin failure problem

 

** 

Hi Listers,

 

I am appealing to people smarter than myself.  I currently am having an
issue with an LDAP import.  Here is the scenario:

 

We are connected to the LDAP and can run queries on the Vendor Form that
return the record we want to see.  However, when we run the same query
through a filter escalation the arplugin fails and does not give an error
message..it fails around 50K records or so.  Any thoughts?

 

We are running ARS 7.1 Patch 006

MS SQL 2005

Windows Server 2003

 

Any help is much appreciated, we are trying to get to a pilot on Monday and
this problem is preventing our CTM:People population.

 

 

Thanks.

 

MCD

Maria C Delagarza

AR System Specialist

Eluri Designs

eluridesign.com

[EMAIL PROTECTED]

 

 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers
Are" html___


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Remove duplicate email address from a String

[Darshana Jivan [MTN Network Solutions]]

Hi,

 

Please can someone assist me with the following.

 

I want to remove duplicate email addresses in a string. I cannot create
a view with the distinct values as I need the unique id's of the record
therefore the only option I do have is to try and remove duplicate
occurrences after the 1st occurrence of an email address.

 

This is the following process that I am using but I know that the last
set fields with the replace function is not doing what I require it to
do and there is where I need some assistance.

 

I have a AL that fetches and email address and concatenates it to a
string in a loop.

SQL Command: SELECT CONTACT_EMAIL FROM [EMAIL PROTECTED] WHERE
CONTACT_ID = '$Col_C_ContactID$'

Set Fields 1: Email

$1$

Set Fields 2: MTNNS_primary_client_contact_email

($MTNNS_primary_client_contact_email$ +  ",") + $Email$

 

I then have another AL that does the following when it finds a match of
an email address in the string 'MTNNS_primary_client_contact_email'

Set Fields 1: Val1

STRSTR($MTNNS_primary_client_contact_email$, $Email$)

Set Fields 2: Val2

LENGTH($Email$)

Set Fields 3:

REPLACE($MTNNS_primary_client_contact_email$,
SUBSTR($MTNNS_primary_client_contact_email$, $Val1$, $Val2$),  "")

 

In essence if I have a table with the following email addresses and when
its looped through the string or the value I am looking for is
[EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] the duplicate
occurrence should be extracted from the string.

 

[EMAIL PROTECTED]

[EMAIL PROTECTED]

[EMAIL PROTECTED]

[EMAIL PROTECTED]
[EMAIL PROTECTED]

 

 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Change Templates ITSM7

[T. Dee]

Don - on the Change Template there is the field "Notes", which will
populate "Notes" on the Change Form - will this be sufficient for
their request?

Ty


On Thu, Mar 6, 2008 at 12:28 PM, Don Simmons <[EMAIL PROTECTED]> wrote:
> **
> Has anyone attempted to or been requested to add Work Info information to
> Change templates in ITSM 7.
>
> Don
>
> 
> Peek-a-boo FREE Tricks & Treats for You! Get 'em!__Platinum Sponsor:
> www.rmsportal.com ARSlist: "Where the Answers Are" html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Remove duplicate email address from a String

[Frank Caruso]

Why don't you try checking for the occurrence of the new email address
in the string BEFORE you concatenate it. If you find the email address
is already in your string then do not add it and move to the next
record in your table.

On Fri, Mar 7, 2008 at 9:34 AM, Darshana Jivan [MTN Network Solutions]
<[EMAIL PROTECTED]> wrote:
> **
>
>
>
> Hi,
>
>
>
> Please can someone assist me with the following.
>
>
>
> I want to remove duplicate email addresses in a string. I cannot create a
> view with the distinct values as I need the unique id's of the record
> therefore the only option I do have is to try and remove duplicate
> occurrences after the 1st occurrence of an email address.
>
>
>
> This is the following process that I am using but I know that the last set
> fields with the replace function is not doing what I require it to do and
> there is where I need some assistance.
>
>
>
> I have a AL that fetches and email address and concatenates it to a string
> in a loop.
>
> SQL Command: SELECT CONTACT_EMAIL FROM [EMAIL PROTECTED] WHERE  CONTACT_ID
> = '$Col_C_ContactID$'
>
> Set Fields 1: Email
>
> $1$
>
> Set Fields 2: MTNNS_primary_client_contact_email
>
> ($MTNNS_primary_client_contact_email$ +  ",") + $Email$
>
>
>
> I then have another AL that does the following when it finds a match of an
> email address in the string 'MTNNS_primary_client_contact_email'
>
> Set Fields 1: Val1
>
> STRSTR($MTNNS_primary_client_contact_email$, $Email$)
>
> Set Fields 2: Val2
>
> LENGTH($Email$)
>
> Set Fields 3:
>
> REPLACE($MTNNS_primary_client_contact_email$,
> SUBSTR($MTNNS_primary_client_contact_email$, $Val1$, $Val2$),  "")
>
>
>
> In essence if I have a table with the following email addresses and when its
> looped through the string or the value I am looking for is [EMAIL PROTECTED],
> [EMAIL PROTECTED], [EMAIL PROTECTED] the duplicate occurrence should be
> extracted from the string.
>
>
>
> [EMAIL PROTECTED]
>
> [EMAIL PROTECTED]
>
> [EMAIL PROTECTED]
>
> [EMAIL PROTECTED]
>  [EMAIL PROTECTED]
>
>
>
>   __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Change Templates ITSM7

[Don Simmons]

No that would not work.  They don't want to use Task.  The want the get the 
Install Plan, etc. with attachments to be part of the templates.  They have 
documents that are reused for hundreds of servers where the same change is 
being made multiple times.> Date: Fri, 7 Mar 2008 09:36:23 -0500> From: [EMAIL 
PROTECTED]> Subject: Re: Change Templates ITSM7> To: arslist@ARSLIST.ORG> > Don 
- on the Change Template there is the field "Notes", which will> populate 
"Notes" on the Change Form - will this be sufficient for> their request?> > Ty> 
> > On Thu, Mar 6, 2008 at 12:28 PM, Don Simmons <[EMAIL PROTECTED]> wrote:> > 
**> > Has anyone attempted to or been requested to add Work Info information 
to> > Change templates in ITSM 7.> >> > Don> >> > 
> > Peek-a-boo FREE Tricks & Treats for You! 
Get 'em!__Platinum Sponsor:> > www.rmsportal.com ARSlist: "Where the Answers 
Are" html___> > 
___>
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org> Platinum Sponsor: 
www.rmsportal.com ARSlist: "Where the Answers Are"
_
Do more with your photos with Windows Live Photo Gallery.
http://www.windowslive.com/share.html?ocid=TXT_TAGLM_Wave2_photos_022008
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

For anyone using the aradmin.exe command

[Scott Philben]

We found out an interesting bit of information yesterday about the command line 
uasge of the aradmin.exe command. On page 557 of the 6.3 Advanced book Remedy 
claims the following:


To parse an XML packing list, and export all the objects defined in that 
packing list, use the following command format:

aradmin -u  [-p ] -x  -e  -l 



Well, when we tried to use that command to dump out a packing list worth of 
stuff nothing seemed to happen. So I opened an Incident with BMC and come to 
find out that the XML packing list thing does not appear to work in any 
environment that they can find. I think this is kind of odd since I believe 
that this option has been available since at least 5.1.2. I might be wrong. 

So anyway, don't try to dump stuff out of your system via an XML packing list 
file (not that you wanted to anyway since I can't find any reference of anyone 
else in history having the same problem and posting about it on the interwebs).

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Find a field by ID

[SUBSCRIBE arslist Melissa]

This may be a silly question, but how can I find a field by the ID number 
if it's not in the view?  Looking for a field on HPD:HelpDesk by the Field 
ID and it's not in the FindID drop down.

Thanks!
Melissa

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Remove duplicate email address from a String

[Opela, Gary L Contr OC-ALC/ITMA]

Darshana,

You are doing about what I was going to suggest whenever I read your
original post.

I was thinking something like the following though:

Lets say that $MTNNS$ contains the following:

[EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED],

Step 1:
Set Fields:
tmpEmail = SUBSTR($MTNNS$, 0, (STRSTR($MTNNS$, ",")-1))  


Step 2:
If NOT('MTNNS' LIKE ("%" + $tmpEmail$ + "%"))
Set Fields:
'tmpFullEmailString' = $tmpFullEmailString$ + "," +
$tmpEmail$
ELSE:
Set Fields:
'tmpEmail' = $NULL$

Step 3:
Set Fields
'MTNNS' = (SUBSTR($MTNNS$, (STRSTR($MTNNS$, ",") + 1)))

Step 4:
Loop until $MTNNS$ is empty or just a ",".

What this should do:

First Iteration:

Step 1: Set tmpEmail = [EMAIL PROTECTED]
Step 2: ELSE: Set tmpEmail = $NULL$ because MTNNS contains $tmpEmail$
Step 3: Set MTNNS = [EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED],
LOOP because MTNNS is not "" or ","

Second Iteration

Step 1: Set tmpEmail = [EMAIL PROTECTED]
Step 2: Set 'tmpFullEmailString' = $NULL$ + [EMAIL PROTECTED]
Step 3: Set MTNNS = [EMAIL PROTECTED], [EMAIL PROTECTED],
LOOP because MTNNS is not "" or ","

Third Iteration

Step 1: Set tmpEmail = [EMAIL PROTECTED]
Step 2: Set 'tmpFullEmailString' = [EMAIL PROTECTED],
[EMAIL PROTECTED]
Step 3: Set MTNNS = [EMAIL PROTECTED],
LOOP because MTNNS is not "" or ","

Fourth Iteration

Step 1: Set tmpEmail = [EMAIL PROTECTED]
Step 2: Set 'tmpFullEmailString' = [EMAIL PROTECTED],
[EMAIL PROTECTED], [EMAIL PROTECTED]
Step 3: set MTNNS = ""
Step 4: EXIT because MTNNS = ""

I think this should work for you. You are chopping off the first
occurrence of the email address instead of all subsequent ones, I hope
that's not a problem.

Thanks,


Gary Opela, Jr

Sr. Remedy Developer

Leader Communications, Inc.

405 736 3211


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Darshana Jivan [MTN Network
Solutions]
Sent: Friday, March 07, 2008 8:34 AM
To: arslist@ARSLIST.ORG
Subject: Remove duplicate email address from a String

** 

Hi,

 

Please can someone assist me with the following.

 

I want to remove duplicate email addresses in a string. I cannot create
a view with the distinct values as I need the unique id's of the record
therefore the only option I do have is to try and remove duplicate
occurrences after the 1st occurrence of an email address.

 

This is the following process that I am using but I know that the last
set fields with the replace function is not doing what I require it to
do and there is where I need some assistance.

 

I have a AL that fetches and email address and concatenates it to a
string in a loop.

SQL Command: SELECT CONTACT_EMAIL FROM [EMAIL PROTECTED] WHERE
CONTACT_ID = '$Col_C_ContactID$'

Set Fields 1: Email

$1$

Set Fields 2: MTNNS_primary_client_contact_email

($MTNNS_primary_client_contact_email$ +  ",") + $Email$

 

I then have another AL that does the following when it finds a match of
an email address in the string 'MTNNS_primary_client_contact_email'

Set Fields 1: Val1

STRSTR($MTNNS_primary_client_contact_email$, $Email$)

Set Fields 2: Val2

LENGTH($Email$)

Set Fields 3:

REPLACE($MTNNS_primary_client_contact_email$,
SUBSTR($MTNNS_primary_client_contact_email$, $Val1$, $Val2$),  "")

 

In essence if I have a table with the following email addresses and when
its looped through the string or the value I am looking for is
[EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] the duplicate
occurrence should be extracted from the string.

 

[EMAIL PROTECTED]

[EMAIL PROTECTED]

[EMAIL PROTECTED]

[EMAIL PROTECTED]
[EMAIL PROTECTED]

 

 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Find a field by ID

[Seth Wrye]

Check the admin view... Form -> Select a View in the admin tool.
 
Seth Wrye



From: Action Request System discussion list(ARSList) on behalf of SUBSCRIBE 
arslist Melissa
Sent: Fri 3/7/2008 10:04 AM
To: arslist@ARSLIST.ORG
Subject: Find a field by ID


** 
This may be a silly question, but how can I find a field by the ID number if 
it's not in the view?  Looking for a field on HPD:HelpDesk by the Field ID and 
it's not in the FindID drop down. 

Thanks! 
Melissa __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Find a field by ID

[Ben Cantatore]

Melissa,

Just do the following:

Go into the form you want to find the field on
Select Form\current view\fields in view  from the menu
Highlight all the fields on the left and then click add this will push 
them all to the right side
Click ok
You'll have a mess in the upper left hand corner of the screen, use the 
find field or ID drop downs at the top to find the field you need.
Click Field properties after you've selected the field you need and look 
up the name
DON'T Save the form, exit and close without saving
Go back into the form and follow steps 1 and 2 and then push over only the 
field name that you've identified from step 6

Hope that helps.

Ben Cantatore
Remedy Administrator
Avon
(914) 935-2946



SUBSCRIBE arslist Melissa <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" 

03/07/2008 10:04 AM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Find a field by ID






** 
This may be a silly question, but how can I find a field by the ID number 
if it's not in the view?  Looking for a field on HPD:HelpDesk by the Field 
ID and it's not in the FindID drop down. 

Thanks! 
Melissa __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers 
Are" html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Find a field by ID

[Gidd]

Melissa,
 
Try this FREE utility from David Sanders' website:
 
http://www.westoverconsulting.co.uk/utilities.html
 
Form and Field Property Viewer
 
Allows you to view database table names and field IDs from within the User
tool
 
HTH
 
 
Regards...Gidd
 
 

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of SUBSCRIBE arslist Melissa
Sent: Friday, March 07, 2008 7:04 AM
To: arslist@ARSLIST.ORG
Subject: Find a field by ID


** 
This may be a silly question, but how can I find a field by the ID number if
it's not in the view?  Looking for a field on HPD:HelpDesk by the Field ID
and it's not in the FindID drop down. 

Thanks! 
Melissa __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers
Are" html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Find a field by ID

[Mary Dollus]

Hi Melissa,

I sort of do the same thing as Ben with one exception.  I do a new view and 
pull all the fields into it.  That way if something inadvertently crashes or 
messes up, I don't have to worry about it affecting the main form.

Take care,
Mary Dollus
generationE Technologies


From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Ben Cantatore
Sent: Friday, March 07, 2008 9:17 AM
To: arslist@ARSLIST.ORG
Subject: Re: Find a field by ID

**
Melissa,

Just do the following:

 1.  Go into the form you want to find the field on

 1.  Select Form\current view\fields in view  from the menu

 1.  Highlight all the fields on the left and then click add this will push 
them all to the right side

 1.  Click ok

 1.  You'll have a mess in the upper left hand corner of the screen, use the 
find field or ID drop downs at the top to find the field you need.

 1.  Click Field properties after you've selected the field you need and look 
up the name

 1.  DON'T Save the form, exit and close without saving

 1.  Go back into the form and follow steps 1 and 2 and then push over only the 
field name that you've identified from step 6

Hope that helps.

Ben Cantatore
Remedy Administrator
Avon
(914) 935-2946

SUBSCRIBE arslist Melissa <[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)" 

03/07/2008 10:04 AM
Please respond to
arslist@ARSLIST.ORG


To

arslist@ARSLIST.ORG

cc



Subject

Find a field by ID










**
This may be a silly question, but how can I find a field by the ID number if 
it's not in the view?  Looking for a field on HPD:HelpDesk by the Field ID and 
it's not in the FindID drop down.

Thanks!
Melissa __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Conversion between Character fields and Date fields

[Jerry Niman]

Roy,

Thanks, but I already have a work-round - I am looking for support to encourage 
BMC to
provide the functionality as native.

Jerry

Jerry NimanTel+44 (0)161-247 1474
Head of Information and Communication Technology Services Email 
[EMAIL PROTECTED]
the Manchester Metropolitan University Mobile +44 (0)7770 638104

Before acting on this email or opening any attachments you should read the 
Manchester
Metropolitan University’s email disclaimer available on its website
http://www.mmu.ac.uk/emaildisclaimer

>>> "Roy Stark" <[EMAIL PROTECTED]> 07 Mar 08 14:50 >>>
Hi Jerry,

Is it possible to use an external app to do this for you.

Kind regards,
  
Roy Stark
Account Manager
Master Place Ltd
Tel:+44 (0)29 2019-5299
Mobile: +44 (0)773 420-6952
Web:http://www.master-place.co.uk  
Any view or opinions expressed are those of the author and do not
necessarily reflect those of Master Place Ltd. This message contains
information which is confidential and is intended solely for the use of
the individual or entity to which this is addressed and is subject to
legal privilege. If you are not the intended recipient, you may not
peruse, use, disseminate, distribute or copy this message. If you have
received this message in error, please notify the sender immediately by
email, facsimile or telephone and return or destroy the original
message. All outgoing messages are scanned by Trend Anti Virus.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

7.1 Java api

[Axton]

Has anyone implemented mid-tier 7.1 or other j2ee apps based on the
7.1 java api in a load balanced environment?  If so, can you comment
on your successes/issues without using persistent sessions on the load
balancer?

Thanks,
Axton Grams

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Find a field by ID

[Ben Cantatore]

Mary, good suggestion.

Ben Cantatore
Remedy Administrator
Avon
(914) 935-2946



Mary Dollus <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" 

03/07/2008 10:32 AM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Re: Find a field by ID






** 
Hi Melissa,
 
I sort of do the same thing as Ben with one exception.  I do a new view 
and pull all the fields into it.  That way if something inadvertently 
crashes or messes up, I don?t have to worry about it affecting the main 
form. 
 
Take care,
Mary Dollus
generationE Technologies
 

From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of Ben Cantatore
Sent: Friday, March 07, 2008 9:17 AM
To: arslist@ARSLIST.ORG
Subject: Re: Find a field by ID
 
** 
Melissa, 

Just do the following: 
1.  Go into the form you want to find the field on 
2.  Select Form\current view\fields in view  from the menu 
3.  Highlight all the fields on the left and then click add this will 
push them all to the right side 
4.  Click ok 
5.  You'll have a mess in the upper left hand corner of the screen, 
use the find field or ID drop downs at the top to find the field you need. 

6.  Click Field properties after you've selected the field you need 
and look up the name 
7.  DON'T Save the form, exit and close without saving 
8.  Go back into the form and follow steps 1 and 2 and then push over 
only the field name that you've identified from step 6

Hope that helps. 

Ben Cantatore
Remedy Administrator
Avon
(914) 935-2946 


SUBSCRIBE arslist Melissa <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" 
 
03/07/2008 10:04 AM 


Please respond to
arslist@ARSLIST.ORG



To
arslist@ARSLIST.ORG 
cc
 
Subject
Find a field by ID
 


 
 




** 
This may be a silly question, but how can I find a field by the ID number 
if it's not in the view?  Looking for a field on HPD:HelpDesk by the Field 
ID and it's not in the FindID drop down. 

Thanks! 
Melissa __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers 
Are" html___ 
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Find a field by ID

[Seth Wrye]

Melissa,
I would avoid the two suggestions because of the implications involved with the 
"what if's".  Since the form you are searching on (HPD:HelpDesk) is an OOTB 
form, all OOTB fields will be listed in the Administrator view.  From there you 
can add the field to another view, but I would be weary of problems caused by 
inadvertently hitting save or creating performance issues by creating another 
view.  
 
Seth Wrye



From: Action Request System discussion list(ARSList) on behalf of Mary Dollus
Sent: Fri 3/7/2008 10:32 AM
To: arslist@ARSLIST.ORG
Subject: Re: Find a field by ID


** 

Hi Melissa,

 

I sort of do the same thing as Ben with one exception.  I do a new view and 
pull all the fields into it.  That way if something inadvertently crashes or 
messes up, I don't have to worry about it affecting the main form. 

 

Take care,

Mary Dollus

generationE Technologies

 



From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Ben Cantatore
Sent: Friday, March 07, 2008 9:17 AM
To: arslist@ARSLIST.ORG
Subject: Re: Find a field by ID

 

** 
Melissa, 

Just do the following: 

1.  Go into the form you want to find the field on 

2.  Select Form\current view\fields in view  from the menu 

3.  Highlight all the fields on the left and then click add this will push 
them all to the right side 

4.  Click ok 

5.  You'll have a mess in the upper left hand corner of the screen, use the 
find field or ID drop downs at the top to find the field you need. 

6.  Click Field properties after you've selected the field you need and 
look up the name 

7.  DON'T Save the form, exit and close without saving 

8.  Go back into the form and follow steps 1 and 2 and then push over only 
the field name that you've identified from step 6 


Hope that helps. 

Ben Cantatore
Remedy Administrator
Avon
(914) 935-2946 



SUBSCRIBE arslist Melissa <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)"  

03/07/2008 10:04 AM 

Please respond to
arslist@ARSLIST.ORG

To

arslist@ARSLIST.ORG 

cc

 

Subject

Find a field by ID

 

 

 




** 
This may be a silly question, but how can I find a field by the ID number if 
it's not in the view?  Looking for a field on HPD:HelpDesk by the Field ID and 
it's not in the FindID drop down. 

Thanks! 
Melissa __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___ 
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Find a field by ID

[Seth Wrye]

Ahh, I miss arstruct.
 
Seth Wrye



From: Action Request System discussion list(ARSList) on behalf of Gidd
Sent: Fri 3/7/2008 10:28 AM
To: arslist@ARSLIST.ORG
Subject: Re: Find a field by ID


** 
Melissa,
 
Try this FREE utility from David Sanders' website:
 
http://www.westoverconsulting.co.uk/utilities.html
 
Form and Field Property Viewer
 
Allows you to view database table names and field IDs from within the User tool
 
HTH
 
 
Regards...Gidd
 
 



From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of SUBSCRIBE arslist Melissa
Sent: Friday, March 07, 2008 7:04 AM
To: arslist@ARSLIST.ORG
Subject: Find a field by ID


** 
This may be a silly question, but how can I find a field by the ID number if 
it's not in the view?  Looking for a field on HPD:HelpDesk by the Field ID and 
it's not in the FindID drop down. 

Thanks! 
Melissa __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Find a field by ID

[Opela, Gary L Contr OC-ALC/ITMA]

Why not just run a def of the form, then search through it for the field
ID?

Thanks,


Gary Opela, Jr

Sr. Remedy Developer

Leader Communications, Inc.

405 736 3211


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Seth Wrye
Sent: Friday, March 07, 2008 9:47 AM
To: arslist@ARSLIST.ORG
Subject: Re: Find a field by ID

Melissa,
I would avoid the two suggestions because of the implications involved
with the "what if's".  Since the form you are searching on
(HPD:HelpDesk) is an OOTB form, all OOTB fields will be listed in the
Administrator view.  From there you can add the field to another view,
but I would be weary of problems caused by inadvertently hitting save or
creating performance issues by creating another view.  
 
Seth Wrye



From: Action Request System discussion list(ARSList) on behalf of Mary
Dollus
Sent: Fri 3/7/2008 10:32 AM
To: arslist@ARSLIST.ORG
Subject: Re: Find a field by ID


** 

Hi Melissa,

 

I sort of do the same thing as Ben with one exception.  I do a new view
and pull all the fields into it.  That way if something inadvertently
crashes or messes up, I don't have to worry about it affecting the main
form. 

 

Take care,

Mary Dollus

generationE Technologies

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Ben Cantatore
Sent: Friday, March 07, 2008 9:17 AM
To: arslist@ARSLIST.ORG
Subject: Re: Find a field by ID

 

** 
Melissa, 

Just do the following: 

1.  Go into the form you want to find the field on 

2.  Select Form\current view\fields in view  from the menu 

3.  Highlight all the fields on the left and then click add this
will push them all to the right side 

4.  Click ok 

5.  You'll have a mess in the upper left hand corner of the screen,
use the find field or ID drop downs at the top to find the field you
need. 

6.  Click Field properties after you've selected the field you need
and look up the name 

7.  DON'T Save the form, exit and close without saving 

8.  Go back into the form and follow steps 1 and 2 and then push
over only the field name that you've identified from step 6 


Hope that helps. 

Ben Cantatore
Remedy Administrator
Avon
(914) 935-2946 



SUBSCRIBE arslist Melissa <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)"
 

03/07/2008 10:04 AM 

Please respond to
arslist@ARSLIST.ORG

To

arslist@ARSLIST.ORG 

cc

 

Subject

Find a field by ID

 

 

 




** 
This may be a silly question, but how can I find a field by the ID
number if it's not in the view?  Looking for a field on HPD:HelpDesk by
the Field ID and it's not in the FindID drop down. 

Thanks! 
Melissa __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the
Answers Are" html___ 
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Find a field by ID

[SUBSCRIBE arslist Melissa]

Acutally that's not true.  There are many many fields that are not in the 
admin view on the HPD:HelpDesk.





Seth Wrye <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" 

03/07/2008 09:50 AM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Re: Find a field by ID






Melissa,
I would avoid the two suggestions because of the implications involved 
with the "what if's".  Since the form you are searching on (HPD:HelpDesk) 
is an OOTB form, all OOTB fields will be listed in the Administrator view. 
 From there you can add the field to another view, but I would be weary of 
problems caused by inadvertently hitting save or creating performance 
issues by creating another view. 
 
Seth Wrye



From: Action Request System discussion list(ARSList) on behalf of Mary 
Dollus
Sent: Fri 3/7/2008 10:32 AM
To: arslist@ARSLIST.ORG
Subject: Re: Find a field by ID


** 

Hi Melissa,

 

I sort of do the same thing as Ben with one exception.  I do a new view 
and pull all the fields into it.  That way if something inadvertently 
crashes or messes up, I don't have to worry about it affecting the main 
form. 

 

Take care,

Mary Dollus

generationE Technologies

 



From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of Ben Cantatore
Sent: Friday, March 07, 2008 9:17 AM
To: arslist@ARSLIST.ORG
Subject: Re: Find a field by ID

 

** 
Melissa, 

Just do the following: 

1.   Go into the form you want to find the field on 

2.   Select Form\current view\fields in view  from the menu 

3.   Highlight all the fields on the left and then click add 
this will push them all to the right side 

4.   Click ok 

5.   You'll have a mess in the upper left hand corner of the 
screen, use the find field or ID drop downs at the top to find the field 
you need. 

6.   Click Field properties after you've selected the field 
you need and look up the name 

7.   DON'T Save the form, exit and close without saving 

8.   Go back into the form and follow steps 1 and 2 and then 
push over only the field name that you've identified from step 6 


Hope that helps. 

Ben Cantatore
Remedy Administrator
Avon
(914) 935-2946 



SUBSCRIBE arslist Melissa <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" 
 

03/07/2008 10:04 AM 

Please respond to
arslist@ARSLIST.ORG

To

arslist@ARSLIST.ORG 

cc

 

Subject

Find a field by ID

 

 

 




** 
This may be a silly question, but how can I find a field by the ID number 
if it's not in the view?  Looking for a field on HPD:HelpDesk by the Field 
ID and it's not in the FindID drop down. 

Thanks! 
Melissa __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers 
Are" html___ 
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Find a field by ID

[Seth Wrye]

As far as I know, If its an OOTB field it should be on the Admin View (that is 
unless the form has been modified).  Otherwise, I would take Gary's advice and 
pull a deff.  Either way, I would avoid creating new views or adding all fields 
to a view on a production environment (unless this is a dev environment, in 
that case, go for it) because of the problems that could arise.  Working 
smarter avoids working harder.
 
Seth Wrye



From: Action Request System discussion list(ARSList) on behalf of SUBSCRIBE 
arslist Melissa
Sent: Fri 3/7/2008 10:54 AM
To: arslist@ARSLIST.ORG
Subject: Re: Find a field by ID


** 
Acutally that's not true.  There are many many fields that are not in the admin 
view on the HPD:HelpDesk. 





Seth Wrye <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)"  

03/07/2008 09:50 AM 
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG 
cc
Subject
Re: Find a field by ID  






Melissa,
I would avoid the two suggestions because of the implications involved with the 
"what if's".  Since the form you are searching on (HPD:HelpDesk) is an OOTB 
form, all OOTB fields will be listed in the Administrator view.  From there you 
can add the field to another view, but I would be weary of problems caused by 
inadvertently hitting save or creating performance issues by creating another 
view.  

Seth Wrye



From: Action Request System discussion list(ARSList) on behalf of Mary Dollus
Sent: Fri 3/7/2008 10:32 AM
To: arslist@ARSLIST.ORG
Subject: Re: Find a field by ID


** 

Hi Melissa,



I sort of do the same thing as Ben with one exception.  I do a new view and 
pull all the fields into it.  That way if something inadvertently crashes or 
messes up, I don't have to worry about it affecting the main form. 



Take care,

Mary Dollus

generationE Technologies





From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Ben Cantatore
Sent: Friday, March 07, 2008 9:17 AM
To: arslist@ARSLIST.ORG
Subject: Re: Find a field by ID



** 
Melissa, 

Just do the following: 

1. Go into the form you want to find the field on 

2. Select Form\current view\fields in view  from the menu 

3. Highlight all the fields on the left and then click add this 
will push them all to the right side 

4. Click ok 

5. You'll have a mess in the upper left hand corner of the 
screen, use the find field or ID drop downs at the top to find the field you 
need. 

6. Click Field properties after you've selected the field you 
need and look up the name 

7. DON'T Save the form, exit and close without saving 

8. Go back into the form and follow steps 1 and 2 and then push 
over only the field name that you've identified from step 6 


Hope that helps. 

Ben Cantatore
Remedy Administrator
Avon
(914) 935-2946 



SUBSCRIBE arslist Melissa <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)"  

03/07/2008 10:04 AM 

Please respond to
arslist@ARSLIST.ORG

To

arslist@ARSLIST.ORG 

cc



Subject

Find a field by ID










** 
This may be a silly question, but how can I find a field by the ID number if 
it's not in the view?  Looking for a field on HPD:HelpDesk by the Field ID and 
it's not in the FindID drop down. 

Thanks! 
Melissa __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___ 
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: UNSUBSCRIBE

[Sanford, Claire]

Susan like Pat Zandi can never leave us!!!



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Howard Richter
Sent: Thursday, March 06, 2008 7:52 PM
To: arslist@ARSLIST.ORG
Subject: Re: UNSUBSCRIBE


** 
Susan,
 
I thought you were going to get off the list and my world was ending..
 
hbr


On Thu, Mar 6, 2008 at 6:37 PM, Susan Palmer <[EMAIL PROTECTED]>
wrote:


** Read the bottom of the email


On Thu, Mar 6, 2008 at 2:12 PM, Benitz, Tony : CO IR
<[EMAIL PROTECTED]> wrote:


How do I get off the list.  I am not doing Remedy any
longer and the there is a lot of action on this list.

Thanks.. Tony Benitz



From: Action Request System discussion list(ARSList) on
behalf of Thomas Bean
Sent: Thu 3/6/2008 12:07 PM
To: arslist@ARSLIST.ORG
Subject: Re: Pattern of $MENU$


**
Andy,
What search qualification do you have defined in the
menu attached to the character field?

--Thomas


   - Original Message -
   From: Mayfield, Andy L.

   Newsgroups: gmane.comp.crm.arsystem.general
   To: arslist@ARSLIST.ORG
   Sent: Thursday, March 06, 2008 1:58 PM
   Subject: Re: Pattern of $MENU$

   **

   I am confused now. I am using the same setup on
other fields with no problem, but for some reason on this form it
doesn't want to work.



   Andy L. Mayfield
   Sr. System Operation Specialist
   Alabama Power Company
   Office: 205-226-1805
   Cell: 205-288-9140
   SoLinc: 10*19140





   From: Action Request System discussion
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Bean
   Sent: Thursday, March 06, 2008 1:15 PM
   To: arslist@ARSLIST.ORG
   Subject: Re: Pattern of $MENU$



   $MENU$ patterns below version will work in
earlier versions of ARS, but not if the search qualification defined in
the search menu contains a dynamic field reference.



   e.g.:

   'Equipment Category' = $536870913$



   There was a workaround for this, however (see
attached).



   This workaround should still be valid on later
versions of ARS.  However, it would be MUCH simpler to follow Joe's
suggestion, and change the display type to 'Drop-Down List' in the
display properties of the character field to which the search menu is
attached (unless for some reason you don't want the character field to
look like a selection field).



   HTH,



   --Thomas



   - Original Message -

   From: Joe D'Souza


   Newsgroups:
gmane.comp.crm.arsystem.general

   To: arslist@ARSLIST.ORG

   Sent: Wednesday, March 05, 2008 9:17 PM

   Subject: Re: Pattern of $MENU$



   **

   Andy,



   If you hare having the field patterned
using $MENU$, why do you type into it or let your users type into it?
Can't you just have the character field displayed as a drop-list and
have the users forced to use the menus? That's an available feature in
ARS version 6.3 upwards.. That would be clean and you would get what you
want to do...



   If you are below version 6, and somewhere
close to version 4.5, there

Re: Change Templates ITSM7

[T. Dee]

What about adding the attachment to the task - you can add attachment
to Tasks.  Then when the Task is added to the Change they will see the
attachment.

Does that help?

Ty


On Fri, Mar 7, 2008 at 9:50 AM, Don Simmons <[EMAIL PROTECTED]> wrote:
> **
> No that would not work.  They don't want to use Task.  The want the get the
> Install Plan, etc. with attachments to be part of the templates.  They have
> documents that are reused for hundreds of servers where the same change is
> being made multiple times.
>
> > Date: Fri, 7 Mar 2008 09:36:23 -0500
> > From: [EMAIL PROTECTED]
> > Subject: Re: Ch__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the
> Answers Are" html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Find a field by ID

[Mary Dollus]

Hi Seth,

I should have clarified it a bit.

I don't actually save the view, it's rare I need to do that so I just create 
the new view but then do not save.

Does that create performance issues too?

- Mary

P.S. I miss arstruct too!! I used it religiously  it was my favorite tool

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Seth Wrye
Sent: Friday, March 07, 2008 10:07 AM
To: arslist@ARSLIST.ORG
Subject: Re: Find a field by ID

As far as I know, If its an OOTB field it should be on the Admin View (that is 
unless the form has been modified).  Otherwise, I would take Gary's advice and 
pull a deff.  Either way, I would avoid creating new views or adding all fields 
to a view on a production environment (unless this is a dev environment, in 
that case, go for it) because of the problems that could arise.  Working 
smarter avoids working harder.

Seth Wrye



From: Action Request System discussion list(ARSList) on behalf of SUBSCRIBE 
arslist Melissa
Sent: Fri 3/7/2008 10:54 AM
To: arslist@ARSLIST.ORG
Subject: Re: Find a field by ID


**
Acutally that's not true.  There are many many fields that are not in the admin 
view on the HPD:HelpDesk.





Seth Wrye <[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)" 

03/07/2008 09:50 AM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc
Subject
Re: Find a field by ID






Melissa,
I would avoid the two suggestions because of the implications involved with the 
"what if's".  Since the form you are searching on (HPD:HelpDesk) is an OOTB 
form, all OOTB fields will be listed in the Administrator view.  From there you 
can add the field to another view, but I would be weary of problems caused by 
inadvertently hitting save or creating performance issues by creating another 
view.

Seth Wrye



From: Action Request System discussion list(ARSList) on behalf of Mary Dollus
Sent: Fri 3/7/2008 10:32 AM
To: arslist@ARSLIST.ORG
Subject: Re: Find a field by ID


**

Hi Melissa,



I sort of do the same thing as Ben with one exception.  I do a new view and 
pull all the fields into it.  That way if something inadvertently crashes or 
messes up, I don't have to worry about it affecting the main form.



Take care,

Mary Dollus

generationE Technologies





From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Ben Cantatore
Sent: Friday, March 07, 2008 9:17 AM
To: arslist@ARSLIST.ORG
Subject: Re: Find a field by ID



**
Melissa,

Just do the following:

1. Go into the form you want to find the field on

2. Select Form\current view\fields in view  from the menu

3. Highlight all the fields on the left and then click add this 
will push them all to the right side

4. Click ok

5. You'll have a mess in the upper left hand corner of the 
screen, use the find field or ID drop downs at the top to find the field you 
need.

6. Click Field properties after you've selected the field you 
need and look up the name

7. DON'T Save the form, exit and close without saving

8. Go back into the form and follow steps 1 and 2 and then push 
over only the field name that you've identified from step 6


Hope that helps.

Ben Cantatore
Remedy Administrator
Avon
(914) 935-2946



SUBSCRIBE arslist Melissa <[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)" 

03/07/2008 10:04 AM

Please respond to
arslist@ARSLIST.ORG

To

arslist@ARSLIST.ORG

cc



Subject

Find a field by ID










**
This may be a silly question, but how can I find a field by the ID number if 
it's not in the view?  Looking for a field on HPD:HelpDesk by the Field ID and 
it's not in the FindID drop down.

Thanks!
Melissa __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Find a field by ID

[Pierson, Shawn]

If you just need to know the name and what views it is in, I would just
run something like this in SQL:



select

 f.fieldid,

 f.fieldname,

 s.[name] as formname,

 v.vuiname as viewname

from field f

 inner join arschema s

  on s.schemaid = f.schemaid

 inner join vui v

  on s.schemaid = v.schemaid

 inner join field_dispprop fp

  on s.schemaid = fp.schemaid

  and f.fieldid = fp.fieldid

where s.[name] = 'HPD:Help Desk'

 and f.fieldid = '100715'



Obviously, this can be tweaked to provide more or less data, but I find
it very useful to go straight to the database to find some things like
this.



I hope this helps,



Shawn Pierson



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of SUBSCRIBE arslist Melissa
Sent: Friday, March 07, 2008 9:04 AM
To: arslist@ARSLIST.ORG
Subject: Find a field by ID



**
This may be a silly question, but how can I find a field by the ID
number if it's not in the view?  Looking for a field on HPD:HelpDesk by
the Field ID and it's not in the FindID drop down.

Thanks!
Melissa __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the
Answers Are" html___


Private and confidential as detailed here: 
http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the 
link, please e-mail sender.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Find a field by ID

[Opela, Gary L Contr OC-ALC/ITMA]

You beat me to it! I was milling through the database looking at Create
Table statements trying to find which table linked the field ID up with
the View ID, then I was going to compose something like what you did.
Man, I was just too slow! I feel inferior now :\ I couldn't find
field_dispprop soon enough...

Oh well, next time I will know it!

Thanks,


Gary Opela, Jr

Sr. Remedy Developer

Leader Communications, Inc.

405 736 3211


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Pierson, Shawn
Sent: Friday, March 07, 2008 10:18 AM
To: arslist@ARSLIST.ORG
Subject: Re: Find a field by ID

** 

If you just need to know the name and what views it is in, I would just
run something like this in SQL:

 

select 

 f.fieldid, 

 f.fieldname, 

 s.[name] as formname,

 v.vuiname as viewname

from field f

 inner join arschema s

  on s.schemaid = f.schemaid

 inner join vui v

  on s.schemaid = v.schemaid

 inner join field_dispprop fp

  on s.schemaid = fp.schemaid

  and f.fieldid = fp.fieldid

where s.[name] = 'HPD:Help Desk'

 and f.fieldid = '100715'

 

Obviously, this can be tweaked to provide more or less data, but I find
it very useful to go straight to the database to find some things like
this.

 

I hope this helps,

 

Shawn Pierson

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of SUBSCRIBE arslist Melissa
Sent: Friday, March 07, 2008 9:04 AM
To: arslist@ARSLIST.ORG
Subject: Find a field by ID

 

** 
This may be a silly question, but how can I find a field by the ID
number if it's not in the view?  Looking for a field on HPD:HelpDesk by
the Field ID and it's not in the FindID drop down. 

Thanks! 
Melissa __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the
Answers Are" html___

Private and confidential as detailed here
 . If you cannot access
hyperlink, please e-mail sender. 
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Find a field by ID

[Seth Wrye]

Only if you hit save.  But. there are times when we are working to resolve 
something, faster than we should and out of habit or just on accident hit save 
(I don't know many developers that haven't made that mistake).  I try to avoid 
it all together unless I'm in a dev environment and especially on OOTB forms.  
If I'm developing a custom form, I will still use the same rule though.  Create 
and add all fields on an Admin view and then move the fields to the view that 
everyone else will see.  This just gives you a good foundation for your form 
and keeps everything well organized.
 
Seth Wrye



From: Action Request System discussion list(ARSList) on behalf of Mary Dollus
Sent: Fri 3/7/2008 11:17 AM
To: arslist@ARSLIST.ORG
Subject: Re: Find a field by ID



Hi Seth,

I should have clarified it a bit.

I don't actually save the view, it's rare I need to do that so I just create 
the new view but then do not save.

Does that create performance issues too?

- Mary

P.S. I miss arstruct too!! I used it religiously  it was my favorite tool

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Seth Wrye
Sent: Friday, March 07, 2008 10:07 AM
To: arslist@ARSLIST.ORG
Subject: Re: Find a field by ID

As far as I know, If its an OOTB field it should be on the Admin View (that is 
unless the form has been modified).  Otherwise, I would take Gary's advice and 
pull a deff.  Either way, I would avoid creating new views or adding all fields 
to a view on a production environment (unless this is a dev environment, in 
that case, go for it) because of the problems that could arise.  Working 
smarter avoids working harder.

Seth Wrye



From: Action Request System discussion list(ARSList) on behalf of SUBSCRIBE 
arslist Melissa
Sent: Fri 3/7/2008 10:54 AM
To: arslist@ARSLIST.ORG
Subject: Re: Find a field by ID


**
Acutally that's not true.  There are many many fields that are not in the admin 
view on the HPD:HelpDesk.





Seth Wrye <[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)" 

03/07/2008 09:50 AM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc
Subject
Re: Find a field by ID






Melissa,
I would avoid the two suggestions because of the implications involved with the 
"what if's".  Since the form you are searching on (HPD:HelpDesk) is an OOTB 
form, all OOTB fields will be listed in the Administrator view.  From there you 
can add the field to another view, but I would be weary of problems caused by 
inadvertently hitting save or creating performance issues by creating another 
view.

Seth Wrye



From: Action Request System discussion list(ARSList) on behalf of Mary Dollus
Sent: Fri 3/7/2008 10:32 AM
To: arslist@ARSLIST.ORG
Subject: Re: Find a field by ID


**

Hi Melissa,



I sort of do the same thing as Ben with one exception.  I do a new view and 
pull all the fields into it.  That way if something inadvertently crashes or 
messes up, I don't have to worry about it affecting the main form.



Take care,

Mary Dollus

generationE Technologies





From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Ben Cantatore
Sent: Friday, March 07, 2008 9:17 AM
To: arslist@ARSLIST.ORG
Subject: Re: Find a field by ID



**
Melissa,

Just do the following:

1. Go into the form you want to find the field on

2. Select Form\current view\fields in view  from the menu

3. Highlight all the fields on the left and then click add this 
will push them all to the right side

4. Click ok

5. You'll have a mess in the upper left hand corner of the 
screen, use the find field or ID drop downs at the top to find the field you 
need.

6. Click Field properties after you've selected the field you 
need and look up the name

7. DON'T Save the form, exit and close without saving

8. Go back into the form and follow steps 1 and 2 and then push 
over only the field name that you've identified from step 6


Hope that helps.

Ben Cantatore
Remedy Administrator
Avon
(914) 935-2946



SUBSCRIBE arslist Melissa <[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)" 

03/07/2008 10:04 AM

Please respond to
arslist@ARSLIST.ORG

To

arslist@ARSLIST.ORG

cc



Subject

Find a field by ID










**
This may be a silly question, but how can I find a field by the ID number if 
it's not in the view?  Looking for a field on HPD:HelpDesk by the Field ID and 
it's not in the FindID drop down.

Thanks!
Melissa __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where th

Issue with OpGetList web service

[Ibrahim Akar]

I have created three web services against CTM:People. OpCreate, OpGet and
OpGetList.

The web services work fine with the exception of OpGetList. It partially
works in that it only returns one record instead of the dozens that I am
expecting.  I am thinking it might  have to do with


   - XPATH(/ROOT/maxLimit)   &
   - XPATH(/ROOT/startRecord)

Do I need to do anything with these? If so, what?  What I noticed is that
the web service only returns the first record. I am attaching the def file.

Any help will be appreciated.

-- 
-Ibrahim Akar


PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS EMAIL

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"


QTSFetchPeopleRecord.def
Description: Binary data

Re: Find a field by ID

[Mary Dollus]

Oh yep!! And I was also speaking of dev... but so true.. I try to avoid 
anything on prod if at all possible! :) ya just never know what can happen

Thanks Seth

- Mary

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Seth Wrye
Sent: Friday, March 07, 2008 10:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: Find a field by ID

Only if you hit save.  But. there are times when we are working to resolve 
something, faster than we should and out of habit or just on accident hit save 
(I don't know many developers that haven't made that mistake).  I try to avoid 
it all together unless I'm in a dev environment and especially on OOTB forms.  
If I'm developing a custom form, I will still use the same rule though.  Create 
and add all fields on an Admin view and then move the fields to the view that 
everyone else will see.  This just gives you a good foundation for your form 
and keeps everything well organized.

Seth Wrye



From: Action Request System discussion list(ARSList) on behalf of Mary Dollus
Sent: Fri 3/7/2008 11:17 AM
To: arslist@ARSLIST.ORG
Subject: Re: Find a field by ID



Hi Seth,

I should have clarified it a bit.

I don't actually save the view, it's rare I need to do that so I just create 
the new view but then do not save.

Does that create performance issues too?

- Mary

P.S. I miss arstruct too!! I used it religiously  it was my favorite tool

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Seth Wrye
Sent: Friday, March 07, 2008 10:07 AM
To: arslist@ARSLIST.ORG
Subject: Re: Find a field by ID

As far as I know, If its an OOTB field it should be on the Admin View (that is 
unless the form has been modified).  Otherwise, I would take Gary's advice and 
pull a deff.  Either way, I would avoid creating new views or adding all fields 
to a view on a production environment (unless this is a dev environment, in 
that case, go for it) because of the problems that could arise.  Working 
smarter avoids working harder.

Seth Wrye



From: Action Request System discussion list(ARSList) on behalf of SUBSCRIBE 
arslist Melissa
Sent: Fri 3/7/2008 10:54 AM
To: arslist@ARSLIST.ORG
Subject: Re: Find a field by ID


**
Acutally that's not true.  There are many many fields that are not in the admin 
view on the HPD:HelpDesk.





Seth Wrye <[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)" 

03/07/2008 09:50 AM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc
Subject
Re: Find a field by ID






Melissa,
I would avoid the two suggestions because of the implications involved with the 
"what if's".  Since the form you are searching on (HPD:HelpDesk) is an OOTB 
form, all OOTB fields will be listed in the Administrator view.  From there you 
can add the field to another view, but I would be weary of problems caused by 
inadvertently hitting save or creating performance issues by creating another 
view.

Seth Wrye



From: Action Request System discussion list(ARSList) on behalf of Mary Dollus
Sent: Fri 3/7/2008 10:32 AM
To: arslist@ARSLIST.ORG
Subject: Re: Find a field by ID


**

Hi Melissa,



I sort of do the same thing as Ben with one exception.  I do a new view and 
pull all the fields into it.  That way if something inadvertently crashes or 
messes up, I don't have to worry about it affecting the main form.



Take care,

Mary Dollus

generationE Technologies





From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Ben Cantatore
Sent: Friday, March 07, 2008 9:17 AM
To: arslist@ARSLIST.ORG
Subject: Re: Find a field by ID



**
Melissa,

Just do the following:

1. Go into the form you want to find the field on

2. Select Form\current view\fields in view  from the menu

3. Highlight all the fields on the left and then click add this 
will push them all to the right side

4. Click ok

5. You'll have a mess in the upper left hand corner of the 
screen, use the find field or ID drop downs at the top to find the field you 
need.

6. Click Field properties after you've selected the field you 
need and look up the name

7. DON'T Save the form, exit and close without saving

8. Go back into the form and follow steps 1 and 2 and then push 
over only the field name that you've identified from step 6


Hope that helps.

Ben Cantatore
Remedy Administrator
Avon
(914) 935-2946



SUBSCRIBE arslist Melissa <[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)" 

03/07/2008 10:04 AM

Please respond to
arslist@ARSLIST.ORG

To

arslist@ARSLIST.ORG

cc



Subject

Find a field by ID










**
This may be a silly questio

Multiple Hosts in Area Ldap

[SUBSCRIBE arslist Melissa]

How can I set up multiple hosts in Area Ldap configuration?  We are using 
ARS 7.01

Thanks!
Melissa

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: UNSUBSCRIBE

[Susan Palmer]

lol ... sometimes I cannot skip a chance for a smarta*s response



On Fri, Mar 7, 2008 at 10:11 AM, Sanford, Claire <
[EMAIL PROTECTED]> wrote:

> ** *Susan like Pat Zandi can never leave us!!!*
>
>  --
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Howard Richter
> *Sent:* Thursday, March 06, 2008 7:52 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: UNSUBSCRIBE
>
>   ** Susan,
>
> I thought you were going to get off the list and my world was ending..
>
> hbr
>
> On Thu, Mar 6, 2008 at 6:37 PM, Susan Palmer <[EMAIL PROTECTED]>
> wrote:
>
> > ** Read the bottom of the email
> >
> > On Thu, Mar 6, 2008 at 2:12 PM, Benitz, Tony : CO IR <[EMAIL PROTECTED]>
> > wrote:
> >
> > > How do I get off the list.  I am not doing Remedy any longer and the
> > > there is a lot of action on this list.
> > >
> > > Thanks.. Tony Benitz
> > >
> > > 
> > >
> > > From: Action Request System discussion list(ARSList) on behalf of
> > > Thomas Bean
> > > Sent: Thu 3/6/2008 12:07 PM
> > > To: arslist@ARSLIST.ORG
> > > Subject: Re: Pattern of $MENU$
> > >
> > >
> > > **
> > > Andy,
> > > What search qualification do you have defined in the menu attached to
> > > the character field?
> > >
> > > --Thomas
> > >
> > >
> > >- Original Message -
> > >From: Mayfield, Andy L. 
> > >Newsgroups: gmane.comp.crm.arsystem.general
> > >To: arslist@ARSLIST.ORG
> > >Sent: Thursday, March 06, 2008 1:58 PM
> > >Subject: Re: Pattern of $MENU$
> > >
> > >**
> > >
> > >I am confused now. I am using the same setup on other fields
> > > with no problem, but for some reason on this form it doesn't want to work.
> > >
> > >
> > >
> > >Andy L. Mayfield
> > >Sr. System Operation Specialist
> > >Alabama Power Company
> > >Office: 205-226-1805
> > >Cell: 205-288-9140
> > >SoLinc: 10*19140
> > >
> > >
> > > 
> > >
> > >
> > >From: Action Request System discussion list(ARSList) [mailto:
> > > [EMAIL PROTECTED] On Behalf Of Thomas Bean
> > >Sent: Thursday, March 06, 2008 1:15 PM
> > >To: arslist@ARSLIST.ORG
> > >Subject: Re: Pattern of $MENU$
> > >
> > >
> > >
> > >$MENU$ patterns below version will work in earlier versions of
> > > ARS, but not if the search qualification defined in the search menu 
> > > contains
> > > a dynamic field reference.
> > >
> > >
> > >
> > >e.g.:
> > >
> > >'Equipment Category' = $536870913$
> > >
> > >
> > >
> > >There was a workaround for this, however (see attached).
> > >
> > >
> > >
> > >This workaround should still be valid on later versions of ARS.
> > >  However, it would be MUCH simpler to follow Joe's suggestion, and change
> > > the display type to 'Drop-Down List' in the display properties of the
> > > character field to which the search menu is attached (unless for some 
> > > reason
> > > you don't want the character field to look like a selection field).
> > >
> > >
> > >
> > >HTH,
> > >
> > >
> > >
> > >--Thomas
> > >
> > >
> > >
> > >- Original Message -
> > >
> > >From: Joe D'Souza 
> > >
> > >Newsgroups: gmane.comp.crm.arsystem.general
> > >
> > >To: arslist@ARSLIST.ORG
> > >
> > >Sent: Wednesday, March 05, 2008 9:17 PM
> > >
> > >Subject: Re: Pattern of $MENU$
> > >
> > >
> > >
> > >**
> > >
> > >Andy,
> > >
> > >
> > >
> > >If you hare having the field patterned using $MENU$,
> > > why do you type into it or let your users type into it? Can't you just 
> > > have
> > > the character field displayed as a drop-list and have the users forced to
> > > use the menus? That's an available feature in ARS version 6.3upwards.. 
> > > That would be clean and you would get what you want to do...
> > >
> > >
> > >
> > >If you are below version 6, and somewhere close to
> > > version 4.5, there used to be a bug with the $MENU$ patterning.. Even
> > > valid values would be rejected. The only fix on that version was to 
> > > upgrade
> > > it. I do not recall a patch that fixed it except the next upgrade..
> > >
> > >
> > >
> > >Cheers
> > >
> > >
> > >
> > >Joe
> > >
> > >
> > >
> > >-Original Message-
> > >
> > >From: Action Request System discussion list(ARSList)
> > > [mailto:[EMAIL PROTECTED]
> > >
> > > ___
> > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> > > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> > >
> >
> > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the

Re: who can advice on new features of version 7

[Michelle L]

Hi, Serouche:

You do not have to do a full blown upgrade to take advantage of this
feature.

One can remain on ARS 6.3 for example and use a 7.x Mid-Tier to take
advantage of this.  All you would need is for someone to send you the def
file for saved searches and import it into your ARS 6.3 server.

In a previous life, this is exactly what we did on Mid-Tier 7.0.1 against a
ARS 6.3 P17 and P20 server.

Thanks,
Michelle


   
 Joe D'Souza   
 <[EMAIL PROTECTED] 
 T> To 
 Sent by: "Action  arslist@ARSLIST.ORG 
 Request System cc 
 discussion
 list(ARSList)"Subject 
 <[EMAIL PROTECTED] Re: who can advice on new features  
 ORG>  of version 7
   
   
 03/05/2008 09:30  
 PM
   
   
 Please respond to 
 [EMAIL PROTECTED] 
RG 
   
   




**
Then again it depends on what they want to upgrade.. If its just the server
go for it.. there are several new features on the Server side that would be
worth upgrading for..

If what you are using are the ITSM applications, and they want to upgrade
those, I may second Jennifer on that, and what happens here stays here! We
won't tell no one :-).. Things do get ugly on ITSM 7.1 if you need to use
it eventually! You are lucky if you do not think you will not need to
change a thing and just use it Out Of The Box but even then, some of the
things are in a manner of speaking, broken before they are even built...

If you really are looking for a new solution, just because you prefer a new
toy, you may be better off looking at other alternatives. Buoyant Solutions
have got a solution that I had a look at a couple of months ago that I must
say I found pretty impressive. It is ARS based, and has all the ITSM
components (IM, PM, CM, AM etc.). Got a lot of bells and whistles. And
costs nowhere nearly as much as ITSM 7 does. You might want to get in touch
with them and take a look for yourself on what they got to offer you..

Cheers

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
  [mailto:[EMAIL PROTECTED] Behalf Of Jennifer Meyer
  Sent: Wednesday, March 05, 2008 6:15 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: who can advice on new features of version 7

  **

  I suggest killing the members of management in favor of upgrading in
  a violent, brutal manner.  This is, of course, my professional
  opinion.


  From: Remedy Maniac
  Sent: Fri 15-Feb-08 11:07
  To: arslist@ARSLIST.ORG
  Subject: who can advice on new features of version 7

  dear listers,

  some of our decision makers would be in favor of upgrading our Remedy
  6
  to version 7 specially because of the new feature which allows "Saved

  searches on web".
  Could anyone give some tips on what this would cost in terms of
  development and how difficult or tricky it could be?
  Any information on this is very welcomed.
  Thank you in advance.
  serouche
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___



==

Confidentiality Notice: The information contained in and transmitted with this 
communication is strictly confidential, is intended only for the use of the 
intended recipient, and is the property of Countrywide Financial Corporation or 
its affiliates and subsidiaries.  If you are not the intended recipient, you 
are hereby notified that any use of the information contained in or transmitted 
with the communication or dissemination, distribution, or copying of this 
communication is strictly prohibited by law.  If you have received this 
communication in error, please immediately return this communication to the 
sender and dele

7.1 Thread weirdness

[William Rentfrow]

We defined multiple escalation threads in 7.1 - we added one thread.

We have 1,000,000 people records in CTM:People in IM.  We are testing
our delete strategy which does the following:

1.) Escalation sets certain record status to "Delete"
2.) Filter deletes record with APPLICATION-DELETE-ENTRY Run Process

This Escalation is set to run in it's own escalation pool (#2).

This all works fine - we can do other stuff on the server in the user
tool without any problems.  However - if we try to save any workflow
(filter/active link) in the admin tool during this time it locks
everyone out of the system.  All user tools time out.  All admin tools
timeout.  The escalation thread keeps going though and deletes records.

This makes no sense to me - the filter threads doing deletes should be
running in fast/list threads and we have plenty of those.  The admin
thread should be wide open to save workflow.

Processor utilization is only about 1.5% when everything is locked up.
 
William Rentfrow, Principal Consultant
[EMAIL PROTECTED]
C 701-306-6157
O 952-432-0227

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: For anyone using the aradmin.exe command

[Carey Matthew Black]

Scott,

Actually... let me see if you can try something for me and see if we
can get that to work...


This is a sore topic for me. I have tried to get BMC to understand how
dumb I think this feature is, but they appear to not share my concern
for it.


In the admin tool open the packing list of interest.
Go to the "Packing List" menu and select "Generate XML".

You need to use this "XML" file as the input to the admin tool command
line. NOT an ARS def file (in xml format). [ The def file does not
work, but it is what most people think should work. Most people do not
ever look at the "Packing List" menu because it only shows up when you
open a packing list , and the terminology is just "XML file" instead
of the "special file generated from the menu of the packing list
object via the admin tool".]


My two cents

I should be able to mention the NAME of the packing list and not have
any cached copy of it before the command line is called.

And in my dream world... I can use a packlist as defined on a
different ARS server too. ( Yes that means that I may need to pass in
two usersnames and passwords, but I am ok with that. )

So ... Picture this...


Create a packing list on your Dev server.
>From the command line export those objects from Production.
Import them to your Test server.
Then import your Dev objects (presumably different from Production) to
your Test server.

You now have a way to maintain one list, on dev, of objects that are
in a "release" and a way to use that list to normalize your Test
server.

-- 
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.




On Fri, Mar 7, 2008 at 9:57 AM, Scott Philben <[EMAIL PROTECTED]> wrote:
> We found out an interesting bit of information yesterday about the command 
> line uasge of the aradmin.exe command. On page 557 of the 6.3 Advanced book 
> Remedy claims the following:
>
>
>  To parse an XML packing list, and export all the objects defined in that 
> packing list, use the following command format:
>
>  aradmin -u  [-p ] -x  -e  -l 
> 
>
>
>  Well, when we tried to use that command to dump out a packing list worth of 
> stuff nothing seemed to happen. So I opened an Incident with BMC and come to 
> find out that the XML packing list thing does not appear to work in any 
> environment that they can find. I think this is kind of odd since I believe 
> that this option has been available since at least 5.1.2. I might be wrong.
>
>  So anyway, don't try to dump stuff out of your system via an XML packing 
> list file (not that you wanted to anyway since I can't find any reference of 
> anyone else in history having the same problem and posting about it on the 
> interwebs).
>
>  
> ___
>  UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>  Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: who can advice on new features of version 7

[Carey Matthew Black]

Michelle,

I have never tried that before so I wonder

That may fix the v7.x web clients use of saved searches, but how does
that effect the v6.3 User Tools use of saved searches?

-- 
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.


On Fri, Mar 7, 2008 at 12:31 PM, Michelle L
<[EMAIL PROTECTED]> wrote:
> Hi, Serouche:
>
>  You do not have to do a full blown upgrade to take advantage of this
>  feature.
>
>  One can remain on ARS 6.3 for example and use a 7.x Mid-Tier to take
>  advantage of this.  All you would need is for someone to send you the def
>  file for saved searches and import it into your ARS 6.3 server.
>
>  In a previous life, this is exactly what we did on Mid-Tier 7.0.1 against a
>  ARS 6.3 P17 and P20 server.
>
>  Thanks,
>  Michelle

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: For anyone using the aradmin.exe command

[Scott Philben]

Yeah, we actually tried this little task with both a def file and an XML file 
created in the Admin tool from a packing list. No dice on either. It did work 
when I referenced a non-existent file at one point... But that just took a long 
time and then gave me a definition file with everything from the server in it 
(175+ MB)

I would also like to see a right click on a workflow object with some sort of 
"Send to Packing List" option so I can quickly dump new things into my Packing 
List without having to actually open an existing Packing List.

-scott
 
On Friday, March 07, 2008, at 12:41PM, "Carey Matthew Black" <[EMAIL 
PROTECTED]> wrote:
>Scott,
>
>Actually... let me see if you can try something for me and see if we
>can get that to work...
>
>
>This is a sore topic for me. I have tried to get BMC to understand how
>dumb I think this feature is, but they appear to not share my concern
>for it.
>
>
>In the admin tool open the packing list of interest.
>Go to the "Packing List" menu and select "Generate XML".
>
>You need to use this "XML" file as the input to the admin tool command
>line. NOT an ARS def file (in xml format). [ The def file does not
>work, but it is what most people think should work. Most people do not
>ever look at the "Packing List" menu because it only shows up when you
>open a packing list , and the terminology is just "XML file" instead
>of the "special file generated from the menu of the packing list
>object via the admin tool".]
>
>
>My two cents
>
>I should be able to mention the NAME of the packing list and not have
>any cached copy of it before the command line is called.
>
>And in my dream world... I can use a packlist as defined on a
>different ARS server too. ( Yes that means that I may need to pass in
>two usersnames and passwords, but I am ok with that. )
>
>So ... Picture this...
>
>
>Create a packing list on your Dev server.
>From the command line export those objects from Production.
>Import them to your Test server.
>Then import your Dev objects (presumably different from Production) to
>your Test server.
>
>You now have a way to maintain one list, on dev, of objects that are
>in a "release" and a way to use that list to normalize your Test
>server.
>
>-- 
>Carey Matthew Black
>Remedy Skilled Professional (RSP)
>ARS = Action Request System(Remedy)
>
>Love, then teach
>Solution = People + Process + Tools
>Fast, Accurate, Cheap Pick two.
>
>
>
>
>On Fri, Mar 7, 2008 at 9:57 AM, Scott Philben <[EMAIL PROTECTED]> wrote:
>> We found out an interesting bit of information yesterday about the command 
>> line uasge of the aradmin.exe command. On page 557 of the 6.3 Advanced book 
>> Remedy claims the following:
>>
>>
>>  To parse an XML packing list, and export all the objects defined in that 
>> packing list, use the following command format:
>>
>>  aradmin -u  [-p ] -x  -e  -l 
>> 
>>
>>
>>  Well, when we tried to use that command to dump out a packing list worth of 
>> stuff nothing seemed to happen. So I opened an Incident with BMC and come to 
>> find out that the XML packing list thing does not appear to work in any 
>> environment that they can find. I think this is kind of odd since I believe 
>> that this option has been available since at least 5.1.2. I might be wrong.
>>
>>  So anyway, don't try to dump stuff out of your system via an XML packing 
>> list file (not that you wanted to anyway since I can't find any reference of 
>> anyone else in history having the same problem and posting about it on the 
>> interwebs).
>>
>>  
>> ___
>>  UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>  Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>>
>
>___
>UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Remove duplicate email address from a String

[Thad K Esser]

Darshana,

Along the lines of Frank's suggestion, how about the following:

In your AL that does the looping:
Set Fields, SQL: SELECT CONTACT_EMAIL FROM [EMAIL PROTECTED] 
WHERE  CONTACT_ID = '$Col_C_ContactID$'
MTNNS_primary_client_contact_email = 
REPLACE($MTNNS_primary_client_contact_email$, LOWER($1$),"") + "," + 
LOWER($1$)

This will replace the email address with a null if its there (it does 
nothing if its not) and then adds it to the end.  The LOWER() is just 
there in case your email addresses have mixed cases.  You can use $1$ 
without storing it in a temp field ("Email" in your example), unless you 
need it for some other purpose.  It also gets rid of the $Val1$ and $Val2$ 
temp fields.

Then, once your loop is complete, do one more set fields to clean up any 
duplicate commas:
MTNNS_primary_client_contact_email = 
REPLACE($MTNNS_primary_client_contact_email$, ",,",",")

Oh, and unless you are handling it somewhere else, your code will cause 
the list to start with a comma (so will the above).  You'll want to clip 
that off:
MTNNS_primary_client_contact_email = 
SUBSTR($MTNNS_primary_client_contact_email$, 1) 
(substrings are zero-indexed, so starting at 1 skips the first char, which 
we know is a comma, and without the third parameter it'll return the rest 
of the string)

For that matter, combine the last two set fields into one:
MTNNS_primary_client_contact_email = 
SUBSTR(REPLACE($MTNNS_primary_client_contact_email$, ",,",",") , 1) 

I hope that helps.

Thad Esser
Remedy Developer
"Argue for your limitations, and sure enough, they're yours."-- Richard 
Bach



"Darshana Jivan [MTN Network Solutions]" <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" 

03/07/2008 06:34 AM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Remove duplicate email address from a String






** 
Hi,
 
Please can someone assist me with the following.
 
I want to remove duplicate email addresses in a string. I cannot create a 
view with the distinct values as I need the unique id?s of the record 
therefore the only option I do have is to try and remove duplicate 
occurrences after the 1st occurrence of an email address.
 
This is the following process that I am using but I know that the last set 
fields with the replace function is not doing what I require it to do and 
there is where I need some assistance.
 
I have a AL that fetches and email address and concatenates it to a string 
in a loop.
SQL Command: SELECT CONTACT_EMAIL FROM [EMAIL PROTECTED] WHERE 
CONTACT_ID = '$Col_C_ContactID$'
Set Fields 1: Email
$1$
Set Fields 2: MTNNS_primary_client_contact_email
($MTNNS_primary_client_contact_email$ +  ",") + $Email$
 
I then have another AL that does the following when it finds a match of an 
email address in the string ?MTNNS_primary_client_contact_email?
Set Fields 1: Val1
STRSTR($MTNNS_primary_client_contact_email$, $Email$)
Set Fields 2: Val2
LENGTH($Email$)
Set Fields 3:
REPLACE($MTNNS_primary_client_contact_email$, 
SUBSTR($MTNNS_primary_client_contact_email$, $Val1$, $Val2$),  "")
 
In essence if I have a table with the following email addresses and when 
its looped through the string or the value I am looking for is 
[EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] the duplicate 
occurrence should be extracted from the string.
 
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
 
 
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___ 

***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.***

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Remove duplicate email address from a String

[Thad K Esser]

Darshana,

I just realized I didn't actually answer your question.  Your "Set Fields 
3":
Set Fields 3: 
REPLACE($MTNNS_primary_client_contact_email$, 
SUBSTR($MTNNS_primary_client_contact_email$, $Val1$, $Val2$),  "") 

doesn't work because $Val2$ is storing the length of the email address, 
not the end position in the string.  If you change that to:
REPLACE($MTNNS_primary_client_contact_email$, 
SUBSTR($MTNNS_primary_client_contact_email$, $Val1$, $Val1$ + $Val2$), "") 

You'll get closer.  Or leave your set fields 3 the same, and change set 
fields 2:
Set Fields 2: 
Val2 = $Val1$ + LENGTH($Email$) 

Thad Esser
Remedy Developer
"Argue for your limitations, and sure enough, they're yours."-- Richard 
Bach



"Thad K Esser" <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" 

03/07/2008 10:14 AM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Re: Remove duplicate email address from a String






** 
Darshana, 

Along the lines of Frank's suggestion, how about the following: 

In your AL that does the looping: 
Set Fields, SQL: SELECT CONTACT_EMAIL FROM [EMAIL PROTECTED] 
WHERE  CONTACT_ID = '$Col_C_ContactID$' 
MTNNS_primary_client_contact_email = 
REPLACE($MTNNS_primary_client_contact_email$, LOWER($1$),"") + "," + 
LOWER($1$) 

This will replace the email address with a null if its there (it does 
nothing if its not) and then adds it to the end.  The LOWER() is just 
there in case your email addresses have mixed cases.  You can use $1$ 
without storing it in a temp field ("Email" in your example), unless you 
need it for some other purpose.  It also gets rid of the $Val1$ and $Val2$ 
temp fields. 

Then, once your loop is complete, do one more set fields to clean up any 
duplicate commas: 
MTNNS_primary_client_contact_email = 
REPLACE($MTNNS_primary_client_contact_email$, ",,",",") 

Oh, and unless you are handling it somewhere else, your code will cause 
the list to start with a comma (so will the above).  You'll want to clip 
that off: 
MTNNS_primary_client_contact_email = 
SUBSTR($MTNNS_primary_client_contact_email$, 1) 
(substrings are zero-indexed, so starting at 1 skips the first char, which 
we know is a comma, and without the third parameter it'll return the rest 
of the string) 

For that matter, combine the last two set fields into one: 
MTNNS_primary_client_contact_email = 
SUBSTR(REPLACE($MTNNS_primary_client_contact_email$, ",,",",") , 1) 

I hope that helps. 

Thad Esser
Remedy Developer
"Argue for your limitations, and sure enough, they're yours."-- Richard 
Bach 


"Darshana Jivan [MTN Network Solutions]" <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" 
 
03/07/2008 06:34 AM 

Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG 
cc

Subject
Remove duplicate email address from a String








** 
Hi, 
  
Please can someone assist me with the following. 
  
I want to remove duplicate email addresses in a string. I cannot create a 
view with the distinct values as I need the unique id?s of the record 
therefore the only option I do have is to try and remove duplicate 
occurrences after the 1st occurrence of an email address. 
  
This is the following process that I am using but I know that the last set 
fields with the replace function is not doing what I require it to do and 
there is where I need some assistance. 
  
I have a AL that fetches and email address and concatenates it to a string 
in a loop. 
SQL Command: SELECT CONTACT_EMAIL FROM [EMAIL PROTECTED] WHERE 
CONTACT_ID = '$Col_C_ContactID$' 
Set Fields 1: Email 
$1$ 
Set Fields 2: MTNNS_primary_client_contact_email 
($MTNNS_primary_client_contact_email$ +  ",") + $Email$ 
  
I then have another AL that does the following when it finds a match of an 
email address in the string ?MTNNS_primary_client_contact_email? 
Set Fields 1: Val1 
STRSTR($MTNNS_primary_client_contact_email$, $Email$) 
Set Fields 2: Val2 
LENGTH($Email$) 
Set Fields 3: 
REPLACE($MTNNS_primary_client_contact_email$, 
SUBSTR($MTNNS_primary_client_contact_email$, $Val1$, $Val2$),  "") 
  
In essence if I have a table with the following email addresses and when 
its looped through the string or the value I am looking for is 
[EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] the duplicate 
occurrence should be extracted from the string. 
  
[EMAIL PROTECTED] 
[EMAIL PROTECTED] 
[EMAIL PROTECTED] 
[EMAIL PROTECTED]
[EMAIL PROTECTED] 
  
  
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___ 
***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 

Re: UNSUBSCRIBE

[Darrell Reading]

Let me share with the list what I did a number of years ago in direct
relationship to the subject above and trying to be a smarta*s.  Please
don't laugh at me too hard, but you can log this as Friday Humor is you
like.
 
As I stated, it was many years ago, and people were still trying to
unsubscribe via the list.  I got sick and tired of people not reading
the bottom of the email, and sending garbage to the list, so I set up a
rule in Outlook that would send an auto response to the individual, and
would delete the email.  All worked well for many months, and I was
quite proud of myself.  One day, I had decided to burn a vacation day
and just fiddle around the house.  It was an early spring day, so I did
my thing outside the house, thinking everything was right in the world.
Unbeknown to me, there was an individual that was going to destroy that
by sending an UNSUBSCRIBE message, then turn on his out of office rule
on.
 
The email came in to the list, with the subject line, UNSUBSCRIBE.  The
email made to my machine, quietly using its rules to sort through my
email when this email came in.  My rule caught the offender and replied,
telling the owner of the email how to properly leave the list.  Well, he
had his out of office set, as he must have found the outdoors as
appealing as I did.  His reply came back to me, telling me that he was
out of office for the rest of the day.  Getting a response like that was
fine, my rules were ready, but the problem was, his out of office reply
kept the UNSUBSCRIBE in the subject line.  My rules didn't like the
reply and did it's thing.  The email bounced back to this individuals
inbox and his out of office reply responded yet again.  I hope you all
see where this is going.
 
I forgot to mention that this individual worked at a military
installation that few have heard of.  Well, after about ten minutes and
6,000 emails later, a big dog at this installation called here.  After a
bit was passed to an individual in our security department.  The person
in the security department knew me, so called right away.  The
conversation went something like this:
 
"Hello?"
"Darrell, do you know so and so from blah blah?"
"Nope, never heard of him."
"Well, can you explain why you just emailed him 6,000 times in less than
10 minutes, taking down a government's exchange server that we are not
supposed to know about?"
"Uh, maybe my auto rules caught something, and they have something
similar on their end.  I'm not in, so I know it wasn't me personally
that emailed this guy."
"Well, we are at a loss to do, we need to stop the looping.  The
government isn't too happy."
"Unplug my network connection."
"Ok, bye."
 
He went to my computer and yanked the power cord out of the wall.
 
We talked later and had a good laugh about it.  I made cracks about
black choppers hovering in my backyard.
 

Darrell Reading Systems Engineer 
Phone 479.204.5739 
[EMAIL PROTECTED] 

Wal-Mart Stores, Inc. 
805 Moberly Lane, MS-0560-68 
Bentonville, AR 72716 
Save Money. Live Better 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer
Sent: Friday, March 07, 2008 11:23
To: arslist@ARSLIST.ORG
Subject: Re: UNSUBSCRIBE


** 
lol ... sometimes I cannot skip a chance for a smarta*s response


 
On Fri, Mar 7, 2008 at 10:11 AM, Sanford, Claire
<[EMAIL PROTECTED]> wrote:


** 
Susan like Pat Zandi can never leave us!!!



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Howard Richter
Sent: Thursday, March 06, 2008 7:52 PM
To: arslist@ARSLIST.ORG
Subject: Re: UNSUBSCRIBE


** 
Susan,
 
I thought you were going to get off the list and my world was
ending..
 
hbr


On Thu, Mar 6, 2008 at 6:37 PM, Susan Palmer
<[EMAIL PROTECTED]> wrote:


** Read the bottom of the email


On Thu, Mar 6, 2008 at 2:12 PM, Benitz, Tony : CO IR
<[EMAIL PROTECTED]> wrote:


How do I get off the list.  I am not doing
Remedy any longer and the there is a lot of action on this list.

Thanks.. Tony Benitz



From: Action Request System discussion
list(ARSList) on behalf of Thomas Bean
Sent: Thu 3/6/2008 12:07 PM
To: arslist@ARSLIST.ORG
Subject: Re: Pattern of $MENU$


**
Andy,
What search qualification do you have defined in
the menu attached to the character field?
 

Re: Users of Remedy Knowledge Management 7.1 Patch

[Joe D'Souza]

We have a development environment at this customer site but their policies
do not let us 'try' a new version for the sake of trying it. So until they
do decide they have the time (and money) to go upto 7.2, I cannot try it,
unless we come across something that's a show stopper in 7.1, and that is
resolved in 7.2. So far that hasn't really happened.

I actually had better luck with using Right Answers, I did have a call with
Remedy about it and when they gave me a doc on how to do it, I pretty much
had no problems using those instructions.. There was a small bug on one of
their documentations, but managed to work around that myself without their
help.. If you put all the files in the right places and tweak the .fte files
and the KMS_config.xml file as required it works like a charm..

TIP: I do however prefer indexing the content using the Hummingbird
administration console instead of the Remedy interface as I have seen Tomcat
crash on me while indexing using the Remedy interface.. Hummingbird has
pretty much worked for me even at a point when I had installed so much
content from Right Answers that it took it about 4 hours to finish indexing
the content.. This was the stage that Tomcat often crashed on me if I tried
indexing the content from the RKM console..

I did need their help on other things though like customizing templates,
customizing look and feel in terms of result lists, customizing statuses
etc. But had no problems duplicating it in the end to end environment..

Cheers

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of strauss
  Sent: Friday, March 07, 2008 1:07 AM
  To: arslist@ARSLIST.ORG
  Subject: Re: Users of Remedy Knowledge Management 7.1 Patch


  **
  I'm hoping that it is a configuration setting that I missed since I am
working on so many completely different systems and modules almost
simultaneously.  I'm mad that I didn't notice sooner, and I am not prepared
to roll back to a 7.1 system since we have converted all of our content and
linked it all as FAQs to our helpdesk web, and to some of our Kinetic
Request Service Items.  Since the self help portal works, and support staff
can all log in, we will limp into production with this fault if we have to,
but I'm hoping they find a fix for it (or a knob I did not turn in December
when I installed it - which took a week and several support calls to
accomplish).

  Do you have a dev server you can bring 7.2 up on to test in your
environment?  I would still do that, if I were you.  There are improvements
in 7.2 that you will want, but like every RKM release your install will
probably fail initially. My experience has been that every new install or
upgrade requires at least one webex with Darren to clean up all of the
issues with stuff that's wrong in the installer, not documented, or makes a
bad assumption about the environment - plus any mistakes I have made on my
own.  Then another webex to get the Right Answers content indexed...  you
might was well get started.
  Christopher Strauss, Ph.D.
  Call Tracking Administration Manager
  University of North Texas Computing & IT Center
  http://itsm.unt.edu/




From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza
Sent: Thursday, March 06, 2008 11:37 PM
To: arslist@ARSLIST.ORG
Subject: Re: Users of Remedy Knowledge Management 7.1 Patch


**
And they told me to go to 7.2 because its resolved outstanding issues!!!
That would have been a show stopper for us if we went in for 7.2 as our
users are authenticating on LDAP Thank you so much for that
information.. You probably saved me my neck as I was almost at that point
where I wanted to recommend that we go to 7.2 because of all these issues!

Is there a software defect bug that they have raised?? Could you update
me on that defect ID if they give you one??

Cheers

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of strauss
  Sent: Friday, March 07, 2008 12:00 AM
  To: arslist@ARSLIST.ORG
  Subject: Re: Users of Remedy Knowledge Management 7.1 Patch


  **
  Here's an interesting twist we caught today during acceptance testing
on the pre-production system:

  Our RKM 7.2 server allows users to log in who have local passwords in
ARS, or anonymous through the Self-Service portal.  It refuses users who
rely on AREA LDAP authentication with the error "Invalid login.  Please try
again.", even though they have a valid authentication event logged in the
aruser.log and arplugin.log.  We have never seen this on the 7.1.01.001
system we still have set up with our development server.

  More whack-a-mole
  Christopher Strauss, Ph.D.
  Call Tracking Administration Manager
  University of North Texas Com

Re: Remove duplicate email address from a String

[Thad K Esser]

Sorry folks, OCD is kicking in.  :-)

Darshana,
If you were to get the same email address for three or more iterations in 
a row, you'd end up with triple commas, which isn't accounted for in my 
original post.  Its probably best to clean up the double commas as you go, 
thereby ensuring we never get more than two in a row.  So, in your AL that 
does the looping: 
Set Fields, SQL: SELECT CONTACT_EMAIL FROM [EMAIL PROTECTED] 
WHERE  CONTACT_ID = '$Col_C_ContactID$' 
Set MTNNS_primary_client_contact_email = 
REPLACE(REPLACE($MTNNS_primary_client_contact_email$, 
LOWER($1$),"") + "," + LOWER($1$) , ",,",",")  

You'll still need to clip the leading comma after the loop is complete.

Thad Esser
Remedy Developer
"Argue for your limitations, and sure enough, they're yours."-- Richard 
Bach



"Thad K Esser" <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" 

03/07/2008 10:14 AM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Re: Remove duplicate email address from a String






** 
Darshana, 

Along the lines of Frank's suggestion, how about the following: 

In your AL that does the looping: 
Set Fields, SQL: SELECT CONTACT_EMAIL FROM [EMAIL PROTECTED] 
WHERE  CONTACT_ID = '$Col_C_ContactID$' 
MTNNS_primary_client_contact_email = 
REPLACE($MTNNS_primary_client_contact_email$, LOWER($1$),"") + "," + 
LOWER($1$) 

This will replace the email address with a null if its there (it does 
nothing if its not) and then adds it to the end.  The LOWER() is just 
there in case your email addresses have mixed cases.  You can use $1$ 
without storing it in a temp field ("Email" in your example), unless you 
need it for some other purpose.  It also gets rid of the $Val1$ and $Val2$ 
temp fields. 

Then, once your loop is complete, do one more set fields to clean up any 
duplicate commas: 
MTNNS_primary_client_contact_email = 
REPLACE($MTNNS_primary_client_contact_email$, ",,",",") 

Oh, and unless you are handling it somewhere else, your code will cause 
the list to start with a comma (so will the above).  You'll want to clip 
that off: 
MTNNS_primary_client_contact_email = 
SUBSTR($MTNNS_primary_client_contact_email$, 1) 
(substrings are zero-indexed, so starting at 1 skips the first char, which 
we know is a comma, and without the third parameter it'll return the rest 
of the string) 

For that matter, combine the last two set fields into one: 
MTNNS_primary_client_contact_email = 
SUBSTR(REPLACE($MTNNS_primary_client_contact_email$, ",,",",") , 1) 

I hope that helps. 

Thad Esser
Remedy Developer
"Argue for your limitations, and sure enough, they're yours."-- Richard 
Bach 


"Darshana Jivan [MTN Network Solutions]" <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" 
 
03/07/2008 06:34 AM 

Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG 
cc

Subject
Remove duplicate email address from a String








** 
Hi, 
  
Please can someone assist me with the following. 
  
I want to remove duplicate email addresses in a string. I cannot create a 
view with the distinct values as I need the unique id?s of the record 
therefore the only option I do have is to try and remove duplicate 
occurrences after the 1st occurrence of an email address. 
  
This is the following process that I am using but I know that the last set 
fields with the replace function is not doing what I require it to do and 
there is where I need some assistance. 
  
I have a AL that fetches and email address and concatenates it to a string 
in a loop. 
SQL Command: SELECT CONTACT_EMAIL FROM [EMAIL PROTECTED] WHERE 
CONTACT_ID = '$Col_C_ContactID$' 
Set Fields 1: Email 
$1$ 
Set Fields 2: MTNNS_primary_client_contact_email 
($MTNNS_primary_client_contact_email$ +  ",") + $Email$ 
  
I then have another AL that does the following when it finds a match of an 
email address in the string ?MTNNS_primary_client_contact_email? 
Set Fields 1: Val1 
STRSTR($MTNNS_primary_client_contact_email$, $Email$) 
Set Fields 2: Val2 
LENGTH($Email$) 
Set Fields 3: 
REPLACE($MTNNS_primary_client_contact_email$, 
SUBSTR($MTNNS_primary_client_contact_email$, $Val1$, $Val2$),  "") 
  
In essence if I have a table with the following email addresses and when 
its looped through the string or the value I am looking for is 
[EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] the duplicate 
occurrence should be extracted from the string. 
  
[EMAIL PROTECTED] 
[EMAIL PROTECTED] 
[EMAIL PROTECTED] 
[EMAIL PROTECTED]
[EMAIL PROTECTED] 
  
  
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___ 
***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 t

Re: UNSUBSCRIBE

[Warren Baltimore]

Gee Darrell, Guantanomo is so nice this time of year!

Warren


On 3/7/08, Darrell Reading <[EMAIL PROTECTED]> wrote:
>
> ** *Let me share with the list what I did a number of years ago in direct
> relationship to the subject above and trying to be a smarta*s.  Please don't
> laugh at me too hard, but you can log this as Friday Humor is you like.*
> **
> *As I stated, it was many years ago, and people were still trying to
> unsubscribe via the list.  I got sick and tired of people not reading the
> bottom of the email, and sending garbage to the list, so I set up a rule in
> Outlook that would send an auto response to the individual, and would delete
> the email.  All worked well for many months, and I was quite proud of
> myself.  One day, I had decided to burn a vacation day and just fiddle
> around the house.  It was an early spring day, so I did my thing outside the
> house, thinking everything was right in the world.  Unbeknown to me, there
> was an individual that was going to destroy that by sending an UNSUBSCRIBE
> message, then turn on his out of office rule on.*
> **
> *The email came in to the list, with the subject line, UNSUBSCRIBE.  The
> email made to my machine, quietly using its rules to sort through my email
> when this email came in.  My rule caught the offender and replied, telling
> the owner of the email how to properly leave the list.  Well, he had his out
> of office set, as he must have found the outdoors as appealing as I did.
> His reply came back to me, telling me that he was out of office for the rest
> of the day.  Getting a response like that was fine, my rules were ready, but
> the problem was, his out of office reply kept the UNSUBSCRIBE in the subject
> line.  My rules didn't like the reply and did it's thing.  The email bounced
> back to this individuals inbox and his out of office reply responded yet
> again.  I hope you all see where this is going.*
> **
> *I forgot to mention that this individual worked at a military
> installation that few have heard of.  Well, after about ten minutes and
> 6,000 emails later, a big dog at this installation called here.  After a bit
> was passed to an individual in our security department.  The person in the
> security department knew me, so called right away.  The conversation went
> something like this:*
> **
> *"Hello?"*
> *"Darrell, do you know so and so from blah blah?"*
> *"Nope, never heard of him."*
> *"Well, can you explain why you just emailed him 6,000 times in less than
> 10 minutes, taking down a government's exchange server that we are not
> supposed to know about?"*
> *"Uh, maybe my auto rules caught something, and they have something
> similar on their end.  I'm not in, so I know it wasn't me personally that
> emailed this guy."*
> *"Well, we are at a loss to do, we need to stop the looping.  The
> government isn't too happy."*
> *"Unplug my network connection."*
> *"Ok, bye."*
> **
> *He went to my computer and yanked the power cord out of the wall.*
> **
> *We talked later and had a good laugh about it.  I made cracks about black
> choppers hovering in my backyard.*
> **
>
> *Darrell Reading Systems Engineer*
> Phone 479.204.5739
> [EMAIL PROTECTED]
>
> Wal-Mart Stores, Inc.
> 805 Moberly Lane, MS-0560-68
> Bentonville, AR 72716
> *Save Money. Live Better*
>
>
>  --
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Susan Palmer
> *Sent:* Friday, March 07, 2008 11:23
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: UNSUBSCRIBE
>
>
>  ** lol ... sometimes I cannot skip a chance for a smarta*s response
>
>
>
> On Fri, Mar 7, 2008 at 10:11 AM, Sanford, Claire <
> [EMAIL PROTECTED]> wrote:
>
> > ** *Susan like Pat Zandi can never leave us!!!*
> >
> >  --
> > *From:* Action Request System discussion list(ARSList) [mailto:
> > [EMAIL PROTECTED] *On Behalf Of *Howard Richter
> > *Sent:* Thursday, March 06, 2008 7:52 PM
> > *To:* arslist@ARSLIST.ORG
> > *Subject:* Re: UNSUBSCRIBE
> >
> >
> >   ** Susan,
> >
> > I thought you were going to get off the list and my world was ending..
> >
> > hbr
> >
> >
> > On Thu, Mar 6, 2008 at 6:37 PM, Susan Palmer <[EMAIL PROTECTED]>
> > wrote:
> >
> > > ** Read the bottom of the email
> > >
> > > On Thu, Mar 6, 2008 at 2:12 PM, Benitz, Tony : CO IR <[EMAIL PROTECTED]>
> > > wrote:
> > >
> > > > How do I get off the list.  I am not doing Remedy any longer and the
> > > > there is a lot of action on this list.
> > > >
> > > > Thanks.. Tony Benitz
> > > >
> > > > 
> > > >
> > > > From: Action Request System discussion list(ARSList) on behalf of
> > > > Thomas Bean
> > > > Sent: Thu 3/6/2008 12:07 PM
> > > > To: arslist@ARSLIST.ORG
> > > > Subject: Re: Pattern of $MENU$
> > > >
> > > >
> > > > **
> > > > Andy,
> > > > What search qualification do you have defined in the menu attached
> > > > to the character field?
> > > >
> > > > --Thomas
> > > >
> > > >
> > > 

OT:Friday Befuddlement

[J.T. Shyman]

I ran across this one yesterday and it had me laughing.

 

For those of you that have MS Word 2003.open a document, type the word
information and ask it for synonyms or look them up in the built-in
thesaurus. 

 

Then, realize that this fits perfectly with Microsoft's corporate vision.

 

--- J.T. Shyman

 

 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Friday Befuddlement

[Opela, Gary L Contr OC-ALC/ITMA]

Wow, that was funny. It took a guy sitting beside me to figure out why
MS listed the list they listed.. I just caught that it didn't make any
sense.

Thanks,


Gary Opela, Jr

Sr. Remedy Developer

Leader Communications, Inc.

405 736 3211


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman
Sent: Friday, March 07, 2008 1:18 PM
To: arslist@ARSLIST.ORG
Subject: OT:Friday Befuddlement

** 

I ran across this one yesterday and it had me laughing.

 

For those of you that have MS Word 2003...open a document, type the word
information and ask it for synonyms or look them up in the built-in
thesaurus. 

 

Then, realize that this fits perfectly with Microsoft's corporate
vision.

 

--- J.T. Shyman

 

 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Remedy SSO Implementation - Help needed

[Tim Richardson]

Hello Thivagar,
  Yes, I am doing this for version 7 and while I don't have everything working 
yet, I did run into this problem and solved it.
  Try adding MidTier.jar to your classpath.
  My execution looks like this:
   
  javac -classpath arapi71.jar:MidTier.jar:. MyParticularAuthenticator.java
   
  Like I said, I don't have it working all the way as I still have a missing 
library, but when I added MidTier.jar, the error you have went away.
   
  Good luck with it and if you do get it work (or if i do) let's share.
  
Tim

Thivagar Sankaran <[EMAIL PROTECTED]> wrote:
  **   st1\:*{behavior:url(#default#ieooui) }Hi List,
   
  I am into the process of implementing SSO. I have the architecture as below: 

ARS 6.3 
Windows Server 2003 
Web Server – Sun Apps Server
  Mid Tier 6.3
  I wanted to create a custom SSO. When I read into the white paper from 
remedy, they have asked to create a java file. I created a java file called 
AreaLdapAuthenticator from the sample they attached. I experience some problems 
while compiling the AreaLdapAuthenticator.java file.
  I execute the following command -
  javac -classpath "C:\Sun\AppServer\lib\j2ee.jar" AreaLdapAuthenticator.java
  And get the following errors -
  C:\Documents and Settings\Administrator\Desktop>javac 
AreaLdapAuthenticator.java
  AreaLdapAuthenticator.java:11: package com.remedy.arsys.session does not exist
import com.remedy.arsys.session.Authenticator;
^
AreaLdapAuthenticator.java:12: package com.remedy.arsys.session does not exist
import com.remedy.arsys.session.UserCredentials;
^
AreaLdapAuthenticator.java:14: cannot resolve symbol
symbol  : class Authenticator
location: class com.naviline.ssoAreaLdap.AreaLdapAuthenticator
public class AreaLdapAuthenticator implements Authenticator {
  ^
AreaLdapAuthenticator.java:23: cannot resolve symbol
symbol  : class UserCredentials
location: class com.naviline.ssoAreaLdap.AreaLdapAuthenticator
public UserCredentials getAuthenticatedCredentials(HttpServletRequest 
request, HttpServletResponse response) throws IOException {
   ^
AreaLdapAuthenticator.java:47: cannot resolve symbol
symbol  : class UserCredentials
location: class com.naviline.ssoAreaLdap.AreaLdapAuthenticator
return new UserCredentials(user,"recipe",null);
   ^
5 errors
  Did I miss something in class path? Please help me to sort this out.
  Thanks & Regards,
Thivagar Sankaran
Remedy Team
   

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Daylight Saving Time - in AR

[Andrew Fremont]

Hi,

Since the DST is coming this weekend, I'm not sure if there is any
affect/change we need to do on the AR server? I think AR just relies on the
OS to fix it out, but want to double check.

We have two servers with AR
6.3 patch 20
7.0.1 patch5.

Thanks,
AF

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Daylight Saving Time - in AR

[Nall, Roger]

That should have been done last year as this is year two of the new
dates. If you did not have any problems in the fall you should be okay.
That means you are patched.

 

Roger A. Nall 
Manager, OSSNMS Remedy 
T-Mobile, USA 
Desk: 813-348-2556 
Cell: 973-652-6723 
FAX: 813-348-2565 
sf49fanv AIM IM 
RogerNall Yahoo IM 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Andrew Fremont
Sent: Friday, March 07, 2008 3:13 PM
To: arslist@ARSLIST.ORG
Subject: Daylight Saving Time - in AR

 

** Hi,

Since the DST is coming this weekend, I'm not sure if there is any
affect/change we need to do on the AR server? I think AR just relies on
the OS to fix it out, but want to double check.

We have two servers with AR
6.3 patch 20
7.0.1 patch5.

Thanks,
AF
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Daylight Saving Time - in AR

[Easter, David]

Tech Bulletins on DST are posted at Support Central:
 
7.0.01: http://www.bmc.com/supportu/documents/87/89/68789/68789.pdf
 
6.3: http://www.bmc.com/supportu/documents/87/90/68790/68790.pdf
 
The only issue not addressed at your present patch level is this:
The following defect is a known issue in AR System that is not fixed in
the AR System 6.03 Patch 20. The defect is corrected in AR System 6.03
Patch 21.

Defect ID SW00257017

Description

 For customers in the Atlantic (AST) and Newfoundland (NST) timezones,
mid tier (web) results vary for the Date/Time field between the "old"
DST window and the "new" DST window in the search results panel and in
forms.

-David J. Easter
Sr. Product Manager, Service Management Business Unit
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.
 


From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger
Sent: Friday, March 07, 2008 12:15 PM
To: arslist@ARSLIST.ORG
Subject: Re: Daylight Saving Time - in AR


** 

That should have been done last year as this is year two of the new
dates. If you did not have any problems in the fall you should be okay.
That means you are patched.

 

Roger A. Nall 
Manager, OSSNMS Remedy 
T-Mobile, USA 
Desk: 813-348-2556 
Cell: 973-652-6723 
FAX: 813-348-2565 
sf49fanv AIM IM 
RogerNall Yahoo IM 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Andrew Fremont
Sent: Friday, March 07, 2008 3:13 PM
To: arslist@ARSLIST.ORG
Subject: Daylight Saving Time - in AR

 

** Hi,

Since the DST is coming this weekend, I'm not sure if there is any
affect/change we need to do on the AR server? I think AR just relies on
the OS to fix it out, but want to double check.

We have two servers with AR
6.3 patch 20
7.0.1 patch5.

Thanks,
AF
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Find a field by ID

[strauss]

Be careful when you get to ITSM 7 (where HPD:HelpDesk becomes HPD:Help
Desk).  There is no administrator view, and the closest thing to it is
the Default User View, from which you can see that over 400 fields in
the form are not instantiated in ANY view!!

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing & IT Center
http://itsm.unt.edu/ 

> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:[EMAIL PROTECTED] On Behalf Of Seth Wrye
> Sent: Friday, March 07, 2008 9:47 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: Find a field by ID
> 
> Melissa,
> I would avoid the two suggestions because of the implications 
> involved with the "what if's".  Since the form you are 
> searching on (HPD:HelpDesk) is an OOTB form, all OOTB fields 
> will be listed in the Administrator view.  From there you can 
> add the field to another view, but I would be weary of 
> problems caused by inadvertently hitting save or creating 
> performance issues by creating another view.  
>  
> Seth Wrye
> 
> 
> 
> From: Action Request System discussion list(ARSList) on 
> behalf of Mary Dollus
> Sent: Fri 3/7/2008 10:32 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: Find a field by ID
> 
> 
> ** 
> 
> Hi Melissa,
> 
>  
> 
> I sort of do the same thing as Ben with one exception.  I do 
> a new view and pull all the fields into it.  That way if 
> something inadvertently crashes or messes up, I don't have to 
> worry about it affecting the main form. 
> 
>  
> 
> Take care,
> 
> Mary Dollus
> 
> generationE Technologies
> 
>  
> 
> 
> 
> From: Action Request System discussion list(ARSList) 
> [mailto:[EMAIL PROTECTED] On Behalf Of Ben Cantatore
> Sent: Friday, March 07, 2008 9:17 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: Find a field by ID
> 
>  
> 
> **
> Melissa, 
> 
> Just do the following: 
> 
> 1.Go into the form you want to find the field on 
> 
> 2.Select Form\current view\fields in view  from the menu 
> 
> 3.Highlight all the fields on the left and then click add 
> this will push them all to the right side 
> 
> 4.Click ok 
> 
> 5.You'll have a mess in the upper left hand corner of the 
> screen, use the find field or ID drop downs at the top to 
> find the field you need. 
> 
> 6.Click Field properties after you've selected the field 
> you need and look up the name 
> 
> 7.DON'T Save the form, exit and close without saving 
> 
> 8.Go back into the form and follow steps 1 and 2 and then 
> push over only the field name that you've identified from step 6 
> 
> 
> Hope that helps. 
> 
> Ben Cantatore
> Remedy Administrator
> Avon
> (914) 935-2946 
> 
> 
> 
> SUBSCRIBE arslist Melissa <[EMAIL PROTECTED]> Sent 
> by: "Action Request System discussion list(ARSList)" 
>  
> 
> 03/07/2008 10:04 AM 
> 
> Please respond to
> arslist@ARSLIST.ORG
> 
> To
> 
> arslist@ARSLIST.ORG 
> 
> cc
> 
>  
> 
> Subject
> 
> Find a field by ID
> 
>  
> 
>  
> 
>  
> 
> 
> 
> 
> **
> This may be a silly question, but how can I find a field by 
> the ID number if it's not in the view?  Looking for a field 
> on HPD:HelpDesk by the Field ID and it's not in the FindID drop down. 
> 
> Thanks! 
> Melissa __Platinum Sponsor: www.rmsportal.com ARSlist: "Where 
> the Answers Are" html___ __Platinum Sponsor: 
> www.rmsportal.com ARSlist: "Where the Answers Are" html___
> 
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the 
> Answers Are" html___ 
> 
> __
> _
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> 
> 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: OT:Friday Befuddlement

[Joanne Mansur]

FYI - Does the same thing in Word 2007.

Joanne Mansur
Client Systems Analyst
Northeastern University
Phone\617.373.3295
Fax\617.373.5985
[EMAIL PROTECTED] 



"J.T. Shyman" <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" 

03/07/2008 02:17 PM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
[ARSLIST] OT:Friday Befuddlement






** 
I ran across this one yesterday and it had me laughing.
 
For those of you that have MS Word 2003?open a document, type the word 
information and ask it for synonyms or look them up in the built-in 
thesaurus. 
 
Then, realize that this fits perfectly with Microsoft?s corporate vision.
 
--- J.T. Shyman
 
 
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Friday Befuddlement

[Joe D'Souza]

I have Word 2000... does it work with that?

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Opela, Gary L Contr OC-ALC/ITMA
Sent: Friday, March 07, 2008 2:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Friday Befuddlement


Wow, that was funny. It took a guy sitting beside me to figure out why MS
listed the list they listed.. I just caught that it didn't make any sense.

Thanks,


Gary Opela, Jr

Sr. Remedy Developer

Leader Communications, Inc.

405 736 3211


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman
Sent: Friday, March 07, 2008 1:18 PM
To: arslist@ARSLIST.ORG
Subject: OT:Friday Befuddlement

**

I ran across this one yesterday and it had me laughing.



For those of you that have MS Word 2003...open a document, type the word
information and ask it for synonyms or look them up in the built-in
thesaurus.



Then, realize that this fits perfectly with Microsoft's corporate vision.



--- J.T. Shyman
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.518 / Virus Database: 269.21.6/1318 - Release Date: 3/7/2008
2:01 PM

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: OT:Friday Befuddlement

[John Atherly]

For us with different version what does it say?


John Atherly
American Power Conversion
[EMAIL PROTECTED]
401-789-5735 Ext. 2120
1-800-788-2208 Ext. 2120



Joanne Mansur <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" 

03/07/2008 03:49 PM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Re: OT:Friday Befuddlement






** 
FYI - Does the same thing in Word 2007. 

Joanne Mansur
Client Systems Analyst
Northeastern University
Phone\617.373.3295
Fax\617.373.5985
[EMAIL PROTECTED] 


"J.T. Shyman" <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" 
 
03/07/2008 02:17 PM 

Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG 
cc

Subject
[ARSLIST] OT:Friday Befuddlement








** 
I ran across this one yesterday and it had me laughing. 
  
For those of you that have MS Word 2003?open a document, type the word 
information and ask it for synonyms or look them up in the built-in 
thesaurus. 
  
Then, realize that this fits perfectly with Microsoft?s corporate vision. 
  
--- J.T. Shyman 
  
  
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___ 
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: OT:Friday Befuddlement

[Darrell Reading]

 
 

Darrell Reading Systems Engineer 
Phone 479.204.5739 
[EMAIL PROTECTED] 

Wal-Mart Stores, Inc. 
805 Moberly Lane, MS-0560-68 
Bentonville, AR 72716 
Save Money. Live Better 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of John Atherly
Sent: Friday, March 07, 2008 15:06
To: arslist@ARSLIST.ORG
Subject: Re: OT:Friday Befuddlement


** 
For us with different version what does it say? 


John Atherly
American Power Conversion
[EMAIL PROTECTED]
401-789-5735 Ext. 2120
1-800-788-2208 Ext. 2120 



Joanne Mansur <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)"
 

03/07/2008 03:49 PM 
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG 
cc
Subject
Re: OT:Friday Befuddlement






** 
FYI - Does the same thing in Word 2007. 

Joanne Mansur
Client Systems Analyst
Northeastern University
Phone\617.373.3295
Fax\617.373.5985
[EMAIL PROTECTED] 


"J.T. Shyman" <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)"
 

03/07/2008 02:17 PM 

Please respond to
arslist@ARSLIST.ORG

To
arslist@ARSLIST.ORG 
cc
Subject
[ARSLIST] OT:Friday Befuddlement








** 
I ran across this one yesterday and it had me laughing. 
 
For those of you that have MS Word 2003...open a document, type the word
information and ask it for synonyms or look them up in the built-in
thesaurus. 
 
Then, realize that this fits perfectly with Microsoft's corporate
vision. 
 
--- J.T. Shyman 
 
  

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___




-
**
This email and any files transmitted with it are confidential and
intended solely for the individual or entity to whom they are
addressed. If you have received this email in error destroy it
immediately.
**
Wal-Mart Confidential
**


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"<>

Re: OT:Friday Befuddlement (U)

[Hennigan, Sandra H CTR OSD-CIO]

UNCLASSIFIED

Word provides the synonym for "in" "formation"

Meaning - in order

With suggested replacements:
In order
In sequence
In turn
In rank
In a row

Sandra Hennigan

OSD Enterprise Remedy Administrator
Office # 703-602-2525 x248

Apparently, there is nothing that cannot happen today.  Mark Twain

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of John Atherly
Sent: Friday, March 07, 2008 4:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: OT:Friday Befuddlement


** 
For us with different version what does it say? 


John Atherly
American Power Conversion
[EMAIL PROTECTED]
401-789-5735 Ext. 2120
1-800-788-2208 Ext. 2120 



Joanne Mansur <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)"
 

03/07/2008 03:49 PM 
Please respond to
arslist@ARSLIST.ORG

To
arslist@ARSLIST.ORG 
cc
Subject
Re: OT:Friday Befuddlement






** 
FYI - Does the same thing in Word 2007. 

Joanne Mansur
Client Systems Analyst
Northeastern University
Phone\617.373.3295
Fax\617.373.5985
[EMAIL PROTECTED] 


"J.T. Shyman" <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)"
 

03/07/2008 02:17 PM 

Please respond to
arslist@ARSLIST.ORG

To
arslist@ARSLIST.ORG 
cc
Subject
[ARSLIST] OT:Friday Befuddlement








** 
I ran across this one yesterday and it had me laughing. 
 
For those of you that have MS Word 2003...open a document, type the word
information and ask it for synonyms or look them up in the built-in
thesaurus. 
 
Then, realize that this fits perfectly with Microsoft's corporate
vision. 
 
--- J.T. Shyman 
 
  

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: OT:Friday Befuddlement

[J.T. Shyman]

Probably the same thing. 

 

I just think its quite funny that technology can be so smart and yet so
brainless at the same time. Providing synonyms for "In Formation" (instead
of "Information") does sort of follow Microsoft's view of the world, doesn't
it?: "You'll do it our way and like it."

 

--- J.T. Shyman

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of John Atherly
Sent: Friday, March 07, 2008 4:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: OT:Friday Befuddlement

 

** 
For us with different version what does it say? 


John Atherly
American Power Conversion
[EMAIL PROTECTED]
401-789-5735 Ext. 2120
1-800-788-2208 Ext. 2120 




Joanne Mansur <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)"
 

03/07/2008 03:49 PM 


Please respond to
arslist@ARSLIST.ORG


To

arslist@ARSLIST.ORG 


cc

 


Subject

Re: OT:Friday Befuddlement

 


 

 




** 
FYI - Does the same thing in Word 2007. 

Joanne Mansur
Client Systems Analyst
Northeastern University
Phone\617.373.3295
Fax\617.373.5985
[EMAIL PROTECTED] 


"J.T. Shyman" <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)"
 

03/07/2008 02:17 PM 


Please respond to
arslist@ARSLIST.ORG


To

arslist@ARSLIST.ORG 


cc

 


Subject

[ARSLIST] OT:Friday Befuddlement

 


 

 





** 
I ran across this one yesterday and it had me laughing. 
 
For those of you that have MS Word 2003.open a document, type the word
information and ask it for synonyms or look them up in the built-in
thesaurus. 
 
Then, realize that this fits perfectly with Microsoft's corporate vision. 
 
--- J.T. Shyman 
 
  

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: OT:Friday Befuddlement (U)

[[EMAIL PROTECTED]]

Lists the same words for Word 2002.  

Technically correct but functionally unusable.

Dave

"Hennigan, Sandra H CTR OSD-CIO" <[EMAIL PROTECTED]> wrote: UNCLASSIFIED

Word provides the synonym for "in" "formation"

Meaning - in order

With suggested replacements:
In order
In sequence
In turn
In rank
In a row

Sandra Hennigan

OSD Enterprise Remedy Administrator
Office # 703-602-2525 x248

Apparently, there is nothing that cannot happen today.  Mark Twain

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of John Atherly
Sent: Friday, March 07, 2008 4:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: OT:Friday Befuddlement


** 
For us with different version what does it say? 


John Atherly
American Power Conversion
[EMAIL PROTECTED]
401-789-5735 Ext. 2120
1-800-788-2208 Ext. 2120 



Joanne Mansur  
Sent by: "Action Request System discussion list(ARSList)"
 

03/07/2008 03:49 PM 
Please respond to
arslist@ARSLIST.ORG

To
arslist@ARSLIST.ORG 
cc
Subject
Re: OT:Friday Befuddlement

 




** 
FYI - Does the same thing in Word 2007. 

Joanne Mansur
Client Systems Analyst
Northeastern University
Phone\617.373.3295
Fax\617.373.5985
[EMAIL PROTECTED] 


"J.T. Shyman"  
Sent by: "Action Request System discussion list(ARSList)"
 

03/07/2008 02:17 PM 

Please respond to
arslist@ARSLIST.ORG

To
arslist@ARSLIST.ORG 
cc
Subject
[ARSLIST] OT:Friday Befuddlement


 





** 
I ran across this one yesterday and it had me laughing. 
 
For those of you that have MS Word 2003...open a document, type the word
information and ask it for synonyms or look them up in the built-in
thesaurus. 
 
Then, realize that this fits perfectly with Microsoft's corporate
vision. 
 
--- J.T. Shyman 
 
  

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"


   
-
Be a better friend, newshound, and know-it-all with Yahoo! Mobile.  Try it now.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Using employee ID to log into Remedy (instead of name)

[Rick Westbrock]

Happy Friday, hopefully someone out there has run into this issue
already and can offer some advice. Our company is getting close to
implementing ITIM (IBM Tivoli Identity Management) for the enterprise
which means that instead of logging in with my name (rickw) I will be
forced to log into the domain with my employee ID number (7-digit
integer).

Since we are using Active Directory to authenticate users into Remedy
(including guest users who may submit a new support request using the
mid-tier) this is going to wreak havoc with our system. A lot of it can
be overcome by using shadow fields to hold the username and populating
them with a lookup based on employee ID number. All workflow that
references the USER keyword will be affected so there is going to be a
lot of work involved to get compliant. The biggest drawback to me is
that the default diary field prepend of date/time and username will now
show a 7-digit number instead of a username; I'll be forced to add a
filter to every form that has a diary field to append the user's name to
the end of every diary entry.

But wait, it gets better. How you may ask? In two ways: first we have
existing temporary employees who don't have a company issued ID number
and when they convert to becoming a regular employee they will get a
number. At that time they will have to start logging into the domain &
Remedy with their number instead of their name. All workflow concerns
aside this means that every time someone converts I will have to go back
and update all existing data to change their user name into their
number. I have used a utility in the past to do that as a one-time
process for two users when we first changed Remedy to cross-ref blank
passwords to AD but this will be an ongoing battle. Each time I will
also have to determine which forms to update based on the user's job
function.

The second big problem is that existing users will continue to use their
name to log in for several months but as of some cutoff date (TBD) all
new users will only be issued an employee ID but no login name. This
means that I will somehow have to account for a mixed user base where
some people log in with their name and others with their number.


If anyone has run into a similar situation in the past I would love to
hear from you, either on- or off-list. Even if you haven't personally
been involved with such an endeavor I really value the experience of
everyone on the list so feel free to chime in with your thoughts.


Thanks in advance,

Rick


_
Rick Westbrock
PETCO Store Systems Engineer
[EMAIL PROTECTED]


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Using employee ID to log into Remedy (instead of name)

[Carey Matthew Black]

Rick,

Maybe.

ARS lets use "authenticate" as a different user name than what the
user enters in the Login Name field via the 'Authentication Login
Name' field on the User form. So you could use that feature to set the
employee ID number as the authentication user name and leave the ARS
'Login Name' field the string (rickw).

This may be strange for the users, but they likely will prefer the
English user names to the all digits anyways.

Anyways.. that may be an option for you.


-- 
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.



On Fri, Mar 7, 2008 at 4:41 PM, Rick Westbrock <[EMAIL PROTECTED]> wrote:
> **
>
>
> Happy Friday, hopefully someone out there has run into this issue already
> and can offer some advice. Our company is getting close to implementing ITIM
> (IBM Tivoli Identity Management) for the enterprise which means that instead
> of logging in with my name (rickw) I will be forced to log into the domain
> with my employee ID number (7-digit integer).
>
> Since we are using Active Directory to authenticate users into Remedy
> (including guest users who may submit a new support request using the
> mid-tier) this is going to wreak havoc with our system. A lot of it can be
> overcome by using shadow fields to hold the username and populating them
> with a lookup based on employee ID number. All workflow that references the
> USER keyword will be affected so there is going to be a lot of work involved
> to get compliant. The biggest drawback to me is that the default diary field
> prepend of date/time and username will now show a 7-digit number instead of
> a username; I'll be forced to add a filter to every form that has a diary
> field to append the user's name to the end of every diary entry.
>
> But wait, it gets better. How you may ask? In two ways: first we have
> existing temporary employees who don't have a company issued ID number and
> when they convert to becoming a regular employee they will get a number. At
> that time they will have to start logging into the domain & Remedy with
> their number instead of their name. All workflow concerns aside this means
> that every time someone converts I will have to go back and update all
> existing data to change their user name into their number. I have used a
> utility in the past to do that as a one-time process for two users when we
> first changed Remedy to cross-ref blank passwords to AD but this will be an
> ongoing battle. Each time I will also have to determine which forms to
> update based on the user's job function.
>
> The second big problem is that existing users will continue to use their
> name to log in for several months but as of some cutoff date (TBD) all new
> users will only be issued an employee ID but no login name. This means that
> I will somehow have to account for a mixed user base where some people log
> in with their name and others with their number.
>
>
> If anyone has run into a similar situation in the past I would love to hear
> from you, either on- or off-list. Even if you haven't personally been
> involved with such an endeavor I really value the experience of everyone on
> the list so feel free to chime in with your thoughts.
>
>
> Thanks in advance,
>
> Rick
>
>
> _
> Rick Westbrock
> PETCO Store Systems Engineer
> [EMAIL PROTECTED]

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Using employee ID to log into Remedy (instead of name)

[Rick Westbrock]

Thanks Carey, I consider the user experience very important and if I can
pull this off it will go a long way towards resolving my problems. The
users won't have any choice but to key in their number when logging into
the domain and Remedy but if they can see actual names once within
Remedy that would be huge.


-Rick 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black
Sent: Friday, March 07, 2008 2:19 PM
To: arslist@ARSLIST.ORG
Subject: Re: Using employee ID to log into Remedy (instead of name)

Rick,

Maybe.

ARS lets use "authenticate" as a different user name than what the user
enters in the Login Name field via the 'Authentication Login Name' field
on the User form. So you could use that feature to set the employee ID
number as the authentication user name and leave the ARS 'Login Name'
field the string (rickw).

This may be strange for the users, but they likely will prefer the
English user names to the all digits anyways.

Anyways.. that may be an option for you.


--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.



On Fri, Mar 7, 2008 at 4:41 PM, Rick Westbrock <[EMAIL PROTECTED]> wrote:
> **
>
>
> Happy Friday, hopefully someone out there has run into this issue 
> already and can offer some advice. Our company is getting close to 
> implementing ITIM (IBM Tivoli Identity Management) for the enterprise 
> which means that instead of logging in with my name (rickw) I will be 
> forced to log into the domain with my employee ID number (7-digit
integer).
>
> Since we are using Active Directory to authenticate users into Remedy 
> (including guest users who may submit a new support request using the
> mid-tier) this is going to wreak havoc with our system. A lot of it 
> can be overcome by using shadow fields to hold the username and 
> populating them with a lookup based on employee ID number. All 
> workflow that references the USER keyword will be affected so there is

> going to be a lot of work involved to get compliant. The biggest 
> drawback to me is that the default diary field prepend of date/time 
> and username will now show a 7-digit number instead of a username; 
> I'll be forced to add a filter to every form that has a diary field to
append the user's name to the end of every diary entry.
>
> But wait, it gets better. How you may ask? In two ways: first we have 
> existing temporary employees who don't have a company issued ID number

> and when they convert to becoming a regular employee they will get a 
> number. At that time they will have to start logging into the domain &

> Remedy with their number instead of their name. All workflow concerns 
> aside this means that every time someone converts I will have to go 
> back and update all existing data to change their user name into their

> number. I have used a utility in the past to do that as a one-time 
> process for two users when we first changed Remedy to cross-ref blank 
> passwords to AD but this will be an ongoing battle. Each time I will 
> also have to determine which forms to update based on the user's job
function.
>
> The second big problem is that existing users will continue to use 
> their name to log in for several months but as of some cutoff date 
> (TBD) all new users will only be issued an employee ID but no login 
> name. This means that I will somehow have to account for a mixed user 
> base where some people log in with their name and others with their
number.
>
>
> If anyone has run into a similar situation in the past I would love to

> hear from you, either on- or off-list. Even if you haven't personally 
> been involved with such an endeavor I really value the experience of 
> everyone on the list so feel free to chime in with your thoughts.
>
>
> Thanks in advance,
>
> Rick
>
>
> _
> Rick Westbrock
> PETCO Store Systems Engineer
> [EMAIL PROTECTED]


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum
Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Users of Remedy Knowledge Management 7.1 Patch

[strauss]

Good news!  Support sent me patch 1610 to debug with, since it has
higher resolution logging.  I was able to determine that it was a access
control group error, not an authentication problem, and fix it.
 
We had added a named access control group of 'UNT Customers' to the
access control list since everyone in our system is a member of that
company, but RKM cannot read a long group name, only a group name, and
of course in ITSM 7 some complete idiot decided that group names would
be the same numeric value as the group id.  In 7.1 none of the
company/organization/department group ids (or "names") ever appear, so
we had added an access control group by name.  You have to add
organizational groups by the numeric group name, which is actually the
group id.  In 7.2 in multitenancy mode, all of the organizational group
ids ("names") appear in the access control group list (219 of them in
our case). When I added Rights and Visibility Group permissions of
Self-Help to the group id that corresponds to UNT Customers,
"16," I was finally able to log in with the LDAP-authenticating
account.
 
I'll bet that explains the visibility problem I have with my
RIghtAnswers content; we indexed it using "UNT Customers" instead of
"16" so RKM does not recognize it even though it was defined as
an access control group.

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing & IT Center
http://itsm.unt.edu/ 

 


  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza
Sent: Friday, March 07, 2008 12:59 PM
To: arslist@ARSLIST.ORG
Subject: Re: Users of Remedy Knowledge Management 7.1 Patch


** 
We have a development environment at this customer site but
their policies do not let us 'try' a new version for the sake of trying
it. So until they do decide they have the time (and money) to go upto
7.2, I cannot try it, unless we come across something that's a show
stopper in 7.1, and that is resolved in 7.2. So far that hasn't really
happened.
 
I actually had better luck with using Right Answers, I did have
a call with Remedy about it and when they gave me a doc on how to do it,
I pretty much had no problems using those instructions.. There was a
small bug on one of their documentations, but managed to work around
that myself without their help.. If you put all the files in the right
places and tweak the .fte files and the KMS_config.xml file as required
it works like a charm..
 
TIP: I do however prefer indexing the content using the
Hummingbird administration console instead of the Remedy interface as I
have seen Tomcat crash on me while indexing using the Remedy interface..
Hummingbird has pretty much worked for me even at a point when I had
installed so much content from Right Answers that it took it about 4
hours to finish indexing the content.. This was the stage that Tomcat
often crashed on me if I tried indexing the content from the RKM
console..
 
I did need their help on other things though like customizing
templates, customizing look and feel in terms of result lists,
customizing statuses etc. But had no problems duplicating it in the end
to end environment..
 
Cheers
 
Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of strauss
Sent: Friday, March 07, 2008 1:07 AM
To: arslist@ARSLIST.ORG
Subject: Re: Users of Remedy Knowledge Management 7.1
Patch


** 
I'm hoping that it is a configuration setting that I
missed since I am working on so many completely different systems and
modules almost simultaneously.  I'm mad that I didn't notice sooner, and
I am not prepared to roll back to a 7.1 system since we have converted
all of our content and linked it all as FAQs to our helpdesk web, and to
some of our Kinetic Request Service Items.  Since the self help portal
works, and support staff can all log in, we will limp into production
with this fault if we have to, but I'm hoping they find a fix for it (or
a knob I did not turn in December when I installed it - which took a
week and several support calls to accomplish).
 
Do you have a dev server you can bring 7.2 up on to test
in your environment?  I would still do that, if I were you.  There are
improvements in 7.2 that you will want, but like every RKM release your
install will probably fail initially. My experience has been that every
new install or upgrade requires at least one webex with Darren to clean
up all of the issues with stuff that's wrong in the installer, not
documented, or makes a bad assumption about the environment - plus any
mistakes I have made on my own.  Then ano

Re: Users of Remedy Knowledge Management 7.1 Patch

[Joe D'Souza]

Chris,

You could still keep your indexes and your RKM access control group with the
name "UNT Customers".. But map that to a Role instead of a group and map
that Role to the ID "16". What I would do is create a Role with Role
ID "-16" and the Role Name as "UNT Customers"

To have this new group configurable for a user in the foundation data, add a
record for this role in the "Lic:Sys-License Permissions Map" form. Create a
new record for this Role that you created in this form. The easiest way to
get the right data into this form is look at an existing record for the
Navigation Tier "Knowledge", and duplicate the information but make sure you
have "UNT Customers" in the Permissions Group* field BY SELECTING from the
MENU. Permission Group ID* should automatically populate on selection of the
group.

That should be enough in order for you to have the name instead of the ID..
I have done it and its working pretty good for me..

I do agree with you though that the idea for having ID's instead of names as
groups - there is something retarded about that!

Cheers

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of strauss
  Sent: Friday, March 07, 2008 5:49 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: Users of Remedy Knowledge Management 7.1 Patch


  **
  Good news!  Support sent me patch 1610 to debug with, since it has higher
resolution logging.  I was able to determine that it was a access control
group error, not an authentication problem, and fix it.

  We had added a named access control group of 'UNT Customers' to the access
control list since everyone in our system is a member of that company, but
RKM cannot read a long group name, only a group name, and of course in ITSM
7 some complete idiot decided that group names would be the same numeric
value as the group id.  In 7.1 none of the company/organization/department
group ids (or "names") ever appear, so we had added an access control group
by name.  You have to add organizational groups by the numeric group name,
which is actually the group id.  In 7.2 in multitenancy mode, all of the
organizational group ids ("names") appear in the access control group list
(219 of them in our case). When I added Rights and Visibility Group
permissions of Self-Help to the group id that corresponds to UNT Customers,
"16," I was finally able to log in with the LDAP-authenticating
account.

  I'll bet that explains the visibility problem I have with my RIghtAnswers
content; we indexed it using "UNT Customers" instead of "16" so RKM
does not recognize it even though it was defined as an access control group.
  Christopher Strauss, Ph.D.
  Call Tracking Administration Manager
  University of North Texas Computing & IT Center
  http://itsm.unt.edu/






From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza
Sent: Friday, March 07, 2008 12:59 PM
To: arslist@ARSLIST.ORG
Subject: Re: Users of Remedy Knowledge Management 7.1 Patch


**
We have a development environment at this customer site but their
policies do not let us 'try' a new version for the sake of trying it. So
until they do decide they have the time (and money) to go upto 7.2, I cannot
try it, unless we come across something that's a show stopper in 7.1, and
that is resolved in 7.2. So far that hasn't really happened.

I actually had better luck with using Right Answers, I did have a call
with Remedy about it and when they gave me a doc on how to do it, I pretty
much had no problems using those instructions.. There was a small bug on one
of their documentations, but managed to work around that myself without
their help.. If you put all the files in the right places and tweak the .fte
files and the KMS_config.xml file as required it works like a charm..

TIP: I do however prefer indexing the content using the Hummingbird
administration console instead of the Remedy interface as I have seen Tomcat
crash on me while indexing using the Remedy interface.. Hummingbird has
pretty much worked for me even at a point when I had installed so much
content from Right Answers that it took it about 4 hours to finish indexing
the content.. This was the stage that Tomcat often crashed on me if I tried
indexing the content from the RKM console..

I did need their help on other things though like customizing templates,
customizing look and feel in terms of result lists, customizing statuses
etc. But had no problems duplicating it in the end to end environment..

Cheers

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of strauss
  Sent: Friday, March 07, 2008 1:07 AM
  To: arslist@ARSLIST.ORG
  Subject: Re: Users of Remedy Knowledge Management 7.1 Patch


  **
  I'm

Problems with AR System Server 7.1 installation

[Masha Bench]

  Hi Everyone,
I am, what you would say, brand new to Remedy and excited to get 7.1 working 
sometime soon. :)
Currently we are running Remedy 6.x, that is doing its job fine but I am having 
problems with brand new installation of 7.1 and BMC Support is not being very 
helpful. Here is the deal:
Windows 2003 SP2 on VM Ware
Oracle 10g client and 10g DB on a remote server
AR System Server 7.1
The install goes smoothly until the very end when it tries to start the BMC 
Remedy Action Request System Server Service, the ar_install.log shows:
14:52:07 Trying to start the service: BMC Remedy Action Request System Server
15:02:05 Waited 600 secs for service to start.
15:02:05 ->[ERROR]: Failed to start the service: BMC Remedy Action Request 
System Server
15:02:05 ->[ERROR]: Unable to start the AR System Server service
15:02:58 ->[ERROR]: The AR System Server could not be started. You can 
start it manually using the Services icon in the Control Panel.

This error occurred after the installation of the AR System was completed.
To correct this error, import the sample applications from the samples 
subdirectory.
15:02:59 ->[ERROR]: Failed to complete AR Server installation.
>From the arerror.log I get
Fri Mar 07 14:52:09 2008  390695 : Unable to extract minor version from Java VM 
version string: 10.0-b19 (ARERR 9130)
Fri Mar 07 14:52:09 2008 : Action Request System(R) Server Version 7.1.00 Build 
200708221849
(c) Copyright 1991-2007 BMC Software, Inc.
Fri Mar 07 14:52:09 2008  390600 : Failure while trying to connect to the SQL 
database.

Please ensure the SQL database is running or contact the Database Administrator 
for help (ARERR 550)

Fri Mar 07 14:52:09 2008 ORA-01017: invalid username/password; logon denied

Fri Mar 07 14:52:09 2008  390600 : Cannot initialize contact with SQL database 
(ARERR 551)

Fri Mar 07 14:52:09 2008 Stop server

Fri Mar 07 14:52:09 2008  390600 : AR System server terminated -- fatal error 
encountered (ARNOTE 21)
So clearly AR Server can't connect to the Oracle db, BUT it had just created 
the tables in it without any problems.  I can connect to the DB from the server 
itself with the AR admin account no problem.
Any help is appreciated.
Thank you,


Mariya (Masha) Bench
Solutions Engineer
Office of Information Technology, BYU
801-422-3323
801-372-6221
[EMAIL PROTECTED]



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
<>

Re: 7.1 Java api

[LJ Longwing]

Well...I haven't personally experienced this, but based on the reading that
I have done on load balancing, and client connections, you can't do it
reliably without persistent sessions (sticky bits) because the server
expects you to already have a session active, so you can't just issue a
command to the server without first opening a session 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Axton
Sent: Friday, March 07, 2008 8:40 AM
To: arslist@ARSLIST.ORG
Subject: 7.1 Java api

Has anyone implemented mid-tier 7.1 or other j2ee apps based on the
7.1 java api in a load balanced environment?  If so, can you comment on your
successes/issues without using persistent sessions on the load balancer?

Thanks,
Axton Grams


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:
www.rmsportal.com ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: For anyone using the aradmin.exe command

[LJ Longwing]

Carey,

I'm actually working on a VERY SIMPLE program that could do just what your
looking for, the API parsing of a packing list is absurdly easy, so if you
wanted with a very small modification to my program, you could specify
packing list on server 1, and export the objects from server2, and then
import that def file just created into server3...I would say it took me less
than 5 hours to create the parsing of the PL on one server, to export from a
second, and then import to a third would be a trivial modification...of
course this work is being done to automate/ease migration of release related
work.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black
Sent: Friday, March 07, 2008 10:41 AM
To: arslist@ARSLIST.ORG
Subject: Re: For anyone using the aradmin.exe command

Scott,

Actually... let me see if you can try something for me and see if we can get
that to work...


This is a sore topic for me. I have tried to get BMC to understand how dumb
I think this feature is, but they appear to not share my concern for it.


In the admin tool open the packing list of interest.
Go to the "Packing List" menu and select "Generate XML".

You need to use this "XML" file as the input to the admin tool command line.
NOT an ARS def file (in xml format). [ The def file does not work, but it is
what most people think should work. Most people do not ever look at the
"Packing List" menu because it only shows up when you open a packing list ,
and the terminology is just "XML file" instead of the "special file
generated from the menu of the packing list object via the admin tool".]


My two cents

I should be able to mention the NAME of the packing list and not have any
cached copy of it before the command line is called.

And in my dream world... I can use a packlist as defined on a different ARS
server too. ( Yes that means that I may need to pass in two usersnames and
passwords, but I am ok with that. )

So ... Picture this...


Create a packing list on your Dev server.
>From the command line export those objects from Production.
Import them to your Test server.
Then import your Dev objects (presumably different from Production) to your
Test server.

You now have a way to maintain one list, on dev, of objects that are in a
"release" and a way to use that list to normalize your Test server.

--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.




On Fri, Mar 7, 2008 at 9:57 AM, Scott Philben <[EMAIL PROTECTED]> wrote:
> We found out an interesting bit of information yesterday about the command
line uasge of the aradmin.exe command. On page 557 of the 6.3 Advanced book
Remedy claims the following:
>
>
>  To parse an XML packing list, and export all the objects defined in that
packing list, use the following command format:
>
>  aradmin -u  [-p ] -x  -e 
>  -l 
>
>
>  Well, when we tried to use that command to dump out a packing list worth
of stuff nothing seemed to happen. So I opened an Incident with BMC and come
to find out that the XML packing list thing does not appear to work in any
environment that they can find. I think this is kind of odd since I believe
that this option has been available since at least 5.1.2. I might be wrong.
>
>  So anyway, don't try to dump stuff out of your system via an XML packing
list file (not that you wanted to anyway since I can't find any reference of
anyone else in history having the same problem and posting about it on the
interwebs).
>
>  
> __
> _  UNSUBSCRIBE or access ARSlist Archives at www.arslist.org  
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:
www.rmsportal.com ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Problems with AR System Server 7.1 installation

[LJ Longwing]

is your ARAdmin account password the default?  If not, have the DBA change
it to the default, and try again, ensure that you don't have anything in our
ar.conf/ar.cfg file regarding the DB password, once connected you can set
the password in the DB through the admin tool/admin console in the user tool

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Masha Bench
Sent: Friday, March 07, 2008 5:18 PM
To: arslist@ARSLIST.ORG
Subject: Problems with AR System Server 7.1 installation


** 
 

  Hi Everyone, 

I am, what you would say, brand new to Remedy and excited to get 7.1 working
sometime soon. J

Currently we are running Remedy 6.x, that is doing its job fine but I am
having problems with brand new installation of 7.1 and BMC Support is not
being very helpful. Here is the deal:

Windows 2003 SP2 on VM Ware 

Oracle 10g client and 10g DB on a remote server

AR System Server 7.1 

The install goes smoothly until the very end when it tries to start the BMC
Remedy Action Request System Server Service, the ar_install.log shows:

14:52:07 Trying to start the service: BMC Remedy Action Request System
Server

15:02:05 Waited 600 secs for service to start.

15:02:05 ->[ERROR]: Failed to start the service: BMC Remedy Action
Request System Server

15:02:05 ->[ERROR]: Unable to start the AR System Server service

15:02:58 ->[ERROR]: The AR System Server could not be started. You can
start it manually using the Services icon in the Control Panel.

 

This error occurred after the installation of the AR System was completed.

To correct this error, import the sample applications from the samples
subdirectory.

15:02:59 ->[ERROR]: Failed to complete AR Server installation. 

>From the arerror.log I get 

Fri Mar 07 14:52:09 2008  390695 : Unable to extract minor version from Java
VM version string: 10.0-b19 (ARERR 9130)

Fri Mar 07 14:52:09 2008 : Action Request System(R) Server Version 7.1.00
Build 200708221849

(c) Copyright 1991-2007 BMC Software, Inc. 

Fri Mar 07 14:52:09 2008  390600 : Failure while trying to connect to the
SQL database.

 

Please ensure the SQL database is running or contact the Database
Administrator for help (ARERR 550)

 

Fri Mar 07 14:52:09 2008 ORA-01017: invalid username/password; logon
denied

 

Fri Mar 07 14:52:09 2008  390600 : Cannot initialize contact with SQL
database (ARERR 551)

 

Fri Mar 07 14:52:09 2008 Stop server

 

Fri Mar 07 14:52:09 2008  390600 : AR System server terminated -- fatal
error encountered (ARNOTE 21)

So clearly AR Server can't connect to the Oracle db, BUT it had just created
the tables in it without any problems.  I can connect to the DB from the
server itself with the AR admin account no problem.

Any help is appreciated. 

Thank you, 

 

 

Mariya (Masha) Bench

Solutions Engineer

Office of Information Technology, BYU

801-422-3323

801-372-6221

  [EMAIL PROTECTED]

 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
<>