Re: Moving Data from Oracle to SQL

2008-04-07 Thread Misi Mladoniczky
Hi,

Why not use the free and robust RRR|Chive-tool. It will give you detailed
logging, it is free, and it can move everything in a single pass.

The incremental transfer will make the work flexible:
Week 1 - Move the bulk of the data
Week 2 - Investigate, fix and handle problems
Week 3 - Test the system
Week 4 - Automatically clean up the test data and update from your current
production system.
Week 4 Friday evening - Do a final incremental transfer and change the
server.

Best Regards - Misi, RRR AB, http://www.rrr.se

Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
* RRR|Translator - Manage and automate your language translations.
Find these products, and many free tools and utilities, at http://rrr.se.

 Why not use Migrator?


 -Original Message-
 From: Action Request System discussion list(ARSList) on behalf of Kaiser
 Norm E CIV USAF 96 CS/SCCE
 Sent: Fri 4/4/2008 10:54 AM
 To: arslist@ARSLIST.ORG
 Subject: Re: Moving Data from Oracle to SQL

 Why not export the data using the import/export tool and then import it
 with the import/export tool?

 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of Covert, Jack
 Sent: Friday, April 04, 2008 12:34 PM
 To: arslist@ARSLIST.ORG
 Subject: Moving Data from Oracle to SQL

 **

 Hi guys.  We're migrating data from Remedy 5 (Oracle 11) to Remedy 7
 (SQL 2005).  We're having a heck of a time w/ long fields.  Anybody have
 any experience/advice on how to move millions of records with long
 fields from one system to the other?



 Thanks everybody, I don't know what I'd do w/o this group!



 Jack Covert



 Corporate IT

 Enterprise Systems Management

 Remedy Support Team



 Remedy Support Team Home Page

 http://collaborate.mckesson.com/sites/esm/remedy
 http://collaborate.mckesson.com/sites/esm/remedy



 ESM - Leveraging the power of automation for the benefit of the business



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

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


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

 --
 This message was scanned by ESVA and is believed to be clean.



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


CSS 5.6

2008-04-07 Thread John Joseph

Hi All,

In the out-of-the-box CSS 5.6, can an existing issue be modified by a person 
who is not configured within the system?

Best Regards,
John Joseph


_
Video: Get a glimpse of the latest in Cricket, Bollywood, News and Fashion. 
Only on MSN videos.
http://video.msn.com/?mkt=en-in
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


7.1 Client .6.3 Sever. enabling admin console

2008-04-07 Thread Meenakshinathan
Hi All,

We are accessing our 6.3 server via 7.1 client. We wan to access the
admin console via this 7.1 client. I heard that if we change some
registry settings, we can bring the admin console. Can you please help
me on this how to bring the same for me?

I searched in the archive post, but i could not locate it properly.
Please help me..
Thanks,
Meenakshinathan

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


Re: Question: Allow Request Creation

2008-04-07 Thread Tony Worthington
Not sure.  We don't use change yet so I don't have a lot of experience...


-- 
Tony Worthington
Sr. Technical Analyst
Kohl's Department Stores
[EMAIL PROTECTED]
262-703-5911



T. Dee [EMAIL PROTECTED] 
Sent by: Action Request System discussion list(ARSList) 
arslist@ARSLIST.ORG
04/04/2008 02:43 PM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Re: Question: Allow Request Creation






** 
Tony I turned this on (clicked button) - saved the Change, but it is not 
showing up in the Requestor Console - is there something else that has to 
be done?
 
Thanks.
 
Ty


 
On 4/4/08, Tony Worthington [EMAIL PROTECTED] wrote: 
** 
Yup.  A request is required for the Change to show on the Requester 
Console. 


-- 
Tony Worthington
Sr. Technical Analyst
Kohl's Department Stores
[EMAIL PROTECTED]
262-703-5911 


T. Dee [EMAIL PROTECTED] 
Sent by: Action Request System discussion list(ARSList) 
arslist@ARSLIST.ORG 
04/04/2008 02:12 PM 

Please respond to
arslist@ARSLIST.ORG



To
arslist@ARSLIST.ORG 
cc

Subject
Question: Allow Request Creation









I have looked in both the Change Management User's Guide and
Configuration Guide (both 7.0) and there is nothing that talks about
the option on the left hand side of Change called Create Request
Creation.

Does anyone know what this is?

THANKS!

Happy Friday :-)

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

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

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

CONFIDENTIALITY NOTICE: 
This is a transmission from Kohl's Department Stores, Inc.
and may contain information which is confidential and proprietary.
If you are not the addressee, any disclosure, copying or distribution or use of 
the contents of this message is expressly prohibited.
If you have received this transmission in error, please destroy it and notify 
us immediately at 262-703-7000.

CAUTION:
Internet and e-mail communications are Kohl's property and Kohl's reserves the 
right to retrieve and read any message created, sent and received.  Kohl's 
reserves the right to monitor messages by authorized Kohl's Associates at any 
time
without any further consent.

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


Job: Multiple Openings - Contract / Contract-to-Hire / Permanent - Kforce

2008-04-07 Thread Kitchen, Joshua T
Dear List,
 
I am compiling all of my open Remedy requirements at the present moment.
Any help is always appreciated.  Hope everyone had a great weekend,
weather is definately getting better here in Dayton, OH.
 
Table of Contents:
1)  Remedy Developer / US Citizen / Dayton, OH / 4 Month Contract
2)  Remedy Architect / US Citizen / North Carolina / 6 Month Contract
3)  Remedy Administrator / US Citizen or Green Card / Woodland Hills, CA
/ Permanent
4)  Remedy Developer / US Citizen or Green Card / Baltimore, MD /
Permanent
5)  Remedy Architect / US Citizen / Atlanta, GA / 18 Month Contract
 
Description of Opportunities:
1)  

Title:  Remedy TTS Programmer or SC06

Location:  Dayton, OH 

Telecommuting:  Not an Option

Authorization Status:  US Citizens (Will be processed for Secret
Clearance) 

Duration:  4 Month Part-Time Contract  (28 Hours 1st Month /
32-Hours 2nd Month / 38 Hours 3rd  4th Months) 

Type:  Straight Contract with possible extension

Requirements:

*   US Citizen 
*   1 to 5 years experience with Remedy Action Request
System (Releases 6 thru 7) and programming using the Remedy Language 
*   Experience with Remedy IT Service Management Suite
(ITSM) Release 7 
*   Database Experience Required (SQL/Oracle) 

2)  


Title:  Remedy Architect
Location:   North Carolina 
Duration:   6 Month Contract
Telecommuting:  Not an Option
Work Authorization:  US Citizens Only

Industry:   DoD 
About Client:One of the world's leading providers of systems
integration and other technology services, including application
development, data hosting, networking, and management consulting. It is
also a leading provider of business process outsourcing (BPO) services
in such areas as billing and payment processing, customer relationship
management (CRM), and human resources. A major government and defense
contractor. 
Description:  
** Subject Matter Expert (SME) in BMC REMEDY* IT Service
Management Suite design, implementation, advanced configuration,
management, and administration. Experience managing and participating in
the design and implementation of custom and OEM enterprise REMEDY
solutions. is required 

** Subject Matter Expert (SME) in the UK OGC ITIL* framework and
procedures 

** 3+ years of experience using BMC REMEDY IT Service Management
Suite tools;  

** Demonstrated the ability to design, implement, and maintain
an enterprise REMEDY IT Service Management Suite solution.  

** Demonstrated the ability to implement REMEDY Service Desk in
a distributed environment. 

 Technologies:  
Service Desk / ITSM / V 7.x / ITIL 
 

3)  


Title:  Remedy Administrator
Location:  Woodland Hills, CA 
Duration:  Direct-Hire / Permanent 
Salary:   65K-80K

Industry:  Insurance
About Client:  2.7 Billion dollar company provides Workers'
Compensation insurance.
Description:  Administration and development in a high
availability environment.  Develop workflows, active links,
customizations, escalations in version 6.x or 7.x. 
* Administer permissions, security, access, logins,
passwords in  Remedy 

* Administer and develop forms, fields, menus and
workflows in  Remedy 

* Build AR System filters and active links in order to
automate responses to user actions and enforce business rules

* Create Remedy training documentation in PowerPoint and
Word for Webinars with employees

* Troubleshoot complex issues regarding forms,
workflows, and log files in  Remedy 

Skills: BMC REMEDY (v7.x preferred, v6.x acceptable) products including
but not limited to Configuration Management DB (CMDB), IT Service
Management (ITSM) Suite including Analytics, Change Management,
Flashboards, Migrator, Service Desk, AR System, Service Level Management
(SLM), and Service Request Management.  Excellent verbal and written
communication skills; ability to understand and articulate ideas and
concepts in both verbal and written form. Process and Detail Oriented.
Experience with Oracle RDBMS, SQL.  
 
 
4)


Title:  Remedy Developer
Location:   Baltimore, MD 
Duration:   6 Month Contract to Hire or Permanent 
About Client:  Our International client specializes in global
management and technology consulting. Our client is known for their deep
industry experience and high customer satisfaction. They collaborate
with clients in government and industry in 60 countries to solve their
most pressing challenges from strategy through execution. 
Skillset: REMEDY v7.x with  Help Desk, Asset, Change, CMDB,
Migrator 
Detailed Job Description: 

 Mid level Remedy Developer 

User can see fields with no permissions

2008-04-07 Thread Dwayne Martin
Dear List,

We have a permission group called “IT”.  We have a form with some fields that 
“IT” used to have permission to, but we have decided to remove those 
permissions.  So I went into the Admin Tool and removed “IT” from the 
permission list in each field.

But when a test user with only “IT” permissions opens the form he can still see 
all the fields.  If he tries to change the data and save the form he gets, 
“ARERR [333] You have no access to field : [field name]”, but with “no access” 
he shouldn’t even be able to see the field.

I cleared the cache, and made a cosmetic change, and the cosmetic change 
appears on the screen, so it isn’t a caching issue.

What is going on?

(ARS 7.1, RH Linux server, Oracle 10.2 db)

Dwayne Martin
James Madison University


Re: User can see fields with no permissions

2008-04-07 Thread David Sanders
Hi Dwayne

Do you have Allow Any User to Submit checked for these fields??

David Sanders
Remedy Solution Architect
Enterprise Service Suite @ Work
==
ARS List Award Winner 2005
Best 3rd party Remedy Application
 
See the ESS Concepts Guide
 
tel +44 1494 468980
mobile +44 7710 377761
email [EMAIL PROTECTED]
 
web http://www.westoverconsulting.co.uk
 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 2:29 PM
To: arslist@ARSLIST.ORG
Subject: User can see fields with no permissions

Dear List,

We have a permission group called IT.  We have a form with some fields
that IT used to have permission to, but we have decided to remove those
permissions.  So I went into the Admin Tool and removed IT from the
permission list in each field.

But when a test user with only IT permissions opens the form he can still
see all the fields.  If he tries to change the data and save the form he
gets, ARERR [333] You have no access to field : [field name], but with no
access he shouldn't even be able to see the field.

I cleared the cache, and made a cosmetic change, and the cosmetic change
appears on the screen, so it isn't a caching issue.

What is going on?

(ARS 7.1, RH Linux server, Oracle 10.2 db)

Dwayne Martin
James Madison University

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


Re: User can see fields with no permissions

2008-04-07 Thread Tanner, Doug
The test user is also a member of Public
All users are a member of Public so check the field for Public
permissions
(also: Allow any user to Submit)

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 9:29 AM
To: arslist@ARSLIST.ORG
Subject: User can see fields with no permissions

Dear List,

We have a permission group called IT.  We have a form with some fields
that IT used to have permission to, but we have decided to remove
those permissions.  So I went into the Admin Tool and removed IT from
the permission list in each field.

But when a test user with only IT permissions opens the form he can
still see all the fields.  If he tries to change the data and save the
form he gets, ARERR [333] You have no access to field : [field name],
but with no access he shouldn't even be able to see the field.

I cleared the cache, and made a cosmetic change, and the cosmetic change
appears on the screen, so it isn't a caching issue.

What is going on?

(ARS 7.1, RH Linux server, Oracle 10.2 db)

Dwayne Martin
James Madison University

DISCLAIMER Important! This message is intended for the above named person(s) 
only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient 
of this e-mail and have received it in error, please immediately notify the 
sender by return email and then delete it from your mailbox. This message may 
be protected by the attorney-client privilege and/or work product doctrine.  
Accessing, copying, disseminating or re-using any of the information contained 
in this e-mail by anyone other than the intended recipient is strictly 
prohibited. Finally, you should check this email and any attachments for the 
presence of viruses, as the sender accepts no liability for any damage caused 
by any virus transmitted by this email.  Thank you.

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


Re: 7.1 Client .6.3 Sever. enabling admin console

2008-04-07 Thread LJ Longwing
I think you may be a bit confused.  The Admin Console that comes with the
client requires a 7.1 Server, not client, so you won't be able to have that
until you upgrade your server.  If however you are looking for the 'Server
Preferences' in the Admin tool, yes, you can check the release notes for
instructions on enabling that feature in a 7.1 Admin tool. 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Meenakshinathan
Sent: Monday, April 07, 2008 4:29 AM
To: arslist@ARSLIST.ORG
Subject: 7.1 Client .6.3 Sever. enabling admin console

Hi All,

We are accessing our 6.3 server via 7.1 client. We wan to access the admin
console via this 7.1 client. I heard that if we change some registry
settings, we can bring the admin console. Can you please help me on this how
to bring the same for me?

I searched in the archive post, but i could not locate it properly.
Please help me..
Thanks,
Meenakshinathan


___
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: User can see fields with no permissions

2008-04-07 Thread LJ Longwing
Dwayne,
Sorry to say, but removing permission to the field removes their permission
to see what's in the field, not the field itself.  The exceptions to this
would be 'Trim' fields, buttons, boxes, etc, because those all disappear
when you don't have access, but when you don't have access to a Char, Int,
etc you simply can't see the contents of the field, but you can still see
the field itself 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 7:29 AM
To: arslist@ARSLIST.ORG
Subject: User can see fields with no permissions

Dear List,

We have a permission group called IT.  We have a form with some fields
that IT used to have permission to, but we have decided to remove those
permissions.  So I went into the Admin Tool and removed IT from the
permission list in each field.

But when a test user with only IT permissions opens the form he can still
see all the fields.  If he tries to change the data and save the form he
gets, ARERR [333] You have no access to field : [field name], but with no
access he shouldn't even be able to see the field.

I cleared the cache, and made a cosmetic change, and the cosmetic change
appears on the screen, so it isn't a caching issue.

What is going on?

(ARS 7.1, RH Linux server, Oracle 10.2 db)

Dwayne Martin
James Madison University

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


Re: How to know when a table is full ??

2008-04-07 Thread john rosquist
On a test form create a filter or esc.

select form name
firing conditions ...
if action-set fields-Read value-direct SQL select count(*) from t...
Name field to put the result into - SQL result col 1

Good luck,
John Rosquist
Windward



