Re: Java API for Query based upon a composite qualification

[Eric Roys]

Naveen,

You can find reference to retrieving entries from multiple forms in the 7.6.4 C 
API Reference document provided by BMC. There is a section specific to this 
along with example in C and Java api. Beyond simple joins, it also covers 
recursion, and other interesting things, if needed. Hopefully that helps.

-Eric

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Friday, November 01, 2013 8:27 AM
To: arslist@ARSLIST.ORG
Subject: Re: Java API for Query based upon a composite qualification

**
Naveen,
To the best of my knowledge, the API itself cannot do this, never really has 
been able to...but some versions ago (I think it was 7.6.04) BMC introduced 
'Multi-Form Search', or MFSif you read the docs you can read up a bit about 
it, and once configured, the API would be able to utilize your MFS Form to do 
what you want, I think.

https://docs.bmc.com/docs/display/public/ars81/Creating+a+form+and+workflow+to+search+across+multiple+forms

On Thu, Oct 31, 2013 at 9:57 PM, Setya, Naveen 
mailto:nse...@columnit.com>> wrote:
**
Greetings,

Can someone please provide an example of java API that can be used to retrieve 
data from a form based upon a composite qualification?

e.g. Form A and Form B

Retrieve Data from Form A where FormA.Field1=FormB.Field2

Thanks in advance
Naveen


_ARSlist: "Where the Answers Are" and have been for 20 years_

_ARSlist: "Where the Answers Are" and have been for 20 years_
CONFIDENTIALITY NOTICE: This email communication is intended only for the 
personal and confidential use of the recipient(s) designated above and may 
contain information which is subject to Federal and/or State privacy laws. In 
the event that you are not the intended recipient or the agent of the intended 
recipient, you are hereby notified that any review, disclosure, or use of the 
information contained herein is strictly prohibited. Do not copy or use the 
information contained within this communication, or allow it to be read, copied 
or utilized in any manner by any other person(s). If you have received this 
communication in error, please notify the sender immediately, either by 
response e-mail or by phone, and permanently delete the original e-mail, any 
attachment(s), and copies.

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

Re: How to determine when a user last logged in

[Eric Roys]

LJ,

Sounds about right. I'm sure there was probably additional extrapolation beyond 
that even. Like I said, it's been a few years. (early version 7ish).

-Eric


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Monday, October 28, 2013 4:07 PM
To: arslist@ARSLIST.ORG
Subject: Re: How to determine when a user last logged in

**
Misi,
About a year ago I figured out a way to determine Floating-Read users.  There 
are two methods (in Java)...one is .getLicenseType(), which gives you the users 
license type, then there is another of .getCurrentLicenseType(), which at least 
in the case of Floating users, if they are assigned a floating license, but 
don't currently have one assigned, the .getCurrentLicenseType() gives you a 
value of Constants.AR_LICENSE_TYPE_NONE.  With this info I determine them to be 
Floating Read, instead of Floating Write.

Hope that helps :)

On Mon, Oct 28, 2013 at 2:53 PM, Misi Mladoniczky 
mailto:m...@rrr.se>> wrote:
Hi,

Unfortunately the UserInfo-API-call does not give you information about if a
FLOATING-READ has been granted because of a lack of licenses on the server, or
because the user did not yet access any form data.

I have also written a polling tool that produces a log file based periodic
API-calls. Except for the above mentioned lack, it works great.

Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)

Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* 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.

> I wrote something with java api a few years back that would track the user
> login, license consumed, whether they were denied a token because there were
> not enough available at the time, and then correlate it with which
> company/org, and other things that mattered in an MSP environment. It ran as
> java plugin and updated data into data form(s) in Remedy for historical
> purposes. This is independent of ITSM, user log, and statistics. It was a fun
> bit of code to write. I don't have it any longer but if there is enough
> interest I'm sure I could reconstitute it.
>
> Eric Roys
> Solutions Engineer
>
> Avnet Services (formerly Seamless Technologies Inc.)
> er...@seamlessti.com<mailto:er...@seamlessti.com>
> www.seamlessti.com<http://www.seamlessti.com>
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Misi 
> Mladoniczky
> Sent: Monday, October 28, 2013 2:56 PM
> To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
> Subject: Re: How to determine when a user last logged in
>
> Hi,
>
> Even more importantly, from a cost perspective, the AR System Historical
> License Usage form does not track FLOATING-READ licenses, only FIXED-WRITE and
> FLOATING-WRITE...
>
> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>
> Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
> * 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.
>
>> Terry,
>> One problem I have with the BMC's provided historical license usage
>> form is that it doesn't cover 'all' users...only users with write
>> licenses...why does this matter you ask?  Well, Read and Read
>> Restricted users are completely valid users of the system, but because
>> their licenses don't cost anything, BMC doesn't deign it necessary to
>> track their usage.  As such, you can't track 'all' of your users
>> through this method.  A simple Active Link that makes a service call to a
>> login audit form any time 'selected'
>> forms are opened will track all of your users that utilize 'main' forms.
>>
>>
>> On Mon, Oct 28, 2013 at 11:30 AM, 
>> tboot...@objectpath.com<mailto:tboot...@objectpath.com> <
>> tboot...@objectpath.com<mailto:tboot...@objectpath.com>> wrote:
>>
>>> **
>>> You can investigate this:
>>>
>>> On the ARSystem Server configuration tab - enable the field : License
>>> Tracking
>>>
>>> Peridocially check the form called " ARSystem Administration: License
>>> Review" form for entries (userids) that do not appear in this form
>>> that appear in your User or appropriate CTM:People form.  A quick
&g

Re: How to determine when a user last logged in

[Eric Roys]

I wrote something with java api a few years back that would track the user 
login, license consumed, whether they were denied a token because there were 
not enough available at the time, and then correlate it with which company/org, 
and other things that mattered in an MSP environment. It ran as java plugin and 
updated data into data form(s) in Remedy for historical purposes. This is 
independent of ITSM, user log, and statistics. It was a fun bit of code to 
write. I don't have it any longer but if there is enough interest I'm sure I 
could reconstitute it.

Eric Roys
Solutions Engineer

Avnet Services (formerly Seamless Technologies Inc.)
er...@seamlessti.com
www.seamlessti.com


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Monday, October 28, 2013 2:56 PM
To: arslist@ARSLIST.ORG
Subject: Re: How to determine when a user last logged in

Hi,

Even more importantly, from a cost perspective, the AR System Historical 
License Usage form does not track FLOATING-READ licenses, only FIXED-WRITE and 
FLOATING-WRITE...

Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)

Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* 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.

> Terry,
> One problem I have with the BMC's provided historical license usage
> form is that it doesn't cover 'all' users...only users with write
> licenses...why does this matter you ask?  Well, Read and Read
> Restricted users are completely valid users of the system, but because
> their licenses don't cost anything, BMC doesn't deign it necessary to
> track their usage.  As such, you can't track 'all' of your users
> through this method.  A simple Active Link that makes a service call to a 
> login audit form any time 'selected'
> forms are opened will track all of your users that utilize 'main' forms.
>
>
> On Mon, Oct 28, 2013 at 11:30 AM, tboot...@objectpath.com <
> tboot...@objectpath.com> wrote:
>
>> **
>> You can investigate this:
>>
>> On the ARSystem Server configuration tab - enable the field : License
>> Tracking
>>
>> Peridocially check the form called " ARSystem Administration: License
>> Review" form for entries (userids) that do not appear in this form
>> that appear in your User or appropriate CTM:People form.  A quick
>> outer join would give you the details.
>>
>> Check the admin manual for details on the License Tracking setting.
>>
>> Terry
>>
>>
>>
>> on Oct 28, 2013, *SUBSCRIBE ARSLIST theReel*  wrote:
>>
>> Hi Guys,
>>
>> Is there a way to determine when a user last logged into Remedy/ITSM
>> without having to enable the user logs. Basically I want to identify
>> any user accounts that have not logged into Remedy in X months.
>>
>> We have a multi-tenant ITSM 8.1 environment and do not have full
>> control of our user base leaving procedures. So if someone with a
>> Remedy account was to leave one of our customers and they do not
>> notify us then that persons account will remain active. To mitigate
>> against this we are planning to supply the customers with an active
>> users report to check and want to include the last time they each
>> logged on and any other useful information.
>> There is the user-cache table which has a timestamp column but that
>> only seems to be updated when the user account is updated/changed and
>> not when they login.
>>
>> Any ideas how I could achieve this or how do you identify unused accounts?
>>
>> Thanks
>> Tony
>>
>>
>> _
>> __ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> "Where the Answers Are, and have been for 20 years"
>>
>>
>> _ARSlist: "Where the Answers Are" and have been for 20 years_
>
> __
> _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers 
Are, and have been for 20 years"
CONFIDENTIALITY NOTICE: This email communication is intended only for the 
personal and confidential use of the recipient(s) desi

7.6.4 Java Api Trivia - Recursive Query Level

[Eric Roys]

Good Friday to you, 

Is it possible to get the level as output from a recursive query call? There 
doesn't appear to be, unless I've not found it, a way by which to retrieve it 
from the results. The sql trace (on ms sql) provides that the sql is 
establishing level. 

Alternatively a api getlistsql using recursive query doesn't appear to be 
productive (requires ";" prior to "with", although providing it ends with no 
results - ever). 

Appreciate any thoughts on the subject. 

Kind Regards,

Eric

CONFIDENTIALITY NOTICE: This email communication is intended only for the 
personal and confidential use of the recipient(s) designated above and may 
contain information which is subject to Federal and/or State privacy laws. In 
the event that you are not the intended recipient or the agent of the intended 
recipient, you are hereby notified that any review, disclosure, or use of the 
information contained herein is strictly prohibited. Do not copy or use the 
information contained within this communication, or allow it to be read, copied 
or utilized in any manner by any other person(s). If you have received this 
communication in error, please notify the sender immediately, either by 
response e-mail or by phone, and permanently delete the original e-mail, any 
attachment(s), and copies.

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

Re: Service action Peculiarity

[Eric Roys]

Thanks, Misi and Dhanshree. 

Input length is not an issue as source/destination are same size. Swapping 
source field with another source field of same size would technically fail if 
it were an issue of input length, but does not.  Whether the field exists or 
not is not an issue as I assure you it does exist and is being accessed via 
Admin account. What does appear to be at issue is confusion of the id/value 
pairing in whatever is transpiring in the black box of the service action. 
Normally I would not allow the system to default an id so normally this would 
not be an issue, it just so happens that this was a quick prototype and the 
additional scrutiny was not (until now) necessary. And what are the odds that 
even if one specified their own id that the source form and the service handler 
form would have the same ids?

-Eric

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Friday, August 17, 2012 3:47 AM
To: arslist@ARSLIST.ORG
Subject: Re: Service action Peculiarity

Hi,

It still seems a bug to me.

If a field does not exist, or the user does not have permissions to it, the 
value should always be NULL.

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

