Re: CI Relationship Viewer - Works for Demo and not for other users. (UNCLASSIFIED)

2008-05-20 Thread Jiri Pospisil
++
Please Read The Disclaimer At The Bottom Of This Email
++

Hi,
 
just to add to this discussion, we have the same issue here.
The CI Viewer only works for users with administrator privileges or when users 
access Remedy through the mid-tier.
I checked the mid-tier log files on our server and found that CI Viewer 
generates the following error message when non-admin user tries to access CI 
Viewer from the PC client
 
MessageType: 2
MessageNum: 9093
MessageText: User is currently connected from another machine

We were advised by support to upgrade the CMDB with the CI viewer to version 
2.0.01 patch 005, which I have not had time to do yet.
 
Jiri Pospisil
LCH.Clearnet

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
Behalf Of Mike Gould
Sent: 19 May 2008 21:08
To: arslist@ARSLIST.ORG
Subject: Re: CI Relationship Viewer - Works for Demo and not for other users. 
(UNCLASSIFIED)



** 
Hi Gordon,
 
The reason that Demo brings up the CI Viewer in the AR User Tool and appadmin 
doesn't is because Demo has Administrator group permissions and appadmin only 
has ITSM Asset Management application role permissions (out-of-the-box).  It 
looks like you just gave your new test appadmin account Administrator 
permissions, which is why it's now working for you.  
 
The problem with the CI Viewer is that it will only run for accounts with 
Administrator rights and displays the The CI Relationship Viewer could not 
open because the specified root CI does not exist. error for all non-Admin 
users.  I recommend you try your test again but this time don't give the user 
Administrator rights and see if you can replicate the error.
 
I know a few have suggested looking at form permissions but unfortunately 
that's not the issue in this instance as non-Admin users can run the CI Viewer 
just fine through their browser once Midtier 7.1.00 Patch 002 is applied but 
not when they try in the User Tool.  The problem seems to reside somewhere in 
some faulty CI Viewer (at least in the 2.0.01 release) code that the User Tool 
is having a hard time processing but was fixed on the Mid-Tier side.
 
I'm still in the process of troubleshooting the problem, which has been on 
going for several months now, with BMC and will let you know when/if a fix is 
found.
 
Have a great afternoon,
Michael Gould
US House of Representatives
 
Solaris 9
Oracle 10g
AR Server 7.0.01 Patch 005
Mid-Tier 7.1.00 Patch 002
Atrium CMDB 2.0.01 Patch 003
ITSM 7.0.03 Patch 005
 
 


 
On Mon, May 19, 2008 at 1:43 PM, FRANK, GORDON CTR DISA JSSC  [EMAIL 
PROTECTED] wrote:


Classification:  UNCLASSIFIED
Caveats: NONE

Thanks for all of your help!

The combination of several feedbacks got me thinking and I actually
solved this problem. I don't know what is being carried my the account
appadmin but it is the key to the solution. appadmin carries ITSM
something that Demo does not. But Demo does bring up the CI Viewer
correctly.

Here are the steps which will work.

1. Collect all information for the new account.
2. Go to the Application Administration Console, People, View
3. Select appadmin Login ID
4. Perform a Copy to New (Ctrl-T or select from toolbar)
5. In the new copy, make all account changes (Login ID, Support Groups
(including Administrator), etc. etc.)
6. Save
7. Login to the new account and the CI Viewer will now work.

Like I said, I don't know what is being carried underneath, but
something is different on appadmin. This procedure seems to work every
time.


Gordon M. Frank
Remedy Skilled Professional - 7.x
ITIL V3 Foundation Certified
DISA\Verizon FNS


-Original Message-
From: Action Request System discussion list(ARSList)

