Issue in Sending Mail in HTML format

[Nair, Rajesh IN BOM SISL]

Dear LIst,
I am facing a issue in sending mail from remedy system in HTML format..
I have copied the format in the Template form. Have created a form say XYZ 
which stores the exact name of the template. This in turn is set to the 
helpdesk form.
In the notfiy filter i have copied the template name in the Content field and 
have selected the fields which are present in the Helpdesk form and in the 
template.
OutpuT
System send the mail in the HTML format as desired but it is not using the 
Field iD .. say Case id goes NULL
I have used the variable name in the template in the format #$$Case ID$$#

Can anyone tell me where i am going worng  or what can be done.

Regards
Rajesh





___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Gurudev Ankam is out of the office.

[Gurudev Ankam]

I will be out of the office starting  11/12/2009 and will not return until
21/12/2009.

I have very minimum access to mails during my vacation. I will give you a
reply once I come back.

For Carphone Warehouse account please contact Suneel Pallamreddy (or)
Sujatha N Babu1.

For other TIM accounts please contact Krunal B Thanki (or) Prem K Padulkar.

For GDF 2009.6 Wave information please contact Sohail Syed.

All escalations should go to my manager  Pratibha Allamaraju @
'pratibh...@in.ibm.com'.


Thank you.

Regards,
Gurudev Ankam

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: CMDB mapping question: dependency vs. component

[Lyle Taylor]

OK.  I see what you're saying.  It does seem to list things the way you had 
them in your table implying that the destination depends on the source.  
Perhaps we were doing things completely backwards...  And that just further 
confuses the whole idea of what's the parent and what's the child, because 
which direction would you expect the arrow to go for a dependency, to the thing 
being depended on, or to the item that depends on it?

Concerning Components, I suppose it depends a bit on how you think of 
component.  While a system is architected of many "components", I'm not sure 
that they're components in the same sense as the types of things they're 
listing in their examples.  The components they list here seem to either be 
logical (conceptual) components of a logical system (an Application System is a 
component of an Application Infrastructure) or physical components of a more 
complete physical whole (e.g., a Computer System - perhaps a VM -  being a 
component of a Mainframe).  The other separate types of "components" that make 
up a system (databases, computer systems, etc.) seem to be separate items that 
merely depend on each other.  That makes more sense to me in my mind.