> Hi,
>
> It’s not a bug. We have seen a case where because of change in the 
> input length of a field it was providing a wrong value.
>
> HTH
> --
> Regards,
> Dhanshree
>
> Vyom Labs Pvt. Ltd.
> BSM Solutions & Services || ITIL Consulting & Training
> Email: i...@vyomlabs.com  || Web Site: www.vyomlabs.com Follow Vyom 
> Labs http://twitter.com/#!/vyomlabs || 
> http://www.linkedin.com/company/vyom-labs
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Eric Roys
> Sent: Friday, August 17, 2012 8:51 AM
> To: arslist@ARSLIST.ORG
> Subject: Service action Peculiarity
>
> Has anyone come across a peculiarity with the filter Service action 
> where-in what is mapped is not what is received on the other end?
> ARS7.6.4 sp2
>
> The particulars...
>
> Filter Service Input Mapping:
> inChar000 (536870913) = $host$  //source field id (536870913)
> inChar001 (536870914) = "People" //source field id (hardcoded)
> inChar002 (536870915) = "Used by" //source field id (hardcoded)
> inChar003 (536870916) = $corpid$  //source field id (536870915)
>
> Source values at time of call say:
> inChar000 (536870913) = vm04
> inChar001 (536870914) = People
> inChar002 (536870915) = Used by
> inChar003 (536870916) = 4712258
>
> Receiving says (and passes wrong value - see inChar003)...
>
>  > --> service action input
>
>  >inChar000 (536870913) = vm04
>
>  >inChar001 (536870914) = People
>
>  >inChar002 (536870915) = Used
>> by
>
>  >inChar003 (536870916) = Used
>> by
>
> Change Service Input mapping to use new field/id as:
> inChar000 (536870913) = $host$  //source field id (536870913)
> inChar001 (536870914) = "People" //source field id (hardcoded)
> inChar002 (536870915) = "Used by" //source field id (hardcoded)
> inChar003 (536870916) = $corpid1$  //source field id (536870929) => 
> new field/id not in field id set on destination form
>
> Use same Source Values as previously noted.
>
> Receiving now says (and works properly)...
>
>  > --> service action input
>
>  >    inChar000 (536870913) = vm04
>
>  >inChar001 (536870914) = People
>
>  >inChar002 (536870915) = Used
>> by
>
>  >inChar003 (536870916) =
>> 4712258
>
>
> Thoughts? Bug? Enhancement? As designed?
>
> Thanks,
>
> Eric Roys
> Seamless Technologies
>
>
> CONFIDENTIALITY NOTICE: This email communication is intended only for 
> the personal and confidential use of the recipient(s) designated above 
> and may contain information which is subject to Federal and/or State privacy 
> laws.
> In the event that you are not the intended recipient or the agent of 
> the intended recipient, you are hereby notified that any review, 
> disclosure, or use of the information contained herein is strictly 
> prohibited. Do not copy or use the information contained within this 
> communication, or allow it to be read, copied or utilized in any 
> manner by any other person(s). If you have received this communication 
> in error, please notify the sender immediately, either by response 
> e-mail or by phone, and permanently delete the original e-mail, any 
> attachment(s), and copies.

Service action Peculiarity

[Eric Roys]

Has anyone come across a peculiarity with the filter Service action where-in 
what is mapped is not what is received on the other end?
ARS7.6.4 sp2

The particulars... 

Filter Service Input Mapping: 
inChar000 (536870913) = $host$  //source field id (536870913)
inChar001 (536870914) = "People" //source field id (hardcoded)
inChar002 (536870915) = "Used by" //source field id (hardcoded)
inChar003 (536870916) = $corpid$  //source field id (536870915)

Source values at time of call say: 
inChar000 (536870913) = vm04
inChar001 (536870914) = People
inChar002 (536870915) = Used by
inChar003 (536870916) = 4712258 

Receiving says (and passes wrong value - see inChar003)... 
  
--> service action input
  
   inChar000 (536870913) = vm04
  
   inChar001 (536870914) = People
  
   inChar002 (536870915) = Used by
  
   inChar003 (536870916) = Used by 

Change Service Input mapping to use new field/id as: 
inChar000 (536870913) = $host$  //source field id (536870913)
inChar001 (536870914) = "People" //source field id (hardcoded)
inChar002 (536870915) = "Used by" //source field id (hardcoded)
inChar003 (536870916) = $corpid1$  //source field id (536870929) => new 
field/id not in field id set on destination form

Use same Source Values as previously noted.

Receiving now says (and works properly)... 
  
--> service action input
  
   inChar000 (536870913) = vm04
  
   inChar001 (536870914) = People
  
   inChar002 (536870915) = Used by
  
   inChar003 (536870916) = 4712258


Thoughts? Bug? Enhancement? As designed?

Thanks, 

Eric Roys
Seamless Technologies


CONFIDENTIALITY NOTICE: This email communication is intended only for the 
personal and confidential use of the recipient(s) designated above and may 
contain information which is subject to Federal and/or State privacy laws. In 
the event that you are not the intended recipient or the agent of the intended 
recipient, you are hereby notified that any review, disclosure, or use of the 
information contained herein is strictly prohibited. Do not copy or use the 
information contained within this communication, or allow it to be read, copied 
or utilized in any manner by any other person(s). If you have received this 
communication in error, please notify the sender immediately, either by 
response e-mail or by phone, and permanently delete the original e-mail, any 
attachment(s), and copies.

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

Re: Can we change char size of Organisation field across ITSM

[Eric Roys]

A couple caveats: 

1. make sure you are getting all references not just those that are handily 
identified with the same database id as there are some that are not, yet would 
fall into the realm of your update, not including temp fields (i.e. 
ReqByOrganization, Requester Organization, Customer Organization, etc.)
2. make sure your updates are in overlay if you are on system that supports 
overlays
3. make sure your updates to cmdb are done via class manager (yes, there's 
references there, too)

However, "if" it were me, I'd want to make sure there is a darn valid reason 
for making this change as it's no small ask as even with additional due 
diligence, it's still prone to some amount of risk. It's nearly always better 
to tweak the data than the code, but if you go the code update route, don't 
forget your backup before pressing the button.

-Eric

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC
Sent: Friday, July 13, 2012 11:41 AM
To: arslist@ARSLIST.ORG
Subject: Re: Can we change char size of Organisation field across ITSM

I personally would write a quick java application that loads all of the forms, 
pulls does a get on the specific field, sets its attributes properly, sets the 
field back to the server...it would take about an hour to write the program (if 
that) and as long as it takes for the change to happen at the API levelbut 
significantly less time than it would take to do it through the dev studio, and 
I would NEVER attempt to do it at the DB level.

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of ITSM.Support
Sent: Friday, July 13, 2012 10:38 AM
To: arslist@ARSLIST.ORG
Subject: Re: Can we change char size of Organisation field across ITSM

Hi,

According to the observations so far, we cannot modify the character size of 
the mentioned fields using the remedy application. The field 'Organization' is 
on the 361 forms with the same database field ID.

Though it may be possible that we can update it at database level, but the same 
operation needs to be performed on each form.

For this we have 'AR System Metadata:field_char' form, where all the meta-data 
related to character fields are stored. 

It’s a view form. We need to update the meta-data, the related record in order 
to achieve this. But this option is not tried and tested, as it may cause the 
severe malfunction at DB level.

--
Regards,
ITSM Support

Vyom Labs Pvt. Ltd.
BSM Solutions & Services || ITIL Consulting & Training
Email: i...@vyomlabs.com  || Web Site: www.vyomlabs.com Follow Vyom Labs 
http://twitter.com/#!/vyomlabs || http://www.linkedin.com/company/vyom-labs

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Vikram
Sent: Thursday, July 12, 2012 9:23 PM
To: arslist@ARSLIST.ORG
Subject: Can we change char size of Organisation field across ITSM

hi All,

I have a requirement where I need to change the char size of Organisation field 
in ITSM from 60 to 254 chars. Is there any way where we can do this in one 
place and it would reflect in all 300+ forms where this field is used. 

It would be a bad task to do manually, do anyone know a tweak for this or 
perhaps a utility for the same. There are 4 -5 such OOTB widely used fields 
which we need to increase size of.

Thanks in advance,
Vikram

___
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"

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

CONFIDENTIALITY NOTICE: This email communication is intended only for the 
personal and confidential use of the recipient(s) designated above and may 
contain information which is subject to Federal and/or State privacy laws. In 
the event that you are not the intended recipient or the agent of the intended 
recipient, you are hereby notified that any review, disclosure, or use of the 
information contained herein is strictly prohibited. Do not copy or use the 
information contained within this communication, or allow it to be read, copied 
or utilized in any manner by any other person(s). If you have received this 
communication in error, please notify the sender immediately, either by 
response e-mail or by phone, and permanently delete the original e-mail, any 
attachment(s), and copies.


___
UNSUBSCRIBE or 

Re: Count of records

[Eric Roys]

You might just want to download ARUtilities application (google it). It’s free 
for a time (until trial expires) and provides a means to do sql against the 
server as you would by building a form/logic as you indicated. It does other 
things too.

Note: I’m not affiliated with the product. It just seems you need a solution 
that doesn’t require effort or introducing code on the system itself, that will 
open the proverbial can of worms.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of remedyarl...@gmail.com
Sent: Friday, April 27, 2012 5:39 AM
To: arslist@ARSLIST.ORG
Subject: Re: Count of records

**
Thank you all for your ideas... Looks like I have to build a new form with a 
drop down field with arschema as menu value. On selection of each form, on 
demand query runs and real time count is provided.
Sent on my BlackBerry® from Vodafone

From: Jose Huerta 
mailto:jose.hue...@sm2baleares.es>>
Sender: "Action Request System discussion list(ARSList)" 
mailto:arslist@ARSLIST.ORG>>
Date: Thu, 26 Apr 2012 22:20:56 +0200
To: mailto:arslist@ARSLIST.ORG>>
ReplyTo: arslist@ARSLIST.ORG
Subject: Re: Count of records

** I know you can't customize nor access the DB. I see no solution to your case.

But I can provide you some solutions, customizing or accessing the database.

All of this is for Oracle.

1.- Run an SQL sentence:

SELECT A.SCHEMAID, A.NAME, A.NEXTID, T.NUM_ROWS FROM ARSCHEMA A 
JOIN user_tables T ON ( ('T' ||TRIM(TO_CHAR(A.SCHEMAID))) = T.TABLE_NAME)

Provides you the next ID and number of requests at each regular form.

2.- Create a view using the previous SQL and map it to a View Form.

3.- Create a view form mapping the user_tables table. Then create a join view 
between this form and the AR System metadata:arschema form, with the join 
qualification like the provided one.

Regards,

Jose Huerta
http://theremedyforit.com/

On Thu, Apr 26, 2012 at 21:09, Jason Miller 
mailto:jason.mil...@gmail.com>> wrote:
**
That is great!

