Re: Anybody running their prod system on VMWARE?

[Louise Van Hine]

As far as I am aware, VMWare platforms are considered "partially supported" by 
BMC, and last I spoke with them about it, do not recommend VMWare for 
production systems because they may not be able to assist with a problem that 
is based in VMWare rather than ARSystem.

However, that being said, an architect I have worked with recently who knows a 
lot about the underlying architecture of VMWare says that it wouldn't be an 
issue if you spec the right hardware, memory etc.  Which is sort of what Rick's 
saying here.

--- On Mon, 8/24/09, Rick Cook  wrote:

From: Rick Cook 
Subject: Re: Anybody running their prod system on VMWARE?
To: arslist@ARSLIST.ORG
Date: Monday, August 24, 2009, 6:38 PM

** Anybody running their prod system on VMWARE?Jack,

Fwiw, I see a growing percentage of installations on virtual platforms these 
days. They need a bit more RAM than a physical counterpart, but I know of no 
other significant issues. 
RickFrom:  "Covert, Jack" 
Date: Mon, 24 Aug 2009 15:20:13 -0700
To: 
Subject: Anybody running their prod system on VMWARE?
 How well is it performing?  How many users are you supporting?  Are you using 
it for all servers, the database, app or web?  Any issues w/ BMC support?  
Doing some homework, thanks for your help. Jack Covert Corporate IT Remedy 
Support Team
 Remedy Support Team Home Page http://collaborate.mckesson.com/sites/esm/remedy
 Remedy Q&A Sessions on Thursdays @ 10:30 AM PT Details on Remedy Support Team 
Home Page  _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the 
Answers Are"_ 




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Anybody running their prod system on VMWARE?

[Webster, Basil]

Hi Jack,

 

We are using VMWare to run our applications machine. It is ESX Ver3.5
and our organization is shortly going to upgrade to 4. This version
allows more resource allocation in terms of CPU and RAM. Currently we
have 4 x CPU and 4GB RAM and have 65 fixed and 80 floating licenses
allocated of which, at peak, around 90% of both are concurrent. We
elected to run our db cluster as physical machines. Reason being that
our guys doing the VM install and support were not confident that the
fail over would be as quick and stable. Also, I am able to allocate 15gb
of RAM to my db immediately. Our ITSM installation is new and the db is
small at this point as we have only been running for 4 months, logging
around 15,000 per month at this point.

 

Virtual is a great concept but if not setup \ administered correctly,
you can have issues. We found out the hard way that the vm environment
was over committed and when one of the hosts went down, the others could
not take up the guests and our server died. The support had to do some
smart shuffling to get us running again, so check these type of things.
Also, networks can play havoc with the vm environment because internally
the system runs on a networking system and our entire vm environment
went down when the network guys took down the network for maintenance. 

 

Under normal circumstances, she runs fine, she is quick.

 

 

Kind Regards,

Basil Webster

Remedy Developer


Siemens Southern Africa

IT Solutions and Services (Pty) Ltd

Infrastructure Operations

300 Janadel Avenue, Halfway House, 1685

T : +27 11 652 7523
F : +27 86 506 2883
M : +27 82 452 9389
basil.webs...@siemens.com  
www.siemens.co.za



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Covert, Jack
Sent: Tuesday, August 25, 2009 12:20 AM
To: arslist@ARSLIST.ORG
Subject: Anybody running their prod system on VMWARE?

 

How well is it performing?  How many users are you supporting?  Are you
using it for all servers, the database, app or web?  Any issues w/ BMC
support?

Doing some homework, thanks for your help.

Jack Covert

Corporate IT

Remedy Support Team

Remedy Support Team Home Page

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

Remedy Q&A Sessions on Thursdays @ 10:30 AM PT

Details on Remedy Support Team Home Page

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_



Disclaimer and Confidentiality Note

This e-mail communication, its attachments, if any, and any rights attaching to 
it are,
unless the context clearly indicates otherwise, the property of Siemens 
Limited. 
It is confidential, private and intended for the addressee only. 
If you are not the intended recipient and receive this communication in error, 
you are hereby notified that any review, copying, use, discloser or 
distribution in any manner whatsoever is strictly prohibited.
Please notify the sender immediately that you have received this e-mail in 
error and delete the e-mail and any copies of it.
Views and opinions expressed in this e-mail are those of the sender unless 
clearly stated as those of Siemens Limited. 
Siemens Limited accepts no liability for any loss or damage whatsoever, and 
howsoever incurred or suffered resulting or arising from 
the use of this e-mail communication and/or its attachments.

Siemens Limited does not warrant the integrity of this e-mail communication nor 
that it is free of errors, viruses, interception or interference.

For more information about Siemens Limited, visit our website at www.siemens.com

Siemens Limited
Company Registration Number: 1923/007514/06
Registered Address: 300 Janadel Avenue, Halfway House 1685
VAT Registration Number: 4790104428
Chairman:  Dr S Russwurm*; Deputy Chairman: Dr ATM Mokgokong
Chief Executive Officer: SJ Clarkson; Chief Financial Officer: AD Hall
Executive Directors: HA Hollier, AM Mathole
Non-Executive Director: D Hoke*; Dr MI Surve; K Setzin
Alternate Director: R Guntermann*; I Amod; Y Mahomed
Company Secretary: V Reddy

*German

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Anybody running their prod system on VMWARE?

[Jason Miller]

Our production is ARS 7.5 (Help Desk 6 and many custom apps) running in Win
2008 64bit, 4gb of RAM on an ESX server.  The db server is a separate
physical box.  In our case we have noticed improved performance because our
DB and ARS server were on the same box previously.  Now the db server alone
is bigger than our old app/db server and is allows to take up most of the
RAM.  We recently went with the blue pricing so we no longer have to pay per
ARS server if we want to split up the various functions as we head towards
ITSM 7 (AIE, Reconciliation, etc).

At our peak times we have about 115 floating users and about 20 fixed
connected.  Most of our users are currently using WUT but we are building
two 2008 VM web servers to added to our existing physical one.  We are
starting to prepare for when the that WUT is gone and starting to transition
more of our apps to the web as well as we can take advantage of the new 7.5
features that do not work in the WUT.

The only issue with support has been that BMC does not support WUT on a 2008
server (we had some issues with it hanging the Windows UI).  We had an issue
with licensing the server because the hostid (MAC address) that ARS reports
changes after each reboot cause the license to become invalid.  On this
issue, where ARS is supported on 2008, the support was excellent.  I got the
impression that they had not had many virtualized 7.5 / Win 2008 calls at
that time but there was no kick back what so ever.

HTH,
Jason

On Mon, Aug 24, 2009 at 3:20 PM, Covert, Jack wrote:

> **
>
> How well is it performing?  How many users are you supporting?  Are you
> using it for all servers, the database, app or web?  Any issues w/ BMC
> support?
>
> Doing some homework, thanks for your help.
>
> Jack Covert**
>
> *Corporate IT*
>
> *Remedy Support Team*
>
> *Remedy Support Team Home Page*
>
> *http://collaborate.mckesson.com/sites/esm/remedy*
>
> ***Remedy Q&A Sessions on Thursdays @ 10:30 AM PT*
>
> ***Details on Remedy Support Team Home Page*
>
>  _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Anybody running their prod system on VMWARE?

[Rick Cook]

Jack,

Fwiw, I see a growing percentage of installations on virtual platforms these 
days. They need a bit more RAM than a physical counterpart, but I know of no 
other significant issues. 

Rick

-Original Message-
From: "Covert, Jack" 

Date: Mon, 24 Aug 2009 15:20:13 
To: 
Subject: Anybody running their prod system on VMWARE?


How well is it performing?  How many users are you supporting?  Are you
using it for all servers, the database, app or web?  Any issues w/ BMC
support?

Doing some homework, thanks for your help.

Jack Covert

Corporate IT

Remedy Support Team


Remedy Support Team Home Page

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


Remedy Q&A Sessions on Thursdays @ 10:30 AM PT

Details on Remedy Support Team Home Page


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Anybody running their prod system on VMWARE?

[Covert, Jack]

How well is it performing?  How many users are you supporting?  Are you
using it for all servers, the database, app or web?  Any issues w/ BMC
support?

Doing some homework, thanks for your help.

Jack Covert

Corporate IT

Remedy Support Team


Remedy Support Team Home Page

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


Remedy Q&A Sessions on Thursdays @ 10:30 AM PT

Details on Remedy Support Team Home Page


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Weird Unicode error in remedy when querying AD via the LDAP and a vendor form

[Lyle Taylor]

That's right - I forgot about that that was the case with 6.3 (my time with 6.3 
was limited - fortunately...).  Thanks for the correction, Axton.

Lyle

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Axton
Sent: Monday, August 24, 2009 3:07 PM
To: arslist@ARSLIST.ORG
Subject: Re: Weird Unicode error in remedy when querying AD via the LDAP and a 
vendor form

** 6.3 does not support multiple localizations; back then a separate arserver 
was required for each localization set, though every localization set supported 
english.

This may not even be a case of Unicode data.  You can get garbage like that 
when applications perform illegal memory operations.  Take a network dump of 
the ldap communication, examine all the data sent back to remedy, see if 
anything being sent exceeds the limits that Remedy supports (email address, 
login name, password, group list, notification method, etc.).  If this is the 
case, the only recourse you really have is to upgrade the plugin, play with the 
available config parameters to avoid the data causing the issue, or write your 
own ldap area plugin.

The libumem slab allocator on Solaris makes it easy to identify these types of 
memory issues... Not sure what options, if any, are available on Windows.  
Maybe someone can enlighten me.