[mailto: [EMAIL PROTECTED] On Behalf Of Joe Bucci
Sent: Monday, May 19, 2008 10:01 AM
To: arslist@ARSLIST.ORG
Subject: Re: CI Relationship Viewer - Works for Demo and not for other
users. (UNCLASSIFIED)

**
Same issues - told to patch CMDB to 2.1, Midtier and thick client.
I am about to do this today.
HTH, Joe

Joe Bucci
cell 703-608-4467

 Date: Sun, 18 May 2008 11:13:29 -0400
 From: [EMAIL PROTECTED]
 Subject: Re: CI Relationship Viewer - Works for Demo and not for other
__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ 


*

This email is intended for the named recipient(s) only. Its contents are  
confidential and may only be retained by the named recipient(s) and may only be 
copied or disclosed with the consent of LCH.Clearnet Limited.   If you are not 
an intended recipient please delete this e-mail and notify [EMAIL PROTECTED]

The contents of this email are subject to contract in all cases, and 
LCH.Clearnet Limited makes no contractual commitment save where confirmed by 
hard copy.  LCH.Clearnet Limited accepts no liability, 

Routing Requests to the correct Categorizations without using the summaries from teh Requestor Console.

2008-05-20 Thread jmchugh
ITSM 7.0.3 patch 7
Remedy ARS Server 7.1 patch 2
MS SQL Server 2005
Windows 2003

Hi,

When using the Requestor Console and submitting ticket I would like to
be able to Categorise and Assign to a particular goup the resultant
incident. This I would like to achieve by not using the summaries drop
down.

Has anyone achieved this and if so how did you go about doing this?

I was thinking of one drop down list of all the deparments. I am not
sure how to proceed from here though.

Thanks
John

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


Backing up Remedy data

2008-05-20 Thread Ravi
Hi: I have a form which stores all the emails that are sent out by AR 
Email engine. I want to back up data older than 3 months on a tape drive 
for upto 3 years. Whatz the best way to back up data so it's available 
for retrieval in case I have to review the old emails? I didn't think I 
could just backup the data in that table from via sqlplus? I want to be 
able to automate the process so end of every month the data for current 
month - 4 months is backed up.


Thanks
Ravi

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


Re: Backing up Remedy data

2008-05-20 Thread Carey Matthew Black
We have used a Perl script that uses the runmacro command line utility
(from our Solaris ARS server) to export data hourly and daily for data
backups from the application level for a few years now.  The down side
to this approach is that we are doing a separate login per ARS Form to
get the data, but we have yet to think we need to do any of this work
in parallel too. (So the process is serially backing up each form as
it loops through the Forms list.) So we know we can cut these times in
about half by just backing up two forms at a time too. Oh and the Perl
script has enough logic added to it to have excluded and mandatory
include lists so that we can totally control what forms are backed up
and when. The script also takes a command line parameter for the query
to use to do the backup task for that set of forms on that specific
run of the script. Anyway... We do occasionally also get timeout
errors in these processes, but since these are our secondary backups
(first backups are RDBMS backups, with transaction logs) we do not
worry about those to much.


FWIW:
Our incremental backups, that gets all data changed that day,
currently can backup about 10788 data rows in 166 ARS Forms in about
10 minutes.

Our nightly full backups backup 3294763 rows in about 5.5 hours for
the same 166 ARS Forms.

We also do a separate once a week full backup for our single largest
form. That currently backs up 2134886 rows and takes about 4.5 hours
for the single form.

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 Tue, May 20, 2008 at 7:19 AM, Ravi [EMAIL PROTECTED] wrote:
 Hi: I have a form which stores all the emails that are sent out by AR Email
 engine. I want to back up data older than 3 months on a tape drive for upto
 3 years. Whatz the best way to back up data so it's available for retrieval
 in case I have to review the old emails? I didn't think I could just backup
 the data in that table from via sqlplus? I want to be able to automate the
 process so end of every month the data for current month - 4 months is
 backed up.

 Thanks
 Ravi

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


Re: Backing up Remedy data

2008-05-20 Thread ITSM Support

*Hi Ravi,*

We can take backup by following ways on tape drive.

Use macro, to complete the tasks

1. write a search criteria for AR Email Message Form.
2. Create a report file for the all searched records.
3. Save it on tape drive and execute your report. 

After that build a batch command for that macro, and schedule it as per 
your requirement.


Using database backup also,we can take Email Messages backup and 
automate it as per the requirement.


Hope this helps...

Regards,

*Sandeep
Vyom Labs Pvt. Ltd.
An ISO 2 certified company.
Consulting | Outsourcing | Training || BMC Remedy BSM | ITIL
Web : www.vyomlabs.com
*


Ravi wrote:
Hi: I have a form which stores all the emails that are sent out by AR 
Email engine. I want to back up data older than 3 months on a tape 
drive for upto 3 years. Whatz the best way to back up data so it's 
available for retrieval in case I have to review the old emails? I 
didn't think I could just backup the data in that table from via 
sqlplus? I want to be able to automate the process so end of every 
month the data for current month - 4 months is backed up.


Thanks
Ravi

___ 


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: Backing up Remedy data

2008-05-20 Thread Grooms, Frederick W
Depending on your tape backup software you could do a db job to copy the
data to a separate table/database/server (you pick) and back that up.

Fred 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Ravi
Sent: Tuesday, May 20, 2008 6:19 AM
To: arslist@ARSLIST.ORG
Subject: Backing up Remedy data

Hi: I have a form which stores all the emails that are sent out by AR
Email engine. I want to back up data older than 3 months on a tape drive
for upto 3 years. Whatz the best way to back up data so it's available
for retrieval in case I have to review the old emails? I didn't think I
could just backup the data in that table from via sqlplus? I want to be
able to automate the process so end of every month the data for current
month - 4 months is backed up.

Thanks
Ravi

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


Re: CI Relationship Viewer - Works for Demo and not for other users. (UNCLASSIFIED)

2008-05-20 Thread LJ Longwing
That actually perfectly explains why only admins are working...because it's
obviously using Mid-Tier to get you the view...and it needs to log you
in...and that is considered a separate connection, which isn't allowed for
anyone except admins...that is of course unless you are logged in through
mid-tier already, then it just uses your current connection to the
serverdefinitely a design problem

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Jiri Pospisil
Sent: Tuesday, May 20, 2008 3:17 AM
To: arslist@ARSLIST.ORG
Subject: Re: CI Relationship Viewer - Works for Demo and not for other
users. (UNCLASSIFIED)


** 

++

Please Read The Disclaimer At The Bottom Of This Email

++

 

Hi,
 
just to add to this discussion, we have the same issue here.
The CI Viewer only works for users with administrator privileges or when
users access Remedy through the mid-tier.
I checked the mid-tier log files on our server and found that CI Viewer
generates the following error message when non-admin user tries to access CI
Viewer from the PC client
 
MessageType: 2
MessageNum: 9093
MessageText: User is currently connected from another machine

We were advised by support to upgrade the CMDB with the CI viewer to version
2.0.01 patch 005, which I have not had time to do yet.
 
Jiri Pospisil
LCH.Clearnet

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Mike Gould
Sent: 19 May 2008 21:08
To: arslist@ARSLIST.ORG
Subject: Re: CI Relationship Viewer - Works for Demo and not for other
users. (UNCLASSIFIED)



** 
Hi Gordon,
 
The reason that Demo brings up the CI Viewer in the AR User Tool and
appadmin doesn't is because Demo has Administrator group permissions and
appadmin only has ITSM Asset Management application role permissions
(out-of-the-box).  It looks like you just gave your new test appadmin
account Administrator permissions, which is why it's now working for you.  
 
The problem with the CI Viewer is that it will only run for accounts with
Administrator rights and displays the The CI Relationship Viewer could not
open because the specified root CI does not exist. error for all non-Admin
users.  I recommend you try your test again but this time don't give the
user Administrator rights and see if you can replicate the error.
 
I know a few have suggested looking at form permissions but unfortunately
that's not the issue in this instance as non-Admin users can run the CI
Viewer just fine through their browser once Midtier 7.1.00 Patch 002 is
applied but not when they try in the User Tool.  The problem seems to reside
somewhere in some faulty CI Viewer (at least in the 2.0.01 release) code
that the User Tool is having a hard time processing but was fixed on the
Mid-Tier side.
 
I'm still in the process of troubleshooting the problem, which has been on
going for several months now, with BMC and will let you know when/if a fix
is found.
 
Have a great afternoon,
Michael Gould
US House of Representatives
 
Solaris 9
Oracle 10g
AR Server 7.0.01 Patch 005
Mid-Tier 7.1.00 Patch 002
Atrium CMDB 2.0.01 Patch 003
ITSM 7.0.03 Patch 005
 
 


 
On Mon, May 19, 2008 at 1:43 PM, FRANK, GORDON CTR DISA JSSC
[EMAIL PROTECTED] wrote:


Classification:  UNCLASSIFIED
Caveats: NONE

Thanks for all of your help!

The combination of several feedbacks got me thinking and I actually
solved this problem. I don't know what is being carried my the account
appadmin but it is the key to the solution. appadmin carries ITSM
something that Demo does not. But Demo does bring up the CI Viewer
correctly.

Here are the steps which will work.

1. Collect all information for the new account.
2. Go to the Application Administration Console, People, View
3. Select appadmin Login ID
4. Perform a Copy to New (Ctrl-T or select from toolbar)
5. In the new copy, make all account changes (Login ID, Support Groups
(including Administrator), etc. etc.)
6. Save
7. Login to the new account and the CI Viewer will now work.

Like I said, I don't know what is being carried underneath, but
something is different on appadmin. This procedure seems to work every
time.


Gordon M. Frank
Remedy Skilled Professional - 7.x
ITIL V3 Foundation Certified
DISA\Verizon FNS


-Original Message-
From: Action Request System discussion list(ARSList)

[mailto:[EMAIL PROTECTED] On Behalf Of Joe Bucci
Sent: Monday, May 19, 2008 10:01 AM
To: arslist@ARSLIST.ORG
Subject: Re: CI Relationship Viewer - Works for Demo and not for other
users. (UNCLASSIFIED)

**
Same issues - told to patch CMDB to 2.1, Midtier and thick client.
I am about to do this today.
HTH, Joe

Joe Bucci
cell 703-608-4467

 Date: Sun, 18 May 2008 11:13:29 -0400
 From: [EMAIL PROTECTED]
 Subject: Re: CI Relationship Viewer - Works for Demo and not for other
__Platinum Sponsor: www.rmsportal.com 

Re: CI Relationship Viewer - Works for Demo and not for other users. (UNCLASSIFIED)

2008-05-20 Thread LJ Longwing
That actually perfectly explains why only admins are working...because it's
obviously using Mid-Tier to get you the view...and it needs to log you
in...and that is considered a separate connection, which isn't allowed for
anyone except admins...that is of course unless you are logged in through
mid-tier already, then it just uses your current connection to the
serverdefinitely a design problem

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Jiri Pospisil
Sent: Tuesday, May 20, 2008 3:17 AM
To: arslist@ARSLIST.ORG
Subject: Re: CI Relationship Viewer - Works for Demo and not for other
users. (UNCLASSIFIED)


** 

++

Please Read The Disclaimer At The Bottom Of This Email

++

 

Hi,
 
just to add to this discussion, we have the same issue here.
The CI Viewer only works for users with administrator privileges or when
users access Remedy through the mid-tier.
I checked the mid-tier log files on our server and found that CI Viewer
generates the following error message when non-admin user tries to access CI
Viewer from the PC client
 
MessageType: 2
MessageNum: 9093
MessageText: User is currently connected from another machine

We were advised by support to upgrade the CMDB with the CI viewer to version
2.0.01 patch 005, which I have not had time to do yet.
 
Jiri Pospisil
LCH.Clearnet

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Mike Gould
Sent: 19 May 2008 21:08
To: arslist@ARSLIST.ORG
Subject: Re: CI Relationship Viewer - Works for Demo and not for other
users. (UNCLASSIFIED)



** 
Hi Gordon,
 
The reason that Demo brings up the CI Viewer in the AR User Tool and
appadmin doesn't is because Demo has Administrator group permissions and
appadmin only has ITSM Asset Management application role permissions
(out-of-the-box).  It looks like you just gave your new test appadmin
account Administrator permissions, which is why it's now working for you.  
 
The problem with the CI Viewer is that it will only run for accounts with
Administrator rights and displays the The CI Relationship Viewer could not
open because the specified root CI does not exist. error for all non-Admin
users.  I recommend you try your test again but this time don't give the
user Administrator rights and see if you can replicate the error.
 
I know a few have suggested looking at form permissions but unfortunately
that's not the issue in this instance as non-Admin users can run the CI
Viewer just fine through their browser once Midtier 7.1.00 Patch 002 is
applied but not when they try in the User Tool.  The problem seems to reside
somewhere in some faulty CI Viewer (at least in the 2.0.01 release) code
that the User Tool is having a hard time processing but was fixed on the
Mid-Tier side.
 
I'm still in the process of troubleshooting the problem, which has been on
going for several months now, with BMC and will let you know when/if a fix
is found.
 
Have a great afternoon,
Michael Gould
US House of Representatives
 
Solaris 9
Oracle 10g
AR Server 7.0.01 Patch 005
Mid-Tier 7.1.00 Patch 002
Atrium CMDB 2.0.01 Patch 003
ITSM 7.0.03 Patch 005
 
 


 
On Mon, May 19, 2008 at 1:43 PM, FRANK, GORDON CTR DISA JSSC
[EMAIL PROTECTED] wrote:


Classification:  UNCLASSIFIED
Caveats: NONE

Thanks for all of your help!

The combination of several feedbacks got me thinking and I actually
solved this problem. I don't know what is being carried my the account
appadmin but it is the key to the solution. appadmin carries ITSM
something that Demo does not. But Demo does bring up the CI Viewer
correctly.

Here are the steps which will work.

1. Collect all information for the new account.
2. Go to the Application Administration Console, People, View
3. Select appadmin Login ID
4. Perform a Copy to New (Ctrl-T or select from toolbar)
5. In the new copy, make all account changes (Login ID, Support Groups
(including Administrator), etc. etc.)
6. Save
7. Login to the new account and the CI Viewer will now work.

Like I said, I don't know what is being carried underneath, but
something is different on appadmin. This procedure seems to work every
time.


Gordon M. Frank
Remedy Skilled Professional - 7.x
ITIL V3 Foundation Certified
DISA\Verizon FNS


-Original Message-
From: Action Request System discussion list(ARSList)

[mailto:[EMAIL PROTECTED] On Behalf Of Joe Bucci
Sent: Monday, May 19, 2008 10:01 AM
To: arslist@ARSLIST.ORG
Subject: Re: CI Relationship Viewer - Works for Demo and not for other
users. (UNCLASSIFIED)

**
Same issues - told to patch CMDB to 2.1, Midtier and thick client.
I am about to do this today.
HTH, Joe

Joe Bucci
cell 703-608-4467

 Date: Sun, 18 May 2008 11:13:29 -0400
 From: [EMAIL PROTECTED]
 Subject: Re: CI Relationship Viewer - Works for Demo and not for other
__Platinum Sponsor: www.rmsportal.com 

Re: SRM 2.1 Patch 1

2008-05-20 Thread Vijay Nimmala
**
Peter..yes, I did without any Issues.Try installing the base version ( 2.1) alone first ,then apply patch.Vijay--- On Mon, 5/19/08, PCR Remedy [EMAIL PROTECTED] wrote:From: PCR Remedy [EMAIL PROTECTED]Subject: SRM 2.1 Patch 1To: arslist@ARSLIST.ORGDate: Monday, May 19, 2008, 9:04 PM**
Does anybody successfully installed patch 1 for SRM 2.1?
I cant make it work in a localized server, I got an error. I send attached.

Thanks in advance.

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


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


Mid-tier AL logging?

2008-05-20 Thread William Rentfrow
Okay - perhaps I'm having a brain crampbut I can't get mid-tier
logging to work for one system.
 
I have...
 
1.) Created an AR User Preference record for the user in question
2.) Turned on logging (AL in this case)
3.) Made sure the AR Server preference setting is set to this server
4.) Logged out and back in as this user.
 
I don't get the AL window - and can't with any user.
 
There is no pop-up blocker interference - I checked that...
 
Just for kicks I also put the Client Side Logging Group to Incident
User to guarantee they could do logging.  I also flushed the cache -
not that it should matter.
 
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: Mid-tier AL logging?

2008-05-20 Thread William Rentfrow
Okay, brain cramp - MT server didn't have the preference server set.
 
That's usually more of a Monday moment.



From: William Rentfrow 
Sent: Tuesday, May 20, 2008 10:09 AM
To: 'arslist@ARSLIST.ORG'
Subject: Mid-tier AL logging?


Okay - perhaps I'm having a brain crampbut I can't get mid-tier
logging to work for one system.
 
I have...
 
1.) Created an AR User Preference record for the user in question
2.) Turned on logging (AL in this case)
3.) Made sure the AR Server preference setting is set to this server
4.) Logged out and back in as this user.
 
I don't get the AL window - and can't with any user.
 
There is no pop-up blocker interference - I checked that...
 
Just for kicks I also put the Client Side Logging Group to Incident
User to guarantee they could do logging.  I also flushed the cache -
not that it should matter.
 
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: Routing Requests to the correct Categorizations without using the summaries from teh Requestor Console.

2008-05-20 Thread Rick Cook
You can create Incident Templates that are available for use in the
Requester Console (or is that what you're referring to as the
Summaries?).  Those can be associated with CTI and Assignee information.
Apart from that, you'll have to customize the app.

Rick

On Tue, May 20, 2008 at 3:21 AM, jmchugh [EMAIL PROTECTED] wrote:

 ITSM 7.0.3 patch 7
 Remedy ARS Server 7.1 patch 2
 MS SQL Server 2005
 Windows 2003

 Hi,

 When using the Requestor Console and submitting ticket I would like to
 be able to Categorise and Assign to a particular goup the resultant
 incident. This I would like to achieve by not using the summaries drop
 down.

 Has anyone achieved this and if so how did you go about doing this?

 I was thinking of one drop down list of all the deparments. I am not
 sure how to proceed from here though.

 Thanks
 John


 ___
 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: ARODBC Error

2008-05-20 Thread Benedetto Cantatore
Jase,
 