- Original Message 
From: Tadeu Augusto Dutra Pinto [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Thursday, April 3, 2008 2:00:46 PM
Subject: How to know when a table is full ??

** 
Hi All.
 
How could I execute a command to get the quantity of records in a table?
 
Our test environment has not license ... and because of this we have a limit of 
2k records for each table...
I'd like to know when my table is full (i.e. if there is with 2k records)
 
Is there some way for me obtain this feature through an workflow object (Filter 
, AL , etc...) ???
 
P.S.: I've thought in to execute a Direct SQL command ... but this action 
doesn't return nothing...
 
 
Can somebody help me?
 
 
 
Thankx-in-advance!
 
 
Tadeu Augusto Dutra Pinto
-
IT Web Services ATM 
Cinq Technologies
http://www.cinq.com.br 
[EMAIL PROTECTED]
Fone: 41 3018-2833 - Cinq
Fone: 41 2107-5736 - HSBC Outsourcing
-
Confiabilidade, Inovação e Qualidade em T.I.
__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___


  

You rock. That's why Blockbuster's offering you one month of Blockbuster Total 
Access, No Cost.  
http://tc.deals.yahoo.com/tc/blockbuster/text5.com

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

Re: User can see fields with no permissions

2008-04-07 Thread Dwayne Martin
But they CAN see the contents of the field itself.  If there is data there the 
test person can read it.

Dwayne

 Original message 
Date: Mon, 7 Apr 2008 07:51:52 -0600
From: LJ Longwing [EMAIL PROTECTED]  
Subject: Re: User can see fields with no permissions  
To: arslist@ARSLIST.ORG

Dwayne,
Sorry to say, but removing permission to the field removes their permission
to see what's in the field, not the field itself.  The exceptions to this
would be 'Trim' fields, buttons, boxes, etc, because those all disappear
when you don't have access, but when you don't have access to a Char, Int,
etc you simply can't see the contents of the field, but you can still see
the field itself 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 7:29 AM
To: arslist@ARSLIST.ORG
Subject: User can see fields with no permissions

Dear List,

We have a permission group called IT.  We have a form with some fields
that IT used to have permission to, but we have decided to remove those
permissions.  So I went into the Admin Tool and removed IT from the
permission list in each field.

But when a test user with only IT permissions opens the form he can still
see all the fields.  If he tries to change the data and save the form he
gets, ARERR [333] You have no access to field : [field name], but with no
access he shouldn't even be able to see the field.

I cleared the cache, and made a cosmetic change, and the cosmetic change
appears on the screen, so it isn't a caching issue.

What is going on?

(ARS 7.1, RH Linux server, Oracle 10.2 db)

Dwayne Martin
James Madison University

___
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: User can see fields with no permissions

2008-04-07 Thread Tanner, Doug
Yes, They can not only see the field but they can see the data - This is
implied with View access to the field. DT 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 10:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

But they CAN see the contents of the field itself.  If there is data
there the test person can read it.

Dwayne

 Original message 
Date: Mon, 7 Apr 2008 07:51:52 -0600
From: LJ Longwing [EMAIL PROTECTED]  
Subject: Re: User can see fields with no permissions  
To: arslist@ARSLIST.ORG

Dwayne,
Sorry to say, but removing permission to the field removes their
permission
to see what's in the field, not the field itself.  The exceptions to
this
would be 'Trim' fields, buttons, boxes, etc, because those all
disappear
when you don't have access, but when you don't have access to a Char,
Int,
etc you simply can't see the contents of the field, but you can still
see
the field itself 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 7:29 AM
To: arslist@ARSLIST.ORG
Subject: User can see fields with no permissions

Dear List,

We have a permission group called IT.  We have a form with some
fields
that IT used to have permission to, but we have decided to remove
those
permissions.  So I went into the Admin Tool and removed IT from the
permission list in each field.

But when a test user with only IT permissions opens the form he can
still
see all the fields.  If he tries to change the data and save the form
he
gets, ARERR [333] You have no access to field : [field name], but
with no
access he shouldn't even be able to see the field.

I cleared the cache, and made a cosmetic change, and the cosmetic
change
appears on the screen, so it isn't a caching issue.

What is going on?

(ARS 7.1, RH Linux server, Oracle 10.2 db)

Dwayne Martin
James Madison University

___

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

DISCLAIMER Important! This message is intended for the above named person(s) 
only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient 
of this e-mail and have received it in error, please immediately notify the 
sender by return email and then delete it from your mailbox. This message may 
be protected by the attorney-client privilege and/or work product doctrine.  
Accessing, copying, disseminating or re-using any of the information contained 
in this e-mail by anyone other than the intended recipient is strictly 
prohibited. Finally, you should check this email and any attachments for the 
presence of viruses, as the sender accepts no liability for any damage caused 
by any virus transmitted by this email.  Thank you.

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


RES: How to know when a table is full ??

2008-04-07 Thread Tadeu Augusto Dutra Pinto
Hi John,
 
Thanks for your reply...
 
But I would like to create this in a AR Sytem Form... (like Alert Events, AR 
System Email Messages)
 
Could I create new Fields in these kind of forms without any worry about modify 
AR System Forms???
 
 
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
Fone: 41 2107-5736 - HSBC Outsourcing
-
Confiabilidade, Inovação e Qualidade em T.I.



De: Action Request System discussion list(ARSList) em nome de john rosquist
Enviada: seg 7/4/2008 11:24
Para: arslist@ARSLIST.ORG
Assunto: Re: How to know when a table is full ??


** 
On a test form create a filter or esc.
 
select form name
firing conditions ...
if action-set fields-Read value-direct SQL select count(*) from t...
Name field to put the result into - SQL result col 1
 
Good luck,
John Rosquist
Windward


 
- Original Message 
From: Tadeu Augusto Dutra Pinto [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Thursday, April 3, 2008 2:00:46 PM
Subject: How to know when a table is full ??

** 
Hi All.
 
How could I execute a command to get the quantity of records in a table?
 
Our test environment has not license ... and because of this we have a limit of 
2k records for each table...
I'd like to know when my table is full (i.e. if there is with 2k records)
 
Is there some way for me obtain this feature through an workflow object (Filter 
, AL , etc...) ???
 
P.S.: I've thought in to execute a Direct SQL command ... but this action 
doesn't return nothing...
 
 
Can somebody help me?
 
 
 
Thankx-in-advance!
 
 
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
Fone: 41 2107-5736 - HSBC Outsourcing
-
Confiabilidade, Inovação e Qualidade em T.I.
__Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/  ARSlist: 
Where the Answers Are html___




You rock. That's why Blockbuster's offering you one month of Blockbuster Total 
Access 
http://us.rd.yahoo.com/evt=47523/*http://tc.deals.yahoo.com/tc/blockbuster/text5.com
 , No Cost. __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: User can see fields with no permissions

2008-04-07 Thread LJ Longwing
Then I must say that they still have permission, I noticed someone else
mention Public, does the field have Public read permission?  If so, that's
your culprit. 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 8:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

But they CAN see the contents of the field itself.  If there is data there
the test person can read it.

Dwayne

 Original message 
Date: Mon, 7 Apr 2008 07:51:52 -0600
From: LJ Longwing [EMAIL PROTECTED]
Subject: Re: User can see fields with no permissions
To: arslist@ARSLIST.ORG

Dwayne,
Sorry to say, but removing permission to the field removes their 
permission to see what's in the field, not the field itself.  The 
exceptions to this would be 'Trim' fields, buttons, boxes, etc, because 
those all disappear when you don't have access, but when you don't have 
access to a Char, Int, etc you simply can't see the contents of the 
field, but you can still see the field itself

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 7:29 AM
To: arslist@ARSLIST.ORG
Subject: User can see fields with no permissions

Dear List,

We have a permission group called IT.  We have a form with some 
fields that IT used to have permission to, but we have decided to 
remove those permissions.  So I went into the Admin Tool and removed 
IT from the permission list in each field.

But when a test user with only IT permissions opens the form he can 
still see all the fields.  If he tries to change the data and save the 
form he gets, ARERR [333] You have no access to field : [field name], 
but with no access he shouldn't even be able to see the field.

I cleared the cache, and made a cosmetic change, and the cosmetic 
change appears on the screen, so it isn't a caching issue.

What is going on?

(ARS 7.1, RH Linux server, Oracle 10.2 db)

Dwayne Martin
James Madison University

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


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

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


Re: CSS 5.6

2008-04-07 Thread Mike Wallick
I'm not sure if this is exactly what you're asking, but yes, as long
as the User has an AR user license and a customer support license
(fixed or floating).  I have a user account that is for EIE that among
other things, handles account/contact merges from our CRM system and
part of the merge process is to move Issues from the merge victim to
the merge survivor.  This service account has a fixed AR User license
and a fixed customer support license and is not set up as an Employee
(i.e. the agent console doesn't work for this service account).

HTH.

Mike

On 4/7/08, John Joseph [EMAIL PROTECTED] wrote:
 **
  Hi All,

 In the out-of-the-box CSS 5.6, can an existing issue be modified by a person
 who is not configured within the system?

 Best Regards,
 John Joseph


 
 Planning marriage in 2008! Join Shaadi.com matrimony FREE! Try it now!
 __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: SLA Deployed to Draft

2008-04-07 Thread Mike Wallick
I don't know why or how, but once an SLA is changed to deploy, there
is no (easy) was to change it back to draft. This is why I run all my
SLAs in draft status.

Mike

On 4/6/08, Alfonso Eduardo Marín Urdapilleta [EMAIL PROTECTED] wrote:
 **

  I would like to know it there is a way to change an SLA from Deployed
 back to Draft status.

 For what I read this is not a simple task.  Has anyone ever done
 something like this? Or could at least give me an idea what a deployed
 SLA does that it can't be changed back to Draft?

 I'm using Remedy 6.3 __Platinum Sponsor: www.rmsportal.com ARSlist: Where
 the Answers Are html___


Re: User can see fields with no permissions

2008-04-07 Thread Dwayne Martin
I was wrong.  The person with IT permission can see the fields, but no data.

We don't even want them to see the fields.  They are on a page and we have 
removed permissions to the page.  But the test person can still see the page.  
But there is another page that no group (but Administrator) has permission to, 
and the test person can't see it.  So why can he see some pages he has no 
permission to and not others?

I also have a test login with no permissions (except Public) and that person 
cannot see the page that IT sees, nor the page with no permissions.

Here is an added complication.  We also have a permission group called IT 
Manager.  I thot maybe IT was inheriting permissions from IT Manager, so I 
change the group name from IT to Info Tech, but that didn't change 
anything.  I even restarted the server.  Do groups with overlapping names 
affect each other?  I am grasping at straws.

Dwayne

 Original message 
Date: Mon, 7 Apr 2008 10:29:52 -0400
From: Tanner, Doug [EMAIL PROTECTED]  
Subject: Re: User can see fields with no permissions  
To: arslist@ARSLIST.ORG

Yes, They can not only see the field but they can see the data - This is
implied with View access to the field. DT 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 10:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

But they CAN see the contents of the field itself.  If there is data
there the test person can read it.

Dwayne

 Original message 
Date: Mon, 7 Apr 2008 07:51:52 -0600
From: LJ Longwing [EMAIL PROTECTED]  
Subject: Re: User can see fields with no permissions  
To: arslist@ARSLIST.ORG

Dwayne,
Sorry to say, but removing permission to the field removes their
permission
to see what's in the field, not the field itself.  The exceptions to
this
would be 'Trim' fields, buttons, boxes, etc, because those all
disappear
when you don't have access, but when you don't have access to a Char,
Int,
etc you simply can't see the contents of the field, but you can still
see
the field itself 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 7:29 AM
To: arslist@ARSLIST.ORG
Subject: User can see fields with no permissions

Dear List,

We have a permission group called IT.  We have a form with some
fields
that IT used to have permission to, but we have decided to remove
those
permissions.  So I went into the Admin Tool and removed IT from the
permission list in each field.

But when a test user with only IT permissions opens the form he can
still
see all the fields.  If he tries to change the data and save the form
he
gets, ARERR [333] You have no access to field : [field name], but
with no
access he shouldn't even be able to see the field.

I cleared the cache, and made a cosmetic change, and the cosmetic
change
appears on the screen, so it isn't a caching issue.

What is going on?

(ARS 7.1, RH Linux server, Oracle 10.2 db)

Dwayne Martin
James Madison University

___

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

DISCLAIMER Important! This message is intended for the above named person(s) 
only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended 
recipient of this e-mail and have received it in error, please immediately 
notify the sender by return email and then delete it from your mailbox. This 
message may be protected by the attorney-client privilege and/or work product 
doctrine.  Accessing, copying, disseminating or re-using any of the 
information contained in this e-mail by anyone other than the intended 
recipient is strictly prohibited. Finally, you should check this email and any 
attachments for the presence of viruses, as the sender accepts no liability 
for any damage caused by any virus transmitted by this email.  Thank you.


___
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


Saving Attachments

2008-04-07 Thread Brittain, Mark
HI All,

I am having a really strange problem here. I have a new form with an
attachment pool. Permissions are any user to submit. If I create a new
record and add an attachment, the attachment is not saved. If I modify
the record, the attachment does save.

ARS 6.3 patch 20
Oracle 9.2
SunOS 5.9


Anybody have any ideas?

Thanks
Mark

This e-mail is the property of NaviSite, Inc. It is intended only
for the person or entity to which it is addressed and may contain
information that is privileged, confidential, or otherwise protected
from disclosure. Distribution or copying of this e-mail, or the
information contained herein, to anyone other than the intended
recipient is prohibited.

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


RES: Using 'Search Bar' with 'Create Date'

2008-04-07 Thread Tadeu Augusto Dutra Pinto
Hello,
 
 
I'm trying to do this funcionallity ...
 
When I put 'Create Date'  this works very well
But when I put 'Create Date' (withou blank spaces between 'Create Date' and 
 ) this does not work...
 
and, consequently, when I put another cause of condition that go out of my 
specific case (i.e. 'Create Date' )
this doesn't work fine ...
 
Is there a way that I can create a condition that works fine?
I've tried to put 'Create Date' + % +  , but when I have another 
sentence after this, I am in trouble too ... 
because I can't write a sentence like this: 'Create Date'  01/01/2007 AND 
'Status'  3 ...
 
 
Any suggestion will be appreciated!
 
Att,
 
 
Tadeu Augusto Dutra Pinto
-
IT Web Services ATM 
Cinq Technologies
http://www.cinq.com.br 
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
Fone: 41 3018-2833 - Cinq
Fone: 41 2107-5736 - HSBC Outsourcing
-
Confiabilidade, Inovação e Qualidade em T.I.



De: Action Request System discussion list(ARSList) em nome de Joe D'Souza
Enviada: sex 4/4/2008 14:06
Para: arslist@ARSLIST.ORG
Assunto: Re: Using 'Search Bar' with 'Create Date'


** 
Just a guess but by the time your statement is evaluated, maybe the ARS 
translates 'Create Date' to '3'??
 
Did you check the AL logs assuming your workflow is AL based?
 
Joe

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL 
PROTECTED] Behalf Of Tadeu Augusto Dutra Pinto
Sent: Friday, April 04, 2008 11:41 AM
To: arslist@ARSLIST.ORG
Subject: Using 'Search Bar' with 'Create Date'


** 
Hi for all,
 
I'd like to know if there is a way to block users to do sentences like 
that:
'Create Date'  0404/2008 for example...
 
 
I tried to do something like this... 'Search Bar' LIKE (( %  +  
'Create Date'  ) +  % )
using Active Link...
 
But it does not work 
 
 
Thankx in advance...
 
 
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
Fone: 41 2107-5736 - HSBC Outsourcing
-
Confiabilidade, Inovação e Qualidade em T.I.

__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: User can see fields with no permissions

2008-04-07 Thread Scott Parrish
LJ,
This is not true. If you remove all permissions to a field AND uncheck Allow
Any User To Submit, then that field will disappear for any user who is not
an Administrator, whether this field is a char, int or otherwise. Also, if
you remove any implicit permissions (submitter, assignee) and uncheck Allow
Any User To Submit, the field will also disappear from the view.

Dwayne,
Do you have any implicit permissions on the field, such as submitter or
assignee? Also, have you checked this person's membership in other groups?
(Maybe he is a member of a different group that does have permission to the
field.)

Scott Parrish
IT Prophets, LLC
(770) 653-5203
www.itprophets.com 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing
Sent: Monday, April 07, 2008 9:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

Dwayne,
Sorry to say, but removing permission to the field removes their permission
to see what's in the field, not the field itself.  The exceptions to this
would be 'Trim' fields, buttons, boxes, etc, because those all disappear
when you don't have access, but when you don't have access to a Char, Int,
etc you simply can't see the contents of the field, but you can still see
the field itself 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 7:29 AM
To: arslist@ARSLIST.ORG
Subject: User can see fields with no permissions

Dear List,

We have a permission group called IT.  We have a form with some fields
that IT used to have permission to, but we have decided to remove those
permissions.  So I went into the Admin Tool and removed IT from the
permission list in each field.

But when a test user with only IT permissions opens the form he can still
see all the fields.  If he tries to change the data and save the form he
gets, ARERR [333] You have no access to field : [field name], but with no
access he shouldn't even be able to see the field.

I cleared the cache, and made a cosmetic change, and the cosmetic change
appears on the screen, so it isn't a caching issue.

What is going on?

(ARS 7.1, RH Linux server, Oracle 10.2 db)

Dwayne Martin
James Madison University


___
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: User can see fields with no permissions

2008-04-07 Thread Kaiser Norm E CIV USAF 96 CS/SCCE
 Do groups with overlapping names affect each other?

Sometimes, yes.  Nesting Group Names is, in my experience, a bad
idea...I learned the hard way.  I supported a site that created a group
named Help Desk and another named Central Help Desk and permissions
overlapped.  They called me to diagnose the problem, and it was a mess
to clean up.

Also, keep in mind that with pages the actual page has permissions and
the *page holder* itself has permissions.  Check both.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 9:47 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

I was wrong.  The person with IT permission can see the fields, but no
data.

We don't even want them to see the fields.  They are on a page and we
have removed permissions to the page.  But the test person can still see
the page.  But there is another page that no group (but Administrator)
has permission to, and the test person can't see it.  So why can he see
some pages he has no permission to and not others?

I also have a test login with no permissions (except Public) and that
person cannot see the page that IT sees, nor the page with no
permissions.

Here is an added complication.  We also have a permission group called
IT Manager.  I thot maybe IT was inheriting permissions from IT
Manager, so I change the group name from IT to Info Tech, but that
didn't change anything.  I even restarted the server.  Do groups with
overlapping names affect each other?  I am grasping at straws.

Dwayne

 Original message 
Date: Mon, 7 Apr 2008 10:29:52 -0400
From: Tanner, Doug [EMAIL PROTECTED]  
Subject: Re: User can see fields with no permissions  
To: arslist@ARSLIST.ORG

Yes, They can not only see the field but they can see the data - This
is
implied with View access to the field. DT 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 10:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

But they CAN see the contents of the field itself.  If there is data
there the test person can read it.

Dwayne

 Original message 
Date: Mon, 7 Apr 2008 07:51:52 -0600
From: LJ Longwing [EMAIL PROTECTED]  
Subject: Re: User can see fields with no permissions  
To: arslist@ARSLIST.ORG

Dwayne,
Sorry to say, but removing permission to the field removes their
permission
to see what's in the field, not the field itself.  The exceptions to
this
would be 'Trim' fields, buttons, boxes, etc, because those all
disappear
when you don't have access, but when you don't have access to a Char,
Int,
etc you simply can't see the contents of the field, but you can still
see
the field itself 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 7:29 AM
To: arslist@ARSLIST.ORG
Subject: User can see fields with no permissions

Dear List,

We have a permission group called IT.  We have a form with some
fields
that IT used to have permission to, but we have decided to remove
those
permissions.  So I went into the Admin Tool and removed IT from the
permission list in each field.

But when a test user with only IT permissions opens the form he can
still
see all the fields.  If he tries to change the data and save the form
he
gets, ARERR [333] You have no access to field : [field name], but
with no
access he shouldn't even be able to see the field.

I cleared the cache, and made a cosmetic change, and the cosmetic
change
appears on the screen, so it isn't a caching issue.

What is going on?

(ARS 7.1, RH Linux server, Oracle 10.2 db)

Dwayne Martin
James Madison University

__
_

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

DISCLAIMER Important! This message is intended for the above named
person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the
intended recipient of this e-mail and have received it in error, please
immediately notify the sender by return email and then delete it from
your mailbox. This message may be protected by the attorney-client
privilege and/or work product doctrine.  Accessing, copying,
disseminating or re-using any of the information contained in this
e-mail by anyone other than the intended recipient is strictly
prohibited. Finally, you should check this email and any attachments for
the presence of viruses, as the sender accepts no liability for any
damage caused by any virus 

Re: User can see fields with no permissions

2008-04-07 Thread LJ Longwing
Scott,
I would love for you to prove that to both yourself and me, because I have
experienced differently. 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Scott Parrish
Sent: Monday, April 07, 2008 8:55 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

LJ,
This is not true. If you remove all permissions to a field AND uncheck Allow
Any User To Submit, then that field will disappear for any user who is not
an Administrator, whether this field is a char, int or otherwise. Also, if
you remove any implicit permissions (submitter, assignee) and uncheck Allow
Any User To Submit, the field will also disappear from the view.

Dwayne,
Do you have any implicit permissions on the field, such as submitter or
assignee? Also, have you checked this person's membership in other groups?
(Maybe he is a member of a different group that does have permission to the
field.)

Scott Parrish
IT Prophets, LLC
(770) 653-5203
www.itprophets.com 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing
Sent: Monday, April 07, 2008 9:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

Dwayne,
Sorry to say, but removing permission to the field removes their permission
to see what's in the field, not the field itself.  The exceptions to this
would be 'Trim' fields, buttons, boxes, etc, because those all disappear
when you don't have access, but when you don't have access to a Char, Int,
etc you simply can't see the contents of the field, but you can still see
the field itself 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 7:29 AM
To: arslist@ARSLIST.ORG
Subject: User can see fields with no permissions

Dear List,

We have a permission group called IT.  We have a form with some fields
that IT used to have permission to, but we have decided to remove those
permissions.  So I went into the Admin Tool and removed IT from the
permission list in each field.

But when a test user with only IT permissions opens the form he can still
see all the fields.  If he tries to change the data and save the form he
gets, ARERR [333] You have no access to field : [field name], but with no
access he shouldn't even be able to see the field.

I cleared the cache, and made a cosmetic change, and the cosmetic change
appears on the screen, so it isn't a caching issue.

What is going on?

(ARS 7.1, RH Linux server, Oracle 10.2 db)

Dwayne Martin
James Madison University


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


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

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


Re: User can see fields with no permissions

2008-04-07 Thread LJ Longwing
In my experience, if you don't want them to see the field, the only option I
have been able to work with is to hide it with workflow in situations where
you don't want them to see it.  one thing you want to be very careful about
when dealing with Tab permissions though, if you remove a persons permission
to a Tab, they also can't access anything on that tab, you can look at a tab
as a container of sorts, if you can't get into the room with your
possessions in it, then you can't access your possessions, you can look at
tabs and fields on the tabs in the same manner. 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 8:47 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

I was wrong.  The person with IT permission can see the fields, but no
data.

We don't even want them to see the fields.  They are on a page and we have
removed permissions to the page.  But the test person can still see the
page.  But there is another page that no group (but Administrator) has
permission to, and the test person can't see it.  So why can he see some
pages he has no permission to and not others?

I also have a test login with no permissions (except Public) and that person
cannot see the page that IT sees, nor the page with no permissions.

Here is an added complication.  We also have a permission group called IT
Manager.  I thot maybe IT was inheriting permissions from IT Manager,
so I change the group name from IT to Info Tech, but that didn't change
anything.  I even restarted the server.  Do groups with overlapping names
affect each other?  I am grasping at straws.

Dwayne

 Original message 
Date: Mon, 7 Apr 2008 10:29:52 -0400
From: Tanner, Doug [EMAIL PROTECTED]
Subject: Re: User can see fields with no permissions
To: arslist@ARSLIST.ORG

Yes, They can not only see the field but they can see the data - This 
is implied with View access to the field. DT

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 10:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

But they CAN see the contents of the field itself.  If there is data 
there the test person can read it.

Dwayne

 Original message 
Date: Mon, 7 Apr 2008 07:51:52 -0600
From: LJ Longwing [EMAIL PROTECTED]
Subject: Re: User can see fields with no permissions
To: arslist@ARSLIST.ORG

Dwayne,
Sorry to say, but removing permission to the field removes their
permission
to see what's in the field, not the field itself.  The exceptions to
this
would be 'Trim' fields, buttons, boxes, etc, because those all
disappear
when you don't have access, but when you don't have access to a Char,
Int,
etc you simply can't see the contents of the field, but you can still
see
the field itself

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 7:29 AM
To: arslist@ARSLIST.ORG
Subject: User can see fields with no permissions

Dear List,

We have a permission group called IT.  We have a form with some
fields
that IT used to have permission to, but we have decided to remove
those
permissions.  So I went into the Admin Tool and removed IT from the 
permission list in each field.

But when a test user with only IT permissions opens the form he can
still
see all the fields.  If he tries to change the data and save the form
he
gets, ARERR [333] You have no access to field : [field name], but
with no
access he shouldn't even be able to see the field.

I cleared the cache, and made a cosmetic change, and the cosmetic
change
appears on the screen, so it isn't a caching issue.

What is going on?

(ARS 7.1, RH Linux server, Oracle 10.2 db)

Dwayne Martin
James Madison University

__
_

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

DISCLAIMER Important! This message is intended for the above named
person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the
intended recipient of this e-mail and have received it in error, please
immediately notify the sender by return email and then delete it from your
mailbox. This message may be protected by the attorney-client privilege
and/or work product doctrine.  Accessing, copying, disseminating or re-using
any of the information contained in this e-mail by anyone other than the
intended recipient is strictly prohibited. Finally, you should check this
email and any attachments for 

Re: User can see fields with no permissions

2008-04-07 Thread Scott Parrish
I would think you could run this test yourself. I did just now before
sending off the email.

Scott Parrish
IT Prophets, LLC
(770) 653-5203
www.itprophets.com 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing
Sent: Monday, April 07, 2008 11:01 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

Scott,
I would love for you to prove that to both yourself and me, because I have
experienced differently. 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Scott Parrish
Sent: Monday, April 07, 2008 8:55 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

LJ,
This is not true. If you remove all permissions to a field AND uncheck Allow
Any User To Submit, then that field will disappear for any user who is not
an Administrator, whether this field is a char, int or otherwise. Also, if
you remove any implicit permissions (submitter, assignee) and uncheck Allow
Any User To Submit, the field will also disappear from the view.

Dwayne,
Do you have any implicit permissions on the field, such as submitter or
assignee? Also, have you checked this person's membership in other groups?
(Maybe he is a member of a different group that does have permission to the
field.)

Scott Parrish
IT Prophets, LLC
(770) 653-5203
www.itprophets.com 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing
Sent: Monday, April 07, 2008 9:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

Dwayne,
Sorry to say, but removing permission to the field removes their permission
to see what's in the field, not the field itself.  The exceptions to this
would be 'Trim' fields, buttons, boxes, etc, because those all disappear
when you don't have access, but when you don't have access to a Char, Int,
etc you simply can't see the contents of the field, but you can still see
the field itself 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 7:29 AM
To: arslist@ARSLIST.ORG
Subject: User can see fields with no permissions

Dear List,

We have a permission group called IT.  We have a form with some fields
that IT used to have permission to, but we have decided to remove those
permissions.  So I went into the Admin Tool and removed IT from the
permission list in each field.

But when a test user with only IT permissions opens the form he can still
see all the fields.  If he tries to change the data and save the form he
gets, ARERR [333] You have no access to field : [field name], but with no
access he shouldn't even be able to see the field.

I cleared the cache, and made a cosmetic change, and the cosmetic change
appears on the screen, so it isn't a caching issue.

What is going on?

(ARS 7.1, RH Linux server, Oracle 10.2 db)

Dwayne Martin
James Madison University


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


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


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

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


Re: User can see fields with no permissions

2008-04-07 Thread LJ Longwing
Scott,
I stand corrected.  I'm curious what platform you are on, because not even a
year ago I experienced the opposite, you could still see the field, but you
couldn't see the data in the field.  I can now confirm that in 7.1 (at
least) when you don't have permission to the field, you can't even see the
field.  Thank you for teaching me something today 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Scott Parrish
Sent: Monday, April 07, 2008 9:04 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

I would think you could run this test yourself. I did just now before
sending off the email.

Scott Parrish
IT Prophets, LLC
(770) 653-5203
www.itprophets.com 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing
Sent: Monday, April 07, 2008 11:01 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

Scott,
I would love for you to prove that to both yourself and me, because I have
experienced differently. 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Scott Parrish
Sent: Monday, April 07, 2008 8:55 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

LJ,
This is not true. If you remove all permissions to a field AND uncheck Allow
Any User To Submit, then that field will disappear for any user who is not
an Administrator, whether this field is a char, int or otherwise. Also, if
you remove any implicit permissions (submitter, assignee) and uncheck Allow
Any User To Submit, the field will also disappear from the view.

Dwayne,
Do you have any implicit permissions on the field, such as submitter or
assignee? Also, have you checked this person's membership in other groups?
(Maybe he is a member of a different group that does have permission to the
field.)

Scott Parrish
IT Prophets, LLC
(770) 653-5203
www.itprophets.com 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing
Sent: Monday, April 07, 2008 9:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

Dwayne,
Sorry to say, but removing permission to the field removes their permission
to see what's in the field, not the field itself.  The exceptions to this
would be 'Trim' fields, buttons, boxes, etc, because those all disappear
when you don't have access, but when you don't have access to a Char, Int,
etc you simply can't see the contents of the field, but you can still see
the field itself 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 7:29 AM
To: arslist@ARSLIST.ORG
Subject: User can see fields with no permissions

Dear List,

We have a permission group called IT.  We have a form with some fields
that IT used to have permission to, but we have decided to remove those
permissions.  So I went into the Admin Tool and removed IT from the
permission list in each field.

But when a test user with only IT permissions opens the form he can still
see all the fields.  If he tries to change the data and save the form he
gets, ARERR [333] You have no access to field : [field name], but with no
access he shouldn't even be able to see the field.

I cleared the cache, and made a cosmetic change, and the cosmetic change
appears on the screen, so it isn't a caching issue.

What is going on?

(ARS 7.1, RH Linux server, Oracle 10.2 db)

Dwayne Martin
James Madison University


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


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


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


___
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: User can see fields with no permissions

2008-04-07 Thread Dwayne Martin
This gets us to another topic.  I have a control panel with fields that 
Public has no permission to.  On this panel are two fields that have no 
Public permission, yet Public can see them.  But they can't see other fields 
with no Public permission.  I've never been able to figure that one out.

But this situation isn't like that.  There are about 25 fields that IT (now 
Info Tech)used to have permission to, but doesn't anymore. Public can't see 
them, but IT still can.  Somehow the system is remembering that IT USED TO 
have permissions, and is letting IT see the fields, but not the data.