Axton Grams

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.
On Mon, Aug 24, 2009 at 11:38 AM, Lyle Taylor 
mailto:tayl...@ldschurch.org>> wrote:
**

I don't have an answer for Gary's question, but wanted to point out that you 
shouldn't need to install a foreign language pack in order to handle foreign 
characters.  Remedy's ability to handle foreign characters depends entirely on 
it being set up for Unicode.



However, Gary, does this happen with any (e.g., all, most, some) record, or 
just a specific one?  What kind of field is it querying in AD?



Lyle



From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Meyer, 
Jennifer L
Sent: Monday, August 24, 2009 10:00 AM
To: arslist@ARSLIST.ORG
Subject: Re: Weird Unicode error in remedy when querying AD via the LDAP and a 
vendor form



**

Does the user's name perhaps contain a character that Remedy can't read?  For 
example, if you have installed the English language pack, but not the Japanese 
language pack, and the user has a Japanese character in his or her name, an 
error of this sort might occur.



Jennifer Meyer

Remedy Technical Support Specialist

State of North Carolina

Office of Information Technology Services

Service Delivery Division ITSM & ITAM Services

Office: 919-754-6543

ITS Service Desk: 919-754-6000

jennifer.me...@its.nc.gov

http://its.state.nc.us



E-mail correspondence to and from this address may be subject to the North 
Carolina Public Records Law and may be disclosed to third parties only by an 
authorized State Official.



From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Opela, 
Gary L CTR USAF AFMC 72 CS/SCBAH
Sent: Monday, August 24, 2009 11:48 AM
To: arslist@ARSLIST.ORG
Subject: Weird Unicode error in remedy when querying AD via the LDAP and a 
vendor form



ARERR [9062] Error encountered during string conversion from Unicode : string 
;yêÇÕáB¬b Ûã=·Ø



Remedy 6.3 (no patch)

Windows/Sql Server



Has anyone seen the above error message when querying AD? Is there a fix that 
doesn't involve patching?



It only happens on some accounts, but on those accounts that it happens, it 
happens every time for those accounts.





Thanks,



Gary Opela, Jr.

Sr. Remedy Engineer

Avaya Phone Admin

RSP Cert, Sec+

405 739 7006 x30043



_Platinum Sponsor: rmisoluti...@verizon.net 
ARSlist: "Where the Answers Are"__Platinum Sponsor: 
rmisoluti...@verizon.net ARSlist: "Where the 
Answers Are"_


NOTICE: This email message is for the sole use of the intended recipient(s) and 
may contain confidential and privileged information. Any unauthorized review, 
use, disclosure or distribution is prohibited. If you are not the intended 
recipient, please contact the sender by reply email and destroy all copies of 
the original message.
_Platinum Sponsor: rmisoluti...@verizon.net 
ARSlist: "Where the Answers Are"_

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or acce

Re: Weird Unicode error in remedy when querying AD via the LDAP and a vendor form

[Axton]

6.3 does not support multiple localizations; back then a separate arserver
was required for each localization set, though every localization set
supported english.

This may not even be a case of Unicode data.  You can get garbage like that
when applications perform illegal memory operations.  Take a network dump of
the ldap communication, examine all the data sent back to remedy, see if
anything being sent exceeds the limits that Remedy supports (email address,
login name, password, group list, notification method, etc.).  If this is
the case, the only recourse you really have is to upgrade the plugin, play
with the available config parameters to avoid the data causing the issue, or
write your own ldap area plugin.

The libumem slab allocator on Solaris makes it easy to identify these types
of memory issues... Not sure what options, if any, are available on
Windows.  Maybe someone can enlighten me.

Axton Grams

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.

On Mon, Aug 24, 2009 at 11:38 AM, Lyle Taylor  wrote:

> **
>
> I don’t have an answer for Gary’s question, but wanted to point out that
> you shouldn’t need to install a foreign language pack in order to handle
> foreign characters.  Remedy’s ability to handle foreign characters depends
> entirely on it being set up for Unicode.
>
>
>
> However, *Gary*, does this happen with any (e.g., all, most, some) record,
> or just a specific one?  What kind of field is it querying in AD?
>
>
>
> Lyle
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arsl...@arslist.org] *On Behalf Of *Meyer, Jennifer L
> *Sent:* Monday, August 24, 2009 10:00 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: Weird Unicode error in remedy when querying AD via the LDAP
> and a vendor form
>
>
>
> **
>
> Does the user’s name perhaps contain a character that Remedy can’t read?
>  For example, if you have installed the English language pack, but not the
> Japanese language pack, and the user has a Japanese character in his or her
> name, an error of this sort might occur.
>
>
>
> Jennifer Meyer
>
> Remedy Technical Support Specialist
>
> State of North Carolina
>
> Office of Information Technology Services
>
> Service Delivery Division ITSM & ITAM Services
>
> Office: 919-754-6543
>
> ITS Service Desk: 919-754-6000
>
> jennifer.me...@its.nc.gov
>
> http://its.state.nc.us
>
>
>
> E-mail correspondence to and from this address may be subject to the North
> Carolina Public Records Law and may be disclosed to third parties only by an
> authorized State Official.
>   --
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arsl...@arslist.org] *On Behalf Of *Opela, Gary L CTR USAF AFMC 72
> CS/SCBAH
> *Sent:* Monday, August 24, 2009 11:48 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Weird Unicode error in remedy when querying AD via the LDAP and
> a vendor form
>
>
>
> ARERR [9062] Error encountered during string conversion from Unicode :
> string ;yêÇÕáB¬b Ûã=·Ø
>
>
>
> Remedy 6.3 (no patch)
>
> Windows/Sql Server
>
>
>
> Has anyone seen the above error message when querying AD? Is there a fix
> that doesn’t involve patching?
>
>
>
> It only happens on some accounts, but on those accounts that it happens, it
> happens every time for those accounts.
>
>
>
>
>
> Thanks,
>
>
>
> Gary Opela, Jr.
>
> Sr. Remedy Engineer
>
> Avaya Phone Admin
>
> RSP Cert, Sec+
>
> 405 739 7006 x30043
>
>
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"__Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the
> Answers Are"_
>
>
>
> NOTICE: This email message is for the sole use of the intended recipient(s)
> and may contain confidential and privileged information. Any unauthorized
> review, use, disclosure or distribution is prohibited. If you are not the
> intended recipient, please contact the sender by reply email and destroy all
> copies of the original message.
>  _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Opportunity in Columbus, OH

[dcharters]

Is this AEP or Chase? I am asking because I have already been submutted to 
those 2. By the way sorry for the psoting to the ars list, I hit reply and 
ran. Too busy sometimes i guess:)


