Julio,
I feel your chances of getting that from the Remedy Java API are around nil.
The API isn't even OO, let alone equipped with Collections (which was a year
2000 feature) - hence, while a nice Java API would be welcome, it's never
going to happen until the Remedy Java API is taken seriously
Hi All,
Remedy datatype Date is stored as an integer in the SQL Server
database. It is stored as the number of seconds from 1st Jan 1970. Now I
am using a SELECT query to read this value in a character (There is a
requirement that I cannot read this into a date field on Remedy). The
value
There are some Kbs on this .. following should help you.
Oracle
--
SELECT TO_CHAR(TO_DATE('01/01/1970 00:00:00', 'MM/DD/ HH24:MI:SS') +
(C3 / ( 60 * 60 * 24 )), 'MM/DD/YY HH24:MI:SS') FROM T40;
SQL
---
select dateadd(second, c3, Jan 1, 1970) from T7
On
Database independent:
1) Define a display only field of type date
2) Set value 01/01/1970 char in the newly created field
3) Define a result field of type date/time
4) (2) step + integer value = (3) step
From: Action Request
Keep saying that mantra, and you'll start to believe it
thats a good idea on the email form, but ultimately the solution should come
from management, who must enforce correct utilisation of the applications.
The idea of anyone being able to log tickets to any group is just
ridiculous,
Thanks everybody for all your help.. I got this correct finally... I added
one run-if condition to the 2nd filter where it chks for null value in one
of the duplicate fields.. and only if it is Null thn the tkt is pushed
ahead...
Thanks,
Anantha
On 12/7/06, Carey Matthew Black [EMAIL PROTECTED]
John,
No JNI that would be great :) In the past I've investigated doing a light
api in pure Java, but the whole RPC stuff seemed the biggest hurdle. One
could ofcourse build a wrapper around the existing API using collections and
annotations (which I have done just to keep things compatible) but
Hi,
You can use to_date('01/01/1970','MM/DD/YY')+c3/(60*60*24)+5.5/24
function to manipulate it. Here +5.5 is GMT difference from IST time. This
value can vary based on your location. So you can always add(+diff) or
remove(-diff) that amount of time from date field. At place of c3(create
time)
Hello everyone, Happy Holidays.
ARUtilities Suite is now available for half price during the month of December.
The sale will end January 1, 2007.
ARUtilities Suite includes:
ARUtilities 7.0
ARUtilities 6.5
ARUtilities 5.6
ARUtilities 4
ARUtilities 7.0 has had a recent update that addressed
That seems a strange restriction - I would think most service providers
would be glad to get their name in front of more potential customers. Is
there anyone who is allowed to point us there, or if not all of us, at least
discrete customers (like Mr. Strauss) whose use of Remedy applications
It wouldn't solve the major issue, which is that they want to be treated
differently than the other groups from a workflow perspective. This would
set a bad precedent, unless it can make a powerful ally that might be used
for long term good.
Rick
-Original Message-
From: Action Request
Morning All! (from the cold Midwest!!! Brrr,,,)
I'm attempting to set up a list of associated tasks that need to be used for
certain types of tickets,, say for account management. These tickets will
be entered into the Incident Management application. First,, do you think
First, thank you for sharing this information, David. We know more than we
did. The DST change is effective 03/11/2007, so we have a little time to
try to assess impact and plan accordingly.
That said, this news is disappointing. I've understood that our current
release (6.0.1) is supported.
**
Peter,
If you have Administrator training already, the recommended WBT to get you updated is "ARS 7 What's New". The Admin Part 1 and Part 2 is for people new to AR System. If you do the part one, you are going to miss a lot of the more advanced "new" features which are covered in Part 2.
Hello everyone,
I wanted to share my testing of a possible migration path for ARS 5.12 ~~
7.0/01.
1. Tested Migrator 6 / 7p1 / 7p2.
2. Tested ARUtilites Migration (some)
3. Tested DB Move / with Installer Upgrades.
ENV:: Solaris 9 / Oracle 9206 -8i libs ~~ Solaris 9 / Oracle 10.2.0.1 - 9i
libs
OOPS::
Ensure you do not have any MACRO functionality running either -- Make sure
they are converted.. or you can start over.
On 12/8/06, patrick zandi [EMAIL PROTECTED] wrote:
Hello everyone,
I wanted to share my testing of a possible migration path for ARS 5.12 ~~
7.0/01.
1. Tested Migrator
NOTE:: I am not DIS'ing ARUTILITES / PANACEA / OR MIGRATOR.. It is just the
simple fact that you are moving through too many changes // system
modificaitons.. They are no made to Modify Structures (ars 4 to 7) .. it is
not designed to do so..
I would afterward use this to keep you data / forms //
Good deal! I just bought a copy for myself.
Thanks.
Stephen
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Friday, December 08, 2006 7:48 AM
To: arslist@ARSLIST.ORG
Subject: OT: ARUtilities Holiday
I think everyone should ;)
Good deal! I just bought a copy for myself.
Thanks.
Stephen
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Friday, December 08, 2006 7:48 AM
To:
I thought about that. However, I noticed the class session ones for
Service Desk 7.X, Change Management 7.X and CMDB all have the Admin 1
class as a Prerequisite so thats why I figured to go with that one.
BMC might be fine if I took that What's New class instead to satisfy
that prerequisite.
Well..
(oracle install 10.2 - oracle install of client 9i) --
I installed these and tested them with a demo ars 7.01 first.. had that all
working..
(approx 1 or 2 days)
Then started with dropping all the Tables -- Below (1 long day)
So 2 - 3 days I suppose.. at most.
On 12/8/06, [EMAIL
We use this a lot--SQL Server specific
SELECT dateadd (ss, YOUR_INTEGER_FIELD, '1970-01-01') from
This returns a date/time value with your default format: You can further add
date formatting commands to this statement to get it into prettier formats if
your default format needs
I've understood that our current release (6.0.1) is supported. I
suppose it's possible that I misunderstood
the compatability matrix.
6.0.1 is a supported platform, although under BMC support policy it in
Limited Support.
Our management here has raised more and more concern regarding
accurately tracking assets in our enterprise.
We are starting to look at ways of scanning our asset tags and are
trying to find ways of getting an interface so that the scanned
information can update our Remedy Asset Management
Hello list:
We are in the process of upgrading Oracle to support an upgrade of
ARS. We are moving from Oracle 9i to Oracle 10gR2 and then will
upgrade ARS from 5.1.2 to 7.0.1. The question the DBA presented me
is... does ARS make use of any of the following Oracle default
schemas, or can they
Mark,
Not that I know of..Remedy using ARadmin tables, and any links that you
need..
you could use remedy to access the scott / hr tables for testing purposes..
your choice..
like a Testbed of sorts.. This way you don't mess with your prod data.. who
cares about scott's tables..
But there is
I'm pretty sure that internal Save button functionality you see on the
toolbar is a built in feature. Not sure if you can actually capture the
event of when a text box contents changes real-time, but only when it
enters or loses focus.
One way I suppose you could do it is run an AL every second
You could push the calculated values to a separate temp menu form and use
those records in your menu.
Create a GUID in a display only field for the set of records before you
start to push the values to your temp menu form. Push this GUID to the new
records along with the values. Then your menu
Patrick, you are so cute!
IMHO, the best way to perform an upgrade is to start with a brand new
server and map my fields from one database to the other, but I like
doing a lot of work. ;-D
J Meyer
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL
What great timing! I just had to do this earlier in the week. You
can use an sql menu with unions. This creates a list of 3 email
addresses from character fields in the parent record. Of course, if
it were from the current form, the where clauses would be WHERE
entry_id = '$1$'
SELECT
Thanks, Zandi. I know ARS creates background schemas of its own like
ARSCHEMA and FILTERS... etc., and since it functions across several DB
platforms, I didn't think it would have total reliance on Oracle
default schemas. But, if it does make use of them, say to improve
performance when on
Wow, awesome..
I am Totally impressed with your work ethics !!
How long does it take for you to migrate a server ?
On 12/8/06, Meyer, Jennifer [EMAIL PROTECTED] wrote:
Patrick, you are so cute!
IMHO, the best way to perform an upgrade is to start with a brand new
server and map my fields
Actually, I am looking further into this..
I think OE is needed.. Oracle using this for security side..
if he is Hardening the server..
check this
http://www.oracle.com/technology/deploy/security/pdf/twp_security_checklist_db_database.pdf
I am looking around at the rest..
On 12/8/06, Mark
Peter, there are TONS of cheap and functional Bar code scanning applications
out there. I wouldn't focus so much on those on the front end as much as I
would look at the back end to ensure that it will be easy to
interface/migrate/transfer its information into something your Remedy
applications
Hello List,
I've got an API that searches for a Record X in Form A. I created a Java API
for this under the 6.3 version on our test server and it worked fine. Now
we've upgraded this server to 7.0.00 Patch 002 200607211559 and when I ran
it, it gives me this error:
#
# An unexpected error has
UNCLASSIFIED
I can highly recommend AEROPRISE, MOBILE REACH or NAVARA - each company
has a slightly different expertise because scanning is not equal to
scanning. Barcode readers are varied in what a reader picks up and
how it interprets code as well as it's capability to be programmed for
That's interesting on OE. Here is an excerpt from my (pretty darn
fast actually) Remedy Support response:
ARSystem uses its own Table Space and Schema so none of the ones
listed would apply, unless the previous install was put in one of
them? which is doubtful
considering the issues you would
Thanks for all the ideas; I am new to SQL menus.
Would it be Select (Field Name1) FROM (Form Name) WHERE entry_id = '1'
UNION SELECT (Field Name2) FROM (Form Name) WHERE entry_id = '1'
If not, how do you find the SQL values for your forms?
thanks
Anthony
-Original Message-
From:
One thing I would Really look at as well.. would be the implications on your
ability to Patch these boxes.. Afterward.
Test that good.. for example.. Take an oracle 10.2 box Stock, and Rip those
above out.. then Patch with the April and Oct CPU Security patches.. see how
that works..
The last
Thanks for all the ideas; I am new to SQL menus.
Would it be Select (Field Name1) FROM (Form Name) WHERE entry_id = '1'
UNION SELECT (Field Name2) FROM (Form Name) WHERE entry_id = '1'
This is correct, except you will want to use '$1$' instead of '1'
If not, how do you find the SQL values
Yes, there is an open source Java API at
http://www.sourceforge.net/projects/joarse.
I didn't take advantage of Java 5 features such as generics at the time I wrote
this, but I think now it would be appropriate to do so as Java 5 has been
available for quite some time now. I don't have time
Again, thank you. This confirmed my understanding.
Good read for anybody not certain of BMC's support position for their ARS
release.
Mike White
Office: 813-978-2192
E-mail: [EMAIL PROTECTED]
6 weeks to a year. Depends on the requirements and the level of idiocy
of whomever's in charge. You know how it is: Clear Requirements
Vision make for an easy project whereas Vague Requirements and Scope
Creep are every developer's nightmare.
-Original Message-
From: Action Request
Rather than start any new projects, please consider adding to these existing
projects:
C++ (uses STL for collections, exceptions, and provides encapsulation of memory
management. Compiles on Windows, Linux, Solaris.)
http://www.sourceforge.net/projects/rtl
Why you should use this:
We at Specific Integration, Inc. are searching for additional Remedy Developers
to join to our staff project team in the Washington, DC area. Specific
Integration is a long time Remedy Integration Partner. We have an immediate
need for developers in the DC Metro area to support private and
Tee-Hee!
Hard as it may be to believe, there are managers out there who do work
without their shoulders permanently super-glued to their thighs. Some
of them have an idea where they want to go and how they want to get
there and can even spell requirement and say no. Even more
difficult to
Mikhail,
While it could be a bug in the v7 server. However, it is also (and
maybe even as likely) an incompatibility between the v6.x JNI/Java API
and the Java Version - 1.5.0_10 JRE that you are running the client
in.
If possible, it would be an interesting test to try to run this code
in the
And now, a bit of a rant.
What in God's name do we pay all of the money in support to BMC for if they
cannot even provide a halfway decent support website?
It's next to impossible to get anything to work! Every time I try to use
the Knowledgebase, it jumps me back to the support home page.
**
Older Admin class + What's new = New Admin class as far as BMC is concerned.
I've sent several of my team to training using this combination.
You might as well get the benefit of the What's new class when the cost is the same ;)-Kelly DeaverDirector, ITSM
Totally Agree. I cant find anything either and am also brought back to
the support home page. Makes me crazy.
katherine.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the
Answers Are
Speak softly...
carry a big stick!
On 12/8/06, Meyer, Jennifer [EMAIL PROTECTED] wrote:
S, Warren. You know better. Flames belong in ALL CAPS!
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Warren Baltimore
I have an issue when a change request is submitted. Initially the user
will create the change request and under Support Information they
choose the group ( we only have one ) and they pull the the Supervisors
name from the drop down list that is supplied. When this happens the
tickets will not
Sometimes, Like me.. you have to have the support folks fix this
personally..
I just gave them my userid and password Shh
and said SEE I am not Crazy..
I was then reminded of the quote from the Bible..
*Rev 8:1* And when he had opened the seventh seal, there was silence in
heaven about the
I'd say check what is being sent to the shr:consolidatedlist, then look at
your submit and modify filters (on my 6.3 install they are called
shrc:shr-modifyconsolidated12, and shrc:shr-submitconsolidated). Are you
sending the full name or the Assignee Login Name for the Assigned To field?
I agree. It makes me laugh that a business like this is not able to have a
decent support web site.
Very stupid and annoying!
Mathieu Pitre
IT Business Systems Analyst
Production Operation
Computer Sciences Corporation
Pratt Whitney Canada, Plant 1
Sametime: Mathieu Pitre
office:
What patch(es) are you on?
Nick
Havin' Fun in Sacramento - CA
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heynewgirl
Sent: Friday, December 08, 2006 10:56 AM
To: arslist@ARSLIST.ORG
Subject: Issue with Change Requests
I
**
Let face it folks. It seems since BMC has taken over the Remedy Family
product.
They have not been very interested in the users.
They basically wanted it so they could show case they other products.
The web site has become a piece of $%^. I would have expected more from
a company,
But
Yet another option
The following T-SQL functions convert date/time to/from Remedy and account
for GMT and Daylight Savings Time (set up for Canada):
/* NOTES on this function:
Input parameters @GetUTCDate and @GetDate expect the results of the
GetUTCDate() and GetDate()
built-in functions
On Fri, 8 Dec 2006 07:47:44 -0500, [EMAIL PROTECTED] wrote:
Hello everyone, Happy Holidays.
ARUtilities Suite is now available for half price during the month of
December.
The sale will end January 1, 2007.
ARUtilities Suite includes:
ARUtilities 7.0
ARUtilities 6.5
ARUtilities 5.6
ARUtilities
Did you hear that they're cutting more support staff next month? I don't
know details, I've just heard from reliable sources that some people there
are looking for other work in advance of the axe.
BMC business plan: Let's pull one of the legs off the stool on which we
stand - it'll still
Dang it. I bought my copy on 11/28...
Well worth the money. Great tool.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Friday, December 08, 2006 11:06 AM
To: arslist@ARSLIST.ORG
Subject: Re:
Apologies to the list for resending this. I meant to send it solely to
myself as a reminder. It is a very useful product!
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the
Answers Are
Well they don't need the large oops small support staff since there self
support website is working so well.
Luck we have 3rd part support.
But I heard our support is going over seas also.
There lucky I don't pay the support bill.
Dan Caissie
From: Action
Peregrine
$.02
J Meyer
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
Sent: Friday, December 08, 2006 12:30 PM
To: arslist@ARSLIST.ORG
Subject: Re: BMC SupportWeb is GARBAGE
**
Did you hear that they're cutting
I am on patch 18. On my change request there is no assigned to field.
Just Supervisor. It is also the Supervisor who does the work. In my
area the supervisor doesnt mean the manager type. So when I choose
the Supervisor+ from the drop down nothing will show up in the
Supervisor+ queue. Its
Jennifer,
Dirty words are generally put in special characters like [EMAIL PROTECTED] [EMAIL
PROTECTED]^
Susan
On 12/8/06, Meyer, Jennifer [EMAIL PROTECTED] wrote:
Peregrine
$.02
J Meyer
-Original Message-
Wrom:
Shameless Vendor Plug***
Well, you're always welcome to sign a support contract with Strategic
and have me support you. I can't guarantee I know any more than you do,
but I'm really good at sympathizing, and you won't have to deal with
BMC's website any more. And I
Susan,
I cuss like a sailor in RL, too. ;~
J Meyer
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer
Sent: Friday, December 08, 2006 4:39 PM
To: arslist@ARSLIST.ORG
Subject: Re: BMC SupportWeb is GARBAGE
**
And I have great hair.
Heck Jennifer, that's as good a reason as any!!
Thanks for the smile, I needed that!
Warren
On 12/8/06, Meyer, Jennifer [EMAIL PROTECTED] wrote:
Shameless Vendor Plug***
Well, you're always welcome to sign a support contract with
Did you already change the Group name on the ticket? And
Do you have your Remedy Agents (who are in APP-Support) in a Support
Group?
It depends on how you want the product (Remedy) to conform to your
organization, or vice-versa...
-Original Message-
From: Action Request System
Hi All,
In the year 1998 we where looking for something that will solve our
requirements. Two Americans came here in Romania. They brought a box
with documentation and software. The presentation regarding Remedy
products was very professional. In this conditions the decision was very
easy: ARS
Gee I wish I had hair :-(
*Rocky*
Rocky Rockwell
eMA Team – Remedy Developer
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
Ph#1: 214-567-8874
Ph#2: 325-884-1263
Warren Baltimore wrote:
**
And I have great hair.
Heck Jennifer, that's as good a reason as any!!
Thanks for the smile, I
I'm sorry to hear that Daniel. Just goes to show that BMC has a big problem
that they need to resolve ASAP. I'm a big fan of the Remedy ARS platform.
I can make it do all sorts of things. But more and more, whenever I have to
deal with support I groan. That's not to say that I have a problem
Competition is healthy. Maybe it is time for some outside influence.
Axton Grams
On 12/8/06, CONDREA, Daniel [EMAIL PROTECTED] wrote:
Hi All,
In the year 1998 we where looking for something that will solve our
requirements. Two Americans came here in Romania. They brought a box
with
The real issue comes from the fact that the real competition is in the
US when it comes to software products. The competition tends to dye
while crossing the Atlantic ocean. The competition keeps on dying while
it moves to the east.
There on the Romanian market software services for ARS are
This site is handy if you just want to get a general timestamp from a
date for use in ad-hoc queries:
http://www.onlineconversion.com/unix_time.htm
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Veeral J Oza
Sent:
Most Barcode readers would dump a CSV/text file on your machine once you
'cradle' them. To get this info into Remedy, you would need a small app that
can automatically read this csv and push the data into an Asset form. This
is also usually available with the Barcode solution provider...
You
Try this
select dateadd(s,1155032236,'1/1/1970 03:00 am')
kulap
_
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Luke, Brian
Sent: Saturday, December 09, 2006 3:32 AM
To: arslist@ARSLIST.ORG
Subject: Re: Retrieving Date from SQL
78 matches
Mail list logo
