We are planning to use Atrium Integrator 7.6.04 to transfer data from a Oracle
staging database to the respective Classes.
What Oracle Datatype to be used for the Date fields in the staging database ?
For e.g.
Submit date
Installation date etc
Oracle Datatype Integer or Timestamp?
Oracle Datetime will do.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Madhu
Sent: Friday, January 17, 2014 4:38 PM
To: arslist@ARSLIST.ORG
Subject: Atrium Integrator - Date Field - Data type
We are planning to use
Thanks Yogesh. I'll try.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years
List,
Anybody have any words of wisdom from there experience of installing SQL
Server 64 bit on a Windows 2008 server that will be used by ITSM 8.1.
Both will be fresh installs no upgrading.
Thanks,
Teresa
___
I've been troubleshooting a problem with my server group. Along the way, I
noticed in the arsignal log that the following was being issued fairly
regularly:
arsignal *-z* [SERVERNAME]:[PORT] [RANDOMUSERNAME]:258999161|, Q-size=0
When I pulled the documentation on arsignal though, there is no
Howard:
I can tell you that we measure MTTR using the Business Hours Duration field
from the Assignment Log form. But I can't tell you whether that value gets
calculated excluding the time spent in Pending status or not. And you have to
be a little careful with it, at least if you build your
This hasn't impacted me yet, but I think BMC created a lot of this mess by
having CMDB = Asset Management for so long and now splitting it out further.
Based on what you've said, it will be interesting to me as well to see what
happens with ADDM because we're discovering the location based on
AR 7.6.4
I am looking to switch from Oracle to MSSQL and when I asked my DBA manager
what the cost of the SQL license would be he fires back this.
My first concern is when we talk to Remedy what is their breakdown of what %
of people use what database? Secondly what is the expected size of the
I need to run a report for all open tickets for the past 24 hours. This will
include SRM requests, incidents, changes, work orders, and problem tickets. Is
there a backend form that I could report off of or should I create a join for
reporting for all of them? Trying not to do multiple
I would be shocked if you could get that information from them. I don't
believe that anything they do requires them to find out from you what DB
you are using. Any shop I am familiar with has made the decision based on
the people they have to support a specific DB type. If you have MSSQL DBAs
My guess is that BMC could probably answwer the question regarding overall
usage. I can tell you that MS SQL is widely used though (we use it here).
Oracle v. MS SQL arguments are kind of like apple v. windows. Lots of
emotion Have fun!
On Fri, Jan 17, 2014 at 11:25 AM, Tommy Morris
Oracle to SQL X .20 or add 20% for sizing ... Why? Clobs and Blobs
are different in sizing.
Speed -- well... Cough cough... ... hopefully you are not leveraging your
cluster..
--- hope that helps some. I am doing the same right now.. sniff sniff
On Fri, Jan 17, 2014 at 11:25 AM,
There is a defect open for this : SW00462392, but BMC considers this a RFE.
Thank you for the information about what they did. It makes it a bit more clear
about they did it, but it still does not help me sell the upgrade. The is more
to it than just the process itself. This change impacts a
Tommy,
BMC has customers on both Oracle and MS SQL in significant numbers.
UNAUDITED but from what we see, the most used database is MS SQL (maybe 60% and
then Oracle in
the say 30% or a bit more range and others in the less than 10%).
Smaller customers are much higher on the MS SQL side.
Hi Guys,
We have a customer who has a few managers that use the SRM Request portal to
submit/view requests and also view tickets raised by other users via the
Busniess manager console.
Not all of this customers users have login Ids for Remedy. 90% submit calls
via phone and only a select few
Thanks to everyone. I think that I have enough to send to the DBA's. Good info
here and I also received some info from our Remedy support partner. All this
should help.
Gotta love ARSList!
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller,
Terry:
Do you have Analytics? If so, you'd have to create separate queries for each
module, and it would be easier if you created separate tabs for each module,
but you could generate a single report document that pulls all of that.
Natalie Stroud
SAIC @ Sandia National Laboratories
ARS-ITSM
Fred,
The 8.1 release of the AR System requires Oracle 11g. So, 11g and later has
everything.
Now, Oracle has been doing things for years and closing in on this issue. They
have added partial support
and some conditions. But, until now, we have not had success with finding all
the right
Thought I would share this here. Jesse from Support has asked for feedback
on how they can make their KB better (not RKM).
He started a discussion specific to AR System here: How can we make the
ARSystem knowledge base
better?https://communities.bmc.com/message/390122#390122
Which is a offshoot
There are special indexes to build (we do that for you for all new indexes
and you have to do a cleanup
script to convert any existing indexes to the new type) for indexed
searches to work and with the right
settings of options all other comparison operations work.
Do I request those scripts
Doug,
This is awesome!! Thank you for sharing this! You have no idea how happy some
of my users will be!I have already asked my DBA to look into the Oracle
version we are on and the possibility of doing an upgrade!
ITSM 7.6.04 SP2
ARS 7.6.04 SP3
Oracle 11.2.0.3.0 - 64bit Production
Win
I would look at the form the Overview uses in the main table
Sent from my iPhone
On Jan 17, 2014, at 11:28 AM, Terri Lockwood teresa.lockw...@sungard.com
wrote:
**
I need to run a report for all open tickets for the past 24 hours. This will
include SRM requests, incidents, changes,
Completely unscientific but it seems I have noticed more people asking
about moving from Oracle to SQL Server in recent years. A trend?
Jason
On Fri, Jan 17, 2014 at 8:41 AM, patrick zandi remedy...@gmail.com wrote:
**
Oracle to SQL X .20 or add 20% for sizing ... Why? Clobs and Blobs
I don't have the answer to your question however we moved from only IT and
certain business users having User records (our older system) to all
employees and affiliates having User records so SRM can be used by
everybody. To us it just made sense that we want them authenticated so we
added them.
cost:: that is all... for us.
IMHO
now sure how scientific that is.. 8-)
On Fri, Jan 17, 2014 at 12:57 PM, Jason Miller jason.mil...@gmail.comwrote:
**
Completely unscientific but it seems I have noticed more people asking
about moving from Oracle to SQL Server in recent years. A trend?
Patrick,
Here is a KB article on the subject that includes a discussion configuration
and a reference to the cleanup
script for the indexes.
https://kb.bmc.com/infocenter/index?page=contentid=KA406947
Oh, and Fred I notice you need the 11.2 Oracle clients not just 11g. (see
what reading
Isn't this the nature of software? Software changes. Hopefully over all
for the better but often better isn't better for everybody. Remember
when MS introduced the ribbon? That worked well for some and not very
well for those that were depending on the old menu style. Every software
company
All,
I think that the field I was looking for is called UpTimeChar on the incident
is closed. I think that this will only show the total time the incident was
worked, minus pending, holiday schedule and non-working hours. However, that I
need to verify.
With that said have a great weekend,
**
Because the current status isn't really an important value to the service target, it is not stored on the SLM:Measurement form. They way I've gotten around this in the past is to either create a reporting join or an actual Remedy join form. You can do all kinds of interesting reporting if you
I don't have an answer but if you ask about it on the wiki page the IDD
team should research and update the documentation.
Jason
On Jan 17, 2014 7:17 AM, Warren R. Baltimore II warrenbaltim...@gmail.com
wrote:
**
I've been troubleshooting a problem with my server group. Along the way,
I
30 matches
Mail list logo