For example, if you wanted to have something akin to an generic Remedy 
Application System (think, Remedy from a customer's perspective), I think that 
might actually have two components from the perspective of the system, the User 
tool (or maybe the Mid Tier) and the AR Server.  Those are the two components 
of the system from the perspective of the overall Application System.  However, 
behind each of those are sub-components that are separate but that depend on 
each other.  E.g., the AR server depends on the Computer System it runs on and 
on the Database, the Database depends on the Computer System the DB server is 
running on, etc.  Does that make sense at all.

I don't know if I'm conveying what I'm thinking very well.  It seems like 
you're headed in the right direction, though.

Lyle

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Martinez, Marcelo A
Sent: Thursday, December 10, 2009 4:44 PM
To: arslist@ARSLIST.ORG
Subject: Re: CMDB mapping question: dependency vs. component

**
The reason I had them backwards is because that is how I interpret this 
document (see attached)..
Look at line 21 on page 8. But since I don't use BMC_SoftwareServer I 
substituted it for BMC_ComputerSystem.
It isn't clear to me if the source depends on the destination OR
if the source is a dependency of the destination...
Also, according to this document, there are very few "components". I would of 
thought that a "system" had many components (i.e. servers, database, jobs, etc).
Thanks Lyle
Marcelo (my msg was getting rejected so I removed the previous txt)

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
To: arslist@ARSLIST.ORG
Subject: Re: CMDB mapping question: dependency vs. component
I would say that your first table seems more correct, except that I think you 
probably have the Source and Destination columns backwards (the Source depends 
on the Destination, not the other way around, IIRC).  In addition, I don't 
think that your Rem001server computer system depends on the database - only 
your AR server depends on the database.  So, I would change "Rem001server" in 
the second line in the table to "Remedy System".  So I think the table would 
actually look like this in the end:
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_


 NOTICE: This email message is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information. Any unauthorized 
review, use, disclosure or distribution is prohibited. If you are not the 
intended recipient, please contact the sender by reply email and destroy all 
copies of the original message.



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: CMDB mapping question: dependency vs. component

[Martinez, Marcelo A]

The reason I had them backwards is because that is how I interpret this 
document (see attached)..
Look at line 21 on page 8. But since I don't use BMC_SoftwareServer I 
substituted it for BMC_ComputerSystem.
It isn't clear to me if the source depends on the destination OR
if the source is a dependency of the destination...
Also, according to this document, there are very few "components". I would of 
thought that a "system" had many components (i.e. servers, database, jobs, etc).
Thanks Lyle
Marcelo (my msg was getting rejected so I removed the previous txt)

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
To: arslist@ARSLIST.ORG
Subject: Re: CMDB mapping question: dependency vs. component
I would say that your first table seems more correct, except that I think you 
probably have the Source and Destination columns backwards (the Source depends 
on the Destination, not the other way around, IIRC).  In addition, I don't 
think that your Rem001server computer system depends on the database - only 
your AR server depends on the database.  So, I would change "Rem001server" in 
the second line in the table to "Remedy System".  So I think the table would 
actually look like this in the end:

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"


Mapping Your Data to BMC Atrium CMDB 7.x Classes.pdf
Description: Mapping Your Data to BMC Atrium CMDB 7.x Classes.pdf

Re: Add-Attachment fail on Filter

[Hyunkel v2.0]

Hi Stuart:

No, The attachment field is set tu 'ulimited', and the file barely reaches 1Kb.

Best Regards


Hugo Ruesga 
perotsystems® 
US  972.577.7000
MX +52 (33) 3332.3868
P Please consider the environment before printing this email

The information contained in and transferred with this electronic message is 
intended only for the recipient(s) designated above, it is protected by law and 
it may contain information which is privileged and confidential. If you are not 
the intended recipient, please do not read, copy, or use it, and do not 
disclose it to others. Please notify the sender of the delivery error by 
replying to this message, and then delete it from your system. Thank you.






Date: Fri, 11 Dec 2009 09:39:54 +1100
From: stuart.sc...@au.fujitsu.com
Subject: Re: Add-Attachment fail on Filter
To: arslist@ARSLIST.ORG

**



















Hi,
is the attachment to big

 

 

regards

 

Stuart Schon

Team Leader-Remedy

 

FUJITSU AUSTRALIA LIMITED 

Level 3, 2 Julius Avenue, North Ryde, NSW 2113, Australia

T 02 9113 9435  M 0439 475 240 

stuart.sc...@au.fujitsu.com

www.au.fujitsu.com 



 



From:
Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On 
Behalf Of Hyunkel v2.0

Sent: Friday, 11 December 2009
05:37

To: arslist@ARSLIST.ORG

Subject: Add-Attachment fail on
Filter



 

** 

I'm trying now to
add the attachment to the field, but guess i'm doing something wrong.



For add the attachment i'm using a filter with a Run Process that calls for:



$PROCESS$ PERFORM-ACTION-ADD-ATTACHMENT 536880912
"/home/remedy/fit_ftp/other.txt"



The filter is getting executed but, the attachment is not being attached to the
field.



Do i need to do anything, or am i missing something?



Best Regards







Hugo
Ruesga 

perotsystems® 

US  972.577.7000

MX +52 (33) 3332.3868

P Please consider the environment before
printing this email



The information contained in and transferred with this
electronic message is intended only for the recipient(s) designated above, it
is protected by law and it may contain information which is privileged and
confidential. If you are not the intended recipient, please do not read, copy,
or use it, and do not disclose it to others. Please notify the sender of the
delivery error by replying to this message, and then delete it from your
system. Thank you.



 



 







Cuida tu aguinaldo y tus cuentas bancarias,
OTTO te enseña cómo.

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the
Answers Are"_ 










This is an email from Fujitsu Australia Limited, ABN 19 001 011 427. It is 
confidential to the ordinary user of the email address

to which it was addressed and may contain copyright and/or legally privileged 
information. No one else may read, print, store, copy

or forward all or any of it or its attachments. If you receive this email in 
error, please return to sender. Thank you.

 

If you do not wish to receive commercial email messages from Fujitsu Australia 
Limited, please email unsubscr...@au.fujitsu.com



_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_   
  
_
Descubre Windows 7
http://www.windows.com.mx
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
<>

Re: CMDB mapping question: dependency vs. component

[Lyle Taylor]

I would say that your first table seems more correct, except that I think you 
probably have the Source and Destination columns backwards (the Source depends 
on the Destination, not the other way around, IIRC).  In addition, I don't 
think that your Rem001server computer system depends on the database - only 
your AR server depends on the database.  So, I would change "Rem001server" in 
the second line in the table to "Remedy System".  So I think the table would 
actually look like this in the end:


Relationship Type


Source (CI Type)


Destination (CI Type)


Dependency


Remedy System (BMC_ApplicationSystem)


Rem001server (BMC_ComputerSystem)


Dependency


Remedy System (BMC_ApplicationSystem)


ARSystem (BMC_Database)


Dependency


ARSystem (BMC_Database)


SQL001server (BMC_ComputerSystem)


Dependency


Remedy System (BMC_ApplicationSystem)


DomControl001 (BMC_ComputerSystem)


Dependency


Remedy System (BMC_ApplicationSystem)


Exchange Sys (BMC_ApplicationSystem)


Lyle

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Martinez, Marcelo A
Sent: Thursday, December 10, 2009 3:17 PM
To: arslist@ARSLIST.ORG
Subject: Re: CMDB mapping question: dependency vs. component

**

Help.. can someone please verify what I'm doing please?

According to how I understand the documentation, the first table should be 
correct. Do you concur ?



CIs:

Remedy System: BMC_ApplicaitonSystem

Exchange System: BMC_ApplicaitonSystem

Rem001Server: BMC_ComputerSystem

SQL0001Server: BMC_ComputerSystem

DomainController001:  BMC_ComputerSystem

ARSystem db: BMC_Database



Relationship Type


Source (CI Type)


Destination (CI Type)


Dependency


Rem001server (BMC_ComputerSystem)


Remedy System (BMC_ApplicationSystem)


Dependency


Rem001server (BMC_ComputerSystem)


ARSystem (BMC_Database)


Dependency


SQL001server (BMC_ComputerSystem)


ARSystem (BMC_Database)


Dependency


DomControl001 (BMC_ComputerSystem)


Remedy System (BMC_ApplicationSystem)


Dependency


Exchange Sys (BMC_ApplicationSystem)


Remedy System (BMC_ApplicationSystem)






Or does this second table look correct to you?



Relationship Type


Source (CI Type)


Destination (CI Type)


Component


Rem001server (BMC_ComputerSystem)


Remedy System (BMC_ApplicationSystem)


Component


ARSystem (BMC_Database)


Remedy System (BMC_ApplicationSystem)


Dependency


ARSystem (BMC_Database)


SQL001server (BMC_ComputerSystem)


Dependency


Remedy System (BMC_ApplicationSystem)


DomControl001 (BMC_ComputerSystem)


Dependency


Remedy System (BMC_ApplicationSystem)


Exchange Sys (BMC_ApplicationSystem)



 NOTICE: This email message is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information. Any unauthorized 
review, use, disclosure or distribution is prohibited. If you are not the 
intended recipient, please contact the sender by reply email and destroy all 
copies of the original message.



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Add-Attachment fail on Filter

[Schon, Stuart]

Hi, is the attachment to big

 

 

regards

 

Stuart Schon

Team Leader-Remedy

 

FUJITSU AUSTRALIA LIMITED 
Level 3, 2 Julius Avenue, North Ryde, NSW 2113, Australia
T 02 9113 9435  M 0439 475 240 

stuart.sc...@au.fujitsu.com  

www.au.fujitsu.com 

 

 

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Hyunkel v2.0
Sent: Friday, 11 December 2009 05:37
To: arslist@ARSLIST.ORG
Subject: Add-Attachment fail on Filter

 

** 

I'm trying now to add the attachment to the field, but guess i'm doing 
something wrong.

For add the attachment i'm using a filter with a Run Process that calls for:

$PROCESS$ PERFORM-ACTION-ADD-ATTACHMENT 536880912 
"/home/remedy/fit_ftp/other.txt"

The filter is getting executed but, the attachment is not being attached to the 
field.

Do i need to do anything, or am i missing something?

Best Regards



Hugo Ruesga 
perotsystems® 
US  972.577.7000
MX +52 (33) 3332.3868

P Please consider the environment before printing this email

The information contained in and transferred with this electronic message is 
intended only for the recipient(s) designated above, it is protected by law and 
it may contain information which is privileged and confidential. If you are not 
the intended recipient, please do not read, copy, or use it, and do not 
disclose it to others. Please notify the sender of the delivery error by 
replying to this message, and then delete it from your system. Thank you.

 

 



Cuida tu aguinaldo y tus cuentas bancarias, OTTO te enseña cómo. 
 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ 



This is an email from Fujitsu Australia Limited, ABN 19 001 011 427. It is 
confidential to the ordinary user of the email address
to which it was addressed and may contain copyright and/or legally privileged 
information. No one else may read, print, store, copy
or forward all or any of it or its attachments. If you receive this email in 
error, please return to sender. Thank you.
 
If you do not wish to receive commercial email messages from Fujitsu Australia 
Limited, please email unsubscr...@au.fujitsu.com


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"<>

Re: CMDB mapping question: dependency vs. component

[Martinez, Marcelo A]

Help.. can someone please verify what I'm doing please?

According to how I understand the documentation, the first table should be 
correct. Do you concur ?



CIs:

Remedy System: BMC_ApplicaitonSystem

Exchange System: BMC_ApplicaitonSystem

Rem001Server: BMC_ComputerSystem

SQL0001Server: BMC_ComputerSystem

DomainController001:  BMC_ComputerSystem

ARSystem db: BMC_Database



Relationship Type


Source (CI Type)


Destination (CI Type)


Dependency


Rem001server (BMC_ComputerSystem)


Remedy System (BMC_ApplicationSystem)


Dependency


Rem001server (BMC_ComputerSystem)


ARSystem (BMC_Database)


Dependency


SQL001server (BMC_ComputerSystem)


ARSystem (BMC_Database)


Dependency


DomControl001 (BMC_ComputerSystem)


Remedy System (BMC_ApplicationSystem)


Dependency


Exchange Sys (BMC_ApplicationSystem)


Remedy System (BMC_ApplicationSystem)






Or does this second table look correct to you?



Relationship Type


Source (CI Type)


Destination (CI Type)


Component


Rem001server (BMC_ComputerSystem)


Remedy System (BMC_ApplicationSystem)


Component


ARSystem (BMC_Database)


Remedy System (BMC_ApplicationSystem)


Dependency


ARSystem (BMC_Database)


SQL001server (BMC_ComputerSystem)


Dependency


Remedy System (BMC_ApplicationSystem)


DomControl001 (BMC_ComputerSystem)


Dependency


Remedy System (BMC_ApplicationSystem)


Exchange Sys (BMC_ApplicationSystem)






Thank you,
Marcelo Martinez





> -Original Message-

> From: Action Request System discussion list(ARSList)

> [mailto:arsl...@arslist.org] On Behalf Of Martinez, Marcelo A

> Sent: Tuesday, December 08, 2009 3:27 PM

> To: arslist@ARSLIST.ORG

> Subject: CMDB mapping question: dependency vs. component

>

> I'm mapping out a few "critical systems" in my CMDB and wanted some input.

>

> Remedy System: BMC_ApplicaitonSystem

> Rem001 Server: BMC_ComputerSystem - Component of Remedy System

> SQL0001 Server: BMC_ComputerSystem - Component of Remedy System (or is

> this a Dependency??) ARSystem database: BMC_Database - Component of Remedy

> System Exchange Server: BMC_ComputerSystem - Dependency of Remedy System

> DomainController:  BMC_ComputerSystem - Dependency of Remedy System

>

> Does this make sense? Or am I mapping it all wrong? Also what is a good

> naming convention for relationships: RemSysComp01, RemSysDepen01??

>

> I am doing this manually because I do not know how/where to mass relate

> these items. I have about 2000 CIs in Computer systems form.

>

> Specs:

> CMDB: 2.1.00

> ARS: 7.1.00

> ITSM 7.0.03

>

> Thanks,,

> Marcelo Martinez

>

>



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Add-Attachment fail on Filter

[Hyunkel v2.0]

Thanks Joe;

Not, It's an optional field.

Best Regards


Hugo Ruesga 
perotsystems® 
US  972.577.7000
MX +52 (33) 3332.3868
P Please consider the environment before printing this email

The information contained in and transferred with this electronic message is 
intended only for the recipient(s) designated above, it is protected by law and 
it may contain information which is privileged and confidential. If you are not 
the intended recipient, please do not read, copy, or use it, and do not 
disclose it to others. Please notify the sender of the delivery error by 
replying to this message, and then delete it from your system. Thank you.






Date: Thu, 10 Dec 2009 15:40:16 -0500
From: jdso...@shyle.net
Subject: Re: Add-Attachment fail on Filter
To: arslist@ARSLIST.ORG

**







Hugo,
 
I meant is it a 
Display-Only field? You may have created a Display-Only attachment field 
instead 
of a data attachment field by mistake.
 
Worth 
checking..
 
Joe

  -Original Message-
From: Action Request System 
  discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of 
  Hyunkel v2.0
Sent: Thursday, December 10, 2009 3:20 
  PM
To: arslist@ARSLIST.ORG
Subject: Re: Add-Attachment 
  fail on Filter

** 
  
  The field is an Attachment Field and yes the user that runs the ARS 
  application is the owner of the directory and the file.

Regards


  
  Hugo 
  Ruesga 
perotsystems® 
  
US  972.577.7000
MX +52 (33) 3332.3868
  P Please consider the environment before 
  printing this email
  
  The 
  information contained in and transferred with this electronic message is 
  intended only for the recipient(s) designated above, it is protected by law 
  and it may contain information which is privileged and confidential. If you 
  are not the intended recipient, please do not read, copy, or use it, and do 
  not disclose it to others. Please notify the sender of the delivery error by 
  replying to this message, and then delete it from your system. 
  Thank you.
  






  
  Date: Thu, 10 Dec 2009 14:33:40 -0500
From: jdso...@shyle.net
Subject: 
  Re: Add-Attachment fail on Filter
To: arslist@ARSLIST.ORG

** 
  Is 
  536880912 a Display-Only attachment field?
   
  Does the 
  user running the AR System on UNIX have access to the path as well as the 
file 
  to be attached?
   
  Joe
  
-Original Message-
From: Action Request System 
discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of 
Hyunkel v2.0
Sent: Thursday, December 10, 2009 2:05 
PM
To: arslist@ARSLIST.ORG
Subject: Re: Add-Attachment 
fail on Filter

** 

ARS 7.1 patch 007
Unix Server --> Solaris 10

The file is 
storage on the unix server.



Hugo 
Ruesga 
perotsystems® 

US  972.577.7000
MX +52 (33) 3332.3868
P Please consider the environment before 
printing this email

The 
information contained in and transferred with this electronic message is 
intended only for the recipient(s) designated above, it is protected by law 
and it may contain information which is privileged and confidential. If you 
are not the intended recipient, please do not read, copy, or use it, and do 
not disclose it to others. Please notify the sender of the delivery error 
by 
replying to this message, and then delete it from your system. 
Thank you.








Date: Thu, 10 Dec 2009 12:42:25 -0600
From: 
tony.worthing...@kohls.com
Subject: Re: Add-Attachment fail on 
Filter
To: arslist@ARSLIST.ORG

** What version and patch?  Bugs around this 
process... 

Tony 
Worthington | Sr. Technical 
Analyst | Kohl’s 
Department Stores 
N56 W17000 
Ridgewood Drive | Menomonee Falls, WI  53051 | office: (262) 703-7763 | 
e-mail: tony.worthing...@kohls.com 




  
  
From: 
"Hyunkel v2.0" 
   
  
To: 
arslist@ARSLIST.ORG 
  
Date: 
12/10/2009 12:38 PM 
  
Subject: 
Add-Attachment fail on Filter 

  
Sent by: 
"Action Request System discussion 
  list(ARSList)" 






** 
I'm trying 
now to add the attachment to the field, but guess i'm doing something 
wrong.

For add the attachment i'm using a filter with a Run Process 
that calls for:

$PROCESS$ PERFORM-ACTION-ADD-ATTACHMENT 536880912 
"/home/remedy/fit_ftp/other.txt"

The filter is getting executed but, 
the attachment is not being attached to the field.

Do i need to do 
anything, or am i missing something?

Best 
Regards


Hugo Ruesga 

perotsystems® 

US  972.577.7000
MX +52 
(33) 3332.3868 
P Please consider the environment before printing this 
email 
The information 
contained in and transferred with this electronic message is intended only 
for the recipient(s) designated above, it is protected by law and it may 
contain information which is privileged and confidential.

Re: Add-Attachment fail on Filter

[Hyunkel v2.0]

Thanks Mark;

I've tried that, but still not attaching the field

Best Regards


Hugo Ruesga 
perotsystems® 
US  972.577.7000
MX +52 (33) 3332.3868
P Please consider the environment before printing this email

The information contained in and transferred with this electronic message is 
intended only for the recipient(s) designated above, it is protected by law and 
it may contain information which is privileged and confidential. If you are not 
the intended recipient, please do not read, copy, or use it, and do not 
disclose it to others. Please notify the sender of the delivery error by 
replying to this message, and then delete it from your system. Thank you.






Date: Thu, 10 Dec 2009 15:24:05 -0500
From: mbritt...@navisite.com
Subject: Re: Add-Attachment fail on Filter
To: arslist@ARSLIST.ORG

**














HI Hugo
 
I looked in the manual and could not find any really useful information about 
this process. However I did have one thought. Have you tried it without the
 double quotes? Might try single quotes too. Just a thought
 
Mark
 




From: Action Request System discussion
 list(ARSList) [mailto:arsl...@arslist.org]
On Behalf Of Hyunkel v2.0

Sent: Thursday, December 10, 2009 3:20 PM

To: arslist@ARSLIST.ORG

Subject: Re: Add-Attachment fail on Filter

 
The field is an Attachment Field and yes the user that runs the ARS application 
is the owner of the directory and the file.



Regards

Hugo Ruesga


perotsystems®


US 
 972.577.7000

MX +52 (33) 3332.3868
P
Please consider the environment before printing this email

The information contained in and transferred with this electronic message is 
intended only for the recipient(s) designated
 above, it is protected by law and it may contain information which is 
privileged and confidential. If you are not the intended recipient, please do 
not read, copy, or use it, and do not disclose it to others. Please notify the 
sender of the delivery error
 by replying to this message, and then delete it from your system. Thank you.

 











  
_
Descubre Windows 7
http://www.windows.com.mx
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

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

[Ramey, Anne]

We have an Avaya system and our customers are very happy with the integration.  
I wasn't involved in the implementation, but I think it wasn't too big of a 
project.  I do know we brought in a Avaya contractor to do it.

Anne Ramey


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Martin Liu
Sent: Wednesday, December 09, 2009 3:51 AM
To: arslist@ARSLIST.ORG
Subject: ASK FOR RECOMMENDATION ABOUT: Computer Telephony Integration (CTI) for 
Remedy

** Hi List,

My customer is going to buy a new PBX system. Currently, we are implementing 
Remedy ITSM 7.6 for them. They ask recommendation to me.

As far as I know we support Avaya and Cisco CTI. But I don't know any specific 
CTI product or model.

May I know your CTI product name and model? Is that good? How about integration 
effort?

My customer need have 20~30 help-desk agent online. Any advice are welcomed!

Thanks,

--
Regards,

刘征 Martin Liu
--
Blog: http://martinliu.cn
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_


E-mail correspondence to and from this address may be subject to the North 
Carolina Public Records Law and may be disclosed to third parties by an 
authorized state official.

Re: Add-Attachment fail on Filter

[Joe D'Souza]

Hugo,

I meant is it a Display-Only field? You may have created a Display-Only
attachment field instead of a data attachment field by mistake.

Worth checking..

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Hyunkel v2.0
  Sent: Thursday, December 10, 2009 3:20 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: Add-Attachment fail on Filter


  ** The field is an Attachment Field and yes the user that runs the ARS
application is the owner of the directory and the file.

  Regards


  Hugo Ruesga
  perotsystems®
  US  972.577.7000
  MX +52 (33) 3332.3868

  P Please consider the environment before printing this email

  The information contained in and transferred with this electronic message
is intended only for the recipient(s) designated above, it is protected by
law and it may contain information which is privileged and confidential. If
you are not the intended recipient, please do not read, copy, or use it, and
do not disclose it to others. Please notify the sender of the delivery error
by replying to this message, and then delete it from your system. Thank you.











--
  Date: Thu, 10 Dec 2009 14:33:40 -0500
  From: jdso...@shyle.net
  Subject: Re: Add-Attachment fail on Filter
  To: arslist@ARSLIST.ORG

  **
  Is 536880912 a Display-Only attachment field?

  Does the user running the AR System on UNIX have access to the path as
well as the file to be attached?

  Joe
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Hyunkel v2.0
Sent: Thursday, December 10, 2009 2:05 PM
To: arslist@ARSLIST.ORG
Subject: Re: Add-Attachment fail on Filter


** ARS 7.1 patch 007
Unix Server --> Solaris 10

The file is storage on the unix server.


Hugo Ruesga
perotsystems®
US  972.577.7000
MX +52 (33) 3332.3868

P Please consider the environment before printing this email

The information contained in and transferred with this electronic
message is intended only for the recipient(s) designated above, it is
protected by law and it may contain information which is privileged and
confidential. If you are not the intended recipient, please do not read,
copy, or use it, and do not disclose it to others. Please notify the sender
of the delivery error by replying to this message, and then delete it from
your system. Thank you.











Date: Thu, 10 Dec 2009 12:42:25 -0600
From: tony.worthing...@kohls.com
Subject: Re: Add-Attachment fail on Filter
To: arslist@ARSLIST.ORG

** What version and patch?  Bugs around this process...

Tony Worthington | Sr. Technical Analyst | Kohl’s Department Stores
N56 W17000 Ridgewood Drive | Menomonee Falls, WI  53051 | office: (262)
703-7763 | e-mail: tony.worthing...@kohls.com


  From:  "Hyunkel v2.0" 
  To:  arslist@ARSLIST.ORG
  Date:  12/10/2009 12:38 PM
  Subject:  Add-Attachment fail on Filter
  Sent by:  "Action Request System discussion list(ARSList)"







**
I'm trying now to add the attachment to the field, but guess i'm doing
something wrong.

For add the attachment i'm using a filter with a Run Process that calls
for:

$PROCESS$ PERFORM-ACTION-ADD-ATTACHMENT 536880912
"/home/remedy/fit_ftp/other.txt"

The filter is getting executed but, the attachment is not being attached
to the field.

Do i need to do anything, or am i missing something?

Best Regards


Hugo Ruesga
perotsystems®
US  972.577.7000
MX +52 (33) 3332.3868
P Please consider the environment before printing this email
The information contained in and transferred with this electronic
message is intended only for the recipient(s) designated above, it is
protected by law and it may contain information which is privileged and
confidential. If you are not the intended recipient, please do not read,
copy, or use it, and do not disclose it to others. Please notify the sender
of the delivery error by replying to this message, and then delete it from
your system. Thank you.






Cuida tu aguinaldo y tus cuentas bancarias, OTTO te enseña cómo.
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_


CONFIDENTIALITY NOTICE:
This is a transmission from Kohl's Department Stores, Inc.
and may contain information which is confidential and proprietary.
If you are not the addressee, any disclosure, copying or distribution or
use of the contents of this message is expressly prohibited.
If 

Re: Add-Attachment fail on Filter

[Rick Cook]

Good thought, Mark. I have seen numerous documentation bugs in that area, so 
don't take the listed syntax as gospel. 

Rick

-Original Message-
From: "Brittain, Mark" 
Date: Thu, 10 Dec 2009 15:24:05 
To: 
Subject: Re: Add-Attachment fail on Filter

HI Hugo

I looked in the manual and could not find any really useful information about 
this process. However I did have one thought. Have you tried it without the 
double quotes? Might try single quotes too. Just a thought

Mark


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Hyunkel v2.0
Sent: Thursday, December 10, 2009 3:20 PM
To: arslist@ARSLIST.ORG
Subject: Re: Add-Attachment fail on Filter

The field is an Attachment Field and yes the user that runs the ARS application 
is the owner of the directory and the file.

Regards
Hugo Ruesga
perotsystems®
US  972.577.7000
MX +52 (33) 3332.3868
P Please consider the environment before printing this email
The information contained in and transferred with this electronic message is 
intended only for the recipient(s) designated above, it is protected by law and 
it may contain information which is privileged and confidential. If you are not 
the intended recipient, please do not read, copy, or use it, and do not 
disclose it to others. Please notify the sender of the delivery error by 
replying to this message, and then delete it from your system. Thank you.





Date: Thu, 10 Dec 2009 14:33:40 -0500
From: jdso...@shyle.net
Subject: Re: Add-Attachment fail on Filter
To: arslist@ARSLIST.ORG

**
Is 536880912 a Display-Only attachment field?

Does the user running the AR System on UNIX have access to the path as well as 
the file to be attached?

Joe
-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org]on Behalf Of Hyunkel v2.0
Sent: Thursday, December 10, 2009 2:05 PM
To: arslist@ARSLIST.ORG
Subject: Re: Add-Attachment fail on Filter
** ARS 7.1 patch 007
Unix Server --> Solaris 10

The file is storage on the unix server.
Hugo Ruesga
perotsystems®
US  972.577.7000
MX +52 (33) 3332.3868
P Please consider the environment before printing this email
The information contained in and transferred with this electronic message is 
intended only for the recipient(s) designated above, it is protected by law and 
it may contain information which is privileged and confidential. If you are not 
the intended recipient, please do not read, copy, or use it, and do not 
disclose it to others. Please notify the sender of the delivery error by 
replying to this message, and then delete it from your system. Thank you.





Date: Thu, 10 Dec 2009 12:42:25 -0600
From: tony.worthing...@kohls.com
Subject: Re: Add-Attachment fail on Filter
To: arslist@ARSLIST.ORG

** What version and patch?  Bugs around this process...

Tony Worthington | Sr. Technical Analyst | Kohl's Department Stores
N56 W17000 Ridgewood Drive | Menomonee Falls, WI  53051 | office: (262) 
703-7763 | e-mail: tony.worthing...@kohls.com

From:

"Hyunkel v2.0" 

To:

arslist@ARSLIST.ORG

Date:

12/10/2009 12:38 PM

Subject:

Add-Attachment fail on Filter

Sent by:

"Action Request System discussion list(ARSList)" 






**
I'm trying now to add the attachment to the field, but guess i'm doing 
something wrong.

For add the attachment i'm using a filter with a Run Process that calls for:

$PROCESS$ PERFORM-ACTION-ADD-ATTACHMENT 536880912 
"/home/remedy/fit_ftp/other.txt"

The filter is getting executed but, the attachment is not being attached to the 
field.

Do i need to do anything, or am i missing something?

Best Regards


Hugo Ruesga
perotsystems®
US  972.577.7000
MX +52 (33) 3332.3868
P Please consider the environment before printing this email
The information contained in and transferred with this electronic message is 
intended only for the recipient(s) designated above, it is protected by law and 
it may contain information which is privileged and confidential. If you are not 
the intended recipient, please do not read, copy, or use it, and do not 
disclose it to others. Please notify the sender of the delivery error by 
replying to this message, and then delete it from your system. Thank you.




Cuida tu aguinaldo y tus cuentas bancarias, OTTO te enseña 
cómo.
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

CONFIDENTIALITY NOTICE:
This is a transmission from Kohl's Department Stores, Inc.
and may contain information which is confidential and proprietary.
If you are not the addressee, any disclosure, copying or distribution or use of 
the contents of this message is expressly prohibited.
If you have received this transmission in error, please destroy it and notify 
us immediately at 262-703-7000.

Re: Add-Attachment fail on Filter

[Brittain, Mark]

HI Hugo

I looked in the manual and could not find any really useful information about 
this process. However I did have one thought. Have you tried it without the 
double quotes? Might try single quotes too. Just a thought

Mark


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Hyunkel v2.0
Sent: Thursday, December 10, 2009 3:20 PM
To: arslist@ARSLIST.ORG
Subject: Re: Add-Attachment fail on Filter

The field is an Attachment Field and yes the user that runs the ARS application 
is the owner of the directory and the file.

Regards
Hugo Ruesga
perotsystems®
US  972.577.7000
MX +52 (33) 3332.3868
P Please consider the environment before printing this email
The information contained in and transferred with this electronic message is 
intended only for the recipient(s) designated above, it is protected by law and 
it may contain information which is privileged and confidential. If you are not 
the intended recipient, please do not read, copy, or use it, and do not 
disclose it to others. Please notify the sender of the delivery error by 
replying to this message, and then delete it from your system. Thank you.





Date: Thu, 10 Dec 2009 14:33:40 -0500
From: jdso...@shyle.net
Subject: Re: Add-Attachment fail on Filter
To: arslist@ARSLIST.ORG

**
Is 536880912 a Display-Only attachment field?

Does the user running the AR System on UNIX have access to the path as well as 
the file to be attached?

Joe
-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org]on Behalf Of Hyunkel v2.0
Sent: Thursday, December 10, 2009 2:05 PM
To: arslist@ARSLIST.ORG
Subject: Re: Add-Attachment fail on Filter
** ARS 7.1 patch 007
Unix Server --> Solaris 10

The file is storage on the unix server.
Hugo Ruesga
perotsystems®
US  972.577.7000
MX +52 (33) 3332.3868
P Please consider the environment before printing this email
The information contained in and transferred with this electronic message is 
intended only for the recipient(s) designated above, it is protected by law and 
it may contain information which is privileged and confidential. If you are not 
the intended recipient, please do not read, copy, or use it, and do not 
disclose it to others. Please notify the sender of the delivery error by 
replying to this message, and then delete it from your system. Thank you.