I think I had a similar problem like yours long ago, my memory is a bit
hazy.  I think what the problem ended up being was specific records
missing a history.  So when you attempted to report on those incidents,
it choked.  I recommend that you run the search in the usertool, and
then press control H as you're scanning through the records to see if
any come up strangely or if you get an error.  Alternately if you're not
finding any damage incidents, I suggest trying the Excel pointed to a
specific incident (one that you know IS good) and see if it'll display.
 
Hope this ends up being helpful.
 
 
Ben Cantatore
Remedy Manager
(914) 457-6209
 
Emerging Health IT
3 Odell Plaza
Yonkers, New York 10701


 [EMAIL PROTECTED] 05/20/08 10:30 AM 

** I am not using 7.1 but am using 7.0. My ARODBC version is 7.00.01.07
and I do not have any issues using the status history columns in queries
from Excel. Not sure if 7.1 uses the same ODBC version.

HTH

On Mon, May 19, 2008 at 4:44 PM, Jase Brandon [EMAIL PROTECTED]
wrote:
** Hello All,
 
I have a user writing corporate reports using Excel/Remedy ARODBC to
connect to prod dbase. (I know, I laughed too) :)
All was fine until last week, when absolutely nothing changed (as far
as I know).
 
Using Excel and his Remedy ARODBC login, he is now unable to query
HPD:HelpDesk for 
Status.History. If he queries on any other field, no problemo. 
If he adds Status.History.New, etc.. to the query, it bombs and returns
the message.
Cannot open catalog, message number = 94, servername
 
Has anyone else seen this?
I get the same result when using my ARODBC as well.
I have verified running the exact same query through SQL Query Analyzer
and it works flawlessly.
I can query H1024 with no problem, T1024 also.
Please see his below excel query.
 
This one works:
SELECT HPD:Help-Desk.Incident-Number
FROM HPD:Help-Desk HPD:Help-Desk
WHERE (HPD:Help-Desk.Incident-Number Is Not Null)
 
This one does not work:
SELECT HPD:Help-Desk.Incident-Number, HPD:Help-Desk.Status
History-New-TIME
FROM HPD:Help-Desk HPD:Help-Desk
WHERE (HPD:Help-Desk.Incident-Number Is Not Null)
 
**notice the only difference is the addition of Status History New TIME
to the query.

 
I believe this to be an issue with the ARODBC drivers, I even had him
reinstall the user.exe to make sure his driver wasn't corrupted, etc.
I hope someone else has seen this as I am perplexed.
 
Has anyone else had issues with 7.1  and Status.History?
 
Kind Regards,
 
Jase
 
 
ARS 7.1 Patch 002
Win2K5
__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


Lisbon UserWorld

2008-05-20 Thread Daniel Bloom
Just got news of 7.5 Beta open beta in the August timeframe with a somewhat 
later release, probably very shortly after the new year. Personally I rather 
like the 4 months between beta starting and the release.

The Developer Suite is looking more solid than last October, and is still 
looking cool with every bell and whistle we have ever asked for being handed to 
us all at once.

Ah, I guess I have just admitted to getting to the European conference for the 
first time.

So, if you are here at the conference and on the ARSlist  just look for people 
wearing a button saying ARSlist - WWRUG -Where The Answers Are ( supplied by 
RMS of course). I am wearing one and am always happy to meet fellow ARSlisters, 
and give out pins. Misi and I have also created a BOF Table for the Weds. Lunch

Cheers. Dan
ARSlist Founder doing a fly about
   

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


Re: Lisbon UserWorld

2008-05-20 Thread Vincent RIEDWEG
Dan,

I was a little disappointed by the presentation around BMC AR System Developer 
Studio, If you want we can disscuss about that at the dinner or now (I am in 
the internet cafe in the chair with my laptop)

Cheers,

Vincent.

-Message d'origine-
De : Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
De la part de Daniel Bloom
Envoyé : mardi 20 mai 2008 18:01
À : arslist@ARSLIST.ORG
Objet : Lisbon UserWorld

Just got news of 7.5 Beta open beta in the August timeframe with a somewhat 
later release, probably very shortly after the new year. Personally I rather 
like the 4 months between beta starting and the release.

The Developer Suite is looking more solid than last October, and is still 
looking cool with every bell and whistle we have ever asked for being handed to 
us all at once.

Ah, I guess I have just admitted to getting to the European conference for the 
first time.

So, if you are here at the conference and on the ARSlist  just look for people 
wearing a button saying ARSlist - WWRUG -Where The Answers Are ( supplied by 
RMS of course). I am wearing one and am always happy to meet fellow ARSlisters, 
and give out pins. Misi and I have also created a BOF Table for the Weds. Lunch

Cheers. Dan
ARSlist Founder doing a fly about
   

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

!RSIG:1,4833be9f203448152433266!

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


Re: ITSM 7 Support Staff permissions

2008-05-20 Thread Lammey, Peter A.
How are you able to do this?  I tried this with a simple support staff user and 
tried to go into People and see if I was logged in as that support staff user 
with just Incident User and Asset viewer rights but I could not alter anything 
(permissions, group membership included) for other people except for the 
person's own profile.

ITSM 7.02 patch 005


Thanks
Peter Lammey
ESPN MIT Technical Services  Applications Management
860-766-4761

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of strauss
Sent: Tuesday, May 20, 2008 12:09 PM
To: arslist@ARSLIST.ORG
Subject: ITSM 7 Support Staff permissions

Has anyone run into an issue with ITSM 7 where it is entirely possible for a 
support staff user (Incident User, Asset Viewer, no Roles at all, just company 
and group membership) in a company to remove all of the application permissions 
for another Incident user in the same group?
One of the departments has already experienced this.  Remember how in ITSM 5.x 
and 6.x there were many different filters trapping who could update what fields 
in the SHR:People and User forms?  I guess they left all of those out in ITSM 
7.  We had thought that the Contact People permission controlled this, but 
apparently not since our admin accounts are the only ones that have those.

Has anyone dug into this enough to explain it?  As usual, the BMC docs on 
permissions and roles are not much help.

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing  IT Center

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

Please consider the environment before printing this e-mail.

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


ITSM 7 Support Staff permissions

2008-05-20 Thread strauss
Has anyone run into an issue with ITSM 7 where it is entirely possible
for a support staff user (Incident User, Asset Viewer, no Roles at all,
just company and group membership) in a company to remove all of the
application permissions for another Incident user in the same group?
One of the departments has already experienced this.  Remember how in
ITSM 5.x and 6.x there were many different filters trapping who could
update what fields in the SHR:People and User forms?  I guess they left
all of those out in ITSM 7.  We had thought that the Contact People
permission controlled this, but apparently not since our admin accounts
are the only ones that have those.

Has anyone dug into this enough to explain it?  As usual, the BMC docs
on permissions and roles are not much help.

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing  IT Center

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


RES: Update form without logging in

2008-05-20 Thread Tadeu Augusto Dutra Pinto
Hi,
 
You can also create a script (shell script) that access the database directly 
and use this to update your record(s) ...
 
 
Att,
 
Tadeu Augusto Dutra Pinto
-
IT Web Services ATM 
Cinq Technologies
http://www.cinq.com.br 
https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ 
 
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
Fone: 41 3018-2833 - Cinq
-
Confiabilidade, Inovação e Qualidade em T.I.



De: Action Request System discussion list(ARSList) em nome de Eli Schilling
Enviada: sex 16/5/2008 17:24
Para: arslist@ARSLIST.ORG
Assunto: Update form without logging in


** 
Happy Friday Listers!
 
So I'm looking for a quick and easy way to update a ticket (single field value) 
without requiring the user to log in.  I'm on ARS 7.1 with Mid-tier 7 on Apache 
Tomcat.  I started by trying to do it via public webservice but couldn't find a 
way to consume a web service using javascript (unless there's another language 
supported by Tomcat that would work).
 
So then I thought...what about using jdbc to update the value directly into the 
database...well; that was a miserable failure as well.  I know it can be done I 
just can't seem to find any examples of the code, nor is my syntax even close 
to being correct.
 
So, has anyone taken one of these two routes and can you help me out?  Or is 
there another, BETTER way?
 
Thanks all!
 
Eli
__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: Update form without logging in

2008-05-20 Thread Ravi
i do the same exact with ARS Perl. Here's the function I use to update 
tickets. I call this function with two arguments: 1: incident number in 
the HPD:Help Desk form and list each fieldname, value pair separated by ##.


