.net apis 9.0/9.1

[Halleux, Jean-Louis]

Hi listers,

Does someone know where I can find .net apis for 9.0 or 9.1 ?

Thanks a lot.
Jean-Louis Halleux

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Learn Remedy Script - Reg

[Halleux, Jean-Louis]

Hello,

Do not forget that changing the login needs to be done in any row of any
table, as the submitter, the assignee or the status history could
contain the login.

As Sylvain did, I wrote a script (for Oracle) that reads all character
fields from the database, and dynamically creates update queries to
replace one value with another. It takes also a night to run, and during
that time your AR Server needs to be stopped.

Best regards,
Jean-Louis


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sylvain YVON
Sent: lundi 1 octobre 2012 8:39
To: arslist@ARSLIST.ORG
Subject: Re: Learn Remedy Script - Reg

Hi,
A few years ago, before there was a DMT, I had a similar requirement.
So I wrote an SQL script that searched every known character field
(from the FIELD table) on every form for references to known login
IDs. The script took a night to execute.
Then, from the result, I generated a list of update commands to be
executed for each login.

Not sure if it's still a good solution, now that we have the DMT. How
much time does it really take to run, have you tried on a test server
?

On Mon, Oct 1, 2012 at 8:22 AM, Suresh Loganathan 
wrote:
> **
> Hi Ratul/Joel,
>
> Thanks for your swift respone. I understand your ideas. Please refer
my
> below info.
>
> DMT tool : If i use this tool, it will take a lot of time. ie., i have
3000+
> records. it vl take more time consuming.
>
> Import Tool : if i use this tool, it vl affect only people form not
others.
> So, this option also not work.
>
> My suggestion, it will work only some scripts to update all forms
including
> people form.
>
> Thanks.
>
> Regards,
>
> Suresh Loganathan.
>
> On Sun, Sep 30, 2012 at 10:19 PM, ratul banerjee 
wrote:
>>
>> ** Hi Joel,
>>
>> Updating the loginid with an escalation might not update the related
data
>> in other form e.g 'AR System User Preference' etc.
>>
>> Ratul
>>
>> On Sun, Sep 30, 2012 at 12:25 PM, Joel Sender

>> wrote:
>>>
>>> **
>>>
>>> Use an escalation
>>>
>>> Qua
>>>
>>> NOT('Login ID' LIKE "%domainname%")
>>>
>>> set field:
>>>
>>> 'Login ID' = "domain\" + 'Login ID'
>>>
>>> HTH,
>>>
>>> Joel
>>>
>>> Joel Senderjdsen...@earthlink.net310.829.5552
>>>
>>>
>>>
>>> From: Action Request System discussion list(ARSList)
>>> [mailto:arslist@ARSLIST.ORG] On Behalf Of ratul banerjee
>>> Sent: Sunday, September 30, 2012 8:58 AM
>>> To: arslist@ARSLIST.ORG
>>> Subject: Re: Learn Remedy Script - Reg
>>>
>>>
>>>
>>> ** Suresh,
>>>
>>>
>>>
>>>  If i understand your requirement correctly, you need to add the
domain
>>> name at the beginning of all your remedy users. The best way to
achieve this
>>> is to use the DMT tool(refer to theData Management Administrator's
Guide).
>>>
>>> Ratul
>>>
>>> On Sun, Sep 30, 2012 at 11:36 AM, Suresh Loganathan
>>>  wrote:
>>>
>>> **
>>>
>>>
>>> I am using windows OS environment.
>>>
>>>
>>>
>>> Remedy version:7.5
>>>
>>> ITSM Version :7.6
>>>
>>> Database :SQL.
>>>
>>>
>>>
>>>
>>> -- Forwarded message --
>>> From: Suresh Loganathan 
>>> Date: Sun, Sep 30, 2012 at 9:00 PM
>>> Subject: Learn Remedy Script - Reg
>>> To: arslist@arslist.org
>>>
>>> Hi Guys,
>>>
>>>
>>>
>>> I want to learn the scrpit related to remedy. Do we have any
document for
>>> this? I have scenario to write the script. The scnenario is "need to
update
>>> the remedy login name". At present, my remedy contain only user
name.
>>> Here,need to update with domain name ie., "Domain
name\RemedyLoginName".
>>> Kindly advice.
>>>
>>>
>>>
>>> Thanks.
>>>
>>>
>>>
>>> Regards,
>>>
>>>
>>>
>>> Suresh Loganathan.
>>>
>>>
>>> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
>>>
>>>
>>> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
>>>
>>> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
>>
>>
>> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
>
>
> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: Looking for an app