Date: Thu, 10 Dec 2009 12:42:25 -0600
From: tony.worthing...@kohls.com
Subject: Re: Add-Attachment fail on Filter
To: arslist@ARSLIST.ORG

** What version and patch?  Bugs around this process...

Tony Worthington | Sr. Technical Analyst | Kohl's Department Stores
N56 W17000 Ridgewood Drive | Menomonee Falls, WI  53051 | office: (262) 
703-7763 | e-mail: tony.worthing...@kohls.com

From:

"Hyunkel v2.0" 

To:

arslist@ARSLIST.ORG

Date:

12/10/2009 12:38 PM

Subject:

Add-Attachment fail on Filter

Sent by:

"Action Request System discussion list(ARSList)" 






**
I'm trying now to add the attachment to the field, but guess i'm doing 
something wrong.

For add the attachment i'm using a filter with a Run Process that calls for:

$PROCESS$ PERFORM-ACTION-ADD-ATTACHMENT 536880912 
"/home/remedy/fit_ftp/other.txt"

The filter is getting executed but, the attachment is not being attached to the 
field.

Do i need to do anything, or am i missing something?

Best Regards


Hugo Ruesga
perotsystems®
US  972.577.7000
MX +52 (33) 3332.3868
P Please consider the environment before printing this email
The information contained in and transferred with this electronic message is 
intended only for the recipient(s) designated above, it is protected by law and 
it may contain information which is privileged and confidential. If you are not 
the intended recipient, please do not read, copy, or use it, and do not 
disclose it to others. Please notify the sender of the delivery error by 
replying to this message, and then delete it from your system. Thank you.




Cuida tu aguinaldo y tus cuentas bancarias, OTTO te enseña 
cómo.
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

CONFIDENTIALITY NOTICE:
This is a transmission from Kohl's Department Stores, Inc.
and may contain information which is confidential and proprietary.
If you are not the addressee, any disclosure, copying or distribution or use of 
the contents of this message is expressly prohibited.
If you have received this transmission in error, please destroy it and notify 
us immediately at 262-703-7000.

CAUTION:
Internet and e-mail communications are Kohl's property and Kohl's reserves the 
right to retrieve and read any message created, sent and received. Kohl's 
reserves the right to monitor messages by authorized Kohl's Associates at any 
time
without any further consent

Re: Add-Attachment fail on Filter

[Hyunkel v2.0]

The field is an Attachment Field and yes the user that runs the ARS application 
is the owner of the directory and the file.

Regards


Hugo Ruesga 
perotsystems® 
US  972.577.7000
MX +52 (33) 3332.3868
P Please consider the environment before printing this email

The information contained in and transferred with this electronic message is 
intended only for the recipient(s) designated above, it is protected by law and 
it may contain information which is privileged and confidential. If you are not 
the intended recipient, please do not read, copy, or use it, and do not 
disclose it to others. Please notify the sender of the delivery error by 
replying to this message, and then delete it from your system. Thank you.






Date: Thu, 10 Dec 2009 14:33:40 -0500
From: jdso...@shyle.net
Subject: Re: Add-Attachment fail on Filter
To: arslist@ARSLIST.ORG

**







Is 536880912 a 
Display-Only attachment field?
 
Does the user 
running the AR System on UNIX have access to the path as well as the file to be 
attached?
 
Joe

  -Original Message-
From: Action Request System 
  discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of 
  Hyunkel v2.0
Sent: Thursday, December 10, 2009 2:05 
  PM
To: arslist@ARSLIST.ORG
Subject: Re: Add-Attachment 
  fail on Filter

** 
  
  ARS 7.1 patch 007
Unix Server --> Solaris 10

The file is storage 
  on the unix server.


  
  Hugo 
  Ruesga 
perotsystems® 
  
US  972.577.7000
MX +52 (33) 3332.3868
  P Please consider the environment before 
  printing this email
  
  The 
  information contained in and transferred with this electronic message is 
  intended only for the recipient(s) designated above, it is protected by law 
  and it may contain information which is privileged and confidential. If you 
  are not the intended recipient, please do not read, copy, or use it, and do 
  not disclose it to others. Please notify the sender of the delivery error by 
  replying to this message, and then delete it from your system. 
  Thank you.
  






  
  Date: Thu, 10 Dec 2009 12:42:25 -0600
From: 
  tony.worthing...@kohls.com
Subject: Re: Add-Attachment fail on 
  Filter
To: arslist@ARSLIST.ORG

** What 
  version and patch?  Bugs around this process... 

Tony Worthington | Sr. Technical Analyst | Kohl’s Department Stores 
N56 W17000 Ridgewood Drive | Menomonee Falls, WI  53051 | 
  office: (262) 703-7763 | e-mail: tony.worthing...@kohls.com 




  


  From: 
  "Hyunkel v2.0" 
 

  To: 
  arslist@ARSLIST.ORG 

  Date: 
  12/10/2009 12:38 PM 

  Subject: 
  Add-Attachment fail on Filter 


  Sent by: 
  "Action Request System discussion 
list(ARSList)" 


  
  


** 
I'm trying 
  now to add the attachment to the field, but guess i'm doing something 
  wrong.

For add the attachment i'm using a filter with a Run Process 
  that calls for:

$PROCESS$ PERFORM-ACTION-ADD-ATTACHMENT 536880912 
  "/home/remedy/fit_ftp/other.txt"

The filter is getting executed but, 
  the attachment is not being attached to the field.

Do i need to do 
  anything, or am i missing something?

Best 
  Regards


Hugo Ruesga 
  
perotsystems® 
  
US  972.577.7000
MX +52 (33) 
  3332.3868 
P Please 
  consider the environment before printing this email 
The information contained in and 
  transferred with this electronic message is intended only for the 
recipient(s) 
  designated above, it is protected by law and it may contain information which 
  is privileged and confidential. If you are not the intended recipient, please 
  do not read, copy, or use it, and do not disclose it to others. Please notify 
  the sender of the delivery error by replying to this message, and then delete 
  it from your system. Thank you. 





  
  Cuida tu aguinaldo y tus cuentas bancarias, 
  OTTO te enseña cómo. 
_Platinum 
  Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ 


  
  CONFIDENTIALITY NOTICE: 
This is a transmission from Kohl's Department 
  Stores, Inc.
and may contain information which is confidential and 
  proprietary.
If you are not the addressee, any disclosure, copying or 
  distribution or use of the contents of this message is expressly 
  prohibited.
If you have received this transmission in error, please destroy 
  it and notify us immediately at 262-703-7000.

CAUTION:
Internet and 
  e-mail communications are Kohl's property and Kohl's reserves the right to 
  retrieve and read any message created, sent and received. Kohl's reserves the 
  right to monitor messages by authorized Kohl's Associates at any 
  time
without any further consent.

  
  CONFIDENTIALITY NOTICE: 
This is a transmission from Kohl's Department 
  Stores, Inc.
and may contain information which is confidential and 
  proprietary.
If you are not the addressee, any disclosure, copying or 
  distribution or use of the contents of this message is expressly 
  prohibited.
If you have received this transmission in

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

