V.Urgent: How Incident/Change License works, how can we manage releasing

2008-10-27 Thread Manish SINGLA
Hello  List,
 
We are growing with our customer base from Remedy utilization in side ST,
with which our incident and Change support people are growing.
Now we need to estimate the utilization of Helpdesk and Change management
Floating license utilization, so that we could plan what to buy more.
 
From our current study of floating license utilization, we can find out that
ARUser license get assigned to the user (profiled APP Support with AR
Floating license) as soon as he logon to Remedy application and remains with
user till he logout from the application. Or License time out can be another
possibility of license release back to license pool. (Please challenge if i
am wrong analyzing)
 
Now the license utilization and handling of Incident/change management
license in black box for us. Now we have some queries for your quick
expected reply:
1. We couldn't find any OOTB thing that could give me current
Incident/Change management license utilization. Please advice if any.
2. Please suggest when the Remedy allocates Helpdesk/change floating license
to a user:
2.1 When he login?
2.2 When he do Save/Update on helpdesk/change form?
2.3 Does helpdesk/change license remains with user?
2.4 If yes what is the way of releasing and what is the standard
OOTB way of doing(Way Remedy application works)
 
Please explain how Remedy do the license handelling and how we can manage
better.
 
Thanks
Best Regards
Manish

 
 
 
 

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


Re: V.Urgent: How Incident/Change License works, how can we manage releasing

2008-10-27 Thread Robert . 2 . Kern
Hello Manish,

have no hands on experience on ITSM, but the user.log file should be a 
good starting point.
Depending on your version, you can turn it on at the admin or user client, 
at the server-log settings.

We do some license monitoring/opimization based on that log file, down to 
the user.

Don't want to advertise, but you could also invest in a tool for that: 
www.rrr.se

They basically also take the user.log file and report on that. Just that 
they do all for you,
so you dont have to build a report/logic you own ... from what I know, 
they can also
report ITSM (so I assume, the ITSM licenses are also shown at the user.log 
file).


Other then that, you have not provided much infos about how you have done
your current studies. Did you use the log file, or just check the 
available licenses?

Based on that, we perhaps can help further :-)


Cheerio, Robert


Ps. yes, I think BMC should be way more helpful, in providing further help 
for optimized
license allocation ... but hey, its a business :-)


Mit freundlichen Grüßen/Best regards
Robert Kern

Corporate Infrastructure IT Operations - Service Integration - Service 
Desk
IT CI OP SI SD
Continental Automotive GmbH
Sodener Strasse 9, 65824 Schwalbach, Germany

Telefon/Phone: +49 6196872546
Telefax: +49 619 687792546
E-Mail: [EMAIL PROTECTED]
www.continental-corporation.com
__
Continental Automotive GmbH, Siemensstr. 12, 93055 Regensburg, Germany
Geschäftsführer/Managing Directors: Helmut Matschi, Gérard Cordonnier, 
Harald Stuhlmann
Sitz der Gesellschaft/Registered office: Hannover
Registergericht/Commercial registry: Hannover, HRB 59424, USt-Id. Nr. 
DE814950663
___
Proprietary and confidential. Distribution only by express authority of 
Continental AG or its
subsidiaries.



Manish SINGLA [EMAIL PROTECTED] 
Sent by: Action Request System discussion list(ARSList) 
arslist@ARSLIST.ORG
27.10.2008 07:58
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
V.Urgent: How Incident/Change License works, how can we manage releasing






** 
Hello  List,
 
We are growing with our customer base from Remedy utilization in side ST, 
with which our incident and Change support people are growing.
Now we need to estimate the utilization of Helpdesk and Change management 
Floating license utilization, so that we could plan what to buy more.
 
From our current study of floating license utilization, we can find out 
that ARUser license get assigned to the user (profiled APP Support with AR 
Floating license) as soon as he logon to Remedy application and remains 
with user till he logout from the application. Or License time out can be 
another possibility of license release back to license pool. (Please 
challenge if i am wrong analyzing)
 
Now the license utilization and handling of Incident/change management 
license in black box for us. Now we have some queries for your quick 
expected reply:
1. We couldn't find any OOTB thing that could give me current 
Incident/Change management license utilization. Please advice if any.
2. Please suggest when the Remedy allocates Helpdesk/change floating 
license to a user:
2.1 When he login?
2.2 When he do Save/Update on helpdesk/change form?
2.3 Does helpdesk/change license remains with user?
2.4 If yes what is the way of releasing and what is the standard 
OOTB way of doing(Way Remedy application works)
 
Please explain how Remedy do the license handelling and how we can manage 
better.
 
Thanks
Best Regards
Manish
 
 
 
 
 
__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are 
html___ 

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


Re: V.Urgent: How Incident/Change License works, how can we manage releasing

2008-10-27 Thread Manish SINGLA
Hello Cheerio, Robert,
 
Thanks for the quick response.
 
I have extracted aruser.log but couldn't find segregated license for
Helpdesk(Incident management) and Change Management.
 
Aruser.log give only one consolidated picture of aruser licenses in use.
 
Please advice some thing else can be used.
 
Thanks again for the reply.
Regards
Manish

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Monday, October 27, 2008 12:38 PM
To: arslist@ARSLIST.ORG
Subject: Re: V.Urgent: How Incident/Change License works, how can we manage
releasing


** 
Hello Manish, 

have no hands on experience on ITSM, but the user.log file should be a good
starting point. 
Depending on your version, you can turn it on at the admin or user client,
at the server-log settings. 

We do some license monitoring/opimization based on that log file, down to
the user. 

Don't want to advertise, but you could also invest in a tool for that:
www.rrr.se 

They basically also take the user.log file and report on that. Just that
they do all for you, 
so you dont have to build a report/logic you own ... from what I know, they
can also 
report ITSM (so I assume, the ITSM licenses are also shown at the user.log
file). 


Other then that, you have not provided much infos about how you have done 
your current studies. Did you use the log file, or just check the
available licenses? 

Based on that, we perhaps can help further :-) 


Cheerio, Robert 


Ps. yes, I think BMC should be way more helpful, in providing further help
for optimized 
license allocation ... but hey, its a business :-) 


Mit freundlichen Grüßen/Best regards
Robert Kern

Corporate Infrastructure IT Operations - Service Integration - Service Desk
IT CI OP SI SD
Continental Automotive GmbH
Sodener Strasse 9, 65824 Schwalbach, Germany

Telefon/Phone: +49 6196872546
Telefax: +49 619 687792546
E-Mail: [EMAIL PROTECTED]
www.continental-corporation.com
__
Continental Automotive GmbH, Siemensstr. 12, 93055 Regensburg, Germany
Geschäftsführer/Managing Directors: Helmut Matschi, Gérard Cordonnier,
Harald Stuhlmann
Sitz der Gesellschaft/Registered office: Hannover
Registergericht/Commercial registry: Hannover, HRB 59424, USt-Id. Nr.
DE814950663
___
Proprietary and confidential. Distribution only by express authority of
Continental AG or its
subsidiaries. 



Manish SINGLA [EMAIL PROTECTED] 
Sent by: Action Request System discussion list(ARSList)
arslist@ARSLIST.ORG 


27.10.2008 07:58 


Please respond to
arslist@ARSLIST.ORG



To
arslist@ARSLIST.ORG 

cc

Subject
V.Urgent: How Incident/Change License works, how can we manage releasing






** 
Hello  List, 
  
We are growing with our customer base from Remedy utilization in side ST,
with which our incident and Change support people are growing. 
Now we need to estimate the utilization of Helpdesk and Change management
Floating license utilization, so that we could plan what to buy more. 
  
From our current study of floating license utilization, we can find out that
ARUser license get assigned to the user (profiled APP Support with AR
Floating license) as soon as he logon to Remedy application and remains with
user till he logout from the application. Or License time out can be another
possibility of license release back to license pool. (Please challenge if i
am wrong analyzing) 
  
Now the license utilization and handling of Incident/change management
license in black box for us. Now we have some queries for your quick
expected reply: 
1. We couldn't find any OOTB thing that could give me current
Incident/Change management license utilization. Please advice if any. 
2. Please suggest when the Remedy allocates Helpdesk/change floating license
to a user: 
2.1 When he login? 
2.2 When he do Save/Update on helpdesk/change form? 
2.3 Does helpdesk/change license remains with user? 
2.4 If yes what is the way of releasing and what is the standard
OOTB way of doing(Way Remedy application works) 
  
Please explain how Remedy do the license handelling and how we can manage
better. 
  
Thanks 
Best Regards 
Manish 

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

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


Re: RANT: Support Finally Got under my skin

2008-10-27 Thread Carey Matthew Black
I would verify that the ar server config file (ar.conf) has a line in
it that specifies the group that you expect for this feature: (
Debug-GroupId ).

I would then go to the Group form and find any records with that
'Group ID' value. ( There should be only one. )
And as an added sanity... take the 'Group Name' value and look for any
other Group form records with that 'Group Name'. ( There should be
only one. But you may find multiple just because of the Search By
Example settings on the field. So make sure the values really are all
the same if you find more than one. )

HTH.

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

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



On Fri, Oct 24, 2008 at 12:21 PM, Grooms, Frederick W
[EMAIL PROTECTED] wrote:
 **
 Yes our group form had Administrator listed twice (ID 1 and 8076), Customize
 (2 and 8077), Submitter (3 and 8078) , ...

 I deleted the high IDs and restarted the server then everything was good
 again.
 
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of Danaceau, Chris
 Sent: Friday, October 24, 2008 8:27 AM
 To: arslist@ARSLIST.ORG
 Subject: Re: RANT: Support Finally Got under my skin

 **
 Worth a look, I guess.   This environment was originally a 7.0 ARS upgraded
 to 7.1.   Should I check the group form for this?

 --

 Chris Danaceau