[Halleux, Jean-Louis]

Hello Larry,

The application published by ARSmarts (www.arsmarts.com) can do that for
you (and much more). They just started a new beta program, so it is a
good opportunity for you to test it for free.

Jean-Louis

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Larry Barnes
Sent: mercredi 28 mars 2012 16:47
To: arslist@ARSLIST.ORG
Subject: Looking for an app

** 

Hello everyone, 

sometime ago there was a post about an app that could create an html
file of all your forms, workflow, etc. and how they linked together.
I've tried searching but since I don't remember many details about it
I've come to a dead end.  I even downloaded then but I failed to create
a backup copy and my laptop was reimaged a short time after the
download.

For those with great memories would you mind reposting that information
so I could capture the tool again. 

Thanks for your help, 

Larry B.


_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: AttachmentPopup buttons not functioning as expected

[Halleux, Jean-Louis]

Hello,

 

Have you tried to flush the cache of the midtier ? With my ITSM 7.6, the
cache gets corrupted weekly, and I have similar behaviour with some
forms.

 

Best regards,

Jean-Louis

 



From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Francois Seegers
Sent: mardi 27 mars 2012 12:48
To: arslist@ARSLIST.ORG
Subject: AttachmentPopup buttons not functioning as expected

 

Hi All,

 

We have a strange issue where when adding an attachment on Incident
Management, the dialog (Attachment Popup) mess up the buttons.  This
does not occur on all user pc's just some.  We are running a load
balancer and application servers is in server group.

 

App Servers

Windows 2008 R2

Mid-Tier 7.6.04 SP2

IE 8 & Windows 7

 

We have tried on one of the users to upgrade to IE9 but having the same
issue.  We also tried to clear the browser cache, cookies etc

 

 

 

Any ideas?

 

Francois

 

 



Blue Turtle Technologies (Pty) Limited | Reg. no.: 2003/002610/07 |
http://www.blueturtle.co.za
Gauteng : Tel: +27 (0)11 206 5600 | Fax: +27 (0)11 206 5606 | Midridge
Office Estate, International Business Gateway, cnr New Road & Sixth
Street, Midrand, 1685 | P O Box 31331, Kyalami, 1684
Western Cape: Tel: +27 (0)87 721 1874 | Fax: +27 (0)21 552 7764 | Unit
E6, Century Square, Heron Crescent, Century City, Cape Town, 7446

DISCLAIMER: This email and any files transmitted with it are
confidential and are intended solely for the use of the individual or
entity to whom they are addressed. This communication represents the
originator's personal views and opinions, which do not necessarily
reflect those of Blue Turtle Technologies (Pty) Ltd. If you are not the
original recipient or the person responsible for delivering the email to
the intended recipient, be advised that you have received this email in
error, and that any use, dissemination, forwarding, printing, or copying
of this email is strictly prohibited. If you received this email in
error, please immediately notify the sender. Thank you.

_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
<>

Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB

[Halleux, Jean-Louis]

Hi Gary,

According to my experience, creating a view form on a db link does not
work well. What I usually do in that case is creating an SQL view, in
the DB direclty, that will use the db link; and then create the view
form on the SQL view.

Best regards,
Jean-Louis Halleux

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Gary Dries
Sent: mardi 6 mars 2012 16:44
To: arslist@ARSLIST.ORG
Subject: Trying to build a view form to a Remote Oracle DB from a Remedy
SQL DB