[Joe D'Souza]

Hello Victor,

That is what I suspected with the invalid identifier error.. if your table
was not recognized it would be invalid table or view name error which is not
your case.. Which is why the later part of my previous email holds good..
Take a SQL log, you may find that offending column name or columns..

There is something in the way that ARS is naming the offending column or
columns causing that error..

When you find what column it is email the list or me directly and we'll try
to figure it out.. you might need to create a independent view in MS-SQL of
that table having names of fields that are legal to use in case there is a
column name there that the ARS converts into something else.. This is just a
speculative solution, we'll know more when you know more..

Cheers

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Victor
Sent: Thursday, December 10, 2009 3:00 PM
To: arslist@ARSLIST.ORG
Subject: Re: View form from Oracle based AR system to remote MS SQL
server


Thanks Joe,

I will try all you said and have you posted tomorrow(I'm out of office at
the moment) but I want to point out that will creating the view form I was
able to load the table and the pick the fields required for the form.
Only when I pressed "Create" the error occurred.

.. and furthermore the ms sql username and password was hard-cored into the
public DB link created

Victor

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Using AIE to restore Asset Data

[Pierson, Shawn]

I've just come up with a way to solve my problem.  I am matching on the TokenID 
field, but I copied the contents of the InstanceID field over to the TokenID so 
it is truly unique now, and I don't have to worry about duplicate CI Names, 
Serial Numbers, etc.

Thanks,

Shawn Pierson

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Thursday, December 10, 2009 1:18 PM
To: arslist@ARSLIST.ORG
Subject: Re: Using AIE to restore Asset Data

**
Note that you can use multiple fields for identification in reconciliation.  
So, if you can define a groups of fields that uniquely identifies each asset, 
you should be able to import the backup data into a dataset, identify between 
them using this group of fields, and then merge them.  Note that what you're 
currently having to do provides a good justification for at least running an 
auto-identification activity on your gold dataset, even if you never merge 
anything in from another dataset, because then you know that you have a single 
field that you can use to identify assets if you ever have to do this again.

Lyle

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn
Sent: Thursday, December 10, 2009 12:04 PM
To: arslist@ARSLIST.ORG
Subject: Re: Using AIE to restore Asset Data

**
We didn't do any reconciliations because the users who own this data don't 
trust automation (which unfortunately did cause the problem in this case) so 
they wanted to perform the creation and updates of Computer System CIs manually.

My plan was to use AIE, but since the data I want to fix is limited to the 
computer system data itself, I may just try doing it all through SQL and 
getting it fixed faster even if it's not the recommended way.

Thanks,

Shawn

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Thursday, December 10, 2009 12:15 PM
To: arslist@ARSLIST.ORG
Subject: Re: Using AIE to restore Asset Data

**
Are you saying that you have a backup of the Asset data that was in Remedy?  
Does that backup include the Reconciliation ID?  If it does, then you don't 
need to match on anything, you would simply need to do a Merge between the 
datasets, because everything should already be matched up (by definition, 
anything that has a recon id (something other than zero) is already matched to 
something, so it doesn't try to identify it again).  You might need to define 
Precedence rules to only set the fields that have gone missing (to avoid 
overwriting any other data that may have changed since the backup), though.

Lyle

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn
Sent: Thursday, December 10, 2009 10:29 AM
To: arslist@ARSLIST.ORG
Subject: Using AIE to restore Asset Data

**
Good morning,

We had a recent problem where a bunch of our Asset data was wiped out.  The 
records exist, but some of the fields were made null.  I came up with the idea 
of using AIE to fix this problem by restoring the Asset data from a backup and 
treating it as external data to import.

However, I've been told that I can't match on either the Request ID or the 
Instance ID, so I am curious if anyone here knows of a system generated unique 
id that I can use to match the old record with the new record.

Thanks,

Shawn Pierson
Remedy Developer | Southern Union



Private and confidential as detailed 
here. If you cannot access 
hyperlink, please e-mail sender.
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_


NOTICE: This email message is for the sole use of the intended recipient(s) and 
may contain confidential and privileged information. Any unauthorized review, 
use, disclosure or distribution is prohibited. If you are not the intended 
recipient, please contact the sender by reply email and destroy all copies of 
the original message.

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
Private and confidential as detailed 
here. If you cannot access 
hyperlink, please e-mail sender.
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

Private and confidential as detailed here: 
http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the 
link, please e-mail sender.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

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

[Victor]

Thanks Joe,

I will try all you said and have you posted tomorrow(I'm out of office at the 
moment) but I want to point out that will creating the view form I was able to 
load the table and the pick the fields required for the form.
Only when I pressed "Create" the error occurred.

.. and furthermore the ms sql username and password was hard-cored into the 
public DB link created

Victor

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Using AIE to restore Asset Data

[Martinez, Marcelo A]

What if you import the entire data, verify it and then delete all data old 
date...  Create Date < $DATE$

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Thursday, December 10, 2009 1:18 PM
To: arslist@ARSLIST.ORG
Subject: Re: Using AIE to restore Asset Data

**
Note that you can use multiple fields for identification in reconciliation.  
So, if you can define a groups of fields that uniquely identifies each asset, 
you should be able to import the backup data into a dataset, identify between 
them using this group of fields, and then merge them.  Note that what you're 
currently having to do provides a good justification for at least running an 
auto-identification activity on your gold dataset, even if you never merge 
anything in from another dataset, because then you know that you have a single 
field that you can use to identify assets if you ever have to do this again.

Lyle

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn
Sent: Thursday, December 10, 2009 12:04 PM
To: arslist@ARSLIST.ORG
Subject: Re: Using AIE to restore Asset Data

**
We didn't do any reconciliations because the users who own this data don't 
trust automation (which unfortunately did cause the problem in this case) so 
they wanted to perform the creation and updates of Computer System CIs manually.

My plan was to use AIE, but since the data I want to fix is limited to the 
computer system data itself, I may just try doing it all through SQL and 
getting it fixed faster even if it's not the recommended way.

Thanks,

Shawn

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Thursday, December 10, 2009 12:15 PM
To: arslist@ARSLIST.ORG
Subject: Re: Using AIE to restore Asset Data

**
Are you saying that you have a backup of the Asset data that was in Remedy?  
Does that backup include the Reconciliation ID?  If it does, then you don't 
need to match on anything, you would simply need to do a Merge between the 
datasets, because everything should already be matched up (by definition, 
anything that has a recon id (something other than zero) is already matched to 
something, so it doesn't try to identify it again).  You might need to define 
Precedence rules to only set the fields that have gone missing (to avoid 
overwriting any other data that may have changed since the backup), though.

Lyle

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn
Sent: Thursday, December 10, 2009 10:29 AM
To: arslist@ARSLIST.ORG
Subject: Using AIE to restore Asset Data

**
Good morning,

We had a recent problem where a bunch of our Asset data was wiped out.  The 
records exist, but some of the fields were made null.  I came up with the idea 
of using AIE to fix this problem by restoring the Asset data from a backup and 
treating it as external data to import.

However, I've been told that I can't match on either the Request ID or the 
Instance ID, so I am curious if anyone here knows of a system generated unique 
id that I can use to match the old record with the new record.

Thanks,

Shawn Pierson
Remedy Developer | Southern Union



Private and confidential as detailed 
here. If you cannot access 
hyperlink, please e-mail sender.
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_


NOTICE: This email message is for the sole use of the intended recipient(s) and 
may contain confidential and privileged information. Any unauthorized review, 
use, disclosure or distribution is prohibited. If you are not the intended 
recipient, please contact the sender by reply email and destroy all copies of 
the original message.

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
Private and confidential as detailed 
here. If you cannot access 
hyperlink, please e-mail sender.
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

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

[Victor]

On Thursday 10 December 2009 20:30:37 Joe D'Souza wrote:
> Victor,
>
> When you access the database view from oracle using SQL*Plus, are you
> logging into SQL*Plus using the same username and password
> (ARAdmin/AR#Admin# if you are using defaults) that is used by the AR System
> to connect to the Oracle database?
>
> If no, then do that and then try to access the table. If you get the same
> error when you try it that way, it means that the DB link you have created
> does not have sufficient privileges for that user that the AR System uses.
> Ask your DBA to fix that..
>
> If you can view the contents of that table after logging in as the AR
> System database user ARAdmin, then you are trying to address that view
> incorrectly while creating the view form.
>
> Make sure that you are using the same name for the view when building it
> from the AR System development interface, as you are using when addressing
> it from SQL*Plus when connected as ARAdmin..
>
> Check on the above before reading below... make sure you have enough
> privileges to query that db link from ARAdmin and that you are addressing
> the view name correctly..
>
> My gut feelings are you are using the right name, and have sufficient
> privileges. Invalid Identifier errors in Oracle, is often due to the fact
> that a column name used in an SQL statement, is an invalid column name. You
> might want to turn up SQL logging to see what column is being addressed
> wrongly. I'm betting on that the Request Identifier column that you are
> selecting to create the view is being wrongly addressed by the SQL
> statement generated by Remedy.
>
> Check your SQL log, and the SQL statement that is generating that error.
> Copy that statement into SQL*Plus, execute it, and then try correcting that
> statement (use ed line editor of SQL*Plus) and correct the column name that
> is being addressed wrongly, then execute it till it runs correctly.
>
> Tell us what you find there.. what works wrong and what needs to be fixed
> on your SQL so that it may work correctly..
>
> Cheers
>
> Joe
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org]on Behalf Of Victor
> Sent: Thursday, December 10, 2009 1:23 PM
> To: arslist@ARSLIST.ORG
> Subject: View form from Oracle based AR system to remote MS SQL server
>
>
> Listers,
>
> Is it possible to create view forms from an Oracle based AR system to
> remote MS SQL Server?
>
> I successfully created the database link and I could access the MS SQL
> tables from sqlplus but when I tried to create view forms I received:
> "Failure during SQL operation to the database: ORA-00904: Invalid
> identifier (ARERR 552)"
>
> Operation performed on ARSystem 6.3 on windows 2k server. The MS SQL server
> is also on windows 2k server.
>
> Any feedback will be appreciated
>
> Victor
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Thanks Joe,

I will try all you said and have you posted tomorrow(I'm out of office at the 
moment) but I want to point out that will creating the view form I was able to 
load the table and the pick the fields required for the form.
Only when I pressed "Create" the error occurred.

Victor

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Add-Attachment fail on Filter

[Joe D'Souza]

Is 536880912 a Display-Only attachment field?

Does the user running the AR System on UNIX have access to the path as well
as the file to be attached?

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Hyunkel v2.0
  Sent: Thursday, December 10, 2009 2:05 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: Add-Attachment fail on Filter


  ** ARS 7.1 patch 007
  Unix Server --> Solaris 10

  The file is storage on the unix server.


  Hugo Ruesga
  perotsystems®
  US  972.577.7000
  MX +52 (33) 3332.3868

  P Please consider the environment before printing this email

  The information contained in and transferred with this electronic message
is intended only for the recipient(s) designated above, it is protected by
law and it may contain information which is privileged and confidential. If
you are not the intended recipient, please do not read, copy, or use it, and
do not disclose it to others. Please notify the sender of the delivery error
by replying to this message, and then delete it from your system. Thank you.











--
  Date: Thu, 10 Dec 2009 12:42:25 -0600
  From: tony.worthing...@kohls.com
  Subject: Re: Add-Attachment fail on Filter
  To: arslist@ARSLIST.ORG

  ** What version and patch?  Bugs around this process...

  Tony Worthington | Sr. Technical Analyst | Kohl’s Department Stores
  N56 W17000 Ridgewood Drive | Menomonee Falls, WI  53051 | office: (262)
703-7763 | e-mail: tony.worthing...@kohls.com


From:  "Hyunkel v2.0" 
To:  arslist@ARSLIST.ORG
Date:  12/10/2009 12:38 PM
Subject:  Add-Attachment fail on Filter
Sent by:  "Action Request System discussion list(ARSList)"




--



  **
  I'm trying now to add the attachment to the field, but guess i'm doing
something wrong.

  For add the attachment i'm using a filter with a Run Process that calls
for:

  $PROCESS$ PERFORM-ACTION-ADD-ATTACHMENT 536880912
"/home/remedy/fit_ftp/other.txt"

  The filter is getting executed but, the attachment is not being attached
to the field.

  Do i need to do anything, or am i missing something?

  Best Regards


  Hugo Ruesga
  perotsystems®
  US  972.577.7000
  MX +52 (33) 3332.3868
  P Please consider the environment before printing this email
  The information contained in and transferred with this electronic message
is intended only for the recipient(s) designated above, it is protected by
law and it may contain information which is privileged and confidential. If
you are not the intended recipient, please do not read, copy, or use it, and
do not disclose it to others. Please notify the sender of the delivery error
by replying to this message, and then delete it from your system. Thank you.






--
  Cuida tu aguinaldo y tus cuentas bancarias, OTTO te enseña cómo.
  _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_


--
  CONFIDENTIALITY NOTICE:
  This is a transmission from Kohl's Department Stores, Inc.
  and may contain information which is confidential and proprietary.
  If you are not the addressee, any disclosure, copying or distribution or
use of the contents of this message is expressly prohibited.
  If you have received this transmission in error, please destroy it and
notify us immediately at 262-703-7000.

  CAUTION:
  Internet and e-mail communications are Kohl's property and Kohl's reserves
the right to retrieve and read any message created, sent and received.
Kohl's reserves the right to monitor messages by authorized Kohl's
Associates at any time
  without any further consent.


--
  CONFIDENTIALITY NOTICE:
  This is a transmission from Kohl's Department Stores, Inc.
  and may contain information which is confidential and proprietary.
  If you are not the addressee, any disclosure, copying or distribution or
use of the contents of this message is expressly prohibited.
  If you have received this transmission in error, please destroy it and
notify us immediately at 262-703-7000.

  CAUTION:
  Internet and e-mail communications are Kohl's property and Kohl's reserves
the right to retrieve and read any message created, sent and received.
Kohl's reserves the right to monitor messages by authorized Kohl's
Associates at any time
  without any further consent.


--
  CONFIDENTIALITY NOTICE:
  This is a transmission from Kohl's Department Stores, Inc.
  and may contain information which is confidential and proprietary.
  If you are not the addressee, any disclosure, copying or distribution or
use of the c

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

[Joe D'Souza]

Victor,

When you access the database view from oracle using SQL*Plus, are you
logging into SQL*Plus using the same username and password
(ARAdmin/AR#Admin# if you are using defaults) that is used by the AR System
to connect to the Oracle database?

If no, then do that and then try to access the table. If you get the same
error when you try it that way, it means that the DB link you have created
does not have sufficient privileges for that user that the AR System uses.
Ask your DBA to fix that..

If you can view the contents of that table after logging in as the AR System
database user ARAdmin, then you are trying to address that view incorrectly
while creating the view form.

Make sure that you are using the same name for the view when building it
from the AR System development interface, as you are using when addressing
it from SQL*Plus when connected as ARAdmin..

Check on the above before reading below... make sure you have enough
privileges to query that db link from ARAdmin and that you are addressing
the view name correctly..

My gut feelings are you are using the right name, and have sufficient
privileges. Invalid Identifier errors in Oracle, is often due to the fact
that a column name used in an SQL statement, is an invalid column name. You
might want to turn up SQL logging to see what column is being addressed
wrongly. I'm betting on that the Request Identifier column that you are
selecting to create the view is being wrongly addressed by the SQL statement
generated by Remedy.

Check your SQL log, and the SQL statement that is generating that error.
Copy that statement into SQL*Plus, execute it, and then try correcting that
statement (use ed line editor of SQL*Plus) and correct the column name that
is being addressed wrongly, then execute it till it runs correctly.

Tell us what you find there.. what works wrong and what needs to be fixed on
your SQL so that it may work correctly..

Cheers

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Victor
Sent: Thursday, December 10, 2009 1:23 PM
To: arslist@ARSLIST.ORG
Subject: View form from Oracle based AR system to remote MS SQL server


Listers,

Is it possible to create view forms from an Oracle based AR system to remote
MS SQL Server?

I successfully created the database link and I could access the MS SQL
tables from sqlplus but when I tried to create view forms I received:
"Failure during SQL operation to the database: ORA-00904: Invalid identifier
(ARERR 552)"

Operation performed on ARSystem 6.3 on windows 2k server. The MS SQL server
is also on windows 2k server.

Any feedback will be appreciated

Victor

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Using AIE to restore Asset Data

[Lyle Taylor]

Note that you can use multiple fields for identification in reconciliation.  
So, if you can define a groups of fields that uniquely identifies each asset, 
you should be able to import the backup data into a dataset, identify between 
them using this group of fields, and then merge them.  Note that what you're 
currently having to do provides a good justification for at least running an 
auto-identification activity on your gold dataset, even if you never merge 
anything in from another dataset, because then you know that you have a single 
field that you can use to identify assets if you ever have to do this again.

Lyle

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn
Sent: Thursday, December 10, 2009 12:04 PM
To: arslist@ARSLIST.ORG
Subject: Re: Using AIE to restore Asset Data

**
We didn't do any reconciliations because the users who own this data don't 
trust automation (which unfortunately did cause the problem in this case) so 
they wanted to perform the creation and updates of Computer System CIs manually.

My plan was to use AIE, but since the data I want to fix is limited to the 
computer system data itself, I may just try doing it all through SQL and 
getting it fixed faster even if it's not the recommended way.

Thanks,

Shawn

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Thursday, December 10, 2009 12:15 PM
To: arslist@ARSLIST.ORG
Subject: Re: Using AIE to restore Asset Data

**
Are you saying that you have a backup of the Asset data that was in Remedy?  
Does that backup include the Reconciliation ID?  If it does, then you don't 
need to match on anything, you would simply need to do a Merge between the 
datasets, because everything should already be matched up (by definition, 
anything that has a recon id (something other than zero) is already matched to 
something, so it doesn't try to identify it again).  You might need to define 
Precedence rules to only set the fields that have gone missing (to avoid 
overwriting any other data that may have changed since the backup), though.

Lyle

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn
Sent: Thursday, December 10, 2009 10:29 AM
To: arslist@ARSLIST.ORG
Subject: Using AIE to restore Asset Data

**
Good morning,

We had a recent problem where a bunch of our Asset data was wiped out.  The 
records exist, but some of the fields were made null.  I came up with the idea 
of using AIE to fix this problem by restoring the Asset data from a backup and 
treating it as external data to import.

However, I've been told that I can't match on either the Request ID or the 
Instance ID, so I am curious if anyone here knows of a system generated unique 
id that I can use to match the old record with the new record.

Thanks,

Shawn Pierson
Remedy Developer | Southern Union



Private and confidential as detailed 
here. If you cannot access 
hyperlink, please e-mail sender.
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_


NOTICE: This email message is for the sole use of the intended recipient(s) and 
may contain confidential and privileged information. Any unauthorized review, 
use, disclosure or distribution is prohibited. If you are not the intended 
recipient, please contact the sender by reply email and destroy all copies of 
the original message.

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
Private and confidential as detailed 
here. If you cannot access 
hyperlink, please e-mail sender.
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Add-Attachment fail on Filter

[Hyunkel v2.0]

ARS 7.1 patch 007
Unix Server --> Solaris 10

The file is storage on the unix server.


Hugo Ruesga 
perotsystems® 
US  972.577.7000
MX +52 (33) 3332.3868
P Please consider the environment before printing this email

The information contained in and transferred with this electronic message is 
intended only for the recipient(s) designated above, it is protected by law and 
it may contain information which is privileged and confidential. If you are not 
the intended recipient, please do not read, copy, or use it, and do not 
disclose it to others. Please notify the sender of the delivery error by 
replying to this message, and then delete it from your system. Thank you.






Date: Thu, 10 Dec 2009 12:42:25 -0600
From: tony.worthing...@kohls.com
Subject: Re: Add-Attachment fail on Filter
To: arslist@ARSLIST.ORG

**
What version and patch?  Bugs around
this process...



Tony Worthington
| Sr. Technical Analyst |
Kohl’s Department Stores

N56 W17000 Ridgewood Drive | Menomonee Falls,
WI  53051 | office: (262) 703-7763 | e-mail: tony.worthing...@kohls.com








From:
"Hyunkel v2.0" 

To:
arslist@ARSLIST.ORG

Date:
12/10/2009 12:38 PM

Subject:
Add-Attachment fail on Filter

Sent by:
"Action Request System discussion
list(ARSList)" 








** 

I'm trying now to add the attachment to
the field, but guess i'm doing something wrong.



For add the attachment i'm using a filter with a Run Process that calls
for:



$PROCESS$ PERFORM-ACTION-ADD-ATTACHMENT 536880912 
"/home/remedy/fit_ftp/other.txt"



The filter is getting executed but, the attachment is not being attached
to the field.



Do i need to do anything, or am i missing something?



Best Regards





Hugo Ruesga 

perotsystems®


US  972.577.7000

MX +52 (33) 3332.3868

P
Please consider the environment
before printing this email

The information contained
in and transferred with this electronic message is intended only for the
recipient(s) designated above, it is protected by law and it may contain
information which is privileged and confidential. If you are not the intended
recipient, please do not read, copy, or use it, and do not disclose it
to others. Please notify the sender of the delivery error by replying to
this message, and then delete it from your system. Thank you.










Cuida tu aguinaldo y tus cuentas bancarias,
OTTO
te enseña cómo.

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where
the Answers Are"_ 


CONFIDENTIALITY NOTICE: 

This is a transmission from Kohl's Department Stores, Inc.

and may contain information which is confidential and proprietary.

If you are not the addressee, any disclosure, copying or distribution or use of 
the contents of this message is expressly prohibited.

If you have received this transmission in error, please destroy it and notify 
us immediately at 262-703-7000.



CAUTION:

Internet and e-mail communications are Kohl's property and Kohl's reserves the 
right to retrieve and read any message created, sent and received.  Kohl's 
reserves the right to monitor messages by authorized Kohl's Associates at any 
time

without any further consent.


CONFIDENTIALITY NOTICE: 

This is a transmission from Kohl's Department Stores, Inc.

and may contain information which is confidential and proprietary.

If you are not the addressee, any disclosure, copying or distribution or use of 
the contents of this message is expressly prohibited.

If you have received this transmission in error, please destroy it and notify 
us immediately at 262-703-7000.



CAUTION:

Internet and e-mail communications are Kohl's property and Kohl's reserves the 
right to retrieve and read any message created, sent and received.  Kohl's 
reserves the right to monitor messages by authorized Kohl's Associates at any 
time

without any further consent.


CONFIDENTIALITY NOTICE: 

This is a transmission from Kohl's Department Stores, Inc.

and may contain information which is confidential and proprietary.

If you are not the addressee, any disclosure, copying or distribution or use of 
the contents of this message is expressly prohibited.

If you have received this transmission in error, please destroy it and notify 
us immediately at 262-703-7000.



CAUTION:

Internet and e-mail communications are Kohl's property and Kohl's reserves the 
right to retrieve and read any message created, sent and received.  Kohl's 
reserves the right to monitor messages by authorized Kohl's Associates at any 
time

without any further consent.

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_   
  
_
Una nueva experiencia de búsqueda está aquí
http://www.bing.com/?mkt=es-MX&FORM=M006IR&Publ=WLHMTAG&Crea=TEXT_M006IR_Bing_ES_SaveTimeClicks_1X1
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARS

Re: Using AIE to restore Asset Data

[Pierson, Shawn]

We didn't do any reconciliations because the users who own this data don't 
trust automation (which unfortunately did cause the problem in this case) so 
they wanted to perform the creation and updates of Computer System CIs manually.

My plan was to use AIE, but since the data I want to fix is limited to the 
computer system data itself, I may just try doing it all through SQL and 
getting it fixed faster even if it's not the recommended way.

Thanks,

Shawn

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Thursday, December 10, 2009 12:15 PM
To: arslist@ARSLIST.ORG
Subject: Re: Using AIE to restore Asset Data

**
Are you saying that you have a backup of the Asset data that was in Remedy?  
Does that backup include the Reconciliation ID?  If it does, then you don't 
need to match on anything, you would simply need to do a Merge between the 
datasets, because everything should already be matched up (by definition, 
anything that has a recon id (something other than zero) is already matched to 
something, so it doesn't try to identify it again).  You might need to define 
Precedence rules to only set the fields that have gone missing (to avoid 
overwriting any other data that may have changed since the backup), though.

Lyle

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn
Sent: Thursday, December 10, 2009 10:29 AM
To: arslist@ARSLIST.ORG
Subject: Using AIE to restore Asset Data

**
Good morning,

We had a recent problem where a bunch of our Asset data was wiped out.  The 
records exist, but some of the fields were made null.  I came up with the idea 
of using AIE to fix this problem by restoring the Asset data from a backup and 
treating it as external data to import.

However, I've been told that I can't match on either the Request ID or the 
Instance ID, so I am curious if anyone here knows of a system generated unique 
id that I can use to match the old record with the new record.

Thanks,

Shawn Pierson
Remedy Developer | Southern Union



Private and confidential as detailed 
here. If you cannot access 
hyperlink, please e-mail sender.
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_


NOTICE: This email message is for the sole use of the intended recipient(s) and 
may contain confidential and privileged information. Any unauthorized review, 
use, disclosure or distribution is prohibited. If you are not the intended 
recipient, please contact the sender by reply email and destroy all copies of 
the original message.

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

Private and confidential as detailed here: 
http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the 
link, please e-mail sender.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Using AIE to restore Asset Data

[Pierson, Shawn]

There are duplicates in the CI Name field, as there are in serial number.  This 
data was not of great quality but it's what the users want.

Thanks,

Shawn

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of DCI Remedy
Sent: Thursday, December 10, 2009 12:00 PM
To: arslist@ARSLIST.ORG
Subject: Re: Using AIE to restore Asset Data

** why don't you match on CI Name?
On Thu, Dec 10, 2009 at 10:37 AM, Pierson, Shawn 
mailto:shawn.pier...@sug.com>> wrote:
**
It was manually entered, unfortunately.

Thanks,

Shawn

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of 
Chowdhury, Tauf
Sent: Thursday, December 10, 2009 11:34 AM
To: arslist@ARSLIST.ORG
Subject: Re: Using AIE to restore Asset Data

**
How was the data put into Asset? Config Discovery? Manual?
If it's Configuration Discovery, there's a bunch of unique fields...

Why wouldn't you be able to match using Instance ID?

Tauf Chowdhury | Forest Laboratories, Inc.
Analyst, Service Management
Mobile:646.483.2779

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Pierson, 
Shawn
Sent: Thursday, December 10, 2009 12:29 PM
To: arslist@ARSLIST.ORG
Subject: Using AIE to restore Asset Data

**
Good morning,

We had a recent problem where a bunch of our Asset data was wiped out.  The 
records exist, but some of the fields were made null.  I came up with the idea 
of using AIE to fix this problem by restoring the Asset data from a backup and 
treating it as external data to import.

However, I've been told that I can't match on either the Request ID or the 
Instance ID, so I am curious if anyone here knows of a system generated unique 
id that I can use to match the old record with the new record.

Thanks,

Shawn Pierson
Remedy Developer | Southern Union



Private and confidential as detailed 
here. If you cannot access 
hyperlink, please e-mail sender.
_Platinum Sponsor: rmisoluti...@verizon.net 
ARSlist: "Where the Answers Are"_

This e-mail and its attachments may contain Forest Laboratories, Inc. 
proprietary information that is privileged, confidential or subject to 
copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely 
for the use of the individual or entity to which it is addressed. If you are 
not the intended recipient of this e-mail, or the employee or agent responsible 
for delivering this e-mail to the intended recipient, you are hereby notified 
that any dissemination, distribution, copying or action taken in relation to 
the contents of and attachments to this e-mail is strictly prohibited and may 
be unlawful. If you have received this e-mail in error, please notify the 
sender immediately and permanently delete the original and any copy of this 
e-mail and any printout.
_Platinum Sponsor: rmisoluti...@verizon.net 
ARSlist: "Where the Answers Are"_
Private and confidential as detailed 
here. If you cannot access 
hyperlink, please e-mail sender.
_Platinum Sponsor: rmisoluti...@verizon.net 
ARSlist: "Where the Answers Are"_

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

Private and confidential as detailed here: 
http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the 
link, please e-mail sender.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Add-Attachment fail on Filter

[Tony Worthington]

What version and patch?  Bugs around this process...

Tony Worthington | Sr. Technical Analyst | Kohl?s Department Stores
N56 W17000 Ridgewood Drive | Menomonee Falls, WI  53051 | office: (262) 
703-7763 | e-mail: tony.worthing...@kohls.com



From:
"Hyunkel v2.0" 
To:
arslist@ARSLIST.ORG
Date:
12/10/2009 12:38 PM
Subject:
Add-Attachment fail on Filter
Sent by:
"Action Request System discussion list(ARSList)" 



** 
I'm trying now to add the attachment to the field, but guess i'm doing 
something wrong.

For add the attachment i'm using a filter with a Run Process that calls 
for:

$PROCESS$ PERFORM-ACTION-ADD-ATTACHMENT 536880912 
"/home/remedy/fit_ftp/other.txt"

The filter is getting executed but, the attachment is not being attached 
to the field.

Do i need to do anything, or am i missing something?

Best Regards


Hugo Ruesga 
perotsystems® 
US  972.577.7000
MX +52 (33) 3332.3868
P Please consider the environment before printing this email
The information contained in and transferred with this electronic message 
is intended only for the recipient(s) designated above, it is protected by 
law and it may contain information which is privileged and confidential. 
If you are not the intended recipient, please do not read, copy, or use 
it, and do not disclose it to others. Please notify the sender of the 
delivery error by replying to this message, and then delete it from your 
system. Thank you.




Cuida tu aguinaldo y tus cuentas bancarias, OTTO te enseña cómo.
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers 
Are"_ 

**
CONFIDENTIALITY NOTICE: 
This is a transmission from Kohl's Department Stores, Inc.
and may contain information which is confidential and proprietary.
If you are not the addressee, any disclosure, copying or distribution or use of 
the contents of this message is expressly prohibited.
If you have received this transmission in error, please destroy it and notify 
us immediately at 262-703-7000.

CAUTION:
Internet and e-mail communications are Kohl's property and Kohl's reserves the 
right to retrieve and read any message created, sent and received.  Kohl's 
reserves the right to monitor messages by authorized Kohl's Associates at any 
time
without any further consent.

**
CONFIDENTIALITY NOTICE: 
This is a transmission from Kohl's Department Stores, Inc.
and may contain information which is confidential and proprietary.
If you are not the addressee, any disclosure, copying or distribution or use of 
the contents of this message is expressly prohibited.
If you have received this transmission in error, please destroy it and notify 
us immediately at 262-703-7000.

CAUTION:
Internet and e-mail communications are Kohl's property and Kohl's reserves the 
right to retrieve and read any message created, sent and received.  Kohl's 
reserves the right to monitor messages by authorized Kohl's Associates at any 
time
without any further consent.

**
CONFIDENTIALITY NOTICE: 
This is a transmission from Kohl's Department Stores, Inc.
and may contain information which is confidential and proprietary.
If you are not the addressee, any disclosure, copying or distribution or use of 
the contents of this message is expressly prohibited.
If you have received this transmission in error, please destroy it and notify 
us immediately at 262-703-7000.

CAUTION:
Internet and e-mail communications are Kohl's property and Kohl's reserves the 
right to retrieve and read any message created, sent and received.  Kohl's 
reserves the right to monitor messages by authorized Kohl's Associates at any 
time
without any further consent.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Add-Attachment fail on Filter

[Hyunkel v2.0]

I'm trying now to add the attachment to the field, but guess i'm doing 
something wrong.

For add the attachment i'm using a filter with a Run Process that calls for:

$PROCESS$ PERFORM-ACTION-ADD-ATTACHMENT 536880912 
"/home/remedy/fit_ftp/other.txt"

The filter is getting executed but, the attachment is not being attached to the 
field.

Do i need to do anything, or am i missing something?

Best Regards



Hugo Ruesga 
perotsystems® 
US  972.577.7000
MX +52 (33) 3332.3868
P Please consider the environment before printing this email

The information contained in and transferred with this electronic message is 
intended only for the recipient(s) designated above, it is protected by law and 
it may contain information which is privileged and confidential. If you are not 
the intended recipient, please do not read, copy, or use it, and do not 
disclose it to others. Please notify the sender of the delivery error by 
replying to this message, and then delete it from your system. Thank you.



  
_
Una nueva experiencia de búsqueda está aquí
http://www.bing.com/?mkt=es-MX&FORM=M006IR&Publ=WLHMTAG&Crea=TEXT_M006IR_Bing_ES_SaveTimeClicks_1X1
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

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

[Victor]

Listers,

Is it possible to create view forms from an Oracle based AR system to remote 
MS SQL Server?

I successfully created the database link and I could access the MS SQL tables 
from sqlplus but when I tried to create view forms I received:
"Failure during SQL operation to the database: ORA-00904: Invalid identifier 
(ARERR 552)"

Operation performed on ARSystem 6.3 on windows 2k server. The MS SQL server is 
also on windows 2k server.

Any feedback will be appreciated

Victor

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Using AIE to restore Asset Data

[Lyle Taylor]

Are you saying that you have a backup of the Asset data that was in Remedy?  
Does that backup include the Reconciliation ID?  If it does, then you don't 
need to match on anything, you would simply need to do a Merge between the 
datasets, because everything should already be matched up (by definition, 
anything that has a recon id (something other than zero) is already matched to 
something, so it doesn't try to identify it again).  You might need to define 
Precedence rules to only set the fields that have gone missing (to avoid 
overwriting any other data that may have changed since the backup), though.

Lyle

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn
Sent: Thursday, December 10, 2009 10:29 AM
To: arslist@ARSLIST.ORG
Subject: Using AIE to restore Asset Data

**
Good morning,

We had a recent problem where a bunch of our Asset data was wiped out.  The 
records exist, but some of the fields were made null.  I came up with the idea 
of using AIE to fix this problem by restoring the Asset data from a backup and 
treating it as external data to import.

However, I've been told that I can't match on either the Request ID or the 
Instance ID, so I am curious if anyone here knows of a system generated unique 
id that I can use to match the old record with the new record.

Thanks,

Shawn Pierson
Remedy Developer | Southern Union



Private and confidential as detailed 
here. If you cannot access 
hyperlink, please e-mail sender.
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_


 NOTICE: This email message is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information. Any unauthorized 
review, use, disclosure or distribution is prohibited. If you are not the 
intended recipient, please contact the sender by reply email and destroy all 
copies of the original message.



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Using AIE to restore Asset Data

[DCI Remedy]

why don't you match on CI Name?

On Thu, Dec 10, 2009 at 10:37 AM, Pierson, Shawn wrote:

> **
>
> It was manually entered, unfortunately.
>
>
>
> Thanks,
>
>
>
> Shawn
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arsl...@arslist.org] *On Behalf Of *Chowdhury, Tauf
> *Sent:* Thursday, December 10, 2009 11:34 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: Using AIE to restore Asset Data
>
>
>
> **
>
> How was the data put into Asset? Config Discovery? Manual?
>
> If it’s Configuration Discovery, there’s a bunch of unique fields…
>
>
>
> Why wouldn’t you be able to match using Instance ID?
>
>
>
> *T**auf** **C**howdhury** **|** **F**orest** **L**aboratories**, **I**nc.*
> **
>
> Analyst, Service Management
>
> Mobile:646.483.2779
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arsl...@arslist.org] *On Behalf Of *Pierson, Shawn
> *Sent:* Thursday, December 10, 2009 12:29 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Using AIE to restore Asset Data
>
>
>
> **
>
> Good morning,
>
>
>
> We had a recent problem where a bunch of our Asset data was wiped out.  The
> records exist, but some of the fields were made null.  I came up with the
> idea of using AIE to fix this problem by restoring the Asset data from a
> backup and treating it as external data to import.
>
>
>
> However, I’ve been told that I can’t match on either the Request ID or the
> Instance ID, so I am curious if anyone here knows of a system generated
> unique id that I can use to match the old record with the new record.
>
>
>
> Thanks,
>
>
>
> *Shawn Pierson *
>
> Remedy Developer | Southern Union
>
>
>
>
>
>
>
> Private and confidential as detailed 
> here.
> If you cannot access hyperlink, please e-mail sender.
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
>  --
>
> This e-mail and its attachments may contain Forest Laboratories, Inc.
> proprietary information that is privileged, confidential or subject to
> copyright belonging to Forest Laboratories, Inc. This e-mail is intended
> solely for the use of the individual or entity to which it is addressed. If
> you are not the intended recipient of this e-mail, or the employee or agent
> responsible for delivering this e-mail to the intended recipient, you are
> hereby notified that any dissemination, distribution, copying or action
> taken in relation to the contents of and attachments to this e-mail is
> strictly prohibited and may be unlawful. If you have received this e-mail in
> error, please notify the sender immediately and permanently delete the
> original and any copy of this e-mail and any printout.
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
> Private and confidential as detailed 
> here.
> If you cannot access hyperlink, please e-mail sender.
>  _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Using AIE to restore Asset Data

[Pierson, Shawn]

It was manually entered, unfortunately.

Thanks,

Shawn

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Chowdhury, Tauf
Sent: Thursday, December 10, 2009 11:34 AM
To: arslist@ARSLIST.ORG
Subject: Re: Using AIE to restore Asset Data

**
How was the data put into Asset? Config Discovery? Manual?
If it's Configuration Discovery, there's a bunch of unique fields...

Why wouldn't you be able to match using Instance ID?

Tauf Chowdhury | Forest Laboratories, Inc.
Analyst, Service Management
Mobile:646.483.2779

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn
Sent: Thursday, December 10, 2009 12:29 PM
To: arslist@ARSLIST.ORG
Subject: Using AIE to restore Asset Data

**
Good morning,

We had a recent problem where a bunch of our Asset data was wiped out.  The 
records exist, but some of the fields were made null.  I came up with the idea 
of using AIE to fix this problem by restoring the Asset data from a backup and 
treating it as external data to import.

However, I've been told that I can't match on either the Request ID or the 
Instance ID, so I am curious if anyone here knows of a system generated unique 
id that I can use to match the old record with the new record.

Thanks,

Shawn Pierson
Remedy Developer | Southern Union



Private and confidential as detailed 
here. If you cannot access 
hyperlink, please e-mail sender.
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

This e-mail and its attachments may contain Forest Laboratories, Inc. 
proprietary information that is privileged, confidential or subject to 
copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely 
for the use of the individual or entity to which it is addressed. If you are 
not the intended recipient of this e-mail, or the employee or agent responsible 
for delivering this e-mail to the intended recipient, you are hereby notified 
that any dissemination, distribution, copying or action taken in relation to 
the contents of and attachments to this e-mail is strictly prohibited and may 
be unlawful. If you have received this e-mail in error, please notify the 
sender immediately and permanently delete the original and any copy of this 
e-mail and any printout.
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

Private and confidential as detailed here: 
http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the 
link, please e-mail sender.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Using AIE to restore Asset Data

[Chowdhury, Tauf]

How was the data put into Asset? Config Discovery? Manual? 

If it's Configuration Discovery, there's a bunch of unique fields... 

 

Why wouldn't you be able to match using Instance ID? 

 

Tauf Chowdhury | Forest Laboratories, Inc.

Analyst, Service Management

Mobile:646.483.2779

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn
Sent: Thursday, December 10, 2009 12:29 PM
To: arslist@ARSLIST.ORG
Subject: Using AIE to restore Asset Data

 

** 

Good morning,

 

We had a recent problem where a bunch of our Asset data was wiped out.
The records exist, but some of the fields were made null.  I came up
with the idea of using AIE to fix this problem by restoring the Asset
data from a backup and treating it as external data to import.

 

However, I've been told that I can't match on either the Request ID or
the Instance ID, so I am curious if anyone here knows of a system
generated unique id that I can use to match the old record with the new
record.

 

Thanks,

 

Shawn Pierson 

Remedy Developer | Southern Union

 

 

 

Private and confidential as detailed here
 . If you cannot access
hyperlink, please e-mail sender. 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ 

**
This e-mail and its attachments may contain Forest Laboratories, Inc. 
proprietary information that is privileged, confidential or subject to 
copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely 
for the use of the individual or entity to which it is addressed. If you are 
not the intended recipient of this e-mail, or the employee or agent responsible 
for delivering this e-mail to the intended recipient, you are hereby notified 
that any dissemination, distribution, copying or action taken in relation to 
the contents of and attachments to this e-mail is strictly prohibited and may 
be unlawful. If you have received this e-mail in error, please notify the 
sender immediately and permanently delete the original and any copy of this 
e-mail and any printout.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Using AIE to restore Asset Data

[Pierson, Shawn]

Good morning,

We had a recent problem where a bunch of our Asset data was wiped out.  The 
records exist, but some of the fields were made null.  I came up with the idea 
of using AIE to fix this problem by restoring the Asset data from a backup and 
treating it as external data to import.

However, I've been told that I can't match on either the Request ID or the 
Instance ID, so I am curious if anyone here knows of a system generated unique 
id that I can use to match the old record with the new record.

Thanks,

Shawn Pierson
Remedy Developer | Southern Union




Private and confidential as detailed here: 
http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the 
link, please e-mail sender.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Team Foundation Server

[LJ Longwing]

Wellbased on the minimal research I just did on TFS...if it is in fact
the product referenced in the link below, it's a follow-on to the SourceSafe
product formerly provided by Microsoftthat being the case, the current
source control integrations available in 7.1 and below don't work very
wellI wouldn't expect it to extend beyond the versions currently
supported.  If you are talking about 7.5 however...it integrates its own
source control directly at the app server level, so no client integration
necessary.  If you wanted to further integrate that with an external system
you could write filters that fire on submit into the source control
tablesand due to the fact that this Wikipedia article says that TFS
provides web services for integration...you may just be able to write your
own that might work wellI personally plan on just sticking with the 7.5
ootb source control for my needs :)
 
http://en.wikipedia.org/wiki/Team_Foundation_Server


  _  

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Basile, Cindy
Sent: Thursday, December 10, 2009 9:35 AM
To: arslist@ARSLIST.ORG
Subject: Team Foundation Server


** 
Good morning, 
 
Does anyone out there have any integration setup between Remedy and TFS?
Its a product that 
we purchased to replace ClearQwest and we are looking into integration
options.
 
Any feedback would be great!
Thanks,
-Cindy
 
CONFIDENTIALITY NOTICE: 

This e-mail transmission may contain confidential information.

This information is solely for the use of the individual(s) or

entity to whom or which it was intended. If not an intended

recipient, any review, copying, printing, disclosure,

distribution or any other use is strictly prohibited. 

If you have received this email in error, please immediately

notify the sender by reply e-mail. Please delete this e-mail

from your files if you are not the intended recipient. Thank you.





_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Team Foundation Server

[Basile, Cindy]

Good morning,

Does anyone out there have any integration setup between Remedy and TFS?  Its a 
product that
we purchased to replace ClearQwest and we are looking into integration options.

Any feedback would be great!
Thanks,
-Cindy


CONFIDENTIALITY NOTICE: 
This e-mail transmission may contain confidential information.
This information is solely for the use of the individual(s) or
entity to whom or which it was intended. If not an intended
recipient, any review, copying, printing, disclosure,
distribution or any other use is strictly prohibited. 
If you have received this email in error, please immediately
notify the sender by reply e-mail. Please delete this e-mail
from your files if you are not the intended recipient. Thank you.


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

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

[Rabi Tripathi]

David, can you explain what IT Service Management "Solution Pack" means? If I 
have Service Desk only, do I qualify?

On Mon, Dec 7, 2009 at 1:30 PM, Easter, David  wrote:

> Lastly, BMC's SMPM tool would be very helpful. I posted a question about 
who is entitled to a non-trial version, but got no replies.

The full versions of SMPM is provided with the purchase of the IT Service 
Management Solution Pack.  The two versions can also be purchased separately, 
although that is under the legacy selling model - so your BMC partner or sales 
person may have to get an exception to sell them "à la carte".  They are called:

BMC Service Management Process Model for Service Delivery
BMC Service Management Process Model for Service Support

-David J. Easter
Sr. Product Manager, Solution Strategy and Development
BMC Software, Inc.

The opinions, statements, and/or suggested courses of action expressed in 
this E-mail do not necessarily reflect those of BMC Software, Inc.  My 
voluntary participation in this forum is not intended to convey a role as a 
spokesperson, liaison or public relations representative for BMC Software, Inc.






___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: CMDB Change stuck in Change Pending - Processing

[Tim Rondeau]

Thank you

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Tony Worthington
Sent: Thursday, December 10, 2009 10:19 AM
To: arslist@ARSLIST.ORG
Subject: Re: CMDB Change stuck in Change Pending - Processing

The version of CMDB you are on is incompatible with the version of ARS you're 
on.  We had the same problem here.

You'll need to contact BMC Support and have them help you clean up the 
meta-data that is now inconsistent, then upgrade/patch your CMDB.

Some excerpts from my previous issue:

--


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

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

[Martinez, Marcelo A]

Brian,
The document you mentioned, "Mapping Your 
Data to BMC Atrium CMDB 7.x Classes", is very helpful. It specifies in detail 
how to relate CIs as well as types of relationships classes.. good read!

Thanks,
Marcelo

Peter Romain,
Thank you for pointing out about the Impact Relationships. I am not using them. 
Truthfully, I don't even see it on my CMDB common data model.

Thanks,
Marcelo



-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of ARSList2009
Sent: Wednesday, December 09, 2009 11:54 AM
To: arslist@ARSLIST.ORG
Subject: Re: SV: CMDB mapping question: dependency vs. component

Marcelo,
As for relationship names, there is a white paper entitled "Mapping Your 
Data to BMC Atrium CMDB 7.x Classes" that has a Relationship 
Normalization table with suggested names for all relationships.

Brian

Petrus Johansson wrote:
> **
> Rather than having a dependency relationship between the DC and the 
> RemedySystem I would suggest doing an Impact Relationship between the 
> DC and the actual domain. That way you (your boss) would see all 
> impacted application systems being hosted on a computer system of that 
> domain affected by a potential reboot of the DC
>  
> Best Regards / Mit freundlichen grüssen / Med Vänliga Hälsningar
> Petrus Johansson
> Senior Product Responsible BMC Discovery Solutions
>
> IKEA IT AB
> Sweden
> 
> *Från:* Action Request System discussion list(ARSList) 
> [arsl...@arslist.org] för Martinez, Marcelo A [marc...@cpchem.com]
> *Skickat:* den 8 december 2009 23:55
> *Till:* arslist@ARSLIST.ORG
> *Ämne:* Re: CMDB mapping question: dependency vs. component
>
> Shawn,
> Thanks for the image. It helps!
> The reason I (or better said - my boss) wants to include the exchange 
> server and DC is because IF the DC or Exch servers was to be rebooted, 
> this way would list all the "application systems" that the reboot is 
> affecting.. But I do see what you mean, the view can get obnoxiously full.
>
> As far as the DB server and database, your example makes sense. I need 
> to relate the application to the database, not necessarily to the DB 
> server. Then relate the database to the DB server... I'll need to run 
> this pass the boss.
>
> One question: what class did you use to load "Remedy Production 
> ARSystem"? did you use BMC_ApplicationSystem or just BMC_Application? 
> (I think ApplicationSystem is the superclass of Application)
>
> Thanks again Shawn.
>
> Marcelo Martinez
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn
> Sent: Tuesday, December 08, 2009 4:27 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: CMDB mapping question: dependency vs. component
>
> Marcelo,
>
> I hope this image of my layout helps.  Basically, I think you are 
> using the correct classes, but I don't know that I would put 
> everything you are putting there.  For example, do you really need to 
> list the Exchange Server and Domain Controller?  They are sort of 
> implied, and you may not want to list it and risk making either the 
> Remedy view or the Domain Controller's views too full.
>
> Also, if you look at my layout, I built dependencies between the 
> Remedy Application with the database, and the database with the SQL 
> Server, but I did not relate the Remedy Application with the DB Server.
>
> Thanks,
>
> Shawn Pierson
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Martinez, Marcelo A
> Sent: Tuesday, December 08, 2009 3:27 PM
> To: arslist@ARSLIST.ORG
> Subject: CMDB mapping question: dependency vs. component
>
> I'm mapping out a few "critical systems" in my CMDB and wanted some input.
>
> Remedy System: BMC_ApplicaitonSystem
> Rem001 Server: BMC_ComputerSystem - Component of Remedy System
> SQL0001 Server: BMC_ComputerSystem - Component of Remedy System (or is 
> this a Dependency??) ARSystem database: BMC_Database - Component of 
> Remedy System Exchange Server: BMC_ComputerSystem - Dependency of 
> Remedy System
> DomainController:  BMC_ComputerSystem - Dependency of Remedy System
>
> Does this make sense? Or am I mapping it all wrong? Also what is a 
> good naming convention for relationships: RemSysComp01, RemSysDepen01??
>
> I am doing this manually because I do not know how/where to mass 
> relate these items. I have about 2000 CIs in Computer systems form.
>
> Specs:
> CMDB: 2.1.00
> ARS: 7.1.00
> ITSM 7.0.03
>
> Thanks,,
> Marcelo Martinez
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
>  Platinum Sponsor:rmisoluti...@verizon.net 
> ARSlist: "Where the Answers Are"
>
> Private and confidential as detailed here: 
> http://www.sug.com/disclaimers/default.

Re: CMDB Change stuck in Change Pending - Processing

[Tony Worthington]

The version of CMDB you are on is incompatible with the version of ARS 
you're on.  We had the same problem here.

You'll need to contact BMC Support and have them help you clean up the 
meta-data that is now inconsistent, then upgrade/patch your CMDB.

Some excerpts from my previous issue:

--

4) As per the information, you have CMDB 2.0.1 P3 with AR Server 7.1 P2 ( 
CMDB 2.0.1 P3 is not compatible with ARS 7.1, you must upgrade your CMDB 
to CMDB 2.0.1 P4 or onwards. Latest CMDB Version is 2.1 P3). We need to 
get that class before planning an upgrade. 

I have attached ARS 7.1 Release Notes with Open Issues. Please refer page 
61. 

SW00263496

AR System server with BMC Atrium Configuration Management Database (CMDB) 
2.0.1: To
use BMC Atrium CMDB 2.0.1 with release 7.1.00 of the AR System server, you 
must install
patch 004 for BMC Atrium CMDB. If you do not, the following error occurs 
when you create
a class in BMC Atrium CMDB:

CMDBCreateClass results
ReturnCode: ERROR
Status List : 1 items
Status Struct :
Message type : ERROR
Message number : 8941
Message: XML Parsing error. Invalid element tag.
Appended: errorHandlerOptions, line: 165, column 24

Mon Aug 11 12:39:11 2008  390600 : AR System server terminated when a 
signal/exception was received by the server (ARNOTE 20)
Mon Aug 11 12:39:11 2008 
   Timestamp: Mon Aug 11 2008 12:39:11.7080 
   Thread Id: 8064
   Version: 7.1.00 Patch 002 RTCL-05/23/08 200802201753 May 23 2008 
10:30:13
   ServerName: remedy-test 
   Database: SQL -- Oracle
   Hardware: Intel Pentium
   OS: Windows NT 5.2
   RPC Id: 160477
   RPC Call: 40 (EXP)
   RPC Queue: 390600
   Client: User tony from Unidentified Client (protocol 12) at IP address 
10.1.35.2
   Form: 
   Logging On: Alert User Thread
   Code: c005
   Operation: read
   Access Addr: 0x5c
   Stack Begin: 
  Addr: 013D11D4
  Addr: 0141103F
  Addr: 0140792C
  Addr: 019AFE21
   Stack End 

Mon Aug 11 12:39:11 2008  390600 : AR System server terminated when a 
signal/exception was received by the server (ARNOTE 20)
Mon Aug 11 12:39:11 2008 0xc005
Mon Aug 11 12:39:11 2008  390600 : AR System server terminated -- fatal 
error encountered (ARNOTE 21)

--


Tony Worthington | Sr. Technical Analyst | Kohl?s Department Stores
N56 W17000 Ridgewood Drive | Menomonee Falls, WI  53051 | office: (262) 
703-7763 | e-mail: tony.worthing...@kohls.com



From:
Tim Rondeau 
To:
arslist@ARSLIST.ORG
Date:
12/10/2009 08:28 AM
Subject:
CMDB Change stuck in Change Pending - Processing
Sent by:
"Action Request System discussion list(ARSList)" 



** 
Running arsystem 7.1 
Cmdb 2.0.1 patch 3
 
We have added several fields to the CMDB without issue, now the following 
is happening.
 
Once I add a field to CMDB, this happens to the arsystem.
 
Thu Dec 10 01:42:16 2009  390600 : AR System server terminated when a 
signal/exception was received by the server (ARNOTE 20)
Thu Dec 10 01:42:16 2009 
   Timestamp: Thu Dec 10 2009 01:42:16.9430 
   Thread Id: 4768
   Version: 7.1.00 Patch 007 200904160530 Apr 16 2009 06:46:41
   ServerName: mb-remapp01 
   Database: SQL -- SQL Server
   Hardware: Intel Pentium
   OS: Windows NT 5.2
   RPC Id: 6895
   RPC Call: 11 (EXP)
   RPC Queue: 390600
   Client: User Remedy Application Service from Unidentified Client 
(protocol 12) at IP address 10.198.100.94
   Form: 
   Logging On:
   Code: c005
   Operation: read
   Access Addr: 0x5c
   Stack Begin: 
  Addr: 012011D4
  Addr: 0124103F
  Addr: 0123792C
  Addr: 0149FE21
   Stack End 
 
Thu Dec 10 01:42:16 2009  390600 : AR System server terminated when a 
signal/exception was received by the server (ARNOTE 20)
Thu Dec 10 01:42:16 2009 0xc005
Thu Dec 10 01:42:16 2009  390600 : AR System server terminated -- fatal 
error encountered (ARNOTE 21)
 
 
 

 

 
Has anyone seen this issue.
 
Thanks
 
Tim
 
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers 
Are"_ 
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers 
Are"_ 

**
CONFIDENTIALITY NOTICE: 
This is a transmission from Kohl's Department Stores, Inc.
and may contain information which is confidential and proprietary.
If you are not the addressee, any disclosure, copying or distribution or use of 
the contents of this message is expressly prohibited.
If you have received this transmission in error, please destroy it and notify 
us immediately at 262-703-7000.

CAUTION:
Internet and e-mail communications are Kohl's property and Kohl's reserves the 
right to retrieve and read any message created, sent and received.  Kohl's 
reserves the right to monitor messages by authorized Kohl's Associates at any 
time
without any further consent.
<><>

Re: Development Cache Mode revisited

[Misi Mladoniczky]

Hi,

We have taken all this into account.

1. The escalations are run on another server
2. Admin-changes will never be applied during production hours

Without Development-Cache-Mode set, the server frequently timed out when
doing admin changes. This seemed to be because of the buffer-copying when
the cache was duplicated.

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

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

> You really need to be careful with development cache mode on production
> servers for the following reason;
>
> With this option set the server has only one copy of the cache to work
> with.  This may provide some advantages in terms of memory usage but
> consider the following..
>
> A user starts a long running query, or a long running escalation kicks
> off.  In both of these cases the thread performing the work will place a
> flag against the cache to say that it is in use - effectively a read lock.
>  Now you make an admin change which requires exclusive use of the one
> cache that you have.  This exclusive lock cannot be obtained because the
> cache is in use so it is queued up and your admin thread is out of action
> until it gets the lock.  Not only that but any subsequent user API call
> that tries to get a read lock on the cache will fail because there is an
> outstanding exclusive lock request pending.  All of your users are locked
> out until the orginal activity completes and then the pending admin change
> is done.
>
> Mark
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky
> Sent: 10 December 2009 11:59
> To: arslist@ARSLIST.ORG
> Subject: Re: Development Cache Mode revisited
>
> Hi,
>
> Just to clarify.
>
> This more or less proves that it is a BAD idea to have Cache-Mode set to
> Development on any server in the Server-Group but the Admin-server.
>
> The Admin-server seems to just patch in the modification directly in
> memory. The other servers allways need to recache everything when a change
> has occured.
>
> If Dev-Cache-Mode is set on a server that rereads the whole cache, the
> users need to wait until the operation is completed.
>
> Best Regards - Misi, RRR AB, http://www.rrr.se
>
> Products from RRR Scandinavia:
> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
> * RRR|Translator - Manage and automate your language translations.
> Find these products, and many free tools and utilities, at http://rrr.se.
>
>> Hi,
>>
>> We have now gone into production, and I have a couple of things I want
>> to
>> share about this...
>>
>> The two servers in the server-group are (now) 7.1.0 patch 008.
>>
>> We have ITSM7 instaleld.
>>
>> We can call the servers USER and ESCL, to indicate their major use.
>>
>> The final way we did it was to have the following setup, it is shown
>> last
>> in the last table below:
>> USER, Cache-Mode=Dev, Admin
>> ESCL, Cache-Mode=0
>>
>> These are results from various settings when an admin-change was
>> applied.
>>
>> Server CacheMode AdminServer RecacheTime UserLockout RecacheMem
>> StableMem
>> USER   Dev   -   420 sec 420 sec 620Mb  620Mb
>> ESCL   Dev   Admin   1 sec   1 sec   620Mb  620Mb
>> (not good, as users got locked out)
>>
>> Server CacheMode AdminServer RecacheTime UserLockout RecacheMem
>> StableMem
>> USER   Dev   Admin   1 sec   1 sec   620Mb  620Mb
>> ESCL   Normal-   550 sec 0 sec   1200Mb 620Mb
>> (requires more memory on the ESCL-server)
>>
>> Note that if you import multiple things, as opposed to applying a small
>> change, the 1-second lockout may be considerably higher.
>>
>>Best Regards - Misi, RRR AB, http://rrr.se
>>
>>> Yep.  If anyone is interested, p171 7.5 Config.
>>>
>>> When object definition changes are made to the administrative server in
>>> a
>>> server
>>> group, other members of the group can be notified either by a signal or
>>> by
>>> a
>>> database posting. With signaling, other servers are notified of changes
>>> immediately, and there is no delay in resynchronization or updating
>>> definitions.
>>> The database method reduces server activity when object definition
>>> changes
>>> are
>>> communicated between servers and is an effective way to reduce the
>>> number
>>> of
>>> cache reloads when a series of changes are made, but there is a delay
>>> before other
>>> members of the server group pick up the changes.
>>>
>>> By default, AR System uses a combination of these methods for different
>>> types of
>>> updates in a server group. Server definition changes such as changes to
>>> forms,
>>> active links, fi

Re: safest and fastest way to delete AR Email records

[Axton]

Yes, directly against the db.  The main reason is so that the high water
mark is reset on the table.  You basically won't have any
performance/overhead gains unless you do this.

http://www.adp-gmbh.ch/ora/concepts/space_management/high_water_mark.html

Axton

On Wed, Dec 9, 2009 at 4:58 PM, Ex Soundgarden wrote:

> **
> Hi Axton,
>
> I'm not sure where David posted his reply from my question. When you say
> truncate table, this means that I would directly go to the db to delete
> records?
>
>
>
>
>  --
> *From:* Axton 
> *To:* arslist@ARSLIST.ORG
> *Sent:* Tue, December 8, 2009 7:06:37 PM
>
> *Subject:* Re: safest and fastest way to delete AR Email records
>
> ** Look into the sql 'truncate table' to empty it initially.  David has
> posted what you need for the ongoing maintenance of the data.  While doing
> the initial delete, you probably want to look at the email error logs form,
> the email attachments form, and all the other email forms.
>
>
> Axton
>
> On Tue, Dec 8, 2009 at 5:56 PM, Ex Soundgarden 
> wrote:
>
>> **
>>  Hi All,
>>
>> I've been wandering around searching for some tips on how to delete 3
>> million records sitting in AR System Email Messages form. What I''m doing
>> right now is just doing it by batch - deleting 10,000 records every now and
>> then. From the past, I remember doing it directly in the database by
>> re-creating the Email Messages table (which eventually dropped all the
>> records). I had no problem with this.
>>
>> I just want to know if there are other ways to delete the records without
>> going directly to the db?
>>
>> Thanks,
>> Gabud
>>
>>
>>
>> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
>> Are"_
>
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
>
>  _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

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

[Victor Olufowobi]

 Both AR database (Oracle) and the external database (MS SQL) are on
Windows 2003
 On Tue 08/12/09 20:13 , "Grooms, Frederick W"
frederick.w.gro...@xo.com sent:
The first question is what platform is your database on. 
FROM: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] ON BEHALF OF Victor Olufowobi
 SENT: Monday, December 07, 2009 9:14 AM
 TO: arslist@ARSLIST.ORG
 SUBJECT: View form to MS SQL database from Oracle based ARSystem 
Listers, 

I need to create view forms to MS SQL databese to be used by ARS 7.5
with Oracle database.
 Do I need to create linked server from Oracle Database or can I just
use available plugins from ARS (for example the one used by AIE)? 

Any link to relevant documentation will be appreciated 

Victor 

 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

CMDB Change stuck in Change Pending - Processing

[Tim Rondeau]

Running arsystem 7.1

Cmdb 2.0.1 patch 3



We have added several fields to the CMDB without issue, now the following is 
happening.



Once I add a field to CMDB, this happens to the arsystem.


Thu Dec 10 01:42:16 2009  390600 : AR System server terminated when a 
signal/exception was received by the server (ARNOTE 20)
Thu Dec 10 01:42:16 2009
   Timestamp: Thu Dec 10 2009 01:42:16.9430
   Thread Id: 4768
   Version: 7.1.00 Patch 007 200904160530 Apr 16 2009 06:46:41
   ServerName: mb-remapp01
   Database: SQL -- SQL Server
   Hardware: Intel Pentium
   OS: Windows NT 5.2
   RPC Id: 6895
   RPC Call: 11 (EXP)
   RPC Queue: 390600
   Client: User Remedy Application Service from Unidentified Client (protocol 
12) at IP address 10.198.100.94
   Form:
   Logging On:
   Code: c005
   Operation: read
   Access Addr: 0x5c
   Stack Begin:
  Addr: 012011D4
  Addr: 0124103F
  Addr: 0123792C
  Addr: 0149FE21
   Stack End

Thu Dec 10 01:42:16 2009  390600 : AR System server terminated when a 
signal/exception was received by the server (ARNOTE 20)
Thu Dec 10 01:42:16 2009 0xc005
Thu Dec 10 01:42:16 2009  390600 : AR System server terminated -- fatal error 
encountered (ARNOTE 21)







[cid:image002.png@01CA797B.06AF71E0]



[cid:image003.png@01CA797B.06AF71E0]



Has anyone seen this issue.



Thanks



Tim


_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
<><>

Re: Development Cache Mode revisited

[Walters, Mark]

You really need to be careful with development cache mode on production servers 
for the following reason;

With this option set the server has only one copy of the cache to work with.  
This may provide some advantages in terms of memory usage but consider the 
following..

A user starts a long running query, or a long running escalation kicks off.  In 
both of these cases the thread performing the work will place a flag against 
the cache to say that it is in use - effectively a read lock.  Now you make an 
admin change which requires exclusive use of the one cache that you have.  This 
exclusive lock cannot be obtained because the cache is in use so it is queued 
up and your admin thread is out of action until it gets the lock.  Not only 
that but any subsequent user API call that tries to get a read lock on the 
cache will fail because there is an outstanding exclusive lock request pending. 
 All of your users are locked out until the orginal activity completes and then 
the pending admin change is done.

Mark

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky
Sent: 10 December 2009 11:59
To: arslist@ARSLIST.ORG
Subject: Re: Development Cache Mode revisited

Hi,

Just to clarify.

This more or less proves that it is a BAD idea to have Cache-Mode set to
Development on any server in the Server-Group but the Admin-server.

The Admin-server seems to just patch in the modification directly in
memory. The other servers allways need to recache everything when a change
has occured.

If Dev-Cache-Mode is set on a server that rereads the whole cache, the
users need to wait until the operation is completed.

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

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

> Hi,
>
> We have now gone into production, and I have a couple of things I want to
> share about this...
>
> The two servers in the server-group are (now) 7.1.0 patch 008.
>
> We have ITSM7 instaleld.
>
> We can call the servers USER and ESCL, to indicate their major use.
>
> The final way we did it was to have the following setup, it is shown last
> in the last table below:
> USER, Cache-Mode=Dev, Admin
> ESCL, Cache-Mode=0
>
> These are results from various settings when an admin-change was applied.
>
> Server CacheMode AdminServer RecacheTime UserLockout RecacheMem StableMem
> USER   Dev   -   420 sec 420 sec 620Mb  620Mb
> ESCL   Dev   Admin   1 sec   1 sec   620Mb  620Mb
> (not good, as users got locked out)
>
> Server CacheMode AdminServer RecacheTime UserLockout RecacheMem StableMem
> USER   Dev   Admin   1 sec   1 sec   620Mb  620Mb
> ESCL   Normal-   550 sec 0 sec   1200Mb 620Mb
> (requires more memory on the ESCL-server)
>
> Note that if you import multiple things, as opposed to applying a small
> change, the 1-second lockout may be considerably higher.
>
>Best Regards - Misi, RRR AB, http://rrr.se
>
>> Yep.  If anyone is interested, p171 7.5 Config.
>>
>> When object definition changes are made to the administrative server in
>> a
>> server
>> group, other members of the group can be notified either by a signal or
>> by
>> a
>> database posting. With signaling, other servers are notified of changes
>> immediately, and there is no delay in resynchronization or updating
>> definitions.
>> The database method reduces server activity when object definition
>> changes
>> are
>> communicated between servers and is an effective way to reduce the
>> number
>> of
>> cache reloads when a series of changes are made, but there is a delay
>> before other
>> members of the server group pick up the changes.
>>
>> By default, AR System uses a combination of these methods for different
>> types of
>> updates in a server group. Server definition changes such as changes to
>> forms,
>> active links, filters, and escalations, as well as user group changes,
>> are
>> handled by
>> database posting. All other changes, such as Alert registration, DSO
>> activity, and
>> so on, are handled by signaling. However, you can configure the server
>> to
>> use
>> signaling for all changes including server object changes by following
>> the
>> procedure in this section.
>>
>> The configuration file setting Server-Group-Signal-Option tells the
>> server
>> whether to use arsignald for all signals, rather than using a
>> combination
>> of
>> signaling and database posting. If set to true (T), server object
>> changes
>> are
>> communicated by arsignald instead of database posting. Use this option
>> if
>> you
>> don?t want any delay in communicating server object changes to other
>>

Re: Development Cache Mode revisited

[Misi Mladoniczky]

Hi,

Just to clarify.

This more or less proves that it is a BAD idea to have Cache-Mode set to
Development on any server in the Server-Group but the Admin-server.

The Admin-server seems to just patch in the modification directly in
memory. The other servers allways need to recache everything when a change
has occured.

If Dev-Cache-Mode is set on a server that rereads the whole cache, the
users need to wait until the operation is completed.

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

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

> Hi,
>
> We have now gone into production, and I have a couple of things I want to
> share about this...
>
> The two servers in the server-group are (now) 7.1.0 patch 008.
>
> We have ITSM7 instaleld.
>
> We can call the servers USER and ESCL, to indicate their major use.
>
> The final way we did it was to have the following setup, it is shown last
> in the last table below:
> USER, Cache-Mode=Dev, Admin
> ESCL, Cache-Mode=0
>
> These are results from various settings when an admin-change was applied.
>
> Server CacheMode AdminServer RecacheTime UserLockout RecacheMem StableMem
> USER   Dev   -   420 sec 420 sec 620Mb  620Mb
> ESCL   Dev   Admin   1 sec   1 sec   620Mb  620Mb
> (not good, as users got locked out)
>
> Server CacheMode AdminServer RecacheTime UserLockout RecacheMem StableMem
> USER   Dev   Admin   1 sec   1 sec   620Mb  620Mb
> ESCL   Normal-   550 sec 0 sec   1200Mb 620Mb
> (requires more memory on the ESCL-server)
>
> Note that if you import multiple things, as opposed to applying a small
> change, the 1-second lockout may be considerably higher.
>
>Best Regards - Misi, RRR AB, http://rrr.se
>
>> Yep.  If anyone is interested, p171 7.5 Config.
>>
>> When object definition changes are made to the administrative server in
>> a
>> server
>> group, other members of the group can be notified either by a signal or
>> by
>> a
>> database posting. With signaling, other servers are notified of changes
>> immediately, and there is no delay in resynchronization or updating
>> definitions.
>> The database method reduces server activity when object definition
>> changes
>> are
>> communicated between servers and is an effective way to reduce the
>> number
>> of
>> cache reloads when a series of changes are made, but there is a delay
>> before other
>> members of the server group pick up the changes.
>>
>> By default, AR System uses a combination of these methods for different
>> types of
>> updates in a server group. Server definition changes such as changes to
>> forms,
>> active links, filters, and escalations, as well as user group changes,
>> are
>> handled by
>> database posting. All other changes, such as Alert registration, DSO
>> activity, and
>> so on, are handled by signaling. However, you can configure the server
>> to
>> use
>> signaling for all changes including server object changes by following
>> the
>> procedure in this section.
>>
>> The configuration file setting Server-Group-Signal-Option tells the
>> server
>> whether to use arsignald for all signals, rather than using a
>> combination
>> of
>> signaling and database posting. If set to true (T), server object
>> changes
>> are
>> communicated by arsignald instead of database posting. Use this option
>> if
>> you
>> don?t want any delay in communicating server object changes to other
>> servers in
>> the server group.
>>
>>
>> Tony Worthington | Sr. Technical Analyst | Kohl?s Department Stores
>> N56 W17000 Ridgewood Drive | Menomonee Falls, WI  53051 | office: (262)
>> 703-7763 | e-mail: tony.worthing...@kohls.com
>>
>>
>>
>> From:
>> Lyle Taylor 
>> To:
>> arslist@ARSLIST.ORG
>> Date:
>> 11/20/2009 03:13 PM
>> Subject:
>> Re: Development Cache Mode revisited
>> Sent by:
>> "Action Request System discussion list(ARSList)" 
>>
>>
>>
>> **
>> Concerning the other servers in the server group, the behavior is
>> discussed in one of the AR server guides, but I?m not sure which one
>> (it?s
>> been a while since I read it).  It probably wouldn?t be too hard to find
>> if needed.
>>
>> In a nutshell, though, each of the servers in the server group
>> periodically checks to see if the schema has been updated (or if new
>> groups have been added, etc.), and builds a new copy of the cache from
>> the
>> database when they see that it has changed.  If I recall correctly, the
>> polling frequency may be able to be configured in ar.conf, and it
>> doesn?t
>> immediately update once it notices a change.  Rather, it will wait until
>> something like two successive polling cycles have passed without
>> additional changes occurring before rebuildin

Resolved: Get result from stored procedure

[Conny Martin]

Frank,
 
great, it works.
 
Thank you for your assistance.
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Frank Caruso
Gesendet: Donnerstag, 10. Dezember 2009 11:32
An: arslist@ARSLIST.ORG
Betreff: Re: Get result from stored procedure


** 
I have created Functions in MS SQL that return values. You call them like this:
 
select fn_test 'param1','param2'
 
Specificy a return field for $1$.
 
For a Stored Procedure, to obtain the return result, which I am assuming will 
tell you whether or not the procedure succeeded or failed, put a select 
statement directly before the " return 1" statement. Select the value you would 
like returned. Then you call the proc from like this:
 
exec sp_testproc 'param1'
 
It might not be the correct way but it seems to work

 
On Thu, Dec 10, 2009 at 1:14 PM, David Morgan  wrote:


Hi Conny/Joe

Not sure if it helps but MS SQL doesn't require any helper table so 
where in Oracle you might use:-

   Select sysdate from dual ;

In MS-SQL you could use

   select getsysdate

Perhaps you can do something similar with your SP?

   Select sp


Failing that - you could use a sledgehammer to crack the nut and use a 
Java JDBC program to launch the SP and write out the result (ie use Java the 
Java program to "glue" the two together?)

ARS   <-- Java program -->   JDBC   <-- Database (Oracle/SQL 
SERVER/SYBASE/INFORMIX etc)

Regards
Dave Morgan


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza
Sent: 10 December 2009 11:05
To: arslist@ARSLIST.ORG
Subject: Re: Get result from stored procedure

There is a small difference on how you call stored procedures while 
using
either the direct SQL or the set field SQL feature from the ARS at 
least as
far as Oracle is concerned.. When using the Oracle client SQL*Plus, 
Execute
 works, but from the ARS interface for SQL, EXECUTE 
doesn't
work. This I believe is because the ARS does not use the extended set 
of the
database API that SQL*Plus uses.

So in Oracle instead of using EXECUTE you use BEGIN. However no error is
returned if you use EXECUTE. It just ignores it and doesn't do anything.

I'm guessing your problem with MS-SQL is something similar.. Only I'm 
not
sure if Begin would be the right keyword to execute a SP if the 
underlying
DB is MS-SQL..

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Conny Martin
Sent: Thursday, December 10, 2009 4:48 AM
To: arslist@ARSLIST.ORG
Subject: AW: Get result from stored procedure


Joe,

I'm calling it the same way as in Query Analyzer.

declare @p_result int
exec SP_TEST 'MDP00072713', @p_result output
select @p_result

No Errormessage is returned but $1$ doesn't get the value from p_result

With oracle there is no problem. One can just do
select sp_test('MDP00072713') from dual
but I don't know the correct syntax for MS-SQL.

Kind Regards Conny

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Joe D'Souza
Gesendet: Donnerstag, 10. Dezember 2009 10:32
An: arslist@ARSLIST.ORG
Betreff: Re: Get result from stored procedure

Conny,

Yes it is possible.. how are you calling/executing the stored procedure 
when
you are using it in the set-field-SQL?

Begin ;
works from the ARS with Oracle as the backend DB.. (I'm not 100% 
certain if
you need the semi colon in the end)

I'm not sure if that would work with MS-SQL as well but you could try 
that..

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Conny Martin
Sent: Thursday, December 10, 2009 3:08 AM
To: arslist@ARSLIST.ORG
Subject: Get result from stored procedure


All,

Not sure if this is possible, but is there a way to get the results 
from a
stored procedure via set-field-SQL into ars.

This works in Query-Analyzer

declare @p_result int
exec SP_TEST 'MDP00072713', @p_result o

Re: Get result from stored procedure

[Frank Caruso]

I have created Functions in MS SQL that return values. You call them like
this:

select fn_test 'param1','param2'

Specificy a return field for $1$.

For a Stored Procedure, to obtain the return result, which I am assuming
will tell you whether or not the procedure succeeded or failed, put a select
statement directly before the " return 1" statement. Select the value you
would like returned. Then you call the proc from like this:

exec sp_testproc 'param1'

It might not be the correct way but it seems to work


On Thu, Dec 10, 2009 at 1:14 PM, David Morgan wrote:

> Hi Conny/Joe
>
> Not sure if it helps but MS SQL doesn't require any helper table so where
> in Oracle you might use:-
>
>Select sysdate from dual ;
>
> In MS-SQL you could use
>
>select getsysdate
>
> Perhaps you can do something similar with your SP?
>
>Select sp
>
>
> Failing that - you could use a sledgehammer to crack the nut and use a Java
> JDBC program to launch the SP and write out the result (ie use Java the Java
> program to "glue" the two together?)
>
> ARS   <-- Java program -->   JDBC   <-- Database (Oracle/SQL
> SERVER/SYBASE/INFORMIX etc)
>
> Regards
> Dave Morgan
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList) [mailto:
> arsl...@arslist.org] On Behalf Of Joe D'Souza
> Sent: 10 December 2009 11:05
> To: arslist@ARSLIST.ORG
> Subject: Re: Get result from stored procedure
>
> There is a small difference on how you call stored procedures while using
> either the direct SQL or the set field SQL feature from the ARS at least as
> far as Oracle is concerned.. When using the Oracle client SQL*Plus, Execute
>  works, but from the ARS interface for SQL, EXECUTE doesn't
> work. This I believe is because the ARS does not use the extended set of
> the
> database API that SQL*Plus uses.
>
> So in Oracle instead of using EXECUTE you use BEGIN. However no error is
> returned if you use EXECUTE. It just ignores it and doesn't do anything.
>
> I'm guessing your problem with MS-SQL is something similar.. Only I'm not
> sure if Begin would be the right keyword to execute a SP if the underlying
> DB is MS-SQL..
>
> Joe
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org]on Behalf Of Conny Martin
> Sent: Thursday, December 10, 2009 4:48 AM
> To: arslist@ARSLIST.ORG
> Subject: AW: Get result from stored procedure
>
>
> Joe,
>
> I'm calling it the same way as in Query Analyzer.
>
> declare @p_result int
> exec SP_TEST 'MDP00072713', @p_result output
> select @p_result
>
> No Errormessage is returned but $1$ doesn't get the value from p_result
>
> With oracle there is no problem. One can just do
> select sp_test('MDP00072713') from dual
> but I don't know the correct syntax for MS-SQL.
>
> Kind Regards Conny
>
> -Ursprüngliche Nachricht-
> Von: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] Im Auftrag von Joe D'Souza
> Gesendet: Donnerstag, 10. Dezember 2009 10:32
> An: arslist@ARSLIST.ORG
> Betreff: Re: Get result from stored procedure
>
> Conny,
>
> Yes it is possible.. how are you calling/executing the stored procedure
> when
> you are using it in the set-field-SQL?
>
> Begin ;
> works from the ARS with Oracle as the backend DB.. (I'm not 100% certain if
> you need the semi colon in the end)
>
> I'm not sure if that would work with MS-SQL as well but you could try
> that..
>
> Joe
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org]on Behalf Of Conny Martin
> Sent: Thursday, December 10, 2009 3:08 AM
> To: arslist@ARSLIST.ORG
> Subject: Get result from stored procedure
>
>
> All,
>
> Not sure if this is possible, but is there a way to get the results from a
> stored procedure via set-field-SQL into ars.
>
> This works in Query-Analyzer
>
> declare @p_result int
> exec SP_TEST 'MDP00072713', @p_result output select @p_result
>
> But in a set-fields-SQL $1$ is always null.
>
> ARS 7.1p6
> MSSQL 2005
> W2K3 Enterprise Server
>
> Any help is really appreciated.
>
> Thanks
>
> Conny
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum 
> Sponsor:rmisoluti...@verizon.netARSlist: 
> "Where the Answers Are"
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum 
> Sponsor:rmisoluti...@verizon.netARSlist: 
> "Where the Answers Are"
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Get result from stored procedure