Good suggestion, Scott, but my testit person is not the Submitter nor 
Assignee to the form.

Dwayne

 Original message 
Date: Mon, 7 Apr 2008 11:04:24 -0400
From: Scott Parrish [EMAIL PROTECTED]  
Subject: Re: User can see fields with no permissions  
To: arslist@ARSLIST.ORG

I would think you could run this test yourself. I did just now before
sending off the email.

Scott Parrish
IT Prophets, LLC
(770) 653-5203
www.itprophets.com 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing
Sent: Monday, April 07, 2008 11:01 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

Scott,
I would love for you to prove that to both yourself and me, because I have
experienced differently. 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Scott Parrish
Sent: Monday, April 07, 2008 8:55 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

LJ,
This is not true. If you remove all permissions to a field AND uncheck Allow
Any User To Submit, then that field will disappear for any user who is not
an Administrator, whether this field is a char, int or otherwise. Also, if
you remove any implicit permissions (submitter, assignee) and uncheck Allow
Any User To Submit, the field will also disappear from the view.

Dwayne,
Do you have any implicit permissions on the field, such as submitter or
assignee? Also, have you checked this person's membership in other groups?
(Maybe he is a member of a different group that does have permission to the
field.)

Scott Parrish
IT Prophets, LLC
(770) 653-5203
www.itprophets.com 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing
Sent: Monday, April 07, 2008 9:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

Dwayne,
Sorry to say, but removing permission to the field removes their permission
to see what's in the field, not the field itself.  The exceptions to this
would be 'Trim' fields, buttons, boxes, etc, because those all disappear
when you don't have access, but when you don't have access to a Char, Int,
etc you simply can't see the contents of the field, but you can still see
the field itself 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 7:29 AM
To: arslist@ARSLIST.ORG
Subject: User can see fields with no permissions

Dear List,

We have a permission group called IT.  We have a form with some fields
that IT used to have permission to, but we have decided to remove those
permissions.  So I went into the Admin Tool and removed IT from the
permission list in each field.

But when a test user with only IT permissions opens the form he can still
see all the fields.  If he tries to change the data and save the form he
gets, ARERR [333] You have no access to field : [field name], but with no
access he shouldn't even be able to see the field.

I cleared the cache, and made a cosmetic change, and the cosmetic change
appears on the screen, so it isn't a caching issue.

What is going on?

(ARS 7.1, RH Linux server, Oracle 10.2 db)

Dwayne Martin
James Madison University


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


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


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

___
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 

Re: User can see fields with no permissions

2008-04-07 Thread Tanner, Doug
I bet the two fields on the Console have Allow any User to Submit
Even though, you are not submitting directly into a Console :)


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 11:26 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

This gets us to another topic.  I have a control panel with fields that
Public has no permission to.  On this panel are two fields that have
no Public permission, yet Public can see them.  But they can't see
other fields with no Public permission.  I've never been able to figure
that one out.

But this situation isn't like that.  There are about 25 fields that IT
(now Info Tech)used to have permission to, but doesn't anymore.
Public can't see them, but IT still can.  Somehow the system is
remembering that IT USED TO have permissions, and is letting IT see
the fields, but not the data.

Good suggestion, Scott, but my testit person is not the Submitter nor
Assignee to the form.

Dwayne

 Original message 
Date: Mon, 7 Apr 2008 11:04:24 -0400
From: Scott Parrish [EMAIL PROTECTED]  
Subject: Re: User can see fields with no permissions  
To: arslist@ARSLIST.ORG

I would think you could run this test yourself. I did just now before
sending off the email.

Scott Parrish
IT Prophets, LLC
(770) 653-5203
www.itprophets.com 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing
Sent: Monday, April 07, 2008 11:01 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

Scott,
I would love for you to prove that to both yourself and me, because I
have
experienced differently. 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Scott Parrish
Sent: Monday, April 07, 2008 8:55 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

LJ,
This is not true. If you remove all permissions to a field AND uncheck
Allow
Any User To Submit, then that field will disappear for any user who is
not
an Administrator, whether this field is a char, int or otherwise. Also,
if
you remove any implicit permissions (submitter, assignee) and uncheck
Allow
Any User To Submit, the field will also disappear from the view.

Dwayne,
Do you have any implicit permissions on the field, such as submitter or
assignee? Also, have you checked this person's membership in other
groups?
(Maybe he is a member of a different group that does have permission to
the
field.)

Scott Parrish
IT Prophets, LLC
(770) 653-5203
www.itprophets.com 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing
Sent: Monday, April 07, 2008 9:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

Dwayne,
Sorry to say, but removing permission to the field removes their
permission
to see what's in the field, not the field itself.  The exceptions to
this
would be 'Trim' fields, buttons, boxes, etc, because those all
disappear
when you don't have access, but when you don't have access to a Char,
Int,
etc you simply can't see the contents of the field, but you can still
see
the field itself 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 7:29 AM
To: arslist@ARSLIST.ORG
Subject: User can see fields with no permissions

Dear List,

We have a permission group called IT.  We have a form with some
fields
that IT used to have permission to, but we have decided to remove
those
permissions.  So I went into the Admin Tool and removed IT from the
permission list in each field.

But when a test user with only IT permissions opens the form he can
still
see all the fields.  If he tries to change the data and save the form
he
gets, ARERR [333] You have no access to field : [field name], but
with no
access he shouldn't even be able to see the field.

I cleared the cache, and made a cosmetic change, and the cosmetic
change
appears on the screen, so it isn't a caching issue.

What is going on?

(ARS 7.1, RH Linux server, Oracle 10.2 db)

Dwayne Martin
James Madison University

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

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

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


Re: BMC Support login

2008-04-07 Thread Rick Cook
Got what appears to be the final word from Support today on this - BMC IT
shows no record that there was ever an account listed under my email
address.  I would submit that the few dozen Support issues raised from that
account shows them to be mistaken.

Management will be contacted

Rick

On Thu, Apr 3, 2008 at 2:53 PM, patrick zandi [EMAIL PROTECTED] wrote:

 ** EVERYONE,
 Next time you login to support.. Test something for me...
 Do a search of all your tickets.. not for just you... but for the whole
 support ID..

 Did you find people and companies you do not know ?
 Maybe it is just me..


 __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: Using 'Search Bar' with 'Create Date'

2008-04-07 Thread Steven Pataray
This looks almost like yours but it worked for me.

'Search Bar' LIKE (% + 'Create Date'  + %)  OR 'Search Bar' LIKE (%
+ 'Create Date' + %)


Steve