I have a need to build a view form to a table on a Remote Oracle DB
10g from our ARS 7.1.06 running sql 2005 DB server

Has anyone been sucessful doing this?

We created the DBlink between the 2 dbs and we are able to connect
from the sql server  via other tools like odbc or sql plus and see the
table on oracle db.

ARAdmin is the oracle table owner and has read/write access, (I am
still scptical) attempted to create the view using the parameter
LINK.DATABASE.TABLEOWNER.TABLE and I always recieve the error in the
Admin tool
"Failure during SQL operation to the database :
CMS_TEST.CMSTEST.ARADMIN.REMEDY_CASES (ARERR 552)"

SQL Log posts this error
*** ERROR ***  Invalid use of schema or catalog for OLE DB provider
"MSDASQL" for linked server "CMS_TEST". A four-part name was supplied,
but the provider does not expose the necessary interfaces to use a
catalog or schema. (SQL Server 7312)

I have worked with BMC Support and they back up all of our
configuration and settings in the ar.cfg file, and all other system
settings.

Any Ideas?

-- 
Gary Dries
OSSNMS / Sr. Remedy Developer
T-Mobile USA
Office (972) 464-3235


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: am I missing something? filter phases

[Halleux, Jean-Louis]

I am afraid the information in the previous post is not correct.

When you make a Push field action in a filter ending with `!, you force
the action to be executed in phase 1.

But on submit, the Request ID field is known only in "transaction
phase", which is after phase 1 and before phase 2.

So you will never be able to push the request id from a filter with `!
on submit.

There are however many workarounds this limitation:

-  use the GUID instead of Request ID

-  use a filter without the `!

-  create your own request id that you increase yourself

 

Best regards.

 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of gurram sanjeevnaidu
Sent: jeudi 25 novembre 2010 14:04
To: arslist@ARSLIST.ORG
Subject: Re: am I missing something? filter phases

 

** 

Eli Schilling,

The filter which you written on the second form has to work on the
higjest excecution order i.e 999

On Tue, 23 Nov 2010 05:17:02 +0530 Eli Schilling wrote
>

Hey list!

its been a little while since I've built workflow so maybe I just need a
sanity check.

I am trying to create workflow that takes data from one form (button
press or via escalation) and creates a record on another form. On submit
of the second form, I am pushing the 'Request ID' to a third form to
trigger another series of events. The first filter that does push fields
includes `! at the end of the name. However, the entire process fails
because it is attempting to push a null value (Request ID) from the
second form to a required field on the third form.

Isn't that the point of - `! - ? So you can force the push fields in
phase 1, create the record and execute additional workflow immediately
thereafter?

We're on ARS 7.5 Patch 007, Windows 2003 and SQL 2005.

Thanks!
>

Eli Schilling

_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ 
 
 _attend WWRUG11 www.wwrug.com ARSlist: "Where
the Answers Are"_



This message was successfully scanned against all known virusses by McAfee 
Groupshield. 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Installing RKM 7.5

[Halleux, Jean-Louis]

Hello,

 

