Re: Is it Possible to Install ITSM in HyperV-Virtual Environment !
Thanks a ton Dear Jason, thanks for circulating your wonderful info and/ experience, which offers me a strapping design to move ahead. Thanks and Regards, Kailashnath A J From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller Sent: Friday, March 11, 2011 11:10 PM To: arslist@ARSLIST.ORG Subject: Re: Is it Possible to Install ITSM in HyperV-Virtual Environment ! ** We did work with BMC on some issues with AIE 7.6 patch 2 (we have a hot fix build now). We did the troubleshooting on the Hyper-V test environment and the subject of physical/virtual never came up. I imagine if there is an issue that completely stumps them they may ask for more details about the environment. Jason On Fri, Mar 11, 2011 at 4:40 AM, Kailashnath A J kailashnath.jeya...@wipro.com wrote: ** Dear Jason, Thanks a lot for sharing your practice in a way that precisely helps me, and I would like you to elucidate one more query, according to BMC, the Hyper-V falls under Partially Supported Virtual Environments and by any chance have you faced any such BMC issues specific to the Virtual Environment, please share it if any. Hope with your amplification I could advance sound. Thanks and Regards, Kailashnath A J From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller Sent: Friday, March 11, 2011 1:40 AM To: arslist@ARSLIST.ORG Subject: Re: Is it Possible to Install ITSM in HyperV-Virtual Environment ! ** Kailashnath, The OS and application are the same no matter if installed on server hardware directly or virtual, installed on Hyper-V or VMware. Our test ITSM 7.6 system is on Hyper-V and production is on VMware ESX (the prod db server is physical though). Users access ITSM by connecting to the Mid-Tier server with their web browser. The same is true for using the Windows User Tool and Developer Studio, we just connect to the application server instead. It works very well. There is a quote from the 7.6.03 beta I see come up occasionally regarding the speed of the first ITSM Preconfigured Suite Stack Installer. That performance (installed in less than an hour) was experienced on a single Hyper-V / Windows 2008 R2 server (app/db/web) that was underpowered for I was asking of it. Granted that was for installing and not under user load, the point being there really is no functional difference between hardware or virtual. Hope that helps, Jason On Wed, Mar 9, 2011 at 3:46 AM, Kailashnath A J kailashnath.jeya...@wipro.com wrote: ** Hi Folks, I would like you to share your experience of installation of BMC Remedy with BMC Service Desk on a HyperV-Virtual environment? If so, how the end users will be accessing the console to raise a request? Kindly clarify. Thanks and Regards, Kailashnath A J Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please
Re: Is it Possible to Install ITSM in HyperV-Virtual Environment !
Dear David, Thanks for updating me on latest compatibility matrix. Thanks and Regards, Kailashnath A J From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Easter, David Sent: Friday, March 11, 2011 11:49 PM To: arslist@ARSLIST.ORG Subject: Re: Is it Possible to Install ITSM in HyperV-Virtual Environment ! ** Ø , according to BMC, the Hyper-V falls under Partially Supported Virtual Environments Hyper-V actually falls under Fully Supported Virtual Environments in AR System 7.6.0x... Please refer to the latest compatibility matrix. http://media.cms.bmc.com/documents/AR+System+7.6.04+Compatibility+Matrix.pdf -David J. Easter Manager of Product Management, Remedy Platform BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kailashnath A J Sent: Friday, March 11, 2011 04:41 AM To: arslist@ARSLIST.ORG Subject: Re: Is it Possible to Install ITSM in HyperV-Virtual Environment ! ** Dear Jason, Thanks a lot for sharing your practice in a way that precisely helps me, and I would like you to elucidate one more query, according to BMC, the Hyper-V falls under Partially Supported Virtual Environments and by any chance have you faced any such BMC issues specific to the Virtual Environment, please share it if any. Hope with your amplification I could advance sound. Thanks and Regards, Kailashnath A J From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller Sent: Friday, March 11, 2011 1:40 AM To: arslist@ARSLIST.ORG Subject: Re: Is it Possible to Install ITSM in HyperV-Virtual Environment ! ** Kailashnath, The OS and application are the same no matter if installed on server hardware directly or virtual, installed on Hyper-V or VMware. Our test ITSM 7.6 system is on Hyper-V and production is on VMware ESX (the prod db server is physical though). Users access ITSM by connecting to the Mid-Tier server with their web browser. The same is true for using the Windows User Tool and Developer Studio, we just connect to the application server instead. It works very well. There is a quote from the 7.6.03 beta I see come up occasionally regarding the speed of the first ITSM Preconfigured Suite Stack Installer. That performance (installed in less than an hour) was experienced on a single Hyper-V / Windows 2008 R2 server (app/db/web) that was underpowered for I was asking of it. Granted that was for installing and not under user load, the point being there really is no functional difference between hardware or virtual. Hope that helps, Jason On Wed, Mar 9, 2011 at 3:46 AM, Kailashnath A J kailashnath.jeya...@wipro.com wrote: ** Hi Folks, I would like you to share your experience of installation of BMC Remedy with BMC Service Desk on a HyperV-Virtual environment? If so, how the end users will be accessing the console to raise a request? Kindly clarify. Thanks and Regards, Kailashnath A J Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this
Re: Urgent please help! how to refresh table using filters
You can tirgger Active Link using Events from Filter and use Change Field Action in Active Link to refresh the table. Thanks, Bala Date: Sun, 13 Mar 2011 22:49:01 + From: mestr...@blizzard.com Subject: Urgent please help! how to refresh table using filters To: arslist@ARSLIST.ORG Thanks in advance. Having email update a back end table, then call filter guide to check data in columns in table. Need to refresh the table before filter call guide to loop thru all rows. Thanks, ~Mary ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Senior SRM Consultant 6 Months North America
Dear All I need an experienced senior ITSM SRM consultant for a 6 month assignment in North America. You will be responsible for designing, implementing and customising the latest SRM module. You must be an American Citizen and be flexible in terms of working location. If you would like more information on this please contact me on the below details. Greg Park Business Development Manager Fusion Business Solutions (UK) Ltd Tel: +44 (0) 208 814 6194 Mob: +44 (0) 7815 576 613 www.fusion.co.uk http://www.fusion.co.uk/ Fusion is the largest consultancy in Europe that focuses exclusively on BMC Software solutions ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Urgent : Memory allocation to ARS process
Hello List, I find 2GB as standard memory allocation to ARS process, could you please suggest how to increase this memory allocation. Regards Manish ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
MidTier and Rich Text
In the client (we are using 7.5 p7) if you put a URL in a field it automatically makes it a clickable link, but in the MidTier is does not do this. Is there a reason why? Or is this just happening with us? Lisa Kemes AR System Developer +01 717 810 2408 tel +01 717 602 9460 mobile lisa.ke...@te.commailto:lisa.ke...@te.com [http://www-qa.tycoelectronics.com/images/socialmedia/smallTElogo.gif]http://www-qa.tycoelectronics.com/ www.te.comhttp://www.te.com/ [http://www.tycoelectronics.com/images/socialmedia/twitter.png]http://twitter.com/tycoelectronics/[http://www.tycoelectronics.com/images/socialmedia/facebook.png]http://facebook.com/tycoelectronics/[http://www.tycoelectronics.com/images/socialmedia/flickr.png]http://www.flickr.com/photos/tycoelectronics/[http://www.tycoelectronics.com/images/socialmedia/linkedin.png]http://www.linkedin.com/groups?gid=1591657[http://www.tycoelectronics.com/images/socialmedia/youtube.png]http://www.youtube.com/tycoelectronics/ This email transmission (and any of its attachments) may contain confidential, proprietary and/or privileged information. The sender intends this transmission only for the designated recipient(s). If you are not a designated recipient (or authorized to receive for a designated recipient), you are hereby notified that the disclosure, copying, distribution or use of any of the information contained in this transmission is strictly prohibited. If you have received this transmission in error, please destroy this message, delete any copies which may exist on your system and notify the sender immediately. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Using DSO to sync two AR Servers
It truly depends upon the complete requirements. I've used DSO for data replication (foundation) as well as ticketing replication quite successfully in near time synch. As you might imagine, to circumvent a DSO Overload - I implemented a queuing mechanism because of what I term ticket stabilization immediately after submit. As you can think, a ticket gets Created, then many Updates occur to said ticket, and if simply implemented as a DSO Operation, that same ticket will get transferred multiple times, thus we build in a queue and waited about 5 minutes (configurable based upon ticket priority) prior to sending to the remote servers. We were keeping 3 global servers in synch... If you are using the remote server more as a reporting or DR type server - and NO ticket entry/update will be performed (unless DR is in effect) - then utilize other methods of sync - such as RRR / Database Replication (is this Oracle, SQL, etc?)... If this is a Live / Live setup as was mine - DSO certainly worked like a champ. HTH Robert Molenda On Fri, Mar 11, 2011 at 9:20 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, For archiving and copying data to a reporting server, I would recommend RRR|Chive. It is fast, robust and foolproof, and will keep modify-dates and request ids synchronized. It does not require any DSO-fields. When you need 2-way synchronization, I would go for DSO or database replication of some kind. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): * 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. Vikram, I worked at a company that used DSO for exactly what you are discussing, used to archive things off of production to a reporting server, and make that reporting server 'real time'it was a good solution for us at the time, but looking back, I wouldn't do it again. The DSO engine is NOT intended for data replication, as others have mentioned...it's really intended for follow the sun operations, as such its throughput is relatively slow for the task you are looking to do. We are embarking on a similar initiative at my current company and we are opting to go with db replication. Replication comes with its own set of baggage, but I believe that baggage is manageable. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of vikram_k Sent: Friday, March 11, 2011 3:12 AM To: arslist@ARSLIST.ORG Subject: Using DSO to sync two AR Servers Hi listers, Greetings, I have a new challenge thrown at me.. now the performance of the system is good enough (if you remember my tiring question about ARS performance and huge queries) now I have been asked to find a way to keep 2 application servers in sync at real time. And what I could think of is to introduce DSO to into the picture. So here it goes: 1) Is it best to use DSO to keep 2 Application servers in sync all real time. 2) Both the application servers are replicas of each other but geographically located. 3) The ARS application is completely customized with 350+ forms to be managed in sync. 4) Also DSO is to be used to archive data from one of the servers into the other which will be used as just an read only reporting server. 5) Both the servers are ARS 5.0.1 :) So I would really appreciate if you can help me through this as well as you did in my previous endavour. My questions : 1) Is it reliabe to use DSO in this big context? 2) What all factors do I have to keep my eyes on while doing this? 3) What is the performance hit that if at all one can expect? 4) Any specific setting that can be implemented to keep the performance up? I guess this is a nice learing experience for someone like me and would like any help possible from you guys. Thanks in advance Regards, Vikram. -- View this message in context: http://old.nabble.com/Using-DSO-to-sync-two-AR-Servers-tp31123715p31123715.h tml Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Issue with a report
The full qual that I am trying is '3'=$Start Date$ and '3'=$End Date$+86399
and '101029'=$Sent From Person$
I want all the records created within a date range by a person. e.g., All
records created from 1/1/11 - 4/1/11 by cpargete
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Roehr, Mario
Sent: Saturday, March 12, 2011 12:52 AM
To: arslist@ARSLIST.ORG
Subject: AW: Issue with a report
**
Christie,
I'm wondering if this could be a valid qualification:
'Submit Date' = $Start Date$
That means `Submit Date` would be later as the `Start Date`, but Submit Date in
the most cases is the earliest Timestamp as it was set when you submitted the
record (eg. Click on the Save button)
Mario
Von: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] Im Auftrag von Pargeter, Christie :CO IS
Gesendet: Samstag, 12. März 2011 00:50
An: arslist@ARSLIST.ORG
Betreff: Re: Issue with a report
**
There are no errors in Crystal Reports or the User Tool when I try the report
only on the web. I did try recreating at one point to use the underscores
incase that was the issue. But the really odd point to me is that if I run the
report with any quals it works but if I add '3'=1/1/11 I get the error.
I tried to add the report to the Reporting Console and to select the Submit
Date and just that field and I still get the error.
From: kimberly.sant...@oracle.com santana [mailto:kimberly.sant...@oracle.com]
Sent: Friday, March 11, 2011 3:43 PM
To: arslist@ARSLIST.ORG
Cc: Pargeter, Christie :CO IS
Subject: Re: Issue with a report
I am curious to know when you refresh the report in crystal reports are you
getting any errors ?
I am noticing that your qualification does not use underscores but the crystal
report field is using underscores..
How do you have our odbc set up? to use underscores or not to use underscores?
Kimberly
On 3/11/2011 9:58 AM, Pargeter, Christie :CO IS wrote:
**
When I look in Crystal Report it is there. Also, this report works in the user
tool as designed (with the external field) but not in the web.
From: kimberly.sant...@oracle.com santana [mailto:kimberly.sant...@oracle.com]
Sent: Thursday, March 10, 2011 8:37 PM
To: arslist@ARSLIST.ORG
Cc: Pargeter, Christie :CO IS
Subject: Re: Issue with a report
Did you check to make sure that this field 'ARSYS_SERIAL_QUAL_COLUMN' is on
the form NTE_Notifier_Log?
Kimberly
On 3/10/2011 7:24 PM, Pargeter, Christie :CO IS wrote:
**
I am trying to build a report against the NTE:Notifier Log screen and if I put
any quals on the Active Link I get
This field name is not known. Details: errorKind Error in File
C:\WINDOWS\TEMP\CLUserHistory {200BA716-D86C-4D45-9F30-0913A657F293}.rpt: Error
in formula . '{NTE_Notifier_Log.ARSYS_SERIAL_QUAL_COLUMN}
4\3\1\3\2\7\1299744000\' This field name is not known. Details: errorKind
This has ('Submit Date' = $Start Date$) as the qual. But if I leave quals
empty on the Active Link the report will run. Eventually, I want to use a
External qual on this report. I thought I had this running a couple of months
ago but just tested it again and now it is broken.
ARS 7.1 p 6
ITSM 7.0.3 p 9
Window 2003
MS SQ 2005
IIS/Tomcat
RKM 7.2 p 4
MidTier 7.5 p 7
Christie Pargeter
Legacy Health
IS - Programming
SR Technical Analyst
cparge...@lhs.org
1120 Building
tel: 503-415-5149
_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_
_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_
_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_
---
Computacenter AG Co. oHG, mit Sitz in Kerpen (Amtsgericht Köln HRA 18096)
Vertretungsberechtigte Gesellschafter:
Computacenter Aktiengesellschaft, mit Sitz in Köln (Amtsgericht Köln HRB 28384)
Vorstand: Oliver Tuszik (Vorsitzender), Dr. Karsten Freihube, Hans-Georg
Freitag, Frank Kottmann, Reiner Louis
Aufsichtsrat: Michael Norris (Vorsitzender)
Computacenter Management GmbH, mit Sitz in Köln (Amtsgericht Köln HRB 28284)
Geschäftsführer: Ulrich Irnich
Visit us on the Internet: http://www.computacenter.de
Visit our Online-Shop: https://shop.computacenter.de
This email is confidential. If you are not the intended recipient, you must not
disclose or use the information contained in it. If you have received this mail
in error, please tell us immediately by return email and delete the document.
---
_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Issue with a report
I know that I have done this before in previous versions of ARS but this is the
first time I have tried to create a report against the NTE:Notifier Log screen
and I wonder if that is part of it.
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Pederson
Sent: Saturday, March 12, 2011 11:00 AM
To: arslist@ARSLIST.ORG
Subject: Re: Issue with a report
**
I seem to recall active links having issues with using greater than/less than
operators on non-integer fields, including date fields. Have you tried moving
the values into some display integer fields and then using those two fields in
the qualification?
Regards,
Brian Pederson
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Roehr, Mario
Sent: Saturday, March 12, 2011 12:52 AM
To: arslist@ARSLIST.ORG
Subject: AW: Issue with a report
**
Christie,
I'm wondering if this could be a valid qualification:
'Submit Date' = $Start Date$
That means `Submit Date` would be later as the `Start Date`, but Submit Date in
the most cases is the earliest Timestamp as it was set when you submitted the
record (eg. Click on the Save button)
Mario
Von: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] Im Auftrag von Pargeter, Christie :CO IS
Gesendet: Samstag, 12. März 2011 00:50
An: arslist@ARSLIST.ORG
Betreff: Re: Issue with a report
**
There are no errors in Crystal Reports or the User Tool when I try the report
only on the web. I did try recreating at one point to use the underscores
incase that was the issue. But the really odd point to me is that if I run the
report with any quals it works but if I add '3'=1/1/11 I get the error.
I tried to add the report to the Reporting Console and to select the Submit
Date and just that field and I still get the error.
From: kimberly.sant...@oracle.com santana [mailto:kimberly.sant...@oracle.com]
Sent: Friday, March 11, 2011 3:43 PM
To: arslist@ARSLIST.ORG
Cc: Pargeter, Christie :CO IS
Subject: Re: Issue with a report
I am curious to know when you refresh the report in crystal reports are you
getting any errors ?
I am noticing that your qualification does not use underscores but the crystal
report field is using underscores..
How do you have our odbc set up? to use underscores or not to use underscores?
Kimberly
On 3/11/2011 9:58 AM, Pargeter, Christie :CO IS wrote:
**
When I look in Crystal Report it is there. Also, this report works in the user
tool as designed (with the external field) but not in the web.
From: kimberly.sant...@oracle.com santana [mailto:kimberly.sant...@oracle.com]
Sent: Thursday, March 10, 2011 8:37 PM
To: arslist@ARSLIST.ORG
Cc: Pargeter, Christie :CO IS
Subject: Re: Issue with a report
Did you check to make sure that this field 'ARSYS_SERIAL_QUAL_COLUMN' is on
the form NTE_Notifier_Log?
Kimberly
On 3/10/2011 7:24 PM, Pargeter, Christie :CO IS wrote:
**
I am trying to build a report against the NTE:Notifier Log screen and if I put
any quals on the Active Link I get
This field name is not known. Details: errorKind Error in File
C:\WINDOWS\TEMP\CLUserHistory {200BA716-D86C-4D45-9F30-0913A657F293}.rpt: Error
in formula . '{NTE_Notifier_Log.ARSYS_SERIAL_QUAL_COLUMN}
4\3\1\3\2\7\1299744000\' This field name is not known. Details: errorKind
This has ('Submit Date' = $Start Date$) as the qual. But if I leave quals
empty on the Active Link the report will run. Eventually, I want to use a
External qual on this report. I thought I had this running a couple of months
ago but just tested it again and now it is broken.
ARS 7.1 p 6
ITSM 7.0.3 p 9
Window 2003
MS SQ 2005
IIS/Tomcat
RKM 7.2 p 4
MidTier 7.5 p 7
Christie Pargeter
Legacy Health
IS - Programming
SR Technical Analyst
cparge...@lhs.org
1120 Building
tel: 503-415-5149
_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_
_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_
_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_
---
Computacenter AG Co. oHG, mit Sitz in Kerpen (Amtsgericht Köln HRA 18096)
Vertretungsberechtigte Gesellschafter:
Computacenter Aktiengesellschaft, mit Sitz in Köln (Amtsgericht Köln HRB 28384)
Vorstand: Oliver Tuszik (Vorsitzender), Dr. Karsten Freihube, Hans-Georg
Freitag, Frank Kottmann, Reiner Louis
Aufsichtsrat: Michael Norris (Vorsitzender)
Computacenter Management GmbH, mit Sitz in Köln (Amtsgericht Köln HRB 28284)
Geschäftsführer: Ulrich Irnich
Visit us on the Internet: http://www.computacenter.de
Visit our Online-Shop: https://shop.computacenter.de
This email is confidential. If you are not the intended recipient, you must not
disclose or use the information
Re: MidTier and Rich Text
The web client did not support Rich Text formatted fields until AR System 7.6.0x. 17-Aug-2010 What's New: BMC Remedy Action Request System 7.6.03 PDFhttp://documents.bmc.com/supportu/documents/80/99/168099/168099.pdf Rich-text formatting in data fields You can add rich-text formatting (RTF) to character fields in browsers so that users can make changes to the format of text in a character field. For example, a user might want to italicize or center text. Additionally, you can allow users to add an image to a field with RTF by referencing a URL to an image. -David J. Easter Manager of Product Management, Remedy Platform BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, March 14, 2011 06:54 AM To: arslist@ARSLIST.ORG Subject: MidTier and Rich Text ** In the client (we are using 7.5 p7) if you put a URL in a field it automatically makes it a clickable link, but in the MidTier is does not do this. Is there a reason why? Or is this just happening with us? Lisa Kemes AR System Developer +01 717 810 2408 tel +01 717 602 9460 mobile lisa.ke...@te.commailto:lisa.ke...@te.com [http://www-qa.tycoelectronics.com/images/socialmedia/smallTElogo.gif]http://www-qa.tycoelectronics.com/ www.te.comhttp://www.te.com/ [http://www.tycoelectronics.com/images/socialmedia/twitter.png]http://twitter.com/tycoelectronics/[http://www.tycoelectronics.com/images/socialmedia/facebook.png]http://facebook.com/tycoelectronics/[http://www.tycoelectronics.com/images/socialmedia/flickr.png]http://www.flickr.com/photos/tycoelectronics/[http://www.tycoelectronics.com/images/socialmedia/linkedin.png]http://www.linkedin.com/groups?gid=1591657[http://www.tycoelectronics.com/images/socialmedia/youtube.png]http://www.youtube.com/tycoelectronics/ This email transmission (and any of its attachments) may contain confidential, proprietary and/or privileged information. The sender intends this transmission only for the designated recipient(s). If you are not a designated recipient (or authorized to receive for a designated recipient), you are hereby notified that the disclosure, copying, distribution or use of any of the information contained in this transmission is strictly prohibited. If you have received this transmission in error, please destroy this message, delete any copies which may exist on your system and notify the sender immediately. Thank you. _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Using DSO to sync two AR Servers
Hi Vikram, You could try DB triggers to replicate data in tables of other DBs. Regards, SriSamSri Appecherla Mobile# +91 991 610 6008 On Fri, Mar 11, 2011 at 3:42 PM, vikram_k vk0073...@techmahindra.comwrote: Hi listers, Greetings, I have a new challenge thrown at me.. now the performance of the system is good enough (if you remember my tiring question about ARS performance and huge queries) now I have been asked to find a way to keep 2 application servers in sync at real time. And what I could think of is to introduce DSO to into the picture. So here it goes: 1) Is it best to use DSO to keep 2 Application servers in sync all real time. 2) Both the application servers are replicas of each other but geographically located. 3) The ARS application is completely customized with 350+ forms to be managed in sync. 4) Also DSO is to be used to archive data from one of the servers into the other which will be used as just an read only reporting server. 5) Both the servers are ARS 5.0.1 :) So I would really appreciate if you can help me through this as well as you did in my previous endavour. My questions : 1) Is it reliabe to use DSO in this big context? 2) What all factors do I have to keep my eyes on while doing this? 3) What is the performance hit that if at all one can expect? 4) Any specific setting that can be implemented to keep the performance up? I guess this is a nice learing experience for someone like me and would like any help possible from you guys. Thanks in advance Regards, Vikram. -- View this message in context: http://old.nabble.com/Using-DSO-to-sync-two-AR-Servers-tp31123715p31123715.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Issue with a report
Christie,
Few things you may want to check,
- Try an advanced search on the form with the qualification you are
trying to use. If it is retrieving the result, probably there would not be a
problem with your qualification
- Try removing the addition of seconds to your date/time and check if you
get the results
Regards,
SriSamSri Appecherla
Mobile# +91 991 610 6008
On Mon, Mar 14, 2011 at 7:58 PM, Pargeter, Christie :CO IS cparg...@lhs.org
wrote:
**
The full qual that I am trying is '3'=$Start Date$ and '3'=$End
Date$+86399 and '101029'=$Sent From Person$
I want all the records created within a date range by a person. e.g., All
records created from 1/1/11 - 4/1/11 by cpargete
--
*From:* Action Request System discussion list(ARSList) [mailto:
arslist@ARSLIST.ORG] *On Behalf Of *Roehr, Mario
*Sent:* Saturday, March 12, 2011 12:52 AM
*To:* arslist@ARSLIST.ORG
*Subject:* AW: Issue with a report
**
Christie,
I’m wondering if this could be a valid qualification:
'Submit Date' = $Start Date$
That means `Submit Date` would be later as the `Start Date`, but Submit
Date in the most cases is the earliest Timestamp as it was set when you
submitted the record (eg. Click on the Save button)
Mario
* *
* *
*Von:* Action Request System discussion list(ARSList) [mailto:
arslist@ARSLIST.ORG] *Im Auftrag von *Pargeter, Christie :CO IS
*Gesendet:* Samstag, 12. März 2011 00:50
*An:* arslist@ARSLIST.ORG
*Betreff:* Re: Issue with a report
**
There are no errors in Crystal Reports or the User Tool when I try the
report only on the web. I did try recreating at one point to use the
underscores incase that was the issue. But the really odd point to me is
that if I run the report with any quals it works but if I add '3'=1/1/11
I get the error.
I tried to add the report to the Reporting Console and to select the Submit
Date and just that field and I still get the error.
--
*From:* kimberly.sant...@oracle.com santana [mailto:
kimberly.sant...@oracle.com]
*Sent:* Friday, March 11, 2011 3:43 PM
*To:* arslist@ARSLIST.ORG
*Cc:* Pargeter, Christie :CO IS
*Subject:* Re: Issue with a report
I am curious to know when you refresh the report in crystal reports are you
getting any errors ?
I am noticing that your qualification does not use underscores but the
crystal report field is using underscores..
How do you have our odbc set up? to use underscores or not to use
underscores?
Kimberly
On 3/11/2011 9:58 AM, Pargeter, Christie :CO IS wrote:
**
When I look in Crystal Report it is there. Also, this report works in the
user tool as designed (with the external field) but not in the web.
--
*From:* kimberly.sant...@oracle.com santana [
mailto:kimberly.sant...@oracle.com kimberly.sant...@oracle.com]
*Sent:* Thursday, March 10, 2011 8:37 PM
*To:* arslist@ARSLIST.ORG
*Cc:* Pargeter, Christie :CO IS
*Subject:* Re: Issue with a report
Did you check to make sure that this field 'ARSYS_SERIAL_QUAL_COLUMN' is
on the form NTE_Notifier_Log?
Kimberly
On 3/10/2011 7:24 PM, Pargeter, Christie :CO IS wrote:
**
I am trying to build a report against the NTE:Notifier Log screen and if I
put any quals on the Active Link I get
This field name is not known. Details: errorKind Error in File
C:\WINDOWS\TEMP\CLUserHistory {200BA716-D86C-4D45-9F30-0913A657F293}.rpt:
Error in formula . '{NTE_Notifier_Log.ARSYS_SERIAL_QUAL_COLUMN}
4\3\1\3\2\7\1299744000\' This field name is not known. Details: errorKind
This has ('Submit Date' = $Start Date$) as the qual. But if I leave
quals empty on the Active Link the report will run. Eventually, I want to
use a External qual on this report. I thought I had this running a couple
of months ago but just tested it again and now it is broken.
ARS 7.1 p 6
ITSM 7.0.3 p 9
Window 2003
MS SQ 2005
IIS/Tomcat
RKM 7.2 p 4
MidTier 7.5 p 7
--
*Christie Pargeter *
*Legacy Health** ***
*IS - Programming*
*SR Technical Analyst***
cparge...@lhs.org
* **1120 Building*
tel: 503-415-5149
_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_
_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_
_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_
---
Computacenter AG Co. oHG, mit Sitz in Kerpen (Amtsgericht Köln HRA 18096)
Vertretungsberechtigte Gesellschafter:
Computacenter Aktiengesellschaft, mit Sitz in Köln (Amtsgericht Köln HRB
28384)
Vorstand: Oliver Tuszik (Vorsitzender), Dr. Karsten Freihube, Hans-Georg
Freitag, Frank Kottmann, Reiner Louis
Aufsichtsrat: Michael Norris (Vorsitzender)
Computacenter Management GmbH, mit Sitz in Köln (Amtsgericht Köln HRB
28284)
Geschäftsführer: Ulrich Irnich
Visit us on the Internet: http://www.computacenter.de
Visit our Online-Shop:
Re: Discovery Tools
HP also has a discovery tool set, HP Discovery and Dependency mapping, that we currently integrate with Remedy. As some others have said the trivial part with this tool set is Normalization and Reconciliation. Tim -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hale, Greg Sent: Friday, March 11, 2011 7:27 AM To: arslist@ARSLIST.ORG Subject: Discovery Tools ** We are starting the process of looking at tools that can handle the Discovery of our Assets and integrating them into our CMDB. What discovery tools are others currently using? Pros? Cons? How was it integrating with BMC's Remedy CMDB? The few Discovery Tools I've seen want to license/charge by the CPU or Asset. Is that true for what others are currently using? Any details, insight, or information would be greatly appreciated. Thanks, Greg Hale SiriusXM Enterprise Management Systems Principal Engineer ARS 7.1P5 Solaris 10 Oracle 10gR2 HelpDesk 6 Mid-Tier 7.5P7 IIS 6 Tomcat 5.5.28 _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Discovery Tools
But let's talk integration into 7.6.4 Or 7.6.3. Of those tools. Done that? Sent from my iPhone On Mar 14, 2011, at 12:37 PM, Hulmes, Timothy CTR MDA/DXCO timothy.hulmes@mda.mil wrote: HP also has a discovery tool set, HP Discovery and Dependency mapping, that we currently integrate with Remedy. As some others have said the trivial part with this tool set is Normalization and Reconciliation. Tim -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hale, Greg Sent: Friday, March 11, 2011 7:27 AM To: arslist@ARSLIST.ORG Subject: Discovery Tools ** We are starting the process of looking at tools that can handle the Discovery of our Assets and integrating them into our CMDB. What discovery tools are others currently using? Pros? Cons? How was it integrating with BMC's Remedy CMDB? The few Discovery Tools I've seen want to license/charge by the CPU or Asset. Is that true for what others are currently using? Any details, insight, or information would be greatly appreciated. Thanks, Greg Hale SiriusXM Enterprise Management Systems Principal Engineer ARS 7.1P5 Solaris 10 Oracle 10gR2 HelpDesk 6 Mid-Tier 7.5P7 IIS 6 Tomcat 5.5.28 _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Issue with a report
I was able to run the qual on the form.
I have also tried hard coding '3'1/1/11 (this being the only qual) on the
active link (thinking that the adding of seconds might be an issue) and still
get the error message.
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of SriSamSri Appecherla
Sent: Monday, March 14, 2011 9:32 AM
To: arslist@ARSLIST.ORG
Subject: Re: Issue with a report
** Christie,
Few things you may want to check,
* Try an advanced search on the form with the qualification you are
trying to use. If it is retrieving the result, probably there would not be a
problem with your qualification
* Try removing the addition of seconds to your date/time and check if you
get the results
Regards,
SriSamSri Appecherla
Mobile# +91 991 610 6008
On Mon, Mar 14, 2011 at 7:58 PM, Pargeter, Christie :CO IS cparg...@lhs.org
wrote:
**
The full qual that I am trying is '3'=$Start Date$ and '3'=$End
Date$+86399 and '101029'=$Sent From Person$
I want all the records created within a date range by a person. e.g.,
All records created from 1/1/11 - 4/1/11 by cpargete
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Roehr, Mario
Sent: Saturday, March 12, 2011 12:52 AM
To: arslist@ARSLIST.ORG
Subject: AW: Issue with a report
**
Christie,
I'm wondering if this could be a valid qualification:
'Submit Date' = $Start Date$
That means `Submit Date` would be later as the `Start Date`, but Submit
Date in the most cases is the earliest Timestamp as it was set when you
submitted the record (eg. Click on the Save button)
Mario
Von: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] Im Auftrag von Pargeter, Christie :CO IS
Gesendet: Samstag, 12. März 2011 00:50
An: arslist@ARSLIST.ORG
Betreff: Re: Issue with a report
**
There are no errors in Crystal Reports or the User Tool when I try the
report only on the web. I did try recreating at one point to use the
underscores incase that was the issue. But the really odd point to me is that
if I run the report with any quals it works but if I add '3'=1/1/11 I get
the error.
I tried to add the report to the Reporting Console and to select the
Submit Date and just that field and I still get the error.
From: kimberly.sant...@oracle.com santana
[mailto:kimberly.sant...@oracle.com]
Sent: Friday, March 11, 2011 3:43 PM
To: arslist@ARSLIST.ORG
Cc: Pargeter, Christie :CO IS
Subject: Re: Issue with a report
I am curious to know when you refresh the report in crystal reports are
you getting any errors ?
I am noticing that your qualification does not use underscores but the
crystal report field is using underscores..
How do you have our odbc set up? to use underscores or not to use
underscores?
Kimberly
On 3/11/2011 9:58 AM, Pargeter, Christie :CO IS wrote:
**
When I look in Crystal Report it is there. Also, this report works in
the user tool as designed (with the external field) but not in the web.
From: kimberly.sant...@oracle.com santana
[mailto:kimberly.sant...@oracle.com]
Sent: Thursday, March 10, 2011 8:37 PM
To: arslist@ARSLIST.ORG
Cc: Pargeter, Christie :CO IS
Subject: Re: Issue with a report
Did you check to make sure that this field 'ARSYS_SERIAL_QUAL_COLUMN'
is on the form NTE_Notifier_Log?
Kimberly
On 3/10/2011 7:24 PM, Pargeter, Christie :CO IS wrote:
**
I am trying to build a report against the NTE:Notifier Log screen and
if I put any quals on the Active Link I get
This field name is not known. Details: errorKind Error in File
C:\WINDOWS\TEMP\CLUserHistory {200BA716-D86C-4D45-9F30-0913A657F293}.rpt: Error
in formula . '{NTE_Notifier_Log.ARSYS_SERIAL_QUAL_COLUMN}
4\3\1\3\2\7\1299744000\' This field name is not known. Details: errorKind
This has ('Submit Date' = $Start Date$) as the qual. But if I leave
quals empty on the Active Link the report will run. Eventually, I want to use
a External qual on this report. I thought I had this running a couple of
months ago but just tested it again and now it is broken.
ARS 7.1 p 6
ITSM 7.0.3 p 9
Window 2003
MS SQ 2005
IIS/Tomcat
RKM 7.2 p 4
MidTier 7.5 p 7
Re: Urgent please help! how to refresh table using filters
Mary, I think Jason hit the nail on the head. Just remember: Server Side Table Field + Filter Guide table looping = Phasing Issues (considerations at least). When using a table field on the server side (i.e. in a filter), it doesn't need to be refreshed, it will always have the current data (within the context of phasing of course). Hopefully that point you in the right direction. :-) Thad On Sun, Mar 13, 2011 at 3:49 PM, Mary Estrada mestr...@blizzard.com wrote: Thanks in advance. Having email update a back end table, then call filter guide to check data in columns in table. Need to refresh the table before filter call guide to loop thru all rows. Thanks, ~Mary ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
FYI undocumented feature / quirk - Request ID (field 1) of length 1 means length is 15 and no zero fill
Hi Folks, Just discovered a case where a request id (field '1') had a database length of 1 - one of the Task Template schemas in ITSM 7.6. This is valid and means that the length is 15 and there is no leading zero fill. The old Admin tool had a nice error message when setting a field 1 to say 2 bytes. I can certainly find nowhere that this is documented including all .h files. The doc says a field id 1 must be between 5 and 15 bytes long and mentions nothing about the effect of setting it to 1. Doc bug? Cheers Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329GMT + 1 + [ DST ] Email:mailto:ben.cher...@softwaretoolhouse.com ben.cher...@softwaretoolhouse.com Web: http://www.softwaretoolhouse.com/ www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/ http://www.softwaretoolhouse.com/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: FYI undocumented feature / quirk - Request ID (field 1) of length 1 means length is 15 and no zero fill
Ben, This has been a feature of the system for quite a while now. 7.5 most definitely, 7.0 I think so, before that, I am not sure. I did a quick search in the on-line documentation and found a section of the document titled Working with the Request ID field This section clearly calls out the possibility of setting this field to a length of 1 to achieve the affect you are commenting on. I do have to agree however that in the section Core Fields where each of the core fields is described, it does not include the extra line or two describing the affect of setting the length to 1. So, that is a good doc bug/enhancement you can submit. I didn't look further at other places to see if it does or does not discuss this topic or even whether it is appropriate for that discussion in other areas. But, the key is that the capability exists to control the ID and get no leading 0s if that is what you want. It does mean that sorting by the Request ID is no longer in clean order because the request ID is a character field and without leading 0s things do not sort numerically correctly as the number of characters in the value changes. But it is your choice. Note: No lead 0's can work with a prefix as well. The prefix will be present but no lead 0s between the prefix and the Request ID number. Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ben Chernys Sent: Monday, March 14, 2011 10:42 AM To: arslist@ARSLIST.ORG Subject: FYI undocumented feature / quirk - Request ID (field 1) of length 1 means length is 15 and no zero fill ** Hi Folks, Just discovered a case where a request id (field '1') had a database length of 1 - one of the Task Template schemas in ITSM 7.6. This is valid and means that the length is 15 and there is no leading zero fill. The old Admin tool had a nice error message when setting a field 1 to say 2 bytes. I can certainly find nowhere that this is documented including all .h files. The doc says a field id 1 must be between 5 and 15 bytes long and mentions nothing about the effect of setting it to 1. Doc bug? Cheers Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329GMT + 1 + [ DST ] Email: ben.cher...@softwaretoolhouse.commailto:ben.cher...@softwaretoolhouse.com Web: www.softwaretoolhouse.comhttp://www.softwaretoolhouse.com/ Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Question about NULL
HI All,
I have a table that uses the following query which searches for any open record
that is not assigned to me.
'Status' Closed AND ('Assigned Person' != Mark Brittain OR 'Assigned
Person' = NULL)
If I use the query without the Assigned Person' = NULL the result does not
include any records that are not assigned. Both fields are indexed but the
NULL causes the full table scan. Is there a way to write query so that
indexing is used but I get the records that are unassigned?
Thanks
Mark
Mark Brittain
Remedy Developer
NaviSite
mbritt...@navisite.commailto:mbritt...@navisite.com
(315) 453-2912 x5335 (Office)
(315) 317.2897 (Cell)
This e-mail is the property of NaviSite, Inc. It is intended only for the
person or entity to which it is addressed and may contain information that is
privileged, confidential, or otherwise protected from disclosure. Distribution
or copying of this e-mail, or the information contained herein, to anyone other
than the intended recipient is prohibited.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: FYI undocumented feature / quirk - Request ID (field 1) of length 1 means length is 15 and no zero fill
Hi, This has been there even since long before 7.0. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): * 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. Ben, This has been a feature of the system for quite a while now. 7.5 most definitely, 7.0 I think so, before that, I am not sure. I did a quick search in the on-line documentation and found a section of the document titled Working with the Request ID field This section clearly calls out the possibility of setting this field to a length of 1 to achieve the affect you are commenting on. I do have to agree however that in the section Core Fields where each of the core fields is described, it does not include the extra line or two describing the affect of setting the length to 1. So, that is a good doc bug/enhancement you can submit. I didn't look further at other places to see if it does or does not discuss this topic or even whether it is appropriate for that discussion in other areas. But, the key is that the capability exists to control the ID and get no leading 0s if that is what you want. It does mean that sorting by the Request ID is no longer in clean order because the request ID is a character field and without leading 0s things do not sort numerically correctly as the number of characters in the value changes. But it is your choice. Note: No lead 0's can work with a prefix as well. The prefix will be present but no lead 0s between the prefix and the Request ID number. Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ben Chernys Sent: Monday, March 14, 2011 10:42 AM To: arslist@ARSLIST.ORG Subject: FYI undocumented feature / quirk - Request ID (field 1) of length 1 means length is 15 and no zero fill ** Hi Folks, Just discovered a case where a request id (field '1') had a database length of 1 - one of the Task Template schemas in ITSM 7.6. This is valid and means that the length is 15 and there is no leading zero fill. The old Admin tool had a nice error message when setting a field 1 to say 2 bytes. I can certainly find nowhere that this is documented including all .h files. The doc says a field id 1 must be between 5 and 15 bytes long and mentions nothing about the effect of setting it to 1. Doc bug? Cheers Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329GMT + 1 + [ DST ] Email: ben.cher...@softwaretoolhouse.commailto:ben.cher...@softwaretoolhouse.com Web: www.softwaretoolhouse.comhttp://www.softwaretoolhouse.com/ Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
View Forms
I recently updated a view on the database with an extra field and I would like to add this field to my View Form. When I right click on my form I get the option to select a field from my view, but when I click on it nothing comes up. Are View Forms sort of locked out if you update your view? Do I have to create a new view? (I did and I was able to include my new field), but I would like to add this field to my already existing view. AR System 7.1 p7 Oracle Lisa Kemes AR System Developer +01 717 810 2408 tel +01 717 602 9460 mobile lisa.ke...@te.commailto:lisa.ke...@te.com [http://www-qa.tycoelectronics.com/images/socialmedia/smallTElogo.gif]http://www-qa.tycoelectronics.com/ www.te.comhttp://www.te.com/ [http://www.tycoelectronics.com/images/socialmedia/twitter.png]http://twitter.com/tycoelectronics/[http://www.tycoelectronics.com/images/socialmedia/facebook.png]http://facebook.com/tycoelectronics/[http://www.tycoelectronics.com/images/socialmedia/flickr.png]http://www.flickr.com/photos/tycoelectronics/[http://www.tycoelectronics.com/images/socialmedia/linkedin.png]http://www.linkedin.com/groups?gid=1591657 This email transmission (and any of its attachments) may contain confidential, proprietary and/or privileged information. The sender intends this transmission only for the designated recipient(s). If you are not a designated recipient (or authorized to receive for a designated recipient), you are hereby notified that the disclosure, copying, distribution or use of any of the information contained in this transmission is strictly prohibited. If you have received this transmission in error, please destroy this message, delete any copies which may exist on your system and notify the sender immediately. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: FYI undocumented feature / quirk - Request ID (field 1) of length 1 means length is 15 and no zero fill
Hi Doug, Your right about the release. I just never came across it before in any form that I wrote a script against and I generally use Submit when modifying data because I generally want workflow firing. My test was with a 7.0.1 ARS and a test form (hence the admin tool). And yes, that was the section I looked at in the doc (7.6.3 doc). Caused me a bug because I automatically truncate character strings with a warning when greater than the limit (now except when it is field '1' and the limit is 1 - though if it is field '1' and it ain't right, I suppose I should throw an error rather than truncate J Thanks for responding. Ben From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug Sent: March-14-11 19:02 To: arslist@ARSLIST.ORG Subject: Re: FYI undocumented feature / quirk - Request ID (field 1) of length 1 means length is 15 and no zero fill ** Ben, This has been a feature of the system for quite a while now. 7.5 most definitely, 7.0 I think so, before that, I am not sure. I did a quick search in the on-line documentation and found a section of the document titled Working with the Request ID field This section clearly calls out the possibility of setting this field to a length of 1 to achieve the affect you are commenting on. I do have to agree however that in the section Core Fields where each of the core fields is described, it does not include the extra line or two describing the affect of setting the length to 1. So, that is a good doc bug/enhancement you can submit. I didn't look further at other places to see if it does or does not discuss this topic or even whether it is appropriate for that discussion in other areas. But, the key is that the capability exists to control the ID and get no leading 0s if that is what you want. It does mean that sorting by the Request ID is no longer in clean order because the request ID is a character field and without leading 0s things do not sort numerically correctly as the number of characters in the value changes. But it is your choice. Note: No lead 0's can work with a prefix as well. The prefix will be present but no lead 0s between the prefix and the Request ID number. Doug Mueller _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ben Chernys Sent: Monday, March 14, 2011 10:42 AM To: arslist@ARSLIST.ORG Subject: FYI undocumented feature / quirk - Request ID (field 1) of length 1 means length is 15 and no zero fill ** Hi Folks, Just discovered a case where a request id (field '1') had a database length of 1 - one of the Task Template schemas in ITSM 7.6. This is valid and means that the length is 15 and there is no leading zero fill. The old Admin tool had a nice error message when setting a field 1 to say 2 bytes. I can certainly find nowhere that this is documented including all .h files. The doc says a field id 1 must be between 5 and 15 bytes long and mentions nothing about the effect of setting it to 1. Doc bug? Cheers Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329GMT + 1 + [ DST ] Email: ben.cher...@softwaretoolhouse.com Web: http://www.softwaretoolhouse.com/ www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/ http://www.softwaretoolhouse.com/ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Line Feed and Carriage Return in ARS
Hi there, I'm transfering data to our partner via a Web Service. There is WebMethods middleware on their side. While ARS has no problems processing any kind of line breaks coming from them, they can't process ours. What can I do to explicitly tell ARS to use a Line Feed and Carriage Return as a line break? Thanks Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: MidTier and Rich Text
Thanks David! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Easter, David Sent: Monday, March 14, 2011 11:23 AM To: arslist@ARSLIST.ORG Subject: Re: MidTier and Rich Text ** The web client did not support Rich Text formatted fields until AR System 7.6.0x. 17-Aug-2010 What's New: BMC Remedy Action Request System 7.6.03 PDFhttp://documents.bmc.com/supportu/documents/80/99/168099/168099.pdf Rich-text formatting in data fields You can add rich-text formatting (RTF) to character fields in browsers so that users can make changes to the format of text in a character field. For example, a user might want to italicize or center text. Additionally, you can allow users to add an image to a field with RTF by referencing a URL to an image. -David J. Easter Manager of Product Management, Remedy Platform BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, March 14, 2011 06:54 AM To: arslist@ARSLIST.ORG Subject: MidTier and Rich Text ** In the client (we are using 7.5 p7) if you put a URL in a field it automatically makes it a clickable link, but in the MidTier is does not do this. Is there a reason why? Or is this just happening with us? Lisa Kemes AR System Developer +01 717 810 2408 tel +01 717 602 9460 mobile lisa.ke...@te.commailto:lisa.ke...@te.com [http://www-qa.tycoelectronics.com/images/socialmedia/smallTElogo.gif]http://www-qa.tycoelectronics.com/ www.te.comhttp://www.te.com/ [http://www.tycoelectronics.com/images/socialmedia/twitter.png]http://twitter.com/tycoelectronics/[http://www.tycoelectronics.com/images/socialmedia/facebook.png]http://facebook.com/tycoelectronics/[http://www.tycoelectronics.com/images/socialmedia/flickr.png]http://www.flickr.com/photos/tycoelectronics/[http://www.tycoelectronics.com/images/socialmedia/linkedin.png]http://www.linkedin.com/groups?gid=1591657[http://www.tycoelectronics.com/images/socialmedia/youtube.png]http://www.youtube.com/tycoelectronics/ This email transmission (and any of its attachments) may contain confidential, proprietary and/or privileged information. The sender intends this transmission only for the designated recipient(s). If you are not a designated recipient (or authorized to receive for a designated recipient), you are hereby notified that the disclosure, copying, distribution or use of any of the information contained in this transmission is strictly prohibited. If you have received this transmission in error, please destroy this message, delete any copies which may exist on your system and notify the sender immediately. Thank you. _attend WWRUG11 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: View Forms
You updated the view and then opened the form to add the field? The list of fields able to be added is generated when the form is opened in the Admin tool. Another possibility is you are using a type of field that ARS does not work with. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, March 14, 2011 1:21 PM To: arslist@ARSLIST.ORG Subject: View Forms ** I recently updated a view on the database with an extra field and I would like to add this field to my View Form. When I right click on my form I get the option to select a field from my view, but when I click on it nothing comes up. Are View Forms sort of locked out if you update your view? Do I have to create a new view? (I did and I was able to include my new field), but I would like to add this field to my already existing view. AR System 7.1 p7 Oracle Lisa Kemes AR System Developer +01 717 810 2408 tel +01 717 602 9460 mobile lisa.ke...@te.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Question about NULL
Just a quick question Mark...
Did you mean $NULL$ OR NULL.
On Mar 14, 2:05 pm, Brittain, Mark mbritt...@navisite.com wrote:
HI All,
I have a table that uses the following query which searches for any open
record that is not assigned to me.
'Status' Closed AND ('Assigned Person' != Mark Brittain OR 'Assigned
Person' = NULL)
If I use the query without the Assigned Person' = NULL the result does not
include any records that are not assigned. Both fields are indexed but the
NULL causes the full table scan. Is there a way to write query so that
indexing is used but I get the records that are unassigned?
Thanks
Mark
Mark Brittain
Remedy Developer
NaviSite
mbritt...@navisite.commailto:mbritt...@navisite.com
(315) 453-2912 x5335 (Office)
(315) 317.2897 (Cell)
This e-mail is the property of NaviSite, Inc. It is intended only for the
person or entity to which it is addressed and may contain information that is
privileged, confidential, or otherwise protected from disclosure.
Distribution or copying of this e-mail, or the information contained herein,
to anyone other than the intended recipient is prohibited.
___
UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
attend wwrug11www.wwrug.comARSList: Where the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Urgent please help! how to refresh table using filters
Sounds right to me - unless she is trying to use a dynamic qualification. If so - I don't think this will work on a server side table walk. On Mar 14, 1:25 pm, Thad Esser thad.es...@gmail.com wrote: Mary, I think Jason hit the nail on the head. Just remember: Server Side Table Field + Filter Guide table looping = Phasing Issues (considerations at least). When using a table field on the server side (i.e. in a filter), it doesn't need to be refreshed, it will always have the current data (within the context of phasing of course). Hopefully that point you in the right direction. :-) Thad On Sun, Mar 13, 2011 at 3:49 PM, Mary Estrada mestr...@blizzard.com wrote: Thanks in advance. Having email update a back end table, then call filter guide to check data in columns in table. Need to refresh the table before filter call guide to loop thru all rows. Thanks, ~Mary ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug11www.wwrug.comARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Question about NULL
$NULL$
'Status' Closed AND ('Assigned Person' != Mark Brittain OR 'Assigned
Person' = $NULL$)
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Elry
Sent: Monday, March 14, 2011 2:40 PM
To: arslist@ARSLIST.ORG
Subject: Re: Question about NULL
Just a quick question Mark...
Did you mean $NULL$ OR NULL.
On Mar 14, 2:05 pm, Brittain, Mark mbritt...@navisite.com wrote:
HI All,
I have a table that uses the following query which searches for any open
record that is not assigned to me.
'Status' Closed AND ('Assigned Person' != Mark Brittain OR 'Assigned
Person' = NULL)
If I use the query without the Assigned Person' = NULL the result does not
include any records that are not assigned. Both fields are indexed but the
NULL causes the full table scan. Is there a way to write query so that
indexing is used but I get the records that are unassigned?
Thanks
Mark
Mark Brittain
Remedy Developer
NaviSite
mbritt...@navisite.commailto:mbritt...@navisite.com
(315) 453-2912 x5335 (Office)
(315) 317.2897 (Cell)
This e-mail is the property of NaviSite, Inc. It is intended only for the
person or entity to which it is addressed and may contain information that is
privileged, confidential, or otherwise protected from disclosure.
Distribution or copying of this e-mail, or the information contained herein,
to anyone other than the intended recipient is prohibited.
___
UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
attend wwrug11www.wwrug.comARSList: Where the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: FYI undocumented feature / quirk - Request ID (field 1) of length 1 means length is 15 and no zero fill
Hi Doug, Your right about the release. I just never came across it before in any form that I wrote a script against and I generally use Submit when modifying data because I generally want workflow firing. My test was with a 7.0.1 ARS and a test form (hence the admin tool). And yes, that was the section I looked at in the doc (7.6.3 doc). Caused me a bug because I automatically truncate character strings with a warning when greater than the limit (now except when it is field '1' and the limit is 1 - though if it is field '1' and it ain't right, I suppose I should throw an error rather than truncate J Thanks for responding. Ben From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug Sent: March-14-11 19:02 To: arslist@ARSLIST.ORG Subject: Re: FYI undocumented feature / quirk - Request ID (field 1) of length 1 means length is 15 and no zero fill ** Ben, This has been a feature of the system for quite a while now. 7.5 most definitely, 7.0 I think so, before that, I am not sure. I did a quick search in the on-line documentation and found a section of the document titled Working with the Request ID field This section clearly calls out the possibility of setting this field to a length of 1 to achieve the affect you are commenting on. I do have to agree however that in the section Core Fields where each of the core fields is described, it does not include the extra line or two describing the affect of setting the length to 1. So, that is a good doc bug/enhancement you can submit. I didn't look further at other places to see if it does or does not discuss this topic or even whether it is appropriate for that discussion in other areas. But, the key is that the capability exists to control the ID and get no leading 0s if that is what you want. It does mean that sorting by the Request ID is no longer in clean order because the request ID is a character field and without leading 0s things do not sort numerically correctly as the number of characters in the value changes. But it is your choice. Note: No lead 0's can work with a prefix as well. The prefix will be present but no lead 0s between the prefix and the Request ID number. Doug Mueller _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ben Chernys Sent: Monday, March 14, 2011 10:42 AM To: arslist@ARSLIST.ORG Subject: FYI undocumented feature / quirk - Request ID (field 1) of length 1 means length is 15 and no zero fill ** Hi Folks, Just discovered a case where a request id (field '1') had a database length of 1 - one of the Task Template schemas in ITSM 7.6. This is valid and means that the length is 15 and there is no leading zero fill. The old Admin tool had a nice error message when setting a field 1 to say 2 bytes. I can certainly find nowhere that this is documented including all .h files. The doc says a field id 1 must be between 5 and 15 bytes long and mentions nothing about the effect of setting it to 1. Doc bug? Cheers Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329GMT + 1 + [ DST ] Email: ben.cher...@softwaretoolhouse.com Web: http://www.softwaretoolhouse.com/ www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/ http://www.softwaretoolhouse.com/ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Question about NULL
The clause ('Assigned Person' != Mark Brittain) will not use an index since
it is a not equal, so the only Index you could use is one on Status. I was
told (a long time ago) it is better to use = instead of (supposedly = helps
the database use an index).
Can you look and see when the last time that the index on Status was analyzed?
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark
Sent: Monday, March 14, 2011 1:49 PM
To: arslist@ARSLIST.ORG
Subject: Re: Question about NULL
$NULL$
'Status' Closed AND ('Assigned Person' != Mark Brittain OR 'Assigned
Person' = $NULL$)
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Elry
Sent: Monday, March 14, 2011 2:40 PM
To: arslist@ARSLIST.ORG
Subject: Re: Question about NULL
Just a quick question Mark...
Did you mean $NULL$ OR NULL.
On Mar 14, 2:05 pm, Brittain, Mark mbritt...@navisite.com wrote:
HI All,
I have a table that uses the following query which searches for any open
record that is not assigned to me.
'Status' Closed AND ('Assigned Person' != Mark Brittain OR 'Assigned
Person' = NULL)
If I use the query without the Assigned Person' = NULL the result does not
include any records that are not assigned. Both fields are indexed but the
NULL causes the full table scan. Is there a way to write query so that
indexing is used but I get the records that are unassigned?
Thanks
Mark
Mark Brittain
Remedy Developer
NaviSite
mbritt...@navisite.commailto:mbritt...@navisite.com
(315) 453-2912 x5335 (Office)
(315) 317.2897 (Cell)
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Question about NULL
Mark,
First, about why your search is not working as you think it should have.
NULL is a strange beast in databases. It is a value. A very special value
that means there is no value. The
only way to find things that have this special no value value is to
explicitly look for it. No value does not
match a != comparison.
This is why you have to explicitly check for it in your qualification to find
things that are unassigned.
Now, about indexing. It actually is not the NULL test that is causing the
table scan. If you have a field
indexed and you search for NULL, you will use the index.
The thing that is causing the table scan is the != Mark Brittain clause. A
!= will cause the system to
perform a table scan as there is nothing to index on.
To find all the unassigned records using the index, just use the clause
'Assigned Person' = $NULL$
This will use the index on Assigned Person and it will find all unassigned
records.
I am not sure what the != Mark Brittain clause is for if you are looking for
unassigned records. That will
find ASSIGNED records that are not assigned to Mark. So, that search is really
looking for all records
not assigned to anyone (the NULL clause) and those not assigned to Mark. If
you can remove the != Mark
from your criteria, you will find things much more efficient.
Now, all this is assuming you don't qualify on Status too. If there is an
index on Status, it should help with
the search and that index can be used. However, the algorithm for determining
whether to use an index may
be determining that there is a large percentage match in the table so it
defaults to a table scan rather than
trying to use the index on Status.
I hope this helps,
Doug Mueller
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark
Sent: Monday, March 14, 2011 11:06 AM
To: arslist@ARSLIST.ORG
Subject: Question about NULL
**
HI All,
I have a table that uses the following query which searches for any open record
that is not assigned to me.
'Status' Closed AND ('Assigned Person' != Mark Brittain OR 'Assigned
Person' = NULL)
If I use the query without the Assigned Person' = NULL the result does not
include any records that are not assigned. Both fields are indexed but the NULL
causes the full table scan. Is there a way to write query so that indexing is
used but I get the records that are unassigned?
Thanks
Mark
Mark Brittain
Remedy Developer
NaviSite
mbritt...@navisite.commailto:mbritt...@navisite.com
(315) 453-2912 x5335 (Office)
(315) 317.2897 (Cell)
This e-mail is the property of NaviSite, Inc. It is intended only for the
person or entity to which it is addressed and may contain information that is
privileged, confidential, or otherwise protected from disclosure. Distribution
or copying of this e-mail, or the information contained herein, to anyone other
than the intended recipient is prohibited.
_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Discovery Tools
Depending on how you seek to integrate it can be easy or simple. For example, if you have an external API or web service that you need to integrate with, it will be a little more challenging than having AIE read values from tables in databases. For client PCs, we have LANDesk and pulling in the discovery data from there is pretty simple, with the only gotcha being that the data needs normalized before you can really use it. What I mean by that is that some applications (for example, Winzip) show up with different manufacturers and different versions that don't quite match. The CMDB provides you with a means to do this, but I did it via SQL so that people could use the data directly in LANDesk in addition to Remedy. On the server side, you care about completely different things, so it does make sense to use a different discovery tool. We already had one in house called ECM. I was able to pull data directly from the DB here as well, but it required a little more work and a lot more conditions in my SQL to make sure the data was clean. I just completed the ADDM class last week, and we are looking to implement that in the coming months. It looks pretty cool and if it can do what BMC says, it will help create a lot of the relationships in the CMDB, which is always the greatest weakness of any discovery tool I've seen. Finding what software is installed on a server is pretty trivial. Crawling web.xml files on a server to look for database information then matching that discovered application with its database and creating that relationship in the CMDB is a little more tricky. Another thing to consider is that you need to clearly define the requirements. BMC focuses extensively on the CMDB side in their marketing, but an important thing to consider is the Asset Management side. Yes, it's very useful to build that web of relationships for support personnel, but it's also vital for you to be able to tell what applications are installed on what machine, then tie that back to a software contract to know whether you are in compliance or not and even if you can stop paying maintenance on some applications and retire them. I would argue that from a corporate standpoint, Asset Management is tremendously more important than Configuration Management, so your best bet is to focus on tools that help your organization be aware of their install base and licensing. Thanks, Shawn Pierson Remedy Developer | Southern Union From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hale, Greg Sent: Friday, March 11, 2011 8:27 AM To: arslist@ARSLIST.ORG Subject: Discovery Tools ** We are starting the process of looking at tools that can handle the Discovery of our Assets and integrating them into our CMDB. What discovery tools are others currently using? Pros? Cons? How was it integrating with BMC's Remedy CMDB? The few Discovery Tools I've seen want to license/charge by the CPU or Asset. Is that true for what others are currently using? Any details, insight, or information would be greatly appreciated. Thanks, Greg Hale SiriusXM Enterprise Management Systems Principal Engineer ARS 7.1P5 Solaris 10 Oracle 10gR2 HelpDesk 6 Mid-Tier 7.5P7 IIS 6 Tomcat 5.5.28 _attend WWRUG11 www.wwrug.com 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 attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Question about NULL
Hi Doug,
Great explanation and I appreciate the time taken to reply to the issue. On
the display only form I have two table fields. The first looks for open records
assigned to me and the second looks for open records not assigned to me. This
is why I am using the != Mark clause.
Thanks for the advice.
Mark
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug
Sent: Monday, March 14, 2011 3:07 PM
To: arslist@ARSLIST.ORG
Subject: Re: Question about NULL
**
Mark,
First, about why your search is not working as you think it should have.
NULL is a strange beast in databases. It is a value. A very special value
that means there is no value. The
only way to find things that have this special no value value is to
explicitly look for it. No value does not
match a != comparison.
This is why you have to explicitly check for it in your qualification to find
things that are unassigned.
Now, about indexing. It actually is not the NULL test that is causing the
table scan. If you have a field
indexed and you search for NULL, you will use the index.
The thing that is causing the table scan is the != Mark Brittain clause. A
!= will cause the system to
perform a table scan as there is nothing to index on.
To find all the unassigned records using the index, just use the clause
'Assigned Person' = $NULL$
This will use the index on Assigned Person and it will find all unassigned
records.
I am not sure what the != Mark Brittain clause is for if you are looking for
unassigned records. That will
find ASSIGNED records that are not assigned to Mark. So, that search is really
looking for all records
not assigned to anyone (the NULL clause) and those not assigned to Mark. If
you can remove the != Mark
from your criteria, you will find things much more efficient.
Now, all this is assuming you don't qualify on Status too. If there is an
index on Status, it should help with
the search and that index can be used. However, the algorithm for determining
whether to use an index may
be determining that there is a large percentage match in the table so it
defaults to a table scan rather than
trying to use the index on Status.
I hope this helps,
Doug Mueller
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark
Sent: Monday, March 14, 2011 11:06 AM
To: arslist@ARSLIST.ORG
Subject: Question about NULL
**
HI All,
I have a table that uses the following query which searches for any open record
that is not assigned to me.
'Status' Closed AND ('Assigned Person' != Mark Brittain OR 'Assigned
Person' = NULL)
If I use the query without the Assigned Person' = NULL the result does not
include any records that are not assigned. Both fields are indexed but the NULL
causes the full table scan. Is there a way to write query so that indexing is
used but I get the records that are unassigned?
Thanks
Mark
Mark Brittain
Remedy Developer
NaviSite
mbritt...@navisite.commailto:mbritt...@navisite.com
(315) 453-2912 x5335 (Office)
(315) 317.2897 (Cell)
This e-mail is the property of NaviSite, Inc. It is intended only for the
person or entity to which it is addressed and may contain information that is
privileged, confidential, or otherwise protected from disclosure. Distribution
or copying of this e-mail, or the information contained herein, to anyone other
than the intended recipient is prohibited.
_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_
_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Question about NULL
I suspect the key question that hasn't been asked is, what database are you using? Getting onto my soap box, Oracle (the last time I checked) is completely clueless to the meaning of null. ie == NULL as far as Oracle is concerned, which may have been correct in 1985, but isn't correct now we're trying to map data (where NULL exists) to tables. John Baker -- Single Sign On for AR System http://www.javasystemsolutions.com/jss/ssoplugin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Question about NULL
I don't think so MarkI believe the reason you are causing the table scan
is because of the OR, not because of the $NULL$. You may try a compound
index on Status and Assigned Personthis MAY help avoid a table scan, but
you must include the $NULL$ to get those...let me know if a compound index
works for this.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark
Sent: Monday, March 14, 2011 12:49 PM
To: arslist@ARSLIST.ORG
Subject: Re: Question about NULL
$NULL$
'Status' Closed AND ('Assigned Person' != Mark Brittain OR 'Assigned
Person' = $NULL$)
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Elry
Sent: Monday, March 14, 2011 2:40 PM
To: arslist@ARSLIST.ORG
Subject: Re: Question about NULL
Just a quick question Mark...
Did you mean $NULL$ OR NULL.
On Mar 14, 2:05 pm, Brittain, Mark mbritt...@navisite.com wrote:
HI All,
I have a table that uses the following query which searches for any open
record that is not assigned to me.
'Status' Closed AND ('Assigned Person' != Mark Brittain OR 'Assigned
Person' = NULL)
If I use the query without the Assigned Person' = NULL the result does not
include any records that are not assigned. Both fields are indexed but the
NULL causes the full table scan. Is there a way to write query so that
indexing is used but I get the records that are unassigned?
Thanks
Mark
Mark Brittain
Remedy Developer
NaviSite
mbritt...@navisite.commailto:mbritt...@navisite.com
(315) 453-2912 x5335 (Office)
(315) 317.2897 (Cell)
This e-mail is the property of NaviSite, Inc. It is intended only for the
person or entity to which it is addressed and may contain information that
is privileged, confidential, or otherwise protected from disclosure.
Distribution or copying of this e-mail, or the information contained herein,
to anyone other than the intended recipient is prohibited.
___
UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
attend wwrug11www.wwrug.comARSList: Where the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: View Forms
This is correct. I updated the View and then opened the view form to add the field. It's not greyed out so it lets me choose Fields from MyView but then it doesn't do anything. I added a brand new view form and purposely left out the new field. Created it, then tried to add the new field and it lets me. Just doesn't let me do this with the already existing View Form that I already have. I then added another new field to the view and I was able to add this to my Brand New View form as well. Looks like my old View form might be corrupted or something. It's pretty old Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Monday, March 14, 2011 2:40 PM To: arslist@ARSLIST.ORG Subject: Re: View Forms You updated the view and then opened the form to add the field? The list of fields able to be added is generated when the form is opened in the Admin tool. Another possibility is you are using a type of field that ARS does not work with. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, March 14, 2011 1:21 PM To: arslist@ARSLIST.ORG Subject: View Forms ** I recently updated a view on the database with an extra field and I would like to add this field to my View Form. When I right click on my form I get the option to select a field from my view, but when I click on it nothing comes up. Are View Forms sort of locked out if you update your view? Do I have to create a new view? (I did and I was able to include my new field), but I would like to add this field to my already existing view. AR System 7.1 p7 Oracle Lisa Kemes AR System Developer +01 717 810 2408 tel +01 717 602 9460 mobile lisa.ke...@te.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Filter Service Calls data base commits...
Hi, I have created a Filter Service that I call from a filter. The problem is that data seems to be committed to the database even though there is an ERROR later on in the processing. A1. Modify Filter in form A: Call Service X X2. Service Filter: pushes data to form X A2. Modify Filter in form A: generates ERROR (phase 2) The data pushed to form X via the Service Filteris commited to the data Is this as designed??? I was under the impression that everything should be rolled back if you have a failiure. At least if you refrain from meddling with the filter phasing, which I have not done... Any comments? ARServer version 7.6.04 on MS SQL Server. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): * 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. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Question about NULL
How about:
'Status' Closed AND NOT ('Assigned Person' == Mark Brittain)
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Filter Service Calls data base commits...
My understanding is that since you are calling a Service (just like consuming an external web-service logically) that is an independent transaction. So an ERROR Trap will need to be constructed, and then service X_rollback would need to be called in the error handling... Yes it adds much complication... HTH Robert On Mon, Mar 14, 2011 at 12:48 PM, Misi Mladoniczky m...@rrr.se wrote: Hi, I have created a Filter Service that I call from a filter. The problem is that data seems to be committed to the database even though there is an ERROR later on in the processing. A1. Modify Filter in form A: Call Service X X2. Service Filter: pushes data to form X A2. Modify Filter in form A: generates ERROR (phase 2) The data pushed to form X via the Service Filteris commited to the data Is this as designed??? I was under the impression that everything should be rolled back if you have a failiure. At least if you refrain from meddling with the filter phasing, which I have not done... Any comments? ARServer version 7.6.04 on MS SQL Server. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): * 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. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are -- ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Filter Service Calls data base commits...
Hi Robert, Maybe, but the documentation does not say anything about this. This would both limit and extend the use of servive-calls I guess. In my case, when my service picks the next of several counters, it will create holes in my counter-series. I guess I have to redesign... Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): * 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. My understanding is that since you are calling a Service (just like consuming an external web-service logically) that is an independent transaction. So an ERROR Trap will need to be constructed, and then service X_rollback would need to be called in the error handling... Yes it adds much complication... HTH Robert On Mon, Mar 14, 2011 at 12:48 PM, Misi Mladoniczky m...@rrr.se wrote: Hi, I have created a Filter Service that I call from a filter. The problem is that data seems to be committed to the database even though there is an ERROR later on in the processing. A1. Modify Filter in form A: Call Service X X2. Service Filter: pushes data to form X A2. Modify Filter in form A: generates ERROR (phase 2) The data pushed to form X via the Service Filteris commited to the data Is this as designed??? I was under the impression that everything should be rolled back if you have a failiure. At least if you refrain from meddling with the filter phasing, which I have not done... Any comments? ARServer version 7.6.04 on MS SQL Server. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): * 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. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are -- ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Question about NULL
DOH!!didn't catch the !=...yea...that certainly won't use an index.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Monday, March 14, 2011 12:56 PM
To: arslist@ARSLIST.ORG
Subject: Re: Question about NULL
The clause ('Assigned Person' != Mark Brittain) will not use an index
since it is a not equal, so the only Index you could use is one on Status.
I was told (a long time ago) it is better to use = instead of (supposedly
= helps the database use an index).
Can you look and see when the last time that the index on Status was
analyzed?
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark
Sent: Monday, March 14, 2011 1:49 PM
To: arslist@ARSLIST.ORG
Subject: Re: Question about NULL
$NULL$
'Status' Closed AND ('Assigned Person' != Mark Brittain OR 'Assigned
Person' = $NULL$)
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Elry
Sent: Monday, March 14, 2011 2:40 PM
To: arslist@ARSLIST.ORG
Subject: Re: Question about NULL
Just a quick question Mark...
Did you mean $NULL$ OR NULL.
On Mar 14, 2:05 pm, Brittain, Mark mbritt...@navisite.com wrote:
HI All,
I have a table that uses the following query which searches for any open
record that is not assigned to me.
'Status' Closed AND ('Assigned Person' != Mark Brittain OR 'Assigned
Person' = NULL)
If I use the query without the Assigned Person' = NULL the result does not
include any records that are not assigned. Both fields are indexed but the
NULL causes the full table scan. Is there a way to write query so that
indexing is used but I get the records that are unassigned?
Thanks
Mark
Mark Brittain
Remedy Developer
NaviSite
mbritt...@navisite.commailto:mbritt...@navisite.com
(315) 453-2912 x5335 (Office)
(315) 317.2897 (Cell)
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Question about NULL
Swapping the Assigned person test around will also improve the query -
the order of the query tests does matter not matter what DB is being
used
'Status' Closed AND ('Assigned Person' = $NULL$ OR NOT ('Assigned
Person' == Mark Brittain))
How about:
'Status' Closed AND NOT ('Assigned Person' == Mark Brittain)
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Active link to check field size
I must be being dense, but I'm trying to write an active link that only fires
if a field is more than a certain length. Can't figure out how to do that.
Know how to trim it and set the length, but not check it in the qualification.
I tried this
LENGTH('Field') 500
But it didn't like that.
Anne Ramey
***
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 only by an
authorized State Official.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Active link to check field size
Anne, You are close but not quite that close...You can’t use it that way in a qualification.. Those functions are set field functions that can be used only in set or push fields actions.. So create a temp integer field to hold the value of LENGTH(‘Field’) and then use that temp field in the qualification in an active link that runs in an order after the first active link.. Hope this helps.. Cheers Joe From: Ramey, Anne Sent: Monday, March 14, 2011 10:18 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Active link to check field size ** I must be being dense, but I’m trying to write an active link that only fires if a field is more than a certain length. Can’t figure out how to do that. Know how to trim it and set the length, but not check it in the qualification. I tried this LENGTH(‘Field’) 500 But it didn’t like that. Anne Ramey *** 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 only by an authorized State Official. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Active link to check field size
Bummer. I was hoping it didn’t have to be a 2 step process. Thanks Anne Ramey *** 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 only by an authorized State Official. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, March 14, 2011 10:50 PM To: arslist@ARSLIST.ORG Subject: Re: Active link to check field size ** Anne, You are close but not quite that close...You can’t use it that way in a qualification.. Those functions are set field functions that can be used only in set or push fields actions.. So create a temp integer field to hold the value of LENGTH(‘Field’) and then use that temp field in the qualification in an active link that runs in an order after the first active link.. Hope this helps.. Cheers Joe From: Ramey, Annemailto:anne.ra...@nc.gov Sent: Monday, March 14, 2011 10:18 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Active link to check field size ** I must be being dense, but I’m trying to write an active link that only fires if a field is more than a certain length. Can’t figure out how to do that. Know how to trim it and set the length, but not check it in the qualification. I tried this LENGTH(‘Field’) 500 But it didn’t like that. Anne Ramey *** 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 only by an authorized State Official. _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_
Re: Active link to check field size
Unfortunately that’s how it is designed.. Those functions are not available at the Run If level. Functions whose result is not a void but a value are used in set field / push field kind of operations.. Only KEYWORDS can be used in Run If qualifications directly to be evaluated in an expression.. Cheers Joe From: Ramey, Anne Sent: Monday, March 14, 2011 10:55 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Active link to check field size Bummer. I was hoping it didn’t have to be a 2 step process. Thanks Anne Ramey *** 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 only by an authorized State Official. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, March 14, 2011 10:50 PM To: arslist@ARSLIST.ORG Subject: Re: Active link to check field size ** Anne, You are close but not quite that close...You can’t use it that way in a qualification.. Those functions are set field functions that can be used only in set or push fields actions.. So create a temp integer field to hold the value of LENGTH(‘Field’) and then use that temp field in the qualification in an active link that runs in an order after the first active link.. Hope this helps.. Cheers Joe From: Ramey, Anne Sent: Monday, March 14, 2011 10:18 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Active link to check field size ** I must be being dense, but I’m trying to write an active link that only fires if a field is more than a certain length. Can’t figure out how to do that. Know how to trim it and set the length, but not check it in the qualification. I tried this LENGTH(‘Field’) 500 But it didn’t like that. Anne Ramey *** 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 only by an authorized State Official. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: View Forms
It should let you add the new field to the existing view, unless like Fred pointed out. if that field is a data type that is not supported by the AR engine.. I have added fields in the past on the fly and have been able to have my view for read the new field.. If the field is a supported data type, I would check to see if there is an open known issue with AR system 7.1 Patch 7 or thereabouts with view forms... Joe -Original Message- From: Kemes, Lisa Sent: Monday, March 14, 2011 3:32 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: View Forms This is correct. I updated the View and then opened the view form to add the field. It's not greyed out so it lets me choose Fields from MyView but then it doesn't do anything. I added a brand new view form and purposely left out the new field. Created it, then tried to add the new field and it lets me. Just doesn't let me do this with the already existing View Form that I already have. I then added another new field to the view and I was able to add this to my Brand New View form as well. Looks like my old View form might be corrupted or something. It's pretty old Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Monday, March 14, 2011 2:40 PM To: arslist@ARSLIST.ORG Subject: Re: View Forms You updated the view and then opened the form to add the field? The list of fields able to be added is generated when the form is opened in the Admin tool. Another possibility is you are using a type of field that ARS does not work with. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, March 14, 2011 1:21 PM To: arslist@ARSLIST.ORG Subject: View Forms ** I recently updated a view on the database with an extra field and I would like to add this field to my View Form. When I right click on my form I get the option to select a field from my view, but when I click on it nothing comes up. Are View Forms sort of locked out if you update your view? Do I have to create a new view? (I did and I was able to include my new field), but I would like to add this field to my already existing view. AR System 7.1 p7 Oracle Lisa Kemes AR System Developer +01 717 810 2408 tel +01 717 602 9460 mobile lisa.ke...@te.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Filter Service Calls data base commits...
I have the same trouble with the error handler feature. I was so excited when it was introduced but then realized it wasn't exactly what I wanted it to be once I used it. It seems you still need many filter qualifications to account for all of the different situations that will cause an error in your process. For example we have a custom db table where records are inserted and an escalation touches the new records using a Vendor Form to bring them into ARS processing (filter pushes them to a Help Desk ticket). There are a number of errors that can occur: invalid CTI combination, invalid Region, Site, Department combination, missing Region, Site or Department, etc. When this happens we want a ticket created to review and correct the record so it can be processed for the customer. When we initially created the process we though if the push fields fails say because a require field on the destination form is missing then our error handler field would create the ticket to research the failure and processing would stop after that. This statement is where our idea fell flat: Pg 165 of 7.5 Workflow Objects Guide When all the If actions of the error handling filter complete successfully, *the error is considered handled*, the error information and keyword is cleared, and the filter in which the error occurred continues execution with the next action. If another error occurs during the execution of the filter, the error handler is executed again. In our initial development attempt would end up with a ticket to research the error and a ticket missing the required field(s) (who knew that was possible, they are required). So then the though was to throw an error in the error handler after the research ticket push fields but then entire transaction rolled back and neither tickets were created just as if we didn't even have the EH. We ended up having our push fields filter still evaluate that all of the requirements were met in the qualification. At the very end if the source record status is still New (would have been set to Processed if ticket was created) then we assume an error has occurred, set the status to Error and create a ticket to research. Another similar process on a web service integration form varies a little bit by throwing an error if a pre-check fails (CTI, RSD, item # not in the catalog). The error handler is called and sets the status field to Error. The pre-checks continue since the error was handled and concatenates the $ERRMSG$ and $ERRNO$ to a character field that is returned in web service. All of the filters that do push fields do not fire if 'Status' = Error. In both situations we need to figure out all of the possible points of failure ahead of time. If an unexpected error is encountered then our error handling actions fall apart. I see value in the way it is designed but it would be nice if there was an option to terminate normal processing if an EH filter is called and only process the filters triggered by the EH. Sometimes you want to take a special action due to an error but you still want a hard error that stops the original processing. Jason On Mar 14, 2011 2:04 PM, Misi Mladoniczky m...@rrr.se wrote: Hi Robert, Maybe, but the documentation does not say anything about this. This would both limit and extend the use of servive-calls I guess. In my case, when my service picks the next of several counters, it will create holes in my counter-series. I guess I have to redesign... Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): * 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. My understanding is that since you are calling a Service (just like consuming an external web-service logically) that is an independent transaction. So an ERROR Trap will need to be constructed, and then service X_rollback would need to be called in the error handling... Yes it adds much complication... HTH Robert On Mon, Mar 14, 2011 at 12:48 PM, Misi Mladoniczky m...@rrr.se wrote: Hi, I have created a Filter Service that I call from a filter. The problem is that data seems to be committed to the database even though there is an ERROR later on in the processing. A1. Modify Filter in form A: Call Service X X2. Service Filter: pushes data to form X A2. Modify Filter in form A: generates ERROR (phase 2) The data pushed to form X via the Service Filteris commited to the data Is this as designed??? I was under the impression that everything should be rolled back if you have a failiure. At least if you refrain from meddling with the filter phasing, which I have not done... Any comments? ARServer version 7.6.04 on MS SQL Server. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award