snip

 
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
 Sent: Friday, October 24, 2008 9:25 AM
 To: arslist@ARSLIST.ORG
 Subject: Re: RANT: Support Finally Got under my skin

 **
 Sorry to jump in here but ...

 Are you sure you don't have 2 groups of Administrator?  I had that problem
 after the 6.3.0 to 7.1.0 upgrade.  The upgrade added an additional set of
 groups with different group IDs.  I had all sorts of strange things going on
 until I removed the incorrect (new) groups.   It sounds like the server may
 think the client side group is set as Administrator (the new one).

 Fred

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


Re: UNSUBSCRIBE

2008-10-27 Thread Darrell Reading
I dub thee UNSUBSCRIBEd.
 

Darrell Reading Systems Engineer 
Phone 479.204.5739 
[EMAIL PROTECTED] 

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

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Sanapala, Rajinikanth IN KRG
Sent: Saturday, October 25, 2008 21:25
To: arslist@ARSLIST.ORG
Subject: UNSUBSCRIBE


** 

 

UNSUBSCRIBE ME

 

Regards,

Rajinikanth


Important notice:This e-mail and any attachment thereto contains
corporate proprietary information. If you have received it by mistake,
please notify us immediately by reply e-mail and delete this e-mail and
its attachments from your system.
Thank You. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the
Answers Are html___ 




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


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

Re: Using Military Time

2008-10-27 Thread Rod Harris
Let us know how you get on.

Good luck with it,

Rod

-Original Message-
From: Action Request System discussion list(ARSList) on behalf of Paul Blasquez
Sent: Sat 10/25/2008 4:15 AM
To: arslist@ARSLIST.ORG
Subject: Re: Using Military Time
 
Rod,

Thank you for this info, I will go back into the User Preference form
and give this a try.

-Paul 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rod Harris
Sent: Tuesday, October 21, 2008 20:38
To: arslist@ARSLIST.ORG
Subject: Re: Using Military Time

Hi Paul,
 
There are AR user preference fields for date and time formats that will
override the windows client settings. There are two fields for the mid
tier and a separate combined field for the windows user tool (WUT). From
memory you may get issues in ITSM if you drop seconds from the time
display but the change to a 24 hour clock shouldn't be a problem. You
could use workflow to default a user's preference setting to a 24 hour
clock. I've done this sort of thing at a couple of client sites
recently. One was all web and the other all WUT so it should work for
both.  
 
 
In Australia we set our WUT date time format to 
dd/MM/ HH:mm:ss 
 
You were on the right track when you found the date format setting in
the preference field. It can actually includes formats for both date and
time.
 
Rod Harris


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


Re: Form dropped but still in schema table

2008-10-27 Thread Garrison, Sean (Norcross)
You will have to go deep into ar to fix this one:

My guess is that the AP:Detail-Signature had been modified somehow.  It used to 
contain a field that has since been removed.

To explore this run the following queries:

SELECT NUMFIELDS FROM ARSCHEMA WHERE NAME LIKE 'AP:Detail-Signature'

SELECT count(*) FROM FIELD WHERE SCHEMAID IN (SELECT SCHEMAID FROM ARSCHEMA 
WHERE NAME LIKE 'AP:Detail-Signature')

If the 2 numbers are different then you will get the Field Count error.

If the field count from the FIELD table is greater than the NUMFIELDS value 
then you can find the missing field by:

SELECT * FROM FIELD WHERE SCHEMAID IN (SELECT SCHEMAID FROM ARSCHEMA WHERE NAME 
LIKE 'AP:Detail-Signature')

THEN DO THIS:

SELECT 'T' || SCHEMAID FROM ARSCHEMA WHERE NAME LIKE 'AP:Detail-Signature'

Then do a DESC on the result of the above query.

You will then have to do a comparison between the description of the table and 
the results of the FIELD list.  You should be able to tell from there what 
field should exist on the form.

Pay close attention to the Data Type and Field Type values.  I wish I could 
remember where the reference is for those things ... but I can't remember off 
the top of my head.  Those 2 fields tell you what type of field it is and what 
type of data is stored in it.  i.e. is it a Integer, Date, Character or 
Date field.  If it is a Character is it a Display-Only field?  etc.

If the field count in the NUMFIELDS is greater than the field count in the 
FIELD table then you need to probably call Remedy support and see if they can 
help you find it.  (I am assuming you didn't customize this form and left it 
out of the box?)

You may be able to get a hint by looking at the QUERY SHORT parameter on the 
FILTER table:

SELECT * FROM FILTER WHERE NAME = ' AP:Dtl-Sig-NextActionEscTime'  but it may 
confuse you more than help.

OR By running this query:

SELECT * FROM FILTER_PUSH WHERE FILTERID IN (SELECT FILTERID FROM FILTER WHERE 
NAME = ' AP:Dtl-Sig-NextActionEscTime')

SELECT * FROM FILTER_SET WHERE FILTERID IN (SELECT FILTERID FROM FILTER WHERE 
NAME = ' AP:Dtl-Sig-NextActionEscTime')

and look at the FIELDID value.  Compare that with the AssignShort field to 
make sure it is pushing to or setting from the AP:Detail-Signature table.



Good Luck,

Sean







From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Moore, Christopher Allen
Sent: Friday, October 24, 2008 11:15 AM
To: arslist@ARSLIST.ORG
Subject: Form dropped but still in schema table

**
Hey everyone,

Yesterday we noticed out error log on dev had not had any changes in about 24 
hours, which is a bit unusual, and the last few lines stated:

Wed Oct 22 12:01:47 2008  Approve : Invalid join member form name 0 (ARERR 
266)
Wed Oct 22 12:01:47 2008  Approve : Operation cancelled due to error (ARAPPNOTE 
4502)
Wed Oct 22 12:01:47 2008 New-Details - CHG:Infrastructure Change - 
CRQ00011371
Wed Oct 22 22:06:37 2008  390695 : AR System server terminated when a 
signal/exception was received by the server (ARNOTE 20)
Wed Oct 22 22:06:37 2008 0xc005
Wed Oct 22 22:06:37 2008  390695 : AR System server terminated -- fatal error 
encountered (ARNOTE 21)
Wed Oct 22 22:06:40 2008  390695 : AR System server terminated when a 
signal/exception was received by the server (ARNOTE 20)
Wed Oct 22 22:06:40 2008 0xc005
Wed Oct 22 22:06:40 2008  390695 : AR System server terminated -- fatal error 
encountered (ARNOTE 21)
Wed Oct 22 22:11:01 2008  390695 : AR System server terminated when a 
signal/exception was received by the server (ARNOTE 20)
Wed Oct 22 22:11:01 2008 0xc005
Wed Oct 22 22:11:01 2008  390695 : AR System server terminated -- fatal error 
encountered (ARNOTE 21)

We restarted the services to try and get it going again, and in just over a 
minute the log stopped again, full of the following sort of errors:

Thu Oct 23 09:09:09 2008  390600 : The form definition file field count does 
not match number of fields in the file (ARERR 403)
Thu Oct 23 09:09:09 2008 AP:Detail-Signature
Thu Oct 23 09:10:21 2008  390600 : Form does not exist on server (ARERR 303)
Thu Oct 23 09:10:21 2008  390600 : Error in definition for a filter (ARERR 343)
Thu Oct 23 09:10:21 2008 AP:Dtl-Sig-NextActionEscTime
Thu Oct 23 09:10:21 2008  390600 : Error in definition for a filter (ARERR 343)
Thu Oct 23 09:10:21 2008 AP:Dtl-Sig-NextActionEscTime
Thu Oct 23 09:10:21 2008  390600 : Form does not exist on server (ARERR 303)
(thousands of rows of this)

So I went and found, sure enough, the join AP:Detail-Signature was missing on 
our dev server, but it was there on production.  No problem, I'll just import 
from production to dev:

The value(s) for this entry violate a unique index that has been defined for 
this form: (ARERR 382)
The following form was not imported: AP:Detail-Signature (ARERR 55)

We checked the arschema table, and sure enough, it's there, id 99.  Even 
overwriting the 

Adding days to a Date field in a qualification doesn't work

2008-10-27 Thread Mark Milke
Hi Listers,

I have a date field on my form and I want to check, if the date
entered isn't later than 6 months from now. I have an Active Link with
the following qualification:

'my_date_field'  $DATE$ + 182

This doesn't work.

'my_date_field'  $DATE$ works just fine. As soon as I try to add any
number the $DATE$ variable it stops working.

Why?


Mark

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


Re: Adding days to a Date field in a qualification doesn't work

2008-10-27 Thread LJ Longwing
have you tried 

'my_date_field'  ($DATE$ + 182)

so that it will add 182 to the date before doing the compare?

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Milke
Sent: Monday, October 27, 2008 8:27 AM
To: arslist@ARSLIST.ORG
Subject: Adding days to a Date field in a qualification doesn't work

Hi Listers,

I have a date field on my form and I want to check, if the date entered
isn't later than 6 months from now. I have an Active Link with the following
qualification:

'my_date_field'  $DATE$ + 182

This doesn't work.

'my_date_field'  $DATE$ works just fine. As soon as I try to add any number
the $DATE$ variable it stops working.