On Thu, Apr 26, 2012 at 11:52 AM, Pierson, Shawn 
mailto:shawn.pier...@sug.com>> wrote:
**
In order to help developers like myself get better at filtering data, my son is 
named Robert’); DROP TABLE Students;-- Pierson.

http://xkcd.com/327/

Thanks,

Shawn Pierson
Remedy Developer | Energy Transfer

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Jason 
Miller
Sent: Thursday, April 26, 2012 1:44 PM
To: arslist@ARSLIST.ORG
Subject: OT: Count of records

**
A good reason to not run your application as root/admin...  I had a system once 
were I didn't have admin access on the app server but the AR System ran as 
root.  I built a form where I could enter an OS command in a text field and 
Remedy would issue the command to the OS in a Run Process.  Worked great for 
things like sending a chown command on log files that I couldn't view because 
they were created by root.

The same could hold true if your ARSystem db user is a sysadmin.  Be careful 
that the SELECT COUNT(*) doesn't turn into DROP DATABASE ARSystem.  :-)

Jason
On Thu, Apr 26, 2012 at 7:07 AM, Joe Martin D'Souza 
mailto:jdso...@shyle.net>> wrote:
You do not require the ARAdmin password to run a direct SQL on your 
application..

Customize your app wherein, you run a direct SQL in a set field operation to 
set a field with $1$ of the SQL statement ==>

select count(*) from 

Do not use the terminating ; character on your direct SQL as the AR System 
engine takes care of that..

Use that statement in a set field action and set a temp field to return your 
count to.. This will not limit your count by what your get list limits on your 
server or your clients are..

Joe

-Original Message- From: 
remedyarl...@gmail.com
Sent: Thursday, April 26, 2012 5:57 AM Newsgroups: 
public.remedy.arsystem.general

To: arslist@ARSLIST.ORG
Subject: Count of records
Quick question..


Do we have a form in remedy 7.6.X where we can check the count of rows in each 
table. I know we have a form to check schema ID's but will this also give count 
of rows. My Getlist query on server is restricted to 2K records only so I have 
to run 1=1 query on each target form in web mode to get the count. 
Unfortunately user too do not give the count. Also I don't have read access to 
DB and client is not ready to share ARAdmin pwd (for security). And as usual no 
customization allowed.

Any help would be appreciated.
Sent on my BlackBerry® from Vodafone
___
UNSUBSCRIBE or access ARSlist Archives at 
www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the 
Answers Are"

_attend WWRUG12 www.wwrug.com ARSlist: "Where the

Re: Multi schema join parse qualfier

[Eric Roys]

LJ, 

Appreciate your time. I was hoping I had overlooked something but apparently 
not. Seems silly to have not provided an appropriate method as the long hand is 
unruly at best and rolling one's own, while better than long handing it, is 
still not ideal since this is something that seems to be a must if dealing with 
multiForm queries and I'm sure I won't be the last person who needs/wants it. 
Perhaps it made it into version 7.7 (sarcasm). 

Where does one find that enhancement request form, again?

-Eric

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Tuesday, April 17, 2012 12:31 PM
To: arslist@ARSLIST.ORG
Subject: Re: Multi schema join parse qualfier

Ok….I’m going to try to document this for ‘the world’.

Looking through the 7.6.4 JavaDocs, you can get a QualifierInfo object through 
numerous methods…the one outline in the appendix

QuerySourceForm primaryForm = new QuerySourceForm("Form1"); QuerySourceForm 
secondaryForm = new QuerySourceForm("Form2"); ArithmeticOrRelationalOperand 
field1 = new ArithmeticOrRelationalOperand(123456, primaryForm); 
ArithmeticOrRelationalOperand field2 = new 
ArithmeticOrRelationalOperand(654321, secondaryForm); RelationalOperationInfo 
relOp = new RelationalOperationInfo(RelationalOperationInfo.AR_REL_OP_EQUAL, 
field1, field2);

QualifierInfo joinQual = new QualifierInfo(relOp);

Or, through more ‘normal’ methods which would be something like this

String qual =  "'Field1' = $Field2$"; // 'Product Name' = $Model$

List f1 = arConnection.getListFieldObjects("Form1");
List f2 = arConnection.getListFieldObjects("Form2");

QualifierInfo joinQual = arConnection.parseQualification(qual, f2, f1, 
Constants.AR_QUALCONTEXT_DEFAULT);

The problem is that the first method creates a QualifierInfo object that looks 
something like this