On 4/7/08, Tadeu Augusto Dutra Pinto [EMAIL PROTECTED] wrote:

 Hello,


 I'm trying to do this funcionallity ...

 When I put 'Create Date'  this works very well
 But when I put 'Create Date' (withou blank spaces between 'Create
 Date' and  ) this does not work...

 and, consequently, when I put another cause of condition that go out of my
 specific case (i.e. 'Create Date' )
 this doesn't work fine ...

 Is there a way that I can create a condition that works fine?
 I've tried to put 'Create Date' + % +  , but when I have another
 sentence after this, I am in trouble too ...
 because I can't write a sentence like this: 'Create Date'  01/01/2007
 AND 'Status'  3 ...


 Any suggestion will be appreciated!

 Att,


 Tadeu Augusto Dutra Pinto
 -
 IT Web Services ATM
 Cinq Technologies
 http://www.cinq.com.br
 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
 Fone: 41 3018-2833 - Cinq
 Fone: 41 2107-5736 - HSBC Outsourcing
 -
 Confiabilidade, Inovação e Qualidade em T.I.

 

 De: Action Request System discussion list(ARSList) em nome de Joe D'Souza
 Enviada: sex 4/4/2008 14:06
 Para: arslist@ARSLIST.ORG
 Assunto: Re: Using 'Search Bar' with 'Create Date'


 **
 Just a guess but by the time your statement is evaluated, maybe the ARS
 translates 'Create Date' to '3'??

 Did you check the AL logs assuming your workflow is AL based?

 Joe

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:
 [EMAIL PROTECTED] Behalf Of Tadeu Augusto Dutra Pinto
Sent: Friday, April 04, 2008 11:41 AM
To: arslist@ARSLIST.ORG
Subject: Using 'Search Bar' with 'Create Date'


**
Hi for all,

I'd like to know if there is a way to block users to do sentences
 like that:
'Create Date'  0404/2008 for example...


I tried to do something like this... 'Search Bar' LIKE ((
 %  +  'Create Date'  ) +  % )
using Active Link...

But it does not work 


Thankx in advance...


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
Fone: 41 2107-5736 - HSBC Outsourcing
-
Confiabilidade, Inovação e Qualidade em T.I.

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


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


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


Re: User can see fields with no permissions

2008-04-07 Thread Tanner, Doug
Most Excellent, working as designed
Doug

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing
Sent: Monday, April 07, 2008 11:45 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

Scott,
I think I answered my own question, here is when fields are visible.

If Dynamic Groups have access (Submitter, Assignee, Assignee Group,
etc), if
you have Allow Any User to Submit checked.  If none of those conditions
are
true, then the field is not visible, if any of those conditions are
true,
but the situation does not match them having access to the data, the
field
is visible, but the data is not. 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Scott Parrish
Sent: Monday, April 07, 2008 9:39 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

Dwayne,
The user does not have to be the assignee nor the submitter. But these
two
groups are implicit groups, just as public is, so if submitter has
permissions to the field then the testit person will be able to see
the
field (after all, how can you be a submitter to a field if you don't
have
permission to see it? Hiding it via workflow is not the same as being
able
to see it via permissions.). Same goes for the assignee.

Scott Parrish
IT Prophets, LLC
(770) 653-5203
www.itprophets.com
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 11:26 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

This gets us to another topic.  I have a control panel with fields that
Public has no permission to.  On this panel are two fields that have
no
Public permission, yet Public can see them.  But they can't see other
fields with no Public permission.  I've never been able to figure that
one
out.

But this situation isn't like that.  There are about 25 fields that IT
(now Info Tech)used to have permission to, but doesn't anymore.
Public
can't see them, but IT still can.  Somehow the system is remembering
that
IT USED TO have permissions, and is letting IT see the fields, but
not
the data.

Good suggestion, Scott, but my testit person is not the Submitter nor
Assignee to the form.

Dwayne

 Original message 
Date: Mon, 7 Apr 2008 11:04:24 -0400
From: Scott Parrish [EMAIL PROTECTED]
Subject: Re: User can see fields with no permissions
To: arslist@ARSLIST.ORG

I would think you could run this test yourself. I did just now before 
sending off the email.

Scott Parrish
IT Prophets, LLC
(770) 653-5203
www.itprophets.com

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing
Sent: Monday, April 07, 2008 11:01 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

Scott,
I would love for you to prove that to both yourself and me, because I 
have experienced differently.

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of Scott Parrish
Sent: Monday, April 07, 2008 8:55 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

LJ,
This is not true. If you remove all permissions to a field AND uncheck
Allow
Any User To Submit, then that field will disappear for any user who is 
not an Administrator, whether this field is a char, int or otherwise. 
Also, if you remove any implicit permissions (submitter, assignee) and 
uncheck Allow Any User To Submit, the field will also disappear from
the
view.

Dwayne,
Do you have any implicit permissions on the field, such as submitter or

assignee? Also, have you checked this person's membership in other
groups?
(Maybe he is a member of a different group that does have permission to

the
field.)

Scott Parrish
IT Prophets, LLC
(770) 653-5203
www.itprophets.com

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing
Sent: Monday, April 07, 2008 9:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

Dwayne,
Sorry to say, but removing permission to the field removes their 
permission to see what's in the field, not the field itself.  The 
exceptions to this would be 'Trim' fields, buttons, boxes, etc, because

those all disappear when you don't have access, but when you don't have

access to a Char, Int, etc you simply can't see the contents of the 
field, but you can still see the field itself

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 7:29 AM
To: arslist@ARSLIST.ORG
Subject: User can see fields with no permissions

Dear List,

We have a permission group called IT.  We have a form with some 
fields 

Re: SLA Deployed to Draft

2008-04-07 Thread Alfonso Eduardo Marín Urdapilleta
I can imagine, I'm sure there isn't a an easy way to change it back. But
then it might be a difficult way, and if it is possible to do it. I'm
interested in how. No matter how Hard it can be. So if anyone knows please
let me know. 

Thank you. 

-Mensaje original-
De: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] En nombre de Mike Wallick
Enviado el: Lunes, 07 de Abril de 2008 09:47 a.m.
Para: arslist@ARSLIST.ORG
Asunto: Re: SLA Deployed to Draft

I don't know why or how, but once an SLA is changed to deploy, there is no
(easy) was to change it back to draft. This is why I run all my SLAs in
draft status.

Mike

On 4/6/08, Alfonso Eduardo Marín Urdapilleta [EMAIL PROTECTED] wrote:
 **

  I would like to know it there is a way to change an SLA from Deployed 
 back to Draft status.

 For what I read this is not a simple task.  Has anyone ever done 
 something like this? Or could at least give me an idea what a deployed 
 SLA does that it can't be changed back to Draft?

 I'm using Remedy 6.3 __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: SLA Deployed to Draft

2008-04-07 Thread John Atherly
Why don't you use the copy button and recreate a new one with a different
name, delete the old one,  Then rename the new one.


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


   
 Alfonso Eduardo   
 Marín Urdapilleta   
 [EMAIL PROTECTED]  To
 MX   arslist@ARSLIST.ORG 
 Sent by: Action   cc
 Request System
 discussionSubject
 list(ARSList)Re: SLA Deployed to Draft   
 [EMAIL PROTECTED] 
 ORG  
   
   
 04/07/2008 11:49  
 AM
   
   
 Please respond to 
 [EMAIL PROTECTED] 
RG 
   
   




I can imagine, I'm sure there isn't a an easy way to change it back. But
then it might be a difficult way, and if it is possible to do it. I'm
interested in how. No matter how Hard it can be. So if anyone knows please
let me know.

Thank you.

-Mensaje original-
De: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] En nombre de Mike Wallick
Enviado el: Lunes, 07 de Abril de 2008 09:47 a.m.
Para: arslist@ARSLIST.ORG
Asunto: Re: SLA Deployed to Draft

I don't know why or how, but once an SLA is changed to deploy, there is no
(easy) was to change it back to draft. This is why I run all my SLAs in
draft status.

Mike

On 4/6/08, Alfonso Eduardo Marín Urdapilleta [EMAIL PROTECTED] wrote:
 **

  I would like to know it there is a way to change an SLA from Deployed
 back to Draft status.

 For what I read this is not a simple task.  Has anyone ever done
 something like this? Or could at least give me an idea what a deployed
 SLA does that it can't be changed back to Draft?

 I'm using Remedy 6.3 __Platinum Sponsor: www.rmsportal.com ARSlist:
 Where the Answers Are html___

___

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

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


Re: User can see fields with no permissions

2008-04-07 Thread David Sanders
Try it with a test field...

Create a field with just an explicit group permission, Like IT Manager, and
your IT test should not be able to see it.

Add Assignee permission to the field - then they will see it.  If you have
Assignee, Assignee Group, Submitter etc. permissions then they will be able
to see the field, because they *might* be in that role for some of the data
records.

David Sanders
Remedy Solution Architect
Enterprise Service Suite @ Work
==
ARS List Award Winner 2005
Best 3rd party Remedy Application
 
See the ESS Concepts Guide
 
tel +44 1494 468980
mobile +44 7710 377761
email [EMAIL PROTECTED]
 
web http://www.westoverconsulting.co.uk
 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Tanner, Doug
Sent: Monday, April 07, 2008 4:31 PM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

I bet the two fields on the Console have Allow any User to Submit
Even though, you are not submitting directly into a Console :)


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 11:26 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

This gets us to another topic.  I have a control panel with fields that
Public has no permission to.  On this panel are two fields that have
no Public permission, yet Public can see them.  But they can't see
other fields with no Public permission.  I've never been able to figure
that one out.

But this situation isn't like that.  There are about 25 fields that IT
(now Info Tech)used to have permission to, but doesn't anymore.
Public can't see them, but IT still can.  Somehow the system is
remembering that IT USED TO have permissions, and is letting IT see
the fields, but not the data.

Good suggestion, Scott, but my testit person is not the Submitter nor
Assignee to the form.

Dwayne

 Original message 
Date: Mon, 7 Apr 2008 11:04:24 -0400
From: Scott Parrish [EMAIL PROTECTED]  
Subject: Re: User can see fields with no permissions  
To: arslist@ARSLIST.ORG

I would think you could run this test yourself. I did just now before
sending off the email.

Scott Parrish
IT Prophets, LLC
(770) 653-5203
www.itprophets.com 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing
Sent: Monday, April 07, 2008 11:01 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

Scott,
I would love for you to prove that to both yourself and me, because I
have
experienced differently. 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Scott Parrish
Sent: Monday, April 07, 2008 8:55 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

LJ,
This is not true. If you remove all permissions to a field AND uncheck
Allow
Any User To Submit, then that field will disappear for any user who is
not
an Administrator, whether this field is a char, int or otherwise. Also,
if
you remove any implicit permissions (submitter, assignee) and uncheck
Allow
Any User To Submit, the field will also disappear from the view.

Dwayne,
Do you have any implicit permissions on the field, such as submitter or
assignee? Also, have you checked this person's membership in other
groups?
(Maybe he is a member of a different group that does have permission to
the
field.)

Scott Parrish
IT Prophets, LLC
(770) 653-5203
www.itprophets.com 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing
Sent: Monday, April 07, 2008 9:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

Dwayne,
Sorry to say, but removing permission to the field removes their
permission
to see what's in the field, not the field itself.  The exceptions to
this
would be 'Trim' fields, buttons, boxes, etc, because those all
disappear
when you don't have access, but when you don't have access to a Char,
Int,
etc you simply can't see the contents of the field, but you can still
see
the field itself 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 7:29 AM
To: arslist@ARSLIST.ORG
Subject: User can see fields with no permissions

Dear List,

We have a permission group called IT.  We have a form with some
fields
that IT used to have permission to, but we have decided to remove
those
permissions.  So I went into the Admin Tool and removed IT from the
permission list in each field.

But when a test user with only IT permissions opens the form he can
still
see all the fields.  If he tries to change the data and save the form
he
gets, ARERR [333] You have no access to field : [field name], but

Re: User can see fields with no permissions

2008-04-07 Thread LJ Longwing
Scott,
I think I answered my own question, here is when fields are visible.

If Dynamic Groups have access (Submitter, Assignee, Assignee Group, etc), if
you have Allow Any User to Submit checked.  If none of those conditions are
true, then the field is not visible, if any of those conditions are true,
but the situation does not match them having access to the data, the field
is visible, but the data is not. 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Scott Parrish
Sent: Monday, April 07, 2008 9:39 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

Dwayne,
The user does not have to be the assignee nor the submitter. But these two
groups are implicit groups, just as public is, so if submitter has
permissions to the field then the testit person will be able to see the
field (after all, how can you be a submitter to a field if you don't have
permission to see it? Hiding it via workflow is not the same as being able
to see it via permissions.). Same goes for the assignee.

Scott Parrish
IT Prophets, LLC
(770) 653-5203
www.itprophets.com
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 11:26 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

This gets us to another topic.  I have a control panel with fields that
Public has no permission to.  On this panel are two fields that have no
Public permission, yet Public can see them.  But they can't see other
fields with no Public permission.  I've never been able to figure that one
out.

But this situation isn't like that.  There are about 25 fields that IT
(now Info Tech)used to have permission to, but doesn't anymore. Public
can't see them, but IT still can.  Somehow the system is remembering that
IT USED TO have permissions, and is letting IT see the fields, but not
the data.

Good suggestion, Scott, but my testit person is not the Submitter nor
Assignee to the form.

Dwayne

 Original message 
Date: Mon, 7 Apr 2008 11:04:24 -0400
From: Scott Parrish [EMAIL PROTECTED]
Subject: Re: User can see fields with no permissions
To: arslist@ARSLIST.ORG

I would think you could run this test yourself. I did just now before 
sending off the email.

Scott Parrish
IT Prophets, LLC
(770) 653-5203
www.itprophets.com

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing
Sent: Monday, April 07, 2008 11:01 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

Scott,
I would love for you to prove that to both yourself and me, because I 
have experienced differently.

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of Scott Parrish
Sent: Monday, April 07, 2008 8:55 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

LJ,
This is not true. If you remove all permissions to a field AND uncheck
Allow
Any User To Submit, then that field will disappear for any user who is 
not an Administrator, whether this field is a char, int or otherwise. 
Also, if you remove any implicit permissions (submitter, assignee) and 
uncheck Allow Any User To Submit, the field will also disappear from the
view.

Dwayne,
Do you have any implicit permissions on the field, such as submitter or 
assignee? Also, have you checked this person's membership in other groups?
(Maybe he is a member of a different group that does have permission to 
the
field.)

Scott Parrish
IT Prophets, LLC
(770) 653-5203
www.itprophets.com

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing
Sent: Monday, April 07, 2008 9:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

Dwayne,
Sorry to say, but removing permission to the field removes their 
permission to see what's in the field, not the field itself.  The 
exceptions to this would be 'Trim' fields, buttons, boxes, etc, because 
those all disappear when you don't have access, but when you don't have 
access to a Char, Int, etc you simply can't see the contents of the 
field, but you can still see the field itself

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 7:29 AM
To: arslist@ARSLIST.ORG
Subject: User can see fields with no permissions

Dear List,

We have a permission group called IT.  We have a form with some 
fields that IT used to have permission to, but we have decided to 
remove those permissions.  So I went into the Admin Tool and removed 
IT from the permission list in each field.

But when a test user with only IT permissions opens the form he can 
still see all the fields.  If he tries to 

Re: User can see fields with no permissions

2008-04-07 Thread Scott Parrish
Dwayne,
The user does not have to be the assignee nor the submitter. But these two
groups are implicit groups, just as public is, so if submitter has
permissions to the field then the testit person will be able to see the
field (after all, how can you be a submitter to a field if you don't have
permission to see it? Hiding it via workflow is not the same as being able
to see it via permissions.). Same goes for the assignee.

Scott Parrish
IT Prophets, LLC
(770) 653-5203
www.itprophets.com
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 11:26 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

This gets us to another topic.  I have a control panel with fields that
Public has no permission to.  On this panel are two fields that have no
Public permission, yet Public can see them.  But they can't see other
fields with no Public permission.  I've never been able to figure that one
out.

But this situation isn't like that.  There are about 25 fields that IT
(now Info Tech)used to have permission to, but doesn't anymore. Public
can't see them, but IT still can.  Somehow the system is remembering that
IT USED TO have permissions, and is letting IT see the fields, but not
the data.

Good suggestion, Scott, but my testit person is not the Submitter nor
Assignee to the form.

Dwayne

 Original message 
Date: Mon, 7 Apr 2008 11:04:24 -0400
From: Scott Parrish [EMAIL PROTECTED]  
Subject: Re: User can see fields with no permissions  
To: arslist@ARSLIST.ORG

I would think you could run this test yourself. I did just now before
sending off the email.

Scott Parrish
IT Prophets, LLC
(770) 653-5203
www.itprophets.com 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing
Sent: Monday, April 07, 2008 11:01 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

Scott,
I would love for you to prove that to both yourself and me, because I have
experienced differently. 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Scott Parrish
Sent: Monday, April 07, 2008 8:55 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

LJ,
This is not true. If you remove all permissions to a field AND uncheck
Allow
Any User To Submit, then that field will disappear for any user who is not
an Administrator, whether this field is a char, int or otherwise. Also, if
you remove any implicit permissions (submitter, assignee) and uncheck Allow
Any User To Submit, the field will also disappear from the view.

Dwayne,
Do you have any implicit permissions on the field, such as submitter or
assignee? Also, have you checked this person's membership in other groups?
(Maybe he is a member of a different group that does have permission to the
field.)

Scott Parrish
IT Prophets, LLC
(770) 653-5203
www.itprophets.com 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing
Sent: Monday, April 07, 2008 9:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

Dwayne,
Sorry to say, but removing permission to the field removes their permission
to see what's in the field, not the field itself.  The exceptions to this
would be 'Trim' fields, buttons, boxes, etc, because those all disappear
when you don't have access, but when you don't have access to a Char, Int,
etc you simply can't see the contents of the field, but you can still see
the field itself 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 7:29 AM
To: arslist@ARSLIST.ORG
Subject: User can see fields with no permissions

Dear List,

We have a permission group called IT.  We have a form with some fields
that IT used to have permission to, but we have decided to remove those
permissions.  So I went into the Admin Tool and removed IT from the
permission list in each field.

But when a test user with only IT permissions opens the form he can still
see all the fields.  If he tries to change the data and save the form he
gets, ARERR [333] You have no access to field : [field name], but with
no
access he shouldn't even be able to see the field.

I cleared the cache, and made a cosmetic change, and the cosmetic change
appears on the screen, so it isn't a caching issue.

What is going on?

(ARS 7.1, RH Linux server, Oracle 10.2 db)

Dwayne Martin
James Madison University

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

___
_

Network traffic: Configuration possible?

2008-04-07 Thread Robert . 2 . Kern
Dear list,

Topic: Network traffic configuration

ARSystem 7.1 patch02

We have the situation here, that we have a server in Europe, and some 
clients in Mexico.

The roundtrip time is around 190ms, which leads so some performance 
issues.


Question is: how does the package verification work? Is every package 
being confirmed?

Can it be configured, that for example only every 10th package needs to be 
confirmed?


Did not find a hint at the documentation, how it works, or if it can be 
configured.


Thank you all,
Robert




Mit den besten Gruessen/Best regards,

Robert Kern