Why?


Mark


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

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


Re: Adding days to a Date field in a qualification doesn't work

2008-10-27 Thread Mark Milke
 'my_date_field'  ($DATE$ + 182)
 so that it will add 182 to the date before doing the compare?

Yes, that's exactly what I did.

Mark

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


Re: Adding days to a Date field in a qualification doesn't work

2008-10-27 Thread Grooms, Frederick W
I usually have to put the Date fields inside quotes when doing
calculations

'my_date_field'  ($DATE$ + 182) 

Fred

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Milke
Sent: Monday, October 27, 2008 10:08 AM
To: arslist@ARSLIST.ORG
Subject: Re: Adding days to a Date field in a qualification doesn't work

 'my_date_field'  ($DATE$ + 182)
 so that it will add 182 to the date before doing the compare?

Yes, that's exactly what I did.

Mark

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


Re: Adding days to a Date field in a qualification doesn't work

2008-10-27 Thread Tanner, Doug
Try

'my_date_field'  ($DATE$ + 15724800)

Humor me
Doug

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Milke
Sent: Monday, October 27, 2008 11:08 AM
To: arslist@ARSLIST.ORG
Subject: Re: Adding days to a Date field in a qualification doesn't work

 'my_date_field'  ($DATE$ + 182)
 so that it will add 182 to the date before doing the compare?

Yes, that's exactly what I did.

Mark


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


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

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


Re: Adding days to a Date field in a qualification doesn't work

2008-10-27 Thread Opela, Gary L CTR USAF AFMC 72 CS/SCBAH
Yeah, I think that doug is on to something here. The $DATE$ keyword is
referring to seconds, I believe, and thus you need to add six months
worth of seconds. Note, that $DATE$ calculates to midnight that day, so
if you need to calculate six months from now, then you will likely need
to use $TIMESTAMP$. Using $DATE$ will give you 6 months from the
beginning of the current day. Also, as a good note, I would suggest
adding the parenthesis, although they should not be required.

Thanks,

Gary

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Tanner, Doug
Sent: Monday, October 27, 2008 10:18 AM
To: arslist@ARSLIST.ORG
Subject: Re: Adding days to a Date field in a qualification doesn't work

Try

'my_date_field'  ($DATE$ + 15724800)

Humor me
Doug

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Milke
Sent: Monday, October 27, 2008 11:08 AM
To: arslist@ARSLIST.ORG
Subject: Re: Adding days to a Date field in a qualification doesn't work

 'my_date_field'  ($DATE$ + 182)
 so that it will add 182 to the date before doing the compare?

Yes, that's exactly what I did.

Mark


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


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


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

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


Carriage Return

2008-10-27 Thread Trevino, Rick
Hello,

Does anyone know how to use a carriage return included in a value.

Example:

 

Field name: 

Value :field + $field name$ + would like carriage return then $field
Name$ + $field name$

 

Data

 

Field

Field

Field

 

Version7.0.1


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


Re: Carriage Return

2008-10-27 Thread Opela, Gary L CTR USAF AFMC 72 CS/SCBAH
You will need to expand the window by clicking on the elipses (...).

Whenever the box is expanded, do your set fields or whatever:

Value: $Field$ + 
 + $Field$ + 



If you put in an opening double quote, then hit enter, it will return to
the next line, and then add your closing double quote. Whenever you
close the expanded window, the single line version, instead of showing
the new lines, will show a non printable solid block character.

Thanks,

Gary Opela, Jr.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Trevino, Rick
Sent: Monday, October 27, 2008 10:24 AM
To: arslist@ARSLIST.ORG
Subject: Carriage Return

** 

Hello,

Does anyone know how to use a carriage return included in a value.

Example:

 

Field name: 

Value :field + $field name$ + would like carriage return then $field
Name$ + $field name$

 

Data

 

Field

Field

Field

 

Version7.0.1

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

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


Re: Adding days to a Date field in a qualification doesn't work

2008-10-27 Thread LJ Longwing
Oh...I know why it's not workingbecause $DATE$ can be used for both Date
and Date/Time fieldsand remedy probably does some dynamic stuff to the
value when you are doing a compare with a date field...so what you may need
to do is

setfield ztmp_datefield = $DATE$
setfield ztmp_datefield = +182 

then in another filter my_date_field  ztmp_datefield

I bet that would work

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Tanner, Doug
Sent: Monday, October 27, 2008 9:18 AM
To: arslist@ARSLIST.ORG
Subject: Re: Adding days to a Date field in a qualification doesn't work

Try

'my_date_field'  ($DATE$ + 15724800)

Humor me
Doug

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Milke
Sent: Monday, October 27, 2008 11:08 AM
To: arslist@ARSLIST.ORG
Subject: Re: Adding days to a Date field in a qualification doesn't work

 'my_date_field'  ($DATE$ + 182)
 so that it will add 182 to the date before doing the compare?

Yes, that's exactly what I did.

Mark


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


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


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

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


Re: Carriage Return

2008-10-27 Thread LJ Longwing
You need to open up the edit box for the setfield, and where you want the
enter put + , then press enter and put your end quote (or more text if you
want)...and when you answer ok to the edit box you will see a vertical black
box where your enter is.

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Trevino, Rick
Sent: Monday, October 27, 2008 9:24 AM
To: arslist@ARSLIST.ORG
Subject: Carriage Return


** 

Hello,

Does anyone know how to use a carriage return included in a value.

Example:

 

Field name: 

Value :field + $field name$ + would like carriage return then $field
Name$ + $field name$

 

Data

 

Field

Field

Field

 

Version7.0.1

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

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


Re: Adding days to a Date field in a qualification doesn't work

2008-10-27 Thread Tanner, Doug
Yeah, It is at the database level a Date/Time field, the DISPLAY
property is TIME

:)
Doug

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L CTR USAF AFMC 72
CS/SCBAH
Sent: Monday, October 27, 2008 11:21 AM
To: arslist@ARSLIST.ORG
Subject: Re: Adding days to a Date field in a qualification doesn't work

Yeah, I think that doug is on to something here. The $DATE$ keyword is
referring to seconds, I believe, and thus you need to add six months
worth of seconds. Note, that $DATE$ calculates to midnight that day, so
if you need to calculate six months from now, then you will likely need
to use $TIMESTAMP$. Using $DATE$ will give you 6 months from the
beginning of the current day. Also, as a good note, I would suggest
adding the parenthesis, although they should not be required.

Thanks,

Gary

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Tanner, Doug
Sent: Monday, October 27, 2008 10:18 AM
To: arslist@ARSLIST.ORG
Subject: Re: Adding days to a Date field in a qualification doesn't work

Try

'my_date_field'  ($DATE$ + 15724800)

Humor me
Doug

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Milke
Sent: Monday, October 27, 2008 11:08 AM
To: arslist@ARSLIST.ORG
Subject: Re: Adding days to a Date field in a qualification doesn't work

 'my_date_field'  ($DATE$ + 182)
 so that it will add 182 to the date before doing the compare?

Yes, that's exactly what I did.

Mark


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


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


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


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


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

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


Re: Adding days to a Date field in a qualification doesn't work

2008-10-27 Thread Frank, Gordon M. (CMS/CTR)
An easy way to do this is to use the multipliers. You will also need to
use $TIMESTAMP$

'my_date_field'  ($TIMESTAMP$ + (60*60*24*182))

$TIMESTAMP$ returns the number of seconds elapsed since midnight
Coordinated Universal Time (UTC) of January 1, 1970. 

Guess what platform Remedy ARS was first built upon? That's right UNIX.
There used to be 3 clients. Anyone know what they were? Note: Remedy ARS
was built before there was a Public Internet. Come to think of it, there
may have been 4 clients at one time, but there may not have been one for
IBM OS/2.

When you do it this way, you can substitute a $variable or a number
whenever you like.

Gordon M. Frank
Remedy Skilled Professional
ITIL V3 Certified
Lockheed Martin

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Milke
Sent: Monday, October 27, 2008 10:27 AM
To: arslist@ARSLIST.ORG
Subject: Adding days to a Date field in a qualification doesn't work

Hi Listers,

I have a date field on my form and I want to check, if the date
entered isn't later than 6 months from now. I have an Active Link with
the following qualification:

'my_date_field'  $DATE$ + 182

This doesn't work.

'my_date_field'  $DATE$ works just fine. As soon as I try to add any
number the $DATE$ variable it stops working.

Why?


Mark


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

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


Re: Carriage Return

2008-10-27 Thread Trevino, Rick
Gary, thanks I will try that
Rick


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L CTR USAF AFMC 72
CS/SCBAH
Sent: Monday, October 27, 2008 10:27 AM
To: arslist@ARSLIST.ORG
Subject: Re: Carriage Return

You will need to expand the window by clicking on the elipses (...).

Whenever the box is expanded, do your set fields or whatever:

Value: $Field$ + 
 + $Field$ + 



If you put in an opening double quote, then hit enter, it will return to
the next line, and then add your closing double quote. Whenever you
close the expanded window, the single line version, instead of showing
the new lines, will show a non printable solid block character.

Thanks,

Gary Opela, Jr.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Trevino, Rick
Sent: Monday, October 27, 2008 10:24 AM
To: arslist@ARSLIST.ORG
Subject: Carriage Return

** 

Hello,

Does anyone know how to use a carriage return included in a value.

Example:

 

Field name: 

Value :field + $field name$ + would like carriage return then $field
Name$ + $field name$

 

Data

 

Field

Field