Example: updateTicket(INC00034, 
ORIG_TRS_SEVERITY=4##PRIME-LOC=ABC##CURR-LOC=ABC')


sub updateTicket {
 my $incident = shift;
  my $update_data = shift;

 $server = x.x.x.x;
 $username = x;
 $password = ;
 $currTime = time();
 ($ctrl = ars_Login($server, $username, $password)) || die couldn't 
allocate control structure;


  $schema = HPD:IncidentInterface;
  %fval = ars_GetFieldTable($ctrl, $schema);

 my @updRemString;
  @fieldvalues = split(/##/, $update_data);
  foreach (@fieldvalues) {
 @valuepair = split(/=/, $_);
 if($valuepair[0] eq ORIG_TRS_SEVERITY) {
push(@updRemString, $fval{'ORIG_TRS_SEVERITY'});
 }
 if($valuepair[0] eq Vendor_Link_Status) {
push(@updRemString, $fval{'Vendor Link Status'});
 }
 if($valuepair[0] eq PRIME-LOC) {
push(@updRemString, $fval{'PRIME-LOC'});
 }
 if($valuepair[0] eq CURR-LOC) {
push(@updRemString, $fval{'CURR-LOC'});
 }
 push(@updRemString, $valuepair[1]);
  }

  ($qual = ars_LoadQualifier($ctrl, $schema, 'Incident Number*' = 
\$incident\)) || die ars_LoadQualifier: $ars_errstr;

  @entries = ars_GetListEntry($ctrl, $schema, $qual, 0, 0);
  $record = $entries[0];
  ars_SetEntry($ctrl, $schema, $record, 0, @updRemString) || die 
ars_SetEntry(User): $ars_errstr;


}

HTH
Ravi

Eli Schilling wrote:

**
Happy Friday Listers!
 
So I'm looking for a quick and easy way to update a ticket (single 
field value) without requiring the user to log in.  I'm on ARS 7.1 
with Mid-tier 7 on Apache Tomcat.  I started by trying to do it via 
public webservice but couldn't find a way to consume a web service 
using javascript (unless there's another language supported by Tomcat 
that would work).
 
So then I thought...what about using jdbc to update the value directly 
into the database...well; that was a miserable failure as well.  I 
know it can be done I just can't seem to find any examples of the 
code, nor is my syntax even close to being correct.
 
So, has anyone taken one of these two routes and can you help me out?  
Or is there another, BETTER way?
 
Thanks all!
 
Eli
__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: EIE Running on a Remote Server

2008-05-20 Thread Marc Simmons
Just so everyone knows, this looks like it might have been an issue with an
invalid AR Server license.  After deleting and re-installing the AR Server
license, EIE started communicating with the server.

On 5/16/08, Marc Simmons [EMAIL PROTECTED] wrote:

 Hi List,

 Does anyone have any experience running EIE 7 on a remote server.  My
 environment is the following:

 Remedy Server:

 ARS 6.3
 HelpDesk 6.0
 Solaris 10
 Oracle 10g

 EIE Server:

 EIE 7 (with Remedy Link for Oracle)
 Solaris 10
 Oracle 10g client

 The target server(s) is not relevant at this point.  I've installed EIE on
 the remote server and can't even get it to run the flat file example
 exchange.

 Any help/extra documents would be appreciated.

 --
 Marc Simmons
 Remedy Administrator

 Everyday above ground is a good day... the rest is a choice!




-- 
Marc Simmons
Remedy Administrator

Everyday above ground is a good day... the rest is a choice!

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


Re: ITSM 7 Support Staff permissions

2008-05-20 Thread strauss
I'm not sure yet how it was done, just that it was, and that the last
modified user on the profile that was altered was another support user
in the same company.

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 Lammey, Peter A.
 Sent: Tuesday, May 20, 2008 11:30 AM
 To: arslist@ARSLIST.ORG
 Subject: Re: ITSM 7 Support Staff permissions
 
 How are you able to do this?  I tried this with a simple support staff
 user and tried to go into People and see if I was logged in as that
 support staff user with just Incident User and Asset viewer rights but
 I could not alter anything (permissions, group membership included)
for
 other people except for the person's own profile.
 
 ITSM 7.02 patch 005
 
 
 Thanks
 Peter Lammey
 ESPN MIT Technical Services  Applications Management
 860-766-4761
 
 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of strauss
 Sent: Tuesday, May 20, 2008 12:09 PM
 To: arslist@ARSLIST.ORG
 Subject: ITSM 7 Support Staff permissions
 
 Has anyone run into an issue with ITSM 7 where it is entirely possible
 for a support staff user (Incident User, Asset Viewer, no Roles at
all,
 just company and group membership) in a company to remove all of the
 application permissions for another Incident user in the same group?
 One of the departments has already experienced this.  Remember how in
 ITSM 5.x and 6.x there were many different filters trapping who could
 update what fields in the SHR:People and User forms?  I guess they
left
 all of those out in ITSM 7.  We had thought that the Contact People
 permission controlled this, but apparently not since our admin
accounts
 are the only ones that have those.
 
 Has anyone dug into this enough to explain it?  As usual, the BMC docs
 on permissions and roles are not much help.
 
 Christopher Strauss, Ph.D.
 Call Tracking Administration Manager
 University of North Texas Computing  IT Center
 

___
 
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum
 Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
 
 Please consider the environment before printing this e-mail.
 

___
 
 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: Lisbon UserWorld

2008-05-20 Thread Sokol, Brian
Can one of you guys share some info about 7.5 and Developer Studio? 

thanks 

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Vincent RIEDWEG
Sent: Tuesday, May 20, 2008 12:15 PM
To: arslist@ARSLIST.ORG
Subject: Re: Lisbon UserWorld

Dan,

I was a little disappointed by the presentation around BMC AR System Developer 
Studio, If you want we can disscuss about that at the dinner or now (I am in 
the internet cafe in the chair with my laptop)

Cheers,

Vincent.

-Message d'origine-
De : Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
De la part de Daniel Bloom Envoyé : mardi 20 mai 2008 18:01 À : 
arslist@ARSLIST.ORG Objet : Lisbon UserWorld

Just got news of 7.5 Beta open beta in the August timeframe with a somewhat 
later release, probably very shortly after the new year. Personally I rather 
like the 4 months between beta starting and the release.

The Developer Suite is looking more solid than last October, and is still 
looking cool with every bell and whistle we have ever asked for being handed to 
us all at once.

Ah, I guess I have just admitted to getting to the European conference for the 
first time.

So, if you are here at the conference and on the ARSlist  just look for people 
wearing a button saying ARSlist - WWRUG -Where The Answers Are ( supplied by 
RMS of course). I am wearing one and am always happy to meet fellow ARSlisters, 
and give out pins. Misi and I have also created a BOF Table for the Weds. Lunch

Cheers. Dan
ARSlist Founder doing a fly about
   

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

!RSIG:1,4833be9f203448152433266!

___
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


Menu Missing - 7.1 ARSysmtem

2008-05-20 Thread Pam Hollis
I am looking for a menu called: 

INT:FNDSRM:WorkOrderRoleLabel-Q - it is on the
CTM:CFG-ApplicationPreferences Form for the Work Order Tab for the Role
- does anyone have this?

 

Thanks

 

Pam Hollis

Tractor Supply Company

Senior Remedy Developer

Remedy Skilled Professional

615-440-4617 (Office)

615-484-4617 (Fax)

[EMAIL PROTECTED]

 


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


Re: Menu Missing - 7.1 ARSysmtem

2008-05-20 Thread Decou, Candace M
I do not have it Pam - same version and I double checked the Menu on the
formmaybe it didn't get bundled up for install?

Sorry - I would have sent it if I had it.

:-)

 

Candace DeCou

DOI Remedy Systems Analyst 
Verizon Business 
Office:  (408) 371-1112

Email: [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]  

 

Verizon Business - global capability, personal accountability. 

This e-mail is strictly confidential and intended only for use by the
addressee unless otherwise indicated



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Pam Hollis
Sent: Tuesday, May 20, 2008 10:51 AM
To: arslist@ARSLIST.ORG
Subject: Menu Missing - 7.1 ARSysmtem

 

I am looking for a menu called: 

INT:FNDSRM:WorkOrderRoleLabel-Q - it is on the
CTM:CFG-ApplicationPreferences Form for the Work Order Tab for the Role
- does anyone have this?

 

Thanks

 

Pam Hollis

Tractor Supply Company

Senior Remedy Developer

Remedy Skilled Professional

615-440-4617 (Office)

615-484-4617 (Fax)

[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: Menu Missing - 7.1 ARSysmtem

2008-05-20 Thread Pam Hollis
Thanks - I have been looking for it in the workflow on the server and
not be able to find it either and it keeps putting an error on the
midtier logs that it is missing - even though I removed it off the
field.

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Decou, Candace M
Sent: Tuesday, May 20, 2008 1:08 PM
To: arslist@ARSLIST.ORG
Subject: Re: Menu Missing - 7.1 ARSysmtem

 

I do not have it Pam - same version and I double checked the Menu on the
formmaybe it didn't get bundled up for install?

Sorry - I would have sent it if I had it.

:-)

 

Candace DeCou

DOI Remedy Systems Analyst 
Verizon Business 
Office:  (408) 371-1112

Email: [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]  

 

Verizon Business - global capability, personal accountability. 

This e-mail is strictly confidential and intended only for use by the
addressee unless otherwise indicated



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Pam Hollis
Sent: Tuesday, May 20, 2008 10:51 AM
To: arslist@ARSLIST.ORG
Subject: Menu Missing - 7.1 ARSysmtem

 

I am looking for a menu called: 

INT:FNDSRM:WorkOrderRoleLabel-Q - it is on the
CTM:CFG-ApplicationPreferences Form for the Work Order Tab for the Role
- does anyone have this?

 

Thanks

 

Pam Hollis

Tractor Supply Company

Senior Remedy Developer

Remedy Skilled Professional

615-440-4617 (Office)

615-484-4617 (Fax)

[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


Re: Menu Missing - 7.1 ARSysmtem

2008-05-20 Thread Decou, Candace M
Well you can probably guess what it is looking for - try creating one
and replace the OOB reference.  Maybe that will help?  Or (gulp) ask BMC
for it.  I haven't had the chance yet to get over to that part of the
app - sighh.  

Guess I should thank you for the heads up!

 

Candace DeCou

DOI Remedy Systems Analyst 
Verizon Business 
Office:  (408) 371-1112

Email: [EMAIL PROTECTED] 

 

Verizon Business - global capability, personal accountability. 

This e-mail is strictly confidential and intended only for use by the
addressee unless otherwise indicated



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Pam Hollis
Sent: Tuesday, May 20, 2008 11:15 AM
To: arslist@ARSLIST.ORG
Subject: Re: Menu Missing - 7.1 ARSysmtem

 

Thanks - I have been looking for it in the workflow on the server and
not be able to find it either and it keeps putting an error on the
midtier logs that it is missing - even though I removed it off the
field.

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Decou, Candace M
Sent: Tuesday, May 20, 2008 1:08 PM
To: arslist@ARSLIST.ORG
Subject: Re: Menu Missing - 7.1 ARSysmtem

 

I do not have it Pam - same version and I double checked the Menu on the
formmaybe it didn't get bundled up for install?

Sorry - I would have sent it if I had it.

:-)

 

Candace DeCou

DOI Remedy Systems Analyst 
Verizon Business 
Office:  (408) 371-1112

Email: [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]  

 

Verizon Business - global capability, personal accountability. 

This e-mail is strictly confidential and intended only for use by the
addressee unless otherwise indicated



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Pam Hollis
Sent: Tuesday, May 20, 2008 10:51 AM
To: arslist@ARSLIST.ORG
Subject: Menu Missing - 7.1 ARSysmtem

 

I am looking for a menu called: 

INT:FNDSRM:WorkOrderRoleLabel-Q - it is on the
CTM:CFG-ApplicationPreferences Form for the Work Order Tab for the Role
- does anyone have this?

 

Thanks

 

Pam Hollis

Tractor Supply Company

Senior Remedy Developer

Remedy Skilled Professional

615-440-4617 (Office)

615-484-4617 (Fax)

