Issue in Sending Mail in HTML format

2009-12-10 Thread Nair, Rajesh IN BOM SISL
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 name

Gurudev Ankam is out of the office.

2009-12-10 Thread Gurudev Ankam
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 p

Re: CMDB mapping question: dependency vs. component

2009-12-10 Thread Lyle Taylor
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, beca

Re: CMDB mapping question: dependency vs. component

2009-12-10 Thread Martinez, Marcelo A
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 depend

Re: Add-Attachment fail on Filter

2009-12-10 Thread Hyunkel v2.0
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 electr

Re: CMDB mapping question: dependency vs. component

2009-12-10 Thread Lyle Taylor
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 data

Re: Add-Attachment fail on Filter

2009-12-10 Thread Schon, Stuart
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 www.au.fujitsu.com

Re: CMDB mapping question: dependency vs. component

2009-12-10 Thread Martinez, Marcelo A
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: BMC_C

Re: Add-Attachment fail on Filter

2009-12-10 Thread Hyunkel v2.0
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 recipient(s

Re: Add-Attachment fail on Filter

2009-12-10 Thread Hyunkel v2.0
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 o

Re: ASK FOR RECOMMENDATION ABOUT: Computer Telephony Integration (CTI) for Remedy

2009-12-10 Thread Ramey, Anne
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) [mailto:ar

Re: Add-Attachment fail on Filter

2009-12-10 Thread Joe D'Souza
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

Re: Add-Attachment fail on Filter

2009-12-10 Thread Rick Cook
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" Date: Thu, 10 Dec 2009 15:24:05 To: Subject: Re: Add-Attachment fail on Filter HI Hugo I looked in the

Re: Add-Attachment fail on Filter

2009-12-10 Thread Brittain, Mark
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 discuss

Re: Add-Attachment fail on Filter

2009-12-10 Thread Hyunkel v2.0
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

Re: View form from Oracle based AR system to remote MS SQL server

2009-12-10 Thread Joe D'Souza
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 or

Re: Using AIE to restore Asset Data

2009-12-10 Thread Pierson, Shawn
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 R

Re: View form from Oracle based AR system to remote MS SQL server

2009-12-10 Thread Victor
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 furtherm

Re: Using AIE to restore Asset Data

2009-12-10 Thread Martinez, Marcelo A
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

Re: View form from Oracle based AR system to remote MS SQL server

2009-12-10 Thread Victor
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

Re: Add-Attachment fail on Filter

2009-12-10 Thread Joe D'Souza
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 Sen

Re: View form from Oracle based AR system to remote MS SQL server

2009-12-10 Thread Joe D'Souza
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 ta

Re: Using AIE to restore Asset Data

2009-12-10 Thread Lyle Taylor
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 tha

Re: Add-Attachment fail on Filter

2009-12-10 Thread Hyunkel v2.0
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 int

Re: Using AIE to restore Asset Data

2009-12-10 Thread Pierson, Shawn
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 lim

Re: Using AIE to restore Asset Data

2009-12-10 Thread Pierson, Shawn
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

Re: Add-Attachment fail on Filter

2009-12-10 Thread Tony Worthington
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" To: arslist@ARSLIST.ORG Date: 12/

Add-Attachment fail on Filter

2009-12-10 Thread Hyunkel v2.0
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 attac

View form from Oracle based AR system to remote MS SQL server

2009-12-10 Thread Victor
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: ORA-00

Re: Using AIE to restore Asset Data

2009-12-10 Thread Lyle Taylor
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 defini

Re: Using AIE to restore Asset Data

2009-12-10 Thread DCI Remedy
why don't you match on CI Name? On Thu, Dec 10, 2009 at 10:37 AM, Pierson, Shawn wrote: > ** > > It was manually entered, unfortunately. > > > > Thanks, > > > > Shawn > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] *On Behalf Of *Chowdhury, Tauf > *S

Re: Using AIE to restore Asset Data

2009-12-10 Thread Pierson, Shawn
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 da

Re: Using AIE to restore Asset Data

2009-12-10 Thread Chowdhury, Tauf
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: Act

Using AIE to restore Asset Data

2009-12-10 Thread Pierson, Shawn
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. Howeve

Re: Team Foundation Server

2009-12-10 Thread LJ Longwing
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 w

Team Foundation Server

2009-12-10 Thread Basile, Cindy
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 c

Re: ITIL Service Catalog templates? Change/Release & Deployment process samples?

2009-12-10 Thread Rabi Tripathi
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 wrote: > Lastly, BMC's SMPM tool would be very helpful. I posted a question about who is entitled to a non-trial version, but go

Re: CMDB Change stuck in Change Pending - Processing

2009-12-10 Thread Tim Rondeau
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 incompatibl

Re: SV: CMDB mapping question: dependency vs. component

2009-12-10 Thread Martinez, Marcelo A
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 n

Re: CMDB Change stuck in Change Pending - Processing

2009-12-10 Thread Tony Worthington
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: --

Re: Development Cache Mode revisited

2009-12-10 Thread Misi Mladoniczky
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

Re: safest and fastest way to delete AR Email records

2009-12-10 Thread Axton
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 Sou

Re: View form to MS SQL database from Oracle based ARSystem

2009-12-10 Thread Victor Olufowobi
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) [mailto:ars

CMDB Change stuck in Change Pending - Processing

2009-12-10 Thread Tim Rondeau
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 by

Re: Development Cache Mode revisited

2009-12-10 Thread Walters, Mark
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 ru

Re: Development Cache Mode revisited

2009-12-10 Thread Misi Mladoniczky
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 when

Resolved: Get result from stored procedure

2009-12-10 Thread Conny Martin
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 Betr

Re: Get result from stored procedure

2009-12-10 Thread Frank Caruso
I have created Functions in MS SQL that return values. You call them like this: select fn_test 'param1','param2' Specificy a return field for $1$. For a Stored Procedure, to obtain the return result, which I am assuming will tell you whether or not the procedure succeeded or failed, put a select

Re: Get result from stored procedure

2009-12-10 Thread David Morgan
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 cou

Re: Get result from stored procedure

2009-12-10 Thread Joe D'Souza
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 works, but from the ARS interface for SQL, EXECUTE doesn't work. This I

AW: Get result from stored procedure

2009-12-10 Thread Conny Martin
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 sp_test('MDP0007271

Re: Get result from stored procedure

2009-12-10 Thread Joe D'Souza
Conny, Yes it is possible.. how are you calling/executing the stored procedure when you are using it in the set-field-sql? Begin ; 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 MS-SQL as well b

BMC Atrium Core widgets

2009-12-10 Thread honormine
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=")

Re: CMDB mapping question: dependency vs. component

2009-12-10 Thread Peter Romain
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 >

Re: Development Cache Mode revisited

2009-12-10 Thread Misi Mladoniczky
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

Get result from stored procedure

2009-12-10 Thread Conny Martin
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 7.