Field

 

Version7.0.1

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


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

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


Re: Adding days to a Date field in a qualification doesn't work

2008-10-27 Thread Rockwell, Rocky
What I use is $DATE$ + (60*60*24*182) in stead of the big long can't remember 
integer. That way I can see what I am adding.


Rocky
 
Rocky Rockwell
Remedy Application Designer
Wk Phone: 214-567-8874
Cell: 214-663-7229
[EMAIL PROTECTED]
-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Tanner, Doug
Sent: Monday, October 27, 2008 10:18 AM
To: arslist@ARSLIST.ORG
Subject: Re: Adding days to a Date field in a qualification doesn't work

Try

'my_date_field'  ($DATE$ + 15724800)

Humor me
Doug

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Milke
Sent: Monday, October 27, 2008 11:08 AM
To: arslist@ARSLIST.ORG
Subject: Re: Adding days to a Date field in a qualification doesn't work

 'my_date_field'  ($DATE$ + 182)
 so that it will add 182 to the date before doing the compare?

Yes, that's exactly what I did.

Mark


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


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

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



Re: Adding days to a Date field in a qualification doesn't work

2008-10-27 Thread Thomas Bean
Yes, that should work.

Although the $DATE$ keyword can be used for both Date and Date/Time fields, 
using an arithmetic operation against the keyword seems to force it to 
translate into a date/time value (# of seconds instead of # of days) at the 
database level.  You can observe this by running a SQL log on the server.

  Search Qual in Advanced Search bar in WUT:
  'zDateField' = $DATE$

  Corresponding query in SQL log ($DATE$ keyword converted to current Date 
integer value - # of days since January 1, 4713 B.C.):
  SELECT TOP 2147483649 T535.C1,T535.C1 FROM T535 WHERE (T535.C536870947 = 
2454767) ORDER BY 1 ASC

  Search Qual in Advanced Search bar in WUT:
  'zDateField' = $DATE$ - 7

  Corresponding query in SQL log ($DATE$ keyword converted to current Date/Time 
integer value - # of seconds since January 1, 1970 12:00:00 AM GMT):
  SELECT TOP 2147483649 T535.C1,T535.C1 FROM T535 WHERE (T535.C536870947 = 
(1225083600 - 7)) ORDER BY 1 ASC

The environment I tested this on is ARS 7.0.1 with a SQL Server 2005 database.

--Thomas

  - Original Message - 
  From: LJ Longwing 
  Newsgroups: gmane.comp.crm.arsystem.general
  To: arslist@ARSLIST.ORG 
  Sent: Monday, October 27, 2008 10:28 AM
  Subject: Re: Adding days to a Date field in a qualification doesn't work


  Oh...I know why it's not workingbecause $DATE$ can be used for both Date
  and Date/Time fieldsand remedy probably does some dynamic stuff to the
  value when you are doing a compare with a date field...so what you may need
  to do is

  setfield ztmp_datefield = $DATE$
  setfield ztmp_datefield = +182 

  then in another filter my_date_field  ztmp_datefield

  I bet that would work

  -Original Message-
  From: Action Request System discussion list(ARSList)
  [mailto:[EMAIL PROTECTED] On Behalf Of Tanner, Doug
  Sent: Monday, October 27, 2008 9:18 AM
  To: arslist@ARSLIST.ORG
  Subject: Re: Adding days to a Date field in a qualification doesn't work

  Try

  'my_date_field'  ($DATE$ + 15724800)

  Humor me
  Doug

  -Original Message-
  From: Action Request System discussion list(ARSList)
  [mailto:[EMAIL PROTECTED] On Behalf Of Mark Milke
  Sent: Monday, October 27, 2008 11:08 AM
  To: arslist@ARSLIST.ORG
  Subject: Re: Adding days to a Date field in a qualification doesn't work

   'my_date_field'  ($DATE$ + 182)
   so that it will add 182 to the date before doing the compare?

  Yes, that's exactly what I did.

  Mark

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


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

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

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


JOB: Column Technologies seeking Senior Mid Level Remedy Consultants based in Dallas or Houston

2008-10-27 Thread Melissa Wish
We are seeking Mid and Senior level Remedy Consultants based in Texas-
preferably Houston or Dallas.

 

*These are permanent positions with generous salary, bonus, benefits and
vacation packages.  Senior Level Candidates must have ITSM implementation
experience.

 

If you're interested please email me your resume as a PDF or MS Word
document and we can coordinate a time to talk.

 

The job description is below.

You will be employed at Column Technologies as a Consulting Applications
Engineer to architect, deploy, support, and in some cases, train the Remedy
product to our growing nationwide customer base. Your responsibilities will
include but not limited to:

 

*Provide maintenance tips for BMC Remedy applications

*Configuration of BMC Remedy applications

*Customization of BMC Remedy applications

*Conduct Requirements Analysis sessions and customer workshops

*Provide solution designs based on requirements

*Scope and develop custom applications

*Provide system and customization documentation

*System troubleshooting

*Installation and configuration of all BMC Remedy applications

*Implement integrations to the BMC Remedy applications

*Assist the Frontline Support when not working on active projects

 

You will primarily serve our customers who are located in the southwest but
travel will be required based on project needs.

 

Thanks!

 

Melissa Wish 
Corporate Recruiter 
Column Technologies, Inc. 
Home Office: 718-399-2136 
Cell/Evenings: 917-748-7104 
E-Fax: 646-349-3799 
Email: [EMAIL PROTECTED] 
www.columnit.com 

BMC Remedy Partner of the Year 2000 - 2004  

BMC Solution Partner of the Year 2004 - 2006  

BMC Fastest Growing Worldwide Partner - 2006 

Inc. 500 Fastest Growing Private Companies - 2006 

BMC 2007 Americas and Worldwide Top Solution Provider

VARBusiness- North America's Largest 500 IT Solution Providers, 2007

 

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

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


Quick Question: RedHat with MS-SQL?

2008-10-27 Thread Herb Geozos
I think I already know the answer here based on the product compatibility
chart (no), but I have a customer who is a fairly adamant RedHat shop, but
at the same time their DB licensing is all MS-SQL. Is anybody out there
running this combo, and/or is it supported?

Many Thanks in Advance,
Herb Geozos

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


Re: Quick Question: RedHat with MS-SQL?

2008-10-27 Thread Matt Worsdell
They put Microsoft SQL on Redhat, I don't think so!


 I think I already know the answer here based on the product compatibility
 chart (no), but I have a customer who is a fairly adamant RedHat shop, but
 at the same time their DB licensing is all MS-SQL. Is anybody out there
 running this combo, and/or is it supported?

 Many Thanks in Advance,
 Herb Geozos

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


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


Re: Quick Question: RedHat with MS-SQL?

2008-10-27 Thread LJ Longwing
Due to the fact that Remedy uses 'native libraries' to connect to the DB,
and MS doesn't publish native libraries to connect to MS SQL, then Remedy
doesn't support that combination.

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Herb Geozos
Sent: Monday, October 27, 2008 10:01 AM
To: arslist@ARSLIST.ORG
Subject: Quick Question: RedHat with MS-SQL?


** I think I already know the answer here based on the product compatibility
chart (no), but I have a customer who is a fairly adamant RedHat shop, but
at the same time their DB licensing is all MS-SQL. Is anybody out there
running this combo, and/or is it supported? 
 
Many Thanks in Advance,
Herb Geozos __Platinum Sponsor: www.rmsportal.com ARSlist: Where the
Answers Are html___ 

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


Re: Adding days to a Date field in a qualification doesn't work

2008-10-27 Thread Thomas Bean
Frank,
This syntax will work if searching a Date/Time field, but it will not work with 
a Date (only) field.  The value on the right side of the qualification 
(($TIMESTAMP$ + (60*60*24*182)) would generate an integer value well beyond the 
range of the Date field type.  If you divided this value by 86400 (the # of 
seconds in a day) and then added the value 2440588 (the corresponding # of days 
for the DATE field type for January 1, 1970), this would theoretically work; 
however, adding these arithmetic operations to the search qualification with a 
Date field seems to generate an error in the client:

ARERR [313] Data types are not appropriate for relational operation
ARERR [312] Data types are not appropriate for arithmetic operation

So, LJ's method seems like the best (add an additional display-only DATE field, 
use the DATEADD function to add the offset from the $DATE$ keyword into the 
temp field, then use the temp field in place of the $DATE$ keyword in the 
original query against the DATE field).

--Thomas

  - Original Message - 
  From: Frank, Gordon M. (CMS/CTR) 
  Newsgroups: gmane.comp.crm.arsystem.general
  To: arslist@ARSLIST.ORG 
  Sent: Monday, October 27, 2008 10:40 AM
  Subject: Re: Adding days to a Date field in a qualification doesn't work


  An easy way to do this is to use the multipliers. You will also need to
  use $TIMESTAMP$

  'my_date_field'  ($TIMESTAMP$ + (60*60*24*182))

  $TIMESTAMP$ returns the number of seconds elapsed since midnight
  Coordinated Universal Time (UTC) of January 1, 1970. 

  Guess what platform Remedy ARS was first built upon? That's right UNIX.
  There used to be 3 clients. Anyone know what they were? Note: Remedy ARS
  was built before there was a Public Internet. Come to think of it, there
  may have been 4 clients at one time, but there may not have been one for
  IBM OS/2.

  When you do it this way, you can substitute a $variable or a number
  whenever you like.

  Gordon M. Frank
  Remedy Skilled Professional
  ITIL V3 Certified
  Lockheed Martin

  -Original Message-
  From: Action Request System discussion list(ARSList)
  [mailto:[EMAIL PROTECTED] On Behalf Of Mark Milke
  Sent: Monday, October 27, 2008 10:27 AM
  To: arslist@ARSLIST.ORG
  Subject: Adding days to a Date field in a qualification doesn't work

  Hi Listers,

  I have a date field on my form and I want to check, if the date
  entered isn't later than 6 months from now. I have an Active Link with
  the following qualification:

  'my_date_field'  $DATE$ + 182

  This doesn't work.

  'my_date_field'  $DATE$ works just fine. As soon as I try to add any
  number the $DATE$ variable it stops working.

  Why?


  Mark

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

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


Re: JOB: Column Technologies seeking Senior Mid Level Remedy Consultants based in Dallas or Houston

2008-10-27 Thread Drew Shuller
Melissa, are you getting any traction for these positions?

Drew

 We are seeking Mid and Senior level Remedy Consultants based in Texas-
 preferably Houston or Dallas.



 *These are permanent positions with generous salary, bonus, benefits and
 vacation packages.  Senior Level Candidates must have ITSM implementation
 experience.



 If you're interested please email me your resume as a PDF or MS Word
 document and we can coordinate a time to talk.



 The job description is below.

 You will be employed at Column Technologies as a Consulting Applications
 Engineer to architect, deploy, support, and in some cases, train the
 Remedy
 product to our growing nationwide customer base. Your responsibilities
 will
 include but not limited to:



 *Provide maintenance tips for BMC Remedy applications

 *Configuration of BMC Remedy applications

 *Customization of BMC Remedy applications

 *Conduct Requirements Analysis sessions and customer workshops

 *Provide solution designs based on requirements

 *Scope and develop custom applications

 *Provide system and customization documentation

 *System troubleshooting

 *Installation and configuration of all BMC Remedy applications

 *Implement integrations to the BMC Remedy applications

 *Assist the Frontline Support when not working on active projects



 You will primarily serve our customers who are located in the southwest
 but
 travel will be required based on project needs.



 Thanks!



 Melissa Wish
 Corporate Recruiter
 Column Technologies, Inc.
 Home Office: 718-399-2136
 Cell/Evenings: 917-748-7104
 E-Fax: 646-349-3799
 Email: [EMAIL PROTECTED]
 www.columnit.com

 BMC Remedy Partner of the Year 2000 - 2004

 BMC Solution Partner of the Year 2004 - 2006

 BMC Fastest Growing Worldwide Partner - 2006

 Inc. 500 Fastest Growing Private Companies - 2006

 BMC 2007 Americas and Worldwide Top Solution Provider

 VARBusiness- North America's Largest 500 IT Solution Providers, 2007



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

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


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


Re: V.Urgent: How Incident/Change License works, how can we manage releasing

2008-10-27 Thread Easter, David
What version of ITSM are you on?  The answer differs depending on the version.
 
For ITSM 6.0 or previous, application licenses were not formally tracked during 
operation.
 
For ITSM 7.0 and above, applications licenses are processed and enforced by the 
server using the same logic as the AR System user licenses.
 
 
-David J. Easter
Sr. Product Manager, Solution Strategy and Development
BMC Software, Inc.
 
The opinions, statements, and/or suggested courses of action expressed in this 
E-mail do not necessarily reflect those of BMC Software, Inc.  My voluntary 
participation in this forum is not intended to convey a role as a spokesperson, 
liaison or public relations representative for BMC Software, Inc.



From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Manish SINGLA
Sent: Monday, October 27, 2008 1:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: V.Urgent: How Incident/Change License works, how can we manage 
releasing


** 
Hello Cheerio, Robert,
 
Thanks for the quick response.
 
I have extracted aruser.log but couldn't find segregated license for 
Helpdesk(Incident management) and Change Management.
 
Aruser.log give only one consolidated picture of aruser licenses in use.
 
Please advice some thing else can be used.
 
Thanks again for the reply.
Regards
Manish



From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of [EMAIL PROTECTED]
Sent: Monday, October 27, 2008 12:38 PM
To: arslist@ARSLIST.ORG
Subject: Re: V.Urgent: How Incident/Change License works, how can we manage 
releasing


** 
Hello Manish, 

have no hands on experience on ITSM, but the user.log file should be a good 
starting point. 
Depending on your version, you can turn it on at the admin or user client, at 
the server-log settings. 

We do some license monitoring/opimization based on that log file, down to the 
user. 

Don't want to advertise, but you could also invest in a tool for that: 
www.rrr.se 

They basically also take the user.log file and report on that. Just that they 
do all for you, 
so you dont have to build a report/logic you own ... from what I know, they can 
also 
report ITSM (so I assume, the ITSM licenses are also shown at the user.log 
file). 


Other then that, you have not provided much infos about how you have done 
your current studies. Did you use the log file, or just check the available 
licenses? 

Based on that, we perhaps can help further :-) 


Cheerio, Robert 


Ps. yes, I think BMC should be way more helpful, in providing further help for 
optimized 
license allocation ... but hey, its a business :-) 


Mit freundlichen Grüßen/Best regards
Robert Kern

Corporate Infrastructure IT Operations - Service Integration - Service Desk
IT CI OP SI SD
Continental Automotive GmbH
Sodener Strasse 9, 65824 Schwalbach, Germany

Telefon/Phone: +49 6196872546
Telefax: +49 619 687792546
E-Mail: [EMAIL PROTECTED]
www.continental-corporation.com
__
Continental Automotive GmbH, Siemensstr. 12, 93055 Regensburg, Germany
Geschäftsführer/Managing Directors: Helmut Matschi, Gérard Cordonnier, Harald 
Stuhlmann
Sitz der Gesellschaft/Registered office: Hannover
Registergericht/Commercial registry: Hannover, HRB 59424, USt-Id. Nr. 
DE814950663
___
Proprietary and confidential. Distribution only by express authority of 
Continental AG or its
subsidiaries. 



Manish SINGLA [EMAIL PROTECTED] 
Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 

27.10.2008 07:58 
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG 
cc
Subject
V.Urgent: How Incident/Change License works, how can we manage releasing






** 
Hello  List, 
  
We are growing with our customer base from Remedy utilization in side ST, with 
which our incident and Change support people are growing. 
Now we need to estimate the utilization of Helpdesk and Change management 
Floating license utilization, so that we could plan what to buy more. 
  
From our current study of floating license utilization, we can find out that 
ARUser license get assigned to the user (profiled APP Support with AR Floating 
license) as soon as he logon to Remedy application and remains with user till 
he logout from the application. Or License time out can be another possibility 
of license release back to license pool. (Please challenge if i am wrong 
analyzing) 
  
Now the license utilization and handling of Incident/change management license 
in black box for us. Now we have some queries for your quick expected reply: 
1. We couldn't find any OOTB thing that could give me current Incident/Change 
management license utilization. Please advice if any. 
2. Please suggest when the Remedy allocates Helpdesk/change floating license to 
a user: 
2.1 When 

Active Link Function in an Escalation???

2008-10-27 Thread Pruitt, Christopher J
Hello Fellow Listers,

Does anyone know a way to mimic the Active Link functions within an
Escalation?

I am trying to find a way to do the following to create log entries, on
a UNIX server, that have a unique timestamp. These logs turn on and off
every day. These logs are created via a SET FIELDS action into the field
'escalationlogfile' on the AR System Administration: Server
Information form. We are able to turn the log on and off at defined
times.

Currently we are using Escalation_ + REPLACE(DATE($DATE$),  /,  ))
+  .log and it crates a log file with the name Escalation_102708.log

However, we would like to name the file Escalation_20081027.log so that
it is in the format MMDD. We have tried this command but it does not
work.
Escalation_ + YEAR($TIMESTAMP$)) + MONTH($TIMESTAMP$)) +
DAY($TIMESTAMP$) +  .log

I can't use $TIMESTAMP$ and that is not a valid UNIX file name, meaning
the file name comes across as Escalation_10/27/288 12:00:00 PM.log,
which is not valid.

Any help would be appreciated.



Christopher Pruitt 
EDS, an HP Company
mailto: [EMAIL PROTECTED]

We deliver on our commitments
so you can deliver on yours.

Confidentiality Notice: This message and any files transmitted with it
are intended for the sole use of the entity or individual to whom it is
addressed, and may contain information that is confidential, privileged,
and exempt from disclosure under applicable law. If you are not the
intended addressee for this e-mail, you are hereby notified that any
copying, distribution, or dissemination of this e-mail is strictly
prohibited. If you have received this e-mail in error, please
immediately destroy, erase, or discard this message. Please notify the
sender immediately by return e-mail if you have received this e-mail by
mistake.


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Drew Shuller
Sent: Monday, October 27, 2008 12:43 PM
To: arslist@ARSLIST.ORG
Subject: Re: JOB: Column Technologies seeking Senior  Mid Level Remedy
Consultants based in Dallas or Houston
Importance: High

Melissa, are you getting any traction for these positions?

Drew

 We are seeking Mid and Senior level Remedy Consultants based in Texas-

 preferably Houston or Dallas.



 *These are permanent positions with generous salary, bonus, benefits 
 and vacation packages.  Senior Level Candidates must have ITSM 
 implementation experience.



 If you're interested please email me your resume as a PDF or MS Word 
 document and we can coordinate a time to talk.



 The job description is below.

 You will be employed at Column Technologies as a Consulting 
 Applications Engineer to architect, deploy, support, and in some 
 cases, train the Remedy product to our growing nationwide customer 
 base. Your responsibilities will include but not limited to:



 *Provide maintenance tips for BMC Remedy applications

 *Configuration of BMC Remedy applications

 *Customization of BMC Remedy applications

 *Conduct Requirements Analysis sessions and customer workshops

 *Provide solution designs based on requirements

 *Scope and develop custom applications

 *Provide system and customization documentation

 *System troubleshooting

 *Installation and configuration of all BMC Remedy applications

 *Implement integrations to the BMC Remedy applications

 *Assist the Frontline Support when not working on active projects



 You will primarily serve our customers who are located in the 
 southwest but travel will be required based on project needs.



 Thanks!



 Melissa Wish
 Corporate Recruiter
 Column Technologies, Inc.
 Home Office: 718-399-2136
 Cell/Evenings: 917-748-7104
 E-Fax: 646-349-3799
 Email: [EMAIL PROTECTED]
 www.columnit.com

 BMC Remedy Partner of the Year 2000 - 2004

 BMC Solution Partner of the Year 2004 - 2006

 BMC Fastest Growing Worldwide Partner - 2006

 Inc. 500 Fastest Growing Private Companies - 2006

 BMC 2007 Americas and Worldwide Top Solution Provider

 VARBusiness- North America's Largest 500 IT Solution Providers, 2007



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

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



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

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

Re: Active Link Function in an Escalation???

2008-10-27 Thread Joe DeSouza
Chris,

Have you tried replacing the invalid characters to either null or an underscore 
or something?

Joe



- Original Message 
From: Pruitt, Christopher J [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, October 27, 2008 2:13:37 PM
Subject: Active Link Function in an Escalation???

Hello Fellow Listers,

Does anyone know a way to mimic the Active Link functions within an Escalation?

I am trying to find a way to do the following to create log entries, on a UNIX 
server, that have a unique timestamp. These logs turn on and off every day. 
These logs are created via a SET FIELDS action into the field 
'escalationlogfile' on the AR System Administration: Server Information form. 
We are able to turn the log on and off at defined times.

Currently we are using Escalation_ + REPLACE(DATE($DATE$),  /,  )) +  
.log and it crates a log file with the name Escalation_102708.log

However, we would like to name the file Escalation_20081027.log so that it is 
in the format MMDD. We have tried this command but it does not work.
Escalation_ + YEAR($TIMESTAMP$)) + MONTH($TIMESTAMP$)) + DAY($TIMESTAMP$) +  
.log