On Mon, 24 Aug 2009 13:42:25 -0400, Leah George wrote
> Please email me at lgeo...@everesttech.com or you can reach me at 
> 614-436-3120 (292) for all questions.
> 
> Thanks
> Leah
> 
> >
> >
> > On Mon, 24 Aug 2009 13:37:46 -0400, Leah George wrote
> >   
> >> Dear All,
> >>
> >> One of the clients I work with is looking for couple remedy 
> >> developers for their location in* Columbus, OH for 6 months 
> >> contract. 100% on site and the rate is $40 1099/CTC*
> >>
> >> ARS 6.3 server - Must have
> >> ARS Midtier 6x or better - Must have
> >> Demonstrated experience in a designing/building totally custom 
> >> remedy applications. - Must have Enterprise/Global application 
> >> design principles. - Must have Solaris 10 - ability to use not admin 
> >> Oracle 10g - ability to use not admin Scripting with PL/SQL, Java, 
> >> or Perl/ARSPerl - At least one would be preferred.
> >>
> >> You can email me at lgeo...@everesttecg.com with subject : *Remedy 
> >> Developer - Columbus, OH
> >>
> >> Thanks
> >> Leah
> >> *
> >>
> >>
> >> 
> > 
__
> > _
> >   
> >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> >> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the 
> >> Answers Are"
> >> 
> >
> >
> > --
> > Open WebMail Project (http://openwebmail.org)
> >
> > 
__
_
> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
> >
> 
> 
__
_
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the 
> Answers Are"


--
Open WebMail Project (http://openwebmail.org)

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Opportunity in Columbus, OH

[Leah George]

Dear All,

One of the clients I work with is looking for couple remedy developers for
their location in* Columbus, OH for 6 months contract. 100% on site and the
rate is $40 1099/CTC*

ARS 6.3 server - Must have
ARS Midtier 6x or better - Must have
Demonstrated experience in a designing/building totally custom remedy
applications. - Must have Enterprise/Global application design principles. -
Must have Solaris 10 - ability to use not admin Oracle 10g - ability to use
not admin Scripting with PL/SQL, Java, or Perl/ARSPerl - At least one would
be preferred.

You can email me at lgeo...@everesttech.com with subject : *Remedy Developer
- Columbus, OH

Thanks
Leah

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Opportunity in Columbus, OH

[Leah George]

Please email me at lgeo...@everesttech.com or you can reach me at 
614-436-3120 (292) for all questions.


Thanks
Leah




On Mon, 24 Aug 2009 13:37:46 -0400, Leah George wrote
  

Dear All,

One of the clients I work with is looking for couple remedy 
developers for their location in* Columbus, OH for 6 months 
contract. 100% on site and the rate is $40 1099/CTC*


ARS 6.3 server - Must have
ARS Midtier 6x or better - Must have
Demonstrated experience in a designing/building totally custom 
remedy applications. - Must have Enterprise/Global application 
design principles. - Must have Solaris 10 - ability to use not admin 
Oracle 10g - ability to use not admin Scripting with PL/SQL, Java, 
or Perl/ARSPerl - At least one would be preferred.


You can email me at lgeo...@everesttecg.com with subject : *Remedy 
Developer - Columbus, OH


Thanks
Leah
*




__
_
  

UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the 
Answers Are"




--
Open WebMail Project (http://openwebmail.org)

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
  


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Opportunity in Columbus, OH

[dcharters]

Is this AEP of Chase?


On Mon, 24 Aug 2009 13:37:46 -0400, Leah George wrote
> Dear All,
> 
> One of the clients I work with is looking for couple remedy 
> developers for their location in* Columbus, OH for 6 months 
> contract. 100% on site and the rate is $40 1099/CTC*
> 
> ARS 6.3 server - Must have
> ARS Midtier 6x or better - Must have
> Demonstrated experience in a designing/building totally custom 
> remedy applications. - Must have Enterprise/Global application 
> design principles. - Must have Solaris 10 - ability to use not admin 
> Oracle 10g - ability to use not admin Scripting with PL/SQL, Java, 
> or Perl/ARSPerl - At least one would be preferred.
> 
> You can email me at lgeo...@everesttecg.com with subject : *Remedy 
> Developer - Columbus, OH
> 
> Thanks
> Leah
> *
> 
> 
__
_
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the 
> Answers Are"


--
Open WebMail Project (http://openwebmail.org)

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Opportunity in Columbus, OH

[Leah George]

Dear All,

One of the clients I work with is looking for couple remedy developers 
for their location in* Columbus, OH for 6 months contract. 100% on site 
and the rate is $40 1099/CTC*


ARS 6.3 server - Must have
ARS Midtier 6x or better - Must have
Demonstrated experience in a designing/building totally custom remedy 
applications. - Must have

Enterprise/Global application design principles. - Must have
Solaris 10 - ability to use not admin
Oracle 10g - ability to use not admin
Scripting with PL/SQL, Java, or Perl/ARSPerl - At least one would be 
preferred.


You can email me at lgeo...@everesttecg.com with subject : *Remedy 
Developer - Columbus, OH


Thanks
Leah
*

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Date Time Conversion Issue in Remedy

[Mark Milke]

OK, I think I got it:

SELECT FROM_EPOCH(outage_time) FROM troubleticket where tt_nr_ =
'0001691614';

Thanks,
Mark

On 24 Aug., 18:06, "Grooms, Frederick W" 
wrote:
> Oracle 9i (and higher) functions for Date Time conversion
>
> Change 'US/Central' to the time zone of your database.  The Oracle functions 
> will automatically perform the correct DST corrections (as long as you have 
> the Oracle DST patches installed in the database)
>
> CREATE OR REPLACE FUNCTION FROM_EPOCH (secs IN NUMBER)
>   RETURN DATE
> IS
>   lDate DATE;
> BEGIN
>   lDate := (From_TZ((TO_DATE('01/01/1970', 'dd/mm/')+(secs/86400)),'GMT') 
> AT TIME ZONE 'US/Central');
>   RETURN lDate;
> END From_Epoch;
> /
>
> CREATE OR REPLACE FUNCTION TO_EPOCH (lDate IN DATE)
>    RETURN NUMBER
> IS
>    Seconds NUMBER;
>    dte1 TIMESTAMP;
>    dte2 TIMESTAMP;
> BEGIN
>    dte1 := new_time(lDate, to_char( from_tz(cast (lDate as timestamp), 
> 'US/Central'),'TZD'),'GMT');
>    dte2 := TO_TIMESTAMP_TZ('01/01/1970 '|| TZ_Offset('Greenwich'), 
> 'MM/DD/ TZH:TZM');
>    Seconds := (((dte1-0) - (dte2-0)) * 86400);
>    RETURN Seconds;
> END To_Epoch;
> /
>
> Fred
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Frank Caruso
> Sent: Monday, August 24, 2009 10:32 AM
> To: arsl...@arslist.org
> Subject: Re: Date Time Conversion Issue in Remedy
>
> You will need to handle this in code. Add logic that figures out
> whether you are in DST or out of DST and then add or subtract the
> offset. I do not believe that there is any built in function in Oracle
> that will do this for you. I have done this in the past and had to
> create conditional statements that contained each years DST start and
> being dates. I think if you search the ARSList you will find examples
> of how do this.
>
> On Mon, Aug 24, 2009 at 6:17 PM, Mark Milke wrote:
> > Hi David,
>
> > I have a question here. I've tried the following:
>
> > SELECT TO_CHAR(TO_DATE('01/01/1970 00:00:00 GMT', 'DD.MM.
> > HH24:MI:SS') + ((outage_time + 3600)/(60*60*24)),'DD.MM.
> > HH24:MI:SS') FROM trouble_ticket where tt_nr_ = '0001234567';
>
> > and it works just fine.
>
> > However depending on what my outage_time is, I'm getting a wrong
> > result, because of the time zone esp. summer and winter time. Where to
> > put time zone information here or how to deal with this issue at all?
>
> > Thanks,
> > Mark
>
> > On 18 Aug., 21:02, David Morgan  wrote:
> >> Hi Lisa
>
> >> The database reference guide has the information for going from EPOCH
> >> date to the date in a format you require (in 6.3 it was p.54 - see below
> >> signature)
> >>         SELECT TO_CHAR(TO_DATE('01/01/1970 00:00:00', 'MM/DD/
> >> HH24:MI:SS') +
> >>                                         ((C +
> >> )/(60*60*24)),'MM/DD/ HH24:MI:SS') FROM T;
>
> >> Going the other way (subtract epoch from current stamp to get difference
> >> in seconds)
>
> >>         selectto_date('2008-07-16','-mm-dd') 
> >> -to_date('1970-01-01','-mm-dd') from dual
>
> >> regards
> >> Dave Morgan
>
> >> -Original Message-
> >> From: Action Request System discussion list(ARSList)
>
> >> [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa
> >> Sent: 18 August 2009 18:24
> >> To: arsl...@arslist.org
> >> Subject: Re: Date Time Conversion Issue in Remedy
>
> >> --_000_46CDC1E68702E54387E9EAEDC0A02CA207C87BF0C5us194mx002tyc_
> >> Content-Type: text/plain; charset="us-ascii"
> >> Content-Transfer-Encoding: quoted-printable
>
> >> I think this is the function to convert FROM Epoch to a readable
> >> date/time =
> >> format.  I need the other way around...
>
> >> Thanks!
>
> >> Lisa
>
> >> 
> >> From: Action Request System discussion list(ARSList)
> >> [mailto:arsl...@arslis=
> >> T.ORG] On Behalf Of Cesaro, Tony M[EQ]
> >> Sent: Tuesday, August 18, 2009 1:01 PM
> >> To: arsl...@arslist.org
> >> Subject: Re: Date Time Conversion Issue in Remedy
>
> >> **
> >> Lisa,
>
> >> We ended up writing an Oracle function to generate the conversion for
> >> us.  =
> >> I have included the SQL source below.  You'll obviously want to change
> >> your=
> >>  time zone and input date format accordingly.
>
> >> create or replace FUNCTION GETDATE (a_number number)
> >>  RETURN Date IS
> >>    date_x date;
>
> >> BEGIN
> >>   if a_number is null then
> >>      return null;
> >>   else
> >>      date_x :=3D new_time(TO_DATE('01/01/1970 00:00:00',
> >> 'MM/DD/HH24:MI=
> >> :SS') + (a_number/86400),'GMT','EDT');
> >>   end if;
> >> RETURN(date_x);
> >> END GetDate;
>
> >> Regards,
>
> >> Tony Cesaro
>
> >> From: Action Request System discussion list(ARSList)
> >> [mailto:arsl...@arslis=
> >> T.ORG] On Behalf Of Kemes, Lisa
> >> Sent: Tuesday, August 18, 2009 12:52
> >> To: arsl...@arslist.org
> >> Subject: Re: Date Time Conversion Issue in Remedy
>
> >> **
> >> I'm having a similar issues (details are a little bit different), but
> >> ho

Re: Functional Group usage (long post)

[Lyle Taylor]

It sounds like you're trying to define functional roles kind of like what you 
have with ITSM (sorry, I keep going back to that).  There, you've got 
permissions that get added to your profile, but then you can also have roles 
within a support group that give you additional "permissions" or functionality 
within the system.  In that case, you may have Remedy permissions that allow 
you to submit and edit records (kind of like your A1_Change group), but then 
based on your role within a support group, you can enabled or disable certain 
functionality in the application.

In your case, perhaps you could maintain conceptual groups - these groups don't 
correspond to Remedy permission groups, they just define what functionality you 
want to be available to users.  Users can then be added to and removed from 
these conceptual groups by someone in the Maintainer "group".  As users use the 
application, you would check whether they belong to certain groups and disable 
or enable functionality when forms load and/or when they attempt to take 
certain actions.  For example, you build everything pretty much just like you 
would for the person that has all permissions, and then selectively remove or 
disable functionality that JoeUser doesn't have as forms are viewed by that 
person.

Does that make sense?  In that case, you still only have the one Remedy 
permission group, and you're free to define more groups as you see fit without 
causing server recaching, etc.  The catch is that as you add groups, you still 
need to add logic to take those into account.  I don't know if there's an easy 
way around that, though.  If you wanted to make adding groups and defining 
their functional abilities both configurable, that starts getting pretty 
complex...

Lyle

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Reiser, John J
Sent: Friday, August 21, 2009 6:51 AM
To: arslist@ARSLIST.ORG
Subject: Re: Functional Group usage (long post)

Lyle,

I was going in that direction at first but I backed off of manipulating
the User form. I already have 235 groups and most of them are for
notification purposes. I was hoping to avoid adding more groups that
would just be for notification and "reporting" roles. If I get this
working I should be able to eliminate some of the Groups for other
applications and use this format.

I only need one (1) group to permit changes (A1_Change) on the
application. So any new user will get their account created with
A1_Change permissions. When the customer needs to add a new functional
group (Procurement) the Maintainer can create the pseudo-group in the
permissions form and pull in the new employee to that functional group.
They could then select check boxes for Create , Change or Maintain
depending on what they want that permission group to do.  
If we use additional ARS Groups they will need to wait for an ARS Admin
to create the group, set up the workflow and add it to the proper table
for the Maintainers to have access.

I'm just trying to off load the tasks that can be better maintained by
some one closer to the business process and reduce the amount of
unnecessary Groups for the system to cache.
Am I complicating things?
Is there a point when there are too many Groups?

Thanks,

--- 
John J. Reiser 
Senior Software Development Analyst 
Remedy Administrator/Developer 
Lockheed Martin - MS2 
The star that burns twice as bright burns half as long. 
Pay close attention and be illuminated by its brilliance. - paraphrased
by me 
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Thursday, August 20, 2009 6:16 PM
To: arslist@ARSLIST.ORG
Subject: Re: Functional Group usage (long post)

If I'm understand you correctly, and you're primarily wondering about
how to give Maintainers the ability to move people into and out of the
four groups, this may not be too difficult.  If you use filters to
update the User form (you shouldn't have to have anyone update the Group
form, since you'll create the 4 groups as an Administrator, and they
shouldn't change once created unless you add more functional groups to
your list), then you don't need to give the Maintainers Administrator
privileges.

You could take an approach similar to how ITSM handles it.  There is a
form that stores the ITSM-related permissions that users have been
granted and a form for maintaining those permissions (you could do it
all on one form, if you wanted to).  Changes made to the form that
stores their permissions trigger filters that make the appropriate
updates to the User form, adding and removing them from the appropriate
Remedy group.  For example, if you add CS permissions to JoeUser in your
form, it would trigger a filter that adds that to the Groups list on the
User form.

Then, your main problem is just limiting access to that form to people
with Maintainer permissions, or l

Re: Date Time Conversion Issue in Remedy

[Mark Milke]

Hi Fred,

thanks for this valueable input.

Can you please enlight me how to connect this with my:

SELECT TO_CHAR(TO_DATE('01/01/1970 00:00:00 GMT', 'DD.MM.
HH24:MI:SS') + ((outage_time + 3600)/(60*60*24)),'DD.MM.
HH24:MI:SS') FROM trouble_ticket where tt_nr_ = '0001234567';

Basically I need to run a query that will show the correct time of the
outage, correct i.e. in the right time zone and DST corrected .


Thanks,
Mark



On 24 Aug., 18:06, "Grooms, Frederick W" 
wrote:
> Oracle 9i (and higher) functions for Date Time conversion
>
> Change 'US/Central' to the time zone of your database.  The Oracle functions 
> will automatically perform the correct DST corrections (as long as you have 
> the Oracle DST patches installed in the database)
>
> CREATE OR REPLACE FUNCTION FROM_EPOCH (secs IN NUMBER)
>   RETURN DATE
> IS
>   lDate DATE;
> BEGIN
>   lDate := (From_TZ((TO_DATE('01/01/1970', 'dd/mm/')+(secs/86400)),'GMT') 
> AT TIME ZONE 'US/Central');
>   RETURN lDate;
> END From_Epoch;
> /
>
> CREATE OR REPLACE FUNCTION TO_EPOCH (lDate IN DATE)
>    RETURN NUMBER
> IS
>    Seconds NUMBER;
>    dte1 TIMESTAMP;
>    dte2 TIMESTAMP;
> BEGIN
>    dte1 := new_time(lDate, to_char( from_tz(cast (lDate as timestamp), 
> 'US/Central'),'TZD'),'GMT');
>    dte2 := TO_TIMESTAMP_TZ('01/01/1970 '|| TZ_Offset('Greenwich'), 
> 'MM/DD/ TZH:TZM');
>    Seconds := (((dte1-0) - (dte2-0)) * 86400);
>    RETURN Seconds;
> END To_Epoch;
> /
>
> Fred
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Frank Caruso
> Sent: Monday, August 24, 2009 10:32 AM
> To: arsl...@arslist.org
> Subject: Re: Date Time Conversion Issue in Remedy
>
> You will need to handle this in code. Add logic that figures out
> whether you are in DST or out of DST and then add or subtract the
> offset. I do not believe that there is any built in function in Oracle
> that will do this for you. I have done this in the past and had to
> create conditional statements that contained each years DST start and
> being dates. I think if you search the ARSList you will find examples
> of how do this.
>
> On Mon, Aug 24, 2009 at 6:17 PM, Mark Milke wrote:
> > Hi David,
>
> > I have a question here. I've tried the following:
>
> > SELECT TO_CHAR(TO_DATE('01/01/1970 00:00:00 GMT', 'DD.MM.
> > HH24:MI:SS') + ((outage_time + 3600)/(60*60*24)),'DD.MM.
> > HH24:MI:SS') FROM trouble_ticket where tt_nr_ = '0001234567';
>
> > and it works just fine.
>
> > However depending on what my outage_time is, I'm getting a wrong
> > result, because of the time zone esp. summer and winter time. Where to
> > put time zone information here or how to deal with this issue at all?
>
> > Thanks,
> > Mark
>
> > On 18 Aug., 21:02, David Morgan  wrote:
> >> Hi Lisa
>
> >> The database reference guide has the information for going from EPOCH
> >> date to the date in a format you require (in 6.3 it was p.54 - see below
> >> signature)
> >>         SELECT TO_CHAR(TO_DATE('01/01/1970 00:00:00', 'MM/DD/
> >> HH24:MI:SS') +
> >>                                         ((C +
> >> )/(60*60*24)),'MM/DD/ HH24:MI:SS') FROM T;
>
> >> Going the other way (subtract epoch from current stamp to get difference
> >> in seconds)
>
> >>         selectto_date('2008-07-16','-mm-dd') 
> >> -to_date('1970-01-01','-mm-dd') from dual
>
> >> regards
> >> Dave Morgan
>
> >> -Original Message-
> >> From: Action Request System discussion list(ARSList)
>
> >> [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa
> >> Sent: 18 August 2009 18:24
> >> To: arsl...@arslist.org
> >> Subject: Re: Date Time Conversion Issue in Remedy
>
> >> --_000_46CDC1E68702E54387E9EAEDC0A02CA207C87BF0C5us194mx002tyc_
> >> Content-Type: text/plain; charset="us-ascii"
> >> Content-Transfer-Encoding: quoted-printable
>
> >> I think this is the function to convert FROM Epoch to a readable
> >> date/time =
> >> format.  I need the other way around...
>
> >> Thanks!
>
> >> Lisa
>
> >> 
> >> From: Action Request System discussion list(ARSList)
> >> [mailto:arsl...@arslis=
> >> T.ORG] On Behalf Of Cesaro, Tony M[EQ]
> >> Sent: Tuesday, August 18, 2009 1:01 PM
> >> To: arsl...@arslist.org
> >> Subject: Re: Date Time Conversion Issue in Remedy
>
> >> **
> >> Lisa,
>
> >> We ended up writing an Oracle function to generate the conversion for
> >> us.  =
> >> I have included the SQL source below.  You'll obviously want to change
> >> your=
> >>  time zone and input date format accordingly.
>
> >> create or replace FUNCTION GETDATE (a_number number)
> >>  RETURN Date IS
> >>    date_x date;
>
> >> BEGIN
> >>   if a_number is null then
> >>      return null;
> >>   else
> >>      date_x :=3D new_time(TO_DATE('01/01/1970 00:00:00',
> >> 'MM/DD/HH24:MI=
> >> :SS') + (a_number/86400),'GMT','EDT');
> >>   end if;
> >> RETURN(date_x);
> >> END GetDate;
>
> >> Regards,
>
> >> Tony Cesaro
>
> >> From: Action Re

Re: Weird Unicode error in remedy when querying AD via the LDAP and a vendor form

[Lyle Taylor]

I don't have an answer for Gary's question, but wanted to point out that you 
shouldn't need to install a foreign language pack in order to handle foreign 
characters.  Remedy's ability to handle foreign characters depends entirely on 
it being set up for Unicode.

However, Gary, does this happen with any (e.g., all, most, some) record, or 
just a specific one?  What kind of field is it querying in AD?

Lyle

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Meyer, Jennifer L
Sent: Monday, August 24, 2009 10:00 AM
To: arslist@ARSLIST.ORG
Subject: Re: Weird Unicode error in remedy when querying AD via the LDAP and a 
vendor form

**
Does the user's name perhaps contain a character that Remedy can't read?  For 
example, if you have installed the English language pack, but not the Japanese 
language pack, and the user has a Japanese character in his or her name, an 
error of this sort might occur.


Jennifer Meyer

Remedy Technical Support Specialist

State of North Carolina

Office of Information Technology Services

Service Delivery Division ITSM & ITAM Services

Office: 919-754-6543

ITS Service Desk: 919-754-6000

jennifer.me...@its.nc.gov

http://its.state.nc.us



E-mail correspondence to and from this address may be subject to the North 
Carolina Public Records Law and may be disclosed to third parties only by an 
authorized State Official.


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF AFMC 72 
CS/SCBAH
Sent: Monday, August 24, 2009 11:48 AM
To: arslist@ARSLIST.ORG
Subject: Weird Unicode error in remedy when querying AD via the LDAP and a 
vendor form

ARERR [9062] Error encountered during string conversion from Unicode : string 
;yêÇÕáB¬bÛã=·Ø

Remedy 6.3 (no patch)
Windows/Sql Server

Has anyone seen the above error message when querying AD? Is there a fix that 
doesn't involve patching?

It only happens on some accounts, but on those accounts that it happens, it 
happens every time for those accounts.


Thanks,

Gary Opela, Jr.
Sr. Remedy Engineer
Avaya Phone Admin
RSP Cert, Sec+
405 739 7006 x30043

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers 
Are"__Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers 
Are"_


 NOTICE: This email message is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information. Any unauthorized 
review, use, disclosure or distribution is prohibited. If you are not the 
intended recipient, please contact the sender by reply email and destroy all 
copies of the original message.



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Data load Template for SLM and Asset Management

[Rohini Prasher]

Hi Listers,

Can anybody share SLM and Asset Management data templates with me/ can provide 
the link from where I can download the same.

Regards,
Rohini Prasher


DISCLAIMER:
---

The contents of this e-mail and any attachment(s) are confidential and intended 
for the named recipient(s) only. 
It shall not attach any liability on the originator or HCL or its affiliates. 
Any views or opinions presented in 
this email are solely those of the author and may not necessarily reflect the 
opinions of HCL or its affiliates. 
Any form of reproduction, dissemination, copying, disclosure, modification, 
distribution and / or publication of 
this message without the prior written consent of the author of this e-mail is 
strictly prohibited. If you have 
received this email in error please delete it and notify the sender 
immediately. Before opening any mail and 
attachments please check them for viruses and defect.

---

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Date Time Conversion Issue in Remedy

[Frank Caruso]

I stand corrected. Great to know this function exist.

On Mon, Aug 24, 2009 at 7:06 PM, Grooms, Frederick
W wrote:
> Oracle 9i (and higher) functions for Date Time conversion
>
> Change 'US/Central' to the time zone of your database.  The Oracle functions 
> will automatically perform the correct DST corrections (as long as you have 
> the Oracle DST patches installed in the database)
>
> CREATE OR REPLACE FUNCTION FROM_EPOCH (secs IN NUMBER)
>  RETURN DATE
> IS
>  lDate DATE;
> BEGIN
>  lDate := (From_TZ((TO_DATE('01/01/1970', 'dd/mm/')+(secs/86400)),'GMT') 
> AT TIME ZONE 'US/Central');
>  RETURN lDate;
> END From_Epoch;
> /
>
>
> CREATE OR REPLACE FUNCTION TO_EPOCH (lDate IN DATE)
>   RETURN NUMBER
> IS
>   Seconds NUMBER;
>   dte1 TIMESTAMP;
>   dte2 TIMESTAMP;
> BEGIN
>   dte1 := new_time(lDate, to_char( from_tz(cast (lDate as timestamp), 
> 'US/Central'),'TZD'),'GMT');
>   dte2 := TO_TIMESTAMP_TZ('01/01/1970 '|| TZ_Offset('Greenwich'), 'MM/DD/ 
> TZH:TZM');
>   Seconds := (((dte1-0) - (dte2-0)) * 86400);
>   RETURN Seconds;
> END To_Epoch;
> /
>
> Fred
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Frank Caruso
> Sent: Monday, August 24, 2009 10:32 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: Date Time Conversion Issue in Remedy
>
> You will need to handle this in code. Add logic that figures out
> whether you are in DST or out of DST and then add or subtract the
> offset. I do not believe that there is any built in function in Oracle
> that will do this for you. I have done this in the past and had to
> create conditional statements that contained each years DST start and
> being dates. I think if you search the ARSList you will find examples
> of how do this.
>
> On Mon, Aug 24, 2009 at 6:17 PM, Mark Milke wrote:
>> Hi David,
>>
>> I have a question here. I've tried the following:
>>
>> SELECT TO_CHAR(TO_DATE('01/01/1970 00:00:00 GMT', 'DD.MM.
>> HH24:MI:SS') + ((outage_time + 3600)/(60*60*24)),'DD.MM.
>> HH24:MI:SS') FROM trouble_ticket where tt_nr_ = '0001234567';
>>
>> and it works just fine.
>>
>> However depending on what my outage_time is, I'm getting a wrong
>> result, because of the time zone esp. summer and winter time. Where to
>> put time zone information here or how to deal with this issue at all?
>>
>>
>> Thanks,
>> Mark
>>
>>
>> On 18 Aug., 21:02, David Morgan  wrote:
>>> Hi Lisa
>>>
>>> The database reference guide has the information for going from EPOCH
>>> date to the date in a format you require (in 6.3 it was p.54 - see below
>>> signature)
>>>         SELECT TO_CHAR(TO_DATE('01/01/1970 00:00:00', 'MM/DD/
>>> HH24:MI:SS') +
>>>                                         ((C +
>>> )/(60*60*24)),'MM/DD/ HH24:MI:SS') FROM T;
>>>
>>> Going the other way (subtract epoch from current stamp to get difference
>>> in seconds)
>>>
>>>         selectto_date('2008-07-16','-mm-dd') 
>>> -to_date('1970-01-01','-mm-dd') from dual
>>>
>>> regards
>>> Dave Morgan
>>>
>>>
>>> -Original Message-
>>> From: Action Request System discussion list(ARSList)
>>>
>>> [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa
>>> Sent: 18 August 2009 18:24
>>> To: arsl...@arslist.org
>>> Subject: Re: Date Time Conversion Issue in Remedy
>>>
>>> --_000_46CDC1E68702E54387E9EAEDC0A02CA207C87BF0C5us194mx002tyc_
>>> Content-Type: text/plain; charset="us-ascii"
>>> Content-Transfer-Encoding: quoted-printable
>>>
>>> I think this is the function to convert FROM Epoch to a readable
>>> date/time =
>>> format.  I need the other way around...
>>>
>>> Thanks!
>>>
>>> Lisa
>>>
>>> 
>>> From: Action Request System discussion list(ARSList)
>>> [mailto:arsl...@arslis=
>>> T.ORG] On Behalf Of Cesaro, Tony M[EQ]
>>> Sent: Tuesday, August 18, 2009 1:01 PM
>>> To: arsl...@arslist.org
>>> Subject: Re: Date Time Conversion Issue in Remedy
>>>
>>> **
>>> Lisa,
>>>
>>> We ended up writing an Oracle function to generate the conversion for
>>> us.  =
>>> I have included the SQL source below.  You'll obviously want to change
>>> your=
>>>  time zone and input date format accordingly.
>>>
>>> create or replace FUNCTION GETDATE (a_number number)
>>>  RETURN Date IS
>>>    date_x date;
>>>
>>> BEGIN
>>>   if a_number is null then
>>>      return null;
>>>   else
>>>      date_x :=3D new_time(TO_DATE('01/01/1970 00:00:00',
>>> 'MM/DD/HH24:MI=
>>> :SS') + (a_number/86400),'GMT','EDT');
>>>   end if;
>>> RETURN(date_x);
>>> END GetDate;
>>>
>>> Regards,
>>>
>>> Tony Cesaro
>>>
>>> From: Action Request System discussion list(ARSList)
>>> [mailto:arsl...@arslis=
>>> T.ORG] On Behalf Of Kemes, Lisa
>>> Sent: Tuesday, August 18, 2009 12:52
>>> To: arsl...@arslist.org
>>> Subject: Re: Date Time Conversion Issue in Remedy
>>>
>>> **
>>> I'm having a similar issues (details are a little bit different), but
>>> how d=
>>> o you convert a MM/DD/ HH:MM:SS to epoch time.  We are using Windows
>

Re: Date Time Conversion Issue in Remedy

[Grooms, Frederick W]

Oracle 9i (and higher) functions for Date Time conversion

Change 'US/Central' to the time zone of your database.  The Oracle functions 
will automatically perform the correct DST corrections (as long as you have the 
Oracle DST patches installed in the database)

CREATE OR REPLACE FUNCTION FROM_EPOCH (secs IN NUMBER)
  RETURN DATE
IS
  lDate DATE;
BEGIN
  lDate := (From_TZ((TO_DATE('01/01/1970', 'dd/mm/')+(secs/86400)),'GMT') 
AT TIME ZONE 'US/Central');
  RETURN lDate;
END From_Epoch;
/


CREATE OR REPLACE FUNCTION TO_EPOCH (lDate IN DATE)
   RETURN NUMBER
IS
   Seconds NUMBER;
   dte1 TIMESTAMP;
   dte2 TIMESTAMP;
BEGIN
   dte1 := new_time(lDate, to_char( from_tz(cast (lDate as timestamp), 
'US/Central'),'TZD'),'GMT');
   dte2 := TO_TIMESTAMP_TZ('01/01/1970 '|| TZ_Offset('Greenwich'), 'MM/DD/ 
TZH:TZM'); 
   Seconds := (((dte1-0) - (dte2-0)) * 86400);
   RETURN Seconds;
END To_Epoch;
/

Fred


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Frank Caruso
Sent: Monday, August 24, 2009 10:32 AM
To: arslist@ARSLIST.ORG
Subject: Re: Date Time Conversion Issue in Remedy

You will need to handle this in code. Add logic that figures out
whether you are in DST or out of DST and then add or subtract the
offset. I do not believe that there is any built in function in Oracle
that will do this for you. I have done this in the past and had to
create conditional statements that contained each years DST start and
being dates. I think if you search the ARSList you will find examples
of how do this.

On Mon, Aug 24, 2009 at 6:17 PM, Mark Milke wrote:
> Hi David,
>
> I have a question here. I've tried the following:
>
> SELECT TO_CHAR(TO_DATE('01/01/1970 00:00:00 GMT', 'DD.MM.
> HH24:MI:SS') + ((outage_time + 3600)/(60*60*24)),'DD.MM.
> HH24:MI:SS') FROM trouble_ticket where tt_nr_ = '0001234567';
>
> and it works just fine.
>
> However depending on what my outage_time is, I'm getting a wrong
> result, because of the time zone esp. summer and winter time. Where to
> put time zone information here or how to deal with this issue at all?
>
>
> Thanks,
> Mark
>
>
> On 18 Aug., 21:02, David Morgan  wrote:
>> Hi Lisa
>>
>> The database reference guide has the information for going from EPOCH
>> date to the date in a format you require (in 6.3 it was p.54 - see below
>> signature)
>>         SELECT TO_CHAR(TO_DATE('01/01/1970 00:00:00', 'MM/DD/
>> HH24:MI:SS') +
>>                                         ((C +
>> )/(60*60*24)),'MM/DD/ HH24:MI:SS') FROM T;
>>
>> Going the other way (subtract epoch from current stamp to get difference
>> in seconds)
>>
>>         selectto_date('2008-07-16','-mm-dd') 
>> -to_date('1970-01-01','-mm-dd') from dual
>>
>> regards
>> Dave Morgan
>>
>>
>> -Original Message-
>> From: Action Request System discussion list(ARSList)
>>
>> [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa
>> Sent: 18 August 2009 18:24
>> To: arsl...@arslist.org
>> Subject: Re: Date Time Conversion Issue in Remedy
>>
>> --_000_46CDC1E68702E54387E9EAEDC0A02CA207C87BF0C5us194mx002tyc_
>> Content-Type: text/plain; charset="us-ascii"
>> Content-Transfer-Encoding: quoted-printable
>>
>> I think this is the function to convert FROM Epoch to a readable
>> date/time =
>> format.  I need the other way around...
>>
>> Thanks!
>>
>> Lisa
>>
>> 
>> From: Action Request System discussion list(ARSList)
>> [mailto:arsl...@arslis=
>> T.ORG] On Behalf Of Cesaro, Tony M[EQ]
>> Sent: Tuesday, August 18, 2009 1:01 PM
>> To: arsl...@arslist.org
>> Subject: Re: Date Time Conversion Issue in Remedy
>>
>> **
>> Lisa,
>>
>> We ended up writing an Oracle function to generate the conversion for
>> us.  =
>> I have included the SQL source below.  You'll obviously want to change
>> your=
>>  time zone and input date format accordingly.
>>
>> create or replace FUNCTION GETDATE (a_number number)
>>  RETURN Date IS
>>    date_x date;
>>
>> BEGIN
>>   if a_number is null then
>>      return null;
>>   else
>>      date_x :=3D new_time(TO_DATE('01/01/1970 00:00:00',
>> 'MM/DD/HH24:MI=
>> :SS') + (a_number/86400),'GMT','EDT');
>>   end if;
>> RETURN(date_x);
>> END GetDate;
>>
>> Regards,
>>
>> Tony Cesaro
>>
>> From: Action Request System discussion list(ARSList)
>> [mailto:arsl...@arslis=
>> T.ORG] On Behalf Of Kemes, Lisa
>> Sent: Tuesday, August 18, 2009 12:52
>> To: arsl...@arslist.org
>> Subject: Re: Date Time Conversion Issue in Remedy
>>
>> **
>> I'm having a similar issues (details are a little bit different), but
>> how d=
>> o you convert a MM/DD/ HH:MM:SS to epoch time.  We are using Windows
>> 20=
>> 03, Oracle 10, ARS 7.0.1
>>
>> I've seen lots of info about converting Epoch to a readable date format,
>> bu=
>> t not the other way around
>>
>> Lisa
>>
>> 
>> From: Action Request System discussion list(ARSList)
>> [mailto:arsl...@arslis=
>> T.ORG] On Be

Re: Weird Unicode error in remedy when querying AD via the LDAP and a vendor form

[Opela, Gary L CTR USAF AFMC 72 CS/SCBAH]

Nope, standard American name (whatever that is these days). Nothing special. We 
even checked all of the Unicode fields in AD to make sure there weren't any 
bazaar characters in there. There was one field with a bazaar character, so we 
left that field off of the vendor form, but it still had the same error.


Thanks,

Gary Opela, Jr.
Sr. Remedy Engineer
Avaya Phone Admin
RSP Cert, Sec+
405 739 7006 x30043


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Meyer, Jennifer L
Sent: Monday, August 24, 2009 11:00 AM
To: arslist@ARSLIST.ORG
Subject: Re: Weird Unicode error in remedy when querying AD via the LDAP and a 
vendor form

** 

Does the user's name perhaps contain a character that Remedy can't read?  For 
example, if you have installed the English language pack, but not the Japanese 
language pack, and the user has a Japanese character in his or her name, an 
error of this sort might occur.

 

Jennifer Meyer

Remedy Technical Support Specialist

State of North Carolina

Office of Information Technology Services 

Service Delivery Division ITSM & ITAM Services

Office: 919-754-6543

ITS Service Desk: 919-754-6000

jennifer.me...@its.nc.gov

http://its.state.nc.us  

 

E-mail correspondence to and from this address may be subject to the North 
Carolina Public Records Law and may be disclosed to third parties only by an 
authorized State Official.



From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF AFMC 72 
CS/SCBAH
Sent: Monday, August 24, 2009 11:48 AM
To: arslist@ARSLIST.ORG
Subject: Weird Unicode error in remedy when querying AD via the LDAP and a 
vendor form

 

ARERR [9062] Error encountered during string conversion from Unicode : string 
;yêÇÕáB¬bÛã=·Ø

 

Remedy 6.3 (no patch)

Windows/Sql Server

 

Has anyone seen the above error message when querying AD? Is there a fix that 
doesn't involve patching?

 

It only happens on some accounts, but on those accounts that it happens, it 
happens every time for those accounts.

 

 

Thanks,

 

Gary Opela, Jr.

Sr. Remedy Engineer

Avaya Phone Admin

RSP Cert, Sec+

405 739 7006 x30043

 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers 
Are"__Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers 
Are"_ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: UNSUBSCRIBE

[Darrell Reading]

Little slow there Junior. 


Darrell Reading Systems Engineer
Phone 479.204.5739
dere...@wal-mart.com

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

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF AFMC 72
CS/SCBAH
Sent: Monday, August 24, 2009 11:01
To: arslist@ARSLIST.ORG
Subject: Re: UNSUBSCRIBE

HAH


Thanks,

Gary Opela, Jr.
Sr. Remedy Engineer
Avaya Phone Admin
RSP Cert, Sec+
405 739 7006 x30043


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Tim Widowfield
Sent: Tuesday, August 11, 2009 8:35 AM
To: arslist@ARSLIST.ORG
Subject: Re: UNSUBSCRIBE

** 
You keep saying that word...  I do not think you know what it means.


--Tim





From: Darrell Reading 
To: arslist@ARSLIST.ORG
Sent: Tuesday, August 11, 2009 7:35:38 AM
Subject: Re: [ARSLIST] UNSUBSCRIBE

** 

Inconceivable!
 

Darrell Reading Systems Engineer 
Phone 479.204.5739 
dere...@wal-mart.com 

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:arsl...@arslist.org] On Behalf Of Nidhi Garg
Sent: Tuesday, August 11, 2009 05:38
To: arslist@ARSLIST.ORG
Subject: UNSUBSCRIBE


** 
 
Thanks & Regards,
 
Nidhi Garg
 
DISCLAIMER:

---

The contents of this e-mail and any attachment(s) are confidential and
intended for the named recipient(s) only. 
It shall not attach any liability on the originator or HCL or its
affiliates. Any views or opinions presented in 
this email are solely those of the author and may not necessarily
reflect the opinions of HCL or its affiliates. 
Any form of reproduction, dissemination, copying, disclosure,
modification, distribution and / or publication of 
this message without the prior written consent of the author of this
e-mail is strictly prohibited. If you have 
received this email in error please delete it and notify the sender
immediately. Before opening any mail and 
attachments please check them for viruses and
 defect.


---
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ 



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

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: UNSUBSCRIBE

[Opela, Gary L CTR USAF AFMC 72 CS/SCBAH]

HAH


Thanks,

Gary Opela, Jr.
Sr. Remedy Engineer
Avaya Phone Admin
RSP Cert, Sec+
405 739 7006 x30043


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Tim Widowfield
Sent: Tuesday, August 11, 2009 8:35 AM
To: arslist@ARSLIST.ORG
Subject: Re: UNSUBSCRIBE

** 
You keep saying that word...  I do not think you know what it means.


--Tim





From: Darrell Reading 
To: arslist@ARSLIST.ORG
Sent: Tuesday, August 11, 2009 7:35:38 AM
Subject: Re: [ARSLIST] UNSUBSCRIBE

** 

Inconceivable!
 

Darrell Reading Systems Engineer 
Phone 479.204.5739 
dere...@wal-mart.com 

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:arsl...@arslist.org] On Behalf Of Nidhi Garg
Sent: Tuesday, August 11, 2009 05:38
To: arslist@ARSLIST.ORG
Subject: UNSUBSCRIBE


** 
 
Thanks & Regards,
 
Nidhi Garg
 
DISCLAIMER:

---

The contents of this e-mail and any attachment(s) are confidential and
intended for the named recipient(s) only. 
It shall not attach any liability on the originator or HCL or its
affiliates. Any views or opinions presented in 
this email are solely those of the author and may not necessarily
reflect the opinions of HCL or its affiliates. 
Any form of reproduction, dissemination, copying, disclosure,
modification, distribution and / or publication of 
this message without the prior written consent of the author of this
e-mail is strictly prohibited. If you have 
received this email in error please delete it and notify the sender
immediately. Before opening any mail and 
attachments please check them for viruses and
 defect.


---
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ 



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

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Weird Unicode error in remedy when querying AD via the LDAP and a vendor form

[Meyer, Jennifer L]

Does the user's name perhaps contain a character that Remedy can't read?  For 
example, if you have installed the English language pack, but not the Japanese 
language pack, and the user has a Japanese character in his or her name, an 
error of this sort might occur.


Jennifer Meyer

Remedy Technical Support Specialist

State of North Carolina

Office of Information Technology Services

Service Delivery Division ITSM & ITAM Services

Office: 919-754-6543

ITS Service Desk: 919-754-6000

jennifer.me...@its.nc.gov

http://its.state.nc.us



E-mail correspondence to and from this address may be subject to the North 
Carolina Public Records Law and may be disclosed to third parties only by an 
authorized State Official.


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF AFMC 72 
CS/SCBAH
Sent: Monday, August 24, 2009 11:48 AM
To: arslist@ARSLIST.ORG
Subject: Weird Unicode error in remedy when querying AD via the LDAP and a 
vendor form

ARERR [9062] Error encountered during string conversion from Unicode : string 
;yêÇÕáB¬bÛã=·Ø

Remedy 6.3 (no patch)
Windows/Sql Server

Has anyone seen the above error message when querying AD? Is there a fix that 
doesn't involve patching?

It only happens on some accounts, but on those accounts that it happens, it 
happens every time for those accounts.


Thanks,

Gary Opela, Jr.
Sr. Remedy Engineer
Avaya Phone Admin
RSP Cert, Sec+
405 739 7006 x30043

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: AL Guide exiting prematurely

[Mark Seiler]

Thanks All... I'm retracing my steps and will provide more explicit errors.
Regards,
Mark

On Fri, Aug 21, 2009 at 9:56 AM, Carey Matthew Black wrote:

> Mark,
>
> Since a Push action will create/update records in another form then
> also make sure you look at filter logs. Maybe your just not seeing the
> error being thrown by the Filter/Database in the Active Link log.
>
> I typically turn on all of the client side logs when I head into
> client side debug mode. ( It avoid the "oh... I also wanted to see
> that. Ok. I will do it again with more logs turned on." problem. )
>
> --
> Carey Matthew Black
> BMC Remedy AR System Skilled Professional (RSP)
> ARS = Action Request System(Remedy)
>
> Love, then teach
> Solution = People + Process + Tools
> Fast, Accurate, Cheap Pick two.
>
>
>
> On Fri, Aug 21, 2009 at 9:50 AM, Mark Seiler wrote:
> > **
> > Well... no explicit errors are called out on the log, and all of the ALs
> in
> > the Guide are on the same form. But, the table loop pushes values to a
> > second form (successfully), and then the Guide exits abruptly.
> >
> >> 
> >> From: Action Request System discussion list(ARSList)
> >> [mailto:arsl...@arslist.org] On Behalf Of Mark Seiler
> >> Sent: Friday, August 21, 2009 7:28 AM
> >> To: arslist@ARSLIST.ORG
> >> Subject: Re: AL Guide exiting prematurely
> >>
> >> **
> >> No, there are no exit guide calls.
> >> Thanks
> >>
> >>> 
> >>> From: Action Request System discussion list(ARSList)
> >>> [mailto:arsl...@arslist.org] On Behalf Of Mark Seiler
> >>> Sent: Friday, August 21, 2009 7:16 AM
> >>> To: arslist@ARSLIST.ORG
> >>> Subject: AL Guide exiting prematurely
> >>>
> >>> **
> >>>
> >>> Hi All,
> >>> I have an AL Guide containing 3 active links. The first one executes a
> >>> search on a form (this completes successfully). Once the form is
> searched,
> >>> another guide (not in the original) is called, which does a table loop
> (this
> >>> also completes successfully). The issue is that the original guide
> exits at
> >>> this point and the final two links are never executed (or even
> attempted
> >>> judging by the AL log). I've double-checked the permissions on the
> workflow
> >>> and all are set to public for test purposes.
> >>> Am I missing something obvious?
> >>> Thanks,
> >>> Mark
> >>>
> >>> Win Server 2003/MS SQL 2000
> >>> ARS 7.1 patch 6
> >>> ITSM 7.0.03 patch 006
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>  Platinum 
> Sponsor:rmisoluti...@verizon.netARSlist: 
> "Where the Answers Are"
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Weird Unicode error in remedy when querying AD via the LDAP and a vendor form

[Opela, Gary L CTR USAF AFMC 72 CS/SCBAH]

ARERR [9062] Error encountered during string conversion from Unicode : string 
;yêÇÕáB¬bÛã=·Ø

 

Remedy 6.3 (no patch)

Windows/Sql Server

 

Has anyone seen the above error message when querying AD? Is there a fix that 
doesn't involve patching?

 

It only happens on some accounts, but on those accounts that it happens, it 
happens every time for those accounts.

 

 

Thanks,

 

Gary Opela, Jr.

Sr. Remedy Engineer

Avaya Phone Admin

RSP Cert, Sec+

405 739 7006 x30043

 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Date Time Conversion Issue in Remedy

[Frank Caruso]

You will need to handle this in code. Add logic that figures out
whether you are in DST or out of DST and then add or subtract the
offset. I do not believe that there is any built in function in Oracle
that will do this for you. I have done this in the past and had to
create conditional statements that contained each years DST start and
being dates. I think if you search the ARSList you will find examples
of how do this.

On Mon, Aug 24, 2009 at 6:17 PM, Mark Milke wrote:
> Hi David,
>
> I have a question here. I've tried the following:
>
> SELECT TO_CHAR(TO_DATE('01/01/1970 00:00:00 GMT', 'DD.MM.
> HH24:MI:SS') + ((outage_time + 3600)/(60*60*24)),'DD.MM.
> HH24:MI:SS') FROM trouble_ticket where tt_nr_ = '0001234567';
>
> and it works just fine.
>
> However depending on what my outage_time is, I'm getting a wrong
> result, because of the time zone esp. summer and winter time. Where to
> put time zone information here or how to deal with this issue at all?
>
>
> Thanks,
> Mark
>
>
> On 18 Aug., 21:02, David Morgan  wrote:
>> Hi Lisa
>>
>> The database reference guide has the information for going from EPOCH
>> date to the date in a format you require (in 6.3 it was p.54 - see below
>> signature)
>>         SELECT TO_CHAR(TO_DATE('01/01/1970 00:00:00', 'MM/DD/
>> HH24:MI:SS') +
>>                                         ((C +
>> )/(60*60*24)),'MM/DD/ HH24:MI:SS') FROM T;
>>
>> Going the other way (subtract epoch from current stamp to get difference
>> in seconds)
>>
>>         selectto_date('2008-07-16','-mm-dd') 
>> -to_date('1970-01-01','-mm-dd') from dual
>>
>> regards
>> Dave Morgan
>>
>> Converting AR System dates to database dates
>> AR System keeps track of the date and time to run escalations, stamps
>> requests with the date and time they were submitted, and informs you
>> when
>> alerts were sent. To track the date and time, AR System uses a format
>> that
>> measures the number of seconds from January 1, 1970, 12:00 a.m.
>> Greenwich
>> Mean Time (GMT). While accurate, this format can be an awkward format
>> to read. You might want to translate it to a format that your database
>> can
>> easily read.
>>
>> Each database requires different commands for the date and time
>> conversion. The following procedures describe how you can use your
>> database to convert the AR System date and time format.
>> Note: In the SQL commands in the following procedures, the column
>> number is referenced by . Alternatively, you can
>> provide the SQL view name of the column (the database name of the field
>> as displayed in Remedy Administrator).
>> " To convert the date and time format for a DB2 Universal database:
>> " See your DB2 documentation for information about dateline arithmetic.
>> " To convert the date and time format for an Informix database:
>> 1 Using any front-end tool that allows direct access to an Informix-SQL
>> database, log in as the root user.
>> 2 Type the following command:
>> % select (extend((extend(datetime(1970-1-1) year to day, year to hour) -
>> interval() hour to hour), year to second) +
>> C
>> units second) from T
>> where,  is the number of the column for the date and time
>> field,  is the number of the form table, and
>>  is
>> a positive or negative number representing the number of hours later or
>> earlier than GMT.
>> If the date is greater than 09/10/2001, you will receive an error. To
>> avoid an
>> error, you can display minutes instead of seconds by using the following
>> command:
>> % select (extend((extend(datetime(1970-1-1) year to day, year to hour) -
>> interval() hour to hour), year to minute)
>> +(C/60)
>> units minute) from T
>> See the Informix Guide to SQL: Reference and Syntax manaul for
>> information
>> about the datetime, extend, and interval functions.
>> " To convert the date and time format for an Oracle database:
>> 1 Using any front-end tool that enables direct access to an Oracle SQL
>> database, log in as a user with write access to the AR System tables.
>> 2 Type the following command:
>> % SELECT TO_CHAR(TO_DATE('01/01/1970 00:00:00', 'MM/DD/
>> HH24:MI:SS') + ((C + )/(60*60*24)),
>> 'MM/DD/ HH24:MI:SS') FROM T;
>> where,  is the number of the column for the date and time
>> field,  is the number of the form table, and  is a
>> positive or negative number representing the number of seconds later or
>> earlier than GMT.
>> See the your Oracle documentation for information about theTO_DATEand
>> TO_CHAR functions.
>> " To convert the date and time format for a Sybase or Microsoft SQL
>> Server
>> database:
>> 1 Using any front-end tool that enables direct access to a Sybase or
>> Microsoft
>> SQL Server database, log in as a user who has write access to the AR
>> System
>> tables.
>> 2 Type the following command:
>> % select dateadd(second, C + ,
>> "Jan 1, 1970") from T
>> where,  is the number of the column for the date and time
>> field,  is the number of the form table, and  is a
>> positive or negative number repr

Re: Date Time Conversion Issue in Remedy

[Mark Milke]

One more question. How to figure out, what from what time zone is the
my timestamp?

Thanks,
Mark

On 18 Aug., 21:02, David Morgan  wrote:
> Hi Lisa
>
> The database reference guide has the information for going from EPOCH
> date to the date in a format you require (in 6.3 it was p.54 - see below
> signature)
>         SELECT TO_CHAR(TO_DATE('01/01/1970 00:00:00', 'MM/DD/
> HH24:MI:SS') +
>                                         ((C +
> )/(60*60*24)),'MM/DD/ HH24:MI:SS') FROM T;
>
> Going the other way (subtract epoch from current stamp to get difference
> in seconds)
>
>         selectto_date('2008-07-16','-mm-dd') 
> -to_date('1970-01-01','-mm-dd') from dual
>
> regards
> Dave Morgan
>
> Converting AR System dates to database dates
> AR System keeps track of the date and time to run escalations, stamps
> requests with the date and time they were submitted, and informs you
> when
> alerts were sent. To track the date and time, AR System uses a format
> that
> measures the number of seconds from January 1, 1970, 12:00 a.m.
> Greenwich
> Mean Time (GMT). While accurate, this format can be an awkward format
> to read. You might want to translate it to a format that your database
> can
> easily read.
>
> Each database requires different commands for the date and time
> conversion. The following procedures describe how you can use your
> database to convert the AR System date and time format.
> Note: In the SQL commands in the following procedures, the column
> number is referenced by . Alternatively, you can
> provide the SQL view name of the column (the database name of the field
> as displayed in Remedy Administrator).
> " To convert the date and time format for a DB2 Universal database:
> " See your DB2 documentation for information about dateline arithmetic.
> " To convert the date and time format for an Informix database:
> 1 Using any front-end tool that allows direct access to an Informix-SQL
> database, log in as the root user.
> 2 Type the following command:
> % select (extend((extend(datetime(1970-1-1) year to day, year to hour) -
> interval() hour to hour), year to second) +
> C
> units second) from T
> where,  is the number of the column for the date and time
> field,  is the number of the form table, and
>  is
> a positive or negative number representing the number of hours later or
> earlier than GMT.
> If the date is greater than 09/10/2001, you will receive an error. To
> avoid an
> error, you can display minutes instead of seconds by using the following
> command:
> % select (extend((extend(datetime(1970-1-1) year to day, year to hour) -
> interval() hour to hour), year to minute)
> +(C/60)
> units minute) from T
> See the Informix Guide to SQL: Reference and Syntax manaul for
> information
> about the datetime, extend, and interval functions.
> " To convert the date and time format for an Oracle database:
> 1 Using any front-end tool that enables direct access to an Oracle SQL
> database, log in as a user with write access to the AR System tables.
> 2 Type the following command:
> % SELECT TO_CHAR(TO_DATE('01/01/1970 00:00:00', 'MM/DD/
> HH24:MI:SS') + ((C + )/(60*60*24)),
> 'MM/DD/ HH24:MI:SS') FROM T;
> where,  is the number of the column for the date and time
> field,  is the number of the form table, and  is a
> positive or negative number representing the number of seconds later or
> earlier than GMT.
> See the your Oracle documentation for information about theTO_DATEand
> TO_CHAR functions.
> " To convert the date and time format for a Sybase or Microsoft SQL
> Server
> database:
> 1 Using any front-end tool that enables direct access to a Sybase or
> Microsoft
> SQL Server database, log in as a user who has write access to the AR
> System
> tables.
> 2 Type the following command:
> % select dateadd(second, C + ,
> "Jan 1, 1970") from T
> where,  is the number of the column for the date and time
> field,  is the number of the form table, and  is a
> positive or negative number representing the number of seconds later or
> earlier than GMT.
> 3 Optionally, you could format the date field by using the convert
> function.
> There are 12 different formats from which you can choose. See your
> Sybase
> documentation.
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
>
> [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa
> Sent: 18 August 2009 18:24
> To: arsl...@arslist.org
> Subject: Re: Date Time Conversion Issue in Remedy
>
> --_000_46CDC1E68702E54387E9EAEDC0A02CA207C87BF0C5us194mx002tyc_
> Content-Type: text/plain; charset="us-ascii"
> Content-Transfer-Encoding: quoted-printable
>
> I think this is the function to convert FROM Epoch to a readable
> date/time =
> format.  I need the other way around...
>
> Thanks!
>
> Lisa
>
> 
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslis=
> T.ORG] On Behalf Of Cesaro, Tony M[EQ]
> Sent: Tuesday, August 18, 2009 1:01 PM
> To

Re: Date Time Conversion Issue in Remedy

[Mark Milke]

Hi David,

I have a question here. I've tried the following:

SELECT TO_CHAR(TO_DATE('01/01/1970 00:00:00 GMT', 'DD.MM.
HH24:MI:SS') + ((outage_time + 3600)/(60*60*24)),'DD.MM.
HH24:MI:SS') FROM trouble_ticket where tt_nr_ = '0001234567';

and it works just fine.

However depending on what my outage_time is, I'm getting a wrong
result, because of the time zone esp. summer and winter time. Where to
put time zone information here or how to deal with this issue at all?


Thanks,
Mark


On 18 Aug., 21:02, David Morgan  wrote:
> Hi Lisa
>
> The database reference guide has the information for going from EPOCH
> date to the date in a format you require (in 6.3 it was p.54 - see below
> signature)
>         SELECT TO_CHAR(TO_DATE('01/01/1970 00:00:00', 'MM/DD/
> HH24:MI:SS') +
>                                         ((C +
> )/(60*60*24)),'MM/DD/ HH24:MI:SS') FROM T;
>
> Going the other way (subtract epoch from current stamp to get difference
> in seconds)
>
>         selectto_date('2008-07-16','-mm-dd') 
> -to_date('1970-01-01','-mm-dd') from dual
>
> regards
> Dave Morgan
>
> Converting AR System dates to database dates
> AR System keeps track of the date and time to run escalations, stamps
> requests with the date and time they were submitted, and informs you
> when
> alerts were sent. To track the date and time, AR System uses a format
> that
> measures the number of seconds from January 1, 1970, 12:00 a.m.
> Greenwich
> Mean Time (GMT). While accurate, this format can be an awkward format
> to read. You might want to translate it to a format that your database
> can
> easily read.
>
> Each database requires different commands for the date and time
> conversion. The following procedures describe how you can use your
> database to convert the AR System date and time format.
> Note: In the SQL commands in the following procedures, the column
> number is referenced by . Alternatively, you can
> provide the SQL view name of the column (the database name of the field
> as displayed in Remedy Administrator).
> " To convert the date and time format for a DB2 Universal database:
> " See your DB2 documentation for information about dateline arithmetic.
> " To convert the date and time format for an Informix database:
> 1 Using any front-end tool that allows direct access to an Informix-SQL
> database, log in as the root user.
> 2 Type the following command:
> % select (extend((extend(datetime(1970-1-1) year to day, year to hour) -
> interval() hour to hour), year to second) +
> C
> units second) from T
> where,  is the number of the column for the date and time
> field,  is the number of the form table, and
>  is
> a positive or negative number representing the number of hours later or
> earlier than GMT.
> If the date is greater than 09/10/2001, you will receive an error. To
> avoid an
> error, you can display minutes instead of seconds by using the following
> command:
> % select (extend((extend(datetime(1970-1-1) year to day, year to hour) -
> interval() hour to hour), year to minute)
> +(C/60)
> units minute) from T
> See the Informix Guide to SQL: Reference and Syntax manaul for
> information
> about the datetime, extend, and interval functions.
> " To convert the date and time format for an Oracle database:
> 1 Using any front-end tool that enables direct access to an Oracle SQL
> database, log in as a user with write access to the AR System tables.
> 2 Type the following command:
> % SELECT TO_CHAR(TO_DATE('01/01/1970 00:00:00', 'MM/DD/
> HH24:MI:SS') + ((C + )/(60*60*24)),
> 'MM/DD/ HH24:MI:SS') FROM T;
> where,  is the number of the column for the date and time
> field,  is the number of the form table, and  is a
> positive or negative number representing the number of seconds later or
> earlier than GMT.
> See the your Oracle documentation for information about theTO_DATEand
> TO_CHAR functions.
> " To convert the date and time format for a Sybase or Microsoft SQL
> Server
> database:
> 1 Using any front-end tool that enables direct access to a Sybase or
> Microsoft
> SQL Server database, log in as a user who has write access to the AR
> System
> tables.
> 2 Type the following command:
> % select dateadd(second, C + ,
> "Jan 1, 1970") from T
> where,  is the number of the column for the date and time
> field,  is the number of the form table, and  is a
> positive or negative number representing the number of seconds later or
> earlier than GMT.
> 3 Optionally, you could format the date field by using the convert
> function.
> There are 12 different formats from which you can choose. See your
> Sybase
> documentation.
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
>
> [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa
> Sent: 18 August 2009 18:24
> To: arsl...@arslist.org
> Subject: Re: Date Time Conversion Issue in Remedy
>
> --_000_46CDC1E68702E54387E9EAEDC0A02CA207C87BF0C5us194mx002tyc_
> Content-Type: text/plain; charset="us-ascii"