[Operation=4,Operand Left=[Operation=1,Operand Left=[Operand 
Type=[type=1],Operand=[Field ID=123456,Func ID=0,Field Source=[Source 
Identifier=-6be110ff:136c144c57c:-8000,Source Name=Form1]]],Operand 
Right=[Operand Type=[type=1],Operand=[Field ID=654321,Func ID=0,Field 
Source=[Source Identifier=-6be110ff:136c144c57c:-7fff,Source 
Name=Form2,Operand Right=]

Whereas the second presents something like

[Operation=4,Operand Left=[Operation=1,Operand Left=[Operand 
Type=[type=1],Operand=123456],Operand Right=[Operand 
Type=[type=1],Operand=654321]],Operand Right=]

So...Eric,
What I'm reading out of this is that the people over at BMC did not deem it 
necessary to either update the parseQualification method...or provide an 
appropriately overridden version of it to be able to create a QualifierInfo 
object that will work when utilizing the getListEntryObjects method with a 
RegularQuery object as one of the inputs

This is a long, 'around the way' way of saying 'No' to your original 
questionit looks like you must use the 'long hand' method of creating the 
qualifier objects for the momentand in the long run, if you want to be able 
to use the shorthand...you could either write your own method to build it 
properlyor submit an enhancement request to BMC to have them do the leg 
work.


From: LJ LongWing [mailto:lj.longw...@gmail.com]
Sent: Monday, April 16, 2012 8:45 AM
To: 'arslist@ARSLIST.ORG'
Subject: RE: Multi schema join parse qualfier

Eric,
I see no reason why you wouldn’t be able to use that method to create the 
QualifierInfo object….I’m not entirely sure of the code you are using to get 
the cast error.  Please feel free to contact me offlist if you would like, but 
I would love to try to help ☺

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Eric Roys
Sent: Sunday, April 15, 2012 9:02 PM
To: arslist@ARSLIST.ORG
Subject: Multi schema join parse qualfier

**
For you java api folks… 

ARS 7.6.4 sp2
Java api 7.6.4 build 2
Java 7

Is there a parse qual method for translating a query string (i.e. ‘This’ = 
$This$ AND ‘That’ = $That$) for the QualifierInfo required by 
com.bmc.arsys.api.QuerySourceForm.setJoin(IQuerySource arg0, int arg1, 
QualifierInfo arg2) method [or does one have to embrace the long hand version 
and write out as indicated in the appendix of the C API reference doc (excerpt 
below)? I was hoping that the parseQualification(String queryString, 
List fieldList1, List fieldList2, int queryContext, boolean 
exceptionWhenFieldNotFound) method would do the trick but it seems the 
getListEntryObjects fails with a cast exception (java.lang.Integer cannot be 
cast to com.bmc.arsys.api.QueryFormField). 

Excerpt:
   // Create join qualifier, which is used to generate the SQL query’s
   // ON clause.  
   ArithmeticOrRelationalOperand field1 = new 
ArithmeticOrRelationalOperand(240001002, prodCat);
   Arithmet

Multi schema join parse qualfier

[Eric Roys]

For you java api folks…

ARS 7.6.4 sp2
Java api 7.6.4 build 2
Java 7

Is there a parse qual method for translating a query string (i.e. ‘This’ = 
$This$ AND ‘That’ = $That$) for the QualifierInfo required by 
com.bmc.arsys.api.QuerySourceForm.setJoin(IQuerySource
 arg0, int arg1, 
QualifierInfo
 arg2) method [or does one have to embrace the long hand version and write out 
as indicated in the appendix of the C API reference doc (excerpt below)? I was 
hoping that the parseQualification(String queryString, List fieldList1, 
List fieldList2, int queryContext, boolean exceptionWhenFieldNotFound) 
method would do the trick but it seems the getListEntryObjects fails with a 
cast exception (java.lang.Integer cannot be cast to 
com.bmc.arsys.api.QueryFormField).

Excerpt:
// Create join qualifier, which is used to generate the SQL query’s
// ON clause.
ArithmeticOrRelationalOperand field1 = new 
ArithmeticOrRelationalOperand(240001002, prodCat);
ArithmeticOrRelationalOperand field2 = new 
ArithmeticOrRelationalOperand(240001002, products);
RelationalOperationInfo relOp = new 
RelationalOperationInfo(RelationalOperationInfo.AR_REL_OP_EQUAL, field1, 
field2);

QualifierInfo joinQual = new QualifierInfo(relOp);

Thanks,

Eric

CONFIDENTIALITY NOTICE: This email communication is intended only for the 
personal and confidential use of the recipient(s) designated above and may 
contain information which is subject to Federal and/or State privacy laws. In 
the event that you are not the intended recipient or the agent of the intended 
recipient, you are hereby notified that any review, disclosure, or use of the 
information contained herein is strictly prohibited. Do not copy or use the 
information contained within this communication, or allow it to be read, copied 
or utilized in any manner by any other person(s). If you have received this 
communication in error, please notify the sender immediately, either by 
response e-mail or by phone, and permanently delete the original e-mail, any 
attachment(s), and copies.


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

Re: Editing a VUI ID.. (resending because of rejected posting..)

[Eric Roys]

Joe,

Via the java api, translating selection fields from the integer value to the 
human readable values uses the VUI as an input parameter to the call as :
getEnumAliasFromValue(viewId, fieldId())

Instead of trying to keep track of vuid’s across the board, a constant can be 
used to define the default vui id (if one chooses).

I’m sure there are other reasons ;-)

-Eric



From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza
Sent: Friday, April 13, 2012 6:29 PM
To: arslist@ARSLIST.ORG
Subject: Editing a VUI ID.. (resending because of rejected posting..)

**

I’m just curious as to why a VUI ID is not editable to a custom view ID when 
creating a new form..

Anyone knows why this is designed as is while every other new view it is 
possible to edit it?

I had just taken this for granted before, but today suddenly I got myself 
wondering why.. Why would VUI’s created after the default view (irrespective of 
whether the form was already created or not before creating the second view) be 
allowed to have custom view ID’s but not the default view?

Not that I really need to change it, but was wondering why.. that’s all..

Attached a screenshot of my ugly form..

Joe

PS: I think an attachment of a screenshot was causing my posting to be 
rejected. Those who want to see what I meant by this posting through a screen 
shot, send me an email and I’ll send you the screen shot..
_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers 
Are"_

CONFIDENTIALITY NOTICE: This email communication is intended only for the 
personal and confidential use of the recipient(s) designated above and may 
contain information which is subject to Federal and/or State privacy laws. In 
the event that you are not the intended recipient or the agent of the intended 
recipient, you are hereby notified that any review, disclosure, or use of the 
information contained herein is strictly prohibited. Do not copy or use the 
information contained within this communication, or allow it to be read, copied 
or utilized in any manner by any other person(s). If you have received this 
communication in error, please notify the sender immediately, either by 
response e-mail or by phone, and permanently delete the original e-mail, any 
attachment(s), and copies.


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

Re: How to use "ARS Scripting Plug-in for JAVA" ???

[Eric Roys]

Tadeu Augusto Dutra Pinto,

Yes it is correct to use try/catch in the script

Also, don't forget to include import com.remedy.arsys.api.Value; at the
beginning of your script as the parameter(s) you pass in are of type Value.
You may or may not need to also include import statements for others as
needed by your script.

Happy coding...


Eric Roys
Sr. Software Engineer
Verizon Business

CONFIDENTIALITY: The information contained in this message and any
attachment may be proprietary, confidential, and privileged or subject to
the work product doctrine and thus protected from disclosure. If the reader
of this message is not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this
communication in error, please notify me immediately by replying to this
message and deleting it and all copies and backups thereof. Thank you.


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto
Sent: Tuesday, October 02, 2007 12:23 PM
To: arslist@ARSLIST.ORG
Subject: RES: How to use "ARS Scripting Plug-in for JAVA" ???

Hy Everyone,
 
Thank you very much for the answers...
Specially thanks to Eric Roys and Carey M. Black...
 
 
Now, I have another question about Filter API.
I'd like to know if I can put Java Method Calls in Script body??
It's correct put try/catch block in Script??
 
Some like this:
 
int result = 0;
 
try
{
  if (values.length() != null)
  {
 if (values.startsWith("1"))
 result = validateOne();
 else if (values.startsWith("2"))
 result = validateTwo();
 else if (values.startsWith("3"))
 result = validateThree();
   }
   return result;
}
catch (Exception e)
{
   return result;
}
 
int validateOne (String str) throws Exception
{
// code that returns an "int"
}
 
int validateTwo (String str) throws Exception
{
// code that returns an "int"
}
 
int validateThree (String str) throws Exception
{
// code that returns an "int"
}

Is this script code functional ???
 
Thanks-in-advance...
 
 
Tadeu Augusto Dutra Pinto
-
IT Web Services ATM 
Cinq Technologies
http://www.cinq.com.br 
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 
Fone: 41 3018-2833 - Cinq
Fone: 41 3340-5736 - HSBC
-
Confiabilidade, Inovação e Qualidade em T.I.
 


De: Action Request System discussion list(ARSList) em nome de Carey Matthew
Black
Enviada: ter 2/10/2007 00:23
Para: arslist@ARSLIST.ORG
Assunto: Re: How to use "ARS Scripting Plug-in for JAVA" ???



Look at the form "Java Scripting Test" and specifically the filters
"Java Scripting:Get Script Code, Plugin, and Language" and "Java
Scripting:Execute".

Basically, the "Filter Script Library" form holds data records that
are feed into the ARF (AR Filter) plugin via the Filter "Java
Scripting:Execute". The action can be done from any form. (So the
filter does not need to be attached to the "Java Scripting Test"
form.) You need to supply the action data that looks like the data in
"Filter Script Library". Only the Java code needs to do what you want
it to do. :)

In sort, the plug in takes these inputs:

1) The Java code ( as a string )
2) Language (the string "Java" in this case)
3) The first argument that will be passed into the Java code (input #1)
4) The next argument that will be passed into the Java code (input #1)
5)  The next argument that will be passed into the Java code (input #1) 

Hope that helps.

--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.


On 10/1/07, Tadeu Augusto Dutra Pinto <[EMAIL PROTECTED]> wrote:
> **
>
>
>
> Hi,
>
>
> How I can use these plug-in to create a Filter that executes a script ??
>
> On "Form Name" field (at Basic tab) I'll select the "Filter Script
Library"
> or another test form??
>
> Because in my "If Action" tab, I have to put the fields that I'd like to
> use... like: ARSYS.ARF.JAVA for "Plug-In Name", and for the combobox
"Enter
> Input Values" I have to put the entries for the "Input Value List"...
>
> But, these fields that are set at "Input Value List:" ... Where are they
> come from??? What form??
>
> Because

Re: 7.1 available today?

[Eric Roys]

Sebastiaan/anyone, 

Can you tell us if the issue with handling active links/active link guides
within the admin tool has been addressed, specifically the ultra poor
performance seen with viewing/modifying them in 7.0.1?

Thanks,

Eric

ARS 7.0.1 p3
ITSM 7.2 p4 / ITSM4.x (don't ask)
CMDB 2.x p3
Solaris 9/Oracle 10G
 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of sebas
Sent: Monday, September 03, 2007 10:01 AM
To: arslist@ARSLIST.ORG
Subject: Re: 7.1 available today?

Hi all,

I had a change to play around with the 7.1 server over the weekend a
bit and have started on a review of some features. You can find it
here: http://arsystem.xqsr.com/new-in-ars-71/

I hope to have some time to look at the new Java plugins and API
tomorrow, one of the sample ARDBC plugins is for a jdbc driver, which
of course is all kinds of cool since with an jdbc-odbc bridge you can
theoretically connect to any SQL database!

Cheers,

Sebastiaan de Man
http://arsystem.xqsr.com/

On 31 Aug., 21:33, "Easter, David" <[EMAIL PROTECTED]> wrote:
> Should be up on EPD sometime after 5pm Pacific Time today.
>
> Thanks,
>
> -David J. Easter
> Sr. Product Manager, Service Management Business Unit
> BMC Software, Inc.
>
> The opinions, statements, and/or suggested courses of action expressed
> in this E-mail do not necessarily reflect those of BMC Software, Inc.
> My voluntary participation in this forum is not intended to convey a
> role as a spokesperson, liaison or public relations representative for
> BMC Software, Inc.
>
> 
>
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Sebastiaan De Man
> Sent: Friday, August 31, 2007 6:44 AM
> To: [EMAIL PROTECTED]
> Subject: Re: 7.1 available today?
>
> ** So am I, last I heard it was 31 August. I guess it's still early in
> California.
>
> 2007/8/31, Moore, Chris <[EMAIL PROTECTED]>:
>
> **
>
> Has anyone heard if 7.1 will be out today for sure?  Right now
> I'm still seeing 7.0.1 on the product download page.
>
> Chris Moore
>
> __20060125___This posting was submitted with
> HTML in it___
>
> __20060125___This posting was submitted with HTML in
> it___
>
>
___-

> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where the
Answers Are"


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

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

Re: AR System Developer Studio Wishlists

[Eric Roys]

I'd like the ability to disable one or multiple actions in an active link or
filter instead of having to delete/re-add the action during troubleshooting.


 

Eric Roys

Sr. Software Engineer

 

CONFIDENTIALITY: The information contained in this message and any
attachment may be proprietary, confidential, and privileged or subject to
the work product doctrine and thus protected from disclosure. If the reader
of this message is not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this
communication in error, please notify me immediately by replying to this
message and deleting it and all copies and backups thereof. Thank you.

  _  

__20060125___This posting was submitted with HTML in
it___ __20060125___This posting was submitted with HTML
in it___

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

Re: init-form for midtier?

[Eric Roys]

Lisa, 

Setting via the preference form has no affect if the user uses a direct url.
The user will simply go to the form and nothing with the home page is done.
That's the problem :-(

Eric


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa
Sent: Tuesday, August 07, 2007 3:34 PM
To: arslist@ARSLIST.ORG
Subject: Re: init-form for midtier?

If the user creates a favorite, I'm not sure what can be done with
workflow, etc.

Set this form to be the home page for each user on the AR System User
Preference form maybe?

Lisa

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Eric Roys
Sent: Tuesday, August 07, 2007 4:26 PM
To: arslist@ARSLIST.ORG
Subject: init-form for midtier?

All, 

I'm hoping one of you may have a solution similar to what can be done
via the windows user tool such that an administrator can define an
init-form (via ar.conf/ar.cfg) to load whenever a user logs in, but for
the mid-tier.

A home page can be set in the user preference form and via the server
config which can be set to an 'init-form'. However, if a user had
previously saved a IE favorite for the Change Management Console, as an
example, the favorite will circumvent the newly or previously defined
home page. 

The requirement is that this form should ALWAYS be the entry point into
the web regardless if users create favorites to other forms. Any way to
do this without adding workflow to every possible form the user can
access?


ARS 7.0.1 Patch3 on Win2k3
Midtier 7.0.1 Patch3 on Solaris 9
ITSM 7.2 Patch 4

Eric Roys
Verizon Business


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


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

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

init-form for midtier?

[Eric Roys]

All, 

I'm hoping one of you may have a solution similar to what can be done via
the windows user tool such that an administrator can define an init-form
(via ar.conf/ar.cfg) to load whenever a user logs in, but for the mid-tier.

A home page can be set in the user preference form and via the server config
which can be set to an 'init-form'. However, if a user had previously saved
a IE favorite for the Change Management Console, as an example, the favorite
will circumvent the newly or previously defined home page. 

The requirement is that this form should ALWAYS be the entry point into the
web regardless if users create favorites to other forms. Any way to do this
without adding workflow to every possible form the user can access?


ARS 7.0.1 Patch3 on Win2k3
Midtier 7.0.1 Patch3 on Solaris 9
ITSM 7.2 Patch 4

Eric Roys
Verizon Business

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

Re: Remedy Upgrade Issue To version 7.0

[Eric Roys]

John, 

We have the same issue (same environment, same upgrade path). The immediate
solution per Remedy Support is to export data from the offending form(s)
(i.e. requestID + offending fields), drop/recreate the offending fields, and
then re-import the data with update record preference. The other option I
was given was: submit a bug to support and escalate the ticket to get
feedback from engineering.

HTH,

Eric Roys
Sr. Software Engineer
Verizon Business

CONFIDENTIALITY: The information contained in this message and any
attachment may be proprietary, confidential, and privileged or subject to
the work product doctrine and thus protected from disclosure. If the reader
of this message is not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this
communication in error, please notify me immediately by replying to this
message and deleting it and all copies and backups thereof. Thank you.


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of jmchugh
Sent: Thursday, March 22, 2007 7:19 AM
To: arslist@ARSLIST.ORG
Subject: Remedy Upgrade Issue To version 7.0

Hi,

We have recently upgraded remedy from ARS version 5.1.2 to 6.0.1 to
7.0.1 on Oracle 10g R2 on a Solaris 9 platform.


We have found that no long type character fields have converted too
clobs or varchars as would be expected.


The issue has caused all ofending forms too drop there sql views.


Has anyone seen this type of issue?


What have you done too overcome this issue?


Do you have any advice on how this can be resolved?


Thanks for your advice in advance.


John McHugh
Remedy Consultant


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

__
This e-mail has been scanned by Verizon Managed Email Content Service, using
SkepticT technology powered by MessageLabs. For more information on Verizon
Managed Email Content Service, visit http://www.verizonbusiness.com.
__


__
This e-mail has been scanned by Verizon Managed Email Content Service, using 
Skeptic™ technology powered by MessageLabs. For more information on Verizon 
Managed Email Content Service, visit http://www.verizonbusiness.com.
__

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

Failure to Create View

[Eric Roys]

ARS7.0.1 patch 1
Solaris 9
Oracle 10gR2 Client / 9i db

Has anyone had issues saving a large form where the view is
dropped/recreated during a field add/change/removal but fails on the
recreation of the view with an error that a 'keyword' is missing? The sql
log shows that only 75% of the statement is actually submitted, which means
the select/from portion of the statement is dropped. Running the same
statement via SQLPlus has the same outcome. Our dba was able to recreate the
view manually using a different technique; however, it means that any change
to the form which requires drop/recreate of the view requires the manual
recreation of the view because ARS fails on the recreation of the view. 

We've been running the 10g client/9i db combination for several months with
no issues (planning 10g db upgrade in about a week). The only thing that has
changed was upgrade from 7.0.0 to 7.0.1 p1 for DST.

Any assistance would be appreciated!

Eric Roys
Sr. Software Engineer
Verizon Business
Email:  [EMAIL PROTECTED]
 
CONFIDENTIALITY: The information contained in this message and any
attachment may be proprietary, confidential, and privileged or subject to
the work product doctrine and thus protected from disclosure. If the reader
of this message is not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this
communication in error, please notify me immediately by replying to this
message and deleting it and all copies and backups thereof. Thank you.


__
This e-mail has been scanned by Verizon Managed Email Content Service, using 
Skeptic™ technology powered by MessageLabs. For more information on Verizon 
Managed Email Content Service, visit http://www.verizonbusiness.com.
__

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

Re: Installing Mid-Tier

[Eric Roys]

Les, 

Stan has a pretty comprehensive guide that may help... it's for 6.3, but
it's pretty much the same stuff.

http://www.javasystemsolutions.com/docs/ApacheTomcatMidtierv1.pdf


Eric Roys
Sr. Software Engineer
Verizon Business
Email:  [EMAIL PROTECTED]
 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, February 06, 2007 12:24 PM
To: arslist@ARSLIST.ORG
Subject: Installing Mid-Tier

Hello,
Would anyone out there have a step by step procedure for installing Mid-Tier
for
ARS 7.0.1?

The machine is running AIX
Apache web server

I have never installed Mid-Tier before
I have very little AIX
I have no experience with Apache

When I try to follow the PDF provided by Remedy it refers to ServletExec,
but
actually installs Tomcat. The guide does not specify how to start/stop
Tomcat.
The guide does not specify any environment variables required (I don't
think).
I have tried a couple times with no luck. Every appeard to install fine
without
error, but when I use a windows machine to browse to the specified
configuration
page it won't display, even thogh I know the machines can see each other.

I am quite lost here and could really use some help. If anyone has done a
complete install all the way from pre to post I could sure use your notes.

Thank you

Les Ganton


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

__
This e-mail has been scanned by Verizon Managed Email Content Service, using
SkepticT technology powered by MessageLabs. For more information on Verizon
Managed Email Content Service, visit http://www.verizonbusiness.com.
__


__
This e-mail has been scanned by Verizon Managed Email Content Service, using 
Skeptic™ technology powered by MessageLabs. For more information on Verizon 
Managed Email Content Service, visit http://www.verizonbusiness.com.
__

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

ARS7.x on Oracle 10G R2 on Solaris 9

[Eric Roys]

 
Good morning listers, 

Platform currently: 
Solaris 9
Oracle 9i2
ARS 6.3 patch 14
Midtier 6.3 patch 15

To conform with data privacy initiatives we must upgrade Oracle 9i2 to
Oracle 10gR2. As some of our other project databases were upgraded certain
issues started to emerge. On a test platform (ARS 7.0.1/Oracle 10gR2
(client/db)/Solaris9) there doesn't appear to be any issue with 10gR2 so
far, however, if anyone is running on a similar platform and has any insight
as to any Oracle issues under this configuration, I would certainly
appreciate any feedback.

Kind Regards,

Eric Roys
Sr. Software Engineer
Verizon Business
Email:  [EMAIL PROTECTED]
 
CONFIDENTIALITY: The information contained in this message and any
attachment may be proprietary, confidential, and privileged or subject to
the work product doctrine and thus protected from disclosure. If the reader
of this message is not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this
communication in error, please notify me immediately by replying to this
message and deleting it and all copies and backups thereof. Thank you.


__
This e-mail has been scanned by Verizon Managed Email Content Service, using 
Skeptic™ technology powered by MessageLabs. For more information on Verizon 
Managed Email Content Service, visit http://www.verizonbusiness.com.
__

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

Re: ARS object cross-reference

[Eric Roys]

Matt, 

Just curious what the performance was like for you using the XSL approach
against an XML file ranging in the neighborhood of 100+ MB?  I messed with
it a bit after delving into XSL for another project and the results were
less than responsive. I had better luck parsing it with PERL (which wasn't
pretty), but it still took plenty of time. It's too bad you ran into a road
block with your web-based utility as it looked promising. Can you elaborate
on the scaling issue?


Eric Roys
Sr. Software Engineer
Verizon Business
Email:  [EMAIL PROTECTED]
 
CONFIDENTIALITY: The information contained in this message and any
attachment may be proprietary, confidential, and privileged or subject to
the work product doctrine and thus protected from disclosure. If the reader
of this message is not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this
communication in error, please notify me immediately by replying to this
message and deleting it and all copies and backups thereof. Thank you.


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black
Sent: Thursday, November 30, 2006 9:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARS object cross-reference

Mike,

With some effort you can take the following approach and do all of this to
your own specification.

Export the defs in XML format.
Use XSL to "search" and make whatever "report" you want from the XML def.

If you go really crazy with it you can even make this all web based.

( If you go this way, feel free to ask detailed questions on the list.
I am sure I can help. AKA: I have something in my back pocket that I wrote
for v5 that appears to still work fairly well for v6 and v7, but I have
never really released it because of XML/XSL scaling issues. )


--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.


On 11/30/06, Mike White <[EMAIL PROTECTED]> wrote:
> Listers,
>
>   Do any of you have strong opinions regarding an object 
> cross-reference utility?  We're former MARS users (now disgruntled RDP 
> users).  I hoped by now BMC would have a working RDP available, but 
> according to their support site, they don't (still 6.0).
>
>   I've browsed ARUtilities Plus 6.5 and it looks like it may be close.
> We'd looked a little at Panacea's Workflow Studio last year and it 
> looked decent, but needed a little work on results export (which I was 
> told was minor/simple).
>
>   All we really want is a reliable facility that will search for 
> text or field references in all areas of all workflow objects, with 
> the ability to export search results to an external file (preferably
.csv).
>
>   Can you share any insight?
>
>   Thanks!
>
> Mike White
> Office:  813-978-2192
> E-mail:  [EMAIL PROTECTED]
>
> __
> _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
> ARSlist:"Where the Answers Are"
>


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

__
This e-mail has been scanned by Verizon Managed Email Content Service, using
SkepticT technology powered by MessageLabs. For more information on Verizon
Managed Email Content Service, visit http://www.verizonbusiness.com.
__


__
This e-mail has been scanned by Verizon Managed Email Content Service, using 
Skeptic™ technology powered by MessageLabs. For more information on Verizon 
Managed Email Content Service, visit http://www.verizonbusiness.com.
__

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

Re: perform-actions-add-attachment

[Eric Roys]

Title: RE: perform-actions-add-attachment
**




Bob,
 
Is the 
process simply a process call or a set field run process? If it's just simply a 
process call, it is a fire and forget thing and may not have time to generate 
the file before your subsequent al tries to attach it. If you use a set field 
run process it will ensure that the file is fully generated before your next 
action fires. I do something similar with filters.. via the filter add 
attachment, the command looks like this:
 
$PROCESS$ PERFORM-ACTION-ADD-ATTACHMENT 536880912 
"/var/tmp/execfb.xml"
 
So, 
you either have the phasing issue or you may simply need to add the 
double-quotes to your statement
 
You do 
need the @@: because you are calling it from an AL but need to run it via the server so it 
would be
$PROCESS$ @@:PERFORM-ACTION-ADD-ATTACHMENT 
536880912 "/var/tmp/execfb.xml"
 
The other 
consideration is permissions...running ARS as root shouldn't cause you a 
problem, but if you are running as non-root, your ARS unix account will need 
access to the appropriate directory/file.
 
HTH
 
Eric Roys
Sr. Software 
Engineer
Verizon Business


 
 


From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, 
RobertSent: Tuesday, November 14, 2006 3:36 PMTo: 
arslist@ARSLIST.ORGSubject: Re: 
perform-actions-add-attachment
** 

Well the users shouldn't be able to access any 
directories.  Which is why I i'm running the process on the server.  
Am I to believe that we can't add attachments that reside on the ARSystem server 
without that user having access to it?
 
What I'm trying to do is have Remedy add an attachment that 
resides on the ARSystem server (that was created by a perl script that 
resides on that server) into an attachment field via an AL. But is this 
possible?
 
Bob Halstead
 


From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J 
C-E LCMC HQISEC/L3Sent: Tuesday, November 14, 2006 2:27 
PMTo: arslist@ARSLIST.ORGSubject: Re: 
perform-actions-add-attachment
** 
Bob:   The 
fact that the server is UNIX should have nothing to do with this.  Maybe it 
is a permission issue.  Can the user get to and access this file?  
Also, remember the format for Windows is:
c:\yada\yada\yada\filename.txt. 
  James McKenzie L-3 GSI   
 
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of 
Halstead, Robert Sent: Tuesday, November 14, 2006 2:10 
PM To: arslist@ARSLIST.ORG Subject: Re: perform-actions-add-attachment 
** Btw, the client is on windows, server 
is on unix.  Could it be that I can't add an attachment from the server 
using an AL?
Bob Halstead   
 
From: Halstead, Robert Sent: Tuesday, 
November 14, 2006 1:54 PM To: 
'arslist@ARSLIST.ORG' Subject: 
PERFORM-ACTION-ADD-ATTACHMENT 
I have this form in remedy that runs a perl script on the server 
via AL.  This perl script creates an excel file based on command line 
arguments passed to it by remedy.  I then have another AL that runs right 
after it doing a PERFORM-ACTION-ADD-ATTACHMENT process cmd.
For some reason the 
PERFORM-ACTION-ADD-ATTACHMENT command fails or doesn't do anything. 
  this is all on a unix box 
btw.   my run process cmd 
looks like this: PERFORM-ACTION-ADD-ATTACHMENT 536880912 
/home/jsoria/SCRIPTS/PERL/REPORTS/log.txt   
The ID is correct, it points to a attachment field (not the 
pool). That txt file is at that location as well.   One thing, do I need to add a @@: in front 
of that?  I've tried and I get a ARERR 90 Connection error. 
  Anyone think of what I'm doing 
wrong? 
Bob Halstead __20060125___This 
posting was submitted with HTML in it___ 
__This 
e-mail has been scanned by Verizon Managed Email Content Service, using Skeptic 
technology powered by MessageLabs. For more information on Verizon Managed Email 
Content Service, visit 
http://www.verizonbusiness.com.20060125___This 
posting was submitted with HTML in it___ 

__
This e-mail has been scanned by Verizon Managed Email Content Service, using Skeptic™ technology powered by MessageLabs. For more information on Verizon Managed Email Content Service, visit http://www.verizonbusiness.com.
__

__20060125___This posting was submitted with HTML in it___

Re: Remedy Support Site - Fixed?

[Eric Roys]

**



... Still waiting, too... ever since first thing this 
AM.
 
Eric Roys
Sr. Software Engineer
Verizon Business
Email:  
[EMAIL PROTECTED]
 

CONFIDENTIALITY: The information contained in this message and any attachment 
may be proprietary, confidential, and privileged or subject to the work product 
doctrine and thus protected from disclosure. If the reader of this message is 
not the intended recipient, or an employee or agent responsible for delivering 
this message to the intended recipient, you are hereby notified that any 
dissemination, distribution or copying of this communication is strictly 
prohibited. If you have received this communication in error, please notify me 
immediately by replying to this message and deleting it and all copies and 
backups thereof. Thank you.
 


From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Laura 
YorkSent: Tuesday, October 17, 2006 4:43 PMTo: 
arslist@ARSLIST.ORGSubject: Re: Remedy Support Site - 
Fixed?
** 

Susan, have you gotten anything yet?
 
I've been waiting over 5 hours now for licenses.  Has 
anyone gotten licenses today?  I have also opened several tickets and all 
of them are still sitting in New status...  They must really be 
swamped.
 

Laura 
York
Remedy Support
generationE 
Technologies


From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Susan 
PalmerSent: Tuesday, October 17, 2006 2:06 PMTo: 
arslist@ARSLIST.ORGSubject: Re: Remedy Support Site - 
Fixed?
** 
I'm waiting for licenses right now also, but only requested them 10 minutes 
ago.  That was not a clearly marked process either!
 
Susan 
On 10/17/06, Laura 
York <[EMAIL PROTECTED]> 
wrote: 
Has 
  anyone been able to get licenses from the new site.  I put a request 
  inseveral hours ago and still have not received my license 
  keys.  I got a message that said my request was successful and 
  they would be emailed tome...Laura YorkRemedy 
  SupportgenerationE 
  Technologies 
  ___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org__This 
e-mail has been scanned by Verizon Managed Email Content Service, using Skeptic 
technology powered by MessageLabs. For more information on Verizon Managed Email 
Content Service, visit 
http://www.verizonbusiness.com.20060125___This 
posting was submitted with HTML in it___ 

__
This e-mail has been scanned by Verizon Managed Email Content Service, using Skeptic™ technology powered by MessageLabs. For more information on Verizon Managed Email Content Service, visit http://www.verizonbusiness.com.
__

__20060125___This posting was submitted with HTML in it___

Re: Two different Condition 's in Run If

[Eric Roys]

Himanshu, others.. 

Perhaps I missed something or haven't had enough coffee, but.. 

Why not just: 

(($OPERATION$ = "CREATE")) OR (($OPERATION$ = $QUERY$) AND ('Case ID+' =
$NULL$))

>From Matt's previous post, the reason for the other criteria is based on
"default values" which may or may not exist. So this will work for either
without depending on values that may default or may be cleared with Ctrl-E,
etc. 

-E


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kohli, Himanshu
Sent: Friday, September 15, 2006 9:43 AM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If

Hi Fred 
 
No even what you have suggested this time didn't worked  :(
 
1) First options of yours fail for both the scenario's i.e. CREATE & QUERY
2) Second option i.e. by making a swap by using a NOT works only for the
first condition ( i.e. Query or Create ..which ever is mentioned before the
OR )
 