I try to install RKM 7.5 patch 1 on Oracle 10g. I use jdk/jre 1.6 and
Tomcat 6.0. The installation succeeds, but the post_installation fails,
when trying to connect to Oracle. I always receive an error 0RA-01017
(invalid user/password), though I am quite sure my password is correct.
I tried the jdbc connection strings like : :: and also
tried the full description coming from tnsnames.ora
(description=(addresslist=...). I also tried to change the ojdbc*.jar
file to more recent version in the lib directory of RKM, and in the lib
directory of tomcat, I still get ORA-01017.

 

Any tip ?

 

Thanks a lot.

Jean-Louis Halleux

 

_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_


This message was successfully scanned against all known virusses by McAfee 
Groupshield. 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: ARDBC LDAP

[Halleux, Jean-Louis]

Hi Misi,

Have you been able to find the source of the AREA/ARDBC plugins ?
I am very intersted in getting these. 

Best regards,
Jean-Louis

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky
Sent: mercredi 21 avril 2010 9:09
To: arslist@ARSLIST.ORG
Subject: Re: ARDBC LDAP

Hi,

Something tickles in the back of my mind about the 15-char limit had
been
removed, or should be removed...

If the 15-char limit is in place, you must have a unique attribute that
will fit.

Unless, as I said, you can leverage a table-field to do what you want to
do. The reason is that the table-field will only do one retrieval using
ARGetListEntryWithFields().

You can also modify the source for the ARDBC-LDAP-plugin, and pack the
DN
so that it will fit the 15-char limit...

Best Regards - Misi, RRR AB, http://www.rrr.se

Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy
logs.
Find these products, and many free tools and utilities, at
http://rrr.se.

> The fact is that I do not have ownership on the LDAP directory, and I
have
> to use the dn. I cannot add any sn or uid, and the process owner will
not
> make the change for me...
>
> Kais
>
> On 20 Apr 2010, at 17:46, Grooms, Frederick W wrote:
>
>> I believe someone in the past suggested using  uSNCreated  as the
>> mapping for RequestID.
>>
>> Fred
>>
>> -Original Message-
>> From: Action Request System discussion list(ARSList)
>> [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky
>> Sent: Tuesday, April 20, 2010 10:20 AM
>> To: arslist@ARSLIST.ORG
>> Subject: Re: ARDBC LDAP
>>
>> I have not done this recently.
>>
>> My experience was that you needed to add a unique attribute to the
>> directory that could be used to retrieve the actual record.
>>
>> If you are only doing a table-refresh to load data, you will not need
>> this, as the system only performs a single "search".
>>
>> If you are using set-fields or push-fields, the unique
>> max-15-character-key is needed.
>>
>>Best Regards - Misi, RRR AB, http://www.rrr.se
>>
>> Products from RRR Scandinavia:
>> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
>> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy
>> logs.
>> Find these products, and many free tools and utilities, at
>> http://rrr.se.
>>
>> -Original Message-
>> From: Action Request System discussion list(ARSList)
>> [mailto:arsl...@arslist.org] On Behalf Of ARSmarts Support
>> Sent: Tuesday, April 20, 2010 8:44 AM
>> To: arslist@ARSLIST.ORG
>> Subject: ARDBC LDAP
>>
>>> Hi listeners,
>>>
>>> Has anybody ever been able to use the ARDBC LDAP plugin mapping the
>>> request id to the dn ? I succeeded with mapping to attribute where
>>> length
>>> is less than 15 characters, but I can't succeed with longer strings,
>>> while
>>> it is documented as being supported. I am using ARS 7.5 patch 3.
>>>
>>> Thanks for your help.
>>>
>>> Kais
>>
>>

___
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>
>

___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"


This message was successfully scanned against all known virusses by McAfee 
Groupshield. 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: need to design a counter

[Halleux, Jean-Louis]

Hi Raj,

Create 2 filters and a temporary checkbox on form 1
1 filter is linked to form 2, and it does a push to form 1, setting the
temporary checkbox to 0
The other filter is linked to form 1, and it does a set action. The Run
If is 'TR.Checkbox' = 0, and the Set Field is Integer field = Integer
field +1,

Best regards,
Jean-Louis


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Raj
Sent: vendredi 16 avril 2010 2:04
To: arslist@ARSLIST.ORG
Subject: need to design a counter

Hello all,
There is an integer field on form1.
need to design a counter which increments the count by one for every
submit on form2.
So, need to write a filter on submit of form 2 which increments the
integer field on form 1 by 1 for every submit on form 2.please advise.
thanks,
Raj


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"


This message was successfully scanned against all known virusses by McAfee 
Groupshield. 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Data model

[Halleux, Jean-Louis]

Hi,

 

Does anyone know it a data model exists for ITSM 7.5 or 7.6, with, at
least, primary and foreign keys ?

 

Thanks.

Jean-Louis

 



This message was successfully scanned against all known virusses by McAfee 
Groupshield. 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"