[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


Remedy Table Indexes

2008-05-20 Thread Luksha, Timothy
I was recently asked to check which columns of one of our remedy forms
were indexed.  The documentation gave me the impression that only
Request Id would be indexed automatically, which makes sense since it
is the primary key.  Remedy administrator indicated that two other
columns had indexes.  When I looked at the Oracle table in a database
tool I have, there were four indexes listed.  The one that wasn't
appearing in remedy administrator mapped to the Date Submitted field.


Does this simply indicate that someone added the index through Oracle
without asking remedy to create it or is something more funny going on?

Thanks,

Tim

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


Re: Menu Missing - 7.1 ARSysmtem

2008-05-20 Thread Savant, [EMAIL PROTECTED]
We have the menu (see attached), I believe it's from SRM 2.1 p001.

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Pam Hollis
Sent: Tuesday, May 20, 2008 10:51 AM
To: arslist@ARSLIST.ORG
Subject: Menu Missing - 7.1 ARSysmtem

This is a multi-part message in MIME format.

--_=_NextPart_001_01C8BAA2.009746D7
Content-Type: text/plain;
charset=us-ascii
Content-Transfer-Encoding: quoted-printable

I am looking for a menu called:=20

INT:FNDSRM:WorkOrderRoleLabel-Q - it is on the
CTM:CFG-ApplicationPreferences Form for the Work Order Tab for the Role
- does anyone have this?

=20

Thanks

=20

Pam Hollis

Tractor Supply Company

Senior Remedy Developer

Remedy Skilled Professional

615-440-4617 (Office)

615-484-4617 (Fax)

[EMAIL PROTECTED]

=20


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

--_=_NextPart_001_01C8BAA2.009746D7
Content-Type: text/html;
charset=us-ascii
Content-Transfer-Encoding: quoted-printable

**
html xmlns:o=3Durn:schemas-microsoft-com:office:office =
xmlns:w=3Durn:schemas-microsoft-com:office:word =
xmlns=3Dhttp://www.w3.org/TR/REC-html40;

head
META HTTP-EQUIV=3DContent-Type CONTENT=3Dtext/html; =
charset=3Dus-ascii
meta name=3DGenerator content=3DMicrosoft Word 11 (filtered medium)
style
!--
 /* Font Definitions */
 @font-face
{font-family:Raavi;
panose-1:2 0 5 0 0 0 0 0 0 0;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:Times New Roman;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
--
/style

/head

body lang=3DEN-US link=3Dblue vlink=3Dpurple

div class=3DSection1

p class=3DMsoNormalfont size=3D2 face=3DArialspan =
style=3D'font-size:10.0pt;
font-family:Arial'I am looking for a menu called: =
o:p/o:p/span/font/p

p class=3DMsoNormalfont size=3D2 face=3DArialspan =
style=3D'font-size:10.0pt;
font-family:Arial'INT:FNDSRM:WorkOrderRoleLabel-Q #8211; it is on the
CTM:CFG-ApplicationPreferences Form for the Work Order Tab for the Role =
#8211;
does anyone have this?o:p/o:p/span/font/p

p class=3DMsoNormalfont size=3D2 face=3DArialspan =
style=3D'font-size:10.0pt;
font-family:Arial'o:pnbsp;/o:p/span/font/p

p class=3DMsoNormalfont size=3D2 face=3DArialspan =
style=3D'font-size:10.0pt;
font-family:Arial'Thankso:p/o:p/span/font/p

p class=3DMsoNormalfont size=3D2 face=3DArialspan =
style=3D'font-size:10.0pt;
font-family:Arial'o:pnbsp;/o:p/span/font/p

p class=3DMsoNormalstrongbfont size=3D3 face=3DRaavispan =
style=3D'font-size:
12.0pt;font-family:Raavi'Pam =
Hollis/span/font/b/strongo:p/o:p/p

p class=3DMsoNormalstrongbfont size=3D2 face=3DTimes New =
Romanspan
style=3D'font-size:10.0pt'Tractor Supply =
Company/span/font/b/strongo:p/o:p/p

p class=3DMsoNormalfont size=3D2 face=3DTimes New Romanspan =
style=3D'font-size:
10.0pt'Senior Remedy Developer/span/fonto:p/o:p/p

p class=3DMsoNormalfont size=3D2 face=3DTimes New Romanspan =
style=3D'font-size:
10.0pt'Remedy Skilled Professional/span/fonto:p/o:p/p

p class=3DMsoNormalfont size=3D2 face=3DTimes New Romanspan =
style=3D'font-size:
10.0pt'615-440-4617 (Office)/span/fonto:p/o:p/p

p class=3DMsoNormalfont size=3D2 face=3DTimes New Romanspan =
style=3D'font-size:
10.0pt'615-484-4617 (Fax)/span/fonto:p/o:p/p

p class=3DMsoNormalfont size=3D2 face=3DTimes New Romanspan =
style=3D'font-size:
10.0pt'a =
href=3Dmailto:[EMAIL PROTECTED][EMAIL PROTECTED]/a/=
span/fonto:p/o:p/p

p class=3DMsoNormalfont size=3D3 face=3DTimes New Romanspan =
style=3D'font-size:
12.0pt'o:pnbsp;/o:p/span/font/p

/div

/body

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

--_=_NextPart_001_01C8BAA2.009746D7--

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


int_fndsrm_menu.def
Description: int_fndsrm_menu.def


Re: Remedy Table Indexes

2008-05-20 Thread Rick Cook
RequestID is the only automatically indexed field on any form.  Your
impression on the others makes sense.  If that's true, or should I say,
until you are sure that it is NOT true, you should not modify your indexes
in Remedy Administrator.  If they were created in the DB, they need to be
maintained there.

Rick

On Tue, May 20, 2008 at 11:23 AM, Luksha, Timothy [EMAIL PROTECTED]
wrote:

 I was recently asked to check which columns of one of our remedy forms
 were indexed.  The documentation gave me the impression that only
 Request Id would be indexed automatically, which makes sense since it
 is the primary key.  Remedy administrator indicated that two other
 columns had indexes.  When I looked at the Oracle table in a database
 tool I have, there were four indexes listed.  The one that wasn't
 appearing in remedy administrator mapped to the Date Submitted field.


 Does this simply indicate that someone added the index through Oracle
 without asking remedy to create it or is something more funny going on?

 Thanks,

 Tim


 ___
 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: Menu Missing - 7.1 ARSysmtem

2008-05-20 Thread Decou, Candace M
Thanks Donald - I guess that makes sense since I only have full ITSM and
not SRM installed - thus the missing menu.  Not sure if that is the same
for Pam or not, but now it does make sense.  I've saved it off just in
case I need it too.
:)
  

Candace DeCou

DOI Remedy Systems Analyst 
Verizon Business 
Office:  (408) 371-1112

Email: [EMAIL PROTECTED] 

 

Verizon Business - global capability, personal accountability. 

This e-mail is strictly confidential and intended only for use by the
addressee unless otherwise indicated


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Savant, [EMAIL PROTECTED]
Sent: Tuesday, May 20, 2008 11:27 AM
To: arslist@ARSLIST.ORG
Subject: Re: Menu Missing - 7.1 ARSysmtem

We have the menu (see attached), I believe it's from SRM 2.1 p001.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Pam Hollis
Sent: Tuesday, May 20, 2008 10:51 AM
To: arslist@ARSLIST.ORG
Subject: Menu Missing - 7.1 ARSysmtem

This is a multi-part message in MIME format.

--_=_NextPart_001_01C8BAA2.009746D7
Content-Type: text/plain;
charset=us-ascii
Content-Transfer-Encoding: quoted-printable

I am looking for a menu called:=20

INT:FNDSRM:WorkOrderRoleLabel-Q - it is on the
CTM:CFG-ApplicationPreferences Form for the Work Order Tab for the Role
- does anyone have this?

=20

Thanks

=20

Pam Hollis

Tractor Supply Company

Senior Remedy Developer

Remedy Skilled Professional

615-440-4617 (Office)

615-484-4617 (Fax)

[EMAIL PROTECTED]

=20



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

--_=_NextPart_001_01C8BAA2.009746D7
Content-Type: text/html;
charset=us-ascii
Content-Transfer-Encoding: quoted-printable

**
html xmlns:o=3Durn:schemas-microsoft-com:office:office =
xmlns:w=3Durn:schemas-microsoft-com:office:word =
xmlns=3Dhttp://www.w3.org/TR/REC-html40;

head
META HTTP-EQUIV=3DContent-Type CONTENT=3Dtext/html; =
charset=3Dus-ascii
meta name=3DGenerator content=3DMicrosoft Word 11 (filtered medium)
style
!--
 /* Font Definitions */
 @font-face
{font-family:Raavi;
panose-1:2 0 5 0 0 0 0 0 0 0;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:Times New Roman;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
--
/style

/head

body lang=3DEN-US link=3Dblue vlink=3Dpurple

div class=3DSection1

p class=3DMsoNormalfont size=3D2 face=3DArialspan =
style=3D'font-size:10.0pt;
font-family:Arial'I am looking for a menu called: =
o:p/o:p/span/font/p

p class=3DMsoNormalfont size=3D2 face=3DArialspan =
style=3D'font-size:10.0pt;
font-family:Arial'INT:FNDSRM:WorkOrderRoleLabel-Q #8211; it is on the
CTM:CFG-ApplicationPreferences Form for the Work Order Tab for the Role
=
#8211;
does anyone have this?o:p/o:p/span/font/p

p class=3DMsoNormalfont size=3D2 face=3DArialspan =
style=3D'font-size:10.0pt;
font-family:Arial'o:pnbsp;/o:p/span/font/p

p class=3DMsoNormalfont size=3D2 face=3DArialspan =
style=3D'font-size:10.0pt;
font-family:Arial'Thankso:p/o:p/span/font/p

p class=3DMsoNormalfont size=3D2 face=3DArialspan =
style=3D'font-size:10.0pt;
font-family:Arial'o:pnbsp;/o:p/span/font/p

p class=3DMsoNormalstrongbfont size=3D3 face=3DRaavispan =
style=3D'font-size:
12.0pt;font-family:Raavi'Pam =
Hollis/span/font/b/strongo:p/o:p/p

p class=3DMsoNormalstrongbfont size=3D2 face=3DTimes New =
Romanspan
style=3D'font-size:10.0pt'Tractor Supply =
Company/span/font/b/strongo:p/o:p/p

p class=3DMsoNormalfont size=3D2 face=3DTimes New Romanspan =
style=3D'font-size:
10.0pt'Senior Remedy Developer/span/fonto:p/o:p/p

p class=3DMsoNormalfont size=3D2 face=3DTimes New Romanspan =
style=3D'font-size:
10.0pt'Remedy Skilled Professional/span/fonto:p/o:p/p

p class=3DMsoNormalfont size=3D2 face=3DTimes New Romanspan =
style=3D'font-size:
10.0pt'615-440-4617 (Office)/span/fonto:p/o:p/p

p class=3DMsoNormalfont size=3D2 face=3DTimes New Romanspan =
style=3D'font-size:
10.0pt'615-484-4617 (Fax)/span/fonto:p/o:p/p

p class=3DMsoNormalfont size=3D2 face=3DTimes New Romanspan =
style=3D'font-size:
10.0pt'a =
href=3Dmailto:[EMAIL PROTECTED][EMAIL PROTECTED]/a
/=
span/fonto:p/o:p/p

p class=3DMsoNormalfont size=3D3 face=3DTimes New Romanspan =
style=3D'font-size:
12.0pt'o:pnbsp;/o:p/span/font/p

/div

/body

/html
__Platinum Sponsor: 

Re: Menu Missing - 7.1 ARSysmtem

2008-05-20 Thread Pam Hollis
Thank you!

Does anyone have the following menu - I found one more missing.

xSYS:MNU:InfraChangeRoleCAB_locale-Q

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Savant, [EMAIL PROTECTED]
Sent: Tuesday, May 20, 2008 1:27 PM
To: arslist@ARSLIST.ORG
Subject: Re: Menu Missing - 7.1 ARSysmtem

We have the menu (see attached), I believe it's from SRM 2.1 p001.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Pam Hollis
Sent: Tuesday, May 20, 2008 10:51 AM
To: arslist@ARSLIST.ORG
Subject: Menu Missing - 7.1 ARSysmtem

This is a multi-part message in MIME format.

--_=_NextPart_001_01C8BAA2.009746D7
Content-Type: text/plain;
charset=us-ascii
Content-Transfer-Encoding: quoted-printable

I am looking for a menu called:=20

INT:FNDSRM:WorkOrderRoleLabel-Q - it is on the
CTM:CFG-ApplicationPreferences Form for the Work Order Tab for the Role
- does anyone have this?

=20

Thanks

=20

Pam Hollis

Tractor Supply Company

Senior Remedy Developer

Remedy Skilled Professional

615-440-4617 (Office)

615-484-4617 (Fax)

[EMAIL PROTECTED]

=20



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

--_=_NextPart_001_01C8BAA2.009746D7
Content-Type: text/html;
charset=us-ascii
Content-Transfer-Encoding: quoted-printable

**
html xmlns:o=3Durn:schemas-microsoft-com:office:office =
xmlns:w=3Durn:schemas-microsoft-com:office:word =
xmlns=3Dhttp://www.w3.org/TR/REC-html40;

head
META HTTP-EQUIV=3DContent-Type CONTENT=3Dtext/html; =
charset=3Dus-ascii
meta name=3DGenerator content=3DMicrosoft Word 11 (filtered medium)
style
!--
 /* Font Definitions */
 @font-face
{font-family:Raavi;
panose-1:2 0 5 0 0 0 0 0 0 0;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:Times New Roman;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
--
/style

/head

body lang=3DEN-US link=3Dblue vlink=3Dpurple

div class=3DSection1

p class=3DMsoNormalfont size=3D2 face=3DArialspan =
style=3D'font-size:10.0pt;
font-family:Arial'I am looking for a menu called: =
o:p/o:p/span/font/p

p class=3DMsoNormalfont size=3D2 face=3DArialspan =
style=3D'font-size:10.0pt;
font-family:Arial'INT:FNDSRM:WorkOrderRoleLabel-Q #8211; it is on the
CTM:CFG-ApplicationPreferences Form for the Work Order Tab for the Role
=
#8211;
does anyone have this?o:p/o:p/span/font/p

p class=3DMsoNormalfont size=3D2 face=3DArialspan =
style=3D'font-size:10.0pt;
font-family:Arial'o:pnbsp;/o:p/span/font/p

p class=3DMsoNormalfont size=3D2 face=3DArialspan =
style=3D'font-size:10.0pt;
font-family:Arial'Thankso:p/o:p/span/font/p

p class=3DMsoNormalfont size=3D2 face=3DArialspan =
style=3D'font-size:10.0pt;
font-family:Arial'o:pnbsp;/o:p/span/font/p

p class=3DMsoNormalstrongbfont size=3D3 face=3DRaavispan =
style=3D'font-size:
12.0pt;font-family:Raavi'Pam =
Hollis/span/font/b/strongo:p/o:p/p

p class=3DMsoNormalstrongbfont size=3D2 face=3DTimes New =
Romanspan
style=3D'font-size:10.0pt'Tractor Supply =
Company/span/font/b/strongo:p/o:p/p

p class=3DMsoNormalfont size=3D2 face=3DTimes New Romanspan =
style=3D'font-size:
10.0pt'Senior Remedy Developer/span/fonto:p/o:p/p

p class=3DMsoNormalfont size=3D2 face=3DTimes New Romanspan =
style=3D'font-size:
10.0pt'Remedy Skilled Professional/span/fonto:p/o:p/p

p class=3DMsoNormalfont size=3D2 face=3DTimes New Romanspan =
style=3D'font-size:
10.0pt'615-440-4617 (Office)/span/fonto:p/o:p/p

p class=3DMsoNormalfont size=3D2 face=3DTimes New Romanspan =
style=3D'font-size:
10.0pt'615-484-4617 (Fax)/span/fonto:p/o:p/p

p class=3DMsoNormalfont size=3D2 face=3DTimes New Romanspan =
style=3D'font-size:
10.0pt'a =
href=3Dmailto:[EMAIL PROTECTED][EMAIL PROTECTED]/a
/=
span/fonto:p/o:p/p

p class=3DMsoNormalfont size=3D3 face=3DTimes New Romanspan =
style=3D'font-size:
12.0pt'o:pnbsp;/o:p/span/font/p

/div

/body

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

--_=_NextPart_001_01C8BAA2.009746D7--


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

___
UNSUBSCRIBE or access ARSlist 

Re: Menu Missing - 7.1 ARSysmtem

2008-05-20 Thread Decou, Candace M
I don't have that one either - Donald perhaps?  It looks like you are
missing any of the specific menus related to SRM.
:)  

Candace DeCou

DOI Remedy Systems Analyst 
Verizon Business 
Office:  (408) 371-1112

Email: [EMAIL PROTECTED] 

 

Verizon Business - global capability, personal accountability. 

This e-mail is strictly confidential and intended only for use by the
addressee unless otherwise indicated


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Pam Hollis
Sent: Tuesday, May 20, 2008 11:54 AM
To: arslist@ARSLIST.ORG
Subject: Re: Menu Missing - 7.1 ARSysmtem

Thank you!

Does anyone have the following menu - I found one more missing.

xSYS:MNU:InfraChangeRoleCAB_locale-Q

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Savant, [EMAIL PROTECTED]
Sent: Tuesday, May 20, 2008 1:27 PM
To: arslist@ARSLIST.ORG
Subject: Re: Menu Missing - 7.1 ARSysmtem

We have the menu (see attached), I believe it's from SRM 2.1 p001.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Pam Hollis
Sent: Tuesday, May 20, 2008 10:51 AM
To: arslist@ARSLIST.ORG
Subject: Menu Missing - 7.1 ARSysmtem

This is a multi-part message in MIME format.

--_=_NextPart_001_01C8BAA2.009746D7
Content-Type: text/plain;
charset=us-ascii
Content-Transfer-Encoding: quoted-printable

I am looking for a menu called:=20

INT:FNDSRM:WorkOrderRoleLabel-Q - it is on the
CTM:CFG-ApplicationPreferences Form for the Work Order Tab for the Role
- does anyone have this?

=20

Thanks

=20

Pam Hollis

Tractor Supply Company

Senior Remedy Developer

Remedy Skilled Professional

615-440-4617 (Office)

615-484-4617 (Fax)

[EMAIL PROTECTED]

=20



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

--_=_NextPart_001_01C8BAA2.009746D7
Content-Type: text/html;
charset=us-ascii
Content-Transfer-Encoding: quoted-printable

**
html xmlns:o=3Durn:schemas-microsoft-com:office:office =
xmlns:w=3Durn:schemas-microsoft-com:office:word =
xmlns=3Dhttp://www.w3.org/TR/REC-html40;

head
META HTTP-EQUIV=3DContent-Type CONTENT=3Dtext/html; =
charset=3Dus-ascii
meta name=3DGenerator content=3DMicrosoft Word 11 (filtered medium)
style
!--
 /* Font Definitions */
 @font-face
{font-family:Raavi;
panose-1:2 0 5 0 0 0 0 0 0 0;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:Times New Roman;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
--
/style

/head

body lang=3DEN-US link=3Dblue vlink=3Dpurple

div class=3DSection1

p class=3DMsoNormalfont size=3D2 face=3DArialspan =
style=3D'font-size:10.0pt;
font-family:Arial'I am looking for a menu called: =
o:p/o:p/span/font/p

p class=3DMsoNormalfont size=3D2 face=3DArialspan =
style=3D'font-size:10.0pt;
font-family:Arial'INT:FNDSRM:WorkOrderRoleLabel-Q #8211; it is on the
CTM:CFG-ApplicationPreferences Form for the Work Order Tab for the Role
=
#8211;
does anyone have this?o:p/o:p/span/font/p

p class=3DMsoNormalfont size=3D2 face=3DArialspan =
style=3D'font-size:10.0pt;
font-family:Arial'o:pnbsp;/o:p/span/font/p

p class=3DMsoNormalfont size=3D2 face=3DArialspan =
style=3D'font-size:10.0pt;
font-family:Arial'Thankso:p/o:p/span/font/p

p class=3DMsoNormalfont size=3D2 face=3DArialspan =
style=3D'font-size:10.0pt;
font-family:Arial'o:pnbsp;/o:p/span/font/p

p class=3DMsoNormalstrongbfont size=3D3 face=3DRaavispan =
style=3D'font-size:
12.0pt;font-family:Raavi'Pam =
Hollis/span/font/b/strongo:p/o:p/p

p class=3DMsoNormalstrongbfont size=3D2 face=3DTimes New =
Romanspan
style=3D'font-size:10.0pt'Tractor Supply =
Company/span/font/b/strongo:p/o:p/p

p class=3DMsoNormalfont size=3D2 face=3DTimes New Romanspan =
style=3D'font-size:
10.0pt'Senior Remedy Developer/span/fonto:p/o:p/p

p class=3DMsoNormalfont size=3D2 face=3DTimes New Romanspan =
style=3D'font-size:
10.0pt'Remedy Skilled Professional/span/fonto:p/o:p/p

p class=3DMsoNormalfont size=3D2 face=3DTimes New Romanspan =
style=3D'font-size:
10.0pt'615-440-4617 (Office)/span/fonto:p/o:p/p

p class=3DMsoNormalfont size=3D2 face=3DTimes New Romanspan =
style=3D'font-size:
10.0pt'615-484-4617 (Fax)/span/fonto:p/o:p/p

p class=3DMsoNormalfont size=3D2 face=3DTimes New Romanspan =
style=3D'font-size:
10.0pt'a 

Re: Menu Missing - 7.1 ARSysmtem

2008-05-20 Thread Pam Hollis
Yeah I only have the ITSM Suite not SRM - but I am finding with just
ITSM - it is looking for some information from SRM even though it is not
installed.  This is one of those things.  This menu is attached to a
field on the CTM:CFG-ApplicationPreference Form - and you get an error
when you open because the menu is missing.

I am also finding in the logs that there are some other references
missing when starting the web - I believe most are with SRM.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Decou, Candace M
Sent: Tuesday, May 20, 2008 1:56 PM
To: arslist@ARSLIST.ORG
Subject: Re: Menu Missing - 7.1 ARSysmtem

Thanks Donald - I guess that makes sense since I only have full ITSM and
not SRM installed - thus the missing menu.  Not sure if that is the same
for Pam or not, but now it does make sense.  I've saved it off just in
case I need it too.
:)
  

Candace DeCou

DOI Remedy Systems Analyst 
Verizon Business 
Office:  (408) 371-1112

Email: [EMAIL PROTECTED] 

 

Verizon Business - global capability, personal accountability. 

This e-mail is strictly confidential and intended only for use by the
addressee unless otherwise indicated


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Savant, [EMAIL PROTECTED]
Sent: Tuesday, May 20, 2008 11:27 AM
To: arslist@ARSLIST.ORG
Subject: Re: Menu Missing - 7.1 ARSysmtem

We have the menu (see attached), I believe it's from SRM 2.1 p001.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Pam Hollis
Sent: Tuesday, May 20, 2008 10:51 AM
To: arslist@ARSLIST.ORG
Subject: Menu Missing - 7.1 ARSysmtem

This is a multi-part message in MIME format.

--_=_NextPart_001_01C8BAA2.009746D7
Content-Type: text/plain;
charset=us-ascii
Content-Transfer-Encoding: quoted-printable

I am looking for a menu called:=20

INT:FNDSRM:WorkOrderRoleLabel-Q - it is on the
CTM:CFG-ApplicationPreferences Form for the Work Order Tab for the Role
- does anyone have this?

=20

Thanks

=20

Pam Hollis

Tractor Supply Company

Senior Remedy Developer

Remedy Skilled Professional

615-440-4617 (Office)

615-484-4617 (Fax)

[EMAIL PROTECTED]

=20



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

--_=_NextPart_001_01C8BAA2.009746D7
Content-Type: text/html;
charset=us-ascii
Content-Transfer-Encoding: quoted-printable

**
html xmlns:o=3Durn:schemas-microsoft-com:office:office =
xmlns:w=3Durn:schemas-microsoft-com:office:word =
xmlns=3Dhttp://www.w3.org/TR/REC-html40;

head
META HTTP-EQUIV=3DContent-Type CONTENT=3Dtext/html; =
charset=3Dus-ascii
meta name=3DGenerator content=3DMicrosoft Word 11 (filtered medium)
style
!--
 /* Font Definitions */
 @font-face
{font-family:Raavi;
panose-1:2 0 5 0 0 0 0 0 0 0;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:Times New Roman;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
--
/style

/head

body lang=3DEN-US link=3Dblue vlink=3Dpurple

div class=3DSection1

p class=3DMsoNormalfont size=3D2 face=3DArialspan =
style=3D'font-size:10.0pt;
font-family:Arial'I am looking for a menu called: =
o:p/o:p/span/font/p

p class=3DMsoNormalfont size=3D2 face=3DArialspan =
style=3D'font-size:10.0pt;
font-family:Arial'INT:FNDSRM:WorkOrderRoleLabel-Q #8211; it is on the
CTM:CFG-ApplicationPreferences Form for the Work Order Tab for the Role
=
#8211;
does anyone have this?o:p/o:p/span/font/p

p class=3DMsoNormalfont size=3D2 face=3DArialspan =
style=3D'font-size:10.0pt;
font-family:Arial'o:pnbsp;/o:p/span/font/p

p class=3DMsoNormalfont size=3D2 face=3DArialspan =
style=3D'font-size:10.0pt;
font-family:Arial'Thankso:p/o:p/span/font/p

p class=3DMsoNormalfont size=3D2 face=3DArialspan =
style=3D'font-size:10.0pt;
font-family:Arial'o:pnbsp;/o:p/span/font/p

p class=3DMsoNormalstrongbfont size=3D3 face=3DRaavispan =
style=3D'font-size:
12.0pt;font-family:Raavi'Pam =
Hollis/span/font/b/strongo:p/o:p/p

p class=3DMsoNormalstrongbfont size=3D2 face=3DTimes New =
Romanspan
style=3D'font-size:10.0pt'Tractor Supply =
Company/span/font/b/strongo:p/o:p/p

p class=3DMsoNormalfont size=3D2 face=3DTimes New Romanspan =
style=3D'font-size:
10.0pt'Senior Remedy Developer/span/fonto:p/o:p/p

p 

Re: Menu Missing - 7.1 ARSysmtem

2008-05-20 Thread Decou, Candace M
Yep - I ran into a few issues in our dev environment on the app
preferences form too - missing fields - missing whatevers - references
to things that don't exist or things that do exist but are not set.  LOL
- now I know why.
Thanks Pam!
:)

Candace DeCou

DOI Remedy Systems Analyst 
Verizon Business 
Office:  (408) 371-1112

Email: [EMAIL PROTECTED] 

 

Verizon Business - global capability, personal accountability. 

This e-mail is strictly confidential and intended only for use by the
addressee unless otherwise indicated


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Pam Hollis
Sent: Tuesday, May 20, 2008 12:08 PM
To: arslist@ARSLIST.ORG
Subject: Re: Menu Missing - 7.1 ARSysmtem

Yeah I only have the ITSM Suite not SRM - but I am finding with just
ITSM - it is looking for some information from SRM even though it is not
installed.  This is one of those things.  This menu is attached to a
field on the CTM:CFG-ApplicationPreference Form - and you get an error
when you open because the menu is missing.

I am also finding in the logs that there are some other references
missing when starting the web - I believe most are with SRM.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Decou, Candace M
Sent: Tuesday, May 20, 2008 1:56 PM
To: arslist@ARSLIST.ORG
Subject: Re: Menu Missing - 7.1 ARSysmtem

Thanks Donald - I guess that makes sense since I only have full ITSM and
not SRM installed - thus the missing menu.  Not sure if that is the same
for Pam or not, but now it does make sense.  I've saved it off just in
case I need it too.
:)
  

Candace DeCou

DOI Remedy Systems Analyst 
Verizon Business 
Office:  (408) 371-1112

Email: [EMAIL PROTECTED] 

 

Verizon Business - global capability, personal accountability. 

This e-mail is strictly confidential and intended only for use by the
addressee unless otherwise indicated


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Savant, [EMAIL PROTECTED]
Sent: Tuesday, May 20, 2008 11:27 AM
To: arslist@ARSLIST.ORG
Subject: Re: Menu Missing - 7.1 ARSysmtem

We have the menu (see attached), I believe it's from SRM 2.1 p001.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Pam Hollis
Sent: Tuesday, May 20, 2008 10:51 AM
To: arslist@ARSLIST.ORG
Subject: Menu Missing - 7.1 ARSysmtem

This is a multi-part message in MIME format.

--_=_NextPart_001_01C8BAA2.009746D7
Content-Type: text/plain;
charset=us-ascii
Content-Transfer-Encoding: quoted-printable

I am looking for a menu called:=20

INT:FNDSRM:WorkOrderRoleLabel-Q - it is on the
CTM:CFG-ApplicationPreferences Form for the Work Order Tab for the Role
- does anyone have this?

=20

Thanks

=20

Pam Hollis

Tractor Supply Company

Senior Remedy Developer

Remedy Skilled Professional

615-440-4617 (Office)

615-484-4617 (Fax)

[EMAIL PROTECTED]

=20



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

--_=_NextPart_001_01C8BAA2.009746D7
Content-Type: text/html;
charset=us-ascii
Content-Transfer-Encoding: quoted-printable

**
html xmlns:o=3Durn:schemas-microsoft-com:office:office =
xmlns:w=3Durn:schemas-microsoft-com:office:word =
xmlns=3Dhttp://www.w3.org/TR/REC-html40;

head
META HTTP-EQUIV=3DContent-Type CONTENT=3Dtext/html; =
charset=3Dus-ascii
meta name=3DGenerator content=3DMicrosoft Word 11 (filtered medium)
style
!--
 /* Font Definitions */
 @font-face
{font-family:Raavi;
panose-1:2 0 5 0 0 0 0 0 0 0;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:Times New Roman;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
--
/style

/head

body lang=3DEN-US link=3Dblue vlink=3Dpurple

div class=3DSection1

p class=3DMsoNormalfont size=3D2 face=3DArialspan =
style=3D'font-size:10.0pt;
font-family:Arial'I am looking for a menu called: =
o:p/o:p/span/font/p

p class=3DMsoNormalfont size=3D2 face=3DArialspan =
style=3D'font-size:10.0pt;
font-family:Arial'INT:FNDSRM:WorkOrderRoleLabel-Q #8211; it is on the
CTM:CFG-ApplicationPreferences Form for the Work Order Tab for the Role
=
#8211;
does anyone have this?o:p/o:p/span/font/p

p class=3DMsoNormalfont size=3D2 face=3DArialspan =

Re: Menu Missing - 7.1 ARSysmtem

2008-05-20 Thread Savant, [EMAIL PROTECTED]
Nope, we don't have that one, with or without the leading 'x'.

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Decou, Candace M
Sent: Tuesday, May 20, 2008 12:05 PM
To: arslist@ARSLIST.ORG
Subject: Re: Menu Missing - 7.1 ARSysmtem

I don't have that one either - Donald perhaps?  It looks like you are
missing any of the specific menus related to SRM.
:) =20

Candace DeCou

DOI Remedy Systems Analyst=20
Verizon Business=20
Office:  (408) 371-1112

Email: [EMAIL PROTECTED]

=20

Verizon Business - global capability, personal accountability.=20

This e-mail is strictly confidential and intended only for use by the
addressee unless otherwise indicated


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Pam Hollis
Sent: Tuesday, May 20, 2008 11:54 AM
To: arslist@ARSLIST.ORG
Subject: Re: Menu Missing - 7.1 ARSysmtem

Thank you!

Does anyone have the following menu - I found one more missing.

xSYS:MNU:InfraChangeRoleCAB_locale-Q

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Savant, [EMAIL PROTECTED]
Sent: Tuesday, May 20, 2008 1:27 PM
To: arslist@ARSLIST.ORG
Subject: Re: Menu Missing - 7.1 ARSysmtem

We have the menu (see attached), I believe it's from SRM 2.1 p001.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Pam Hollis
Sent: Tuesday, May 20, 2008 10:51 AM
To: arslist@ARSLIST.ORG
Subject: Menu Missing - 7.1 ARSysmtem

This is a multi-part message in MIME format.

--_=3D_NextPart_001_01C8BAA2.009746D7
Content-Type: text/plain;
charset=3Dus-ascii
Content-Transfer-Encoding: quoted-printable

I am looking for a menu called:=3D20

INT:FNDSRM:WorkOrderRoleLabel-Q - it is on the
CTM:CFG-ApplicationPreferences Form for the Work Order Tab for the Role
- does anyone have this?

=3D20

Thanks

=3D20

Pam Hollis

Tractor Supply Company

Senior Remedy Developer

Remedy Skilled Professional

615-440-4617 (Office)

615-484-4617 (Fax)

[EMAIL PROTECTED]

=3D20



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

--_=3D_NextPart_001_01C8BAA2.009746D7
Content-Type: text/html;
charset=3Dus-ascii
Content-Transfer-Encoding: quoted-printable

**
html xmlns:o=3D3Durn:schemas-microsoft-com:office:office =3D
xmlns:w=3D3Durn:schemas-microsoft-com:office:word =3D
xmlns=3D3Dhttp://www.w3.org/TR/REC-html40;

head
META HTTP-EQUIV=3D3DContent-Type CONTENT=3D3Dtext/html; =3D
charset=3D3Dus-ascii
meta name=3D3DGenerator content=3D3DMicrosoft Word 11 (filtered =
medium)
style
!--
 /* Font Definitions */
 @font-face
{font-family:Raavi;
panose-1:2 0 5 0 0 0 0 0 0 0;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:Times New Roman;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
--
/style

/head

body lang=3D3DEN-US link=3D3Dblue vlink=3D3Dpurple

div class=3D3DSection1

p class=3D3DMsoNormalfont size=3D3D2 face=3D3DArialspan =3D
style=3D3D'font-size:10.0pt;
font-family:Arial'I am looking for a menu called: =3D
o:p/o:p/span/font/p

p class=3D3DMsoNormalfont size=3D3D2 face=3D3DArialspan =3D
style=3D3D'font-size:10.0pt;
font-family:Arial'INT:FNDSRM:WorkOrderRoleLabel-Q #8211; it is on the
CTM:CFG-ApplicationPreferences Form for the Work Order Tab for the Role
=3D
#8211;
does anyone have this?o:p/o:p/span/font/p

p class=3D3DMsoNormalfont size=3D3D2 face=3D3DArialspan =3D
style=3D3D'font-size:10.0pt;
font-family:Arial'o:pnbsp;/o:p/span/font/p

p class=3D3DMsoNormalfont size=3D3D2 face=3D3DArialspan =3D
style=3D3D'font-size:10.0pt;
font-family:Arial'Thankso:p/o:p/span/font/p

p class=3D3DMsoNormalfont size=3D3D2 face=3D3DArialspan =3D
style=3D3D'font-size:10.0pt;
font-family:Arial'o:pnbsp;/o:p/span/font/p

p class=3D3DMsoNormalstrongbfont size=3D3D3 face=3D3DRaavispan =
=3D
style=3D3D'font-size:
12.0pt;font-family:Raavi'Pam =3D
Hollis/span/font/b/strongo:p/o:p/p

p class=3D3DMsoNormalstrongbfont size=3D3D2 face=3D3DTimes New =
=3D
Romanspan
style=3D3D'font-size:10.0pt'Tractor Supply =3D
Company/span/font/b/strongo:p/o:p/p

p class=3D3DMsoNormalfont size=3D3D2 face=3D3DTimes New Romanspan =
=3D
style=3D3D'font-size:
10.0pt'Senior Remedy Developer/span/fonto:p/o:p/p

p class=3D3DMsoNormalfont 

Remedy Position available--Charleston, SC

2008-05-20 Thread Jennifer Meyer
Mystikal Solutions is looking for candidates to fill two full-time, permanent 
positions in Charleston, SC for experienced Remedy administrator/developers. In 
short, we're looking for folks with at least 2 years of Remedy experience, 
experience with Remedy 7.X, and the ability to gain a security clearance. 
We'll give preference to candidates with at least 5 years of Remedy experience, 
ITSM, ITIL, MSSQL, and Windows server experience. Salaries are highly 
competitive for the Remedy skill set, and the cost of living in Charleston is 
extremely reasonable. 
Please respond off-list if you are interested in these positions.

Jennifer Meyer
Data Manager
Mystikal Solutions
Bringing Order to Chaos
desk: 843-218-7120
cell: 919-995-2402
[EMAIL PROTECTED]
[EMAIL PROTECTED]

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


Missing Workflow - ARSYSTEM 7.1 ITSM

2008-05-20 Thread Pam Hollis
I am actually looking for all the following:  

 

I am not sure if menus, forms or what - but through the Catalina logs it
is making reference to these and it can't find.

 

SCRSRM:REQ:Start

INT:FNDSRS:BuildQualification_WorkOrder

SHR:SHR:PrefixIDGenerator

 

I believe this is workflow with the Service Request Applications - but I
only have the ITSM Suite - I do not have the Service Request Application
- which these are not causing problems for user - but I am trying to
clear all errors out of log files.  If anyone has can you please send me
a def with the workflow and associated workflow would be appreciated.

 

 

Pam Hollis

Tractor Supply Company

Senior Remedy Developer

Remedy Skilled Professional

615-440-4617 (Office)

615-484-4617 (Fax)

[EMAIL PROTECTED]

 


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


Re: SRM 2.1 Patch 1

2008-05-20 Thread Joe DeSouza
Peter,
I'd suspect the disk space if it cannot 'build' the list... Do you have enough 
space in the drive that contains the Windows Temp folder?
Joe


- Original Message 
From: PCR Remedy [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Tuesday, May 20, 2008 12:04:45 AM
Subject: SRM 2.1 Patch 1

** 
Does anybody successfully installed patch 1 for SRM 2.1?
I cant make it work in a localized server, I got an error.  I send attached.
 
Thanks in advance.
 
Peter


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

Qualification Error - Strange?

2008-05-20 Thread Kathy Morris
Hello all,
 
I ran this qualification:
 
'Assignee+' = Michael Davis OR 'Assignee+' = Gurpreet Savi  AND 'Status*' 
= 3
 
Result:  status values that such as Closed and  Cancelled appeared that have 
a value of 5 and 6?? 
 
When I modified the qualification:
('Assignee+' = Michael Davis OR 'Assignee+' = Gurpreet  Savi) AND 
'Status*' = 3
Result:  the values that were less than or equal to 3  appeared correctly.
 
What logic is this based on?  
 
Sometimes when I use LIKE %Mary Smith I find the  name faster than if I type 
= Mary Smith - never understood  why.



**Wondering what's for Dinner Tonight? Get new twists on family 
favorites at AOL Food.  
(http://food.aol.com/dinner-tonight?NCID=aolfod000301)

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


Re: Qualification Error - Strange?

2008-05-20 Thread john rosquist
Kathy,

 

It is Boolean logic as implemented by you favorite SQL optimizer.

 

X or Y and Z == x or ( y and z) because AND has a higher precedence than OR.

 

John

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kathy Morris
Sent: Tuesday, May 20, 2008 8:27 PM
To: arslist@ARSLIST.ORG
Subject: Qualification Error - Strange?

 

Hello all,

 

I ran this qualification:

 

'Assignee+' = Michael Davis OR 'Assignee+' = Gurpreet Savi AND 'Status*'
= 3

 

Result:  status values that such as Closed and Cancelled appeared that have
a value of 5 and 6?? 

 

When I modified the qualification:

('Assignee+' = Michael Davis OR 'Assignee+' = Gurpreet Savi) AND
'Status*' = 3

Result:  the values that were less than or equal to 3 appeared correctly.

 

What logic is this based on?  

 

Sometimes when I use LIKE %Mary Smith I find the name faster than if I type
= Mary Smith - never understood why.





  _  

Wondering what's for Dinner Tonight? Get new
http://food.aol.com/dinner-tonight?NCID=aolfod000301  twists on
family favorites at AOL Food.

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



E-mail message checked by Internet Security (5.5.0.191)
Database version: 5.09860
http://www.pctools.com/Internet-Security/





E-mail message checked by Internet Security (5.5.0.191)
Database version: 5.09860
http://www.pctools.com/Internet-Security/

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


Re: Qualification Error - Strange?

2008-05-20 Thread Andrew Fremont
The first qualification would be interpreted as:
('Assignee+' = Michael Davis) OR (( 'Assignee+' = Gurpreet Savi) AND
('Status*' = 3))
 That explains the result return all entries with Status as they match with
Michael Davis

AF

On Tue, May 20, 2008 at 5:27 PM, Kathy Morris [EMAIL PROTECTED]
wrote:

 ** Hello all,

 I ran this qualification:

 'Assignee+' = Michael Davis OR 'Assignee+' = Gurpreet Savi AND
 'Status*' = 3

 Result:  status values that such as Closed and Cancelled appeared that have
 a value of 5 and 6??

 When I modified the qualification:
 ('Assignee+' = Michael Davis OR 'Assignee+' = Gurpreet Savi) AND
 'Status*' = 3
 Result:  the values that were less than or equal to 3 appeared correctly.

 What logic is this based on?

 Sometimes when I use LIKE %Mary Smith I find the name faster than if I type
 = Mary Smith - never understood why.



 --
 Wondering what's for Dinner Tonight? Get new twists on family favorites at
 AOL Food http://food.aol.com/dinner-tonight?NCID=aolfod000301.
 __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: Qualification Error - Strange?

2008-05-20 Thread Lisa Westerfield
It literally reads the qualification as:  
assigned = x ,regardless of status, OR (assigned = x and status  less than 3).

It assumes the and and the last qualification before it are paired together.  
When you added the brackets you specified (this group of qualifications) PLUS 
this qualification.

If they had all been or, or and, it wouldn't have been a problem.

Hope that helps.

-Original Message-
From: Kathy Morris [EMAIL PROTECTED]
Sent: Tuesday, May 20, 2008 7:26 PM
To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG
Subject: Qualification Error - Strange?

Hello all,
 
I ran this qualification:
 
'Assignee+' = Michael Davis OR 'Assignee+' = Gurpreet Savi  AND 'Status*' 
= 3
 
Result:  status values that such as Closed and  Cancelled appeared that have 
a value of 5 and 6?? 
 
When I modified the qualification:
('Assignee+' = Michael Davis OR 'Assignee+' = Gurpreet  Savi) AND 
'Status*' = 3
Result:  the values that were less than or equal to 3  appeared correctly.
 
What logic is this based on?  
 
Sometimes when I use LIKE %Mary Smith I find the  name faster than if I type 
= Mary Smith - never understood  why.



**Wondering what's for Dinner Tonight? Get new twists on family 
favorites at AOL Food.  
(http://food.aol.com/dinner-tonight?NCID=aolfod000301)

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
This message is subject to and does not create or vary any contractual 
relationship between TuringSMI, SMI Technologies, SMI Telco, its subsidiaries 
or affiliates and you. Internet communications are not secure and therefore the 
TuringSMI Group does not accept any legal responsibility for the contents of 
this message. Any views or opinions expressed are those of the author.  This 
message is intended for the addressee(s) only and its contents and any attached 
files are strictly confidential. If you have received it in error, please 
contact the sender on the number above.

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


Importing licenses through Command Prompt.

2008-05-20 Thread ITSM Support

*Hi Listers,*

Can I import licenses through Command Prompt?

Regards,
*Mahendra.

Vyom Labs Pvt. Ltd.
An ISO 2 certified company.
Consulting | Outsourcing | Training || BMC Remedy BSM | ITIL
Web : www.vyomlabs.com
*

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


Re: Remedy Table Indexes

2008-05-20 Thread ITSM Support

*Hi Luksha Timothy,*

It's true that Request ID is the only implicitely indexed field in Remedy.
But,in form properties,what is the status of Indexes ?Are there any 
fields indexed?Check that also.
There may be work flows related to Direct SQL action or SQL Query in 
set fields action in which primary key may be configered.


Hope this helps...
Regards,
*
Sandeep

Vyom Labs Pvt. Ltd.
An ISO 2 certified company.
Consulting | Outsourcing | Training || BMC Remedy BSM | ITIL
Web : www.vyomlabs.com
*



Luksha, Timothy wrote:

I was recently asked to check which columns of one of our remedy forms
were indexed.  The documentation gave me the impression that only
Request Id would be indexed automatically, which makes sense since it
is the primary key.  Remedy administrator indicated that two other
columns had indexes.  When I looked at the Oracle table in a database
tool I have, there were four indexes listed.  The one that wasn't
appearing in remedy administrator mapped to the Date Submitted field.


Does this simply indicate that someone added the index through Oracle
without asking remedy to create it or is something more funny going on?

Thanks,

Tim

___
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