Re: Upgrade ARS from 7603 to 7604 SP4

[RajaShanin]

Thanks Joe, we do not intend to use the overlay concept as of now, we have
few instances of AR server going down in our server group environment and
BMC usually provides arserver.exe or arplugin.exe files (claiming to be the
latest) to be replaced quiet often, hence we decided to go with the latest
version of the arserver in order to reduce the file replacement method.

Thanks
Raja 



--
View this message in context: 
http://ars-action-request-system.1093659.n2.nabble.com/Upgrade-ARS-from-7603-to-7604-SP4-tp7588533p7588555.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

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

OT: Its friday

[Rajesh Nair]

Murphy's Funny laws: 😆

1) Law of Queue: If you change queues, the one you have left will start to
move faster than the one you are in now.

2) Law of Telephone: When you dial a wrong number, you never get a busy
tone.😅

3) Law of Mechanical Repair: After your hands become coated with grease,
your nose will begin to itch.

4) Law of the Workshop: Any tool, when dropped, will roll to the least
accessible corner.😐

6) Bath Theorem: When the body is immersed in water, the telephone rings.

7) Law of Encounters: The probability of meeting someone you know increases
when you are with someone you don't want to be seen with.

8) Law of the Result: When you try to prove to someone that a machine won't
work, it will. 

9) Law of Bio mechanics: The severity of the itch is inversely proportional
to the reach. 

10) Theatre Rule: People with the seats at the furthest from the screen
arrive last. 😅

11) Law of Coffee: As soon as you sit down for a cup of hot coffee, your
boss will ask you to do something which will last until the coffee is cold.
😩

12) Law of Proposal : After u accept a proposal you will get a better one. 

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

Re: Remedy Integration with SCOM

[onkar shinde]

Hi Anup,

You can install integration from below link:
http://blogs.technet.com/b/kevinholman/archive/2010/09/23/installing-the-opsmgr-r2-universal-connector.aspx

It has a link to download the connector for SCOM 2007 R2 for BMC Remedy ARS.

It also has instructions for integration and configuration.

Hope this helps.



On Fri, May 3, 2013 at 7:43 AM, Anup Garg  wrote:

> Hi,
>
> I am working on bmc remedy version 7.6.04 SP2 on windows 2008 R2 and SQL
> server 2008 R2 .
> I need some help on steps required to integrate SCOM with BMC Remedy. Our
> requirement is like as follows :
>
> SCOM should raise an alert whenever any server goes down and then from
> that alert an incident should be created automatically in BMC Remedy with
> the information to be picked up from CMDB about that server.
> Our incident should autmatically populates the entire summary about that
> server(CI in atrium cmdb) .
> Is it possible ?
>
> Please share some steps or any dcoument if anyone has done that before.
>
> Thanks,
> Anup
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>



-- 
Regards,
Onkar Shinde
Senior Software Engineer
Vyom Labs Pvt. Ltd.
BSM Solutions & Services || ITIL Consulting & Training

Telephone: +91-20-6632-1000
Mobile: +91-7709008719
Email: onkar.shi...@vyomlabs.com
Web: www.vyomlabs.com

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

Re: Extracting substring from string and putting the value in different field

[Sagar Valse]

Hi,

I have created 2 forms 1 display only form containing a field(desc) to
store string "INC000123, INC000456, INC000789, INC05"
,a temp field(temp) and another regular form to store the incident tickets.

1.Created alink Alink1 with actions
a.Set desc=$default$
b.Set temp=STRSTR($desc$, ",")
c.callguide AlinkGuide
   AlinkGuide:
   1. Label "Start"
   2. Call alink Alink2
   if 'temp' != "-1"
 i. Push in form 2
incno= SUBSTR($desc$, 0, $temp$ - 1)
 ii.Set desc=SUBSTR($desc$, $temp$ + 1, LENGTH($desc$))
 iii. Go to guide label Start.
   else
 i.Go to guide label End.
   3. Label "End"
d.Pushfield in form 2
   incno=desc

Thanks and Regard,
Sagar Valse


On Thu, May 2, 2013 at 7:53 PM, jayesh panchal wrote:

> **
>
> Have you tried using LEFTC function in set field action???.it will extract
> substrings and u can set into different field.
>
> Regards
> Jayesh
> On May 2, 2013 6:05 PM, "sanjay"  wrote:
>
>> Hello Lister's,
>>
>> We have a requirement. Where we have a string which contains  incident
>> id's
>> separated by ",". And my requirement is to extract the individual incident
>> from the string and put the value to separate field.
>>
>> Example of the above requirement
>> ==
>>
>> Input
>> ==
>> TMP_field ="INC000123, INC000456, INC000789, INC05"
>>
>> Output
>> ===
>> Felid1 = INC000123
>> Felid2 = INC000456
>> Felid3 = INC000789
>> Felid4 = INC05
>>
>> and my question is how do I accomplish the above task. Please help me out
>> to
>> accomplish the above requirement.
>>
>> Many thanks for all your suggestion and help in advance.
>>
>> Regards,
>> Sanjay.
>>
>>
>>
>>
>>
>>
>> --
>> View this message in context:
>> http://ars-action-request-system.1093659.n2.nabble.com/Extracting-substring-from-string-and-putting-the-value-in-different-field-tp7588518.html
>> Sent from the ARS (Action Request System) mailing list archive at
>> Nabble.com.
>>
>>
>> ___
>> 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"

Re: Remedy Integration with SCOM

[Saji Philip]

I have documentation from Kelverion I can forward to you.  Systems Center
Orhestrator was formerly called Opalis.  If your running Microsoft you
should already own it.  Theres quite a few documantation on Orhestrator on
the Microsoft website.

Just send me your contact info to 'sphili...@hotmail.com'
On May 2, 2013 9:58 PM, "Rick Cook"  wrote:

> **
>
> I have built a couple of simple things in the Opalis Orchestrator, but
> that was a few years ago.  I would do some digging on Microsoft's website
> to get more current information.
>
> Rick
> On May 2, 2013 7:54 PM, "vivek garg"  wrote:
>
>> **
>> Hi Rick ,Saji,
>>
>> If I start learning system center orchestrater, then how should I start
>> and from where should I learn about it as I have no prior knowledge on
>> orchestrator or on System center. Do you have any kind of documentation
>> which would help me understand this type of integration. Even I read
>> soemwhere that Using orchestrator would be best option for these type of
>> integrations.
>>
>> Rick,
>> Have you done it without using orchestrator?
>> On Fri, May 3, 2013 at 8:15 AM, Rick Cook  wrote:
>>
>>> **
>>>
>>> It seemed as though the new MS app, formerly known as Opalis, was
>>> similar in its build interface to the Remedy Abydos designer.  I would
>>> think there would be a CLI/API connection that would work.
>>>
>>> Rick
>>>  On May 2, 2013 7:36 PM, "Saji Philip"  wrote:
>>>
 **

 We use the Microsoft integration to create Remedy incidents from SCOM
 2007.  We are in the process of upgrading SCOM to 2012 and microsoft no
 longer supports that connection.  The new way is using Systems Center
 Orhestrater and run books utilizing a connector developed by Kelverion.  I
 hear Kelverion is working on a similar API connector used by Microsoft and
 it will be more functional (not creating just tickets).  Not sure if BAO
 can be used to integrate with SCOM..
 On May 2, 2013 9:13 PM, "Anup Garg"  wrote:

> Hi,
>
> I am working on bmc remedy version 7.6.04 SP2 on windows 2008 R2 and
> SQL server 2008 R2 .
> I need some help on steps required to integrate SCOM with BMC Remedy.
> Our requirement is like as follows :
>
> SCOM should raise an alert whenever any server goes down and then from
> that alert an incident should be created automatically in BMC Remedy with
> the information to be picked up from CMDB about that server.
> Our incident should autmatically populates the entire summary about
> that server(CI in atrium cmdb) .
> Is it possible ?
>
> Please share some steps or any dcoument if anyone has done that before.
>
> Thanks,
> Anup
>
>
> ___
> 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_
>>>
>>> _ARSlist: "Where the Answers Are" and have been for 20 years_
>>>
>>
>> _ARSlist: "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"

Re: Remedy Integration with SCOM

[Rick Cook]

I have built a couple of simple things in the Opalis Orchestrator, but that
was a few years ago.  I would do some digging on Microsoft's website to get
more current information.

Rick
On May 2, 2013 7:54 PM, "vivek garg"  wrote:

> **
> Hi Rick ,Saji,
>
> If I start learning system center orchestrater, then how should I start
> and from where should I learn about it as I have no prior knowledge on
> orchestrator or on System center. Do you have any kind of documentation
> which would help me understand this type of integration. Even I read
> soemwhere that Using orchestrator would be best option for these type of
> integrations.
>
> Rick,
> Have you done it without using orchestrator?
> On Fri, May 3, 2013 at 8:15 AM, Rick Cook  wrote:
>
>> **
>>
>> It seemed as though the new MS app, formerly known as Opalis, was similar
>> in its build interface to the Remedy Abydos designer.  I would think there
>> would be a CLI/API connection that would work.
>>
>> Rick
>>  On May 2, 2013 7:36 PM, "Saji Philip"  wrote:
>>
>>> **
>>>
>>> We use the Microsoft integration to create Remedy incidents from SCOM
>>> 2007.  We are in the process of upgrading SCOM to 2012 and microsoft no
>>> longer supports that connection.  The new way is using Systems Center
>>> Orhestrater and run books utilizing a connector developed by Kelverion.  I
>>> hear Kelverion is working on a similar API connector used by Microsoft and
>>> it will be more functional (not creating just tickets).  Not sure if BAO
>>> can be used to integrate with SCOM..
>>> On May 2, 2013 9:13 PM, "Anup Garg"  wrote:
>>>
 Hi,

 I am working on bmc remedy version 7.6.04 SP2 on windows 2008 R2 and
 SQL server 2008 R2 .
 I need some help on steps required to integrate SCOM with BMC Remedy.
 Our requirement is like as follows :

 SCOM should raise an alert whenever any server goes down and then from
 that alert an incident should be created automatically in BMC Remedy with
 the information to be picked up from CMDB about that server.
 Our incident should autmatically populates the entire summary about
 that server(CI in atrium cmdb) .
 Is it possible ?

 Please share some steps or any dcoument if anyone has done that before.

 Thanks,
 Anup


 ___
 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_