[David Morgan]

Hi Conny/Joe

Not sure if it helps but MS SQL doesn't require any helper table so where in 
Oracle you might use:-

Select sysdate from dual ;

In MS-SQL you could use 

select getsysdate

Perhaps you can do something similar with your SP?

Select sp


Failing that - you could use a sledgehammer to crack the nut and use a Java 
JDBC program to launch the SP and write out the result (ie use Java the Java 
program to "glue" the two together?)

ARS   <-- Java program -->   JDBC   <-- Database (Oracle/SQL 
SERVER/SYBASE/INFORMIX etc)

Regards
Dave Morgan


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza
Sent: 10 December 2009 11:05
To: arslist@ARSLIST.ORG
Subject: Re: Get result from stored procedure

There is a small difference on how you call stored procedures while using
either the direct SQL or the set field SQL feature from the ARS at least as
far as Oracle is concerned.. When using the Oracle client SQL*Plus, Execute
 works, but from the ARS interface for SQL, EXECUTE doesn't
work. This I believe is because the ARS does not use the extended set of the
database API that SQL*Plus uses.

So in Oracle instead of using EXECUTE you use BEGIN. However no error is
returned if you use EXECUTE. It just ignores it and doesn't do anything.

I'm guessing your problem with MS-SQL is something similar.. Only I'm not
sure if Begin would be the right keyword to execute a SP if the underlying
DB is MS-SQL..

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Conny Martin
Sent: Thursday, December 10, 2009 4:48 AM
To: arslist@ARSLIST.ORG
Subject: AW: Get result from stored procedure