I can't use $TIMESTAMP$ and that is not a valid UNIX file name, meaning the 
file name comes across as Escalation_10/27/288 12:00:00 PM.log,
which is not valid.

Any help would be appreciated.



Christopher Pruitt 
EDS, an HP Company
mailto: [EMAIL PROTECTED]

We deliver on our commitments
so you can deliver on yours.

Confidentiality Notice: This message and any files transmitted with it are 
intended for the sole use of the entity or individual to whom it is addressed, 
and may contain information that is confidential, privileged, and exempt from 
disclosure under applicable law. If you are not the intended addressee for this 
e-mail, you are hereby notified that any copying, distribution, or 
dissemination of this e-mail is strictly prohibited. If you have received this 
e-mail in error, please immediately destroy, erase, or discard this message. 
Please notify the sender immediately by return e-mail if you have received this 
e-mail by mistake.


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Drew Shuller
Sent: Monday, October 27, 2008 12:43 PM
To: arslist@ARSLIST.ORG
Subject: Re: JOB: Column Technologies seeking Senior  Mid Level Remedy
Consultants based in Dallas or Houston
Importance: High

Melissa, are you getting any traction for these positions?

Drew

 We are seeking Mid and Senior level Remedy Consultants based in Texas-

 preferably Houston or Dallas.



 *These are permanent positions with generous salary, bonus, benefits 
 and vacation packages.  Senior Level Candidates must have ITSM 
 implementation experience.



 If you're interested please email me your resume as a PDF or MS Word 
 document and we can coordinate a time to talk.



 The job description is below.

 You will be employed at Column Technologies as a Consulting 
 Applications Engineer to architect, deploy, support, and in some 
 cases, train the Remedy product to our growing nationwide customer 
 base. Your responsibilities will include but not limited to:



 *Provide maintenance tips for BMC Remedy applications

 *Configuration of BMC Remedy applications

 *Customization of BMC Remedy applications

 *Conduct Requirements Analysis sessions and customer workshops

 *Provide solution designs based on requirements

 *Scope and develop custom applications

 *Provide system and customization documentation

 *System troubleshooting

 *Installation and configuration of all BMC Remedy applications

 *Implement integrations to the BMC Remedy applications

 *Assist the Frontline Support when not working on active projects



 You will primarily serve our customers who are located in the 
 southwest but travel will be required based on project needs.



 Thanks!



 Melissa Wish
 Corporate Recruiter
 Column Technologies, Inc.
 Home Office: 718-399-2136
 Cell/Evenings: 917-748-7104
 E-Fax: 646-349-3799
 Email: [EMAIL PROTECTED]
 www.columnit.com

 BMC Remedy Partner of the Year 2000 - 2004

 BMC Solution Partner of the Year 2004 - 2006

 BMC Fastest Growing Worldwide Partner - 2006

 Inc. 500 Fastest Growing Private Companies - 2006

 BMC 2007 Americas and Worldwide Top Solution Provider

 VARBusiness- North America's Largest 500 IT Solution Providers, 2007




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

