112 Field

2006-10-30 Thread Gianluca Nieri
**
Hi everybody,I created on a form the 112 field and populated it with the groups I want to display the records.But when I try to access the form from a user belonging to a group not in the list, all the records are still visible.Can you help me please? __20060125___This posting was submitted with HTML in it___


Re: CMDB/DSL - Cleaning Up Product Dictionary Entries

2006-10-30 Thread Cindy Sapochetti
Hi Michael - 

No solution for you, but we will likely do something similar.  We've done 
some editing of the DSL behind the scenes, using the forms you've already 
mentioned, and have not seen issues.  We'll likely build our own 
maintenance form(s) as well for any future DSL updates.

Having said that, we put in an RFE for better overall DSL management 
capabilities, including the ability to categorize the software as you like, 
instead of just Software-Application-Third Party, which does zip for our 
reporting.  The more RFE's they get on this, the more likely they'll  beef 
it up I would think.

Cindy

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


EIE 7.0 Issues (hanging + API Error)

2006-10-30 Thread Cindy Sapochetti
Listers - 

Having issues with EIE 7.0 hanging after working for about a week.  I 
have several active data exchanges which worked until 2 days ago, then just 
stopped.  Have debugging on, and after restarting EIE service, eiemain.dbg 
would just show Starting to look for changes to data exchange definitions 
and then nothing more.  Since this is a dev server, eie.cfg has a 
ConfigInterval set to 1 - but it never continues to check each minute, it 
just seems to hang.

I rebooted the box this a.m. (Windows 2003 server), and got the following 
in eiemain.dbg (see below).  Two things to note: API error and the fact 
that after 9:43, it never cycled again to look for changes.

I tried looking up the API error, no luck. 

Does anyone have any ideas?  I'm stuck!

Thanks,
Cindy


EIEMain.dbg log:

[08:58:36,10/27/06] - Starting to look for changes to data exchange 
definitions
[09:41:16,10/27/06] - Starting to look for changes to data exchange 
definitions
[09:41:17,10/27/06] - CreateDataExchangelist: AR API returned error during 
ARGetListEntry, Error = 2
[09:41:20,10/27/06] - Failed to retrieve any active data exchange defined 
on AR System: scrmdy07
[09:41:20,10/27/06] - Starting threads to manage event driven requests
[09:41:20,10/27/06] - Immediate async thread started.
[09:41:20,10/27/06] - Event Request cleanup thread started.
[09:41:20,10/27/06] - Waiting for 1 minutes to look for changes to data 
exchange definitions.
[09:42:33,10/27/06] - Starting to look for changes to data exchange 
definitions
[09:42:40,10/27/06] - CreateDataExchangelist: AR API returned error during 
ARGetListEntry, Error = 2
[09:42:40,10/27/06] - Failed to retrieve any active data exchange defined 
on AR System: scrmdy07
[09:42:40,10/27/06] - Waiting for 1 minutes to look for changes to data 
exchange definitions.
[09:43:57,10/27/06] - Starting to look for changes to data exchange 
definitions

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


ARS 7.x Solaris 10 Containers

2006-10-30 Thread Chris Rom
Is anyone out there running ARS 7.x within Solaris 10 containers ?

ARS 7.0.1 supposedly supports this now.

http://www.sun.com/software/solaris/utilization.jsp

Have you been able to consolidate multiple servers (app, DB and Mid-Tier) 
into one and what was your experience ?

Any feedback would be appreciated.

Rgds,

Chris Rom
Schlumberger

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


Re: HD 6.0 Run Process Problem

2006-10-30 Thread Ben Chernys
Try typing cmd /? in a command window  (Start Button, Run..., cmd.exe)
Ben Chernys

Senior Software Architect
Software Tool House Inc.

Canada / Deutschland / Germany
Mobile:  +49 (0162) 175 0956   GMT + 1
Email:   mailto:[EMAIL PROTECTED]
Web: http://www.softwaretoolhouse.com

A free notepad for Diary fields:
http://www.softwaretoolhouse.com/downloads/DiaryFieldEditor.htm
An ARS integration, import, migration, batch facility:
http://www.softwaretoolhouse.com/products/SthMupd
  

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Urbanek, Clint
Sent: October 27, 2006 6:36 PM
To: arslist@ARSLIST.ORG
Subject: Re: HD 6.0 Run Process Problem

I do not know where you can get documentation, but I believe /c closes the
cmd window after finishing the command. 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Sanford, Claire
Sent: Friday, October 27, 2006 7:44 AM
To: arslist@ARSLIST.ORG
Subject: Re: HD 6.0 Run Process Problem

Does anyone know where to point me to get a list of command line switches
for ver 6.3??

I specifically need to know what  /c stands for, but need to see what else
is available.

This is workflow that was originally created by a consultant that did not
document what he did (NOT PHIL).

I tried mapping to my old production server and running the process there,
but it didn't work.  Still no error message.

Claire

-Original Message-
From: Sanford, Claire
Sent: Wednesday, October 25, 2006 4:23 PM
To: 'arslist@ARSLIST.ORG'
Subject: RE: HD 6.0 Run Process Problem

I am trying to get my paging working on the Help Desk tickets.

Everything is set up exactly the same on the new server as it is on the old
server (still production), but it doesn't send the page.