Joe,

I'm calling it the same way as in Query Analyzer.

declare @p_result int
exec SP_TEST 'MDP00072713', @p_result output 
select @p_result

No Errormessage is returned but $1$ doesn't get the value from p_result

With oracle there is no problem. One can just do
select sp_test('MDP00072713') from dual
but I don't know the correct syntax for MS-SQL.

Kind Regards Conny

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Joe D'Souza
Gesendet: Donnerstag, 10. Dezember 2009 10:32
An: arslist@ARSLIST.ORG
Betreff: Re: Get result from stored procedure

Conny,

Yes it is possible.. how are you calling/executing the stored procedure when
you are using it in the set-field-SQL?

Begin ;
works from the ARS with Oracle as the backend DB.. (I'm not 100% certain if
you need the semi colon in the end)

I'm not sure if that would work with MS-SQL as well but you could try that..

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Conny Martin
Sent: Thursday, December 10, 2009 3:08 AM
To: arslist@ARSLIST.ORG
Subject: Get result from stored procedure


All,

Not sure if this is possible, but is there a way to get the results from a
stored procedure via set-field-SQL into ars.

This works in Query-Analyzer

declare @p_result int
exec SP_TEST 'MDP00072713', @p_result output select @p_result

But in a set-fields-SQL $1$ is always null.