VDO Automotive AG
SV IO IT BO ST
Sodener Strasse 9, 65824 Schwalbach, Germany

Ein Unternehmen des Continental-Konzerns/A Company of the Continental 
Corporation

Telefon/Phone: +49 6196 87-2546
Mobile: +49 170 8522-515
Telefax: +49 6196 8779-2546
E-Mail: [EMAIL PROTECTED]
http://www.continental-corporation.com
__

VDO Automotive AG, Siemensstr. 12, 93055 Regensburg
Postfach/Postbox 10 09 43, 93009 Regensburg
Vorsitzender des Aufsichtsrats/Chairman of the Supervisory Board: Johannes 
Suttmeyer
Vorstand/Managing Board: Dr. Alan Hippe, Helmut Matschi
Sitz der Gesellschaft/Registered office: Regensburg
Registergericht/Commercial registry: Regensburg, HRB 10510

__

Proprietary and confidential. Distribution only by express authority of 
Continental AG or its subsidiaries.

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

RES: Using 'Search Bar' with 'Create Date'

2008-04-07 Thread Tadeu Augusto Dutra Pinto
Steve,
 
I've already tried to do something like this...
but I wanted to simplify the condition...
 
I wouldn't like to use a code like these:
 
('Search Bar' LIKE (((% + 'Create Date') + %)))  == with no blank 
spaces
OR
('Search Bar' LIKE (((% + 'Create Date' ) + %))) == with one blank 
space
OR
('Search Bar' LIKE (((% + 'Create Date'  ) + %)))== with two blank 
space
OR 
('Search Bar' LIKE (((% + 'Create Date'   ) + %)))   == with three 
blank space
 
and so on...
 
I'd like to know if there is a way for me do this with a rule that is used for 
n blank spaces...
 
 
Remember that I've tried to use % but this does not work because of this, for 
example:
'Create Date'  01/01/2007 AND 'Status'  3
 
Thankx for all...
 
Yours Sincerelly,
 
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
Fone: 41 2107-5736 - HSBC Outsourcing
-
Confiabilidade, Inovação e Qualidade em T.I.

 


De: Action Request System discussion list(ARSList) em nome de Steven Pataray
Enviada: seg 7/4/2008 12:43
Para: arslist@ARSLIST.ORG
Assunto: Re: Using 'Search Bar' with 'Create Date'


** 
This looks almost like yours but it worked for me.
 
'Search Bar' LIKE (% + 'Create Date'  + %)  OR 'Search Bar' LIKE (% + 
'Create Date' + %)
 
 
Steve

 
On 4/7/08, Tadeu Augusto Dutra Pinto [EMAIL PROTECTED] wrote: 

Hello,


I'm trying to do this funcionallity ...

When I put 'Create Date'  this works very well
But when I put 'Create Date' (withou blank spaces between 'Create 
Date' and  ) this does not work...

and, consequently, when I put another cause of condition that go out of 
my specific case (i.e. 'Create Date' )
this doesn't work fine ...

Is there a way that I can create a condition that works fine?
I've tried to put 'Create Date' + % +  , but when I have another 
sentence after this, I am in trouble too ...
because I can't write a sentence like this: 'Create Date'  
01/01/2007 AND 'Status'  3 ...


Any suggestion will be appreciated!

Att,


Tadeu Augusto Dutra Pinto
-
IT Web Services ATM
Cinq Technologies
http://www.cinq.com.br http://www.cinq.com.br/ 
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
Fone: 41 3018-2833 - Cinq
Fone: 41 2107-5736 - HSBC Outsourcing
-
Confiabilidade, Inovação e Qualidade em T.I.



De: Action Request System discussion list(ARSList) em nome de Joe 
D'Souza
Enviada: sex 4/4/2008 14:06
Para: arslist@ARSLIST.ORG
Assunto: Re: Using 'Search Bar' with 'Create Date'


**
Just a guess but by the time your statement is evaluated, maybe the ARS 
translates 'Create Date' to '3'??

Did you check the AL logs assuming your workflow is AL based?

Joe

   -Original Message-
   From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] Behalf Of Tadeu Augusto Dutra Pinto
   Sent: Friday, April 04, 2008 11:41 AM
   To: arslist@ARSLIST.ORG
   Subject: Using 'Search Bar' with 'Create Date'


   **
   Hi for all,

   I'd like to know if there is a way to block users to do 
sentences like that:
   'Create Date'  0404/2008 for example...


   I tried to do something like this... 'Search Bar' LIKE (( %  + 
 'Create Date'  ) +  % )
   using Active Link...

   But it does not work 


   Thankx in advance...


   Tadeu Augusto Dutra Pinto
   -
   IT Web Services ATM
   Cinq Technologies
   http://www.cinq.com.br 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
   Fone: 41 2107-5736 - HSBC Outsourcing
   -
   Confiabilidade, Inovação e Qualidade em T.I.

__Platinum Sponsor: www.rmsportal.com 

Re: User can see fields with no permissions

2008-04-07 Thread Mueller, Doug
To avoid this heading down a path that will cause confusion, let me try
and
provide some insight into what is happening and you should find that all
permutations of what you are getting, what folks remember, or when
things might
or might not be visible are explained.


If a field is assigned access to a group and YOU are a member of that
group
   -- You will see the field AND you will see data in the field
   -- You can read the data and if the group is assigned change access,
change
 the field (within licensing restrictions of course)

If a field is assigned access to Public
   -- EVERYONE can see the field AND EVERYONE can see data in the field

If a field has the Allow any user to submit option set
   -- REGARDLESS OF ANY GROUP ASSIGNMENT, EVERYONE can see the field
  (you have said that ANY user can submit data so they have to
be able
   to see the field to submit things)
   -- Whether they can see data or not is dependent on other group
settings
   if NO other groups are assigned, then there will be no data
access but
   you can see the field

If the Submitter, Assignee, Assignee Group, or the other implicit row
level
security groups are assigned any permission
   -- REGARDLESS OF ANY GROUP ASSIGNMENT, EVERYONE can see the field
  (you have said that if their group membership matches, they
can see
   the data so that means they have to be able to see the field)
   -- Whether they can see data or not is dependent on the CONTENT of
the
field or fields on the form that match the groups assigned
permissions


So, if ANY of the following things are true, you can see the field:
   1) You are a member of a group assigned permission
   2) The field has Allow any user to Submit assigned
   3) The field has any of the implicit groups assigned (Submitter,
Assignee,
 Assignee Group, or the other 1000 row level security groups you
can
 create)

If NONE of these are true, you cannot see the field under any
circumstances

Once the field is visible, permissions control whether or not you can
see the
data in the field.  So, just seeing the field does not mean that you can
necessarily see data in the field. OR that you can see the data for all
rows.
You may be able to for some rows but not others because of row level
security.


In the different scenarios being discussed, the permission of the group
is
generally checked and it is found that the user doesn't have permission
by
an explicit group assignment.  However, the Allow any user to submit
or the
use of implicit groups is generally not looked at and that is the source
of
why a field would be visible when not expected.

If you look at all the items noted here, I think you will find that the
field
is visible or not and the data within it is visible or not consistently
under
the rules stated.


I hope this helps stop confusion about the rules of field visibility.

Doug Mueller

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 6:29 AM
To: arslist@ARSLIST.ORG
Subject: User can see fields with no permissions

Dear List,

We have a permission group called IT.  We have a form with some fields
that IT used to have permission to, but we have decided to remove
those permissions.  So I went into the Admin Tool and removed IT from
the permission list in each field.

But when a test user with only IT permissions opens the form he can
still see all the fields.  If he tries to change the data and save the
form he gets, ARERR [333] You have no access to field : [field name],
but with no access he shouldn't even be able to see the field.

I cleared the cache, and made a cosmetic change, and the cosmetic change
appears on the screen, so it isn't a caching issue.

What is going on?

(ARS 7.1, RH Linux server, Oracle 10.2 db)

Dwayne Martin
James Madison University

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


Re: User can see fields with no permissions SOLVED

2008-04-07 Thread Dwayne Martin
Doug, You've summarized it very well, but just to repeat, my problem is both 
Allow any user to submit and Assignee Group.  If either of these are true 
the user will be able to see the field.

I don't quite follow the logic of showing the field but not the data if 
Assignee Group has permission.  Maybe on Submit when the user just MIGHT be 
assigning the call to hermself, but why on display?

Anyway, now that I know what the problem is I'll just have to use workflow to 
hide the fields.

Thank you, everyone who joined in the discussion,
Dwayne

 Original message 
Date: Mon, 7 Apr 2008 11:46:25 -0400
From: Tanner, Doug [EMAIL PROTECTED]  
Subject: Re: User can see fields with no permissions  
To: arslist@ARSLIST.ORG

Most Excellent, working as designed
Doug

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing
Sent: Monday, April 07, 2008 11:45 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

Scott,
I think I answered my own question, here is when fields are visible.

If Dynamic Groups have access (Submitter, Assignee, Assignee Group,
etc), if
you have Allow Any User to Submit checked.  If none of those conditions
are
true, then the field is not visible, if any of those conditions are
true,
but the situation does not match them having access to the data, the
field
is visible, but the data is not. 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Scott Parrish
Sent: Monday, April 07, 2008 9:39 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

Dwayne,
The user does not have to be the assignee nor the submitter. But these
two
groups are implicit groups, just as public is, so if submitter has
permissions to the field then the testit person will be able to see
the
field (after all, how can you be a submitter to a field if you don't
have
permission to see it? Hiding it via workflow is not the same as being
able
to see it via permissions.). Same goes for the assignee.

Scott Parrish
IT Prophets, LLC
(770) 653-5203
www.itprophets.com
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 11:26 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

This gets us to another topic.  I have a control panel with fields that
Public has no permission to.  On this panel are two fields that have
no
Public permission, yet Public can see them.  But they can't see other
fields with no Public permission.  I've never been able to figure that
one
out.

But this situation isn't like that.  There are about 25 fields that IT
(now Info Tech)used to have permission to, but doesn't anymore.
Public
can't see them, but IT still can.  Somehow the system is remembering
that
IT USED TO have permissions, and is letting IT see the fields, but
not
the data.

Good suggestion, Scott, but my testit person is not the Submitter nor
Assignee to the form.

Dwayne

 Original message 
Date: Mon, 7 Apr 2008 11:04:24 -0400
From: Scott Parrish [EMAIL PROTECTED]
Subject: Re: User can see fields with no permissions
To: arslist@ARSLIST.ORG

I would think you could run this test yourself. I did just now before 
sending off the email.

Scott Parrish
IT Prophets, LLC
(770) 653-5203
www.itprophets.com

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing
Sent: Monday, April 07, 2008 11:01 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

Scott,
I would love for you to prove that to both yourself and me, because I 
have experienced differently.

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of Scott Parrish
Sent: Monday, April 07, 2008 8:55 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

LJ,
This is not true. If you remove all permissions to a field AND uncheck
Allow
Any User To Submit, then that field will disappear for any user who is 
not an Administrator, whether this field is a char, int or otherwise. 
Also, if you remove any implicit permissions (submitter, assignee) and 
uncheck Allow Any User To Submit, the field will also disappear from
the
view.

Dwayne,
Do you have any implicit permissions on the field, such as submitter or

assignee? Also, have you checked this person's membership in other
groups?
(Maybe he is a member of a different group that does have permission to

the
field.)

Scott Parrish
IT Prophets, LLC
(770) 653-5203
www.itprophets.com

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing
Sent: Monday, April 07, 2008 9:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no 

Re: User can see fields with no permissions

2008-04-07 Thread LJ Longwing
Thank you Doug, I had never delved that deep apparently, and I had always
experienced field visibility, but not data visibility without realizing that
it was possible to have the field not visible...thank you for the in depth
details of when a field is visible/hidden...:) 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mueller, Doug
Sent: Monday, April 07, 2008 10:03 AM
To: arslist@ARSLIST.ORG
Subject: Re: User can see fields with no permissions

To avoid this heading down a path that will cause confusion, let me try and
provide some insight into what is happening and you should find that all
permutations of what you are getting, what folks remember, or when things
might or might not be visible are explained.


If a field is assigned access to a group and YOU are a member of that group
   -- You will see the field AND you will see data in the field
   -- You can read the data and if the group is assigned change access,
change
 the field (within licensing restrictions of course)

If a field is assigned access to Public
   -- EVERYONE can see the field AND EVERYONE can see data in the field

If a field has the Allow any user to submit option set
   -- REGARDLESS OF ANY GROUP ASSIGNMENT, EVERYONE can see the field
  (you have said that ANY user can submit data so they have to be
able
   to see the field to submit things)
   -- Whether they can see data or not is dependent on other group settings
   if NO other groups are assigned, then there will be no data access
but
   you can see the field

If the Submitter, Assignee, Assignee Group, or the other implicit row level
security groups are assigned any permission
   -- REGARDLESS OF ANY GROUP ASSIGNMENT, EVERYONE can see the field
  (you have said that if their group membership matches, they can
see
   the data so that means they have to be able to see the field)
   -- Whether they can see data or not is dependent on the CONTENT of the
field or fields on the form that match the groups assigned
permissions


So, if ANY of the following things are true, you can see the field:
   1) You are a member of a group assigned permission
   2) The field has Allow any user to Submit assigned
   3) The field has any of the implicit groups assigned (Submitter,
Assignee,
 Assignee Group, or the other 1000 row level security groups you can
 create)

If NONE of these are true, you cannot see the field under any circumstances

Once the field is visible, permissions control whether or not you can see
the data in the field.  So, just seeing the field does not mean that you can
necessarily see data in the field. OR that you can see the data for all
rows.
You may be able to for some rows but not others because of row level
security.


In the different scenarios being discussed, the permission of the group is
generally checked and it is found that the user doesn't have permission by
an explicit group assignment.  However, the Allow any user to submit
or the
use of implicit groups is generally not looked at and that is the source of
why a field would be visible when not expected.

If you look at all the items noted here, I think you will find that the
field is visible or not and the data within it is visible or not
consistently under the rules stated.


I hope this helps stop confusion about the rules of field visibility.

Doug Mueller

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, April 07, 2008 6:29 AM
To: arslist@ARSLIST.ORG
Subject: User can see fields with no permissions

Dear List,

We have a permission group called IT.  We have a form with some fields
that IT used to have permission to, but we have decided to remove those
permissions.  So I went into the Admin Tool and removed IT from the
permission list in each field.

But when a test user with only IT permissions opens the form he can still
see all the fields.  If he tries to change the data and save the form he
gets, ARERR [333] You have no access to field : [field name], but with no
access he shouldn't even be able to see the field.

I cleared the cache, and made a cosmetic change, and the cosmetic change
appears on the screen, so it isn't a caching issue.

What is going on?

(ARS 7.1, RH Linux server, Oracle 10.2 db)

Dwayne Martin
James Madison University


___
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


Senior Custom Trainer Position for Column Technologies

2008-04-07 Thread Melissa Wish
We are seeking a Senior Field Trainer to develop custom trainings for our
clients. This is a permanent position with a generous salary, bonus and
benefits package. If you are interested, please email me your resume as well
as a good time to talk with you. [EMAIL PROTECTED] 

Responsibilities
*Draft application and process specific training documentation 
*Conduct requirements gathering workshops around training needs and
deliverables
*Communicate strategies and best practices for training in the
customer environment
*Design custom or product-based training guides, job aides, labs,
slides, etc…
*Demonstrate BMC Remedy ITSM suite to customers
*Respond to customer requests for training information and guidance
*Estimate level of effort to design or train on BMC Remedy product
suite
*Draft proposals and statements of work for training solutions
*Provide technical assistance in a pre-sales capacity to scope
training opportunities


Melissa Wish
Corporate Recruiter
Column Technologies, Inc.
Home Office: 718-399-2136
Cell/Evenings: 917-748-7104
E-Fax: 646-349-3799
Email: [EMAIL PROTECTED]
www.columnit.com
BMC Remedy Partner of the Year 2000 – 2006  
BMC Fastest Growing Worldwide Partner – 2006 
Inc. 500 Fastest Growing Private Companies – 2006 
BMC 2007 Americas and Worldwide Top Solution Provider



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


Reopening a Closed Change Ticket

2008-04-07 Thread Louis Cobuccio
Good Afternoon Everyone,

I've got a real simple question today, at least I hope it is simple.   I

need to reopen a Change Management Case which was automatically set to a
Closed status when all its tasks were closed.In older versions I was
always able to 
reopen tickets as the admin of the system, set the status back to 
Scheduled, but it looks like that functionality might be locked down in 
this version.

Any ideas?

We run a Window Shop w/Server 2003 MS SQL 2005  AR apps, v7.0.1 Patch
006.

Thanks,
Lou

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


Re: SLA Deployed to Draft

2008-04-07 Thread Alfonso Eduardo Marín Urdapilleta
I've considere that option, but one doubt I have is that if SLA are attached
to forms, filters and/or active links more deeply than just name. 

And would it be any problem if the SLA is not the original one? 


-Mensaje original-
De: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] En nombre de John Atherly
Enviado el: Lunes, 07 de Abril de 2008 11:00 a.m.
Para: arslist@ARSLIST.ORG
Asunto: Re: SLA Deployed to Draft

Why don't you use the copy button and recreate a new one with a different
name, delete the old one,  Then rename the new one.


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


   
 Alfonso Eduardo   
 Marín Urdapilleta 
 [EMAIL PROTECTED]  To 
 MX   arslist@ARSLIST.ORG 
 Sent by: Action   cc 
 Request System
 discussionSubject 
 list(ARSList)Re: SLA Deployed to Draft   
 [EMAIL PROTECTED] 
 ORG  
   
   
 04/07/2008 11:49  
 AM
   
   
 Please respond to 
 [EMAIL PROTECTED] 
RG 
   
   




I can imagine, I'm sure there isn't a an easy way to change it back. But
then it might be a difficult way, and if it is possible to do it. I'm
interested in how. No matter how Hard it can be. So if anyone knows please
let me know.

Thank you.