I changed the Filter name from Checking SHRH:HPD-Page7_cmd_asgn To Checking
SHRH:HPD-Page7_cmd_asgn`! To get it to process in Phase 1, but that didn't
seem to make any difference.

If I cut and paste the line from the filter log into the CMD window, it will
send the page.

This is what I have in my Run Process Line:

$zTmpPagerCommand$ $zTmpParameter2$$Case ID+$ $Priority$ assigned to you

This is the output:

cmd /c C:\WINDOWS\system32\cmdmsgr.exe -p20333 -cMetroCall -m Sev 3 - Med
assigned to you


The only difference in the old and new server is that the old is windows NT
and the new is Win2003.

The path on the old is :  cmd /c C:\winnt\system32\cmdmsgr.exe The path on
the new is :cmd /c C:\WINDOWS\system32\cmdmsgr.exe

Any thoughts

ARS 6.3 Patch 18
HD 6.0
Oracle 10 w/9 libraries
Oracle lives on a remote server
Windows 2003 4 gig on app server and 8 gig on DB server

Claire Sanford
Information Systems Division
Memorial Hermann Healthcare System
Phone: 713 448 6035
[EMAIL PROTECTED]


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


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

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


DST changes this weekend

2006-10-30 Thread Chris Rom
With the US and many other countries changing from back DST time this 
weekend, I was wondering how other admins handle the change.

We have users and support groups in more than 100 countries and twice a 
year our admin team had to manually update business hours. Only a few 
support groups are 24x7. To complicate things, some countries change at 
different times, while other countries go the opposite direction later this 
year (Ex: Brazil on Nov. 5).

We are currently on a custom system but I am wondering if ITSM handles this 
automatically or if manual updates are required. Do you need to update the 
business hours ?

A useful site - http://www.timeanddate.com/time/aboutdst.html

Rgds,

Chris Rom
Schlumberger

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


MS/SQL - does 1=0 filter push action table scans

2006-10-30 Thread David Chan
Hi all

I am trying to confirm...

On MS/SQL database, does 1=0 qualification in filter push action cause 
table scan.

I know oracle does... just confirming if SQL 2000 does

thanks... dave

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


Re: ITSM 7.0 PDL-Contracts relationship question - WAS RE: sanity check

2006-10-30 Thread Cindy Sapochetti
Silly question - but when you say relate contract to an item in the product 
catalog - do you mean relate a contract to an asset (CI)?  If so, what type 
of asset and what type of contract?

Cindy

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


Re: CMDB Question

2006-10-30 Thread Cindy Sapochetti
We'll be in the same boat as well.  After a first pass look at where to put 
things, we're thinking of creating either a subclass under 
BMC_HardwareSystemComponent, or a cat. subclass under Media for the SAN 
devices themselvesremains to be seen what our folks need to track about 
them though for final decision.

We don't have any of the Remedy/BMC topology stuffif anyone does and it 
gives a clue, please let us know!

Cindy

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


7.0 Menu Displayed Error

2006-10-30 Thread Pam Hollis
I am in the process of configuring my 7.0 Applications.  I have noticed 
that when I initially open Remedy going to the Home Page - and I click on 
the Incident Managment Link or if I go into the Application Administration 
Console to Setup People, Categories etc - when I click to View People link 
or another one of the links I receive the same message.

I get a Selection List Box - that has Return Components To1 listed 3 
times.  I just say OK and the form comes up just fine.  But, I need to 
make this go away - or my users will be complaining if the first time they 
open the form it asks them this.  

Any one else have this problem.

Thanks
Pam Hollis
ARSystem 7.0.1 - ITSM patch2
Oracle 10g/Linux 

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


Re: Direct SQL - How can I use a $TIMESTAMP$ reference?

2006-10-30 Thread Dylan Thomas
I don't think you can subtract from the timestamp like that can you? Have
you tried using a datediff to get the proper date?

On Fri, 27 Oct 2006 15:55:35 -0400, Leigh Gruber [EMAIL PROTECTED] wrote:

Hi Everyone,

 

I met a number of you at the 2005 RUG and am sorry that I didn't get to
this year's gathering.  My husband and friends DID have successful
English Channel relay swim over and back so I missed the event for a
good reason. Hope to see you next year!

 

Now my question I am writing new workflow and have a direct SQL
statement in an escalation which will execute occasionally.
Unfortunately I get an error due to the conversion of the $TIMESTAMP$
value into a nicely formatted date/time stamp.  

 

How can I get the current time to come out in epoch time so it will
play nicely with the create date and the calculated offset?

 

This is the direct SQL statement.

SELECT count(*) FROM Issue 
WHERE  Customer_Abbreviation = '$Customer_Abbreviation$' AND 
Create_Date  ($TIMESTAMP$ - ($Threshold Days$ * 24 * 60 * 60))



And this is what I see when the SQL log is turned on for the server.
SELECT count(*) FROM Issue 
WHERE  Customer_Abbreviation = 'zSENTEL' AND 
Create_Date  (10/27/2006 3:33:51 PM - (28 * 24 * 60 * 60))



^

(*** ERROR *** Line 1: Incorrect syntax near '3'. (SQL Server 170))

 

We're running SQL Server 2000 on Windows 2003 OS.

 

Many thanks,

Leigh



The information contained in this message may be privileged and/or
confidential. If you are not the intended recipient, or responsible for
delivering this message to the intended recipient, any review, forwarding,
dissemination, distribution or copying of this communication or any
attachment(s) is strictly prohibited. If you have received this message in
error, please so notify the sender immediately, and delete it and all
attachments from your computer and network.


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


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


Re: scrolling message in remedy

2006-10-30 Thread Jim Bruce
You could add a View Field and a Character Field to your form.
In an active link, set the Character field with some HTML like:

marquee width=100% behavior=scroll[MESSAGE]/marquee

In another active link, change the [MESSAGE] string to whatever you want, 
perhaps from a Message form maintained externally.

Character Field = REPLACE($Character Field$, [MESSAGE], $New Message$)

Hope that helps,

Jim Bruce


On Thu, 26 Oct 2006 17:06:47 -0400, Niu, Jason 
[EMAIL PROTECTED] wrote:

** 

Does anyone know a way to display scrolling message in Remedy?

 

Such as NOTICE: There is currently an outage on AMAACK2A102 - Use Maser
Ticket 758658, scrolling from right to left...

 

Thanks,

Jason Niu

Remedy Skilled Professional

Alliance Bernstein

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC
HQISEC/L3
Sent: Monday, July 10, 2006 5:43 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARERR 405 exporting Display Only form to .def file

 

Fred: 
  
I might be able to test this in the near future. 
  
James McKenzie 
  

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W 
Sent: Monday, July 10, 2006 1:58 PM 
To: arslist@ARSLIST.ORG 
Subject: Re: ARERR 405 exporting Display Only form to .def file 

 

** 
I think you might be able to change from a core field to some other
field. 

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC
HQISEC/L3

Sent: Monday, July 10, 2006 3:53 PM 
To: arslist@ARSLIST.ORG 
Subject: Re: ARERR 405 exporting Display Only form to .def file 

 

** 

Fred: 

Will this work with a core field? 

James McKenzie 
  
[Information on ARCHGID deleted] 

__20060125___This posting was submitted with HTML in
it___

-
The information contained in this transmission may be privileged and
confidential and is intended only for the use of the person(s) named
above. If you are not the intended recipient, or an employee or agent 
responsible
for delivering this message to the intended recipient, any review, 
dissemination,
distribution or duplication of this communication is strictly prohibited. 
If you are
not the intended recipient, please contact the sender immediately by reply 
e-mail
and destroy all copies of the original message. Please note that we do not 
accept
account orders and/or instructions by e-mail, and therefore will not be 
responsible
for carrying out such orders and/or instructions.  If you, as the intended 
recipient
of this message, the purpose of which is to inform and update our clients, 
prospects
and consultants of developments relating to our services and products, 
would not
like to receive further e-mail correspondence from the sender, 
please reply to the
sender indicating your wishes.  In the U.S.: 1345 Avenue of the Americas, 
New York,
NY 10105.

___

UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

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


JOB: Permanent Remedy Admin/Developer Position (Northern VA)

2006-10-30 Thread John Ennis
A fast growing network services company located in Herndon Virginia is 
seeking a junior-to-mid level Systems Analyst. This is a full-time 
permanent position responsible for implementing, tailoring, and 
administering the Remedy AR System and other enterprise-wide applications. 

Experience:
- Remedy installation, configuration, development and administration;
- 2+ years UNIX system administration;
- user support and training experience; 
- knowledge of a relational database management system.

If you are interested in learning more about this position, or know 
someone else who may be interested (we pay a generous referral bonus), 
please contact me at [EMAIL PROTECTED]

Thank you for your time.

Regards,
John Ennis
RJM Technologies, Inc.
[EMAIL PROTECTED]

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


Re: 112 Field

2006-10-30 Thread Frank Caruso
**
Check the permissions on Field ID 1.It may say Public which mean all groups have access. Set the permission of field ID 1 to Assigned Group to only allow the groups in 112 access.On 10/29/06, 
Gianluca Nieri [EMAIL PROTECTED] wrote:
**
Hi everybody,I created on a form the 112 field and populated it with the groups I want to display the records.But when I try to access the form from a user belonging to a group not in the list, all the records are still visible.
Can you help me please?

 __20060125___This posting was submitted with HTML in it___

-- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineerwww.specificintegration.com703-376-1249
__20060125___This posting was submitted with HTML in it___


Re: Client Application SSO (U)

2006-10-30 Thread Dylan Thomas
Stephen, I'm just curious why you couldn't use the Remedy SSO
implementation? That's what we're using here and no probs so far.

I'm also confused about the User tool SSO. If you uncheck the prompt for
password box, it'll auto log you in? Are you talking about making it so you
can login to any workstation on the network, open the User tool and it will
auto log you in? Now that would be cool :)

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


Login in Alert Tool

2006-10-30 Thread Rezaul Haque
Is there a way to configure auto login to Alert Tool when you login to User 
tool?

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


Converting Remedy Datetime for SQL Query

2006-10-30 Thread James Van Sickle
Fellow ARSList Members

   I need to convert the Epoch time format that Remedy stores its datetime 
data into a more readable format for an SQL query.  According to an older 
KB article I have from Remedy, Remedy recommends using DATEADD(day, 
h.Cinsert field id-2440588, '01/01/1970') to format what they store as 
1161641694 into 10/23/2006 6:14:54 PM.  The article also claims I have to 
add h.Cinsert field id IS NOT NULL and h.Cinsert field id  2440590 
to the where statement of the query.

The following is the SQL query I am running based on the KB article.

select  h.C1 as Case ID,
 DATEADD(day, h.C3-2440588, '01/01/1970') as Arrival Time,
from  T87 h
where h.C1 = 'HD367848'
and h.C3 IS NOT NULL 
and h.C3  2440590

   When I use this query, my Microsoft SQL Server 2000 returns Adding a 
value to a 'datetime' column caused overflow.  Does anyone have the 
correct string to use in a SQL query to convert the returned date/time 
values into readable date/time format.  I would appreciate any assistance 
you can give on this, and thank you for you time regarding this question.

James Van Sickle

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


Re: Client Application SSO (U)

2006-10-30 Thread Michiel Beijen

Axton,

This will also be true for https right? With https the TRAFFIC is
encrypted but the URLs are not. This makes sense because you first
have to request a site (by issuing an URL) before the secure
connection can  be set up.

Kind regards,

Michiel

On 10/26/06, Axton [EMAIL PROTECTED] wrote:

The only other things I can think of:
If not using https
- browser will store url in history (username/pass)
- proxy server will store url (username/pass)
- username/password are visible on network in plain text

Axton Grams

On 10/26/06, Heider, Stephen [EMAIL PROTECTED] wrote:
 If you can find a way to bypass the security with this model please post
 a message. I can then patch it.  Thanks.

 Stephen

 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of Axton
 Sent: Thursday, October 26, 2006 3:09 PM
 To: arslist@ARSLIST.ORG
 Subject: Re: Client Application SSO (U)

 This is good.  I didn't know whether you were relying on the web
 server/domain to authenticate the user or if you were using some vb
 command to read the username.

 Axton Grams

 On 10/26/06, Heider, Stephen [EMAIL PROTECTED] wrote:
  Axton,
 
  Great questions.  I tested each of these scenarios.  I created a local

  account with a username of an existing employee.  After some testing I

  then added this user to the local Admin group and also added the
  employee's domain\username to the local Admin group.
 
  Local accounts do not have access to connect to our remedy web server,

  only authenticated domain users.  With each attempt the Windows login
  prompt was presented.  When I provided my network credentials the web
  app knew that I was using my login name and not the local user.
 
  I then attempted to Run As IE as the local account user (logged into
  Windows as me) and entered the URL in the address field.  The web app
  knew it was me.  I then logged into Windows as the local account and
  ran IE with Run As me. Same result.
 
  The web app checks the domain when logging in.  All our employees are
  in the same domain, so checking here is easy.  For companies that have

  multiple domains additional checks would need to be done.  You could
  also track a lot of details regarding the SSO web app session, such as

  IP address, computer name, etc.  If someone successfully spoofed a
  login [to get into Remedy only] in the logging file/table tracks could

  lead back to the culprit.
 
  The only thing I didn't try was to rename my computer to the name of
  the domain.  This may present the web app with domain\username,
  however the Remedy web server still wouldn't allow access without a
  valid domain account login.
 
  To spoof the web app I think that either the browser or .Net libraries

  would need to be hacked.  Or, if they somehow intercepted calls made
  to HttpContext.Current.User.Identity.Name from the web app and
  interjected a new value when sending data back to the web server it
 might work.
  Can't say for sure, but if someone can hack into this they may also be

  able to hack into LDAP authentication as well.
 
 
  Stephen
 
 
 
  -Original Message-
  From: Action Request System discussion list(ARSList)
  [mailto:[EMAIL PROTECTED] On Behalf Of Axton
  Sent: Thursday, October 26, 2006 11:52 AM
  To: arslist@ARSLIST.ORG
  Subject: Re: Client Application SSO (U)
 
  So what happens if I create a local account on my desktop that has the

  same login name as some other domain account, then proceed to access
  your SSO enabled web interfaces?
 
  Or even better, create the local account, then run iexplore.exe as
  that user?
 
  Axton Grams
 
  On 10/26/06, Heider, Stephen [EMAIL PROTECTED] wrote:
   For inquiring minds... here is the SSO solution I implemented here.
  
   Background:
   Over the last couple months I have been researching SSO solutions
   for Remedy, initially only for Mid Tier (6.3, 7.0).  There are
   several good ones that will do the job.  The costs prevented us
   purchasing ($15K for a Mid Tier-only solution up to $100K+ for a
   solution for all
 
   web and Windows applications including non-Remedy apps).
  
   A few weeks after the decision was made not to purchase I began
   reading more and more posts about implementing SSO.  I gleaned some
   ideas from Listers and determined that I was going to find a
 solution.
 
   It didn't take long to see that this would work.  It may not be
   applicable in certain companies/organizations (ie. top secret
   government work), but I suppose it could be useful in about 90% of
  Remedy installations.
  
   Goal:
   Provide seamless login (aka SSO) to our end-user Mid Tier
   application for all employees with Read/Read Restricted licenses.
   We wanted to make it easy for our employees to be able to submit and

   view their own
 
   tickets.  SSO makes it as simple as clicking a link on a web page.
   For those with Fixed/Floating licenses (technicians and technical
   management) 

Re: NEW: Open Window Actions Blocked - Other Methods?

2006-10-30 Thread Michiel Beijen

Craig,

When there was a way around popup blockers, other people would use
that as well and that way the popup blockers would not be of much use.

If your users are all in a windows domain you can try talking to the
Windows team, they can push a policy setting where your mid-tier
domain would be allowed to show popups. If you do not have control
over your users clients you could choose not to open new forms but
include display only fields on the current form, maybe with a
different color or something, to display those messages. This way you
would have no popups so also no problems with popup blockers.

--
Michiel

On 10/27/06, Carter, Craig J Civ ARPC/DPD
[EMAIL PROTECTED] wrote:

**



ARS 6.3 P16

ServletExec 5.0 AS

Windows IIS



We've built several web applications that open new windows (another Remedy
form) to display informational messages, get feedback, etc.  Our customers
are worldwide and many of them are using ISP-provided browsers and tools
that prevent Javascript popup windows from being displayed.  It's causing a
lot of problems since a good majority of them don't understand them or know
how to turn them off.  Some are running multiple blockers without even
realizing it.



Anyone have any good alternatives to opening forms in new windows that will
not trigger the Javascript popup blockers?



Craig Carter

  __20060125___This posting was
submitted with HTML in it___


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


Re: Heads Up:ARImport Tool 6.3 and 7.0 issues

2006-10-30 Thread Michiel Beijen

Has patch 19 been pulled? I only see P11 - 18 available available for
download for version 6.3.

Kind regards,

Michiel

On 10/29/06, Michiel Beijen [EMAIL PROTECTED] wrote:

Michelle,

Why do CSV files not work on patch 19? I guess there must be a reason,
will try tomorrow myself.
Next question, can't you import your CSV file as filetype ASCII with
',' as a separator?

--
Michiel

On 10/27/06, Lucero, Michelle - IST contractor
[EMAIL PROTECTED] wrote:
 Hi, Folks:

 I've been working with tech support on an ARImport issue I reported back
 in May.  I originally reported the issue on AR Import 6.3 P12 while
 importing CSV files.

 The Define Fallback mapping does not work for core fields.  They've
 acknowledged that it should and have since bugged it as SW00244816.
 This behavior unfortunately occurs on:
 ARImport 6.3 P12, P13, P15, P17, P18; and 7.0, 7.0 P1.  They're pretty
 sure that it will still occur on whatever the latest 7.0 import tool is
 out there, because the fix hasn't been pushed yet.

 Bittersweet news:
 Fixed on a special support patch built after P18 was released.  However,
 this new support patch obliterates CSV files.

 My dilemma:
 The latest special import tool patch ARImport 6.3 P19 recognizes and
 uses fallback mapping.  But, is completely useless to perform an actual
 import of CSV files.
 ARImport 7.0 P1 successfully imported the same CSV file (properly), but
 still contains the fallback mapping bug.

 QUESTION:
 Does anyone remember the last 6.3 patch where Fallback mapping worked on
 core fields, especially when importing CSV files?

 Signed,
 So frustrated, that I had to manually add values to several rows of the
 file and then import it with 7.0 P1.

 Admin Tool 6.3 P19
 ARImport6.3 P19
 WinXP Pro

 ARS 6.3 P11 server


 ESM Mission: To provide the most accurate, timely, and actionable
 information to our customers
 so that they can effectively support the Mary Kay IST environment.

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




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


Re: MS/SQL - does 1=0 filter push action table scans

2006-10-30 Thread Michiel Beijen

David,

there have been lots of discussions about this in the past. the
outcome was that even Oracle does not perform a table scan on this.
For more info please search the archives.
If you would like to find out how MS SQL2000 does this you could use
the SQL Profiler tool which should be installed on the server or at
least at the DBA's workstation.

MORE IMPORTANT:  there is no real need for the use of 1=0. If you want
a push fields action to always create requests, you should leave the
field under Push Field If empty, and select If No Requests Match:
Create New Request.  This would always create a new request.

--
Michiel

On 10/28/06, David Chan [EMAIL PROTECTED] wrote:

Hi all

I am trying to confirm...

On MS/SQL database, does 1=0 qualification in filter push action cause
table scan.

I know oracle does... just confirming if SQL 2000 does

thanks... dave

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



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


Integration with CA Clarity

2006-10-30 Thread James Van Sickle
Fellow ARSList Members

   My company is looking to integrate our Remedy system with CA's Clarity 
application.  Based on what I have read from Clarity's Integration Guide, 
it appears that using Web Services would be the best method.  I am curious 
if anyone else has successfully integrated these two applications, and if 
this is the track taken in doing so.  I seem to remember another list 
member posting a similar topic about this a few months ago, but I cannot 
find any references to the matter in the list archives.  I would greatly 
appreciate any information or advice anyone can provide on linking these 
two apps.  Thank you for your time regarding this question.

James Van Sickle

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


Remedy Consultant need at Northern CA

2006-10-30 Thread Atul Bhardwaj
Hi Folks,

I am here again to give and get help. 

We have Need for a BMC Remedy Consultant with Bearing Point at Northern CA 
Bay Area for a 4-6 months assignment. Find the job description below for 
your ready reference and let me know if you would be interested for this 
role.

Title: BMC Remedy Consultant
Location: Northern CA Bay Area
Duration: 4-6 months
Start date is or/about Nov 13

Principle duties/essential functions:
• Provide technical leadership, installation and configuration of 
the following BMC tools: 
• Hands-on development and implementation of  BMC Remedy ITSM 7.0 
(Helpdesk, Change, SLM) 
• Hands-on development and implementation of BMC CMDB 2.0 
• Solaris 9, 10 Experience 
• Oracle 9iR2, Oracle 10gR2 
• Support workflow/process definition in ITIL areas 
• Assist our clients in assessing IT operational maturity and 
identifying targets for process/technology improvement 
• Support the definition of technology requirements 
• Organize and document findings of studies and prepare 
recommendations for implementation of new processes and procedures 
• Have experience with ITSM 7.0 and not just AR 7.0

Requirements: 
• MUST be located in Northern CA Bay Area (Customer location - Santa 
Clara) 
• Must have 3-7 years of experience in BMC Remedy 6.0  7.0 products 
including product design, configuration and integration with 3rd party 
tools
• Must have experience with development of BMC Remedy in Solaris 
environment
• Experience with installation and configuration of AR Server group 
• Prefer 1-3 years of IT Infrastructure Library (ITIL) certification 
with practical design and implementation experience a plus 
• Project Management Skills preferred 
• BS or BA Degree in IT, Engineering or Business preferred. 


Atul Bhardwaj | Manager Recruiting | Mastech Inc. |
Direct: 412-567-3773 | Toll-free: 866-411-3088 Ext. 2151 | Fax: 412-291-
3059 |
Email: [EMAIL PROTECTED] | Web: www.mastech.com | 
1000 Commerce Drive, Suite 500 | Pittsburgh, PA 15275 |

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


Tool to fix drop downs when a new field is added.

2006-10-30 Thread Dan Caissie
Ok I heard there is a tool to fix my problem.
I have been asked to add a new Priority field to it's drop down list.
This will push the values down one spoton all prior tickets.

I did hear there is a tool that will repair this issue.
Thanks,
ARServer 6.03
SQL 2000 SP4

Dan Caissie

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


Re: Problem with Push Fields in a Table Loop (RESOLVED)

2006-10-30 Thread Alex Bredariol
**
Thank you all!I solved my problem appending '! in the end of the filter's name. Then it works because with that, actions are executed in the desired order, because normally, without '!, push fields actions are delayed into a later phase and executed as a bulk after the Set Fields actions.
AlexOn 10/26/06, Alex Bredariol [EMAIL PROTECTED] wrote:
A filter A calls a Filter Guide B looping a table. This Filter Guide B contains a filter that should execute a push fields in another form.But there's a problem: it always push the same data. It's not a mistake with the Table I'm looping, because I tested using set fields and  displayed messages with the value and both work. 
Does someone know what may be happening?ThanksAlex Grilo


__20060125___This posting was submitted with HTML in it___


DSO Mapping

2006-10-30 Thread Fabien Tetreault
Hi !
list we are in the process of setting up a group servers environment with 
resonnate load balancer.
Everything went fine until we try to get the dso working.

Here our setup:

Server A remedyserv
Server B remedysrvb

Both in server group Name ECC-Remedy

They both have the alias remedyprd6 this because the underlying database 
is a copy from the actual production server.

They are both connected to a resonnate load balancer that used the the 
follwing name remedyprd6t and a VIP.

When we do the mapping,, from what i think i know, i need to map it 
trought the Load balancer server name and IP.

I have check the following:

No password on both side for access (Target and Source)
The from any server option is check
the  name from server group is there
ETc Etc

What could it be ?, does the Alias from both server need to be the same as 
the Name of the Virtual Name of the load balancer ?

Ar.conf setting for RPC etc.

i did create private rpc for DSOP and configure it accordingly.

The error we get is :

Action Request System(R)  Distributed Server   Version 6.03.00 patch 018
Remedy, a BMC Software company.  
Copyright (c) 1995 - 2005 BMC Software, Inc.  
All rights reserved.

AR System Server is not currently available -- will retry connection 
(ARDSNOTE 3004)

Cannot establish a network connection to the AR System server (ARERR 90)

AR System Distributed Server terminated -- fatal error encountered 
(ARDSNOTE 3001)

 (ARNOTE 0)
   Server (pid:27539) died with 65280.

Any help would be appriciated

Fabien tetreault


 

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


Suggestions Anyone?

2006-10-30 Thread Valerie Balloon
I'm looking for any suggestions on how to cleanly pull/push data realtime 
from one AR System to another without the use of EIE or utilizing the API. 
One server is v6.3 and the other 7.0.  Our Tier 1 helpdesk uses a 
customized 6.3 Helpdesk application while our Tier 2 Helpdesk will be using 
the 7.0 ITSM suite.Note: We do not have a programmer to build the API 
interface nor can we afford 30K for EIE. 

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


Re: Suggestions Anyone?

2006-10-30 Thread Michael Worts
**

How about using Web Services? All of
your code is contained within Remedy and it is up to you how simple or
complex you want to make it.

Mike.






Valerie Balloon [EMAIL PROTECTED]

Sent by: Action Request System
discussion list(ARSList) arslist@ARSLIST.ORG
30/10/2006 12:31



Please respond to
arslist@ARSLIST.ORG





To
arslist@ARSLIST.ORG


cc



Subject
Suggestions Anyone?








I'm looking for any suggestions on how to cleanly
pull/push data realtime 
from one AR System to another without the use of EIE or utilizing the API.

One server is v6.3 and the other 7.0. Our Tier 1 helpdesk uses a

customized 6.3 Helpdesk application while our Tier 2 Helpdesk will be using

the 7.0 ITSM suite.Note: We do not have a programmer to build the API 
interface nor can we afford 30K for EIE. 

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


__20060125___This posting was submitted with HTML in it___

SV: CMDB Question

2006-10-30 Thread Rasmus Kielstrup
**








Hello,



In the Computer System
class, there is a field Primary Capability, in this you can find
options like SANSwicth, SANHub etc.



/RK











Fra: Action Request
System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
Sendt: 24. oktober 2006 17:09
Til: arslist@ARSLIST.ORG
Emne: CMDB Question







I was approached about placement of information related to a
storage area network and where to put information about the device into the
CMDB. Is anyone working with these devices and how did you identify them
in the CMDB and which class did you use?











Thank you.











James McKenzie





L-3 GSI














__20060125___This posting was submitted with HTML in it___
__20060125___This posting was submitted with HTML in it___

Re: Client Application SSO (U)

2006-10-30 Thread Heider, Stephen
Dylan,

The Remedy SSO interface requires additional configuration and
programming on mid tier.   From what I have read (here and elsewhere)
and conversations I've had this is not trivial.  Two mid tier-specific
products I reviewed cost $15K - $20K for SSO, plus annual support. 

The SSO interface in mid tier is not an out-of-the-box implementation -
although it should be. If you have a quick and easy solution for mid
tier SSO, please let us know how you got it to work and your
environment.

My mid tier environment:
ARS 6.3
Windows Server 2003
IIS 6
ServletExec 5.0

Regarding SSO for the Windows User Tool, you can set it to cache your
Remedy password. In many organizations this is considered a security
risk that is too high.  I have previously researched developing an SSO
solution for WUT.  It's on hold for now as there are other projects I
need to work on. I plan to get back to the SSO for WUT project in a few
months.

Stephen


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dylan Thomas
Sent: Thursday, October 26, 2006 11:45 AM
To: arslist@ARSLIST.ORG
Subject: Re: Client Application SSO (U)

Stephen, I'm just curious why you couldn't use the Remedy SSO
implementation? That's what we're using here and no probs so far.

I'm also confused about the User tool SSO. If you uncheck the prompt for
password box, it'll auto log you in? Are you talking about making it so
you can login to any workstation on the network, open the User tool and
it will auto log you in? Now that would be cool :)


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

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


Re: Newb needs API help...couple of questions

2006-10-30 Thread Heider, Stephen
Marc,

Just a quick comment:

Regarding You first real API call (ARGetListSchema), or a call to
ARVerifyUser, will actually test out that the server/user/password is
fine.,  in my login routine I attempt to generate a GUID immediately
after login.   If it works then I know the login was successful.  I only
use the generate GUID because it's quick and only one line of code (.Net
API).

HTH

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dan Hardy
Sent: Saturday, October 28, 2006 2:11 PM
To: arslist@ARSLIST.ORG
Subject: FW: Newb needs API help...couple of questions

 
If you are expecting ARInitialization to fail because of a bad server
name, or user/password - it won't.  ARInitialization simply setus up
some client side state, and in general won't fail.  It doesn't actually
connect to the server.
 
You first real API call (ARGetListSchema), or a call to ARVerifyUser,
will actually test out that the server/user/password is fine.
 
First of all, you should not use the C API without RTL.
(http://www.sourceforge.net/projects/rtl).  It will reduce your C code
below by 80 or 90% and make it much more bulletproof.  Everything you've
done would be about 8 lines of code (see below).  To see why and another
comparison, go to http://rtl.sourceforge.net/doc.  With rtl, you won't
have to worry about freeing status lists, allocating memory, testing
errors after every call, doing expensive lookups with for loops, etc.  I
cringe looking at how verbose and error prone API programs are without
it.  Oh yes, I almost forgot - it's free and open source.
 
Here is what your code would loook like using RTL (taken straight from
the docs).  This does everything for you (memory management, error
handling, etc.).  All those checks for error codes and calls to
FreeARStatusList go away for starters (whew).
 
 try {
   Server server(localhost, Demo, );
   NameList names;
   server.getListSchema(names);
   NameList::iterator iter = names.begin();
   for (; iter != names.end(); iter++) {
   cout  (*iter).getName().c_str()  \n;
   }
 } catch (Exception err) {
   cerr  err.toString().c_str();
 }
Regards,
Dan Hardy
Co-Founder and Chief Architect
Pathworks Software
http://www/pathworkssoftware.com/
Get Work Done Right, Every Time.
 




From: Action Request System discussion list(ARSList) on behalf of Marc
Nations
Sent: Fri 10/27/2006 9:47 PM
To: arslist@ARSLIST.ORG
Subject: Newb needs API help...couple of questions


** Hello all,

For starters, I'm trying to integrate the Remedy API into a Python
application. That is my ultimate goal. So if anyone has any experience
with that or knows where some sample code is, I'd appreciate it. I'm 
going to use ctypes to make the dll calls and am building the
structures.

However, I've hit a wall so far with Python so I decided to run some
example code in C and follow the process. I don't understand what is 
happening here, so I'm hoping someone could explain it to me. I am
running the example given in the Remedy API documentation (with a
couple of small modifications):

Let me start off by saying that the code works, however almost 
seemingly by accident. The problem is when I step through it using
Visual Studio, it doesn't respond like I thought it would. Here's the
problem:

Right now I have the application set up to fail at the initialization 
stage. So at Step A (marked below) I should see a failure after the
ARInitialization call is made. However that is not the case. Instead I
get back a response of '0', and it does not fall into the exception
loop. 

Instead it moves on and attempts the ARGetListSchema call. At Step B is
when the error for the initialization is actually recognized. So then
it falls in the exception loop, prints out the error that was supposed 
to be printed in ARInit loop, and finishes execution.

This also means that the status list is not being freed like is
supposed to happen during the FreeARStatusList proc. It's still there
when the next function is called. 

So in the end the application does work, but it's not failing at the
correct place. So until I understand how this is supposed to properly
work, there's no way I'll be able to get it interfaced over to another 
language. Does anyone know what either I or it is doing wrong?

Thanks,
Marc


// ARS.cpp : Defines the entry point for the console application.
//

#include stdafx.h

#include  ar.h
#include arextern.h
#include arfree.h

void printStatusList(ARStatusList *theList)
{
   unsigned int i;
   for (i=0; i theList - numItems; i++)
   {
   if (theList - statusList[i].appendedText == NULL ||
   theList - statusList[i].appendedText == '\0')
   printf(%s, theList -
statusList[i].messageText); 
   else
   printf(%s:%s, theList -
statusList[i].messageText,
   theList - 

Re: Auto guest user

2006-10-30 Thread Shellman, David
Maxim,

What we use here is the person's network login for both Guest and tech
logins.  These are tied to data in our Active Directory.  With Guest
login, we can tie the login to the individual's name, phone number,
email address, etc.  It also provides the ability to search for past
tickets opened for that person's network id.  In our link's to lookup
tickets or create a new one, we encode the login in the url string.

Not sure why you would want to generate a random login.  This makes the
linkage described above impossible.  Maybe you can explain to us a
little bit better why you would want a random login.

Dave

Date:Fri, 27 Oct 2006 11:35:39 +0400
From:=?koi8-r?B?98XSws/Xycsg7cHL08nN?= [EMAIL PROTECTED]
Subject: Re: Auto guest user

David,

I must create auto login script in home page of my site with random
login name and for the people in User form additional page for entering
true login and password. I think it will be helpful.

---
With best
wishes,

Maxim Verbovik
Software solutions division
INLINE Technologies, www.in-line.ru

/Tel: +7 (495) 721 3505 (=C4=CF=C2./ext 393)
/Fax:+7 (495) 131 4529
/Mob:+7 (926) 351 6738, +7 (927) 200 2520

Dave Shellman

Phone:  (717) 810-3687
Fax:(717) 810-2124
email:  [EMAIL PROTECTED]

tyco/Electronics
A tyco International LTD Company
MS 161-043
PO Box 3608
Harrisburg, PA 17105-3607

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


SupportWeb Enhancements

2006-10-30 Thread Mike Parker

Good Morning List:

Has anyone found on Supportweb where the Enhancement Requests (along with 
the Community Downloads) have been moved to?


I've been searching for the past 10 minutes and can't find where BMC hid it.

Thanks!

_
Get today's hot entertainment gossip  
http://movies.msn.com/movies/hotgossip?icid=T002MSN03A07001


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


Re: 7.0.1 Email

2006-10-30 Thread Michiel Beijen

Track down the filter that is used to send the message to the user.
In the Notify action, tick the box Add Shortcut.

--
Michiel

On 10/26/06, Pam Hollis [EMAIL PROTECTED] wrote:

Where do you go to enable and disable the option to add link to the
incident that is opened within the email that is sent out to the user.

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



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


Re: Integration with CA Clarity

2006-10-30 Thread Kelly Deaver
**
Hi James,
Clarity only has one method to integrate with it, that is via XML using the Clarity XOG (XML Open Gateway- developed jointly by Niku and Xinify) so yes you are on the right track. Xinify has integrated Niku/Clarity with Remedy since before the days of web services in Remedy. Back then we had to jump through hoops to export the data, convert to XML then import. Muchmore straight forwardthese days :). 

Are you wanting to import time sheet data to associate with Clarity projects, integrate projects to change requests? We've done both. I'd be happy to speak with you about it. -Kelly DeaverDirector, ITSM PracticeXinify[EMAIL PROTECTED]

 Original Message Subject: Integration with CA ClarityFrom: James Van Sickle [EMAIL PROTECTED]Date: Wed, October 25, 2006 12:37 pmTo: arslist@ARSLIST.ORGFellow ARSList Members My company is looking to integrate our Remedy system with CA's Clarity application. Based on what I have read from Clarity's Integration Guide, it appears that using Web Services would be the best method. I am curious if anyone else has successfully integrated these two applications, and if this is the track taken in doing so. I seem to remember another list member posting a similar topic about this a few months ago, but I cannot find any references to the matter in the list archives. I would greatly appreciate any information or advice anyone can provide on linking these two apps. Thank you for your time regarding this question.James Van Sickle___UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" 
__20060125___This posting was submitted with HTML in it___


Re: Direct SQL - How can I use a $TIMESTAMP$ reference? - Solved

2006-10-30 Thread Leigh Gruber
**








Everyone,



I think that Thomas method would
work just fine, but I received a solution off line that is very clean and seems
to work perfectly without the extra field.



Mark W. sent me the following solution.
I dont know the etiquette of the list when someone sends a solution
off-line, but the results are just as I expected.



SELECT count(*) FROM Issue

WHERE Customer_Abbreviation =
'$Customer_Abbreviation$' AND

Create_Date 
(DATEDIFF(s,'1/1/1970','$TIMESTAMP$') - ($Threshold Days$ * 24 * 60 * 60))



Many thanks,

Leigh









From: Action Request
System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Bean
Sent: Friday, October 27, 2006
5:25 PM
To: arslist@ARSLIST.ORG
Subject: Re: Direct SQL - How can
I use a $TIMESTAMP$ reference?







Hello Leigh,





Try setting the $TIMESTAMP$ value to hidden, display-only integer field, then use the integer
field name reference in place of the $TIMESTAMP$ keyword reference in your SQL
statement.











--Thomas













- Original Message - 





From: Leigh
Gruber 





Newsgroups:
gmane.comp.crm.arsystem.general





Sent: Friday, October
27, 2006 14:55





Subject: Direct SQL - How
can I use a $TIMESTAMP$ reference?









** 

Hi Everyone,



I met a number of you at the 2005 RUG and am sorry that I
didnt get to this years gathering. My husband and friends
DID have successful English Channel relay swim
over and back so I missed the event for a good reason. Hope to see you next
year!



Now my question. I am writing new workflow and have a
direct SQL statement in an escalation which will execute occasionally.
Unfortunately I get an error due to the conversion of the $TIMESTAMP$ value
into a nicely formatted date/time stamp. 



How can I get the current time to come out in epoch time so
it will play nicely with the create date and the calculated
offset?



This is the direct SQL statement.

SELECT count(*) FROM Issue 
WHERE Customer_Abbreviation = '$Customer_Abbreviation$' AND 
Create_Date  ($TIMESTAMP$ - ($Threshold Days$ * 24 * 60 * 60))

And this is what I see when the SQL
log is turned on for the server.
SELECT count(*) FROM Issue 
WHERE Customer_Abbreviation = 'zSENTEL' AND 
Create_Date  (10/27/2006 3:33:51 PM - (28 * 24 * 60 * 60))

^

(*** ERROR *** Line 1: Incorrect syntax near '3'. (SQL Server 170))



Were running SQL Server 2000 on Windows 2003 OS.



Many thanks,

Leigh



The
information contained in this message may be privileged and/or confidential. If
you are not the intended recipient, or responsible for delivering this message
to the intended recipient, any review, forwarding, dissemination, distribution
or copying of this communication or any attachment(s) is strictly prohibited.
If you have received this message in error, please so notify the sender
immediately, and delete it and all attachments from your computer and network.



__20060125___This posting was submitted with HTML
in it___ 








__20060125___This posting was submitted with HTML in it___
__20060125___This posting was submitted with HTML in it___

Upgrading and switching platforms at the same time

2006-10-30 Thread Dwayne Martin
Hello everyone,

We are upgrading from ARS 6.3 to 7, and at the same time
switching from Unix HPUX-11 to a new Red Hat Linux machine. 
We are also upgrading from Oracle 9 to Oracle 10.  We have a
mostly-customized ARS system, but have installed the Asset
Tracking module.

Two approaches:
1. Install Oracle on the new machine.  Install ARS on the new
machine.  Export all the form and workflow definitions and
form data from the old system and import it into the new.

2.Copy the present Oracle database from the old machine to the
new.  Rename the database and upgrade it.  Install ARS.

The second approach sounds easier.  Any pitfalls that we
should be aware of?

Dwayne Martin
Computing Support
James Madison University

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


Re: EIE 7.0 Issues (hanging + API Error)

2006-10-30 Thread Kelly Deaver
**
Hi Cindy,
The setting to 1 minute in the eie.cfg is too frequent. By default it is set to check every 5 minutes. This setting determines how often EIE creates new threads and deletes old ones. I think it is probably falling over from all the created/delete. If you set it to 1440, it will check once a day. It is recommended that you set it to at least 60 minutes. While you are testing, it is simpler to just stop and start the EIE service when you want instant gratification.-Kelly DeaverDirector, ITSM PracticeXinify[EMAIL PROTECTED]

 Original Message Subject: EIE 7.0 Issues ("hanging" + API Error)From: Cindy Sapochetti [EMAIL PROTECTED]Date: Fri, October 27, 2006 9:57 amTo: arslist@ARSLIST.ORGListers - Having issues with EIE 7.0 "hanging" after working for about a week. I have several active data exchanges which worked until 2 days ago, then just stopped. Have debugging on, and after restarting EIE service, eiemain.dbg would just show "Starting to look for changes to data exchange definitions" and then nothing more. Since this is a dev server, eie.cfg has a ConfigInterval set to 1 - but it never "continues" to check each minute, it just seems to hang.I rebooted the box this a.m. (Windows 2003 server), and got the following in eiemain.dbg (see below). Two things to note: API error and the fact that after 9:43, it never cycled again to look for changes.I tried looking up the API error, no luck. Does anyone have any ideas? I'm stuck!Thanks,CindyEIEMain.dbg log:[08:58:36,10/27/06] - Starting to look for changes to data exchange definitions[09:41:16,10/27/06] - Starting to look for changes to data exchange definitions[09:41:17,10/27/06] - CreateDataExchangelist: AR API returned error during ARGetListEntry, Error = 2[09:41:20,10/27/06] - Failed to retrieve any active data exchange defined on AR System: scrmdy07[09:41:20,10/27/06] - Starting threads to manage event driven requests[09:41:20,10/27/06] - Immediate async thread started.[09:41:20,10/27/06] - Event Request cleanup thread started.[09:41:20,10/27/06] - Waiting for 1 minutes to look for changes to data exchange definitions.[09:42:33,10/27/06] - Starting to look for changes to data exchange definitions[09:42:40,10/27/06] - CreateDataExchangelist: AR API returned error during ARGetListEntry, Error = 2[09:42:40,10/27/06] - Failed to retrieve any active data exchange defined on AR System: scrmdy07[09:42:40,10/27/06] - Waiting for 1 minutes to look for changes to data exchange definitions.[09:43:57,10/27/06] - Starting to look for changes to data exchange definitions___UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" 
__20060125___This posting was submitted with HTML in it___


Re: Direct SQL - How can I use a $TIMESTAMP$ reference?

2006-10-30 Thread Jim Ashton
Leigh,

Try the following statement (I've substituted a SQL-based calculation of 
epoch time for the $TIMESTAMP$ value):

SELECT count(*) FROM Issue 
WHERE  Customer_Abbreviation = '$Customer_Abbreviation$' AND 
Create_Date  (ABS(DATEDIFF(ss,GetUTCDate(),'1970-01-01')) - ($Threshold 
Days$ * 24 * 60 * 60))

ABS(DATEDIFF(ss,GetUTCDate(),'1970-01-01')) represents the current date and 
time in epoch time.

I'm assuming $Threshold Days$ is already an integer value; if not, you may 
need to include a CAST function to convert it from a varchar to an int.

Cheers,
Jim.

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


OpSet in Web Service

2006-10-30 Thread Joe Grande
Hello Listers,

I'm trying to figure out where to specify the request ID I am trying to
update via an OpSet in Web Services. The Remedy documentation is not very
clear on this. Here is the XML:
SOAP-ENV:Envelope
xmlns:SOAP-ENV=http://schemas.xmlsoap.org/soap/envelope/;
xmlns:SOAP-ENC=http://schemas.xmlsoap.org/soap/encoding/;
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;
xmlns:xsd=http://www.w3.org/2001/XMLSchema;
 SOAP-ENV:Header
  m:AuthenticationInfo xmlns:m=urn:SiebelInputStaging
   m:userNameWebService/m:userName
   m:passwordremadmin/m:password
  /m:AuthenticationInfo
 /SOAP-ENV:Header
 SOAP-ENV:Body
  m:OpSet xmlns:m=urn:SiebelInputStaging
   Full_NameJoe Grande/Full_Name
  /m:OpSet
 /SOAP-ENV:Body
/SOAP-ENV:Envelope

Any help would be greatly appreciated!!

Thank you,
Joe Grande

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


Re: OpSet in Web Service

2006-10-30 Thread McKenzie, James J C-E LCMC HQISEC/L3
Title: RE: OpSet in Web Service
**





Joe:


See below.


James Mckenzie





-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Grande
Sent: Monday, October 30, 2006 7:35 AM
To: arslist@ARSLIST.ORG
Subject: OpSet in Web Service


Hello Listers,


I'm trying to figure out where to specify the request ID I am trying to update via an OpSet in Web Services. The Remedy documentation is not very clear on this. Here is the XML:

SOAP-ENV:Envelope
xmlns:SOAP-ENV=http://schemas.xmlsoap.org/soap/envelope/
xmlns:SOAP-ENC=http://schemas.xmlsoap.org/soap/encoding/
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance
xmlns:xsd=http://www.w3.org/2001/XMLSchema
SOAP-ENV:Header
 m:AuthenticationInfo xmlns:m=urn:SiebelInputStaging
 m:userNameWebService/m:userName
 m:passwordremadmin/m:password
 /m:AuthenticationInfo
/SOAP-ENV:Header
SOAP-ENV:Body
 m:OpSet xmlns:m=urn:SiebelInputStaging


Should go right here.



 Full_NameJoe Grande/Full_Name
 /m:OpSet
/SOAP-ENV:Body
/SOAP-ENV:Envelope


Any help would be greatly appreciated!!


Thank you,
Joe Grande


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




__20060125___This posting was submitted with HTML in it___

Re: Upgrading and switching platforms at the same time

2006-10-30 Thread McKenzie, James J C-E LCMC HQISEC/L3
Title: RE: Upgrading and switching platforms at the same time
**





Dwayne:


Go:


1. Install Oracle 9i on your new machine. Import database. Upgrade to 10g. This will insure that the database's metadata is upgraded to the new version.

James McKenzie
L-3 GSI



-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Dwayne Martin
Sent: Monday, October 30, 2006 7:03 AM
To: arslist@ARSLIST.ORG
Subject: Upgrading and switching platforms at the same time


Hello everyone,


We are upgrading from ARS 6.3 to 7, and at the same time switching from Unix HPUX-11 to a new Red Hat Linux machine. 
We are also upgrading from Oracle 9 to Oracle 10. We have a mostly-customized ARS system, but have installed the Asset Tracking module.

Two approaches:
1. Install Oracle on the new machine. Install ARS on the new machine. Export all the form and workflow definitions and form data from the old system and import it into the new.

2.Copy the present Oracle database from the old machine to the new. Rename the database and upgrade it. Install ARS.


The second approach sounds easier. Any pitfalls that we should be aware of?


Dwayne Martin
Computing Support
James Madison University


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




__20060125___This posting was submitted with HTML in it___

Re: Heads Up:ARImport Tool 6.3 and 7.0 issues

2006-10-30 Thread Lucero, Michelle - IST contractor
Hi, Michiel:

Thanks for responding.

Patch 19 was a special support patch.  Since I've reported this back to
tech support.  They've informed me that they are still working out the
kinks of this patch.  It is not available for general release.

Actually, it didn't matter how I manipulated that file. I could not
successfully import it with patch 19.  I could however, import the same
file with patch 17 AND 7.0 Patch 1.

I just wanted to know the last patch # where I can successfully import
CSV files (which is all but this one) AND use fallback mapping against
core fields. The issue about fallback mapping was originally reported in
patch 12 and has appeared in all subsequent releases of the Admin/Import
tool.

I might download patch 5 just to see if it worked there.

Michelle

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Michiel Beijen
Sent: Monday, October 30, 2006 5:44 AM
To: arslist@ARSLIST.ORG
Subject: Re: Heads Up:ARImport Tool 6.3 and 7.0 issues

Has patch 19 been pulled? I only see P11 - 18 available available for
download for version 6.3.

Kind regards,

Michiel

On 10/29/06, Michiel Beijen [EMAIL PROTECTED] wrote:
 Michelle,

 Why do CSV files not work on patch 19? I guess there must be a reason,
 will try tomorrow myself.
 Next question, can't you import your CSV file as filetype ASCII with
 ',' as a separator?

 --
 Michiel

 On 10/27/06, Lucero, Michelle - IST contractor
 [EMAIL PROTECTED] wrote:
  Hi, Folks:
 
  I've been working with tech support on an ARImport issue I reported
back
  in May.  I originally reported the issue on AR Import 6.3 P12 while
  importing CSV files.
 
  The Define Fallback mapping does not work for core fields.  They've
  acknowledged that it should and have since bugged it as SW00244816.
  This behavior unfortunately occurs on:
  ARImport 6.3 P12, P13, P15, P17, P18; and 7.0, 7.0 P1.  They're
pretty
  sure that it will still occur on whatever the latest 7.0 import tool
is
  out there, because the fix hasn't been pushed yet.
 
  Bittersweet news:
  Fixed on a special support patch built after P18 was released.
However,
  this new support patch obliterates CSV files.
 
  My dilemma:
  The latest special import tool patch ARImport 6.3 P19 recognizes and
  uses fallback mapping.  But, is completely useless to perform an
actual
  import of CSV files.
  ARImport 7.0 P1 successfully imported the same CSV file (properly),
but
  still contains the fallback mapping bug.
 
  QUESTION:
  Does anyone remember the last 6.3 patch where Fallback mapping
worked on
  core fields, especially when importing CSV files?
 
  Signed,
  So frustrated, that I had to manually add values to several rows of
the
  file and then import it with 7.0 P1.
 
  Admin Tool 6.3 P19
  ARImport6.3 P19
  WinXP Pro
 
  ARS 6.3 P11 server
 
 
  ESM Mission: To provide the most accurate, timely, and actionable
  information to our customers
  so that they can effectively support the Mary Kay IST environment.
 
 

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



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

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


Re: Remedy Consultant need at Northern CA

2006-10-30 Thread Herb Partlow
Must have 3-7 years of experience in BMC Remedy 6.0  7.0 products 
including product design, configuration and integration with 3rd party

tools
3-7 years exp with 7.0. who's requirements is this?

Herb

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Atul Bhardwaj
Sent: Thursday, October 26, 2006 2:08 PM
To: arslist@ARSLIST.ORG
Subject: Remedy Consultant need at Northern CA

Hi Folks,

I am here again to give and get help. 

We have Need for a BMC Remedy Consultant with Bearing Point at Northern
CA 
Bay Area for a 4-6 months assignment. Find the job description below for

your ready reference and let me know if you would be interested for this

role.

Title: BMC Remedy Consultant
Location: Northern CA Bay Area
Duration: 4-6 months
Start date is or/about Nov 13

Principle duties/essential functions:
. Provide technical leadership, installation and configuration of 
the following BMC tools: 
. Hands-on development and implementation of  BMC Remedy ITSM 7.0 
(Helpdesk, Change, SLM) 
. Hands-on development and implementation of BMC CMDB 2.0 
. Solaris 9, 10 Experience 
. Oracle 9iR2, Oracle 10gR2 
. Support workflow/process definition in ITIL areas 
. Assist our clients in assessing IT operational maturity and 
identifying targets for process/technology improvement 
. Support the definition of technology requirements 
. Organize and document findings of studies and prepare 
recommendations for implementation of new processes and procedures 
. Have experience with ITSM 7.0 and not just AR 7.0

Requirements: 
. MUST be located in Northern CA Bay Area (Customer location - Santa 
Clara) 
. Must have 3-7 years of experience in BMC Remedy 6.0  7.0 products 
including product design, configuration and integration with 3rd party 
tools
. Must have experience with development of BMC Remedy in Solaris 
environment
. Experience with installation and configuration of AR Server group 
. Prefer 1-3 years of IT Infrastructure Library (ITIL) certification 
with practical design and implementation experience a plus 
. Project Management Skills preferred 
. BS or BA Degree in IT, Engineering or Business preferred. 


Atul Bhardwaj | Manager Recruiting | Mastech Inc. |
Direct: 412-567-3773 | Toll-free: 866-411-3088 Ext. 2151 | Fax: 412-291-
3059 |
Email: [EMAIL PROTECTED] | Web: www.mastech.com | 
1000 Commerce Drive, Suite 500 | Pittsburgh, PA 15275 |


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

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


Re: SupportWeb Enhancements

2006-10-30 Thread Lucero, Michelle - IST contractor
Hi, Mike:

You're right.  It's not there.

I've been informed by tech support that, it appears that our
customers will no longer be able to submit such RFE on the web anymore.


paraphrased
Although, I've been told by the BMC Product Line Manager that it was
unintentional, they can't say that there is a plan to reimplement this
functionality. Since, BMC was already considering having all enhancement
requests flow through Customer Support.  
/paraphrased

Submit your enhancement requests as you would your other incidents
through the support site.  Just indicate somewhere that you would like
this to be an enhancement request.  Tech support will submit the
enhancement request in their defect/RFE tracking system on your behalf.

Thanks,
Michelle
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mike Parker
Sent: Monday, October 30, 2006 8:03 AM
To: arslist@ARSLIST.ORG
Subject: SupportWeb Enhancements

Good Morning List:

Has anyone found on Supportweb where the Enhancement Requests (along
with 
the Community Downloads) have been moved to?

I've been searching for the past 10 minutes and can't find where BMC hid
it.

Thanks!

_
Get today's hot entertainment gossip  
http://movies.msn.com/movies/hotgossip?icid=T002MSN03A07001


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

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


Re: OpSet in Web Service

2006-10-30 Thread Joe Grande
James,

Thank you for the response, that's where I thought it should go. However,
when I post there I receive the following error:
MessageType: 2
MessageNum: 8962
MessageText: Unexpected element encountered in the input XML document
AppendedText: lt;Full_Namegt;/faultstring

Thank you,
Joe

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


Looking for Job in Sweden

2006-10-30 Thread Mathieu Pitre
Hi all,

My familly and I are currently looking into moving in Sweden this summer. 
We live in Canada and we want to see a different culture. I was wondering 
if any of you would know where I could search on the web to find some work 
in Sweden. A contact would be a good thing to. I can read/talk/write in 
French and English. Any important information on Sweden would also be 
appreciated.

Mathieu Pitre
Business Systems Analyst
[EMAIL PROTECTED]

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


RESOLVED: QUESTION: MENU - NOT LIKE

2006-10-30 Thread Tyrone Dee
Title: RE: ARERR 405 exporting Display Only form to .def file
**



Thanks to everyone for their help - here it 
is:

NOT(('Group List' LIKE "1;%") OR ('Group List' LIKE 
"%;1;%") OR ('Group List' LIKE "% 1;%"))




From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of CONDREA, 
DanielSent: October 27, 2006 11:49 PMTo: 
arslist@ARSLIST.ORGSubject: Re: QUESTION: MENU - NOT 
LIKE
** 

Hi All,

When a user is defined "the user" belongs to one or more 
groups. Usually this functionality is implemented using a normalized 
representation. Remedy's adds to the user's definition every group ID. The 
result of this operation is a string. For example 
";1;2;3;4;".

Finding what users belongs to a group it is a string 
operation not an SQL operation.

In an older version of the ARS, the developer had to be 
very careful. There was an extra space.

Daniel


From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thomas 
BeanSent: 27 October 2006 18:20To: 
arslist@ARSLIST.ORGSubject: Re: QUESTION: MENU - NOT 
LIKE
** 



Try this qualification:

NOT ('Group List' LIKE "1;%" OR 'Group List' LIKE "% 1;%" OR 
'Group List' LIKE "%;1;%")

--Thomas


  - Original Message - 
  From: 
  Tyrone 
  Dee 
  Newsgroups: 
  gmane.comp.crm.arsystem.general
  Sent: Friday, October 27, 2006 
08:16
  Subject: QUESTION: MENU - NOT LIKE
  ** 
  
  I 
  have a Menu that shows all Users from the USER Form - no 
  problem.
  
  I 
  would like to restrict all users who are Administrators from the pull down 
  menu. I tried:
  
  NOT 
  'Group List' LIKE "%" + "1" + "%"
  
  However, this is not working as there are other groups with "1" in the 
  Group Number.
  
  Any 
  assistance would be greatly appreciated.
  
  THANKS!__20060125___This 
  posting was submitted with HTML in it___ 
__20060125___This posting was submitted with 
HTML in it___ __20060125___This posting was submitted with 
HTML in it___ 
__20060125___This posting was submitted with HTML in it___


Re: Remedy Consultant need at Northern CA

2006-10-30 Thread McKenzie, James J C-E LCMC HQISEC/L3
Title: RE: Remedy Consultant need at Northern CA
**





Herb:


I doubt you can get seven years of experience with 6.x. I think that was back in the 4.x days. I have that level of experience.

James McKenzie
L-3 GSI



-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Herb Partlow
Sent: Monday, October 30, 2006 8:00 AM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy Consultant need at Northern CA


Must have 3-7 years of experience in BMC Remedy 6.0  7.0 products 
including product design, configuration and integration with 3rd party


tools
3-7 years exp with 7.0. who's requirements is this?


Herb


-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Atul Bhardwaj
Sent: Thursday, October 26, 2006 2:08 PM
To: arslist@ARSLIST.ORG
Subject: Remedy Consultant need at Northern CA


Hi Folks,


I am here again to give and get help. 


We have Need for a BMC Remedy Consultant with Bearing Point at Northern CA Bay Area for a 4-6 months assignment. Find the job description below for

your ready reference and let me know if you would be interested for this


role.


Title: BMC Remedy Consultant
Location: Northern CA Bay Area
Duration: 4-6 months
Start date is or/about Nov 13


Principle duties/essential functions:
. Provide technical leadership, installation and configuration of the following BMC tools: 
. Hands-on development and implementation of BMC Remedy ITSM 7.0 (Helpdesk, Change, SLM) . Hands-on development and implementation of BMC CMDB 2.0 . Solaris 9, 10 Experience . Oracle 9iR2, Oracle 10gR2 . Support workflow/process definition in ITIL areas . Assist our clients in assessing IT operational maturity and identifying targets for process/technology improvement . Support the definition of technology requirements . Organize and document findings of studies and prepare recommendations for implementation of new processes and procedures . Have experience with ITSM 7.0 and not just AR 7.0

Requirements: 
. MUST be located in Northern CA Bay Area (Customer location - Santa
Clara)
. Must have 3-7 years of experience in BMC Remedy 6.0  7.0 products including product design, configuration and integration with 3rd party tools . Must have experience with development of BMC Remedy in Solaris environment . Experience with installation and configuration of AR Server group . Prefer 1-3 years of IT Infrastructure Library (ITIL) certification with practical design and implementation experience a plus . Project Management Skills preferred . BS or BA Degree in IT, Engineering or Business preferred. 


Atul Bhardwaj | Manager Recruiting | Mastech Inc. |
Direct: 412-567-3773 | Toll-free: 866-411-3088 Ext. 2151 | Fax: 412-291-
3059 |
Email: [EMAIL PROTECTED] | Web: www.mastech.com | 1000 Commerce Drive, Suite 500 | Pittsburgh, PA 15275 |



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


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




__20060125___This posting was submitted with HTML in it___

Re: OpSet in Web Service

2006-10-30 Thread McKenzie, James J C-E LCMC HQISEC/L3
Title: RE: OpSet in Web Service
**





Joe:


Sorry that this did not work for you. From what I understand of the construction of the XML Set request, that is where the information should go. Maybe someone else has the correct answer.

James McKenzie 


-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Grande
Sent: Monday, October 30, 2006 8:06 AM
To: arslist@ARSLIST.ORG
Subject: Re: OpSet in Web Service


James,


Thank you for the response, that's where I thought it should go. However, when I post there I receive the following error:

MessageType: 2
MessageNum: 8962
MessageText: Unexpected element encountered in the input XML document
AppendedText: lt;Full_Namegt;/faultstring


Thank you,
Joe


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




__20060125___This posting was submitted with HTML in it___

Re: Converting Remedy Datetime for SQL Query

2006-10-30 Thread Webster, Basil
This is what I have and I've never had a problem.

dateadd(second, Create Date Field + 7200, '1 Jan 1970'

Make sure that the number of seconds you add or subtract is correct according 
to your timezone.
 

Regards,
 
Basil Webster
 
Remedy Developer
Siemens Business Services (Pty) Ltd 
* E-Mail:  [EMAIL PROTECTED]
( Tel:  +27 11 652 7523
Ê Fax: +27 11 652-7501 
) Mobile: +27 82 452 9389
 
-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of James Van Sickle
Sent: 25 October 2006 19:52
To: arslist@ARSLIST.ORG
Subject: Converting Remedy Datetime for SQL Query

Fellow ARSList Members

   I need to convert the Epoch time format that Remedy stores its datetime 
data into a more readable format for an SQL query.  According to an older 
KB article I have from Remedy, Remedy recommends using DATEADD(day, 
h.Cinsert field id-2440588, '01/01/1970') to format what they store as 
1161641694 into 10/23/2006 6:14:54 PM.  The article also claims I have to 
add h.Cinsert field id IS NOT NULL and h.Cinsert field id  2440590 
to the where statement of the query.

The following is the SQL query I am running based on the KB article.

select  h.C1 as Case ID,
 DATEADD(day, h.C3-2440588, '01/01/1970') as Arrival Time,
from  T87 h
where h.C1 = 'HD367848'
and h.C3 IS NOT NULL 
and h.C3  2440590

   When I use this query, my Microsoft SQL Server 2000 returns Adding a 
value to a 'datetime' column caused overflow.  Does anyone have the 
correct string to use in a SQL query to convert the returned date/time 
values into readable date/time format.  I would appreciate any assistance 
you can give on this, and thank you for you time regarding this question.

James Van Sickle

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

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


Re: Not allow users to close a form

2006-10-30 Thread Clary, Bill
There are several reasons for this need.

1. Users who think they know everything and always close the Support
Console, then call me when they can not figure out how to do something
that was on the console.

2. I run several interval active links on the console to do checks and
to run a news ticker, this will stop when the User closes the form. Also
the news ticker is suppose to be required viewing by the manager for
sending emergency news to the users.

3. Some users never close their clients, so I always get calls after a
change is made to the system from users that did not get the change
(also their client cache files mess up more then users that close their
clients). So I have used interval active links on the console to close
the users client every day at 11pm. Now all my users always pick up
the changes and the amount of corrupt client cache files has gone way
down.

Bill Clary
Remedy Developer, Tech Solutions
FTS | Customer Support Center



CONDREA, Daniel [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
...
Why there is a need for this functionality as log as an end user can log
out?



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Clary, Bill
Sent: 27 October 2006 19:50
To: arslist@ARSLIST.ORG
Subject: Not allow users to close a form


** 

All;

 

  I have a support console form that opens for everyone on login. I need
to stop users from closing this form without using an error message.
If I use an error message they also get the message when closing the
client and that is very confusing to them.

 

  I am running AR 6.3 on UNIX and Oracle.

 

Bill Clary

Remedy Developer, Tech Solutions

FTS | Customer Support Center

 

__20060125___This posting was submitted with HTML in
it___ 


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

--

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


Re: Heads Up:ARImport Tool 6.3 and 7.0 issues

2006-10-30 Thread Michiel Beijen

Michelle,

Why do CSV files not work on patch 19? I guess there must be a reason,
will try tomorrow myself.
Next question, can't you import your CSV file as filetype ASCII with
',' as a separator?

--
Michiel

On 10/27/06, Lucero, Michelle - IST contractor
[EMAIL PROTECTED] wrote:

Hi, Folks:

I've been working with tech support on an ARImport issue I reported back
in May.  I originally reported the issue on AR Import 6.3 P12 while
importing CSV files.

The Define Fallback mapping does not work for core fields.  They've
acknowledged that it should and have since bugged it as SW00244816.
This behavior unfortunately occurs on:
ARImport 6.3 P12, P13, P15, P17, P18; and 7.0, 7.0 P1.  They're pretty
sure that it will still occur on whatever the latest 7.0 import tool is
out there, because the fix hasn't been pushed yet.

Bittersweet news:
Fixed on a special support patch built after P18 was released.  However,
this new support patch obliterates CSV files.

My dilemma:
The latest special import tool patch ARImport 6.3 P19 recognizes and
uses fallback mapping.  But, is completely useless to perform an actual
import of CSV files.
ARImport 7.0 P1 successfully imported the same CSV file (properly), but
still contains the fallback mapping bug.

QUESTION:
Does anyone remember the last 6.3 patch where Fallback mapping worked on
core fields, especially when importing CSV files?

Signed,
So frustrated, that I had to manually add values to several rows of the
file and then import it with 7.0 P1.

Admin Tool 6.3 P19
ARImport6.3 P19
WinXP Pro

ARS 6.3 P11 server


ESM Mission: To provide the most accurate, timely, and actionable
information to our customers
so that they can effectively support the Mary Kay IST environment.

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



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


Cold Fusion and Web Services 6.3

2006-10-30 Thread Michael McAdams
Hi all,

We are trying to use Cold Fusion to consume a Remedy web service and are 
getting the following error:


Could not generate stub objects for web service invocation


Anyone have any ideas or encountered this before and have a few things 
that we can try.

Thanks.

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


Re: How to pass parameters to jsp file?

2006-10-30 Thread Grooms, Frederick W
**



jsp:forward 
page="/servlet/ViewFormServlet" jsp:param name="server" 
value="devhc"/ 
jsp:param 
name="mode" value="Search"/ jsp:param name="form" 
value="WAL:BULK:RequestForm"/ 

jsp:param name ="username" 
value="username"/ jsp:param name ="pwd" value="password"/ 

jsp:param name ="eid" 
value="Your Request ID"/ 
/jsp:forward 

Look in Chapter 9 of the 6.3 Developing 
Applications:Basic guide (~ page 447) for a list of 
parameters.

Fred



From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of George 
TsaiSent: Friday, October 27, 2006 1:11 PMTo: 
arslist@ARSLIST.ORGSubject: How to pass parameters to jsp 
file?

** We use a jsp file allowing user to 
login to Remedy Mid-Tier with a generic user name. The question is that if 
we like to open up a specific request within the form, how can we pass the 
parameters through url to the jsp file. We do not like to show the 
username/password/formname on the url. Example jsp file: jsp:forward page="/servlet/ViewFormServlet" jsp:param 
name="server" value="de vhc"/ 
jsp:param name="mode" value="Search"/ jsp:param name="form" 
value="WAL :BULK:RequestForm"/ 
jsp:param name ="username" value="username"/ jsp:param na 
me ="pwd" value="password"/ 
/jsp:forward Thanks.George TsaiIT Systems Architecture - Process 
Automation InitiativesWalgreens Co.847-914-5210


__20060125___This posting was submitted with HTML in it___


Re: multiple attachments in pool on mid tier?

2006-10-30 Thread Anderson, Douglas W.
Title: Re: multiple attachments in pool on mid tier?
**






Hi Rocky, Michelle, Craig, et al.,


It's not a permissions issue and yes, we're using the built-in Add, Delete,  Display buttons.


The browser interface doesn't enable selecting a row in the pool. One can click wherever one wants and nothing is highlighted inside the pool. The first click on the pool causes the buttons to appear.

The result of the first invocation of the Add button is an attachment displayed in the top row of the pool. A second invocation of the Add button results in a dialog asking whether one wants to replace the first attachment with the newly specified one.

It's not my application, so I won't carry the investigation any further at this point. I'll be interested to see whether the issue evaporates when we (eventually) upgrade to 6.3 or 7.x ARS.

Thanks for your ideas!

Doug



original message:

Date: Fri, 27 Oct 2006 13:53:34 -0600

From: Carter, Craig J Civ ARPC/DPD [EMAIL PROTECTED]

Subject: Re: multiple attachments in pool on mid tier?


We've never seen this problem and we use them all over the place in our

midtier. We're no longer on 6.0.1 either.



This may seem obvious but are you logging into the midtier with the same

permissions and have you verified the permissions for each attachment row in

the web view? Perhaps those extra rows were added later and the permissions

were not updated. Another obvious thing to check is whether you are

clicking on the actual row in the attachment pool when adding the

attachments on the web? We don't use buttons on the web (just use the built

in ones you get once you select a row) and you have to click each specific

row or the attachment will keep going into the first row (or currently

selected row).




Are you using a button with locally-built workflow or are you using the

built-in buttons?





CRAIG J. CARTER




__20060125___This posting was submitted with HTML in it___

ITSM 6/CMDB 2.0 integration

2006-10-30 Thread Rick Cook
**
BMC said a month or soagothat they planned to issue a white paper and a def file to make the integration between these two happen in a more planned, supportable,and stable manner than having to figure it out ourselves. The soft due date they gave was late October, which is now. Does anyone have an update on when that will actually be released?
-- Rick CookCook Enterprises253-278-4112 
__20060125___This posting was submitted with HTML in it___


Re: ITSM 6/CMDB 2.0 integration

2006-10-30 Thread Mike Parker

Hi Rick:

I've heard rumblings that CMDB 2.1 will be released in November sometime.  
Maybe BMC will roll it up in that release?




From: Rick Cook [EMAIL PROTECTED]
Reply-To: arslist@ARSLIST.ORG
To: arslist@ARSLIST.ORG
Subject: ITSM 6/CMDB 2.0 integration
Date: Mon, 30 Oct 2006 08:09:05 -0800

BMC said a month or so ago that they planned to issue a white paper and a
def file to make the integration between these two happen in a more 
planned,

supportable, and stable manner than having to figure it out ourselves.  The
soft due date they gave was late October, which is now.  Does anyone have 
an

update on when that will actually be released?

--
Rick Cook
Cook Enterprises
253-278-4112

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


_
Stay in touch with old friends and meet new ones with Windows Live Spaces 
http://clk.atdmt.com/MSN/go/msnnkwsp007001msn/direct/01/?href=http://spaces.live.com/spacesapi.aspx?wx_action=createwx_url=/friends.aspxmkt=en-us


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


Re: Time Change - Processes Running Twice

2006-10-30 Thread Grooms, Frederick W
One other thing to bring up ...  Since the US is changing the date for
Daylight Saving Time as of 2007 there are OS patches to install.

The switch to DST will occur on March 11 instead of April 1st.  The
switch back will occur on November 4th instead of October 28th. 

Sun has a patch available now: 
http://sunsolve.sun.com/search/document.do?assetkey=1-26-102178-1

Microsoft will not have their patch available until December. 
http://www.microsoft.com/windows/timezone/dst2007.mspx

The Minimum Java versions to calculate times correctly are: 
http://java.sun.com/developer/technicalArticles/Intl/USDST/ 
JDK 6 Project (beta) 
J2SE 5.0 Update 6 or later 
J2SE 1.4.2_11 or later 
J2SE 1.3.1_18 or later 

From what I have been told Oracle uses Java and Remedy uses the OS for
determining DST changes.

Fred

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


Re: Client Application SSO (U)

2006-10-30 Thread Axton

This is probably true for some browsers.  Seems that some do not store
https info in browser history, though I do not know of a standard that
would prevent this and I would not expect all browsers to act the
same.  All in all, it's not a secure method to pass credentials that
should otherwise be private.

Axtno Grams


On 10/30/06, Michiel Beijen [EMAIL PROTECTED] wrote:

Axton,

This will also be true for https right? With https the TRAFFIC is
encrypted but the URLs are not. This makes sense because you first
have to request a site (by issuing an URL) before the secure
connection can  be set up.

Kind regards,

Michiel

On 10/26/06, Axton [EMAIL PROTECTED] wrote:
 The only other things I can think of:
 If not using https
 - browser will store url in history (username/pass)
 - proxy server will store url (username/pass)
 - username/password are visible on network in plain text

 Axton Grams

 On 10/26/06, Heider, Stephen [EMAIL PROTECTED] wrote:
  If you can find a way to bypass the security with this model please post
  a message. I can then patch it.  Thanks.
 
  Stephen
 
  -Original Message-
  From: Action Request System discussion list(ARSList)
  [mailto:[EMAIL PROTECTED] On Behalf Of Axton
  Sent: Thursday, October 26, 2006 3:09 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: Client Application SSO (U)
 
  This is good.  I didn't know whether you were relying on the web
  server/domain to authenticate the user or if you were using some vb
  command to read the username.
 
  Axton Grams
 
  On 10/26/06, Heider, Stephen [EMAIL PROTECTED] wrote:
   Axton,
  
   Great questions.  I tested each of these scenarios.  I created a local
 
   account with a username of an existing employee.  After some testing I
 
   then added this user to the local Admin group and also added the
   employee's domain\username to the local Admin group.
  
   Local accounts do not have access to connect to our remedy web server,
 
   only authenticated domain users.  With each attempt the Windows login
   prompt was presented.  When I provided my network credentials the web
   app knew that I was using my login name and not the local user.
  
   I then attempted to Run As IE as the local account user (logged into
   Windows as me) and entered the URL in the address field.  The web app
   knew it was me.  I then logged into Windows as the local account and
   ran IE with Run As me. Same result.
  
   The web app checks the domain when logging in.  All our employees are
   in the same domain, so checking here is easy.  For companies that have
 
   multiple domains additional checks would need to be done.  You could
   also track a lot of details regarding the SSO web app session, such as
 
   IP address, computer name, etc.  If someone successfully spoofed a
   login [to get into Remedy only] in the logging file/table tracks could
 
   lead back to the culprit.
  
   The only thing I didn't try was to rename my computer to the name of
   the domain.  This may present the web app with domain\username,
   however the Remedy web server still wouldn't allow access without a
   valid domain account login.
  
   To spoof the web app I think that either the browser or .Net libraries
 
   would need to be hacked.  Or, if they somehow intercepted calls made
   to HttpContext.Current.User.Identity.Name from the web app and
   interjected a new value when sending data back to the web server it
  might work.
   Can't say for sure, but if someone can hack into this they may also be
 
   able to hack into LDAP authentication as well.
  
  
   Stephen
  
  
  
   -Original Message-
   From: Action Request System discussion list(ARSList)
   [mailto:[EMAIL PROTECTED] On Behalf Of Axton
   Sent: Thursday, October 26, 2006 11:52 AM
   To: arslist@ARSLIST.ORG
   Subject: Re: Client Application SSO (U)
  
   So what happens if I create a local account on my desktop that has the
 
   same login name as some other domain account, then proceed to access
   your SSO enabled web interfaces?
  
   Or even better, create the local account, then run iexplore.exe as
   that user?
  
   Axton Grams
  
   On 10/26/06, Heider, Stephen [EMAIL PROTECTED] wrote:
For inquiring minds... here is the SSO solution I implemented here.
   
Background:
Over the last couple months I have been researching SSO solutions
for Remedy, initially only for Mid Tier (6.3, 7.0).  There are
several good ones that will do the job.  The costs prevented us
purchasing ($15K for a Mid Tier-only solution up to $100K+ for a
solution for all
  
web and Windows applications including non-Remedy apps).
   
A few weeks after the decision was made not to purchase I began
reading more and more posts about implementing SSO.  I gleaned some
ideas from Listers and determined that I was going to find a
  solution.
  
It didn't take long to see that this would work.  It may not be
applicable in certain companies/organizations (ie. top 

Re: Time Change - Processes Running Twice

2006-10-30 Thread Easter, David
 
 Remedy uses the OS for determining DST changes

This is true for the server, but there is one library used by the
Mid-Tier and API that needs to be updated.  BMC Remedy updated that
library in the AR System 7.0.01 release.  The AR System 6.03 release
will be patched as soon before March 2007 as possible (most likely by
January).  Released prior to 6.03 are affected, but are not scheduled to
be patched as per the BMC support policy. (i.e. 6.0.1 is a C-2
release)

BMC as a company is working on a comprehensive statement about this
issue across all BMC products that should be released soon.

Thanks,

-David J. Easter
Sr. Product Manager, Service Management Business Unit
BMC Software, Inc.


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Monday, October 30, 2006 8:31 AM
To: arslist@ARSLIST.ORG
Subject: Re: Time Change - Processes Running Twice

One other thing to bring up ...  Since the US is changing the date for
Daylight Saving Time as of 2007 there are OS patches to install.

The switch to DST will occur on March 11 instead of April 1st.  The
switch back will occur on November 4th instead of October 28th. 

Sun has a patch available now: 
http://sunsolve.sun.com/search/document.do?assetkey=1-26-102178-1

Microsoft will not have their patch available until December. 
http://www.microsoft.com/windows/timezone/dst2007.mspx

The Minimum Java versions to calculate times correctly are: 
http://java.sun.com/developer/technicalArticles/Intl/USDST/
JDK 6 Project (beta)
J2SE 5.0 Update 6 or later
J2SE 1.4.2_11 or later
J2SE 1.3.1_18 or later 

From what I have been told Oracle uses Java and Remedy uses the OS for
determining DST changes.

Fred


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

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


Push Field Problem

2006-10-30 Thread Sokol, Brian
I am trying to create some simple time auditing based upon when forms
are opened. I am running an AL with a push fields action to a form. I
set the Push Field If to:
( 'Submitter' = $USER$) AND ( 'Sign In Date' = $DATE$)
And set If No Requests match to Create a New Request
And
If Any Request Match to Take No Action.

Every time I open the form that triggers this AL it creates a new record
even though there are multiple records with my account in the Submitter
field and today's date in the Sign In Date field.

What am I doing wrong?

Brian Sokol 
Manager, Desktop Services 
Scholastic Inc. 
212-343-6494 
[EMAIL PROTECTED] 
http://www.scholastic.com 

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


Re: Push Field Problem

2006-10-30 Thread Thomas Bean

Brian,
Is the 'Sign In Date' field a date/time field or a date field?  If it is 
date/time (even if it is only set to display as date-only), then your 
qualification would only prevent multiple requests from being created for 
the current user for given second of the day, *not* for the given day.


If this is the cause, you should be able to correct this without converting 
to the date field type by using this modified qualification:


( 'Submitter' = $USER$) AND ( 'Sign In Date' = $DATE$)

HTH,

--Thomas

- Original Message - 
From: Sokol, Brian [EMAIL PROTECTED]

Newsgroups: gmane.comp.crm.arsystem.general
Sent: Monday, October 30, 2006 11:11
Subject: Push Field Problem


I am trying to create some simple time auditing based upon when forms
are opened. I am running an AL with a push fields action to a form. I
set the Push Field If to:
( 'Submitter' = $USER$) AND ( 'Sign In Date' = $DATE$)
And set If No Requests match to Create a New Request
And
If Any Request Match to Take No Action.

Every time I open the form that triggers this AL it creates a new record
even though there are multiple records with my account in the Submitter
field and today's date in the Sign In Date field.

What am I doing wrong?

Brian Sokol
Manager, Desktop Services
Scholastic Inc.
212-343-6494
[EMAIL PROTECTED]
http://www.scholastic.com

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


Re: Push Field Problem

2006-10-30 Thread Sokol, Brian
It is a Date field. They strange thing is I just noticed that this works
ok from the web. If I use aruser it creates a record every time. Either
I am misinformed about something or this is a bug. 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Thomas Bean
Sent: Monday, October 30, 2006 12:33 PM
To: arslist@ARSLIST.ORG
Subject: Re: Push Field Problem

Brian,
Is the 'Sign In Date' field a date/time field or a date field?  If it is

date/time (even if it is only set to display as date-only), then your 
qualification would only prevent multiple requests from being created
for 
the current user for given second of the day, *not* for the given day.

If this is the cause, you should be able to correct this without
converting 
to the date field type by using this modified qualification:

( 'Submitter' = $USER$) AND ( 'Sign In Date' = $DATE$)

HTH,

--Thomas

- Original Message - 
From: Sokol, Brian [EMAIL PROTECTED]
Newsgroups: gmane.comp.crm.arsystem.general
Sent: Monday, October 30, 2006 11:11
Subject: Push Field Problem


I am trying to create some simple time auditing based upon when forms
are opened. I am running an AL with a push fields action to a form. I
set the Push Field If to:
( 'Submitter' = $USER$) AND ( 'Sign In Date' = $DATE$)
And set If No Requests match to Create a New Request
And
If Any Request Match to Take No Action.

Every time I open the form that triggers this AL it creates a new record
even though there are multiple records with my account in the Submitter
field and today's date in the Sign In Date field.

What am I doing wrong?

Brian Sokol
Manager, Desktop Services
Scholastic Inc.
212-343-6494
[EMAIL PROTECTED]
http://www.scholastic.com


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

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


Re: Push Field Problem

2006-10-30 Thread Sokol, Brian
I just noticed this AL works as I thought it should from the web. If I
use the User tool it creates a new record every time. I am on ver 7.0
for aruser, server and MidTier. 

Also noticed that if I switch the Push Field If statement to:
( 'Submitter' = $USER$) AND ( $DATE$ = 'Sign In Date') 

I get an arerror 313 Data types are not appropriate for relational
operation

-Original Message-
From: Sokol, Brian 
Sent: Monday, October 30, 2006 12:12 PM
To: arslist@ARSLIST.ORG
Subject: Push Field Problem

I am trying to create some simple time auditing based upon when forms
are opened. I am running an AL with a push fields action to a form. I
set the Push Field If to:
( 'Submitter' = $USER$) AND ( 'Sign In Date' = $DATE$)
And set If No Requests match to Create a New Request
And
If Any Request Match to Take No Action.

Every time I open the form that triggers this AL it creates a new record
even though there are multiple records with my account in the Submitter
field and today's date in the Sign In Date field.

What am I doing wrong?

Brian Sokol 
Manager, Desktop Services 
Scholastic Inc. 
212-343-6494 
[EMAIL PROTECTED] 
http://www.scholastic.com 

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


Re: Push Field Problem

2006-10-30 Thread Thomas Bean
There is a bug related to this, I can't remember if it was corrected in a 
5.1.2 patch or in version 6.x possibly...


Essentially, the $DATE$ keyword is resolving to Unix epoch seconds instead 
of the correct value for date fields (# of days since Jan 1, 4713 B.C.).  As 
I recall, the bug only affected using $DATE$ in a workflow qualification 
with a date field (the $DATE$ keyword should work correctly as a set fields 
value for a date field).


I believe the workaround I used was to set a hidden display-only date field 
to $DATE$, then use this field in place of the $DATE$ keyword in the 
qualification.  For example:


Set Fields:
'zTmpDate' = $DATE$

Subsequent 'Push Field If':
( 'Submitter' = $USER$) AND ( 'Sign In Date' = 'zTmpDate')

HTH,

Thomas

- Original Message - 
From: Sokol, Brian [EMAIL PROTECTED]

Newsgroups: gmane.comp.crm.arsystem.general
Sent: Monday, October 30, 2006 11:43
Subject: Re: Push Field Problem


It is a Date field. They strange thing is I just noticed that this works
ok from the web. If I use aruser it creates a record every time. Either
I am misinformed about something or this is a bug.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Thomas Bean
Sent: Monday, October 30, 2006 12:33 PM
To: arslist@ARSLIST.ORG
Subject: Re: Push Field Problem

Brian,
Is the 'Sign In Date' field a date/time field or a date field?  If it is

date/time (even if it is only set to display as date-only), then your
qualification would only prevent multiple requests from being created
for
the current user for given second of the day, *not* for the given day.

If this is the cause, you should be able to correct this without
converting
to the date field type by using this modified qualification:

( 'Submitter' = $USER$) AND ( 'Sign In Date' = $DATE$)

HTH,

--Thomas

- Original Message - 
From: Sokol, Brian [EMAIL PROTECTED]

Newsgroups: gmane.comp.crm.arsystem.general
Sent: Monday, October 30, 2006 11:11
Subject: Push Field Problem


I am trying to create some simple time auditing based upon when forms
are opened. I am running an AL with a push fields action to a form. I
set the Push Field If to:
( 'Submitter' = $USER$) AND ( 'Sign In Date' = $DATE$)
And set If No Requests match to Create a New Request
And
If Any Request Match to Take No Action.

Every time I open the form that triggers this AL it creates a new record
even though there are multiple records with my account in the Submitter
field and today's date in the Sign In Date field.

What am I doing wrong?

Brian Sokol
Manager, Desktop Services
Scholastic Inc.
212-343-6494
[EMAIL PROTECTED]
http://www.scholastic.com


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

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


Disable MidTier Help?

2006-10-30 Thread Dylan
Is there a way to disable the help button on the menu bar for the forms 
like HelpDesk through the mid tier? Or at least control it's action?
I've built an outside help system to display the data we want to show the 
user but I haven't been able to figure out how to disable that default help 
button.

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


Re: Disable MidTier Help?

2006-10-30 Thread Dylan Thomas
Argh, posted too fast. It's 6.3 server on IIS. In case there's a difference 
heh.

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


Re: Converting Remedy Datetime for SQL Query

2006-10-30 Thread Carlos Ungil

Hello,

I don't think you can use them (Oracle 9i is required and I understand
you're using MS SQL), but for the record here are a couple of
functions I wrote recently to convert remedy timestamps to/from a more
reasonable format.

Regards,

Carlos Ungil

create function timestamp_to_date
   (remdate in number)
   return char
is
   stuff char(20);
begin
   select to_char((timestamp '1970-01-01 00:00:00 GMT'+
numtodsinterval(remdate, 'SECOND')) at time zone
'Europe/Zurich','dd/mm/ hh24:mi:ss')
   into stuff
   from dual;
   return(stuff);
end timestamp_to_date;

create function date_to_timestamp
   (txtdate in varchar2)
   return number
is
   stuff number;
begin
   select extract(second from
(from_tz(to_timestamp(txtdate,'dd/mm/ hh24:mi:ss'),
'Europe/Zurich') - (timestamp '1970-01-01 00:00:00 GMT')))
+60*extract(minute from (from_tz(to_timestamp(txtdate,'dd/mm/
hh24:mi:ss'), 'Europe/Zurich') - (timestamp '1970-01-01 00:00:00
GMT')))
+60*60*extract(hour from (from_tz(to_timestamp(txtdate,'dd/mm/
hh24:mi:ss'), 'Europe/Zurich') - (timestamp '1970-01-01 00:00:00
GMT')))
+24*60*60*extract(day from (from_tz(to_timestamp(txtdate,'dd/mm/
hh24:mi:ss'), 'Europe/Zurich') - (timestamp '1970-01-01 00:00:00
GMT')))
   into stuff
   from dual;
   return(stuff);
end date_to_timestamp;

On 10/25/06, James Van Sickle [EMAIL PROTECTED] wrote:

Fellow ARSList Members

   I need to convert the Epoch time format that Remedy stores its datetime
data into a more readable format for an SQL query.  According to an older
KB article I have from Remedy, Remedy recommends using DATEADD(day,
h.Cinsert field id-2440588, '01/01/1970') to format what they store as
1161641694 into 10/23/2006 6:14:54 PM.  The article also claims I have to
add h.Cinsert field id IS NOT NULL and h.Cinsert field id  2440590
to the where statement of the query.

The following is the SQL query I am running based on the KB article.

select  h.C1 as Case ID,
 DATEADD(day, h.C3-2440588, '01/01/1970') as Arrival Time,
from  T87 h
where h.C1 = 'HD367848'
and h.C3 IS NOT NULL
and h.C3  2440590

   When I use this query, my Microsoft SQL Server 2000 returns Adding a
value to a 'datetime' column caused overflow.  Does anyone have the
correct string to use in a SQL query to convert the returned date/time
values into readable date/time format.  I would appreciate any assistance
you can give on this, and thank you for you time regarding this question.

James Van Sickle

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



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


Re: Disable MidTier Help?

2006-10-30 Thread Lucero, Michelle - IST contractor
Hi, Dylan:

If you are asking for either the Helpdesk form in the User Tool or in
the Mid-Tier.

To disable:
Open the form in the Admin Tool,
On the menu, click Form, select Current View/Properties
The View Properties window will open,
Click the Menu Access tab Uncheck Help.
Click OK.

You will have to do that per view that you would like to exclude the
Help icon from.

Note: It will be excluded on that view whether the form is opened from
the Remedy User Tool or Mid-Tier.

Hope that helps,
Michelle


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dylan
Sent: Monday, October 30, 2006 12:23 PM
To: arslist@ARSLIST.ORG
Subject: Disable MidTier Help?

Is there a way to disable the help button on the menu bar for the forms 
like HelpDesk through the mid tier? Or at least control it's action?
I've built an outside help system to display the data we want to show
the 
user but I haven't been able to figure out how to disable that default
help 
button.


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

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


Re: OpSet in Web Service

2006-10-30 Thread Jarl Grøneng

What does the WSDL look like?

-
Jarl

On 10/30/06, Joe Grande [EMAIL PROTECTED] wrote:

Hello Listers,

I'm trying to figure out where to specify the request ID I am trying to
update via an OpSet in Web Services. The Remedy documentation is not very
clear on this. Here is the XML:
SOAP-ENV:Envelope
xmlns:SOAP-ENV=http://schemas.xmlsoap.org/soap/envelope/;
xmlns:SOAP-ENC=http://schemas.xmlsoap.org/soap/encoding/;
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;
xmlns:xsd=http://www.w3.org/2001/XMLSchema;
 SOAP-ENV:Header
  m:AuthenticationInfo xmlns:m=urn:SiebelInputStaging
   m:userNameWebService/m:userName
   m:passwordremadmin/m:password
  /m:AuthenticationInfo
 /SOAP-ENV:Header
 SOAP-ENV:Body
  m:OpSet xmlns:m=urn:SiebelInputStaging
   Full_NameJoe Grande/Full_Name
  /m:OpSet
 /SOAP-ENV:Body
/SOAP-ENV:Envelope

Any help would be greatly appreciated!!

Thank you,
Joe Grande

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



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


Re: SupportWeb Enhancements

2006-10-30 Thread Jarl Grøneng

That was an elegant way to get around the RFE's already submitted.

--
Jarl

On 10/30/06, Lucero, Michelle - IST contractor
[EMAIL PROTECTED] wrote:

Hi, Mike:

You're right.  It's not there.

I've been informed by tech support that, it appears that our
customers will no longer be able to submit such RFE on the web anymore.


paraphrased
Although, I've been told by the BMC Product Line Manager that it was
unintentional, they can't say that there is a plan to reimplement this
functionality. Since, BMC was already considering having all enhancement
requests flow through Customer Support.
/paraphrased

Submit your enhancement requests as you would your other incidents
through the support site.  Just indicate somewhere that you would like
this to be an enhancement request.  Tech support will submit the
enhancement request in their defect/RFE tracking system on your behalf.

Thanks,
Michelle
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mike Parker
Sent: Monday, October 30, 2006 8:03 AM
To: arslist@ARSLIST.ORG
Subject: SupportWeb Enhancements

Good Morning List:

Has anyone found on Supportweb where the Enhancement Requests (along
with
the Community Downloads) have been moved to?

I've been searching for the past 10 minutes and can't find where BMC hid
it.

Thanks!

_
Get today's hot entertainment gossip
http://movies.msn.com/movies/hotgossip?icid=T002MSN03A07001


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

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



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


Re: Suggestions Anyone?

2006-10-30 Thread Jarl Grøneng

rrrChive may help you.

http://www.rrr.se/en/, look for rrrChive.

--
Jarl

On 10/30/06, Valerie Balloon [EMAIL PROTECTED] wrote:

I'm looking for any suggestions on how to cleanly pull/push data realtime
from one AR System to another without the use of EIE or utilizing the API.
One server is v6.3 and the other 7.0.  Our Tier 1 helpdesk uses a
customized 6.3 Helpdesk application while our Tier 2 Helpdesk will be using
the 7.0 ITSM suite.Note: We do not have a programmer to build the API
interface nor can we afford 30K for EIE.

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



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


Re: JOB: 9-month contract i Sweden

2006-10-30 Thread Mathieu Pitre
Hi,

My familly and I are currently looking into moving in Sweden this summer. 
We live in Canada and we want to see a different culture. I was wondering 
if you would know where I could search on the web to find some work 
in Sweden. A contact would be a good thing to. I can read/talk/write in 
French and English. Any important information on Sweden would also be 
appreciated.

Mathieu Pitre
Business Systems Analyst
[EMAIL PROTECTED]

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


RV: Question about arimporcmd command

2006-10-30 Thread Lourdes Ortiz Sada
Title: Mensaje
**



Hi

I have one question?

How can I used the arimporcmd command to 
mapping a file with one file especific, for example I need to add in the attach 
file a one document of word?

Do you have any suggestion?

Best Regards

Lourdes 
Ortiz SadaConsultor de Soluciones de Infraestructura y 
Soporte Aplicaciones
ATS - BMC 
Remedy
Quitze 
Tecnología
Oficina: (+52) 55 5241-2660SOPORTE QUITZE 7X24: 044 
5530-206524 

Por 
favor borre este email y notifíquenos inmediatamente si usted no es el 
destinatario previsto. Quitze no entra en contratos u obligaciones contractuales 
vía correo electrónico, a menos que esté convenido de otra manera por escrito 
entre las partes que están tratando.
__20060125___This posting was submitted with HTML in it___


Question: Email Notification Attachment Size Limitation

2006-10-30 Thread Tyrone Dee
Title: RE: ARERR 405 exporting Display Only form to .def file
**



I have 
a filter that sends out an email to the user with the attachment they 
added.

I was 
wondering if there are an known size limitations that Remedy can handle. I 
know that the Exchange Server can have limitations and our server is set to 9 
MB.

We are 
running Windows 2000, Remedy ARS 6.00.01 (patch 1394), SQL 
2000.

Thanks!
__20060125___This posting was submitted with HTML in it___


Re: Question: Email Notification Attachment Size Limitation

2006-10-30 Thread Rick Cook
**
In modern (32 bit) versions of Remedy, the only limitations are at the OS level. You would run into firewall/mail server limitations well before you hit the OS limit of around 2 GB.

Rick
On 10/30/06, Tyrone Dee [EMAIL PROTECTED] wrote:
** 

I have a filter that sends out an email to the user with the attachment they added.

I was wondering if there are an known size limitations that Remedy can handle. I know that the Exchange Server can have limitations and our server is set to 9 MB.


We are running Windows 2000, Remedy ARS 6.00.01 (patch 1394), SQL 2000.

Thanks!__20060125___This posting was submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___


Re: Disable MidTier Help?

2006-10-30 Thread Wixson Carolyn L PSNS
Thanks for the reply Michelle.  I neglected to mension one vital part,
though. (Funny how it doesn't make it always from the brain to the email.)

I really want the FORM help available to the mid-tier, just not the FIELD
help. It looks like it is all or none.

It is too bad that they disabled the feature of hiding fields where
necessary. 

I was hoping that someone had a workaround.

Carolyn

-Original Message-
From: Lucero, Michelle - IST contractor
[mailto:[EMAIL PROTECTED]
Sent: Monday, October 30, 2006 11:51
To: arslist@ARSLIST.ORG
Subject: Re: Disable MidTier Help?


Hi, Carolyn:

Here are two approaches.

1.  Create another view specifically for the Mid-Tier and simply disable
Help as mentioned below.
Or,
1.  Disable Help Mid-Tier menu access item.
2.  Create a Form Action field Help button.  
3.  Create an active link to Hide the button when $ CLIENT-TYPE$ = 9

Here is a note about field-level help in version 6.3
  
Note:  For field-level help, the Hide This Help Text in Web Views check
box at the bottom of the tab is ignored in version 6.3. Using previous
versions, you can select the check box if you do not want help text for
a field to appear in a form viewed on the web.

Hope this helps,
Michelle
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Wixson Carolyn L PSNS
Sent: Monday, October 30, 2006 1:22 PM
To: arslist@ARSLIST.ORG
Subject: Re: Disable MidTier Help?

Does anyone know if there a way to control the help contents when it is
shown to the Mid Tier? 
Right now in 6.3 it shows all form help and all field help. 
I would like to hide the field help from the Mid Tier users, but still
have
the field help for the Windows Client.

Carolyn


-Original Message-
From: Lucero, Michelle - IST contractor
[mailto:[EMAIL PROTECTED]
Sent: Monday, October 30, 2006 10:39
To: arslist@ARSLIST.ORG
Subject: Re: Disable MidTier Help?


Hi, Dylan:

If you are asking for either the Helpdesk form in the User Tool or in
the Mid-Tier.

To disable:
Open the form in the Admin Tool,
On the menu, click Form, select Current View/Properties
The View Properties window will open,
Click the Menu Access tab Uncheck Help.
Click OK.

You will have to do that per view that you would like to exclude the
Help icon from.

Note: It will be excluded on that view whether the form is opened from
the Remedy User Tool or Mid-Tier.

Hope that helps,
Michelle


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dylan
Sent: Monday, October 30, 2006 12:23 PM
To: arslist@ARSLIST.ORG
Subject: Disable MidTier Help?

Is there a way to disable the help button on the menu bar for the forms 
like HelpDesk through the mid tier? Or at least control it's action?
I've built an outside help system to display the data we want to show
the 
user but I haven't been able to figure out how to disable that default
help 
button.


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



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


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


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

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


Re: Upgrading and switching platforms at the same time

2006-10-30 Thread Rick Parry
**


Hello Dwayne,

I've made this same type of move just thismonth.Iagree with James do the database first then do the Remedy upgrade. Imoved froma Windows Platform to a SuSE Linuxplatform for both database and Remedy.

Take care,

Rick
 "McKenzie, James J C-E LCMC HQISEC/L3" [EMAIL PROTECTED] 10/30/2006 7:42 AM 
Dwayne: 
Go: 
1. Install Oracle 9i on your new machine. Import database. Upgrade to 10g. This will insure that the database's metadata is upgraded to the new version.
James McKenzie L-3 GSI  
-Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Dwayne Martin Sent: Monday, October 30, 2006 7:03 AM To: arslist@ARSLIST.ORG Subject: Upgrading and switching platforms at the same time 
Hello everyone, 
We are upgrading from ARS 6.3 to 7, and at the same time switching from Unix HPUX-11 to a new Red Hat Linux machine. We are also upgrading from Oracle 9 to Oracle 10. We have a mostly-customized ARS system, but have installed the Asset Tracking module.
Two approaches: 1. Install Oracle on the new machine. Install ARS on the new machine. Export all the form and workflow definitions and form data from the old system and import it into the new.
2.Copy the present Oracle database from the old machine to the new. Rename the database and upgrade it. Install ARS. 
The second approach sounds easier. Any pitfalls that we should be aware of? 
Dwayne Martin Computing Support James Madison University 
___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" __20060125___This posting was submitted with HTML in it___
__20060125___This posting was submitted with HTML in it___


ITSM 6 Licenses on ARS 7 Server

2006-10-30 Thread igor ivanov
Please help, what's wrong?

 Remedy Support Note: ...
There is also no license file upgrade needed if you are upgrading your AR 
System to version 7 but not upgrading your ITSM application.
You only need to upgrade your file if you are upgrading your ITSM 
application to version 7, or if you are upgrading your AR Server to version 
6.

Installed fresh ARS 6.03 and ITSM 6 (OOTB).
Upgraded it to ARS 7.0. Server not licensed - 3 Demo licenses.

I've exported ITSM 5.6 App. Licenses (the same Site:Contract ID and Host 
ID: *site*) from PROD (ARS 6.03) and imported them into ARS7/ITSM6 box.

I can see all of them (HD, CH, AS) in Admin Tool (Format 6.0, Help Desk 
User Fixed ...) but can not assign them to User.

There are no Help Desk licenses available.   (Number Available = 0, Number 
Currently Used = 0) (ARERR 41453)

The preceding message occurred during the execution of active link 
SHRCFG:PGP-ModPeopleInfo07Peop -- action 1. (ARNOTE 1101)

regards,

ii

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


Re: ITSM 6 Licenses on ARS 7 Server

2006-10-30 Thread Rick Cook
**
I think there's a KB for this onethat suggestsdeleting your multilicense.ar file, I think it's called. When you restart ARS, it should generate another.

Rick
On 10/30/06, igor ivanov [EMAIL PROTECTED] wrote:
Please help, what's wrong? Remedy Support Note: ...There is also no license file upgrade needed if you are upgrading your AR
System to version 7 but not upgrading your ITSM application.You only need to upgrade your file if you are upgrading your ITSMapplication to version 7, or if you are upgrading your AR Server to version6.
Installed fresh ARS 6.03 and ITSM 6 (OOTB).Upgraded it to ARS 7.0. Server not licensed - 3 Demo licenses.I've exported ITSM 5.6 App. Licenses (the same Site:Contract ID and HostID: *site*) from PROD (ARS 
6.03) and imported them into ARS7/ITSM6 box.I can see all of them (HD, CH, AS) in Admin Tool (Format 6.0, Help DeskUser Fixed ...) but can not assign them to User.There are no Help Desk licenses available. (Number Available = 0, Number
Currently Used = 0) (ARERR 41453)The preceding message occurred during the execution of active linkSHRCFG:PGP-ModPeopleInfo07Peop -- action 1. (ARNOTE 1101)regards,ii
__20060125___This posting was submitted with HTML in it___


Re: ITSM 6 Licenses on ARS 7 Server

2006-10-30 Thread McKenzie, James J C-E LCMC HQISEC/L3
**



Rick:

Is is not true that you cannot run an unlicensed server 
with the ITSM applications. This would cause the problem that 

Igorsees? 

James 
McKenzie
L-3 GSI



From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick 
CookSent: Monday, October 30, 2006 2:22 PMTo: 
arslist@ARSLIST.ORGSubject: Re: ITSM 6 Licenses on ARS 7 
Server
** 
I think there's a KB for this onethat suggestsdeleting your multilicense.ar file, I think it's 
called. When you restart ARS, it should generate another.

Rick
On 10/30/06, igor 
ivanov [EMAIL PROTECTED] 
wrote: 
Please 
  help, what's wrong?" Remedy Support Note: ...There is also no 
  license file upgrade needed if you are upgrading your AR System to version 
  7 but not upgrading your ITSM application.You only need to upgrade your 
  file if you are upgrading your ITSMapplication to version 7, or if you are 
  upgrading your AR Server to version6." Installed fresh ARS 6.03 
  and ITSM 6 (OOTB).Upgraded it to ARS 7.0. Server not licensed - 3 Demo 
  licenses.I've exported ITSM 5.6 App. Licenses (the same Site:"Contract 
  ID" and HostID: *site*) from PROD (ARS 6.03) and imported them into 
  ARS7/ITSM6 box.I can see all of them (HD, CH, AS) in Admin Tool 
  (Format 6.0, Help DeskUser Fixed ...) but can not assign them to 
  User.There are no Help Desk licenses available. (Number 
  Available = 0, Number Currently Used = 0) (ARERR 41453)The 
  preceding message occurred during the execution of active 
  linkSHRCFG:PGP-ModPeopleInfo07Peop -- action 1. (ARNOTE 
  1101)regards,ii__20060125___This 
posting was submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___


Re: ITSM 6 Licenses on ARS 7 Server

2006-10-30 Thread Rick Cook
**
I think you can run an unlicensed AR Server with ITSM apps up to, but not including, ITSM 6.0. After that, the CMDB is included, which requires multi-threading, which requires an AR Server license. I believe that the deployable applications that ITSM 7 uses also require an AR Server license.


But if Igor's got application licenses, odds are he has an AR Server license, too, so I'm not sure that's his problem.

Rick
On 10/30/06, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote:
** 

Rick:

Is is not true that you cannot run an unlicensed server with the ITSM applications. This would cause the problem that 
Igorsees? 

James McKenzie
L-3 GSI



From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG
] On Behalf Of Rick CookSent: Monday, October 30, 2006 2:22 PMTo: arslist@ARSLIST.ORG
Subject: Re: ITSM 6 Licenses on ARS 7 Server
** 

I think there's a KB for this onethat suggestsdeleting your multilicense.ar file, I think it's called. When you restart ARS, it should generate another.


Rick
On 10/30/06, igor ivanov [EMAIL PROTECTED]
 wrote: 
Please help, what's wrong? Remedy Support Note: ...There is also no license file upgrade needed if you are upgrading your AR 
System to version 7 but not upgrading your ITSM application.You only need to upgrade your file if you are upgrading your ITSMapplication to version 7, or if you are upgrading your AR Server to version6. 
Installed fresh ARS 6.03 and ITSM 6 (OOTB).Upgraded it to ARS 7.0. Server not licensed - 3 Demo licenses.I've exported ITSM 5.6 App. Licenses (the same Site:Contract ID and HostID: *site*) from PROD (ARS 
6.03) and imported them into ARS7/ITSM6 box.I can see all of them (HD, CH, AS) in Admin Tool (Format 6.0, Help DeskUser Fixed ...) but can not assign them to User.There are no Help Desk licenses available. (Number Available = 0, Number 
Currently Used = 0) (ARERR 41453)The preceding message occurred during the execution of active linkSHRCFG:PGP-ModPeopleInfo07Peop -- action 1. (ARNOTE 1101)regards,ii

__20060125___This posting was submitted with HTML in it___


Re: ITSM 6 Licenses on ARS 7 Server

2006-10-30 Thread Tony Worthington
In addition - I find that version 7 sometimes forgets about its licenses.

Example ... I just finished up an ITSM7 install (licensed), rebooted the 
server, and it came up as demo.  I could see all the licenses in the admin 
tool, but the server didn't recognize any of them.

Deleting the multilicense file and bouncing the server resolved the issue. 
 (On Windows it lives in c:\program files\common files\ar system\licenses)

-tony

-- 
Tony Worthington
[EMAIL PROTECTED]
262-703-5911



Rick Cook [EMAIL PROTECTED] 
Sent by: Action Request System discussion list(ARSList) 
arslist@ARSLIST.ORG
10/30/2006 03:22 PM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Re: ITSM 6 Licenses on ARS 7 Server






** 
I think there's a KB for this one that suggests deleting your 
multilicense.ar file, I think it's called.  When you restart ARS, it 
should generate another.
 
Rick
 
On 10/30/06, igor ivanov [EMAIL PROTECTED] wrote: 
Please help, what's wrong?

 Remedy Support Note: ...
There is also no license file upgrade needed if you are upgrading your AR 
System to version 7 but not upgrading your ITSM application.
You only need to upgrade your file if you are upgrading your ITSM
application to version 7, or if you are upgrading your AR Server to 
version
6. 

Installed fresh ARS 6.03 and ITSM 6 (OOTB).
Upgraded it to ARS 7.0. Server not licensed - 3 Demo licenses.

I've exported ITSM 5.6 App. Licenses (the same Site:Contract ID and Host
ID: *site*) from PROD (ARS 6.03) and imported them into ARS7/ITSM6 box.

I can see all of them (HD, CH, AS) in Admin Tool (Format 6.0, Help Desk
User Fixed ...) but can not assign them to User.

There are no Help Desk licenses available.   (Number Available = 0, Number 

Currently Used = 0) (ARERR 41453)

The preceding message occurred during the execution of active link
SHRCFG:PGP-ModPeopleInfo07Peop -- action 1. (ARNOTE 1101)

regards,

ii
__20060125___This posting was submitted with HTML in 
it___ 


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 to or from authorized Kohl's Associates 
at any time
without any further consent.

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


Capture Path of Document (File Chooser)

2006-10-30 Thread Rolf Cooke
How might I capture file location with User client?



Request is to implement a file chooser, such as with typical application 
using File  Open.  Instead of opening the document, simply want to 
capture the location at the which document was found.

As a possible solution, I considered letting person attach document to 
attachment pool and then get location using SET Field action.  Problem was 
encountered when file was in network share.  The capture path was in TEMP 
folder within windows profile.

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


Re: ITSM 6/CMDB 2.0 integration

2006-10-30 Thread strauss
**



There are CMDB 2.0.1 documents up on SupportWeb in 
Documentation(BMC Atrium CMDB 
2.0.1 Developer's Reference Guide  BMC Atrium CMDB 2.0.1Master Index) 
dated 2 November... so I would have to guess that it's 
close.
Christopher Strauss, Ph.D.Remedy Database 
AdministratorUniversity of North Texas Computing Centerhttp://remedy.unt.edu/helpdesk/ 



From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick 
CookSent: Monday, October 30, 2006 10:09 AMTo: 
arslist@ARSLIST.ORGSubject: ITSM 6/CMDB 2.0 
integration
** BMC said a month or soagothat they planned to issue a 
white paper and a def file to make the integration between these two happen in a 
more planned, supportable,and stable manner than having to figure it out 
ourselves. The soft due date they gave was late October, which is 
now. Does anyone have an update on when that will actually be released? 
-- Rick CookCook Enterprises253-278-4112 
__20060125___This posting was submitted with HTML in it___ 

__20060125___This posting was submitted with HTML in it___


Re: ITSM 6 Licenses on ARS 7 Server

2006-10-30 Thread McKenzie, James J C-E LCMC HQISEC/L3
Title: RE: ITSM 6 Licenses on ARS 7 Server
**





Rick:

Igor stated that there is no server license, just the default 3 licenses. If I'm incorrect, sorry.

James McKenzie
L-3 GSI






From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook
Sent: Monday, October 30, 2006 2:32 PM
To: arslist@ARSLIST.ORG
Subject: Re: ITSM 6 Licenses on ARS 7 Server



** 
I think you can run an unlicensed AR Server with ITSM apps up to, but not including, ITSM 6.0. After that, the CMDB is included, which requires multi-threading, which requires an AR Server license. I believe that the deployable applications that ITSM 7 uses also require an AR Server license. 


But if Igor's got application licenses, odds are he has an AR Server license, too, so I'm not sure that's his problem.

Rick

On 10/30/06, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: 


 ** 
 Rick:
 
 Is is not true that you cannot run an unlicensed server with the ITSM applications. This would cause the problem that 

 Igor sees? 
 
 James McKenzie
 L-3 GSI


 



 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] On Behalf Of Rick Cook
 Sent: Monday, October 30, 2006 2:22 PM
 To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG 
 Subject: Re: ITSM 6 Licenses on ARS 7 Server
 
 
 ** 
  I think there's a KB for this one that suggests deleting your multilicense.ar http://multilicense.ar/ file, I think it's called. When you restart ARS, it should generate another. 

 
 Rick
 
 On 10/30/06, igor ivanov [EMAIL PROTECTED]  wrote: 


  Please help, what's wrong?
  
   Remedy Support Note: ...
  There is also no license file upgrade needed if you are upgrading your AR 
  System to version 7 but not upgrading your ITSM application.
  You only need to upgrade your file if you are upgrading your ITSM
  application to version 7, or if you are upgrading your AR Server to version
  6. 
  
  Installed fresh ARS 6.03 and ITSM 6 (OOTB).
  Upgraded it to ARS 7.0. Server not licensed - 3 Demo licenses.
  
RICK: ITS RIGHT HERE ^^ 
  I've exported ITSM 5.6 App. Licenses (the same Site:Contract ID and Host
  ID: *site*) from PROD (ARS 6.03) and imported them into ARS7/ITSM6 box.
  
  I can see all of them (HD, CH, AS) in Admin Tool (Format 6.0, Help Desk
  User Fixed ...) but can not assign them to User.
  
  There are no Help Desk licenses available. (Number Available = 0, Number 
  Currently Used = 0) (ARERR 41453)
  
  The preceding message occurred during the execution of active link
  SHRCFG:PGP-ModPeopleInfo07Peop -- action 1. (ARNOTE 1101)
  
  regards,
  
  ii


 __20060125___This posting was submitted with HTML in it___ 




__20060125___This posting was submitted with HTML in it___

Re: ITSM 6/CMDB 2.0 integration

2006-10-30 Thread Rick Cook
**
Chris, how/where are you seeing that? I only see 2.0.0 in the Supported Product List.

Rick
On 10/30/06, strauss [EMAIL PROTECTED] wrote:
** 

There are CMDB 2.0.1 documents up on SupportWeb in Documentation(BMC Atrium CMDB 2.0.1 Developer's Reference Guide  BMC Atrium CMDB 
2.0.1Master Index) dated 2 November... so I would have to guess that it's close.
Christopher Strauss, Ph.D.Remedy Database AdministratorUniversity of North Texas Computing Center
http://remedy.unt.edu/helpdesk/ 


From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG
] On Behalf Of Rick CookSent: Monday, October 30, 2006 10:09 AMTo: arslist@ARSLIST.ORG
Subject: ITSM 6/CMDB 2.0 integration
** BMC said a month or soagothat they planned to issue a white paper and a def file to make the integration between these two happen in a more planned, supportable,and stable manner than having to figure it out ourselves. The soft due date they gave was late October, which is now. Does anyone have an update on when that will actually be released? 

__20060125___This posting was submitted with HTML in it___


Re: Newb needs API help...couple of questions

2006-10-30 Thread Marc Nations
**
Thanks for all the help! I had not scoured sourceforge yet and, by the Beard of Zeus, someone has already done a Python interface. Very good news indeed. I was able to install it, run it, and start getting results almost immediately. 
Apparently it's also using ctypes to interface with the DLLs. I was rather close but was not aware of the magical '.value' extension that is required to access the contents of a char pointer. However I'm not interested in re-creating the wheel, so the fact that it's already out there saves me tons of time.
For those that use this though, I did have a problem actually with the example shown in the documention. The ARGetSchema helper function didn't work. First it's using the variable 'schema' and trying to reference it without a definition. And then some of the fields within the structure were being called with incorrect definitions. I started trying to fix the problems, but then wondered if maybe there's another file that I need to reference. 
I don't need this function at the moment, but I'm worried that if there's another file that I don't have correctly configured I may have problems elsewhere. Did anyone else who uses pyARS have this problem?
MarcOn 10/30/06, Dirk Reiter [EMAIL PROTECTED] wrote:
Marc,there is a python module called pyars that covers most of the ARS API and CMDB functions.http://sourceforge.net/projects/pyars/We use it for automizing migration stuff for ARS and find it quite useful and stable.
CheersDirk Original-Nachricht Datum: Fri, 27 Oct 2006 23:47:14 -0500Von: Marc Nations [EMAIL PROTECTED]An: 
arslist@ARSLIST.ORGBetreff: Newb needs API help...couple of questions Hello all, For starters, I'm trying to integrate the Remedy API into a Python application. That is my ultimate goal. So if anyone has any experience
 with that or knows where some sample code is, I'd appreciate it. I'm going to use ctypes to make the dll calls and am building the structures. However, I've hit a wall so far with Python so I decided to run some
 example code in C and follow the process. I don't understand what is happening here, so I'm hoping someone could explain it to me. I am running the example given in the Remedy API documentation (with a
 couple of small modifications): Let me start off by saying that the code works, however almost seemingly by accident. The problem is when I step through it using Visual Studio, it doesn't respond like I thought it would. Here's the
 problem: Right now I have the application set up to fail at the initialization stage. So at Step A (marked below) I should see a failure after the ARInitialization call is made. However that is not the case. Instead I
 get back a response of '0', and it does not fall into the exception loop. Instead it moves on and attempts the ARGetListSchema call. At Step B is when the error for the initialization is actually recognized. So then
 it falls in the exception loop, prints out the error that was supposed to be printed in ARInit loop, and finishes execution. This also means that the status list is not being freed like is
 supposed to happen during the FreeARStatusList proc. It's still there when the next function is called. So in the end the application does work, but it's not failing at the correct place. So until I understand how this is supposed to properly
 work, there's no way I'll be able to get it interfaced over to another language. Does anyone know what either I or it is doing wrong? Thanks, Marc // ARS.cpp
 : Defines the entry point for the console application. // #include stdafx.h #include ar.h #include arextern.h #include arfree.h
 void printStatusList(ARStatusList *theList) {unsigned int i;for (i=0; i theList - numItems; i++){if (theList - statusList[i].appendedText == NULL ||
theList - statusList[i].appendedText == '\0')printf(%s, theList - statusList[i].messageText);elseprintf(%s:%s, theList -
 statusList[i].messageText,theList - statusList[i].appendedText);printf((ARERR %d)\n, theList - statusList[i].messageNum);
printf((Type %d)\n, theList - statusList[i].messageType);} } int main(void) {ARControlStruct control =
 {0,0,TEST_REMEDY,TEST_REMEDY02,,0,,TSTREMEDY01};ARNameList formNameList;unsigned int i;unsigned int ARInt;
unsigned int ARGetInt;ARStatusList status;ARInt = ARInitialization(control, status); --STEP
 Aprintf((ARInt %d)\n, ARInt);if ( ARInt = AR_RETURN_ERROR){printStatusList(status);
FreeARStatusList(status, FALSE);return 1;}FreeARStatusList(status, FALSE);ARGetInt = ARGetListSchema(control, 0,
AR_LIST_SCHEMA_ALL|AR_HIDDEN_INCREMENT,NULL,NULL,formNameList, status); --STEP
 Bif(ARGetInt = AR_RETURN_ERROR)printStatusList(status);else{for (i=0; i
formNameList.numItems; i++)printf(%s\n,formNameList.nameList[i]);}FreeARStatusList(status, FALSE);FreeARNameList(formNameList, 

Re: ITSM 6/CMDB 2.0 integration

2006-10-30 Thread Tony Worthington
I found the release notes there as well...  I don't think they were 
supposed to be there, it was supposed to be another document (some 
whitepaper, i don't remember)

-tony


-- 
Tony Worthington
[EMAIL PROTECTED]
262-703-5911



Rick Cook [EMAIL PROTECTED] 
Sent by: Action Request System discussion list(ARSList) 
arslist@ARSLIST.ORG
10/30/2006 03:45 PM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Re: ITSM 6/CMDB 2.0 integration






** 
Chris, how/where are you seeing that?  I only see 2.0.0 in the Supported 
Product List.
 
Rick
 
On 10/30/06, strauss [EMAIL PROTECTED] wrote: 
** 
There are CMDB 2.0.1 documents up on SupportWeb in Documentation (BMC 
Atrium CMDB 2.0.1 Developer's Reference Guide  BMC Atrium CMDB 2.0.1 
Master Index) dated 2 November... so I would have to guess that it's 
close.
Christopher Strauss, Ph.D.
Remedy Database Administrator
University of North Texas Computing Center
http://remedy.unt.edu/helpdesk/ 
From: Action Request System discussion list(ARSList) [mailto:

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


Re: ITSM 6 Licenses on ARS 7 Server

2006-10-30 Thread Grooms, Frederick W
Let me see if I have this straight (from your text below...)

You installed a fresh 6.03 and upgraded it to 7 ARS Server.  Is this a
new server box?  If so it looks like you do not have an AR Server
license for this box.  I believe ITSM 6 require a Server license.

What the support note is stating: 
 If you are Upgrading your Server from v5.x (or below) to version 6 or
higher you need to have your file upgraded. 
 - OR - 
 If you are Upgrading your ITSM application to version 7. 
 
Fred


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of igor ivanov
Sent: Monday, October 30, 2006 3:11 PM
To: arslist@ARSLIST.ORG
Subject: ITSM 6 Licenses on ARS 7 Server

Please help, what's wrong?

 Remedy Support Note: ...
There is also no license file upgrade needed if you are upgrading your
AR System to version 7 but not upgrading your ITSM application.
You only need to upgrade your file if you are upgrading your ITSM
application to version 7, or if you are upgrading your AR Server to
version 6.

Installed fresh ARS 6.03 and ITSM 6 (OOTB).
Upgraded it to ARS 7.0. Server not licensed - 3 Demo licenses.

I've exported ITSM 5.6 App. Licenses (the same Site:Contract ID and
Host ID: *site*) from PROD (ARS 6.03) and imported them into ARS7/ITSM6
box.

I can see all of them (HD, CH, AS) in Admin Tool (Format 6.0, Help Desk
User Fixed ...) but can not assign them to User.

There are no Help Desk licenses available.   (Number Available = 0,
Number Currently Used = 0) (ARERR 41453)

The preceding message occurred during the execution of active link
SHRCFG:PGP-ModPeopleInfo07Peop -- action 1. (ARNOTE 1101)

regards,

ii

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


Re: ITSM 6 Licenses on ARS 7 Server

2006-10-30 Thread igor ivanov
stopped ARS,
deleted multilicense,
started ARS,
multilicense recreated

same errors...

it looks like Server has to be licensed!

thanks,

ii

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


Re: ITSM 6/CMDB 2.0 integration

2006-10-30 Thread strauss
**



http://www.bmc.com/support/hou_Support_ProdVersion/0,3648,19097_19695_138636_0,00.html

Which is under My List of Products, to which I have added 
Change Mgmt and ServiceDesk - 2.0.1 isn't listed yet in the Atrium 
section.
Christopher Strauss, Ph.D.Remedy Database 
AdministratorUniversity of North Texas Computing Centerhttp://remedy.unt.edu/helpdesk/ 




From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick 
CookSent: Monday, October 30, 2006 3:46 PMTo: 
arslist@ARSLIST.ORGSubject: Re: ITSM 6/CMDB 2.0 
integration
** 
Chris, how/where are you seeing that? I only see 2.0.0 in the 
Supported Product List.

Rick
On 10/30/06, strauss 
[EMAIL PROTECTED] 
wrote: 
** 

  
  There are 
  CMDB 2.0.1 documents up on SupportWeb in Documentation(BMC Atrium CMDB 2.0.1 Developer's Reference 
  Guide  BMC Atrium CMDB 2.0.1Master Index) dated 2 
  November... so I would have to guess that it's close.
  Christopher Strauss, Ph.D.Remedy Database 
  AdministratorUniversity of North Texas Computing Centerhttp://remedy.unt.edu/helpdesk/ 
  
  
  From: Action Request System discussion 
  list(ARSList) [mailto:arslist@ARSLIST.ORG ] 
  On Behalf Of Rick CookSent: Monday, October 30, 2006 10:09 
  AMTo: arslist@ARSLIST.ORG 
  Subject: ITSM 6/CMDB 2.0 integration
  ** BMC said a month or soagothat they planned to issue 
  a white paper and a def file to make the integration between these two happen 
  in a more planned, supportable,and stable manner than having to figure 
  it out ourselves. The soft due date they gave was late October, which is 
  now. Does anyone have an update on when that will actually be released? 
  __20060125___This posting was 
submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___


Re: ITSM 6 Licenses on ARS 7 Server

2006-10-30 Thread igor ivanov
Installed a fresh 6.03 and upgraded it to 7 ARS Server.
This a new server box. As i have said it does not have an AR Server license.

I can login to ITSM APPs. Submit HD Ticket with just ARS Demo License (no 
ITSM App Licenses).

Support note is stating: 
 If you are Upgrading your Server from v5.x (or below) to version 6 or
higher you need to have your file upgraded. 
 - OR - 
 If you are Upgrading your ITSM application to version 7. 

That's right: ... You only need to upgrade your file if you are upgrading 
your ITSM 
application to version 7, or if you are upgrading your AR Server to version 
6. - i'm not doing any of that!

So, what do i need ?

ii

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


Re: Upgrading and switching platforms at the same time

2006-10-30 Thread Axton

Good point James, this will eliminate any real headaches if they
exist.  Is it possible to create the new instance using utf8 and
import an localized oracle db into the utf8 db?

Axton Grams

On 10/30/06, McKenzie, James J C-E LCMC HQISEC/L3
[EMAIL PROTECTED] wrote:

**


Dwayne:

Go:

1.  Install Oracle 9i on your new machine.  Import database.  Upgrade to
10g.  This will insure that the database's metadata is upgraded to the new
version.

James McKenzie
L-3 GSI



-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, October 30, 2006 7:03 AM
To: arslist@ARSLIST.ORG
Subject: Upgrading and switching platforms at the same time

Hello everyone,

We are upgrading from ARS 6.3 to 7, and at the same time switching from Unix
HPUX-11 to a new Red Hat Linux machine.
We are also upgrading from Oracle 9 to Oracle 10.  We have a
mostly-customized ARS system, but have installed the Asset Tracking module.

Two approaches:
1. Install Oracle on the new machine.  Install ARS on the new machine.
Export all the form and workflow definitions and form data from the old
system and import it into the new.

2.Copy the present Oracle database from the old machine to the new.  Rename
the database and upgrade it.  Install ARS.

The second approach sounds easier.  Any pitfalls that we should be aware of?

Dwayne Martin
Computing Support
James Madison University

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the
Answers Are __20060125___This posting
was submitted with HTML in it___


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


Re: multiple attachments in pool on mid tier?

2006-10-30 Thread Carter, Craig J Civ ARPC/DPD
Title: Re: multiple attachments in pool on mid tier?
**








Doug,



This is exactly what happens when you do
not select another row in the pool before clicking the Add button. You have to
click the row below the file column header (far left column)clicking
under any other column will not allow selection of the row. The individual row
permissions must be set as well as the overall attachment pool. Since you are
not selecting a different row in the pool, it prompts to see whether you want
to replace the existing file.



It doesnt sound like anything is
wrong. You need to verify the permissions for each row of the pool, make sure
you are opening the page in submit mode, and make sure you are selecting the
row beneath the file column header before clicking the add button. Unless its
one of these things, Im not sure what to tell you since it should work.
If its working for the first row, youve confirmed it works as
expected so my guess would be the additional rows in the pool do not have the
proper permissions or you are not clicking in the pool under the proper header.



Craig











From: Action Request
System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]
On Behalf Of Anderson, Douglas W.
Sent: Monday, October 30, 2006
9:08 AM
To: arslist@ARSLIST.ORG
Subject: Re: multiple attachments
in pool on mid tier?





Hi
Rocky, Michelle, Craig, et al., 

It's
not a permissions issue and yes, we're using the built-in Add, Delete, 
Display buttons. 

The
browser interface doesn't enable selecting a row in the pool. One can click
wherever one wants and nothing is highlighted inside the pool. The first
click on the pool causes the buttons to appear.

The
result of the first invocation of the Add button is an attachment displayed in
the top row of the pool. A second invocation of the Add button
results in a dialog asking whether one wants to replace the first attachment
with the newly specified one.

It's
not my application, so I won't carry the investigation any further at this
point. I'll be interested to see whether the issue evaporates when we
(eventually) upgrade to 6.3 or 7.x ARS.

Thanks
for your ideas! 
Doug




original
message: 
Date:
Fri, 27 Oct 2006 13:53:34 -0600 
From:
Carter, Craig J Civ ARPC/DPD
[EMAIL PROTECTED] 
Subject:
Re: multiple attachments in pool on mid tier? 

We've
never seen this problem and we use them all over the place in our

midtier.
We're no longer on 6.0.1 either. 



This
may seem obvious but are you logging into the midtier with the same

permissions
and have you verified the permissions for each attachment row in 
the
web view? Perhaps those extra rows were added later and the permissions

were
not updated. Another obvious thing to check is whether you are

clicking
on the actual row in the attachment pool when adding the 
attachments
on the web? We don't use buttons on the web (just use the built

in
ones you get once you select a row) and you have to click each specific

row
or the attachment will keep going into the first row (or currently

selected
row). 



Are
you using a button with locally-built workflow or are you using the

built-in
buttons? 




CRAIG
J. CARTER 






__20060125___This posting was submitted with HTML in it___
__20060125___This posting was submitted with HTML in it___

Re: QUESTION: MENU - NOT LIKE

2006-10-30 Thread Guillermo Alfredo Torres Barron
**








I use this qualification



$GROUPS$ LIKE %Administrator%



Work good ;)



A question, somebady I
said me that if I can use LIKE in a Run if quealification I do a FULL SCAN over
database, It is true?

Thanks in advance











De: Action Request
System discussion list(ARSList) [mailto:[EMAIL PROTECTED] En nombre de Reiser, John J
Enviado el: Viernes, 27 de Octubre
de 2006 10:21 a.m.
Para: arslist@ARSLIST.ORG
Asunto: Re: QUESTION: MENU - NOT
LIKE





Frank, Wouldn't it be 

(Not $GROUP$ Like %
1;% and Not $GROUP$ Like 1;%)

The first term finds it in the middle or
the end and the second term finds it in the first position of the Group list.

With %1;% it would find,
and block, a group number like 51.



HTH,



John J.
Reiser
Software Development Analyst
Remedy Administrator/Developer
Lockheed Martin - MS2
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased by me















From:
Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso
Sent: Friday, October 27, 2006
10:11 AM
To: arslist@ARSLIST.ORG
Subject: Re: QUESTION: MENU - NOT
LIKE

** I think it is
something like:

(Not $GROUP$ Like %1;% and Not $GROUP$ Like 1;% and Not
$GROUP$ Like %; 1%)

You need to catch it as the first Group, anywhere in the middle and the last
group 






On 10/27/06, Tyrone
Dee [EMAIL PROTECTED]
wrote: 

** 





I have a Menu that shows
all Users from the USER Form - no problem.











I would like to restrict
all users who are Administrators from the pull down menu. I tried:











NOT 'Group List' LIKE
% + 1 + %











However, this is not
working as there are other groups with 1 in the Group Number.











Any assistance would be
greatly appreciated.











THANKS!





__20060125___This posting was submitted with HTML
in it___ 






-- 
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer
www.specificintegration.com
703-376-1249 __20060125___This posting was submitted with
HTML in it___ 



...Este correo electronico es confidencial y/o puede contener informacion privilegiada.Si usted no es su destinatario o no es alguna persona autorizada por este para recibir sus correos electronicos, NO debera usted utilizar, copiar, revelar, o tomar ninguna accion basada en este correo electronico o cualquier otra informacion incluida en el, favor de notificar al remitente de inmediato mediante el reenvio de este correo electronico y borrar a continuacion totalmente este correo electronico y sus anexos.Nota: Los acentos y caracteres especiales fueron omitidos para su correcta lectura en cualquier medio electronico.This e-mail is confidential and/or may contain privileged information.If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or anyother information herein, please advise the sender immediately by reply this e-mail and delete this e-mail and  its attachments. ...


__20060125___This posting was submitted with HTML in it___
__20060125___This posting was submitted with HTML in it___

Re: QUESTION: MENU - NOT LIKE

2006-10-30 Thread Axton

I would be more worried about groups like 'APP-Administrotor' or
'insert app name here-Administrator'.

Axton Grams

On 10/30/06, Guillermo Alfredo Torres Barron
[EMAIL PROTECTED] wrote:

**



I use this qualification



$GROUPS$ LIKE %Administrator%



Work good ;)



A question, somebady I said me that if I can use LIKE in a Run if
quealification I do a FULL SCAN over database, It is true?

Thanks in advance



 


De: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] En nombre de Reiser, John J
 Enviado el: Viernes, 27 de Octubre de 2006 10:21 a.m.
 Para: arslist@ARSLIST.ORG
 Asunto: Re: QUESTION: MENU - NOT LIKE



Frank, Wouldn't it be

(Not $GROUP$ Like % 1;% and Not $GROUP$ Like 1;%)

The first term finds it in the middle or the end and the second term finds
it in the first position of the Group list.

With %1;%  it would find, and block, a group number like 51.


HTH,

John J. Reiser
 Software Development Analyst
 Remedy Administrator/Developer
 Lockheed Martin - MS2
 The star that burns twice as bright burns half as long.
 Pay close attention and be illuminated by its brilliance. - paraphrased by
me





 


From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso
 Sent: Friday, October 27, 2006 10:11 AM
 To: arslist@ARSLIST.ORG
 Subject: Re: QUESTION: MENU - NOT LIKE

** I think it is something like:

 (Not $GROUP$ Like %1;% and Not $GROUP$ Like 1;% and Not $GROUP$ Like
%; 1%)

 You need to catch it as the first Group, anywhere in the middle and the
last group





On 10/27/06, Tyrone Dee [EMAIL PROTECTED] wrote:

**



I have a Menu that shows all Users from the USER Form - no problem.





I would like to restrict all users who are Administrators from the pull down
menu.  I tried:





NOT 'Group List' LIKE % + 1 + %





However, this is not working as there are other groups with 1 in the Group
Number.





Any assistance would be greatly appreciated.





THANKS!

__20060125___This posting was submitted
with HTML in it___




 --
 Frank Caruso
 Specific Integration, Inc.
 Senior Remedy Engineer
 www.specificintegration.com
 703-376-1249 __20060125___This posting
was submitted with HTML in it___
...
Este correo electronico es confidencial y/o puede contener informacion
privilegiada.
Si usted no es su destinatario o no es alguna persona autorizada por este
para recibir sus correos electronicos, NO debera usted utilizar, copiar,
revelar, o tomar ninguna accion basada en este correo electronico o
cualquier otra informacion incluida en el, favor de notificar al remitente
de inmediato mediante el reenvio de este correo electronico y borrar a
continuacion totalmente este correo electronico y sus anexos.
Nota: Los acentos y caracteres especiales fueron omitidos para su correcta
lectura en cualquier medio electronico.

This e-mail is confidential and/or may contain privileged information.
If you are not the addressee or authorized to receive this for the
addressee, you must not use, copy, disclose, or take any action based on
this message or any
other information herein, please advise the sender immediately by reply this
e-mail and delete this e-mail and its attachments.
...
 __20060125___This posting was
submitted with HTML in it___
__20060125___This posting was submitted
with HTML in it___


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


Avery L Logan/ASG/Johnson_Controls is out of the office.

2006-10-30 Thread Avery L. Logan II
I will be out of the office starting  10/29/2006 and will not return until
11/06/2006.

I will respond to your message when I return.  Please contact your local
Help Desk concerning Remedy issues.  Other Remedy team members can also be
contacted at [EMAIL PROTECTED]
([EMAIL PROTECTED] - Manager)

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