ARS 7.1p6
MSSQL 2005
W2K3 Enterprise Server

Any help is really appreciated.

Thanks

Conny

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Get result from stored procedure

[Joe D'Souza]

There is a small difference on how you call stored procedures while using
either the direct SQL or the set field SQL feature from the ARS at least as
far as Oracle is concerned.. When using the Oracle client SQL*Plus, Execute
 works, but from the ARS interface for SQL, EXECUTE doesn't
work. This I believe is because the ARS does not use the extended set of the
database API that SQL*Plus uses.

So in Oracle instead of using EXECUTE you use BEGIN. However no error is
returned if you use EXECUTE. It just ignores it and doesn't do anything.

I'm guessing your problem with MS-SQL is something similar.. Only I'm not
sure if Begin would be the right keyword to execute a SP if the underlying
DB is MS-SQL..

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Conny Martin
Sent: Thursday, December 10, 2009 4:48 AM
To: arslist@ARSLIST.ORG
Subject: AW: Get result from stored procedure


Joe,

I'm calling it the same way as in Query Analyzer.

declare @p_result int
exec SP_TEST 'MDP00072713', @p_result output 
select @p_result

No Errormessage is returned but $1$ doesn't get the value from p_result

With oracle there is no problem. One can just do
select sp_test('MDP00072713') from dual
but I don't know the correct syntax for MS-SQL.

Kind Regards Conny

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Joe D'Souza
Gesendet: Donnerstag, 10. Dezember 2009 10:32
An: arslist@ARSLIST.ORG
Betreff: Re: Get result from stored procedure

Conny,

Yes it is possible.. how are you calling/executing the stored procedure when
you are using it in the set-field-SQL?

Begin ;
works from the ARS with Oracle as the backend DB.. (I'm not 100% certain if
you need the semi colon in the end)

I'm not sure if that would work with MS-SQL as well but you could try that..

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Conny Martin
Sent: Thursday, December 10, 2009 3:08 AM
To: arslist@ARSLIST.ORG
Subject: Get result from stored procedure


All,

Not sure if this is possible, but is there a way to get the results from a
stored procedure via set-field-SQL into ars.

This works in Query-Analyzer

declare @p_result int
exec SP_TEST 'MDP00072713', @p_result output select @p_result

But in a set-fields-SQL $1$ is always null.

ARS 7.1p6
MSSQL 2005
W2K3 Enterprise Server

Any help is really appreciated.

Thanks

Conny

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

AW: Get result from stored procedure

[Conny Martin]

Joe,

I'm calling it the same way as in Query Analyzer.

declare @p_result int
exec SP_TEST 'MDP00072713', @p_result output 
select @p_result

No Errormessage is returned but $1$ doesn't get the value from p_result

With oracle there is no problem. One can just do
select sp_test('MDP00072713') from dual
but I don't know the correct syntax for MS-SQL.

Kind Regards Conny

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Joe D'Souza
Gesendet: Donnerstag, 10. Dezember 2009 10:32
An: arslist@ARSLIST.ORG
Betreff: Re: Get result from stored procedure

Conny,

Yes it is possible.. how are you calling/executing the stored procedure when 
you are using it in the set-field-sql?

Begin ;
works from the ARS with Oracle as the backend DB.. (I'm not 100% certain if you 
need the semi colon in the end)

I'm not sure if that would work with MS-SQL as well but you could try that..

Joe

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org]on Behalf Of Conny Martin
Sent: Thursday, December 10, 2009 3:08 AM
To: arslist@ARSLIST.ORG
Subject: Get result from stored procedure