Re: Adding days to a Date field in a qualification doesn't work

2008-10-27 Thread Joe DeSouza
Mark,

Even if that did work, it wouldn't be always accurate, considering leap years 
or the 2 consecutive months that we have 30 days.

Why not try string manupulation, by setting the current value contained in the 
date field, to a character field and then find the month position and extract 
the month part of the string, set that to a display only integer field, add 6 
to it, and reconstruct the date string.. Consider the exception for when you 
will need to add up the year part if the month part is greater than 6.

Also create exceptions for the month of February to handle leap years.

Might be tricky but you will end up with a more accurate result..

Cheers

Joe






From: Mark Milke [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, October 27, 2008 10:27:04 AM
Subject: Adding days to a Date field in a qualification doesn't work

Hi Listers,

I have a date field on my form and I want to check, if the date entered isn't 
later than 6 months from now. I have an Active Link with the following 
qualification:

'my_date_field'  $DATE$ + 182

This doesn't work.

'my_date_field'  $DATE$ works just fine. As soon as I try to add any number 
the $DATE$ variable it stops working.

Why?


Mark



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

Re: Active Link Function in an Escalation???

2008-10-27 Thread Pruitt, Christopher J
Yes, but it still does not get us to the MMDD format we need. We can
get DDMMYY at best so far.
 

Christopher Pruitt
EDS, an HP Company
mailto: [EMAIL PROTECTED] 

We deliver on our commitments 
so you can deliver on yours. 

Confidentiality Notice: This message and any files transmitted with it
are intended for the sole use of the entity or individual to whom it is
addressed, and may contain information that is confidential, privileged,
and exempt from disclosure under applicable law. If you are not the
intended addressee for this e-mail, you are hereby notified that any
copying, distribution, or dissemination of this e-mail is strictly
prohibited. If you have received this e-mail in error, please
immediately destroy, erase, or discard this message. Please notify the
sender immediately by return e-mail if you have received this e-mail by
mistake.

 




From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza
Sent: Monday, October 27, 2008 3:49 PM
To: arslist@ARSLIST.ORG
Subject: Re: Active Link Function in an Escalation???


** 
Chris,
 
Have you tried replacing the invalid characters to either null
or an underscore or something?
 
Joe


- Original Message 
From: Pruitt, Christopher J [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, October 27, 2008 2:13:37 PM
Subject: Active Link Function in an Escalation???

Hello Fellow Listers,

Does anyone know a way to mimic the Active Link functions within
an Escalation?

I am trying to find a way to do the following to create log
entries, on a UNIX server, that have a unique timestamp. These logs turn
on and off every day. These logs are created via a SET FIELDS action
into the field 'escalationlogfile' on the AR System Administration:
Server Information form. We are able to turn the log on and off at
defined times.

Currently we are using Escalation_ + REPLACE(DATE($DATE$),
/,  )) +  .log and it crates a log file with the name
Escalation_102708.log

However, we would like to name the file Escalation_20081027.log
so that it is in the format MMDD. We have tried this command but it
does not work.
Escalation_ + YEAR($TIMESTAMP$)) + MONTH($TIMESTAMP$)) +
DAY($TIMESTAMP$) +  .log

I can't use $TIMESTAMP$ and that is not a valid UNIX file name,
meaning the file name comes across as Escalation_10/27/288 12:00:00
PM.log,
which is not valid.

Any help would be appreciated.



Christopher Pruitt 
EDS, an HP Company
mailto: [EMAIL PROTECTED]

We deliver on our commitments
so you can deliver on yours.

Confidentiality Notice: This message and any files transmitted
with it are intended for the sole use of the entity or individual to
whom it is addressed, and may contain information that is confidential,
privileged, and exempt from disclosure under applicable law. If you are
not the intended addressee for this e-mail, you are hereby notified that
any copying, distribution, or dissemination of this e-mail is strictly
prohibited. If you have received this e-mail in error, please
immediately destroy, erase, or discard this message. Please notify the
sender immediately by return e-mail if you have received this e-mail by
mistake.


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Drew Shuller
Sent: Monday, October 27, 2008 12:43 PM
To: arslist@ARSLIST.ORG
Subject: Re: JOB: Column Technologies seeking Senior  Mid Level
Remedy
Consultants based in Dallas or Houston
Importance: High