(NOT (($OPERATION$ = "CREATE") AND ('Case ID+' = "HD")) OR(($OPERATION$ =
"QUERY") AND ('Case ID+' = $NULL$)))  ==>  Works for CREATE
 
(NOT (($OPERATION$ = "QUERY") AND ('Case ID+' = $NULL$)) OR (($OPERATION$ =
"CREATE") AND ('Case ID+' = "HD")))  ==>  Works for QUERY
 
 
Looking forward to crack this simple :( stuff with your Help & Info
 
Himanshu 
 



From: Action Request System discussion list(ARSList) on behalf of Grooms,
Frederick W
Sent: Thu 9/14/2006 7:25 PM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If



You want the error for these 2 conditions (and the error is in the else).
 1) On Query when he has no Case Id selected or searched (i.e. Case ID =
Null )
 2) On Create when his Case ID has a default value ( Case ID = HD)

So those conditions would be:
 1. ($OPERATION$ = "QUERY") AND ('Case ID' = $NULL$)  2. ($OPERATION$ =
"CREATE") AND ('Case ID' = "HD")

So putting them together would be (This will give you the error in the
If):
 (($OPERATION$ = "QUERY") AND ('Case ID' = $NULL$)) OR  (($OPERATION$ =
"CREATE") AND ('Case ID' = "HD"))