-Mensaje original-
De: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] En nombre de Mike Wallick Enviado el: Lunes, 07
de Abril de 2008 09:47 a.m.
Para: arslist@ARSLIST.ORG
Asunto: Re: SLA Deployed to Draft

I don't know why or how, but once an SLA is changed to deploy, there is no
(easy) was to change it back to draft. This is why I run all my SLAs in
draft status.

Mike

On 4/6/08, Alfonso Eduardo Marín Urdapilleta [EMAIL PROTECTED] wrote:
 **

  I would like to know it there is a way to change an SLA from Deployed 
 back to Draft status.

 For what I read this is not a simple task.  Has anyone ever done 
 something like this? Or could at least give me an idea what a deployed 
 SLA does that it can't be changed back to Draft?

 I'm using Remedy 6.3 __Platinum Sponsor: www.rmsportal.com ARSlist:
 Where the Answers Are html___


___

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


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

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


Re: Reopening a Closed Change Ticket

2008-04-07 Thread Eli Schilling
Lou,

Open the form SYS:Status Transition rules - in here there is an entry
that controls all status changes.  I took the entry for Application
Manager where 'From Status' - 'To Status' = Completed -
Implementation in Progress and set the record to offline.

However, you need to be careful when doing this because there is a lot
of workflow around approvals and tasks.  I built workflow so that if a
change is moved from Completed to any previous status the task and
approval functionality is locked down.

Cheers! 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio
Sent: Monday, April 07, 2008 10:22 AM
To: arslist@ARSLIST.ORG
Subject: Reopening a Closed Change Ticket

Good Afternoon Everyone,

I've got a real simple question today, at least I hope it is simple.   I

need to reopen a Change Management Case which was automatically set to a
Closed status when all its tasks were closed.In older versions I was
always able to
reopen tickets as the admin of the system, set the status back to
Scheduled, but it looks like that functionality might be locked down in
this version.

Any ideas?

We run a Window Shop w/Server 2003 MS SQL 2005  AR apps, v7.0.1 Patch
006.

Thanks,
Lou


___
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: Reopening a Closed Change Ticket

2008-04-07 Thread Louis Cobuccio
Thank you Eli.  I'll give it a go.

Have a great day,
Lou

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Eli Schilling
Sent: Monday, April 07, 2008 1:28 PM
To: arslist@ARSLIST.ORG
Subject: Re: Reopening a Closed Change Ticket

Lou,

Open the form SYS:Status Transition rules - in here there is an entry
that controls all status changes.  I took the entry for Application
Manager where 'From Status' - 'To Status' = Completed -
Implementation in Progress and set the record to offline.

However, you need to be careful when doing this because there is a lot
of workflow around approvals and tasks.  I built workflow so that if a
change is moved from Completed to any previous status the task and
approval functionality is locked down.

Cheers! 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio
Sent: Monday, April 07, 2008 10:22 AM
To: arslist@ARSLIST.ORG
Subject: Reopening a Closed Change Ticket

Good Afternoon Everyone,

I've got a real simple question today, at least I hope it is simple.   I

need to reopen a Change Management Case which was automatically set to a
Closed status when all its tasks were closed.In older versions I was
always able to
reopen tickets as the admin of the system, set the status back to
Scheduled, but it looks like that functionality might be locked down in
this version.

Any ideas?

We run a Window Shop w/Server 2003 MS SQL 2005  AR apps, v7.0.1 Patch
006.

Thanks,
Lou


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


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

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


Midtier wait icon

2008-04-07 Thread Shoemaker, Gary
I am wanting to simulate the wait icon, because I need to walk some tables and 
the wait time is 3-5 seconds.  I checked with support and they said there is 
not a way to force their wait icon.  Has anyone implemented their own wait icon?

Server 7.1
Midtier 7.1


Gary Shoemaker
Sandia National Laboratories





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


Re: Network traffic: Configuration possible?

2008-04-07 Thread Axton
When you say package, do you mean packet?  If so, read up on tcp.

Axton

On Mon, Apr 7, 2008 at 12:23 PM, [EMAIL PROTECTED]
wrote:

 **
 Dear list,

 Topic: Network traffic configuration

 ARSystem 7.1 patch02

 We have the situation here, that we have a server in Europe, and some
 clients in Mexico.

 The roundtrip time is around 190ms, which leads so some performance
 issues.


 Question is: how does the package verification work? Is every package
 being confirmed?

 Can it be configured, that for example only every 10th package needs to be
 confirmed?


 Did not find a hint at the documentation, how it works, or if it can be
 configured.


 Thank you all,
 Robert




 Mit den besten Gruessen/Best regards,

 Robert Kern

 VDO Automotive AG
 SV IO IT BO ST
 Sodener Strasse 9, 65824 Schwalbach, Germany

 Ein Unternehmen des Continental-Konzerns/A Company of the Continental
 Corporation

 Telefon/Phone: +49 6196 87-2546
 Mobile: +49 170 8522-515
 Telefax: +49 6196 8779-2546
 E-Mail: [EMAIL PROTECTED]
 http://www.continental-corporation.com
 __

 VDO Automotive AG, Siemensstr. 12, 93055 Regensburg
 Postfach/Postbox 10 09 43, 93009 Regensburg
 Vorsitzender des Aufsichtsrats/Chairman of the Supervisory Board: Johannes
 Suttmeyer
 Vorstand/Managing Board: Dr. Alan Hippe, Helmut Matschi
 Sitz der Gesellschaft/Registered office: Regensburg
 Registergericht/Commercial registry: Regensburg, HRB 10510

 __

 Proprietary and confidential. Distribution only by express authority of
 Continental AG or its subsidiaries. __Platinum Sponsor: 
 www.rmsportal.comARSlist: 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: Network traffic: Configuration possible?

2008-04-07 Thread Axton
When you say package, do you mean packet?  If so, read up on tcp.

Axton

On Mon, Apr 7, 2008 at 12:23 PM, [EMAIL PROTECTED]
wrote:

 **
 Dear list,

 Topic: Network traffic configuration

 ARSystem 7.1 patch02

 We have the situation here, that we have a server in Europe, and some
 clients in Mexico.

 The roundtrip time is around 190ms, which leads so some performance
 issues.


 Question is: how does the package verification work? Is every package
 being confirmed?

 Can it be configured, that for example only every 10th package needs to be
 confirmed?


 Did not find a hint at the documentation, how it works, or if it can be
 configured.


 Thank you all,
 Robert




 Mit den besten Gruessen/Best regards,

 Robert Kern

 VDO Automotive AG
 SV IO IT BO ST
 Sodener Strasse 9, 65824 Schwalbach, Germany

 Ein Unternehmen des Continental-Konzerns/A Company of the Continental
 Corporation

 Telefon/Phone: +49 6196 87-2546
 Mobile: +49 170 8522-515
 Telefax: +49 6196 8779-2546
 E-Mail: [EMAIL PROTECTED]
 http://www.continental-corporation.com
 __

 VDO Automotive AG, Siemensstr. 12, 93055 Regensburg
 Postfach/Postbox 10 09 43, 93009 Regensburg
 Vorsitzender des Aufsichtsrats/Chairman of the Supervisory Board: Johannes
 Suttmeyer
 Vorstand/Managing Board: Dr. Alan Hippe, Helmut Matschi
 Sitz der Gesellschaft/Registered office: Regensburg
 Registergericht/Commercial registry: Regensburg, HRB 10510

 __

 Proprietary and confidential. Distribution only by express authority of
 Continental AG or its subsidiaries. __Platinum Sponsor: 
 www.rmsportal.comARSlist: 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: Using 'Search Bar' with 'Create Date'

2008-04-07 Thread Steven Pataray
Okay how about this:

'Search Bar' LIKE (% + 'Create Date'% + %)

Steve

On 4/7/08, Tadeu Augusto Dutra Pinto [EMAIL PROTECTED] wrote:

 Steve,

 I've already tried to do something like this...
 but I wanted to simplify the condition...

 I wouldn't like to use a code like these:

 ('Search Bar' LIKE (((% + 'Create Date') + %)))  == with no
 blank spaces
 OR
 ('Search Bar' LIKE (((% + 'Create Date' ) + %))) == with one
 blank space
 OR
 ('Search Bar' LIKE (((% + 'Create Date'  ) + %)))== with two
 blank space
 OR
 ('Search Bar' LIKE (((% + 'Create Date'   ) + %)))   == with three
 blank space

 and so on...

 I'd like to know if there is a way for me do this with a rule that is used
 for n blank spaces...


 Remember that I've tried to use % but this does not work because of
 this, for example:
 'Create Date'  01/01/2007 AND 'Status'  3

 Thankx for all...

 Yours Sincerelly,

 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
 Fone: 41 2107-5736 - HSBC Outsourcing
 -
 Confiabilidade, Inovação e Qualidade em T.I.


 

 De: Action Request System discussion list(ARSList) em nome de Steven
 Pataray
 Enviada: seg 7/4/2008 12:43
 Para: arslist@ARSLIST.ORG
 Assunto: Re: Using 'Search Bar' with 'Create Date'


 **
 This looks almost like yours but it worked for me.

 'Search Bar' LIKE (% + 'Create Date'  + %)  OR 'Search Bar' LIKE
 (% + 'Create Date' + %)


 Steve


 On 4/7/08, Tadeu Augusto Dutra Pinto [EMAIL PROTECTED] wrote:

Hello,


I'm trying to do this funcionallity ...

When I put 'Create Date'  this works very well
But when I put 'Create Date' (withou blank spaces between
 'Create Date' and  ) this does not work...

and, consequently, when I put another cause of condition that go
 out of my specific case (i.e. 'Create Date' )
this doesn't work fine ...

Is there a way that I can create a condition that works fine?
I've tried to put 'Create Date' + % +  , but when I have
 another sentence after this, I am in trouble too ...
because I can't write a sentence like this: 'Create Date' 
 01/01/2007 AND 'Status'  3 ...


Any suggestion will be appreciated!

Att,


Tadeu Augusto Dutra Pinto
-
IT Web Services ATM
Cinq Technologies
http://www.cinq.com.br http://www.cinq.com.br/
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
Fone: 41 3018-2833 - Cinq
Fone: 41 2107-5736 - HSBC Outsourcing
-
Confiabilidade, Inovação e Qualidade em T.I.



De: Action Request System discussion list(ARSList) em nome de Joe
 D'Souza
Enviada: sex 4/4/2008 14:06
Para: arslist@ARSLIST.ORG
Assunto: Re: Using 'Search Bar' with 'Create Date'


**
Just a guess but by the time your statement is evaluated, maybe the
 ARS translates 'Create Date' to '3'??

Did you check the AL logs assuming your workflow is AL based?

Joe

   -Original Message-
   From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] Behalf Of Tadeu Augusto Dutra Pinto
   Sent: Friday, April 04, 2008 11:41 AM
   To: arslist@ARSLIST.ORG
   Subject: Using 'Search Bar' with 'Create Date'


   **
   Hi for all,

   I'd like to know if there is a way to block users to do
 sentences like that:
   'Create Date'  0404/2008 for example...


   I tried to do something like this... 'Search Bar' LIKE ((
 %  +  'Create Date'  ) +  % )
   using Active Link...

   But it does not work 


   Thankx in advance...


   Tadeu Augusto Dutra Pinto

   
 -
   IT Web Services ATM
   Cinq Technologies
   http://www.cinq.com.br 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
   Fone: 41 2107-5736 - HSBC Outsourcing

   
 -
   Confiabilidade, Inovação e Qualidade em T.I.

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



Re: Network traffic: Configuration possible?

2008-04-07 Thread Axton
When you say package, do you mean packet?  If so, read up on tcp.

Axton


On Mon, Apr 7, 2008 at 12:23 PM, [EMAIL PROTECTED]
wrote:

 **
 Dear list,

 Topic: Network traffic configuration

 ARSystem 7.1 patch02

 We have the situation here, that we have a server in Europe, and some
 clients in Mexico.

 The roundtrip time is around 190ms, which leads so some performance
 issues.


 Question is: how does the package verification work? Is every package
 being confirmed?

 Can it be configured, that for example only every 10th package needs to be
 confirmed?


 Did not find a hint at the documentation, how it works, or if it can be
 configured.


 Thank you all,
 Robert




 Mit den besten Gruessen/Best regards,

 Robert Kern

 VDO Automotive AG
 SV IO IT BO ST
 Sodener Strasse 9, 65824 Schwalbach, Germany

 Ein Unternehmen des Continental-Konzerns/A Company of the Continental
 Corporation

 Telefon/Phone: +49 6196 87-2546
 Mobile: +49 170 8522-515
 Telefax: +49 6196 8779-2546
 E-Mail: [EMAIL PROTECTED]
 http://www.continental-corporation.com
 __

 VDO Automotive AG, Siemensstr. 12, 93055 Regensburg
 Postfach/Postbox 10 09 43, 93009 Regensburg
 Vorsitzender des Aufsichtsrats/Chairman of the Supervisory Board: Johannes
 Suttmeyer
 Vorstand/Managing Board: Dr. Alan Hippe, Helmut Matschi
 Sitz der Gesellschaft/Registered office: Regensburg
 Registergericht/Commercial registry: Regensburg, HRB 10510

 __

 Proprietary and confidential. Distribution only by express authority of
 Continental AG or its subsidiaries. __Platinum Sponsor: 
 www.rmsportal.comARSlist: 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: Notify with attachments

2008-04-07 Thread Brittain, Mark
Hi All,

My headache just got worse. Before I was only testing the first
attachment field. When I create a new record and place attachments in
all three attachment fields, only attachment 2 is saved. 1  3 are not.
Everything appears to be same for all three.

Thanks
Mark

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kalyan Krishna Nethy
Sent: Saturday, April 05, 2008 1:31 PM
To: arslist@ARSLIST.ORG
Subject: Re: Notify with attachments

Mark,

Can you check if the attachment field is display only field. That
could be one of the reasons.

Regards,
Kalyan.

On 4/5/08, Brittain, Mark [EMAIL PROTECTED] wrote:
 HI All,

 I have a email form with an attachment pool. I open the form from a
link
 on the Trouble Ticket form that then populates a subject, and To:
 address. When I hit the send button the PERFORM-ACTION-APPLY runs,
saves
 the form and a filter emails the contents on the form. The email is
sent
 and recieved just fine but without the attachments.

 The problem is the attachments added to the attachment pool are not
 being saved. I have also tried Commit Changes but that does not work
 either. I can go directly on the email form, add the attachment and
save
 it no problem

 What am I missing?

 Thanks

 Mark

 Mark Brittain
 Remedy Developer
 NaviSite Inc.
 [EMAIL PROTECTED]


 This e-mail is the property of NaviSite, Inc. It is intended only
 for the person or entity to which it is addressed and may contain
 information that is privileged, confidential, or otherwise protected
 from disclosure. Distribution or copying of this e-mail, or the
 information contained herein, to anyone other than the intended
 recipient is prohibited.



___
 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

This e-mail is the property of NaviSite, Inc. It is intended only
for the person or entity to which it is addressed and may contain
information that is privileged, confidential, or otherwise protected
from disclosure. Distribution or copying of this e-mail, or the
information contained herein, to anyone other than the intended
recipient is prohibited.

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


FW: Using Open Window action to write report to specified location.

2008-04-07 Thread Matthew Kunkel
I've done a little more research.  It looks like the person doing these
conversions attached the macro instead of the report file, so I switched
the embedded report definition to an .arr and it does not contain the
to-file line.  I did find the documentation about the Target Location
field.  It looks like you can put to-file: in the target location, but
so far I haven't been able to make to-file:
\\windowsshare\SendTest\$Record
BLOCKED::file://windowsshare/SendTest/$Record  ID$.txt   
 
Any ideas?  Has anyone else run into something like this?
 
Thanks,
Matt



From: Matthew Kunkel 
Sent: Thursday, April 03, 2008 4:47 PM
To: 'arslist@ARSLIST.ORG'
Subject: Using Open Window action to write report to specified location.


We're in the process of converting all our old Run Macro active links to
Open Window actions since this has been unsupported for a while now.
Also, the nice little converter will go away when we upgrade to version
7.  I'm running into problems with a macro action that writes a report
to a pre-determined location.  For example the macro might say:
 
sendtotest
Set-schema: Test Schema$Server$
Query: 1=$Record ID$
Report: 21=11=$Record ID$4=5=6=13=
23=07=7210=1968=19=111=012=020=716=-17=
18=119=72=536870936
Statistics: 
 
to-file: \\windowsshare\SendTest\$Record
file://\\windowsshare\SendTest\$Record  ID$.txtO
end
 
This how we save a report to a shared directory without user
interaction, and we're talking about some fairly ancient code here.
Anyhow, when I convert this to an Open Window action, I set the Target =
File, and of course a dialog opens asking for a location.  I try Target
= File \\windowsshare\SendTest\$Record
file://windowsshare/SendTest/$Record  ID$.txt OR Target =
\\windowsshare\SendTest\$Record file://windowsshare/SendTest/$Record
ID$.txt and it doesn't work.  The line
to-file:\\windowsshare\SendTest\$Record
file:///\\windowsshare\SendTest\$Record  ID$.txt is in my report
definition.  
 
Any ideas?   We are still using the Windows thick client although I can
see where this might cause problems on the Web.
 
I'm trying to get around writing a server side process to create the
report and ftp it to the share.
 
Thanks,
Matt



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


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

Re: Using Open Window action to write report to specified location.

2008-04-07 Thread Darrell Reading
Man, that is messed up.  I hope whoever wrote that macro was let go.  I
can't imagine dealing with something so poorly designed in the
production environment...
 

Darrell Reading Systems Engineer 
Phone 479.204.5739 
[EMAIL PROTECTED] 

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

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Matthew Kunkel
Sent: Monday, April 07, 2008 13:31
To: arslist@ARSLIST.ORG
Subject: FW: Using Open Window action to write report to specified
location.