All,

Not sure if this is possible, but is there a way to get the results from a 
stored procedure via set-field-sql into ars.

This works in Query-Analyzer

declare @p_result int
exec SP_TEST 'MDP00072713', @p_result output select @p_result

But in a set-fields-sql $1$ is always null.

ARS 7.1p6
MSSQL 2005
W2K3 Enterprise Server

Any help is really appreciated.

Thanks

Conny

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum 
Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Get result from stored procedure

[Joe D'Souza]

Conny,

Yes it is possible.. how are you calling/executing the stored procedure when
you are using it in the set-field-sql?

Begin ;
works from the ARS with Oracle as the backend DB.. (I'm not 100% certain if
you need the semi colon in the end)

I'm not sure if that would work with MS-SQL as well but you could try that..

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Conny Martin
Sent: Thursday, December 10, 2009 3:08 AM
To: arslist@ARSLIST.ORG
Subject: Get result from stored procedure


All,

Not sure if this is possible, but is there a way to get the results from a
stored procedure via set-field-sql into ars.

This works in Query-Analyzer

declare @p_result int
exec SP_TEST 'MDP00072713', @p_result output
select @p_result

But in a set-fields-sql $1$ is always null.

ARS 7.1p6
MSSQL 2005
W2K3 Enterprise Server

Any help is really appreciated.

Thanks

Conny

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

BMC Atrium Core widgets

[honormine]

I followed the steps on the BMC Atrium CMDB 7.5.00 Administrator's Guide(Page
161) and created a Data Visualization Field,From the Definition list,I
selected the Atrium Explorer,I set "  "namespace=" + "BMC.CORE") +
",classname=") + $Name$) + ",datasetid=") + $DatasetId$) + ",instanceid=") +
$InstanceId$) + ",filtername=") + “Components and Dependencies” " into it ,
it worked.
Now I wanted to choose the Atrirm Topology type and show the Topology,which
elements should I set
-- 
View this message in context: 
http://old.nabble.com/BMC-Atrium-Core-widgets-tp26723875p26723875.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: CMDB mapping question: dependency vs. component

[Peter Romain]

One point about Impact relationships - BMC plans to drop them!

The base relationship class now includes impact information.

In the future any relationship will be able to hold impact information
which should reduce the number of relationship CIs needed to model an
environment.

Cheers

Peter



> When we were mapping that out, we made Remedy be a SoftwareServer.  We
> also included SoftwareServers for the database servers (the database
> software, not the hardware) and made the Databases depend on the Software
> Servers.  But then, we were tracking more information about databases in
> general.  If you don't care about what software database servers are
> hosting what database instances but rather just the host the database is
> on, then you're probably fine doing it the way you have or like Shawn did.
>
> As far as the relationship types, I would go with Dependency and/or
> Impact.  I'm not sure you can even make some of them components - I think
> that that requires that the child class be a subclass of SystemComponent.
>
> Lyle
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Martinez, Marcelo A
> Sent: Tuesday, December 08, 2009 3:55 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: CMDB mapping question: dependency vs. component
>
> Shawn,
> Thanks for the image. It helps!
> The reason I (or better said - my boss) wants to include the exchange
> server and DC is because IF the DC or Exch servers was to be rebooted,
> this way would list all the "application systems" that the reboot is
> affecting.. But I do see what you mean, the view can get obnoxiously full.
>
> As far as the DB server and database, your example makes sense. I need to
> relate the application to the database, not necessarily to the DB server.
> Then relate the database to the DB server... I'll need to run this pass
> the boss.
>
> One question: what class did you use to load "Remedy Production ARSystem"?
> did you use BMC_ApplicationSystem or just BMC_Application? (I think
> ApplicationSystem is the superclass of Application)
>
> Thanks again Shawn.
>
> Marcelo Martinez
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn
> Sent: Tuesday, December 08, 2009 4:27 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: CMDB mapping question: dependency vs. component
>
> Marcelo,
>
> I hope this image of my layout helps.  Basically, I think you are using
> the correct classes, but I don't know that I would put everything you are
> putting there.  For example, do you really need to list the Exchange
> Server and Domain Controller?  They are sort of implied, and you may not
> want to list it and risk making either the Remedy view or the Domain
> Controller's views too full.
>
> Also, if you look at my layout, I built dependencies between the Remedy
> Application with the database, and the database with the SQL Server, but I
> did not relate the Remedy Application with the DB Server.
>
> Thanks,
>
> Shawn Pierson
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Martinez, Marcelo A
> Sent: Tuesday, December 08, 2009 3:27 PM
> To: arslist@ARSLIST.ORG
> Subject: CMDB mapping question: dependency vs. component
>
> I'm mapping out a few "critical systems" in my CMDB and wanted some input.
>
> Remedy System: BMC_ApplicaitonSystem
> Rem001 Server: BMC_ComputerSystem - Component of Remedy System
> SQL0001 Server: BMC_ComputerSystem - Component of Remedy System (or is
> this a Dependency??) ARSystem database: BMC_Database - Component of Remedy
> System Exchange Server: BMC_ComputerSystem - Dependency of Remedy System
> DomainController:  BMC_ComputerSystem - Dependency of Remedy System
>
> Does this make sense? Or am I mapping it all wrong? Also what is a good
> naming convention for relationships: RemSysComp01, RemSysDepen01??
>
> I am doing this manually because I do not know how/where to mass relate
> these items. I have about 2000 CIs in Computer systems form.
>
> Specs:
> CMDB: 2.1.00
> ARS: 7.1.00
> ITSM 7.0.03
>
> Thanks,,
> Marcelo Martinez
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum
> Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
>
> Private and confidential as detailed here:
> http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the
> link, please e-mail sender.
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum
> Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.n

Re: Development Cache Mode revisited

[Misi Mladoniczky]

Hi,

We have now gone into production, and I have a couple of things I want to
share about this...

The two servers in the server-group are (now) 7.1.0 patch 008.

We have ITSM7 instaleld.

We can call the servers USER and ESCL, to indicate their major use.

The final way we did it was to have the following setup, it is shown last
in the last table below:
USER, Cache-Mode=Dev, Admin
ESCL, Cache-Mode=0

These are results from various settings when an admin-change was applied.

Server CacheMode AdminServer RecacheTime UserLockout RecacheMem StableMem
USER   Dev   -   420 sec 420 sec 620Mb  620Mb
ESCL   Dev   Admin   1 sec   1 sec   620Mb  620Mb
(not good, as users got locked out)

Server CacheMode AdminServer RecacheTime UserLockout RecacheMem StableMem
USER   Dev   Admin   1 sec   1 sec   620Mb  620Mb
ESCL   Normal-   550 sec 0 sec   1200Mb 620Mb
(requires more memory on the ESCL-server)

Note that if you import multiple things, as opposed to applying a small
change, the 1-second lockout may be considerably higher.

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

> Yep.  If anyone is interested, p171 7.5 Config.
>
> When object definition changes are made to the administrative server in a
> server
> group, other members of the group can be notified either by a signal or by
> a
> database posting. With signaling, other servers are notified of changes
> immediately, and there is no delay in resynchronization or updating
> definitions.
> The database method reduces server activity when object definition changes
> are
> communicated between servers and is an effective way to reduce the number
> of
> cache reloads when a series of changes are made, but there is a delay
> before other
> members of the server group pick up the changes.
>
> By default, AR System uses a combination of these methods for different
> types of
> updates in a server group. Server definition changes such as changes to
> forms,
> active links, filters, and escalations, as well as user group changes, are
> handled by
> database posting. All other changes, such as Alert registration, DSO
> activity, and
> so on, are handled by signaling. However, you can configure the server to
> use
> signaling for all changes including server object changes by following the
> procedure in this section.
>
> The configuration file setting Server-Group-Signal-Option tells the server
> whether to use arsignald for all signals, rather than using a combination
> of
> signaling and database posting. If set to true (T), server object changes
> are
> communicated by arsignald instead of database posting. Use this option if
> you
> don?t want any delay in communicating server object changes to other
> servers in
> the server group.
>
>
> Tony Worthington | Sr. Technical Analyst | Kohl?s Department Stores
> N56 W17000 Ridgewood Drive | Menomonee Falls, WI  53051 | office: (262)
> 703-7763 | e-mail: tony.worthing...@kohls.com
>
>
>
> From:
> Lyle Taylor 
> To:
> arslist@ARSLIST.ORG
> Date:
> 11/20/2009 03:13 PM
> Subject:
> Re: Development Cache Mode revisited
> Sent by:
> "Action Request System discussion list(ARSList)" 
>
>
>
> **
> Concerning the other servers in the server group, the behavior is
> discussed in one of the AR server guides, but I?m not sure which one (it?s
> been a while since I read it).  It probably wouldn?t be too hard to find
> if needed.
>
> In a nutshell, though, each of the servers in the server group
> periodically checks to see if the schema has been updated (or if new
> groups have been added, etc.), and builds a new copy of the cache from the
> database when they see that it has changed.  If I recall correctly, the
> polling frequency may be able to be configured in ar.conf, and it doesn?t
> immediately update once it notices a change.  Rather, it will wait until
> something like two successive polling cycles have passed without
> additional changes occurring before rebuilding its local cache.  That way,
> it?s less likely to do an update in the middle of a set of changes.
>
> If Dev Cache Mode is turned off on the other servers in the group, and
> users are logged into those servers, users will continue to use the old
> copy of the cache until they log out and back in again.  Note that this
> means that, depending on the frequency of changes (including adding new
> Remedy group or ITSM Support Groups), this can be a significant source of
> memory usage on the server.  We have run out of memory and had the server
> crash in the past due to creating several new Support Groups throughout
> the day, and each one causing yet another copy of the cache to be held in
> memory for the people that logged in since the last time it was updated.
> This is even more of an issue if people don?t log out correctly (e.g., if
> they?re using the mid-tier and simply close their browser window without
> logging out), as the system will NOT log them out automatically, e

Get result from stored procedure

[Conny Martin]

All,

Not sure if this is possible, but is there a way to get the results from
a stored procedure via set-field-sql into ars.

This works in Query-Analyzer

declare @p_result int 
exec SP_TEST 'MDP00072713', @p_result output 
select @p_result

But in a set-fields-sql $1$ is always null.

ARS 7.1p6
MSSQL 2005
W2K3 Enterprise Server

Any help is really appreciated.

Thanks

Conny

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"