Melissa, are you getting any traction for these positions?

Drew

 We are seeking Mid and Senior level Remedy Consultants based
in Texas-

 preferably Houston or Dallas.



 *These are permanent positions with generous salary, bonus,
benefits 
 and vacation packages.  Senior Level Candidates must have ITSM

 implementation experience.



 If you're interested please email me your resume as a PDF or
MS Word 
 document and we can coordinate a time to talk.



 The job description is below.

 You will be employed at Column Technologies as a Consulting 
 Applications Engineer to architect, deploy, support, and in
some 
 cases, train the Remedy product to our growing nationwide
customer 
 base. Your responsibilities will include but not limited to:



 

Re: Active Link Function in an Escalation???

2008-10-27 Thread Grooms, Frederick W
What kind of error are you getting using TIMESTAMP?
 
I have used the DAY, MONTH, and YEAR functions in set fields before with
no problems (Except having to use LPAD as well).
Escalation_ + LPAD(YEAR($TIMESTAMP$),4,2000) +
LPAD(MONTH($TIMESTAMP$),2,00) + LPAD(DAY($TIMESTAMP$),2,00) +
.log

Fred



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Pruitt, Christopher J
Sent: Monday, October 27, 2008 4:00 PM
To: arslist@ARSLIST.ORG
Subject: Re: Active Link Function in an Escalation???


** 
Yes, but it still does not get us to the MMDD format we need. We can
get DDMMYY at best so far.
 

Christopher Pruitt
EDS, an HP Company
mailto: [EMAIL PROTECTED] 

We deliver on our commitments 
so you can deliver on yours. 

Confidentiality Notice: This message and any files transmitted with it
are intended for the sole use of the entity or individual to whom it is
addressed, and may contain information that is confidential, privileged,
and exempt from disclosure under applicable law. If you are not the
intended addressee for this e-mail, you are hereby notified that any
copying, distribution, or dissemination of this e-mail is strictly
prohibited. If you have received this e-mail in error, please
immediately destroy, erase, or discard this message. Please notify the
sender immediately by return e-mail if you have received this e-mail by
mistake.

 




From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza
Sent: Monday, October 27, 2008 3:49 PM
To: arslist@ARSLIST.ORG
Subject: Re: Active Link Function in an Escalation???


** 
Chris,
 
Have you tried replacing the invalid characters to either null
or an underscore or something?
 
Joe


- Original Message 
From: Pruitt, Christopher J [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, October 27, 2008 2:13:37 PM
Subject: Active Link Function in an Escalation???

Hello Fellow Listers,

Does anyone know a way to mimic the Active Link functions within
an Escalation?

I am trying to find a way to do the following to create log
entries, on a UNIX server, that have a unique timestamp. These logs turn
on and off every day. These logs are created via a SET FIELDS action
into the field 'escalationlogfile' on the AR System Administration:
Server Information form. We are able to turn the log on and off at
defined times.

Currently we are using Escalation_ + REPLACE(DATE($DATE$),
/,  )) +  .log and it crates a log file with the name
Escalation_102708.log

However, we would like to name the file Escalation_20081027.log
so that it is in the format MMDD. We have tried this command but it
does not work.
Escalation_ + YEAR($TIMESTAMP$)) + MONTH($TIMESTAMP$)) +
DAY($TIMESTAMP$) +  .log

I can't use $TIMESTAMP$ and that is not a valid UNIX file name,
meaning the file name comes across as Escalation_10/27/288 12:00:00
PM.log,
which is not valid.

Any help would be appreciated.



Christopher Pruitt 
EDS, an HP Company
mailto: [EMAIL PROTECTED]

We deliver on our commitments
so you can deliver on yours.

Confidentiality Notice: This message and any files transmitted
with it are intended for the sole use of the entity or individual to
whom it is addressed, and may contain information that is confidential,
privileged, and exempt from disclosure under applicable law. If you are
not the intended addressee for this e-mail, you are hereby notified that
any copying, distribution, or dissemination of this e-mail is strictly
prohibited. If you have received this e-mail in error, please
immediately destroy, erase, or discard this message. Please notify the
sender immediately by return e-mail if you have received this e-mail by
mistake.
 
 

 
 

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


Re: Active Link Function in an Escalation???

2008-10-27 Thread Whaley, David G (Contractor)
If you are just trying to create a log file you can use the unix date
command to achieve this.  Going from memory here but you could use a run
process action, and a command that looks like this, 
 
mv your_escalationfile.log `date +escalation_%Y%m%d.log`
 
David
 


From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza
Sent: Monday, October 27, 2008 3:49 PM
To: arslist@ARSLIST.ORG
Subject: Re: Active Link Function in an Escalation???


** 
Chris,
 
Have you tried replacing the invalid characters to either null or an
underscore or something?
 
Joe


- Original Message 
From: Pruitt, Christopher J [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, October 27, 2008 2:13:37 PM
Subject: Active Link Function in an Escalation???

Hello Fellow Listers,

Does anyone know a way to mimic the Active Link functions within an
Escalation?

I am trying to find a way to do the following to create log entries, on
a UNIX server, that have a unique timestamp. These logs turn on and off
every day. These logs are created via a SET FIELDS action into the field
'escalationlogfile' on the AR System Administration: Server
Information form. We are able to turn the log on and off at defined
times.

Currently we are using Escalation_ + REPLACE(DATE($DATE$),  /,  ))
+  .log and it crates a log file with the name Escalation_102708.log

However, we would like to name the file Escalation_20081027.log so that
it is in the format MMDD. We have tried this command but it does not
work.
Escalation_ + YEAR($TIMESTAMP$)) + MONTH($TIMESTAMP$)) +
DAY($TIMESTAMP$) +  .log

I can't use $TIMESTAMP$ and that is not a valid UNIX file name, meaning
the file name comes across as Escalation_10/27/288 12:00:00 PM.log,
which is not valid.

Any help would be appreciated.



Christopher Pruitt 
EDS, an HP Company
mailto: [EMAIL PROTECTED]

We deliver on our commitments
so you can deliver on yours.

Confidentiality Notice: This message and any files transmitted with it
are intended for the sole use of the entity or individual to whom it is
addressed, and may contain information that is confidential, privileged,
and exempt from disclosure under applicable law. If you are not the
intended addressee for this e-mail, you are hereby notified that any
copying, distribution, or dissemination of this e-mail is strictly
prohibited. If you have received this e-mail in error, please
immediately destroy, erase, or discard this message. Please notify the
sender immediately by return e-mail if you have received this e-mail by
mistake.


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Drew Shuller
Sent: Monday, October 27, 2008 12:43 PM
To: arslist@ARSLIST.ORG
Subject: Re: JOB: Column Technologies seeking Senior  Mid Level Remedy
Consultants based in Dallas or Houston
Importance: High

Melissa, are you getting any traction for these positions?

Drew

 We are seeking Mid and Senior level Remedy Consultants based in Texas-

 preferably Houston or Dallas.



 *These are permanent positions with generous salary, bonus, benefits 
 and vacation packages.  Senior Level Candidates must have ITSM 
 implementation experience.



 If you're interested please email me your resume as a PDF or MS Word 
 document and we can coordinate a time to talk.



 The job description is below.

 You will be employed at Column Technologies as a Consulting 
 Applications Engineer to architect, deploy, support, and in some 
 cases, train the Remedy product to our growing nationwide customer 
 base. Your responsibilities will include but not limited to:



 *Provide maintenance tips for BMC Remedy applications

 *Configuration of BMC Remedy applications

 *Customization of BMC Remedy applications

 *Conduct Requirements Analysis sessions and customer workshops

 *Provide solution designs based on requirements

 *Scope and develop custom applications

 *Provide system and customization documentation

 *System troubleshooting

 *Installation and configuration of all BMC Remedy applications

 *Implement integrations to the BMC Remedy applications

 *Assist the Frontline Support when not working on active projects



 You will primarily serve our customers who are located in the 
 southwest but travel will be required based on project needs.



 Thanks!



 Melissa Wish
 Corporate Recruiter
 Column Technologies, Inc.
 Home Office: 718-399-2136
 Cell/Evenings: 917-748-7104
 E-Fax: 646-349-3799
 Email: [EMAIL PROTECTED]
 www.columnit.com http://www.columnit.com/ 

 BMC Remedy Partner of the Year 2000 - 2004

 BMC Solution Partner of the Year 2004 - 2006

 BMC Fastest Growing Worldwide Partner - 2006

 Inc. 500 Fastest Growing Private Companies - 2006

 BMC 2007 Americas and Worldwide Top Solution Provider

 VARBusiness- North America's Largest 500 IT Solution Providers, 2007

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

JOB: Senior Remedy Developer; Sydney/Australia; 6 Month Contract

2008-10-27 Thread Gareth Oliver
My friend is relisting the job I posted recently, this time as a
contract position. Ideally the person would already has working rights
in Australia, but the client will sponsor.

Lynne's contact details are at the end. No consulting/recruitment
organisations, this time please.



===

My client is looking for a senior Remedy Developer for an initial 6
month contract.

Job Purpose: 
*   To offer wide-ranging expertise in various stages of the Remedy
system design life cycle and  to participate in IT projects as required.


Outcomes (Key Result Areas) 
*   Remedy Fault Management System (FMS) development and maintenance