** 
I've done a little more research.  It looks like the person doing these
conversions attached the macro instead of the report file, so I switched
the embedded report definition to an .arr and it does not contain the
to-file line.  I did find the documentation about the Target Location
field.  It looks like you can put to-file: in the target location, but
so far I haven't been able to make to-file:
\\windowsshare\SendTest\$Record
BLOCKED::file://windowsshare/SendTest/$Record  ID$.txt   
 
Any ideas?  Has anyone else run into something like this?
 
Thanks,
Matt



From: Matthew Kunkel 
Sent: Thursday, April 03, 2008 4:47 PM
To: 'arslist@ARSLIST.ORG'
Subject: Using Open Window action to write report to specified location.


We're in the process of converting all our old Run Macro active links to
Open Window actions since this has been unsupported for a while now.
Also, the nice little converter will go away when we upgrade to version
7.  I'm running into problems with a macro action that writes a report
to a pre-determined location.  For example the macro might say:
 
sendtotest
Set-schema: Test Schema$Server$
Query: 1=$Record ID$
Report: 21=11=$Record ID$4=5=6=13=
23=07=7210=1968=19=111=012=020=716=-17=
18=119=72=536870936
Statistics: 
 
to-file: \\windowsshare\SendTest\$Record
file://\\windowsshare\SendTest\$Record  ID$.txtO
end
 
This how we save a report to a shared directory without user
interaction, and we're talking about some fairly ancient code here.
Anyhow, when I convert this to an Open Window action, I set the Target =
File, and of course a dialog opens asking for a location.  I try Target
= File \\windowsshare\SendTest\$Record
file://windowsshare/SendTest/$Record  ID$.txt OR Target =
\\windowsshare\SendTest\$Record file://windowsshare/SendTest/$Record
ID$.txt and it doesn't work.  The line
to-file:\\windowsshare\SendTest\$Record
file:///\\windowsshare\SendTest\$Record  ID$.txt is in my report
definition.  
 
Any ideas?   We are still using the Windows thick client although I can
see where this might cause problems on the Web.
 
I'm trying to get around writing a server side process to create the
report and ftp it to the share.
 
Thanks,
Matt



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

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



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


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

Advanced Search Bar

2008-04-07 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Dear listers,
It's been some time since anyone on my project has been to the 
performance and tuning class and we're having some performance issues at peak 
times.  I'm sure we're getting killed in multiple areas (QBE settings, 
Indexing, etc.) but one of the questions I was asked is about the Advanced 
Search Bar.  I did a quick scan of the docset and didn't see an answer.  Is 
there any way to prevent users from using the Advanced bar?  I see a menu for 
Search Bar in the form action fields, but it's not checked on any of our 
forms.

Thanks much,

Michael A. McManus, SSgt, USAF


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


Re: Advanced Search Bar

2008-04-07 Thread Darrell Reading
If you did that, then what would stop them from keying values in the
fields themselves?
 

Darrell Reading Systems Engineer 
Phone 479.204.5739 
[EMAIL PROTECTED] 

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

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754
ELSG/DOMH
Sent: Monday, April 07, 2008 13:42
To: arslist@ARSLIST.ORG
Subject: Advanced Search Bar


** 

Dear listers,

It's been some time since anyone on my project has been to
the performance and tuning class and we're having some performance
issues at peak times.  I'm sure we're getting killed in multiple areas
(QBE settings, Indexing, etc.) but one of the questions I was asked is
about the Advanced Search Bar.  I did a quick scan of the docset and
didn't see an answer.  Is there any way to prevent users from using the
Advanced bar?  I see a menu for Search Bar in the form action fields,
but it's not checked on any of our forms.

 

Thanks much,

 

Michael A. McManus, SSgt, USAF

 

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



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


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

Re: Advanced Search Bar

2008-04-07 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
Nothing of course, but it would prevent searches like 'Field' != value which 
if memory serves, ignores indexes.  Assuming it can be done anyway.

Michael A. McManus, SSgt, USAF

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Darrell Reading
Sent: Monday, April 07, 2008 1:45 PM
To: arslist@ARSLIST.ORG
Subject: Re: Advanced Search Bar

**
If you did that, then what would stop them from keying values in the fields 
themselves?


Darrell Reading Systems Engineer
Phone 479.204.5739
[EMAIL PROTECTED]

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





From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH
Sent: Monday, April 07, 2008 13:42
To: arslist@ARSLIST.ORG
Subject: Advanced Search Bar


**

Dear listers,

It's been some time since anyone on my project has been to the 
performance and tuning class and we're having some performance issues at peak 
times.  I'm sure we're getting killed in multiple areas (QBE settings, 
Indexing, etc.) but one of the questions I was asked is about the Advanced 
Search Bar.  I did a quick scan of the docset and didn't see an answer.  Is 
there any way to prevent users from using the Advanced bar?  I see a menu for 
Search Bar in the form action fields, but it's not checked on any of our 
forms.



Thanks much,



Michael A. McManus, SSgt, USAF



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



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

__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


CAS Single Sign On

2008-04-07 Thread Masha Bench

 Greetings Listers,
Has any of you integrated CAS (Central Authentication Service) with Remedy? 
From what I can see it is possible, I just wanted to see if anyone could share 
the their experience with it.
ARS 7.1p on Windows 2003 SE
Oracle 10g
Midtier 7.1p2 on RH 5.0

Thanks.

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



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

Monitoring AR Server - Crashing!

2008-04-07 Thread Tadeu Augusto Dutra Pinto
Hi people,
 
I'm in troubles with environment production in these last week
It's second time that our server crashes in a interval of one week and we don't 
have any idea of what is happening with our system...
 
Our log files (API, SQL, Filter, Escalation, Thread, etc...) weren't turn on 
... 
 
Recently we have made an upgrade of our system ...
 