You can either swap the actions or NOT the entire criteria:
 (NOT (($OPERATION$ = "QUERY") AND ('Case ID' = $NULL$))
  OR (($OPERATION$ = "CREATE") AND ('Case ID' = "HD")))

Fred


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kohli, Himanshu
Sent: Thursday, September 14, 2006 3:11 PM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If

James

It so simple but making me really crazy about it ...

ok let me try to explain you briefly

I want to block a user action on a Button Click to open a new Window and to
include both the condition's in a single ACTL's Run If

1) On Query when he has no Case Id selected or searched (i.e. Case ID = Null
)
2) On Create when his Case ID has a default value ( Case ID = HD)

Now I am trying that

Run If  ==>  ('Case ID' != $NULL$)  OR ('Case ID' != "HD")

If  Action ==>  Open the Window

Else If==>  Error Msg


Result : If I use only one of each condition in the Run If ..it works as
desired but fails when I try to use both with "OR"

I beleive its somthing to relate with the execution of an ACTL at two
different Operation's CREATE & QUERY on Help Desk form.

I am having

ARS 6.3 , Windows 2k with MS SQL 2K

I hope you will be able to pull me out of this ...

Thanks & Regards
Himanshu Kohli
Remedy Developer / Administrator

PS : It looks so simple but has made me sound like 



From: Action Request System discussion list(ARSList) on behalf of McKenzie,
James J C-E LCMC HQISEC/L3
Sent: Thu 9/14/2006 3:14 PM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If

Himanshu:
 
What EXACTLY are you trying to do?  Your Run-if qualification is leading me
to ask the question.
 
Thank you for changing the Subject:
 
James McKenzie
L-3 GSI



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kohli, Himanshu
Sent: Thursday, September 14, 2006 12:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If

Eric
 
No even this is not working ...
 
Frederick
 
My ACTL executes on a Button on Help Desk form and runs for both CREATE &
QUERY operations but only Status field is a Required Field so idealy this
should not make my Run If condition fail..


Once again If I am using just one of the condition without using 'OR'
all works as desired...
 
plz help me 

Re: HP Openview/ARS

[Eric Roys]

 
Dave, 

That's how it was presented to our management (HP OV Service Desk).. An
ITSM/ITIL solution with it's own CMBD built-in. If an org already had the
rest of HP's products (OVO, NNM, Service Navigator, etc), the SD package
would seem to make sense with the assumption that all HP products should
'play well with one another', thereby eliminating the need to write custom
interfaces. To my understanding, that isn't exactly the case. There seems to
be a lot of data silo'ing with various different HP pieces, which is what
you'd expect from buying market share in the ITIL arena (i.e. buy from
someone who already built it and worry about how to integrate it later but
never really do, or make a poor attempt at it). I don't recall what HP is
going to label their next gen Service Desk, but it will make use of a lot of
the features from the Peregrine apps they bought, including whatever
Peregrine had for their equivellant to Remedy's midtier. 

-E


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Shellman, David
Sent: Wednesday, September 13, 2006 7:05 PM
To: arslist@ARSLIST.ORG
Subject: Re: HP Openview/ARS

Shawn,

Actually HP offers a Help Desk product along with their own version of CMDB.
HP purchased Peregrine which had a Help Desk product and Asset Management.
They recently purchased Mercury ITG which marketed a Change Management
solution and another version of CMDB.  When all the products were combined
it probably could be considered an ITSM suite of products.

All these products seem to be labeled as HP OpenView in their marketing
along with NNM and OVO.

Dave

>Date:Wed, 13 Sep 2006 14:27:33 -0500
>From:"Pierson, Shawn" <[EMAIL PROTECTED]>
>Subject: Re: HP Openview/ARS
>
>Lars,
>
>It has been a few years since I've worked with Openview, but I have to
say that replacing ARS with Openview makes as much sense as replacing your
car
>with boat.  They are two completely different tools for different
tasks.  Openview is for system monitoring, ARS is a development platform.
There is
>certainly some overlap between the applications, but they serve two
different functions.
>
>HP Openview's Asset management system is primitive compared to BMC's.
Openview as a monitoring tool competes with a few other BMC apps that are
not
>really based in ARS, such as the discovery tools and Control-M.  It
sounds to me like your management don't really understand what they are
trying to do.
>
>It is true that ARS is expensive, and that if you purchase the OOB apps
it becomes even more costly.  However, I don't think either of those costs
are as
>high as it would be to code a similar system from scratch in C++ or
even ASP, and neither can be modified as fast as ARS.  I don't know enough
about
>Openview currently to know if it has helpdesk functionality, but I
would think that the result is that you use C++ or Java to write your own
apps from
>scratch and integrate via an API with Openview and spend a long time
doing it.
>
>Your best bet is to talk to the management and find out what their
requirements are, because I don't see how anyone could consider replacing
one piece of 
>software with something completely irrelevant to it.  If they need
system monitoring functionality, you can integrate Openview with Remedy, or
purchase 
>the BMC tools.
>
>Thanks,
>
>Shawn Pierson

Dave Shellman

Phone:  (717) 810-3687
Fax:(717) 810-2124
email:  [EMAIL PROTECTED]

tyco/Electronics
A tyco International LTD Company
MS 161-043
PO Box 3608
Harrisburg, PA 17105-3607


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

__
This e-mail has been scanned by Verizon Managed Email Content Service, using
Skeptic technology powered by MessageLabs. For more information on Verizon
Managed Email Content Service, visit http://www.verizonbusiness.com.
__