Duties and Responsibilities: 
* To understand the market place, in which the company trades,
and to thereby anticipate and be aware of current and future business
needs. 
*   To participate in the analysis (including process mapping),
design and implementation of new functionality within the Remedy Fault
Management System to meet business needs. 
*   To liaise with many levels of staff on potential business
problems and solutions. 
*   Intranet / Internet, design and implementation of Customer Views
of fault information. 

Personal Specification: 
*   Degree level qualification in Information Technology preferred
or an ability to demonstrate knowledge to an equivalent level 
*   Superior demonstrable technical skills in the Remedy Action
Request System with at least two years experience in both Developer and
Support roles. 
*   Previous experience in developing and maintaining large real
time operational support systems is required. 
*   Superior demonstrable technical skills in the Solaris and
Windows environments. 
*   Superior interpersonal skills are essential, as is the ability
to work closely with colleagues and customers at all levels as either a
leader or a member of a team and, when necessary, on an individual
basis. 

The team there has some very professional Remedy developers in it
already. People like working for this company. They have a very healthy
respect for their staff. 

My client will pay AU$800/day for a top quality Remedy Developer with at
least 5 years experience. 

Contact Lynne Fox now to register your interest in this excellent
contracting role! 

Kind regards
Lynne Fox 
[EMAIL PROTECTED]
SENIOR CONSULTANT - FINITE IT RECRUITMENT SOLUTIONS
LEVEL 31, AUSTRALIA SQUARE, 264-278 GEORGE STREET, SYDNEY, NSW 2000
TEL +61 02 8243 6868   FAX +61 02 8243 6866   DIRECT +61 02 8243 6818
MOBILE +61 0419 012 195  WWW.FINITE.COM.AU

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


Re: Data - For Server Events

2008-10-27 Thread John


OK -- so I finally looked into ar.h (per Axton) to figure out what the  
form 'server events' is telling me.



However -- I still don't quite know how to interpret the info provided.

Has anybody actually used the Server Events with success? And - what  
did you do?


Here is what I have in my 'server events' table

Event Type, Event Cause, Event Date, Event Details1 ,2,3
1,8,10/27/2008 11:36:49 AM, JDS-Test
1,8,10/27/2008 11:36:49 AM, JDS-Test
2,14,10/27/2008 11:36:53 AM, 536870913;Field1
2,14,10/27/2008 11:36:53 AM, 536870914;Field2



So -- oddly enough -- I have 2 entries for what appear to be modifying  
a form.


Then 1 entry for each of the 2 fields I created.



So -- parsing the first line -- I am assuming the

1,8,10/27/2008 11:36:49 AM, JDS-Test

1 = AR_SVR_EVENT_CHG_SCHEMA -- which is fine

8 = ???

Date is obvious

JDS-Test -- the name of the table I created



then the next interesting line

2,14,10/27/2008 11:36:53 AM, 536870913;Field1

2 = AR_SVR_EVENT_CHG_FIELD

14 = ???

Date is obvious

536870913;Field1 -- the field I created.



So -- what is 'Event Cause' -- and does that info exist in ar.h -- I  
could not find it.




Thanks in advance.



-John




#define AR_SVR_EVENT_CHG_SCHEMA1
#define AR_SVR_EVENT_CHG_FIELD 2
#define AR_SVR_EVENT_CHG_CHARMENU  3
#define AR_SVR_EVENT_CHG_FILTER4
#define AR_SVR_EVENT_CHG_IMPORT5
#define AR_SVR_EVENT_CHG_ACTLINK   6
#define AR_SVR_EVENT_CHG_ESCAL 7
#define AR_SVR_EVENT_CHG_VUI   8
#define AR_SVR_EVENT_CHG_CONTAINER 9
#define AR_SVR_EVENT_CHG_USERS 10
#define AR_SVR_EVENT_CHG_GROUPS11
#define AR_SVR_EVENT_CHG_SVR_SETTINGS  12
#define AR_SVR_EVENT_CHG_ALERT_USERS   13
#define AR_SVR_EVENT_ARCHIVE_DONE  14
#define AR_SVR_EVENT_SERVGROUP_ACTION  15
#define AR_SVR_EVENT_CHG_LICENSES  16
#define AR_SVR_EVENT_USER_ADDED0
#define AR_SVR_EVENT_USER_MODIFIED 1
#define AR_SVR_EVENT_USER_DELETED  2
#define AR_SVR_EVENT_GROUP_ADDED  0
#define AR_SVR_EVENT_GROUP_MODIFIED   1
#define AR_SVR_EVENT_GROUP_DELETED2
#define AR_SVR_EVENT_COMPGROUP_ADDED  3
#define AR_SVR_EVENT_COMPGROUP_MODIFIED   4
#define AR_SVR_EVENT_COMPGROUP_DELETED5
#define AR_SVR_EVENT_APPLICATION_ADDED6
#define AR_SVR_EVENT_APPLICATION_MODIFIED 7
#define AR_SVR_EVENT_APPLICATION_DELETED  8
#define AR_SVR_EVENT_ROLE_ADDED   9
#define AR_SVR_EVENT_ROLE_MODIFIED10
#define AR_SVR_EVENT_ROLE_DELETED 11
#define AR_SVR_EVENT_ARCHIVE_FORM 1
#define AR_SVR_EVENT_ARCHIVE_DELETE   2
#define AR_SVR_EVENT_ARCHIVE_FORM_DELETE  3
#define AR_SVR_EVENT_ARCHIVE_XML  4
#define AR_SVR_EVENT_ARCHIVE_ARX  5
#define AR_SVR_EVENT_SERVGROUP_FAILOVER   1
#define AR_SVR_EVENT_SERVGROUP_RELINQUISH 2
#define AR_SVR_EVENT_SERVGROUP_TAKEOVER   3
#define AR_SVR_EVENT_IMPORT_SET_OBJECT 0
#define AR_SVR_EVENT_IMPORT_CREATE_OBJECT  1


--
John David Sundberg
235 East 6th Street, Suite 400B
St. Paul, MN 55101
(651) 556-0930-work
(651) 247-6766-cell
(651) 695-8577-fax
[EMAIL PROTECTED]

On Mar 27, 2008, at 1:52 PM, Axton wrote:

** 
http://arswiki.org/projects/arapi/browser/trunk/7.1/solaris/include/ar.h#L5095

Axton Grams

On Thu, Mar 27, 2008 at 2:36 PM, Tanner, Doug [EMAIL PROTECTED] 
 wrote:

**
Does anyone have (and is willing to share) the data mapping (Elements)  
for the Server Events (Event Type  Event Cause)



(Example Below)


Event Type – 1  Creating Form

Event Cause -1  Creating Form


Event Type – 2  Creating Field

Event Cause -0  Creating Field


Thanks, Doug


Doug Tanner

Senior Developer

Remedy Skilled Professional (RSP)

(704) 328-3178

[EMAIL PROTECTED]



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


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



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


LOB Space Reclaim Issue

2008-10-27 Thread Do Duy
Hi,

 

I just wanted to find out if anyone has had this problem and possibly
how the issue was resolved.

 

Details of the problem is below.

 

Thank you in advance,

 

Duy Do

Broadcast Australia

 

Database Version

 

Database is on Oracle 10G 10.2.0.2.0 Standard Edition on Sun Solaris.

 

Operation done

 

Database is growing, so after the deletes in Development database, we
tried Space reclaim of the tables containing LOB segments by running
'alter table table_name enable row movement' and 'alter table table_name
shrink space cascade'. Space Reclaim was successful.

 

Observed Problem

 

But after that, the read access to the database Lobs gave ORA-1555
Snapshot too old error messsage.

 

Patch Apply

 

Found  Applied Patch 5636728 which was to address FALSE ORA-1555 WHEN
READING LOBS AFTER SHRINK, but it didn't help.

 

Later Steps

 

Finally, we had to restore the original Dev database from the backup.

 

Fortunately this test was done on the Development database with the
intention of doing it on Production later.

 

Currently the DB is on Oracle 10.2.0.2.0, latest patchset 10.2.0.4 will
be applied at some point in time as per the compatibility with the
Application.

 

But the patch 5636728, which was to address false Ora-1555 after LOB
shrink, was applied successfully. But the ORA-1555 problem remained.

 

Error showed up when Action Remedy application tried to access the data
after the LOB space shrink.

 

Even export gave the same error.

 

The Original Dev database as per before the Space shrink was restored
from the backup.

 

 

Frequency of the error

 

Consistently

 

Impact to the Business 

 

Production database is growing and we need to be able to reclaim space .

 

We still have the problematic database copy with the LOBs shrunk, so any
diagnostic scripts or actions as advised can be run there.

 


**

  IMPORTANT NOTICE
This email and any attachments may be confidential and/or 
privileged, in which case neither is intended to be waived. If 
received in error, please contact us and delete all copies. Before 
opening or using attachments, check them for viruses and defects. 
Our liability is limited to resupplying any affected attachments.


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


Mark Boyle is out of the office.

2008-10-27 Thread Mark Boyle

I will be out of the office starting  28/10/2008 and will not return until
29/10/2008.

I will respond to your message when I return.

- 
IMPORTANT NOTICE : The information in this email is confidential and may also 
be privileged. If you are not the intended recipient, any use or dissemination 
of the information and any disclosure or copying of this email is unauthorised 
and strictly prohibited. If you have received this email in error, please 
promptly inform us by reply email or telephone. You should also delete this 
email and destroy any hard copies produced.

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