We migrated from AIX 5.1 to AIX 5.3, Oracle database 9i to 10g and ARS 5.1 to 
7.0.01 Patch 4...
 
 
Is there any suggestions about what could be happenin' with our system ... 
Maybe could be because Patch version (I don't know)
 
Will be appreciated tips and suggestions that help us to discovery what can be 
happening and how we can monitor this kind of things...
 
Thanks
 
FYI: twice that server crashes the production environment was in rush hour 
(could it be hardware requirements?? like memory? I don't know)
 
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
Fone: 41 2107-5736 - HSBC Outsourcing
-
Confiabilidade, Inovação e Qualidade em T.I.

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


Re: Advanced Search Bar

2008-04-07 Thread Joe D'Souza
I don't think that is true? LIKE searches ignores indexes to the best of my
knowledge if you use the wildcard anywhere to the left of the string you are
comparing..

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of McManus Michael A SSgt HQ 754
ELSG/DOMH
Sent: Monday, April 07, 2008 3:16 PM
To: arslist@ARSLIST.ORG
Subject: Re: Advanced Search Bar


Nothing of course, but it would prevent searches like 'Field' != value
which if memory serves, ignores indexes.  Assuming it can be done anyway.

Michael A. McManus, SSgt, USAF

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Darrell Reading
Sent: Monday, April 07, 2008 1:45 PM
To: arslist@ARSLIST.ORG
Subject: Re: Advanced Search Bar

**
If you did that, then what would stop them from keying values in the fields
themselves?


Darrell Reading Systems Engineer
Phone 479.204.5739
[EMAIL PROTECTED]

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





From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754
ELSG/DOMH
Sent: Monday, April 07, 2008 13:42
To: arslist@ARSLIST.ORG
Subject: Advanced Search Bar


**

Dear listers,

It's been some time since anyone on my project has been to the
performance and tuning class and we're having some performance issues at
peak times.  I'm sure we're getting killed in multiple areas (QBE settings,
Indexing, etc.) but one of the questions I was asked is about the Advanced
Search Bar.  I did a quick scan of the docset and didn't see an answer.  Is
there any way to prevent users from using the Advanced bar?  I see a menu
for Search Bar in the form action fields, but it's not checked on any of
our forms.



Thanks much,



Michael A. McManus, SSgt, USAF
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.8/1362 - Release Date: 4/6/2008
11:12 AM

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


Re: Mid-Tier help

2008-04-07 Thread Kaiser Norm E CIV USAF 96 CS/SCCE
It's probably a Tomcat issue, I'd think.  I'm not entirely familiar with
Tomcat, as I'm still running New Atlanta, but there must be a way by
which you configure the location of applications...and that's probably
missing on your server.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Monday, April 07, 2008 2:37 PM
To: arslist@ARSLIST.ORG
Subject: Mid-Tier help

** 

I have installed Mid-Tier with IIS6 and Tomcat.

 

I go in and try to open my config.jsp page, and it gives me the Page
cannot be displayed error.

 

Do I need to go in and tell IIS where my website is loaded, or maybe set
an alias? I installed Mid-Tier in the default C:/Program Files/AR
System/Mid Tier folder.

 

I also went into ISAPI filters under Web Sites in IIS and told it .jsp
to open with TomCat.

 

Win 2k3 32-bit

Remedy 7.1

Mid-Tier 7.1

 

 

Thanks,

 

Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

 

__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: Advanced Search Bar

2008-04-07 Thread Kaiser Norm E CIV USAF 96 CS/SCCE
I hate to be Mr. Obvious! It seems to me that attempting to disable
advanced searches is an act of desperation.  If you're so concerned
about users running advanced searches and eating up too much system
resources, perhaps either your system needs a major upgrade or it's not
tuned very well.

We have a single Remedy server here (and a separate Midtier)...Dell 2860
with 4GB RAM.  It supports 18,000+ users 24/7 and it runs like a champ.
I would never dream of disabling the query bar...if performance were an
issue, I'd look elsewhere...

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754
ELSG/DOMH
Sent: Monday, April 07, 2008 2:16 PM
To: arslist@ARSLIST.ORG
Subject: Re: Advanced Search Bar

Nothing of course, but it would prevent searches like 'Field' != value
which if memory serves, ignores indexes.  Assuming it can be done
anyway.

Michael A. McManus, SSgt, USAF

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Darrell Reading
Sent: Monday, April 07, 2008 1:45 PM
To: arslist@ARSLIST.ORG
Subject: Re: Advanced Search Bar

**
If you did that, then what would stop them from keying values in the
fields themselves?


Darrell Reading Systems Engineer
Phone 479.204.5739
[EMAIL PROTECTED]

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





From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754
ELSG/DOMH
Sent: Monday, April 07, 2008 13:42
To: arslist@ARSLIST.ORG
Subject: Advanced Search Bar


**

Dear listers,

It's been some time since anyone on my project has been to
the performance and tuning class and we're having some performance
issues at peak times.  I'm sure we're getting killed in multiple areas
(QBE settings, Indexing, etc.) but one of the questions I was asked is
about the Advanced Search Bar.  I did a quick scan of the docset and
didn't see an answer.  Is there any way to prevent users from using the
Advanced bar?  I see a menu for Search Bar in the form action fields,
but it's not checked on any of our forms.



Thanks much,



Michael A. McManus, SSgt, USAF



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



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

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


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

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


Re: Mid-Tier help

2008-04-07 Thread J.T. Shyman
Gary, try these steps and let us know the results.

 

First off, check to see if the Apache/Tomcat service is running. There
should be a windows service or, depending on the version of Tomcat, an
application you can find in the start menu.

 

Second, by default it should run on port 8080 so try going to
http://server:8080/arsys and see if you get the login page. If so try
http://server:8080/arsys/shared/config/config/jsp

 

 

--- J.T. Shyman

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Monday, April 07, 2008 3:37 PM
To: arslist@ARSLIST.ORG
Subject: Mid-Tier help

 

I have installed Mid-Tier with IIS6 and Tomcat.

 

I go in and try to open my config.jsp page, and it gives me the Page cannot
be displayed error.

 

Do I need to go in and tell IIS where my website is loaded, or maybe set an
alias? I installed Mid-Tier in the default C:/Program Files/AR System/Mid
Tier folder.

 

I also went into ISAPI filters under Web Sites in IIS and told it .jsp to
open with TomCat.

 

Win 2k3 32-bit

Remedy 7.1

Mid-Tier 7.1

 

 

Thanks,

 

Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMIR Level 3 Rated Company

 

__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


Mid-Tier help

2008-04-07 Thread Gary Opela (Corporate)
I have installed Mid-Tier with IIS6 and Tomcat.

 

I go in and try to open my config.jsp page, and it gives me the Page
cannot be displayed error.

 

Do I need to go in and tell IIS where my website is loaded, or maybe set
an alias? I installed Mid-Tier in the default C:/Program Files/AR
System/Mid Tier folder.

 

I also went into ISAPI filters under Web Sites in IIS and told it .jsp
to open with TomCat.

 

Win 2k3 32-bit

Remedy 7.1

Mid-Tier 7.1

 

 

Thanks,

 

Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

 


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


Re: Mid-Tier help

2008-04-07 Thread Gary Opela (Corporate)
This is what we were leaning towards.

 

We start TomCat and it just instantly stops. We cannot get it to stay
started.

 

We looked into event viewer, and noticed that flashboards was throwing
an error that it could not find the JVM, but I installed one.

 

Can anyone give us any help?

 

 

Thanks,

 

Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman
Sent: Monday, April 07, 2008 2:58 PM
To: arslist@ARSLIST.ORG
Subject: Re: Mid-Tier help

 

** 

Gary, try these steps and let us know the results.

 

First off, check to see if the Apache/Tomcat service is running. There
should be a windows service or, depending on the version of Tomcat, an
application you can find in the start menu.

 

Second, by default it should run on port 8080 so try going to
http://server:8080/arsys and see if you get the login page. If so try
http://server:8080/arsys/shared/config/config/jsp

 

 

--- J.T. Shyman

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Monday, April 07, 2008 3:37 PM
To: arslist@ARSLIST.ORG
Subject: Mid-Tier help

 

I have installed Mid-Tier with IIS6 and Tomcat.

 

I go in and try to open my config.jsp page, and it gives me the Page
cannot be displayed error.

 

Do I need to go in and tell IIS where my website is loaded, or maybe set
an alias? I installed Mid-Tier in the default C:/Program Files/AR
System/Mid Tier folder.

 

I also went into ISAPI filters under Web Sites in IIS and told it .jsp
to open with TomCat.

 

Win 2k3 32-bit

Remedy 7.1

Mid-Tier 7.1

 

 

Thanks,

 

Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

 

__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: Advanced Search Bar

2008-04-07 Thread Darrell Reading
The 'Field' != $VALUE$ he is referring to have to do with ENUM fields,
and that does do a table scan, because it grabs all records and then
disregards the != $VALUE$. It's better to do a  on those fields.  We
have some pretty hefty systems here, and a few of the != searches can
hurt us if they are done right after each other.  One could make their
own Advanced Search bar, disable Remedy's, and build in logic to avoid
doing those kinds of search on certain fields.  It won't fix everything,
but it will help. 


Darrell Reading Systems Engineer
Phone 479.204.5739
[EMAIL PROTECTED]

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

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96
CS/SCCE
Sent: Monday, April 07, 2008 15:00
To: arslist@ARSLIST.ORG
Subject: Re: Advanced Search Bar

I hate to be Mr. Obvious! It seems to me that attempting to disable
advanced searches is an act of desperation.  If you're so concerned
about users running advanced searches and eating up too much system
resources, perhaps either your system needs a major upgrade or it's not
tuned very well.

We have a single Remedy server here (and a separate Midtier)...Dell 2860
with 4GB RAM.  It supports 18,000+ users 24/7 and it runs like a champ.
I would never dream of disabling the query bar...if performance were an
issue, I'd look elsewhere...

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754
ELSG/DOMH
Sent: Monday, April 07, 2008 2:16 PM
To: arslist@ARSLIST.ORG
Subject: Re: Advanced Search Bar

Nothing of course, but it would prevent searches like 'Field' != value
which if memory serves, ignores indexes.  Assuming it can be done
anyway.

Michael A. McManus, SSgt, USAF

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Darrell Reading
Sent: Monday, April 07, 2008 1:45 PM
To: arslist@ARSLIST.ORG
Subject: Re: Advanced Search Bar

**
If you did that, then what would stop them from keying values in the
fields themselves?


Darrell Reading Systems Engineer
Phone 479.204.5739
[EMAIL PROTECTED]

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





From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754
ELSG/DOMH
Sent: Monday, April 07, 2008 13:42
To: arslist@ARSLIST.ORG
Subject: Advanced Search Bar


**

Dear listers,

It's been some time since anyone on my project has been to
the performance and tuning class and we're having some performance
issues at peak times.  I'm sure we're getting killed in multiple areas
(QBE settings, Indexing, etc.) but one of the questions I was asked is
about the Advanced Search Bar.  I did a quick scan of the docset and
didn't see an answer.  Is there any way to prevent users from using the
Advanced bar?  I see a menu for Search Bar in the form action fields,
but it's not checked on any of our forms.



Thanks much,



Michael A. McManus, SSgt, USAF



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



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

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


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


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

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


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


Re: Mid-Tier help

2008-04-07 Thread strauss
You may have to reinstall tomcat now that the jvm is present - the
installer will have missed making a number of settings.  Did you really
install it with IIS?  If so, you only installed the Tomcat app server to
provide IIS with a java server page capability - it connects with a
shim, just as ServletExec would if you used it instead of tomcat - and
the mid-tier will be on port 80 via IIS, not 8080 which is tomcat's own
web server.  I'm having to remember quite a ways back here, as I long
since have gone with the built-in tomcat web server instead of IIS.

 

Christopher Strauss, Ph.D.

Call Tracking Administration Manager

University of North Texas Computing  IT Center

http://itsm.unt.edu/ http://itsm.unt.edu/ 

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Monday, April 07, 2008 3:22 PM
To: arslist@ARSLIST.ORG
Subject: Re: Mid-Tier help

 

** 

This is what we were leaning towards.

 

We start TomCat and it just instantly stops. We cannot get it to stay
started.

 

We looked into event viewer, and noticed that flashboards was throwing
an error that it could not find the JVM, but I installed one.

 

Can anyone give us any help?

 

 

Thanks,

 

Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman
Sent: Monday, April 07, 2008 2:58 PM
To: arslist@ARSLIST.ORG
Subject: Re: Mid-Tier help

 

** 

Gary, try these steps and let us know the results.

 

First off, check to see if the Apache/Tomcat service is running. There
should be a windows service or, depending on the version of Tomcat, an
application you can find in the start menu.

 

Second, by default it should run on port 8080 so try going to
http://server:8080/arsys and see if you get the login page. If so try
http://server:8080/arsys/shared/config/config/jsp

 

 

--- J.T. Shyman

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Monday, April 07, 2008 3:37 PM
To: arslist@ARSLIST.ORG
Subject: Mid-Tier help

 

I have installed Mid-Tier with IIS6 and Tomcat.

 

I go in and try to open my config.jsp page, and it gives me the Page
cannot be displayed error.

 

Do I need to go in and tell IIS where my website is loaded, or maybe set
an alias? I installed Mid-Tier in the default C:/Program Files/AR
System/Mid Tier folder.

 

I also went into ISAPI filters under Web Sites in IIS and told it .jsp
to open with TomCat.

 

Win 2k3 32-bit

Remedy 7.1

Mid-Tier 7.1

 

 

Thanks,

 

Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

 

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

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


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


Re: Mid-Tier help

2008-04-07 Thread J.T. Shyman
Sounds like either a Tomcat variable or a system variable or Flashboards was
installed before the JVM and needs to be reinstalled.

 

First, Tomcat. Do you have an interface like this and is the correct path to
the jvm.dll in the field?

 



 

Second, check your system environmental variables and ensure that the path
to the java bin\client folder in the in Path. For example: C:\Program
Files\Java\j2re1.4.2_07\bin\client

 

Third, check the arfbserver.log file in the flashboards install folder to
see if that has any clues as to why flashboards won't start.

 

Fourth, check out the fbserver.bat file. 

 

Use:

fbserver.bat uninstall 

 

to uninstall Flashboards

 

Then use:

 

Fbserver.bat install full path to java vm dll flashboard
install path libver

 

You can find libver by looking for the flashd??.jar file. The ?? is the
libver. 

 

 

--- J.T. Shyman

 

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

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

Re: Advanced Search Bar

2008-04-07 Thread Kaiser Norm E CIV USAF 96 CS/SCCE
Uh...how often is that done by Average Joe User?

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Darrell Reading
Sent: Monday, April 07, 2008 3:34 PM
To: arslist@ARSLIST.ORG
Subject: Re: Advanced Search Bar

The 'Field' != $VALUE$ he is referring to have to do with ENUM fields,
and that does do a table scan, because it grabs all records and then
disregards the != $VALUE$. It's better to do a  on those fields.  We
have some pretty hefty systems here, and a few of the != searches can
hurt us if they are done right after each other.  One could make their
own Advanced Search bar, disable Remedy's, and build in logic to avoid
doing those kinds of search on certain fields.  It won't fix everything,
but it will help. 


Darrell Reading Systems Engineer
Phone 479.204.5739
[EMAIL PROTECTED]

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

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96
CS/SCCE
Sent: Monday, April 07, 2008 15:00
To: arslist@ARSLIST.ORG
Subject: Re: Advanced Search Bar

I hate to be Mr. Obvious! It seems to me that attempting to disable
advanced searches is an act of desperation.  If you're so concerned
about users running advanced searches and eating up too much system
resources, perhaps either your system needs a major upgrade or it's not
tuned very well.

We have a single Remedy server here (and a separate Midtier)...Dell 2860
with 4GB RAM.  It supports 18,000+ users 24/7 and it runs like a champ.
I would never dream of disabling the query bar...if performance were an
issue, I'd look elsewhere...

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754
ELSG/DOMH
Sent: Monday, April 07, 2008 2:16 PM
To: arslist@ARSLIST.ORG
Subject: Re: Advanced Search Bar

Nothing of course, but it would prevent searches like 'Field' != value
which if memory serves, ignores indexes.  Assuming it can be done
anyway.

Michael A. McManus, SSgt, USAF

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Darrell Reading
Sent: Monday, April 07, 2008 1:45 PM
To: arslist@ARSLIST.ORG
Subject: Re: Advanced Search Bar

**
If you did that, then what would stop them from keying values in the
fields themselves?


Darrell Reading Systems Engineer
Phone 479.204.5739
[EMAIL PROTECTED]

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





From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754
ELSG/DOMH
Sent: Monday, April 07, 2008 13:42
To: arslist@ARSLIST.ORG
Subject: Advanced Search Bar


**

Dear listers,

It's been some time since anyone on my project has been to
the performance and tuning class and we're having some performance
issues at peak times.  I'm sure we're getting killed in multiple areas
(QBE settings, Indexing, etc.) but one of the questions I was asked is
about the Advanced Search Bar.  I did a quick scan of the docset and
didn't see an answer.  Is there any way to prevent users from using the
Advanced bar?  I see a menu for Search Bar in the form action fields,
but it's not checked on any of our forms.



Thanks much,



Michael A. McManus, SSgt, USAF



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



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

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


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


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

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

Re: Mid-Tier help

2008-04-07 Thread William Rentfrow
Did you configure/verify the ISAPI settings for Tomcat/IIS?



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman
Sent: Monday, April 07, 2008 4:07 PM
To: arslist@ARSLIST.ORG
Subject: Re: Mid-Tier help


** 

Sounds like either a Tomcat variable or a system variable or Flashboards
was installed before the JVM and needs to be reinstalled.

 

First, Tomcat. Do you have an interface like this and is the correct
path to the jvm.dll in the field?

 

 

 

Second, check your system environmental variables and ensure that the
path to the java bin\client folder in the in Path. For example:
C:\Program Files\Java\j2re1.4.2_07\bin\client

 

Third, check the arfbserver.log file in the flashboards install folder
to see if that has any clues as to why flashboards won't start.

 

Fourth, check out the fbserver.bat file. 

 

Use:

fbserver.bat uninstall 

 

to uninstall Flashboards

 

Then use:

 

Fbserver.bat install full path to java vm dll flashboard
install path libver

 

You can find libver by looking for the flashd??.jar file. The ?? is the
libver. 

 

 

--- J.T. Shyman

 

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

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

Re: Advanced Search Bar

2008-04-07 Thread Darrell Reading
Often here when Joe user is searching for tickets that are not Closed.
When Joe user tries it three times, which is usually the case, on a
table that has 1.6 million rows, and then some other users do other bad
queries at the same time we can see impact here. 


Darrell Reading Systems Engineer
Phone 479.204.5739
[EMAIL PROTECTED]

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

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96
CS/SCCE
Sent: Monday, April 07, 2008 16:10
To: arslist@ARSLIST.ORG
Subject: Re: Advanced Search Bar

Uh...how often is that done by Average Joe User?

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Darrell Reading
Sent: Monday, April 07, 2008 3:34 PM
To: arslist@ARSLIST.ORG
Subject: Re: Advanced Search Bar

The 'Field' != $VALUE$ he is referring to have to do with ENUM fields,
and that does do a table scan, because it grabs all records and then
disregards the != $VALUE$. It's better to do a  on those fields.  We
have some pretty hefty systems here, and a few of the != searches can
hurt us if they are done right after each other.  One could make their
own Advanced Search bar, disable Remedy's, and build in logic to avoid
doing those kinds of search on certain fields.  It won't fix everything,
but it will help. 


Darrell Reading Systems Engineer
Phone 479.204.5739
[EMAIL PROTECTED]

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

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96
CS/SCCE
Sent: Monday, April 07, 2008 15:00
To: arslist@ARSLIST.ORG
Subject: Re: Advanced Search Bar

I hate to be Mr. Obvious! It seems to me that attempting to disable
advanced searches is an act of desperation.  If you're so concerned
about users running advanced searches and eating up too much system
resources, perhaps either your system needs a major upgrade or it's not
tuned very well.

We have a single Remedy server here (and a separate Midtier)...Dell 2860
with 4GB RAM.  It supports 18,000+ users 24/7 and it runs like a champ.
I would never dream of disabling the query bar...if performance were an
issue, I'd look elsewhere...

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754
ELSG/DOMH
Sent: Monday, April 07, 2008 2:16 PM
To: arslist@ARSLIST.ORG
Subject: Re: Advanced Search Bar

Nothing of course, but it would prevent searches like 'Field' != value
which if memory serves, ignores indexes.  Assuming it can be done
anyway.

Michael A. McManus, SSgt, USAF

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Darrell Reading
Sent: Monday, April 07, 2008 1:45 PM
To: arslist@ARSLIST.ORG
Subject: Re: Advanced Search Bar

**
If you did that, then what would stop them from keying values in the
fields themselves?


Darrell Reading Systems Engineer
Phone 479.204.5739
[EMAIL PROTECTED]

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





From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754
ELSG/DOMH
Sent: Monday, April 07, 2008 13:42
To: arslist@ARSLIST.ORG
Subject: Advanced Search Bar


**

Dear listers,

It's been some time since anyone on my project has been to
the performance and tuning class and we're having some performance
issues at peak times.  I'm sure we're getting killed in multiple areas
(QBE settings, Indexing, etc.) but one of the questions I was asked is
about the Advanced Search Bar.  I did a quick scan of the docset and
didn't see an answer.  Is there any way to prevent users from using the
Advanced bar?  I see a menu for Search Bar in the form action fields,
but it's not checked on any of our forms.



Thanks much,



Michael A. McManus, SSgt, USAF



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



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

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


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum 

Re: Midtier wait icon

2008-04-07 Thread Grooms, Frederick W
For the MidTier you should be able to use some JavaScript to change your
cursor in an ActiveLink.
 
The Run Process actions would be something like:
 
//Set cursor to hourglass
javascript: document.body.style.cursor = wait;

//Turn hourglass off
javascript: document.body.style.cursor = default;
 
Fred
 




From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Shoemaker, Gary
Sent: Monday, April 07, 2008 12:45 PM
To: arslist@ARSLIST.ORG
Subject: Midtier wait icon


I am wanting to simulate the wait icon, because I need to walk some
tables and the wait time is 3-5 seconds.  I checked with support and
they said there is not a way to force their wait icon.  Has anyone
implemented their own wait icon?
 
Server 7.1
Midtier 7.1
 
Gary Shoemaker 
Sandia National Laboratories 

 
 

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


Re: Monitoring AR Server - Crashing!

2008-04-07 Thread Benedetto Cantatore
My previous job, I was on a SUSE Linux system, ARServer patch 4 was causing our 
server to crash every other day.  I had to roll back to patch 3.  I recommend 
you either roll back or patch to 5/6.  
 


 [EMAIL PROTECTED] 04/07/08 3:36 PM 

** Hi people,
 
I'm in troubles with environment production in these last week
It's second time that our server crashes in a interval of one week and we don't 
have any idea of what is happening with our system...
 
Our log files (API, SQL, Filter, Escalation, Thread, etc...) weren't turn on 
... 
 
Recently we have made an upgrade of our system ...
 
We migrated from AIX 5.1 to AIX 5.3, Oracle database 9i to 10g and ARS 5.1 to 
7.0.01 Patch 4...
 
 
Is there any suggestions about what could be happenin' with our system ... 
Maybe could be because Patch version (I don't know)
 
Will be appreciated tips and suggestions that help us to discovery what can be 
happening and how we can monitor this kind of things...
 
Thanks
 
FYI: twice that server crashes the production environment was in rush hour 
(could it be hardware requirements?? like memory? I don't know)
 
Att
 
 


Tadeu Augusto Dutra Pinto
-
IT Web Services ATM Cinq Technologies
http://www.cinq.com.br 
[EMAIL PROTECTED]
Fone: 41 3018-2833 - Cinq
Fone: 41 2107-5736 - HSBC Outsourcing
-
Confiabilidade, Inovação e Qualidade em T.I.



__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


Set an editable check box in a table field

2008-04-07 Thread Jason Miller
Hi all,

I am wondering if anybody has or knows if it is possible to run a active
link table loop and check a check box that is set to editable.  What we have
is a parent child set of forms with the children viewable in a table field
on the parent form.  In that table field there is a check box field that I
have set to editable.

What I would like to do is create a table loop that will go through and
check the box in all of the child records when the Select All button is
pushed.  I have created a guide and AL that does a set fields to the
attribute value of the check box.  The only thing the AL will do is NULL the
field if there is a check mark in it.  I have tried using the Selection
Value, the Alias Value, the ID Value for that field with no luck.  I even
tried using   in my set field action hoping to emulate a press of the
space bar. Just to test I added an editable character field to my set fields
action and the value is entered when looping no problem.

Any ideas would be appreciated.  I am questioning if it is even possible to
set a check box in a table field because when I click on Modify Action in my
set fields it adds double quotes to any value I put in there. One workaround
that I though about was to do a push field, setting the check box on the
child records when clicking Select All and then refresh the table but I
would prefer to just set value in the table field and then push the value
with the parent is saved.

Thanks,
Jason

ARS 7.0.1 p6
Windows 2003
SQL 2005

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


Question: Production Testing - ITSM 7 (patch 6)

2008-04-07 Thread T. Dee
I am going to be migrating the code / data from our development server
to our production server.

The users will test the production server to ensure everything is OK
before go live date.

I know that I will need to reset the Help Desk, Change and Task ticket
numbers back to zero.

However, I was wondering what other underlying forms will need to be
reset as well.  Has anyone done this?

THANKS!!!

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


Re: Search Menus

2008-04-07 Thread Carey Matthew Black
Kathy,

There are are a few things that I think will help explain the
details... so let me start at the beginning

I see three questions in your post:

RE: Question #1

When the user selects the menu in Help Desk - does it go to the
database to query all the records from the location table.


Depending on how the menu is defined, the list of values to be shown
to the user ( on the menu UI ) may be determined at a few different
points in time.

 If the menu is a search menu that refreshes on 15 minute
intervals, then the server gets a list of the values, and holds them
in RAM. When the Client asks for the ARS menu object then it gets the
list of values on the server at that time. (The client may even re-ask
for the list every 15 minuets too, but I have never taken the time to
watch/test that detail.)

 If the menu is a search menu that refreshes on Connect then the
list is gathered when the user opens the ARS form.

 If the menu is a search menu that refreshes on Open then the
list is gathered when the user clicks (mouseDown) on the Menu widget
itself. (If the user clicks 15 times and never selects a value then 15
searches were likely done to the RDBMS.)


Beyond When the data is retrieved the What data is retrieved is
determined by the ARS Menu definition too. So if there is no Query
Qualification, then All records would be returned. However, that is
not a likely condition for a production application.


RE: Question #2

Secondly, if I have an open window action that passes a qualification
against the Help Desk table - - does the workflow query the database
once or twice to get the results?


This does not really sound like a Menu question to me... but...
First see the above description of how menus work with reference to
their refresh options and how that relates to the opening of an ARS
form object.

It might also be useful to know that it is possible that the menu data
will be refreshed once for the Window Open, and for a second menu
(maybe looking at similar data, but from a different field, or maybe
from active links that might swap the menus on fields etc...) So if
you are watching SQL logs you may see queries that look very much a
like, but are in fact from different ARS objects.

Also You may be seeing two searches because of the Results
list data and the Detail  parts of the screen. When the UI (ARS
form) has a Results List and a Detail pane visible the data is
retried in two separate API calls. GLF (Get List with Fields to fill
the Results List UI) and a second call that retrieves the details
for the selected record in the Results List in the form of a GE (Get
Entry). Maybe this behaviour is really want your asking about?


RE: Question #3

However when Remedy runs the open window $qualification$ action does
it search the entire HPD:Help Desk table to process the qualification
?


I am sorry, but I do not understand this question. How can any
application search a table without searching the entire table?
(under any conditions?) If the qualification is set up to not use an
index, then a table scan might happen. However that has more to do
with the quality of the qualification and the indexes that exist on
the table then any details of how ARS.

HTH

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

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



On Fri, Apr 4, 2008 at 3:50 PM, Kathy Morris [EMAIL PROTECTED] wrote:
 **

 Hi,

 We have a search menu in the Help Desk that pulls from another table (i.e.
 locations).  When the user selects the menu in Help Desk - does it go to the
 database to query all the records from the location table.  Secondly, if I
 have an open window action that passes a qualification against the Help Desk
 table - - does the workflow query the database once or twice to get the
 results?  I believe it searches the database to get the location data, and
 the second time to process the qualification.  However when Remedy runs the
 open window $qualification$ action does it search the entire HPD:Help Desk
 table to process the qualification ?

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


Re: 7.1 AR user Client - 6.3 Server - Quick Question?

2008-04-07 Thread Meenakshinathan
Hi Rick and Ben,

I am able to access my 6.3 server using 7.1 client. But now, i could
not acces my server information using admin tool,

Can you please help me, how can i bring my admin console...for 6.3
server.. in the 7.1 client.

Thanks in advance,
Meenakshinathan

On Mar 31, 9:49 pm, Rick Cook [EMAIL PROTECTED] wrote:
 That's right - I remember this now.  It had to do with having a version of
 CR that was compatible with both the AR Server and the UT.  Good catch, Ben.

 Rick

 On Mon, Mar 31, 2008 at 9:37 AM, Benedetto Cantatore 





 [EMAIL PROTECTED] wrote:
  ** The only issue I ever saw, was running Crystal reports... and those
  issues were limited to inidividual users.  Mostly it works just fine.

   [EMAIL PROTECTED] 03/31/08 12:26 PM 
  Hi All,

  I am trying to access my 6.3 server using my 7.1 AR user client(Not
  Admin).We are having our helpdesk in 6.3 server and our new service
  desk in 7.1. For time being we want to access the both system. Is that
  any problem accessing the forms and objects like this? I tried to
  login and make the updation. I didn;t get any error and it is working
  fine for me. Anyway just want to ask the experience from others.
  Please let me know issues regarding this.

  Thanks,
  Meenakshinathan

  ___­
  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
  Platinum Sponsor:www.rmsportal.comARSlist: Where the Answers Are
  __Platinum Sponsor:www.rmsportal.comARSlist: Where the Answers Are
  html___

 ___­
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 Platinum Sponsor:www.rmsportal.comARSlist: Where the Answers Are- Hide 
 quoted text -

 - Show quoted text -

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