All,
Not sure if this is possible, but is there a way to get the results from
a stored procedure via set-field-sql into ars.
This works in Query-Analyzer
declare @p_result int
exec SP_TEST 'MDP00072713', @p_result output
select @p_result
But in a set-fields-sql $1$ is always null.
ARS
Hi,
We have now gone into production, and I have a couple of things I want to
share about this...
The two servers in the server-group are (now) 7.1.0 patch 008.
We have ITSM7 instaleld.
We can call the servers USER and ESCL, to indicate their major use.
The final way we did it was to have the
One point about Impact relationships - BMC plans to drop them!
The base relationship class now includes impact information.
In the future any relationship will be able to hold impact information
which should reduce the number of relationship CIs needed to model an
environment.
Cheers
Peter
I followed the steps on the BMC Atrium CMDB 7.5.00 Administrator's Guide(Page
161) and created a Data Visualization Field,From the Definition list,I
selected the Atrium Explorer,I set namespace= + BMC.CORE) +
,classname=) + $Name$) + ,datasetid=) + $DatasetId$) + ,instanceid=) +
Conny,
Yes it is possible.. how are you calling/executing the stored procedure when
you are using it in the set-field-sql?
Begin procedure name;
works from the ARS with Oracle as the backend DB.. (I'm not 100% certain if
you need the semi colon in the end)
I'm not sure if that would work with
Joe,
I'm calling it the same way as in Query Analyzer.
declare @p_result int
exec SP_TEST 'MDP00072713', @p_result output
select @p_result
No Errormessage is returned but $1$ doesn't get the value from p_result
With oracle there is no problem. One can just do
select
There is a small difference on how you call stored procedures while using
either the direct SQL or the set field SQL feature from the ARS at least as
far as Oracle is concerned.. When using the Oracle client SQL*Plus, Execute
procedure name works, but from the ARS interface for SQL, EXECUTE
Hi Conny/Joe
Not sure if it helps but MS SQL doesn't require any helper table so where in
Oracle you might use:-
Select sysdate from dual ;
In MS-SQL you could use
select getsysdate
Perhaps you can do something similar with your SP?
Select sp
Failing that - you
Frank,
great, it works.
Thank you for your assistance.
Kind Regards Conny
Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Frank Caruso
Gesendet: Donnerstag, 10. Dezember 2009 11:32
An: arslist@ARSLIST.ORG
Hi,
Just to clarify.
This more or less proves that it is a BAD idea to have Cache-Mode set to
Development on any server in the Server-Group but the Admin-server.
The Admin-server seems to just patch in the modification directly in
memory. The other servers allways need to recache everything
You really need to be careful with development cache mode on production servers
for the following reason;
With this option set the server has only one copy of the cache to work with.
This may provide some advantages in terms of memory usage but consider the
following..
A user starts a long
Running arsystem 7.1
Cmdb 2.0.1 patch 3
We have added several fields to the CMDB without issue, now the following is
happening.
Once I add a field to CMDB, this happens to the arsystem.
Thu Dec 10 01:42:16 2009 390600 : AR System server terminated when a
signal/exception was received
Both AR database (Oracle) and the external database (MS SQL) are on
Windows 2003
On Tue 08/12/09 20:13 , Grooms, Frederick W
frederick.w.gro...@xo.com sent:
The first question is what platform is your database on.
FROM: Action Request System discussion list(ARSList)
Yes, directly against the db. The main reason is so that the high water
mark is reset on the table. You basically won't have any
performance/overhead gains unless you do this.
http://www.adp-gmbh.ch/ora/concepts/space_management/high_water_mark.html
Axton
On Wed, Dec 9, 2009 at 4:58 PM, Ex
Hi,
We have taken all this into account.
1. The escalations are run on another server
2. Admin-changes will never be applied during production hours
Without Development-Cache-Mode set, the server frequently timed out when
doing admin changes. This seemed to be because of the buffer-copying when
The version of CMDB you are on is incompatible with the version of ARS
you're on. We had the same problem here.
You'll need to contact BMC Support and have them help you clean up the
meta-data that is now inconsistent, then upgrade/patch your CMDB.
Some excerpts from my previous issue:
Brian,
The document you mentioned, Mapping Your
Data to BMC Atrium CMDB 7.x Classes, is very helpful. It specifies in detail
how to relate CIs as well as types of relationships classes.. good read!
Thanks,
Marcelo
Peter Romain,
Thank you for pointing out about the Impact Relationships. I am
Thank you
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Tony Worthington
Sent: Thursday, December 10, 2009 10:19 AM
To: arslist@ARSLIST.ORG
Subject: Re: CMDB Change stuck in Change Pending - Processing
The version of CMDB you are on is
David, can you explain what IT Service Management Solution Pack means? If I
have Service Desk only, do I qualify?
On Mon, Dec 7, 2009 at 1:30 PM, Easter, David david_eas...@bmc.com wrote:
Lastly, BMC's SMPM tool would be very helpful. I posted a question about
who is entitled to a
Good morning,
Does anyone out there have any integration setup between Remedy and TFS? Its a
product that
we purchased to replace ClearQwest and we are looking into integration options.
Any feedback would be great!
Thanks,
-Cindy
CONFIDENTIALITY NOTICE:
This e-mail transmission may contain
Wellbased on the minimal research I just did on TFS...if it is in fact
the product referenced in the link below, it's a follow-on to the SourceSafe
product formerly provided by Microsoftthat being the case, the current
source control integrations available in 7.1 and below don't work very
Good morning,
We had a recent problem where a bunch of our Asset data was wiped out. The
records exist, but some of the fields were made null. I came up with the idea
of using AIE to fix this problem by restoring the Asset data from a backup and
treating it as external data to import.
How was the data put into Asset? Config Discovery? Manual?
If it's Configuration Discovery, there's a bunch of unique fields...
Why wouldn't you be able to match using Instance ID?
Tauf Chowdhury | Forest Laboratories, Inc.
Analyst, Service Management
Mobile:646.483.2779
From:
It was manually entered, unfortunately.
Thanks,
Shawn
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Chowdhury, Tauf
Sent: Thursday, December 10, 2009 11:34 AM
To: arslist@ARSLIST.ORG
Subject: Re: Using AIE to restore Asset Data
**
How was the
why don't you match on CI Name?
On Thu, Dec 10, 2009 at 10:37 AM, Pierson, Shawn shawn.pier...@sug.comwrote:
**
It was manually entered, unfortunately.
Thanks,
Shawn
*From:* Action Request System discussion list(ARSList) [mailto:
arsl...@arslist.org] *On Behalf Of *Chowdhury,
Are you saying that you have a backup of the Asset data that was in Remedy?
Does that backup include the Reconciliation ID? If it does, then you don't
need to match on anything, you would simply need to do a Merge between the
datasets, because everything should already be matched up (by
Listers,
Is it possible to create view forms from an Oracle based AR system to remote
MS SQL Server?
I successfully created the database link and I could access the MS SQL tables
from sqlplus but when I tried to create view forms I received:
Failure during SQL operation to the database:
I'm trying now to add the attachment to the field, but guess i'm doing
something wrong.
For add the attachment i'm using a filter with a Run Process that calls for:
$PROCESS$ PERFORM-ACTION-ADD-ATTACHMENT 536880912
/home/remedy/fit_ftp/other.txt
The filter is getting executed but, the
What version and patch? Bugs around this process...
Tony Worthington | Sr. Technical Analyst | Kohl?s Department Stores
N56 W17000 Ridgewood Drive | Menomonee Falls, WI 53051 | office: (262)
703-7763 | e-mail: tony.worthing...@kohls.com
From:
Hyunkel v2.0 lord_dyna...@hotmail.com
To:
There are duplicates in the CI Name field, as there are in serial number. This
data was not of great quality but it's what the users want.
Thanks,
Shawn
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of DCI Remedy
Sent: Thursday, December 10, 2009
We didn't do any reconciliations because the users who own this data don't
trust automation (which unfortunately did cause the problem in this case) so
they wanted to perform the creation and updates of Computer System CIs manually.
My plan was to use AIE, but since the data I want to fix is
ARS 7.1 patch 007
Unix Server -- Solaris 10
The file is storage on the unix server.
Hugo Ruesga
perotsystems®
US 972.577.7000
MX +52 (33) 3332.3868
P Please consider the environment before printing this email
The information contained in and transferred with this electronic message is
Note that you can use multiple fields for identification in reconciliation.
So, if you can define a groups of fields that uniquely identifies each asset,
you should be able to import the backup data into a dataset, identify between
them using this group of fields, and then merge them. Note
Victor,
When you access the database view from oracle using SQL*Plus, are you
logging into SQL*Plus using the same username and password
(ARAdmin/AR#Admin# if you are using defaults) that is used by the AR System
to connect to the Oracle database?
If no, then do that and then try to access the
Is 536880912 a Display-Only attachment field?
Does the user running the AR System on UNIX have access to the path as well
as the file to be attached?
Joe
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Hyunkel v2.0
On Thursday 10 December 2009 20:30:37 Joe D'Souza wrote:
Victor,
When you access the database view from oracle using SQL*Plus, are you
logging into SQL*Plus using the same username and password
(ARAdmin/AR#Admin# if you are using defaults) that is used by the AR System
to connect to the
What if you import the entire data, verify it and then delete all data old
date... Create Date $DATE$
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Thursday, December 10, 2009 1:18 PM
To: arslist@ARSLIST.ORG
Subject: Re: Using
Thanks Joe,
I will try all you said and have you posted tomorrow(I'm out of office at the
moment) but I want to point out that will creating the view form I was able to
load the table and the pick the fields required for the form.
Only when I pressed Create the error occurred.
.. and
I've just come up with a way to solve my problem. I am matching on the TokenID
field, but I copied the contents of the InstanceID field over to the TokenID so
it is truly unique now, and I don't have to worry about duplicate CI Names,
Serial Numbers, etc.
Thanks,
Shawn Pierson
From: Action
Hello Victor,
That is what I suspected with the invalid identifier error.. if your table
was not recognized it would be invalid table or view name error which is not
your case.. Which is why the later part of my previous email holds good..
Take a SQL log, you may find that offending column name
The field is an Attachment Field and yes the user that runs the ARS application
is the owner of the directory and the file.
Regards
Hugo Ruesga
perotsystems®
US 972.577.7000
MX +52 (33) 3332.3868
P Please consider the environment before printing this email
The information contained in and
HI Hugo
I looked in the manual and could not find any really useful information about
this process. However I did have one thought. Have you tried it without the
double quotes? Might try single quotes too. Just a thought
Mark
From: Action Request System
Good thought, Mark. I have seen numerous documentation bugs in that area, so
don't take the listed syntax as gospel.
Rick
-Original Message-
From: Brittain, Mark mbritt...@navisite.com
Date: Thu, 10 Dec 2009 15:24:05
To: arslist@ARSLIST.ORG
Subject: Re: Add-Attachment
Hugo,
I meant is it a Display-Only field? You may have created a Display-Only
attachment field instead of a data attachment field by mistake.
Worth checking..
Joe
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Hyunkel
We have an Avaya system and our customers are very happy with the integration.
I wasn't involved in the implementation, but I think it wasn't too big of a
project. I do know we brought in a Avaya contractor to do it.
Anne Ramey
From: Action Request System discussion list(ARSList)
Thanks Mark;
I've tried that, but still not attaching the field
Best Regards
Hugo Ruesga
perotsystems®
US 972.577.7000
MX +52 (33) 3332.3868
P Please consider the environment before printing this email
The information contained in and transferred with this electronic message is
intended
Thanks Joe;
Not, It's an optional field.
Best Regards
Hugo Ruesga
perotsystems®
US 972.577.7000
MX +52 (33) 3332.3868
P Please consider the environment before printing this email
The information contained in and transferred with this electronic message is
intended only for the
Help.. can someone please verify what I'm doing please?
According to how I understand the documentation, the first table should be
correct. Do you concur ?
CIs:
Remedy System: BMC_ApplicaitonSystem
Exchange System: BMC_ApplicaitonSystem
Rem001Server: BMC_ComputerSystem
SQL0001Server:
Hi, is the attachment to big
regards
Stuart Schon
Team Leader-Remedy
FUJITSU AUSTRALIA LIMITED
Level 3, 2 Julius Avenue, North Ryde, NSW 2113, Australia
T 02 9113 9435 M 0439 475 240
stuart.sc...@au.fujitsu.com mailto:tracy.mccorm...@au.fujitsu.com
www.au.fujitsu.com
I would say that your first table seems more correct, except that I think you
probably have the Source and Destination columns backwards (the Source depends
on the Destination, not the other way around, IIRC). In addition, I don't
think that your Rem001server computer system depends on the
Hi Stuart:
No, The attachment field is set tu 'ulimited', and the file barely reaches 1Kb.
Best Regards
Hugo Ruesga
perotsystems®
US 972.577.7000
MX +52 (33) 3332.3868
P Please consider the environment before printing this email
The information contained in and transferred with this
The reason I had them backwards is because that is how I interpret this
document (see attached)..
Look at line 21 on page 8. But since I don't use BMC_SoftwareServer I
substituted it for BMC_ComputerSystem.
It isn't clear to me if the source depends on the destination OR
if the source is a
OK. I see what you're saying. It does seem to list things the way you had
them in your table implying that the destination depends on the source.
Perhaps we were doing things completely backwards... And that just further
confuses the whole idea of what's the parent and what's the child,
I will be out of the office starting 11/12/2009 and will not return until
21/12/2009.
I have very minimum access to mails during my vacation. I will give you a
reply once I come back.
For Carphone Warehouse account please contact Suneel Pallamreddy (or)
Sujatha N Babu1.
For other TIM accounts
Dear LIst,
I am facing a issue in sending mail from remedy system in HTML format..
I have copied the format in the Template form. Have created a form say XYZ
which stores the exact name of the template. This in turn is set to the
helpdesk form.
In the notfiy filter i have copied the template
55 matches
Mail list logo