__
This e-mail has been scanned by Verizon Managed Email Content Service, using 
Skeptic™ technology powered by MessageLabs. For more information on Verizon 
Managed Email Content Service, visit http://www.verizonbusiness.com.
__

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: HP Openview/ARS

[Eric Roys]

L ars, 

I feel your pain...  

Is there an Admin tool for HP Openview which can be compared with ars, make
changes fast, safe and even in production?

There is an Admin tool (HP Service Desk) which does allow you to make
certain changes such as adding new fields, changing layout (within specific
guidelines), creating "smart actions" (i.e. client-side/server-side
workflow), running processes, etc. To call it a Design tool would be a
stretch because the "design" that you can do with it doesn't include
generating an application/form from scratch. You can 'extend' and existing
form (i.e. comparable to creating a different view of the same form in
Remedy), but can't create a form from scratch (natively). Of what you 'can'
do, the process is pretty straight-forward after toying with it a bit, and
the changes take similar amounts of time as with Remedy changes. Would I
trust production changes? Only if it's an emergency change, but that's a
business policy more than a tool issue.  

How will the migration be done and what will it cost ... We can't loose all
reqeusts. A lot of data must to be transfered to the new system in a new
datastructure.
That will depend on your existing forms/data. Refering to the first
question's answer, if SD doesn't have a form template for you to map your
remedy form into, then you will have to find an alternate solution which
might include working at the SD Api level and/or directly against the db.
(That's my understanding from the many demos that we received). As far as
export/import of your data for those forms that 'may' map relatively well,
SD offers an import utility which can bulk import from another database, or
you can go the CSV or API route. 

Maybe Integration is the best solution, we run ars and they run openview,
just build an IF between those two systems intead of replacing one?
Regardless of your management's intentions, integration or even segregation
will most likely be your final outcome in order to support your custom apps.
For OTB apps like Incident, Change, Problem, etc, those can port relatively
well as both Remedy ITSM and SD are similar 'enough'. So you could run any
OTB using HP but run all your custom apps via Remedy.

While at an HP conference, one of our developers talked with some of HP's
Service Desk customers. Almost 80% had to extend functionality by using the
api. 

As for cost savings.. You hit the nail on the head. When factoring in
re-training your user base, migrating data/workflow, purchasing new hardware
to support it, new license cost, new application cost, maintenance cost, and
everything else, it doesn't exactly add up to more savings. Btw, if you ever
received a Peregrine T-shirt and you do go with Service Desk, you can wear
the t-shirt again since Peregrine's Service Center will eventually meld into
the OOTB SD apps. (It's worth it just for the t-shirt, right?).


Eric Roys
Sr. Software Engineer
Verizon Business
Email:  [EMAIL PROTECTED]
 
CONFIDENTIALITY: The information contained in this message and any
attachment may be proprietary, confidential, and privileged or subject to
the work product doctrine and thus protected from disclosure. If the reader
of this message is not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this
communication in error, please notify me immediately by replying to this
message and deleting it and all copies and backups thereof. Thank you.


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Wednesday, September 13, 2006 2:15 PM
To: arslist@ARSLIST.ORG
Subject: HP Openview/ARS

Hello, I would like to get some comments upon this issue: Suppose the
Management make a decision because 'ARS is expensive' - replace the ars
system with HP Openview. My thougts are:

Is there an Admin tool for HP Openview which can be compared with ars, make
changes fast, safe and even in production?

How will the migration be done and what will it cost ... We can't loose all
reqeusts. A lot of data must to be transfered to the new system in a new
datastructure.

Suppose 700 active users, If every user needs 8 h time to learn a new
system, this means 5600 h, and 8 h is at a low estimate I think.

Is ars expensive? Maybe licenses, but is development expensive? Some skilled
ars devlelopers can implement a lot with only 100 hrs of work. The same with
Openview? Our system has always been changing rapidly, new conditions every
year, not a problem, just make a new release of the application with max 15
hrs of migration. Easy to make a new release of an Openview application with
new code?

I guess that another p

Java API max entries

[Eric Roys]

**



All, 
 
Looking for a sanity check on a particular piece of 
java api code
 
EntryListInfo[] 
entryInfo = 
EntryFactory.findEntryListInfos(   context, 
listCriteria, criteria, false, nMatches );
 
If I 
use a qual of 1=1, nMatches returns a count of all entries in the form (i.e. 
29993). 
When 
using entryInfo.length, returns a value of 10k, which is max entries set by 
server. 
 
Other 
than writing a loop to re-query after handling the first 10k records or turning 
off Max Entries, is there any way to bypass the server max records 
limit?
Any advice would be 
appreciated.
 
Ars 6.3 and Ars7.0
Using 7.x api
 
 
Eric Roys
Sr. Software Engineer
Verizon Business

Email:  [EMAIL PROTECTED]
 

CONFIDENTIALITY: The information contained in this message and any attachment 
may be proprietary, confidential, and privileged or subject to the work product 
doctrine and thus protected from disclosure. If the reader of this message is 
not the intended recipient, or an employee or agent responsible for delivering 
this message to the intended recipient, you are hereby notified that any 
dissemination, distribution or copying of this communication is strictly 
prohibited. If you have received this communication in error, please notify me 
immediately by replying to this message and deleting it and all copies and 
backups thereof. Thank you.
 


From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jason 
MillerSent: Wednesday, September 06, 2006 1:26 PMTo: 
arslist@ARSLIST.ORGSubject: Re: Question: Disable 
ODBC
** Tyrone, absolutely you can restrict everybody except admins. That 
is the beauty of it, you have the flexibility of any query that can be run in a 
filter Run If.Firing on every get entry is definitely something to take 
into consideration and was one of my concerns. I figured since it is not a query 
to the db it wasn't too much of a performance hit for my situation (it is still 
an API call to the server each time you view a record but there are going to be 
other various API calls anyways when you view a record). Plus I didn't know 
about the Disable-Client-Operations option. Thanks for the 
"Disable-Client-Operation". This looks like an awesome feature that I will play 
with. You could actually get to the user level by creating a computed group and 
specify login names (or a mix of login names and groups). Depending on the size 
of your system and the way you have your groups setup it could become a 
maintenance burden to make sure all new users are properly restricted. I 
guess this is were the get entry filter option has a bit more flexibility 
because you can disable everybody as a baseline and enable ODBC operations for a 
group with a NOT statement (i.e. NOT $GROUPS$ LIKE "%" + "Administrator" + "%" 
versus having to disable each group individually using the config file. But even 
then you could have a computed group with all groups except the Admin group to 
use with the Disable-Client-Operation. Many ways to do it (I love ARS). 
Jason
On 9/6/06, Carey Matthew 
Black <[EMAIL PROTECTED]> 
wrote:
All,ConfigGuide-630.pdf 
  Page: 287:"Disable-Client-Operation:  
  [[]-[]] 
  []Restricts time-consuming operations (such as 
  reporting) during busy times, improving the overall performance. This 
  option can be set to certain timesthe day. It can also exclude users of 
  specific groups so that they are notblocked from performing the specified 
  operation. For example, you can allow only the administrator to perform 
  reporting during busy hours."So ... I think the config file option 
  is the best bet. It would allowany specified groups to be _excluded_ from 
  the restriction. Jason's Get Entry filter option does go to one level 
  more granular (tothe user not a group) and has the added performance 
  expense of beingevaluated for every data row returned from the form. (Even 
  for theusers listed in the Run If.)I wonder if the config option 
  will (or was) similarly expanded likethe Assignee Group values were but 
  BMC failed to document thatfeature? (Maybe you can be user specific in the 
  config file? if not, then it would be a good REF idea 
  IMHO.)--Carey Matthew BlackRemedy Skilled Professional 
  (RSP)ARS = Action Request System(Remedy)Love, then 
  teachSolution = People + Process + ToolsFast, Accurate, Cheap Pick 
  two. 
  ___UNSUBSCRIBE 
  or access ARSlist Archives at http://www.wwrug.org__20060125___This 
posting was submitted with HTML in it___ 
__This 
e-mail has been scanned by Verizon Managed Email Content Service, using Skeptic™ 
technology powered by MessageLabs. For more information on Verizo

Re: Escalation reminder every X hours

[Eric Roys]

John, 

Remember, that escalations by nature are singled threaded. If you can adjust
the workflow to utilize filters for the bulk of the processing you will be
much better off since they are by nature, multi-threaded. For example, if
your HD form has 1/2 mil or a mil+ records, running escalation(s) against it
can be intensive in a single thread. Even Remedy moved away from utilizing
hundreds of escalations for their ITSM apps in favor of a more filter driven
process. Just something to consider.


Eric Roys
Sr. Software Engineer
Verizon Business
Email:  [EMAIL PROTECTED]
 
CONFIDENTIALITY: The information contained in this message and any
attachment may be proprietary, confidential, and privileged or subject to
the work product doctrine and thus protected from disclosure. If the reader
of this message is not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this
communication in error, please notify me immediately by replying to this
message and deleting it and all copies and backups thereof. Thank you.


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J
Sent: Thursday, September 07, 2006 9:12 AM
To: arslist@ARSLIST.ORG
Subject: Escalation reminder every X hours

Hello Listers,

Congrats to the ARSlist Award winners.

ARS 6.3
MS SQL Server 2000
Midtier 6.3
Homegrown Helpdesk forms

Just as a sanity check I thought I would ask if anyone has a good process
for "send out an email notification every X hours if the ticket is still at
a status of New"?

After the obvious failure of setting the escalation time to 2 Hrs ( Ticket
entered 1 second after Esc doesn't go out in email for 3 hrs 59 minutes 59
seconds) I decided to put a field on the HD form that will be populated with
create time + 2 hrs.
The escalation will run every 5 or 10 minutes and check the escalation time
stored on create. It will increase the escalation time by 2 hours if the
status is still New.
The Run If will be 'ESC_Time' < $TIMESTAMP$ AND Status = "New"

The reason I am running this by the List is that I wanted to know if there
was a slicker way to do this.
Anyone? . . . Bueller? Bueller?

Thanks,
John J. Reiser
Software Development Analyst
Remedy Administrator/Developer
Lockheed Martin - MS2
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased by
me 
 


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

__
This e-mail has been scanned by Verizon Managed Email Content Service, using
Skeptic technology powered by MessageLabs. For more information on Verizon
Managed Email Content Service, visit http://www.verizonbusiness.com.
__


__
This e-mail has been scanned by Verizon Managed Email Content Service, using 
Skeptic™ technology powered by MessageLabs. For more information on Verizon 
Managed Email Content Service, visit http://www.verizonbusiness.com.
__

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Java api driver program help - RESOLVED

[Eric Roys]

**



Theo, 
 
Thanks for the help. I got tired of messing with the 
JavaDriver for 6.3 api and just moved to JavaDriver with 7.x api and it 
compiled and ran without issue (no need to comment out the line and no missing 
file(s)).
I'm 
not sure why JavaDriver for 6.3 was looking for the icuuc28.dll file when it 
seems that 6.3 shipped with icuuc20.dll (installed with admin tool) and 7.x 
shipped with icuuc32.dll (installed with admin tool). 
 
Eric Roys
Sr. Software Engineer
Verizon Business

Email:  [EMAIL PROTECTED]
 

CONFIDENTIALITY: The information contained in this message and any attachment 
may be proprietary, confidential, and privileged or subject to the work product 
doctrine and thus protected from disclosure. If the reader of this message is 
not the intended recipient, or an employee or agent responsible for delivering 
this message to the intended recipient, you are hereby notified that any 
dissemination, distribution or copying of this communication is strictly 
prohibited. If you have received this communication in error, please notify me 
immediately by replying to this message and deleting it and all copies and 
backups thereof. Thank you.
 


From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Theo 
FondseSent: Friday, August 11, 2006 4:17 AMTo: 
arslist@ARSLIST.ORGSubject: Re: Java api driver program 
help
** 




Hi 
Eric!
 
This is something I 
came across as well some time ago.
 
To get it to work, 
simply comment out the following line in the getListEntryBlocks() method in the 
JavaDriver.java file:
 
IARRowIterator ri = new 
RowIterator();
 
Add a new line below 
it:
IARRowIterator ri = 
null;
 
Your Java driver 
program should compile & run afterwards.
 
 
Best 
regards,
Theo 
Fondse
 
 




From: Action 
Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eric RoysSent: 10 August 2006 18:05To: arslist@ARSLIST.ORGSubject: Java api driver program 
help
 
Hello all, 

 
I’m new to the java api 
(and java in general) and having issues compiling the driver program that came 
with ars 6.3 api. The following is the output generated during 
compile:
 
F:\rem_java\JavaDriver.java:2267: 
cannot find symbol
symbol  : class 
RowIterator
location: class 
JavaDriver
  
IARRowIterator ri = new RowIterator();
  
^
Note: Some input files 
use unchecked or unsafe operations.
Note: Recompile with 
-Xlint:unchecked for details.
1 
error
 
Any suggestions would 
be appreciated.
 

 
Eric 
Roys
Sr. Software 
Engineer
Verizon 
Business
Email:  
[EMAIL PROTECTED]
 
CONFIDENTIALITY: The information contained in this 
message and any attachment may be proprietary, confidential, and privileged or 
subject to the work product doctrine and thus protected from disclosure. If the 
reader of this message is not the intended recipient, or an employee or agent 
responsible for delivering this message to the intended recipient, you are 
hereby notified that any dissemination, distribution or copying of this 
communication is strictly prohibited. If you have received this communication in 
error, please notify me immediately by replying to this message and deleting it 
and all copies and backups thereof. Thank you.
__This 
e-mail has been scanned by Verizon Managed Email Content Service, using Skeptic 
technology powered by MessageLabs. For more information on Verizon Managed Email 
Content Service, visit 
http://www.verizonbusiness.com.This 
e-mail has been scanned by Verizon Managed Email Content Service, using Skeptic 
technology powered by MessageLabs. For more information on Verizon Managed Email 
Content Service, visit 
http://www.verizonbusiness.com.20060125___This 
posting was submitted with HTML in it___ __20060125___This 
posting was submitted with HTML in it___

__
This e-mail has been scanned by Verizon Managed Email Content Service, using Skeptic™ technology powered by MessageLabs. For more information on Verizon Managed Email Content Service, visit http://www.verizonbusiness.com.
__

__20060125___This posting was submitted with HTML in it___

Re: Java api driver program help

[Eric Roys]

**



Theo, 
 
That seems to have cleared up that problem. Don't suppose 
you have icuuc28.dll that you could send (offline) to clear up the next 
issue? 
(so much for download, compile and 
run).
 
Eric Roys
Sr. Software Engineer
Verizon Business

Email:  [EMAIL PROTECTED]
 

CONFIDENTIALITY: The information contained in this message and any attachment 
may be proprietary, confidential, and privileged or subject to the work product 
doctrine and thus protected from disclosure. If the reader of this message is 
not the intended recipient, or an employee or agent responsible for delivering 
this message to the intended recipient, you are hereby notified that any 
dissemination, distribution or copying of this communication is strictly 
prohibited. If you have received this communication in error, please notify me 
immediately by replying to this message and deleting it and all copies and 
backups thereof. Thank you.
 


From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Theo 
FondseSent: Friday, August 11, 2006 4:17 AMTo: 
arslist@ARSLIST.ORGSubject: Re: Java api driver program 
help
** 




Hi 
Eric!
 
This is something I 
came across as well some time ago.
 
To get it to work, 
simply comment out the following line in the getListEntryBlocks() method in the 
JavaDriver.java file:
 
IARRowIterator ri = new 
RowIterator();
 
Add a new line below 
it:
IARRowIterator ri = 
null;
 
Your Java driver 
program should compile & run afterwards.
 
 
Best 
regards,
Theo 
Fondse
 
 




From: Action 
Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eric RoysSent: 10 August 2006 18:05To: arslist@ARSLIST.ORGSubject: Java api driver program 
help
 
Hello all, 

 
I’m new to the java api 
(and java in general) and having issues compiling the driver program that came 
with ars 6.3 api. The following is the output generated during 
compile:
 
F:\rem_java\JavaDriver.java:2267: 
cannot find symbol
symbol  : class 
RowIterator
location: class 
JavaDriver
  
IARRowIterator ri = new RowIterator();
  
^
Note: Some input files 
use unchecked or unsafe operations.
Note: Recompile with 
-Xlint:unchecked for details.
1 
error
 
Any suggestions would 
be appreciated.
 

 
Eric 
Roys
Sr. Software 
Engineer
Verizon 
Business
Email:  
[EMAIL PROTECTED]
 
CONFIDENTIALITY: The information contained in this 
message and any attachment may be proprietary, confidential, and privileged or 
subject to the work product doctrine and thus protected from disclosure. If the 
reader of this message is not the intended recipient, or an employee or agent 
responsible for delivering this message to the intended recipient, you are 
hereby notified that any dissemination, distribution or copying of this 
communication is strictly prohibited. If you have received this communication in 
error, please notify me immediately by replying to this message and deleting it 
and all copies and backups thereof. Thank you.
__This 
e-mail has been scanned by Verizon Managed Email Content Service, using Skeptic 
technology powered by MessageLabs. For more information on Verizon Managed Email 
Content Service, visit 
http://www.verizonbusiness.com.This 
e-mail has been scanned by Verizon Managed Email Content Service, using Skeptic 
technology powered by MessageLabs. For more information on Verizon Managed Email 
Content Service, visit 
http://www.verizonbusiness.com.20060125___This 
posting was submitted with HTML in it___ __20060125___This 
posting was submitted with HTML in it___

__
This e-mail has been scanned by Verizon Managed Email Content Service, using Skeptic™ technology powered by MessageLabs. For more information on Verizon Managed Email Content Service, visit http://www.verizonbusiness.com.
__

__20060125___This posting was submitted with HTML in it___

Java api driver program help

[Eric Roys]

**




Hello all, 

 
I’m new to the java api 
(and java in general) and having issues compiling the driver program that came 
with ars 6.3 api. The following is the 
output generated during compile:
 
F:\rem_java\JavaDriver.java:2267: 
cannot find symbol
symbol  : class 
RowIterator
location: class 
JavaDriver
  IARRowIterator 
ri = new RowIterator();
  
^
Note: Some input files 
use unchecked or unsafe operations.
Note: Recompile with 
-Xlint:unchecked for details.
1 
error
 
Any suggestions would 
be appreciated.
 
 
Eric Roys
Sr. Software Engineer
Verizon Business
Email:  
[EMAIL PROTECTED]
 

CONFIDENTIALITY: The information contained in this message and any attachment 
may be proprietary, confidential, and privileged or subject to the work product 
doctrine and thus protected from disclosure. If the reader of this message is 
not the intended recipient, or an employee or agent responsible for delivering 
this message to the intended recipient, you are hereby notified that any 
dissemination, distribution or copying of this communication is strictly 
prohibited. If you have received this communication in error, please notify me 
immediately by replying to this message and deleting it and all copies and 
backups thereof. Thank you.

__
This e-mail has been scanned by Verizon Managed Email Content Service, using Skeptic™ technology powered by MessageLabs. For more information on Verizon Managed Email Content Service, visit http://www.verizonbusiness.com.
__

__20060125___This posting was submitted with HTML in it___

Re: View Field Deleting Files?!?!!

[Eric Roys]

**



Norm, 
 
Yes, I ran into this a long time ago. It was bugged 
(bug:SW21370). 
 
Eric Roys
Sr. Software Engineer
Verizon Business
Email:  
[EMAIL PROTECTED]
 

CONFIDENTIALITY: The information contained in this message and any attachment 
may be proprietary, confidential, and privileged or subject to the work product 
doctrine and thus protected from disclosure. If the reader of this message is 
not the intended recipient, or an employee or agent responsible for delivering 
this message to the intended recipient, you are hereby notified that any 
dissemination, distribution or copying of this communication is strictly 
prohibited. If you have received this communication in error, please notify me 
immediately by replying to this message and deleting it and all copies and 
backups thereof. Thank you.
 


From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV 
USAF 96 CG/SCWOESent: Friday, April 21, 2006 4:11 PMTo: 
arslist@ARSLIST.ORGSubject: View Field Deleting 
Files?!?!!
** 




OK, folks, have I missed the boat on 
something? This is really, really weird.  My view fields are DELETING files 
from my file system!
 
Here's what I'm doing.  I have 
a view field and a button on a regular form.  When I click the button I do 
a SET FIELDS to the view field with the following 
text:
 
For more information, 
view the FAQ:  Test.html
 
OK, simple enough.  Just text 
and a basic HTML hyperlink to a file on my C: drive.  When I click the 
button, the text appears in my view field just as expected, including the 
hyperlink.  That hyperlink looks awfully tempting, so I click it, and sure 
enough, the HTML document on the C: drive is displayed, just as expected.  
Here's where it's weird: If I save the form, the Test.html document is deleted 
from my C: drive! I'm not kidding! I had a user report this to me and at first I 
didn't believe him, but then I recreated it myself and found he was right.  
Somehow, for some reason, view fields delete files that are viewed in the view 
field by clicking hyperlinked text that was also viewed in the view 
field.
 
How weird is that? Anyone seen this 
before?
 
Remedy 
5.1.2
 
Norm__This 
e-mail has been scanned by Verizon Managed Email Content Service, using Skeptic™ 
technology powered by MessageLabs. For more information on Verizon Managed Email 
Content Service, visit 
http://www.verizonbusiness.com.20060125___This 
posting was submitted with HTML in it___ 

__
This e-mail has been scanned by Verizon Managed Email Content Service, using Skeptic™ technology powered by MessageLabs. For more information on Verizon Managed Email Content Service, visit http://www.verizonbusiness.com.
__

__20060125___This posting was submitted with HTML in it___