>>
>> _ARSlist: "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"

Re: Remedy Integration with SCOM

[vivek garg]

Hi Rick ,Saji,

If I start learning system center orchestrater, then how should I start and
from where should I learn about it as I have no prior knowledge on
orchestrator or on System center. Do you have any kind of documentation
which would help me understand this type of integration. Even I read
soemwhere that Using orchestrator would be best option for these type of
integrations.

Rick,
Have you done it without using orchestrator?
On Fri, May 3, 2013 at 8:15 AM, Rick Cook  wrote:

> **
>
> It seemed as though the new MS app, formerly known as Opalis, was similar
> in its build interface to the Remedy Abydos designer.  I would think there
> would be a CLI/API connection that would work.
>
> Rick
>  On May 2, 2013 7:36 PM, "Saji Philip"  wrote:
>
>> **
>>
>> We use the Microsoft integration to create Remedy incidents from SCOM
>> 2007.  We are in the process of upgrading SCOM to 2012 and microsoft no
>> longer supports that connection.  The new way is using Systems Center
>> Orhestrater and run books utilizing a connector developed by Kelverion.  I
>> hear Kelverion is working on a similar API connector used by Microsoft and
>> it will be more functional (not creating just tickets).  Not sure if BAO
>> can be used to integrate with SCOM..
>> On May 2, 2013 9:13 PM, "Anup Garg"  wrote:
>>
>>> Hi,
>>>
>>> I am working on bmc remedy version 7.6.04 SP2 on windows 2008 R2 and SQL
>>> server 2008 R2 .
>>> I need some help on steps required to integrate SCOM with BMC Remedy.
>>> Our requirement is like as follows :
>>>
>>> SCOM should raise an alert whenever any server goes down and then from
>>> that alert an incident should be created automatically in BMC Remedy with
>>> the information to be picked up from CMDB about that server.
>>> Our incident should autmatically populates the entire summary about that
>>> server(CI in atrium cmdb) .
>>> Is it possible ?
>>>
>>> Please share some steps or any dcoument if anyone has done that before.
>>>
>>> Thanks,
>>> Anup
>>>
>>>
>>> ___
>>> 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_
>
> _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"

Re: Remedy Integration with SCOM

[Rick Cook]

It seemed as though the new MS app, formerly known as Opalis, was similar
in its build interface to the Remedy Abydos designer.  I would think there
would be a CLI/API connection that would work.

Rick
On May 2, 2013 7:36 PM, "Saji Philip"  wrote:

> **
>
> We use the Microsoft integration to create Remedy incidents from SCOM
> 2007.  We are in the process of upgrading SCOM to 2012 and microsoft no
> longer supports that connection.  The new way is using Systems Center
> Orhestrater and run books utilizing a connector developed by Kelverion.  I
> hear Kelverion is working on a similar API connector used by Microsoft and
> it will be more functional (not creating just tickets).  Not sure if BAO
> can be used to integrate with SCOM..
> On May 2, 2013 9:13 PM, "Anup Garg"  wrote:
>
>> Hi,
>>
>> I am working on bmc remedy version 7.6.04 SP2 on windows 2008 R2 and SQL
>> server 2008 R2 .
>> I need some help on steps required to integrate SCOM with BMC Remedy. Our
>> requirement is like as follows :
>>
>> SCOM should raise an alert whenever any server goes down and then from
>> that alert an incident should be created automatically in BMC Remedy with
>> the information to be picked up from CMDB about that server.
>> Our incident should autmatically populates the entire summary about that
>> server(CI in atrium cmdb) .
>> Is it possible ?
>>
>> Please share some steps or any dcoument if anyone has done that before.
>>
>> Thanks,
>> Anup
>>
>>
>> ___
>> 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"

Re: Remedy Integration with SCOM

[Saji Philip]

We use the Microsoft integration to create Remedy incidents from SCOM
2007.  We are in the process of upgrading SCOM to 2012 and microsoft no
longer supports that connection.  The new way is using Systems Center
Orhestrater and run books utilizing a connector developed by Kelverion.  I
hear Kelverion is working on a similar API connector used by Microsoft and
it will be more functional (not creating just tickets).  Not sure if BAO
can be used to integrate with SCOM..
On May 2, 2013 9:13 PM, "Anup Garg"  wrote:

> Hi,
>
> I am working on bmc remedy version 7.6.04 SP2 on windows 2008 R2 and SQL
> server 2008 R2 .
> I need some help on steps required to integrate SCOM with BMC Remedy. Our
> requirement is like as follows :
>
> SCOM should raise an alert whenever any server goes down and then from
> that alert an incident should be created automatically in BMC Remedy with
> the information to be picked up from CMDB about that server.
> Our incident should autmatically populates the entire summary about that
> server(CI in atrium cmdb) .
> Is it possible ?
>
> Please share some steps or any dcoument if anyone has done that before.
>
> Thanks,
> Anup
>
>
> ___
> 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"

Re: Remedy Integration with SCOM

[Rick Cook]

Microsoft provides some Remedy code with SCOM to handle the interface.  I
know, I helped them make it work.  ;-)

Rick
On May 2, 2013 7:13 PM, "Anup Garg"  wrote:

> Hi,
>
> I am working on bmc remedy version 7.6.04 SP2 on windows 2008 R2 and SQL
> server 2008 R2 .
> I need some help on steps required to integrate SCOM with BMC Remedy. Our
> requirement is like as follows :
>
> SCOM should raise an alert whenever any server goes down and then from
> that alert an incident should be created automatically in BMC Remedy with
> the information to be picked up from CMDB about that server.
> Our incident should autmatically populates the entire summary about that
> server(CI in atrium cmdb) .
> Is it possible ?
>
> Please share some steps or any dcoument if anyone has done that before.
>
> Thanks,
> Anup
>
>
> ___
> 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"

Remedy Integration with SCOM

[Anup Garg]

Hi,

I am working on bmc remedy version 7.6.04 SP2 on windows 2008 R2 and SQL server 
2008 R2 .
I need some help on steps required to integrate SCOM with BMC Remedy. Our 
requirement is like as follows :

SCOM should raise an alert whenever any server goes down and then from that 
alert an incident should be created automatically in BMC Remedy with the 
information to be picked up from CMDB about that server.
Our incident should autmatically populates the entire summary about that 
server(CI in atrium cmdb) .
Is it possible ?

Please share some steps or any dcoument if anyone has done that before.

Thanks,
Anup

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

Re: AR System ODBC driver

[Tauf Chowdhury]

Thanks Stuart!


On Thu, May 2, 2013 at 8:35 PM, Schon, Stuart
wrote:

> **
>
> Almost everything in CR is usable. But do you want to do so. Things like
> dynamic parameters can make running the report very slow as lists of values
> need to queried from the table being referenced.
>
> ** **
>
> For example if you are reporting on the Helpdesk form and you have a
> parameter based on Status that is pulled from the DB for selection by the
> person running the report-every record in the Helpdesk form will be read to
> determine the list. You cannot branch off and read this from another table.
> So if there are 10M records then CR will read all 10M to determine the
> definitive list of Statuses.
>
> ** **
>
> If the report is being run externally from Remedy then
>
> Static Parameters (simple or list) can be used
>
> User enterable values can be used, e.g. Dates and date ranges
>
> Optional parameters (these default to Null which might not be what you
> want)
>
> Sub-reports – yes as already stated
>
> SQL Commands –yes but only tables and views and only one. It can't be a
> stored procedure or function or…..
>
> ** **
>
> If the report is embedded in Remedy then its tied to a form and about the
> only thing else that works is sub-reports. Especially you can get the CR to
> ask for parameters you need to get Remedy to do so which is used to
> pre-filter the data presented to the CR report.
>
> ** **
>
> Get the guy to try things and he will get the idea of what is possible and
> what's not.
>
> ** **
>
> ** **
>
> *Stuart Schon
> Service Desk Systems - Manager
>
>
> *
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Tauf Chowdhury
> *Sent:* Friday, 3 May 2013 10:01 AM
>
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: AR System ODBC driver
>
> ** **
>
> ** 
>
> All,
> Thanks for the great info...
> So here is some info from my superuser who has exp with Crystal (and I
> don't).
>
> Do you guys know if these features are supported by the driver?
> Crystal in general supports all these functions: multi-value parameters,
> optional parameters, static/dynamic parameters, sub-reports, TSQL
> Commands... But what is supported with the AR System Driver, and do the
> normal steps in Crystal still apply to make the functionality still work?*
> ***
>
> ** **
>
> On Thu, May 2, 2013 at 7:58 PM, Schon, Stuart 
> wrote:
>
> Sorry yes your right Fred, I meant that you CAN'T use dynamic joins
> (i.e. in the SQL) when using the OBDC driver. And as you pointed out you
> CAN'T see anything your userid is not supposed to see in the report.
>
> Using sub-reports is a real solution but it can be really really slow if
> a significant number of parent records are being processed.
>
>
> Use of the ODBC driver has significant benefits as it decodes many of
> the DB field values into nice things like dates and readable Strings for
> things such as Status. You can also test dates in your query without
> having to decode them to epoch values.
>
>
>
> Stuart Schon
> Service Desk Systems - Manager
>
> Fujitsu Australia Limited
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
>
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
> Sent: Thursday, 2 May 2013 11:42 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: AR System ODBC driver
>
> I think Stuart had a typo ...
> Since the ODBC uses the Remedy application server, if you can't see
> something in Remedy you can't see it using the ODBC driver.
>
> One way around the join limitation is to use sub-reports in Crystal.
> You can then have multiple form(s) data in the report
>
> Fred
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Schon, Stuart
> Sent: Wednesday, May 01, 2013 6:13 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: AR System ODBC driver
>
> The main limitation is that you can perform joins in the query using the
> OBDC driver. If you need to join tables together you need to build them
> in Remedy first and then use in your report.
>
> The other restriction/feature is that the driver uses the Remedy data
>
> security model - so if you can't see something using Remedy you can't
>
> see it in a report.
>
> Stuart Schon
> Service Desk Systems - Manager
>
> Fujitsu Australia Limited
>
> Please consider the environment before printing this email
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury
> Sent: Thursday, 2 May 2013 6:37 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: AR System ODBC driver
>
> Thanks Fred. I'll check it out.
>
> Sent from my iPhone
>
> On May 1, 2013, at 4:36 PM, "Grooms, Frederick W"
>  wrote:
>
> > The Integration Guide document (Page 212) lists some issues and
> > considerations
> >
> > -Original Message-
> > Fro

Re: AR System ODBC driver

[Schon, Stuart]

Almost everything in CR is usable. But do you want to do so. Things like
dynamic parameters can make running the report very slow as lists of
values need to queried from the table being referenced.

 

For example if you are reporting on the Helpdesk form and you have a
parameter based on Status that is pulled from the DB for selection by
the person running the report-every record in the Helpdesk form will be
read to determine the list. You cannot branch off and read this from
another table. So if there are 10M records then CR will read all 10M to
determine the definitive list of Statuses.

 

If the report is being run externally from Remedy then

Static Parameters (simple or list) can be used

User enterable values can be used, e.g. Dates and date ranges

Optional parameters (these default to Null which might not be what you
want)

Sub-reports - yes as already stated

SQL Commands -yes but only tables and views and only one. It can't be a
stored procedure or function or.

 

If the report is embedded in Remedy then its tied to a form and about
the only thing else that works is sub-reports. Especially you can get
the CR to ask for parameters you need to get Remedy to do so which is
used to pre-filter the data presented to the CR report.

 

Get the guy to try things and he will get the idea of what is possible
and what's not.

 

 

Stuart Schon
Service Desk Systems - Manager




From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury
Sent: Friday, 3 May 2013 10:01 AM
To: arslist@ARSLIST.ORG
Subject: Re: AR System ODBC driver

 

** 

All,
Thanks for the great info... 
So here is some info from my superuser who has exp with Crystal (and I
don't).

Do you guys know if these features are supported by the driver? 
Crystal in general supports all these functions: multi-value parameters,
optional parameters, static/dynamic parameters, sub-reports, TSQL
Commands... But what is supported with the AR System Driver, and do the
normal steps in Crystal still apply to make the functionality still
work?

 

On Thu, May 2, 2013 at 7:58 PM, Schon, Stuart
 wrote:

Sorry yes your right Fred, I meant that you CAN'T use dynamic joins
(i.e. in the SQL) when using the OBDC driver. And as you pointed out you
CAN'T see anything your userid is not supposed to see in the report.

Using sub-reports is a real solution but it can be really really slow if
a significant number of parent records are being processed.


Use of the ODBC driver has significant benefits as it decodes many of
the DB field values into nice things like dates and readable Strings for
things such as Status. You can also test dates in your query without
having to decode them to epoch values.



Stuart Schon
Service Desk Systems - Manager

Fujitsu Australia Limited

-Original Message-
From: Action Request System discussion list(ARSList)

[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Thursday, 2 May 2013 11:42 PM
To: arslist@ARSLIST.ORG
Subject: Re: AR System ODBC driver

I think Stuart had a typo ...
Since the ODBC uses the Remedy application server, if you can't see
something in Remedy you can't see it using the ODBC driver.

One way around the join limitation is to use sub-reports in Crystal.
You can then have multiple form(s) data in the report

Fred

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Schon, Stuart
Sent: Wednesday, May 01, 2013 6:13 PM
To: arslist@ARSLIST.ORG
Subject: Re: AR System ODBC driver

The main limitation is that you can perform joins in the query using the
OBDC driver. If you need to join tables together you need to build them
in Remedy first and then use in your report.

The other restriction/feature is that the driver uses the Remedy data

security model - so if you can't see something using Remedy you can't

see it in a report.

Stuart Schon
Service Desk Systems - Manager

Fujitsu Australia Limited

Please consider the environment before printing this email

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury
Sent: Thursday, 2 May 2013 6:37 AM
To: arslist@ARSLIST.ORG
Subject: Re: AR System ODBC driver

Thanks Fred. I'll check it out.

Sent from my iPhone

On May 1, 2013, at 4:36 PM, "Grooms, Frederick W"
 wrote:

> The Integration Guide document (Page 212) lists some issues and
> considerations
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury
> Sent: Wednesday, May 01, 2013 2:25 PM
> To: arslist@ARSLIST.ORG
> Subject: AR System ODBC driver
>
> **
> Version: 7.6.04
>
> All,
> Does anyone know or have a document about what capabilities are
available for the AR System ODBC driver? I have a user who is trying to
use Crystal Reports by way of the driver and some features aren't
working.
>
>
> --
> Tauf 

Re: Upgrade ARS from 7603 to 7604 SP4

[Joe D'Souza]

Short answer yes.

Long answer would be what might be a recommended approach. 7.6.04 introduces
the concept of overlays. There is no real benefit of upgrading the server
platform itself to this new version if you do not intend to update ITSM to
7.6.04 and leverage the use of overlays.

If you upgrade both the server and the ITSM app in a single project kind of
an approach, you will be able to reap the benefits of overlays a lot more
easily than otherwise by making use of the hash file that would create
overlays of your already customized version of your ITSM applications. I'm
guessing that this may get a little more complicated later - I haven't used
that as yet so I cannot say that for sure, but this is my best guess...

Cheers



-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of RajaShanin
Sent: Thursday, May 02, 2013 10:05 AM
To: arslist@ARSLIST.ORG
Subject: Upgrade ARS from 7603 to 7604 SP4

Hi

I would like to know whether we can directly upgrade from ARS 7603 (hot fix
version - FCS MWRT SW00401937) to ARS 7604 SP4 while ITSM remains in 7603?
any known errors or compatibility issues between ARS 7604 SP4 and ITSM 7603?


Thanks
Raja

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

Re: AR System ODBC driver

[Tauf Chowdhury]

All,
Thanks for the great info...
So here is some info from my superuser who has exp with Crystal (and I
don't).
Do you guys know if these features are supported by the driver?
Crystal in general supports all these functions: multi-value parameters,
optional parameters, static/dynamic parameters, sub-reports, TSQL
Commands... But what is supported with the AR System Driver, and do the
normal steps in Crystal still apply to make the functionality still work?


On Thu, May 2, 2013 at 7:58 PM, Schon, Stuart
wrote:

> Sorry yes your right Fred, I meant that you CAN'T use dynamic joins
> (i.e. in the SQL) when using the OBDC driver. And as you pointed out you
> CAN'T see anything your userid is not supposed to see in the report.
>
> Using sub-reports is a real solution but it can be really really slow if
> a significant number of parent records are being processed.
>
>
> Use of the ODBC driver has significant benefits as it decodes many of
> the DB field values into nice things like dates and readable Strings for
> things such as Status. You can also test dates in your query without
> having to decode them to epoch values.
>
>
> Stuart Schon
> Service Desk Systems - Manager
>
> Fujitsu Australia Limited
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
> Sent: Thursday, 2 May 2013 11:42 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: AR System ODBC driver
>
> I think Stuart had a typo ...
> Since the ODBC uses the Remedy application server, if you can't see
> something in Remedy you can't see it using the ODBC driver.
>
> One way around the join limitation is to use sub-reports in Crystal.
> You can then have multiple form(s) data in the report
>
> Fred
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Schon, Stuart
> Sent: Wednesday, May 01, 2013 6:13 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: AR System ODBC driver
>
> The main limitation is that you can perform joins in the query using the
> OBDC driver. If you need to join tables together you need to build them
> in Remedy first and then use in your report.
>
> The other restriction/feature is that the driver uses the Remedy data
> security model - so if you can't see something using Remedy you can't
> see it in a report.
>
> Stuart Schon
> Service Desk Systems - Manager
>
> Fujitsu Australia Limited
>
> Please consider the environment before printing this email
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury
> Sent: Thursday, 2 May 2013 6:37 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: AR System ODBC driver
>
> Thanks Fred. I'll check it out.
>
> Sent from my iPhone
>
> On May 1, 2013, at 4:36 PM, "Grooms, Frederick W"
>  wrote:
>
> > The Integration Guide document (Page 212) lists some issues and
> > considerations
> >
> > -Original Message-
> > From: Action Request System discussion list(ARSList)
> > [mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury
> > Sent: Wednesday, May 01, 2013 2:25 PM
> > To: arslist@ARSLIST.ORG
> > Subject: AR System ODBC driver
> >
> > **
> > Version: 7.6.04
> >
> > All,
> > Does anyone know or have a document about what capabilities are
> available for the AR System ODBC driver? I have a user who is trying to
> use Crystal Reports by way of the driver and some features aren't
> working.
> >
> >
> > --
> > Tauf Chowdhury
>
> 
> ___
> 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"
>



-- 
*Tauf Chowdhury

*

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

Re: AR System ODBC driver

[Schon, Stuart]

Sorry yes your right Fred, I meant that you CAN'T use dynamic joins
(i.e. in the SQL) when using the OBDC driver. And as you pointed out you
CAN'T see anything your userid is not supposed to see in the report.

Using sub-reports is a real solution but it can be really really slow if
a significant number of parent records are being processed.


Use of the ODBC driver has significant benefits as it decodes many of
the DB field values into nice things like dates and readable Strings for
things such as Status. You can also test dates in your query without
having to decode them to epoch values.


Stuart Schon
Service Desk Systems - Manager

Fujitsu Australia Limited

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Thursday, 2 May 2013 11:42 PM
To: arslist@ARSLIST.ORG
Subject: Re: AR System ODBC driver

I think Stuart had a typo ...   
Since the ODBC uses the Remedy application server, if you can't see
something in Remedy you can't see it using the ODBC driver.

One way around the join limitation is to use sub-reports in Crystal.
You can then have multiple form(s) data in the report

Fred

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Schon, Stuart
Sent: Wednesday, May 01, 2013 6:13 PM
To: arslist@ARSLIST.ORG
Subject: Re: AR System ODBC driver

The main limitation is that you can perform joins in the query using the
OBDC driver. If you need to join tables together you need to build them
in Remedy first and then use in your report.

The other restriction/feature is that the driver uses the Remedy data
security model - so if you can't see something using Remedy you can't
see it in a report.

Stuart Schon
Service Desk Systems - Manager

Fujitsu Australia Limited

Please consider the environment before printing this email

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury
Sent: Thursday, 2 May 2013 6:37 AM
To: arslist@ARSLIST.ORG
Subject: Re: AR System ODBC driver

Thanks Fred. I'll check it out.

Sent from my iPhone

On May 1, 2013, at 4:36 PM, "Grooms, Frederick W"
 wrote:

> The Integration Guide document (Page 212) lists some issues and 
> considerations
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury
> Sent: Wednesday, May 01, 2013 2:25 PM
> To: arslist@ARSLIST.ORG
> Subject: AR System ODBC driver
>
> **
> Version: 7.6.04
>
> All,
> Does anyone know or have a document about what capabilities are
available for the AR System ODBC driver? I have a user who is trying to
use Crystal Reports by way of the driver and some features aren't
working.
>
>
> --
> Tauf Chowdhury


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

Re: Merge Job

[Peter Romain]

The recon job is probably simply merging all the CI’s that have been modified 
since it last ran.

 

If you are running it for the first time it will pick up all CI’s.

 

>From your results it doesn’t look like the recon merge status is taking 
>priority over the last run time but I’ve never played with this field so don’t 
>really know what it’s supposed to do.

 

You could try adding a qualification to the merge job to prevent it merging 
anything then, when it has finished, its last run time will be set. Then try 
removing the qualification and see what happens.

 

Cheers

 

Peter

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Atul Vohra
Sent: 02 May 2013 21:01
To: arslist@ARSLIST.ORG
Subject: Merge Job

 

** 

All

 

In order to save time, we have decided to load our new test servers with 
hundreds of thousands of assets through a direct SQL import from an earlier 
direct SQL export rather than through Atrium AI and the Reconciliation Engine.  
We have figured out which tables had to be exported, have imported both the 
staging and production data using SQL, and all seems well after the import 
except for one detail.

When we first run the Reconciliation Engine Job that pushes data from staging 
into production (needed when we incrementally add assets after the initial SQL 
import), every single asset imported initially through SQL is Merged, and of 
course this takes a very long time.  This was surprising because in the 
database from the SQL import, every asset in the staging dataset has 
ReconciliationMergeStatus=50 (Merge Done) and our Job does not Merge unchanged 
CIs.  I expected none of these assets to be included in a Merge.  Moreover, all 
of our SQL-imported assets had Reconciliation IDs and the Reconciliation Job 
did correctly skip the Identification Step.

Does anyone know why we are seeing this behavior?  Is there another field on 
another form that controls why all of our records were merged even though 
ReconciliationMergeStatus=50.

We are using 8.0 and oracle 11g.

Thanks

Atul

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

Merge Job

[Atul Vohra]

All
�
In order to save time, we have decided to load our new test servers with 
hundreds of thousands of assets through a direct SQL import from an earlier 
direct SQL export rather than through Atrium AI and the Reconciliation Engine.� 
We have figured out which tables had to
be exported, have imported both the staging and production data using SQL, and 
all seems well after the import except for one detail.
When we first run the Reconciliation Engine Job that pushes data from staging 
into production (needed when we incrementally add assets after the initial SQL
import), every single asset imported initially through SQL is Merged, and of 
course this takes a very long time.� This was surprising because in the 
database from the SQL import, every asset in the staging dataset has 
ReconciliationMergeStatus=50 (Merge Done) and our Job does not Merge
unchanged CIs.� I expected none of these assets to be included in a Merge.� 
Moreover, all of our SQL-imported assets had Reconciliation IDs and the 
Reconciliation Job did correctly skip the Identification Step.
Does anyone know why we are seeing this behavior?� Is there another
field on another form that controls why all of our records were merged even 
though ReconciliationMergeStatus=50.
We are using 8.0 and oracle 11g.
Thanks
Atul

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

Re: Exporting data from CLM -> Non-CLM

[Hulmes, Timothy CTR MDA/ICTO]

Have tried creating a job in Pentaho?  We have recently done something similar 
and Pentaho worked for us!

Tim


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Jared Dean
Sent: Thursday, May 02, 2013 6:28 AM
To: arslist@ARSLIST.ORG
Subject: Exporting data from CLM -> Non-CLM

** 

Hello All,

 

We are currently running CLM 3.0 which contains additional cloud data that is 
not present in Atrium 8.0. We initially tried to use the CMDBDriver utility, 
but since its version specific we have been unsuccessful. 


The issue we are having is that the source Atrium has certain CMDB extensions 
that do not (and should not) exist on the target Atrium. Specifically, the CLM 
Cloud Extensions are installed on the source Atrium. When we run an import 
using the CMDBDriver utility on the stand-alone Atrium 8, we get import errors 
(120004) complaining that attributes in the XML import files does not exist in 
the target dataset. We know what the issue is, but are unsure how to solve it. 
Essentially, we want to export a subset data from CLM 3.0 Atrium. For a given 
dataset, we want to export all classes & attributes that exist in the BMC.CORE, 
BMC.AM, and possibly BMC.FED namespaces. Even when specifying a specific 
namespace to export, the resulting XML files still contain attributes that are 
provided by other namespaces. This subsequently causes imports to fail, since 
there is "extra" data.

 

Thanks for the help!

Jared 


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

Re: Filter - Webservice

[jayesh panchal]

U can use filter guide to trigger the filter again using GO TO label and
also u can use WAIT action for user interaction..i am not aware if we can
run filter after some seconds...beware of using GO TO and make sure it
doesnt lead to infinite loop..make sure u use exit to exit filter guide on
false action

Regards
Jayesh
On May 2, 2013 5:21 PM, "Govind M"  wrote:

> **
>
> I have been looking into one scenario to reproduce in test env but I just
> confused more on this. It is like I have a filter with below syntax, 
>
> ** **
>
> Filter name  : Filter A
>
> Filter runif:  field1 = abdc AND field2 = No
>
> Actions :  Set field  -> field 2 = Yes
>
>Set field   -> Trigger 3rd party webservice.***
> *
>
> ** **
>
> After firing the filter A for first time, field2 was set to the value
> “Yes” and triggered the wbs request to a middle ware app for a record.
>  After few minutes, the same request has been triggered thrice with the
> intervals of milliseconds which make me to think, after the value change in
> Runif field2, is it possible to trigger the filter again? L From the user
> tool wise, there is no track of changes in the record and we don’t have
> logs as well. I suspect this can’t be by user action, since it of
> milliseconds interval.
>
> ** **
>
> Does any come across in ARS 7.1 patch 8 in solaris box.?  Any solutions/
> ideas are much appreciated to reproduce/resolve.
>
> ** **
>
> Regards,
>
> Govind
>
> * Please do not print this email unless it is absolutely necessary. *
>
> The information contained in this electronic message and any attachments
> to this message are intended for the exclusive use of the addressee(s) and
> may contain proprietary, confidential or privileged information. If you are
> not the intended recipient, you should not disseminate, distribute or copy
> this e-mail. Please notify the sender immediately and destroy all copies of
> this message and any attachments.
>
> WARNING: Computer viruses can be transmitted via email. The recipient
> should check this email and any attachments for the presence of viruses.
> The company accepts no liability for any damage caused by any virus
> transmitted by this email.
>
> www.wipro.com
>  _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"

Re: Extracting substring from string and putting the value in different field

[jayesh panchal]

Have you tried using LEFTC function in set field action???.it will extract
substrings and u can set into different field.

Regards
Jayesh
On May 2, 2013 6:05 PM, "sanjay"  wrote:

> Hello Lister's,
>
> We have a requirement. Where we have a string which contains  incident id's
> separated by ",". And my requirement is to extract the individual incident
> from the string and put the value to separate field.
>
> Example of the above requirement
> ==
>
> Input
> ==
> TMP_field ="INC000123, INC000456, INC000789, INC05"
>
> Output
> ===
> Felid1 = INC000123
> Felid2 = INC000456
> Felid3 = INC000789
> Felid4 = INC05
>
> and my question is how do I accomplish the above task. Please help me out
> to
> accomplish the above requirement.
>
> Many thanks for all your suggestion and help in advance.
>
> Regards,
> Sanjay.
>
>
>
>
>
>
> --
> View this message in context:
> http://ars-action-request-system.1093659.n2.nabble.com/Extracting-substring-from-string-and-putting-the-value-in-different-field-tp7588518.html
> Sent from the ARS (Action Request System) mailing list archive at
> Nabble.com.
>
>
> ___
> 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"

Upgrade ARS from 7603 to 7604 SP4

[RajaShanin]

Hi

I would like to know whether we can directly upgrade from ARS 7603 (hot fix
version - FCS MWRT SW00401937) to ARS 7604 SP4 while ITSM remains in 7603?
any known errors or compatibility issues between ARS 7604 SP4 and ITSM 7603?


Thanks
Raja



--
View this message in context: 
http://ars-action-request-system.1093659.n2.nabble.com/Upgrade-ARS-from-7603-to-7604-SP4-tp7588533.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

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

Re: Extracting substring from string and putting the value in different field

[Grooms, Frederick W]

This would be a situation where I would use the arfPerl plugin (but that is 
just me) as a simple split would take care of this.

In pure ARS you could do it in a single filter that is called multiple times 
(in a Guide using goto label).  While the number of entries may be dynamic the 
actual length of an incident ID is always the same.  

In pseudo code it would be something like this:   
   Filter Run-If temp_Inbound_String != $NULL$   
   Action 1Field_10  = Field_9   
   Action 2Field_9  = Field_8   
   Action 3Field_8  = Field_7   
   Action 4Field_7  = Field_6   
   Action 5Field_6  = Field_5   
   Action 6Field_5  = Field_4   
   Action 7Field_4  = Field_3   
   Action 8Field_3  = Field_2   
   Action 9Field_2  = Field_1   
   Action 10  Field_1 = LEFT( $temp_Inbound_String$, 9)   
   Action 11  temp_Inbound_String = LTRIM(RTRIM(SUBSTR($temp_Inbound_String$+"  
 ", 10)))   
   Action 12  goto   start of guide label   


The Filter Guide would be a start label and the filter to do the split.

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, Lj
Sent: Thursday, May 02, 2013 8:12 AM
To: arslist@ARSLIST.ORG
Subject: Re: Extracting substring from string and putting the value in 
different field

** 
Sanjay,
you are going to need something in the range of 11 filters...one of them that 
does a STRSTR to find the location of the , then one filter for each of the 
field1-10.  Put them in a filter guide.  Fire the filter that finds the , then, 
if that int is > 0 use SUBSTR to grab the first value, storing it in field 1 
and removing that value from your temp field, then call your find the , filter, 
rinse and repeat untill no , is found.  If no , is found, exit the guide.

-Original Message-
On Thu, May 2, 2013 at 7:06 AM, kanhu mohapatra  wrote:
** 
Hello Pierson,
Thanks for your post.But how do I get the start and end position of the 
incident as the string is dynamic and start and end position cannot be hard 
coded. See below.

I have just outlined the requirement. The string which contain incident has 
dynamic values and maximum contains 10 ids.Where I have to count the no. 
incidents and then put individual incident to different field.
Example :
Temp_field = string
string ="INC000123, INC000456, INC000789, INC05" or "INC000123, INC000456, 
INC000789, INC05,"INC000121, INC000453, INC000781, INC02"
field1="INC000123"
.
.
.
Field4="INC000121"
Field5="NULL"
.
.
Field10="NULL"

or 
field1="INC000123"
.
.
Field8="INC02"
Field9="NULL'
Field10="NULL"

what I have to do is to count no. of ids and then put individual ids to fields. 
The value of sting cannot be hard coded. it is always dynamic but the limit is 
10 records.
Basically what I want to do is to parse the string and extract the sub-string 
whenever it find the delimiter "," and then put the values to fields.
Hope you have understood my requirement.And expect more suggestion from 
Lister's.
Again,thanking in advance for all suggestion and help.

Regards,
Sanjay

-Original Message-
On Thu, May 2, 2013 at 6:11 PM, Pierson, Shawn wrote:
So you will always have four Incidents that you have to parse to pass to four 
specific fields?  If so, you can do four different Set Fields on the same 
AL/Filter with different SUBSTRING values pulling each Incident out based on 
the start and stop values of the SUBSTRING function on the TMP_field.  If it's 
a one to many type of list, then I wouldn't do that, nor would I write them to 
hardcoded fields.  In that case it gets more complicated, but it's still easily 
doable.

Thanks,

Shawn Pierson
Remedy Developer | Energy Transfer


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of sanjay
Sent: Thursday, May 02, 2013 7:35 AM
To: arslist@ARSLIST.ORG
Subject: Extracting substring from string and putting the value in different 
field

Hello Lister's,

We have a requirement. Where we have a string which contains  incident id's 
separated by ",". And my requirement is to extract the individual incident from 
the string and put the value to separate field.

Example of the above requirement
==

Input
==
TMP_field ="INC000123, INC000456, INC000789, INC05"

Output
===
Felid1 = INC000123
Felid2 = INC000456
Felid3 = INC000789
Felid4 = INC05

and my question is how do I accomplish the above task. Please help me out to 
accomplish the above requirement.

Many thanks for all your suggestion and help in advance.

Regards,
Sanjay.






--
View this message in context: 
http://ars-action-request-system.1093659.n2.nabble.com/Extracting-substring-from-string-and-putting-the-value-in-different-field-tp7588518.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

___

Re: Filter - Webservice

[Brittain, Mark]

Does another filter which fires before this one set field2=No? If so maybe the 
response to web service call is modifying the record, workflow sets field2 to 
No and the cycle starts over when filter A fires again.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Govind M
Sent: Thursday, May 02, 2013 7:51 AM
To: arslist@ARSLIST.ORG
Subject: Filter - Webservice

**
I have been looking into one scenario to reproduce in test env but I just 
confused more on this. It is like I have a filter with below syntax,

Filter name  : Filter A
Filter runif:  field1 = abdc AND field2 = No
Actions :  Set field  -> field 2 = Yes
   Set field   -> Trigger 3rd party webservice.

After firing the filter A for first time, field2 was set to the value "Yes" and 
triggered the wbs request to a middle ware app for a record.  After few 
minutes, the same request has been triggered thrice with the intervals of 
milliseconds which make me to think, after the value change in Runif field2, is 
it possible to trigger the filter again? :( From the user tool wise, there is 
no track of changes in the record and we don't have logs as well. I suspect 
this can't be by user action, since it of milliseconds interval.

Does any come across in ARS 7.1 patch 8 in solaris box.?  Any solutions/ ideas 
are much appreciated to reproduce/resolve.

Regards,
Govind

Please do not print this email unless it is absolutely necessary.

The information contained in this electronic message and any attachments to 
this message are intended for the exclusive use of the addressee(s) and may 
contain proprietary, confidential or privileged information. If you are not the 
intended recipient, you should not disseminate, distribute or copy this e-mail. 
Please notify the sender immediately and destroy all copies of this message and 
any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient should 
check this email and any attachments for the presence of viruses. The company 
accepts no liability for any damage caused by any virus transmitted by this 
email.

www.wipro.com
_ARSlist: "Where the Answers Are" and have been for 20 years_


This e-mail is the property of NaviSite, Inc. It is intended only for the 
person or entity to which it is addressed and may contain information that is 
privileged, confidential, or otherwise protected from disclosure. Distribution 
or copying of this e-mail, or the information contained herein, to anyone other 
than the intended recipient is prohibited.

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

Re: ARERR 8755 error message for ARSYS.ARF.WEBSERVICE

[Grooms, Frederick W]

Are you running ARS as non-root?  

When the startup fails is it when running ./arsystem start  (from your bin 
directory) or when starting from the server init ?

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Govind M
Sent: Thursday, May 02, 2013 7:11 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARERR 8755 error message for ARSYS.ARF.WEBSERVICE

** 
Apart from /bin in LD_LIBRARY_PATH, I have found 
only one path updated for java: /usr/java/jre/lib/sparc/client. I am not sure 
after installation, is it updated or needs to be updated correctly. Can you pls 
guide me what to look out in CLASSPATH.

Yes Joe, I have checked by running the plugin start up command thru command 
line separately. It brought up the Webservice and other plugins as well ☺.   
The problem happens when I get HPI library error while restarting it.


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza
Sent: Thursday, April 11, 2013 7:28 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARERR 8755 error message for ARSYS.ARF.WEBSERVICE

** 
Apart from your class path examine the plugin startup command in the armonitor 
file. Try to start it from the command line and see what is the error you get, 
assuming for some reason it has not started.

Joe


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Ali A. Musa
Sent: Wednesday, April 10, 2013 4:23 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARERR 8755 error message for ARSYS.ARF.WEBSERVICE

Check the CLASSPATH


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Govind M
Sent: Wednesday, April 10, 2013 10:44 AM
To: arslist@ARSLIST.ORG
Subject: ARERR 8755 error message for ARSYS.ARF.WEBSERVICE

** 
Hi All,

Request your expertise advice for the below error.

ARERR 8755 error message for ARSYS.ARF.WEBSERVICE

What happened is, upgrading patch 9 in ARS 7.1 in unix environment had failed 
to set the environment path of /bin in 
LD_LIBRARY_PATH and java path which we provided during installation. When we 
restart the ARSystem, it failed to load Java and webservice plugins and gives 
HPI library error. We have a case  opened with BMC. As per their suggestion, 
after exporting /bin in LD_LIBRARY_PATH, tried 
separately initiating  Arplugin process, once arsystem is up which loaded Web 
service and other plugins properly. For this activity, we have commented the 
arplugin line item in armonitor.conf. 

But can’t able to figure out, why we  are getting these ARERROR 8755 and HPI 
library error only when we start the ars with uncommenting arplugin line item 
in armontior.conf.  What is the cause for these errors which is not appearing 
on separate initialization of arplugin..?

Thanks,
Govind




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

Re: AR System ODBC driver

[Grooms, Frederick W]

I think Stuart had a typo ...   
Since the ODBC uses the Remedy application server, if you can't see something 
in Remedy you can't see it using the ODBC driver.

One way around the join limitation is to use sub-reports in Crystal.  You can 
then have multiple form(s) data in the report

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Schon, Stuart
Sent: Wednesday, May 01, 2013 6:13 PM
To: arslist@ARSLIST.ORG
Subject: Re: AR System ODBC driver

The main limitation is that you can perform joins in the query using the
OBDC driver. If you need to join tables together you need to build them
in Remedy first and then use in your report.

The other restriction/feature is that the driver uses the Remedy data
security model - so if you can't see something using Remedy you can see
it in a report.

Stuart Schon
Service Desk Systems - Manager

Fujitsu Australia Limited

Please consider the environment before printing this email

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury
Sent: Thursday, 2 May 2013 6:37 AM
To: arslist@ARSLIST.ORG
Subject: Re: AR System ODBC driver

Thanks Fred. I'll check it out.

Sent from my iPhone

On May 1, 2013, at 4:36 PM, "Grooms, Frederick W"
 wrote:

> The Integration Guide document (Page 212) lists some issues and 
> considerations
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury
> Sent: Wednesday, May 01, 2013 2:25 PM
> To: arslist@ARSLIST.ORG
> Subject: AR System ODBC driver
>
> **
> Version: 7.6.04
>
> All,
> Does anyone know or have a document about what capabilities are
available for the AR System ODBC driver? I have a user who is trying to
use Crystal Reports by way of the driver and some features aren't
working.
>
>
> --
> Tauf Chowdhury

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

Re: IE 10 on Windows 8

[Leonard Nelson]

Thanks very much. Disabled it and it worked well.

Leo

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Hennigan, Sandra
Sent: Thursday, May 2, 2013 8:49 AM
To: arslist@ARSLIST.ORG
Subject: Re: IE 10 on Windows 8

**
Are you using the IE Compatible mode?

Thank you,

Sandra Hennigan
Remedy Developer

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Leonard Nelson
Sent: Thursday, May 02, 2013 8:48 AM
To: arslist@ARSLIST.ORG
Subject: IE 10 on Windows 8

**
Hello All,

Is anyone experiencing browser issues when attempting to use any of the ITSM 8 
modules with IE10 on Windows 8?

Leo

_ARSlist: "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"

Re: Exporting data from CLM -> Non-CLM

[Longwing, Lj]

how about RRRChive?


On Thu, May 2, 2013 at 6:48 AM, Jared Dean  wrote:

> **
> Thanks for the reply John. Unfortunately, DSO is not an option due to the
> way our infrastructure is setup.
>
> -Jared
>
>
>
> On Thu, May 2, 2013 at 8:43 AM, Roger J  wrote:
>
>> **
>> The easiest way to accomplish this transfer is by using DSO.
>>  -Original Message-
>> From: Jared Dean 
>> To: arslist 
>> Sent: Thu, May 2, 2013 8:37 am
>> Subject: Exporting data from CLM -> Non-CLM
>>
>>  **
>> Hello All,
>>
>> We are currently running CLM 3.0 which contains additional cloud data
>> that is not present in Atrium 8.0. We initially tried to use the CMDBDriver
>> utility, but since its version specific we have been unsuccessful.
>>  The issue we are having is that the source Atrium has certain CMDB
>> extensions that do not (and should not) exist on the target Atrium.
>> Specifically, the CLM Cloud Extensions are installed on the source Atrium.
>> When we run an import using the *CMDBDriver utility* on the stand-alone
>> Atrium 8, we get import errors (120004) complaining that attributes in the
>> XML import files does not exist in the target dataset. We know what the
>> issue is, but are unsure how to solve it. Essentially, we want to export a
>> subset data from CLM 3.0 Atrium. For a given dataset, we want to export all
>> classes & attributes that exist in the BMC.CORE, BMC.AM, and possibly
>> BMC.FED namespaces. Even when specifying a specific namespace to export,
>> the resulting XML files still contain attributes that are provided by other
>> namespaces. This subsequently causes imports to fail, since there is
>> "extra" data.
>>
>> Thanks for the help!
>> Jared
>>  _ARSlist: "Where the Answers Are" and have been for 20 years_
>>  _ARSlist: "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"

Re: Extracting substring from string and putting the value in different field

[Longwing, Lj]

Sanjay,
you are going to need something in the range of 11 filters...one of them
that does a STRSTR to find the location of the , then one filter for each
of the field1-10.  Put them in a filter guide.  Fire the filter that finds
the , then, if that int is > 0 use SUBSTR to grab the first value, storing
it in field 1 and removing that value from your temp field, then call your
find the , filter, rinse and repeat untill no , is found.  If no , is
found, exit the guide.


On Thu, May 2, 2013 at 7:06 AM, kanhu mohapatra wrote:

> **
> Hello Pierson,
>
> Thanks for your post.But how do I get the start and end position of the
> incident as the string is dynamic and start and end position cannot be hard
> coded. See below.
>
> I have just outlined the requirement. The string which contain incident
> has dynamic values and maximum contains 10 ids.Where I have to count the
> no. incidents and then put individual incident to different field.
>
> Example :
> Temp_field = string
> string ="INC000123, INC000456, INC000789, INC05" or "INC000123,
> INC000456, INC000789, INC05,"INC000121, INC000453, INC000781, INC02"
>
> field1="INC000123"
> .
> .
> .
> Field4="INC000121"
> Field5="NULL"
> .
> .
> Field10="NULL"
>
> or
> field1="INC000123"
> .
> .
> Field8="INC02"
> Field9="NULL'
> Field10="NULL"
>
> what I have to do is to count no. of ids and then put individual ids to
> fields. The value of sting cannot be hard coded. it is always dynamic but
> the limit is 10 records.
>
> Basically what I want to do is to parse the string and extract the
> sub-string whenever it find the delimiter "," and then put the values to
> fields.
>
> Hope you have understood my requirement.And expect more suggestion from
> Lister's.
>
> Again,thanking in advance for all suggestion and help.
>
> Regards,
> Sanjay
>
>
> On Thu, May 2, 2013 at 6:11 PM, Pierson, Shawn <
> shawn.pier...@energytransfer.com> wrote:
>
>> So you will always have four Incidents that you have to parse to pass to
>> four specific fields?  If so, you can do four different Set Fields on the
>> same AL/Filter with different SUBSTRING values pulling each Incident out
>> based on the start and stop values of the SUBSTRING function on the
>> TMP_field.  If it's a one to many type of list, then I wouldn't do that,
>> nor would I write them to hardcoded fields.  In that case it gets more
>> complicated, but it's still easily doable.
>>
>> Thanks,
>>
>> Shawn Pierson
>> Remedy Developer | Energy Transfer
>>
>>
>> -Original Message-
>> From: Action Request System discussion list(ARSList) [mailto:
>> arslist@ARSLIST.ORG] On Behalf Of sanjay
>> Sent: Thursday, May 02, 2013 7:35 AM
>> To: arslist@ARSLIST.ORG
>> Subject: Extracting substring from string and putting the value in
>> different field
>>
>> Hello Lister's,
>>
>> We have a requirement. Where we have a string which contains  incident
>> id's separated by ",". And my requirement is to extract the individual
>> incident from the string and put the value to separate field.
>>
>> Example of the above requirement
>> ==
>>
>> Input
>> ==
>> TMP_field ="INC000123, INC000456, INC000789, INC05"
>>
>> Output
>> ===
>> Felid1 = INC000123
>> Felid2 = INC000456
>> Felid3 = INC000789
>> Felid4 = INC05
>>
>> and my question is how do I accomplish the above task. Please help me out
>> to accomplish the above requirement.
>>
>> Many thanks for all your suggestion and help in advance.
>>
>> Regards,
>> Sanjay.
>>
>>
>>
>>
>>
>>
>> --
>> View this message in context:
>> http://ars-action-request-system.1093659.n2.nabble.com/Extracting-substring-from-string-and-putting-the-value-in-different-field-tp7588518.html
>> Sent from the ARS (Action Request System) mailing list archive at
>> Nabble.com.
>>
>>
>> ___
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the
>> Answers Are, and have been for 20 years"
>>
>> Private and confidential as detailed here:
>> http://www.energytransfer.com/mail_disclaimer.aspx .  If you cannot
>> access the link, please e-mail sender.
>>
>>
>> ___
>> 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"

Re: Extracting substring from string and putting the value in different field

[kanhu mohapatra]

Hello Pierson,

Thanks for your post.But how do I get the start and end position of the
incident as the string is dynamic and start and end position cannot be hard
coded. See below.

I have just outlined the requirement. The string which contain incident has
dynamic values and maximum contains 10 ids.Where I have to count the no.
incidents and then put individual incident to different field.

Example :
Temp_field = string
string ="INC000123, INC000456, INC000789, INC05" or "INC000123,
INC000456, INC000789, INC05,"INC000121, INC000453, INC000781, INC02"

field1="INC000123"
.
.
.
Field4="INC000121"
Field5="NULL"
.
.
Field10="NULL"

or
field1="INC000123"
.
.
Field8="INC02"
Field9="NULL'
Field10="NULL"

what I have to do is to count no. of ids and then put individual ids to
fields. The value of sting cannot be hard coded. it is always dynamic but
the limit is 10 records.

Basically what I want to do is to parse the string and extract the
sub-string whenever it find the delimiter "," and then put the values to
fields.

Hope you have understood my requirement.And expect more suggestion from
Lister's.

Again,thanking in advance for all suggestion and help.

Regards,
Sanjay


On Thu, May 2, 2013 at 6:11 PM, Pierson, Shawn <
shawn.pier...@energytransfer.com> wrote:

> So you will always have four Incidents that you have to parse to pass to
> four specific fields?  If so, you can do four different Set Fields on the
> same AL/Filter with different SUBSTRING values pulling each Incident out
> based on the start and stop values of the SUBSTRING function on the
> TMP_field.  If it's a one to many type of list, then I wouldn't do that,
> nor would I write them to hardcoded fields.  In that case it gets more
> complicated, but it's still easily doable.
>
> Thanks,
>
> Shawn Pierson
> Remedy Developer | Energy Transfer
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] On Behalf Of sanjay
> Sent: Thursday, May 02, 2013 7:35 AM
> To: arslist@ARSLIST.ORG
> Subject: Extracting substring from string and putting the value in
> different field
>
> Hello Lister's,
>
> We have a requirement. Where we have a string which contains  incident
> id's separated by ",". And my requirement is to extract the individual
> incident from the string and put the value to separate field.
>
> Example of the above requirement
> ==
>
> Input
> ==
> TMP_field ="INC000123, INC000456, INC000789, INC05"
>
> Output
> ===
> Felid1 = INC000123
> Felid2 = INC000456
> Felid3 = INC000789
> Felid4 = INC05
>
> and my question is how do I accomplish the above task. Please help me out
> to accomplish the above requirement.
>
> Many thanks for all your suggestion and help in advance.
>
> Regards,
> Sanjay.
>
>
>
>
>
>
> --
> View this message in context:
> http://ars-action-request-system.1093659.n2.nabble.com/Extracting-substring-from-string-and-putting-the-value-in-different-field-tp7588518.html
> Sent from the ARS (Action Request System) mailing list archive at
> Nabble.com.
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the
> Answers Are, and have been for 20 years"
>
> Private and confidential as detailed here:
> http://www.energytransfer.com/mail_disclaimer.aspx .  If you cannot
> access the link, please e-mail sender.
>
>
> ___
> 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"

Re: Filter - Webservice

[Longwing, Lj]

is Field2 'real' or is it display only?


On Thu, May 2, 2013 at 5:51 AM, Govind M  wrote:

> **
>
> I have been looking into one scenario to reproduce in test env but I just
> confused more on this. It is like I have a filter with below syntax, 
>
> ** **
>
> Filter name  : Filter A
>
> Filter runif:  field1 = abdc AND field2 = No
>
> Actions :  Set field  -> field 2 = Yes
>
>Set field   -> Trigger 3rd party webservice.***
> *
>
> ** **
>
> After firing the filter A for first time, field2 was set to the value
> “Yes” and triggered the wbs request to a middle ware app for a record.
>  After few minutes, the same request has been triggered thrice with the
> intervals of milliseconds which make me to think, after the value change in
> Runif field2, is it possible to trigger the filter again? L From the user
> tool wise, there is no track of changes in the record and we don’t have
> logs as well. I suspect this can’t be by user action, since it of
> milliseconds interval.
>
> ** **
>
> Does any come across in ARS 7.1 patch 8 in solaris box.?  Any solutions/
> ideas are much appreciated to reproduce/resolve.
>
> ** **
>
> Regards,
>
> Govind
>
> * Please do not print this email unless it is absolutely necessary. *
>
> The information contained in this electronic message and any attachments
> to this message are intended for the exclusive use of the addressee(s) and
> may contain proprietary, confidential or privileged information. If you are
> not the intended recipient, you should not disseminate, distribute or copy
> this e-mail. Please notify the sender immediately and destroy all copies of
> this message and any attachments.
>
> WARNING: Computer viruses can be transmitted via email. The recipient
> should check this email and any attachments for the presence of viruses.
> The company accepts no liability for any damage caused by any virus
> transmitted by this email.
>
> www.wipro.com
>  _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"

Re: IE 10 on Windows 8

[Hennigan, Sandra]

Are you using the IE Compatible mode?

Thank you,

Sandra Hennigan
Remedy Developer

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Leonard Nelson
Sent: Thursday, May 02, 2013 8:48 AM
To: arslist@ARSLIST.ORG
Subject: IE 10 on Windows 8

**
Hello All,

Is anyone experiencing browser issues when attempting to use any of the ITSM 8 
modules with IE10 on Windows 8?

Leo

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

IE 10 on Windows 8

[Leonard Nelson]

Hello All,

Is anyone experiencing browser issues when attempting to use any of the ITSM 8 
modules with IE10 on Windows 8?

Leo


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

Re: Exporting data from CLM -> Non-CLM

[Jared Dean]

Thanks for the reply John. Unfortunately, DSO is not an option due to the
way our infrastructure is setup.

-Jared


On Thu, May 2, 2013 at 8:43 AM, Roger J  wrote:

> **
> The easiest way to accomplish this transfer is by using DSO.
>  -Original Message-
> From: Jared Dean 
> To: arslist 
> Sent: Thu, May 2, 2013 8:37 am
> Subject: Exporting data from CLM -> Non-CLM
>
>  **
> Hello All,
>
> We are currently running CLM 3.0 which contains additional cloud data that
> is not present in Atrium 8.0. We initially tried to use the CMDBDriver
> utility, but since its version specific we have been unsuccessful.
>  The issue we are having is that the source Atrium has certain CMDB
> extensions that do not (and should not) exist on the target Atrium.
> Specifically, the CLM Cloud Extensions are installed on the source Atrium.
> When we run an import using the *CMDBDriver utility* on the stand-alone
> Atrium 8, we get import errors (120004) complaining that attributes in the
> XML import files does not exist in the target dataset. We know what the
> issue is, but are unsure how to solve it. Essentially, we want to export a
> subset data from CLM 3.0 Atrium. For a given dataset, we want to export all
> classes & attributes that exist in the BMC.CORE, BMC.AM, and possibly
> BMC.FED namespaces. Even when specifying a specific namespace to export,
> the resulting XML files still contain attributes that are provided by other
> namespaces. This subsequently causes imports to fail, since there is
> "extra" data.
>
> Thanks for the help!
> Jared
>  _ARSlist: "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"

Re: Exporting data from CLM -> Non-CLM

[Roger J]

The easiest way to accomplish this transfer is by using DSO.


-Original Message-
From: Jared Dean 
To: arslist 
Sent: Thu, May 2, 2013 8:37 am
Subject: Exporting data from CLM -> Non-CLM


**
Hello All,
 
We are currentlyrunning CLM 3.0 which contains additional cloud data that is 
not present inAtrium 8.0. We initially tried to use the CMDBDriver utility, but 
since its version specific we have been unsuccessful. 

The issue we arehaving is that the source Atrium has certain CMDB extensions 
that do not (andshould not) exist on the target Atrium. Specifically, the CLM 
Cloud Extensionsare installed on the source Atrium. When we run an import using 
the CMDBDriver utility on the stand-aloneAtrium 8, we get import errors 
(120004) complaining that attributes in the XMLimport files does not exist in 
the target dataset. We know what the issue is,but are unsure how to solve it. 
Essentially, we want to export a subset datafrom CLM 3.0 Atrium. For a given 
dataset, we want to export all classes &attributes that exist in the BMC.CORE, 
BMC.AM, and possibly BMC.FED namespaces.Even when specifying a specific 
namespace to export, the resulting XML filesstill contain attributes that are 
provided by other namespaces. Thissubsequently causes imports to fail, since 
there is "extra" data.
 
Thanks for thehelp!
Jared 

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

Re: Extracting substring from string and putting the value in different field

[Pierson, Shawn]

So you will always have four Incidents that you have to parse to pass to four 
specific fields?  If so, you can do four different Set Fields on the same 
AL/Filter with different SUBSTRING values pulling each Incident out based on 
the start and stop values of the SUBSTRING function on the TMP_field.  If it's 
a one to many type of list, then I wouldn't do that, nor would I write them to 
hardcoded fields.  In that case it gets more complicated, but it's still easily 
doable.

Thanks,

Shawn Pierson
Remedy Developer | Energy Transfer


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of sanjay
Sent: Thursday, May 02, 2013 7:35 AM
To: arslist@ARSLIST.ORG
Subject: Extracting substring from string and putting the value in different 
field

Hello Lister's,

We have a requirement. Where we have a string which contains  incident id's 
separated by ",". And my requirement is to extract the individual incident from 
the string and put the value to separate field.

Example of the above requirement
==

Input
==
TMP_field ="INC000123, INC000456, INC000789, INC05"

Output
===
Felid1 = INC000123
Felid2 = INC000456
Felid3 = INC000789
Felid4 = INC05

and my question is how do I accomplish the above task. Please help me out to 
accomplish the above requirement.

Many thanks for all your suggestion and help in advance.

Regards,
Sanjay.






--
View this message in context: 
http://ars-action-request-system.1093659.n2.nabble.com/Extracting-substring-from-string-and-putting-the-value-in-different-field-tp7588518.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

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

Private and confidential as detailed here: 
http://www.energytransfer.com/mail_disclaimer.aspx .  If you cannot access the 
link, please e-mail sender.

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

Exporting data from CLM -> Non-CLM

[Jared Dean]

Hello All,



We are currently running CLM 3.0 which contains additional cloud data that
is not present in Atrium 8.0. We initially tried to use the CMDBDriver
utility, but since its version specific we have been unsuccessful.

The issue we are having is that the source Atrium has certain CMDB
extensions that do not (and should not) exist on the target Atrium.
Specifically, the CLM Cloud Extensions are installed on the source Atrium.
When we run an import using the *CMDBDriver utility* on the stand-alone
Atrium 8, we get import errors (120004) complaining that attributes in the
XML import files does not exist in the target dataset. We know what the
issue is, but are unsure how to solve it. Essentially, we want to export a
subset data from CLM 3.0 Atrium. For a given dataset, we want to export all
classes & attributes that exist in the BMC.CORE, BMC.AM, and possibly
BMC.FED namespaces. Even when specifying a specific namespace to export,
the resulting XML files still contain attributes that are provided by other
namespaces. This subsequently causes imports to fail, since there is
"extra" data.



Thanks for the help!

Jared

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

Extracting substring from string and putting the value in different field

[sanjay]

Hello Lister's,

We have a requirement. Where we have a string which contains  incident id's
separated by ",". And my requirement is to extract the individual incident
from the string and put the value to separate field.

Example of the above requirement
==

Input
==
TMP_field ="INC000123, INC000456, INC000789, INC05" 

Output 
===
Felid1 = INC000123 
Felid2 = INC000456 
Felid3 = INC000789 
Felid4 = INC05 

and my question is how do I accomplish the above task. Please help me out to
accomplish the above requirement.

Many thanks for all your suggestion and help in advance.

Regards,
Sanjay.






--
View this message in context: 
http://ars-action-request-system.1093659.n2.nabble.com/Extracting-substring-from-string-and-putting-the-value-in-different-field-tp7588518.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

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

Re: ARERR 8755 error message for ARSYS.ARF.WEBSERVICE

[Govind M]

Apart from /bin in LD_LIBRARY_PATH, I have found 
only one path updated for java: /usr/java/jre/lib/sparc/client. I am not sure 
after installation, is it updated or needs to be updated correctly. Can you pls 
guide me what to look out in CLASSPATH.

Yes Joe, I have checked by running the plugin start up command thru command 
line separately. It brought up the Webservice and other plugins as well :).   
The problem happens when I get HPI library error while restarting it.


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza
Sent: Thursday, April 11, 2013 7:28 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARERR 8755 error message for ARSYS.ARF.WEBSERVICE

**

Apart from your class path examine the plugin startup command in the armonitor 
file. Try to start it from the command line and see what is the error you get, 
assuming for some reason it has not started.



Joe


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Ali A. Musa
Sent: Wednesday, April 10, 2013 4:23 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARERR 8755 error message for ARSYS.ARF.WEBSERVICE

Check the CLASSPATH

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Govind M
Sent: Wednesday, April 10, 2013 10:44 AM
To: arslist@ARSLIST.ORG
Subject: ARERR 8755 error message for ARSYS.ARF.WEBSERVICE

**
Hi All,

Request your expertise advice for the below error.

ARERR 8755 error message for ARSYS.ARF.WEBSERVICE

What happened is, upgrading patch 9 in ARS 7.1 in unix environment had failed 
to set the environment path of /bin in 
LD_LIBRARY_PATH and java path which we provided during installation. When we 
restart the ARSystem, it failed to load Java and webservice plugins and gives 
HPI library error. We have a case  opened with BMC. As per their suggestion, 
after exporting /bin in LD_LIBRARY_PATH, tried 
separately initiating  Arplugin process, once arsystem is up which loaded Web 
service and other plugins properly. For this activity, we have commented the 
arplugin line item in armonitor.conf.

But can't able to figure out, why we  are getting these ARERROR 8755 and HPI 
library error only when we start the ars with uncommenting arplugin line item 
in armontior.conf.  What is the cause for these errors which is not appearing 
on separate initialization of arplugin..?

Thanks,
Govind

Please do not print this email unless it is absolutely necessary.

The information contained in this electronic message and any attachments to 
this message are intended for the exclusive use of the addressee(s) and may 
contain proprietary, confidential or privileged information. If you are not the 
intended recipient, you should not disseminate, distribute or copy this e-mail. 
Please notify the sender immediately and destroy all copies of this message and 
any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient should 
check this email and any attachments for the presence of viruses. The company 
accepts no liability for any damage caused by any virus transmitted by this 
email.

www.wipro.com
_ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where 
the Answers Are" and have been for 20 years_

Please do not print this email unless it is absolutely necessary.

The information contained in this electronic message and any attachments to 
this message are intended for the exclusive use of the addressee(s) and may 
contain proprietary, confidential or privileged information. If you are not the 
intended recipient, you should not disseminate, distribute or copy this e-mail. 
Please notify the sender immediately and destroy all copies of this message and 
any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient should 
check this email and any attachments for the presence of viruses. The company 
accepts no liability for any damage caused by any virus transmitted by this 
email.

www.wipro.com

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

Filter - Webservice

[Govind M]

I have been looking into one scenario to reproduce in test env but I just 
confused more on this. It is like I have a filter with below syntax,

Filter name  : Filter A
Filter runif:  field1 = abdc AND field2 = No
Actions :  Set field  -> field 2 = Yes
   Set field   -> Trigger 3rd party webservice.

After firing the filter A for first time, field2 was set to the value "Yes" and 
triggered the wbs request to a middle ware app for a record.  After few 
minutes, the same request has been triggered thrice with the intervals of 
milliseconds which make me to think, after the value change in Runif field2, is 
it possible to trigger the filter again? :( From the user tool wise, there is 
no track of changes in the record and we don't have logs as well. I suspect 
this can't be by user action, since it of milliseconds interval.

Does any come across in ARS 7.1 patch 8 in solaris box.?  Any solutions/ ideas 
are much appreciated to reproduce/resolve.

Regards,
Govind

Please do not print this email unless it is absolutely necessary.

The information contained in this electronic message and any attachments to 
this message are intended for the exclusive use of the addressee(s) and may 
contain proprietary, confidential or privileged information. If you are not the 
intended recipient, you should not disseminate, distribute or copy this e-mail. 
Please notify the sender immediately and destroy all copies of this message and 
any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient should 
check this email and any attachments for the presence of viruses. The company 
accepts no liability for any damage caused by any virus transmitted by this 
email.

www.wipro.com

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

Re: Relate a change to a change error

[trupti.thorave]

**


  
  
Hi,


For Oracle Database following information may help you:-

1>Character with a maximum length of 4000 or fewer bytes =
varchar for DB2 & Oracle DB

2>Character with an unlimited length or a maximum length of more
than 4000 bytes=clob  for Db2 & Oracle DB

3>If you set the Input Length to more than the maximum for
varchar, the character field is created as a clob database 

table column and storage is allocated in blocks that average between
1K to 2K bytes (depending on the database). A full 

block is allocated for the first byte. When that block is filled
with the field contents, another full block is 

allocated. 

4>CLOB (character large object) data is stored:

In Row:-
If the length of the character data, including the LOB locator, is
less than or equal to 4000 bytes, store the data "in 
row."
If the length of the character data, including the LOB locator, is
greater than 4000 bytes, store the LOB locator "in 
row" and the data "out row."



you expect to store unusually large amounts of data in
  CLOBs, set this option to TRUE before installing AR System
  applications
  so that all database tables for applications are created in-row.

In-row CLOBs can degrade CPU performance. 

If a field contains more than 4000 characters, the CLOB is stored
out
row no matter which value is specified for this server setting.

Out Row Store the data "out row." Out-row CLOBs can cause the
database to grow rapidly. 


Regards,
Trupti Thorave














On 4/30/2013 8:24 PM, Brittain, Mark wrote:
**
  
  
  
  
  
HI All,
 
I have an interesting situation that was
  reported to me. If a user using an existing Change selects
  Create Related Request >>  Infrastructure Change
  sometimes it works and sometimes it does not. Specifically the
  new Change is displayed and if there is a small amount of data
  in the Notes/Detailed Description, the new Change is saved. If
  the Notes/Detailed Description is like 4,000 characters, on
  save the user gets an error
  “Required field cannot be blank.: Request ID (ARERR 326)”
 
I would think if the issue was the size of
  the Notes was too big, it would generate max limit. Has anyone
  encountered this issue?
 
ITSM 7.6.04 SP3
 
Mark 
 
Mark Brittain
Remedy Developer
ITILv3 Foundation
NaviSite –
A Time Warner Cable Company
mbritt...@navisite.com
Office: 315-453-2912 x5335
Mobile: 315-882.5360

 
  
  
  
  This e-mail is the
property of NaviSite, Inc. It is intended only for the person or
entity to which it is addressed and may contain information that
is privileged, confidential, or otherwise protected from
disclosure. Distribution or copying of this e-mail, or the
information contained herein, to anyone other than the intended
recipient is prohibited.
  
  _ARSlist: "Where the Answers Are" and have been for 20 years_


  

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

Re: Remedy 8.1.00 V Setup

[Sandeep Pandey]

Hi Hari,

Looking in terms of financial, you can go for Windows 2008 standard OS
rather than going on enterprise. It will save you lot and serve your
purpose. And there would be no performance issue as well. Remaining
specification looks good.

-- 
Sandeep Pandey
Remedy Developer


On Thu, May 2, 2013 at 5:22 AM, Joe D'Souza  wrote:

> **
>
> Looking at it in a financial perspective however, I would think it’s a
> whole lot better to give that additional CPU and RAM as recommended, than
> the installation to take twice or trice as long, especially if the resource
> performing that installation costs around 100/hr or over. If that install
> takes over 4 to 6 hours and all that the resource is doing at that time is
> overseeing the installation, that’s about 600 bucks right there at the
> minimum.
>
> ** **
>
> And considering its POC, assuming that there might be possibilities of
> wiping and reconfiguring and spending a few more hours on rebuilding a
> slightly different configuration – do the math. Its way cheaper to double
> up on the hardware upfront than to go skimpy on it.
>
> ** **
>
> Sometimes it is easy to forget these hidden costs.
>
> ** **
>
> I would stick with the configuration you started out with if that has
> already been approved, instead of committing that lesser than 12 GB or 2
> core CPU’s might work just as fine.
>
> ** **
>
> Just my two cents.
>
> ** **
>
> Joe
>
> ** **
>  --
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *laurent matheo
> *Sent:* Wednesday, May 01, 2013 3:42 PM
> *To:* arslist@ARSLIST.ORG
>
> *Subject:* Re: Remedy 8.1.00 V Setup
> 
>
>  ** **
>
> Hi :)
>
>
> So you just have ARS and CMDB? No ITSM, SRM, SLM?
> I guess that on the same VM you'll also have a mid-tier and the database?
> Will you install the web services Atrium Core and a Tomcat for it?
>
>
> CPU: 4 core indeed, 2 would be the limit.
>
> Processing speed: I would say it doesn't matter that much.
> If it's a poc the CPU processing speed isn't really a problem. I got a
> laptop which is an octocore 2.30 Ghz but which is overall more powerfull /
> faster that most of my customers dev / staging environment.
>
> RAM: seems a bit high if you have only ARS+CMDB+Integrator.
> I made a 8.1 VM with 12 GB ram but with all the stack (ARS, CMDB, ITSM,
> SRM, SLM, Integrator server, Openfire, tomcat for mid-tier, tomcat for
> Atrium Core webservices, sql server) and right now after one day use I'm
> using 9 GB with several Firefox and Chrome opened, developer studio and
> Data Import Tool on the VM.
> I guess in your case you could go to 10 if you don't install the Tomcat
> for the Atrium Webservices. Or even 8 GB but I wouldn't be that comfortable
> here. Right now with web browsers closed and dev studio / data import
> closed I'm using 7.74 GB RAM (so with all stack and Tomcat for Atrium WS
> using nearly 500 MB).
>
> HDD:
> It seems a lot. I'm using 66 GB used right now but once again, I have all
> the stack, online help, Analytics and BO XI 4, Dashboards and so on.
>
>
> My advice is to limit the SQL Server memory setting at 4 GB.
> I would go for Java 1.7 x64 and Tomcat 7 x64 (or use the Tomcat from
> installer).
> As for OS, are those the 2008 or 2008 R2 versions? I always work with R2
> and they work fine (with latest SP on both).
>
> Then more importantly it depends what you want to do with this POC VM.
> Just a demo "here is what is the CMDB" or big reconciliations, a lot of
> data, interfaces and so on?
>
> Anwyay, a POC is there to show off to customers most of the time. So if
> you can take a cool hardware rig with 12 GB RAM, a very fast HDD (or SSD)
> and 4 CPU, do it.
>
>
> On 01 May, 2013,at 09:14 PM, Hari Vishwakarma 
> wrote:
>
>  ** Hi,
>
> I am going to install Remedy 8.1.00 version for POC purpose.
> Can anyone suggest what per-requisites should I consider before starting
> the Remedy 8.1.00 version.
>
> Objective: To install Remedy 8.1.00 V
> Components of 8.1.00 V inculdes: AR Server, CMDB( Atrium Core &
> Integrator),No ITSM in consideration
> Environment: Windows
>
> Currently the planning in mind as per BMC recommendations are:
>
> Hardware Pr-requisites:
>
> Server type: VM
>
> Server details:
>
> 1. Processor type : 4 core CPU processor
> 2. Processing speed: >= 3 GHz( Can we consider less than this, if yes,
> what were its pros & cons)
> 3. RAM: 12 GB( Can we consider less than this as well, if yes, what were
> its pros & cons)
> 4. Hard disk space(HDD): 250 GB
>
> Software Pr-requisites:
>
> OS name: Windows 2008 Server Enterprise Edition(64-bit)
> Database: SQL Server 2008 Enterprise Edition(64-bit)
> JAVA : JAVA 1.6.X/JAVA 1.7.X( 64-bit)
> Tomcat: 6.0.X (64-bit)
>
> Please guide me in selecting the best options available with suggestions &
> let me know in case of any challenges involved.
>
> Also, please confirm if this ok to start the installation.
>
>
>
>
> Best

Re: Installation Error

[Sandeep Pandey]

Hi Abdul,

Is database remote? What is OS? Which Database?

check arerror log file as well.

-- 
Sandeep Pandey
Remedy Developer

On Thu, May 2, 2013 at 1:47 AM, laurent matheo  wrote:

> **
> You should check the "/ARSystem/arserver/db/arerror.log" file and the
> installation log file which is in the temp folder, usually something like
> "c:/users/administrator/appdata/local/temp/" folder.
> Perhaps the ARmonitor service already (still) exists?
>
> On 01 May, 2013,at 10:14 PM, Abdullah Baytops <
> abayt...@onefederalsolution.com> wrote:
>
> I had installed 7.6.04 on a server in our environment in which were using
> and today I decided to uninstall it from our app server and database
> server.  In then tried to reinstall it on our servers and all day I have
> been not able to install the server from the setup.exe files provided onto
> the existing DB (MS SQL Server) or App Server.  Is there something the DB
> may be maintaining or holding in a certain location since it was installed
> on the sever before.  When I run the installer we get 90% through the
> installation and it fails.  When I look at the DB it has been created but
> the services will not start.
>
> Any ideas would be great.
>
> V/R
> Abdul Baytops
>
> _ARSlist: "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"