Re: Transactional (TR) and Database (DB)
There is nothing wrong with the use of TR and DB comparisons - in fact it is the only way out when you really want to compare what is in the database currently, and what is being sent forth as a transaction on modification filters. You could not use it if you want to but that would mean you would have to build hidden fields and additional logic on GE to set those hidden fields with values that have been retrieved, if you want to compare them with values that are set during the transaction. That is additional work that might not have been necessary. There are examples again when setting hidden fields with current values may be preferred over TR and DB use, for e.g. If you want to use both the values OR if you want to use the 'previous' value in post transaction logic such as notification or other things. But I do not see why the use of TR and DB in filter comparison can be a bad thing IF used correctly. I have capitalized IF because it is easy to misunderstand the use of TR and DB and wrongly construct your qualification, and get a weird result especially when comparing your TR value to NULL. BE VERY CAREFUL in evaluating your qualifiations when comparing your TR value to NULL and understand what TR means thoroughly before you use it. I'm quite certain you might have misunderstood the directions of the likes of Misi if they had a recommendation on this concept. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of James Smith Sent: Thursday, May 08, 2014 11:22 AM To: arslist@ARSLIST.ORG Subject: Transactional (TR) and Database (DB) Hi List, We can achieve things without using TR and DB values in a filter by just using Field but I do not understand why they have been developed to use? I have heard from many remedy developers like Misi and BMC who suggest not to use TR and DB in Run If qualification of a filter but why? Why it is not recommended to use TR and DB values? What if I use TR.Field=DB.Field? Will it yield a correct result? In BMC documentation also they have not given any example where they used TR and DB together in a qualification. Appreciate your thoughts! Cheers, James ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
What is the best possible way to build Asset - People relationship?
At a client, the need is to do CI-People relationship. As per BMC, they had achieved this for BBCA by writing some rules – not sure at CMDB level or BBCA. Since footprints - BCM tool captures this information (CI and associated login name) – is there any way to build Asset-People Relationship or has anyone see/done this kind of automated relationship building? How to achieve this relationship? One way is creating the CSV template and load the data into the AST:AssetPeople form. But, populating the sheet is tedious job as it involves lot of manual steps. Please suggest. Thanks in advance. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Transactional (TR) and Database (DB)
James, TR.Field - Transactional value. Its the value that will be used in the UPDATE sql statement that gets sent to the database. DB.Field - Database value. It's the value that is currently in the database. Field - Without TR or DB, the value used is the most current value for the field. In my passionate opinion :-) TR has no value and should never be used; however, the DB value is useful. The DB value is useful to detect if a field value is different from what is in the database. The Run If would be ('Field' != 'DB.Field'). That qualification will always work to detect a difference. The TR value is often suggested as a way to detect if a field has changed, as in ('TR.Field' != 'DB.Field'). The issue with this is that if the field isn't part of the update, the TR value will be null, so then you have to test for that, as in ('TR.Field' != 'DB.Field' AND 'TR.Field' != $ NULL$). But sometimes the field is being cleared out, the field is legitimately changing to null, so in that case the TR value is null because that's the new value, not because it didn't change. So then you need to account for that. It gets messier and messier. Sometimes this is suggested: ('TR.Field' != $ NULL$ ) It has all the same issues detecting for null, plus this... During a push field action, all the fields listed will be part of the UPDATE statement (meaning they will have a TR value), regardless of whether or not the values are changing. So your filter will fire even though the value didn't change. Maybe that's a problem, maybe its not. Either way your code isn't doing what was intended. So using a TR value is confusing at best, and sometimes outright wrong, when a simple ('Field' != 'DB.Field') always does the trick. As far as your question about (TR.Field=DB.Field), most likely that will not give you the results you want, but you hadn't stated what you have in mind by correct so I couldn't say for sure. (for your clause to come out as true, the two values would have to be equal. That would only be the case in the push fields situation above.) Hopefully that clarifies things. Thad On Thu, May 8, 2014 at 8:21 AM, James Smith bmcremedyarslis...@gmail.comwrote: Hi List, We can achieve things without using TR and DB values in a filter by just using Field but I do not understand why they have been developed to use? I have heard from many remedy developers like Misi and BMC who suggest not to use TR and DB in Run If qualification of a filter but why? Why it is not recommended to use TR and DB values? What if I use TR.Field=DB.Field? Will it yield a correct result? In BMC documentation also they have not given any example where they used TR and DB together in a qualification. Appreciate your thoughts! Cheers, James ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: ADM: still having email issues, might take a while for me to fix this
Just about an hour ago I used the web UI to reply to a discussion but it hasn't show up on the web yet. I just posted via email and that showed up in the web UI almost instantly. It doesn't appear that the web is 100% working. Jason On Wed, Apr 30, 2014 at 4:45 AM, arslist arsl...@danielbloom.ca wrote: ** I don’t think that is the factor, but I will keep track of it for now. Dan *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Axton *Sent:* April 29, 2014 11:53 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: ADM: still having email issues, might take a while for me to fix this ** I seem to have them all though there are some discrepancies in time. With the way things are shaping up in the US you might need to reach out to US ISP's and pay them to have your traffic prioritized (that was a hint to get involved... to all you US residents; sign a petition, send an email, write a letter, make a phone call). Here are the timings from my gmail account and the arslist.org web interface for the messages in the last 24 hours: Re: Fast v.s. List Threads Wed, 30 Apr 2014 00:06:21 + 4/29 9:03pm US/Central Re: Indirect reference to form field value Tue, 29 Apr 2014 22:50:19 +0200 4/29 6:18pm US/Central Fast v.s. List Threads Tue, 29 Apr 2014 11:39:36 -0700 4/29 9:03pm US/Central OT: Cox Enterprises is looking for a BMC BPPM Monitoring Engineer(Job Number: 141359) Tue, 29 Apr 2014 17:15:08 + 4/29 9:04pm US/Central ADM: still having email issues, might take a while for me to fix this Tue, 29 Apr 2014 10:44:13 -0400 4/29 9:04pm US/Central Re: Indirect reference to form field value Tue, 29 Apr 2014 06:59:18 -0400 4/29 6:18pm US/Central Re: Application Tab Won't Fly back In Tue, 29 Apr 2014 10:05:58 -0400 4/29 9:06am US/Central Re: DMT not working, showing as In Progress. Tue, 29 Apr 2014 15:20:53 +0530 4/29 8:33am US/Central Changing the font color on the Incident Summary field Mon, 28 Apr 2014 16:43:24 -0400 4/28 3:43pm US/Central Axton Grams PS Dan, sorry for the political plug... I couldn't resist. On Tue, Apr 29, 2014 at 9:44 AM, Daniel daniel.bl...@danielbloom.ca wrote: ** Note: some seem to get through to me, others don’t. the web site has everything. If anyone is getting all of them please let me know off list. Thanks Dan _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Test via email
The email worked. I see it in the web UI almost instantly. This update is from the web. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
FW: Remedy job with Cisco in RTP, NC
FYI Thanks, Shawn Pierson Remedy Developer | Energy Transfer 1300 Main St. Houston, TX 77002 | 713.989.7226 IT Service Desk: 1.855.658.2468 If you would like to report an issue with Remedy, please click herehttp://remedy/issue.html to enter an Incident. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Bharad w Sent: Tuesday, May 06, 2014 3:32 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy job with Cisco in RTP, NC ** Hi kessler, This is Bharadwaja Damera I am interested in this position . can I know whether this position still open. waiting for your positive response. Thanks Bharadwaja Damera 256-856-2156 On Sat, Mar 29, 2014 at 4:43 PM, Rod Kessler rkess...@teksystems.commailto:rkess...@teksystems.com wrote: If anyone knows any Remedy consultants who would be interested in a 1 year+ contract with Cisco Systems in RTP, NC, email rkess...@teksystems.commailto:rkess...@teksystems.com. Job Description: 1. Candidate must have experience designing, configuring, implementing BMC Remedy v 7.5 (or near version) 2. Candidate must have knowledge (Certification Preferred) of ITIL practice (foundation level) 3. Experience in managing/configuring mission critical Remedy implementation in large enterprise or service provider environment. 4. Excellent communication , documentation skills, team player 5. Quick learner of Remedy Implementation so as to support the environment. 6. Integration using Web Services with Remedy will be a strong +ve. 7. Flexible to work with multiple timezones. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ Private and confidential as detailed here: http://www.energytransfer.com/mail_disclaimer.aspx . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: ARS 7.6.04 install on Linux using Command Line
Hi Saurabh, I have sent you a mail. The sample files may be for fresh install or upgrade. You may need to correct some paramters as per your need !! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Approve : 3102 An instance of the Distributed Server is already running.
Hello, I recently upgraded our TEST environment from Remedy 7.6.04 SP4 to Remedy 8.1.01 (ARS/ATRIUM/ITSM). I am getting the following error in the arerror.log file: Approve : 3102 An instance of the Distributed Server is already running. Anyone have any ideas on what is causing this? I configured approval server to run in a separate plug-in instance and disabled the default approval server plugin and I am still getting the error message. Thoughts? Chris Wilson ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Transactional (TR) and Database (DB)
Some wonder why TR was built others say it works fine. I thought I had a good handle on TR but now reading the differing opinions I am questing my understanding of TR. Some posts indicate it is completely useless and can't be trusted. Some other indicate like a weapon as long as you treat it with respect and know how to you it you'll be fine. So off the the archives I went: http://ars-action-request-system.1.n7.nabble.com/TR-vs-DB-sanity-check-please-tp99981p3.html Doug set it straight in 2010. After rereading his post I am questioning the purpose of TR. QUOTE: 'A' != 'DB.A' is all the testing you need to see if the value has changed If DB all that is needed what is a valid use case for having TR. Not one that can be down with TR or DB but what is that TR provides that cannot be done otherwise? Jason BTW, hope this didn't post twice. I used the web UI because of the recent email issues but when I checked I don't see my reply which is usually instant on the web. I waited a few minutes and fired again. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Dynamic user-specific color coding for table field rows and columns
Thanks Charlie and Misi for your ideas. If anyone has other ideas,please share with me. Thanks Regards Robin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Service target goes from attached to In Progess only if the ticket is modified. (SLM 7.5 )
Hi Experts, I need to start a service target based on future date and time: 2 days after a ticket was created. but issue is It only goes from attached to In Progess if the ticket (work order) is modified. Start when - 'WO Type Field 06'= $\TIMESTAMP$ .( WO Type Field 06 is a date and time field on work order form) Version- SLM 7.5 Thanks, Harry ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Transactional (TR) and Database (DB)
James, I've been doing Remedy for awhile now, and I'll be honest...I don't use TR much, and most people that DO use it, don't understand the intricacies of using it properly. DB is a good tool for determining if the current value is different than the currently stored in the DB value, and I use it regularlythe reason you don't see many examples of TR and DB used in the same qualification is because of how TR functions, which makes it somewhat irregular. So, the reason that TR is tricky is because it doesn't indicate what you think it should. Upon initial inspection you would think that if TR is not null, that means that it's being changed...and if TR is null, that means it's not being changed...but if you took that definition, you would be entirely WRONG. TR being null means one of two thingseither the value isn't being changed, or it's being changed to a null value...there is no way through a run-if to tell which. TR being NOT Null means that it's being set to that value...but says nothing about if that is a change or not. TR can be set to a value by actually being set to that value through the GUI, or it could be set to a value through pushagain...the fact that TR is not null gives NO indication of if it's changing or not...so... a qualification of TR.Field=DB.Field would indicate that the initiation of the update was setting the field, and that it is being set to the same value as is currently there. The most common of 'oh no, that's not what you meant' that I've seen is the opposite of that though TR.Field != DB.Fieldmost people when they write that think they are saying 'the value is changing', but as described above...it doesn'tif the value isn't being set, that would be a true boolean, but not what the user thinks it should mean. oh...another caveat regarding the DB...if using DB during a Submit operation...the DB value will always be null...:) On Thu, May 8, 2014 at 9:21 AM, James Smith bmcremedyarslis...@gmail.comwrote: Hi List, We can achieve things without using TR and DB values in a filter by just using Field but I do not understand why they have been developed to use? I have heard from many remedy developers like Misi and BMC who suggest not to use TR and DB in Run If qualification of a filter but why? Why it is not recommended to use TR and DB values? What if I use TR.Field=DB.Field? Will it yield a correct result? In BMC documentation also they have not given any example where they used TR and DB together in a qualification. Appreciate your thoughts! Cheers, James ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Transactional (TR) and Database (DB)
James, Can't say I have heard anyone saying not to use it. Comparing the current value on the database against the current value on the client can be very useful when you want to take an action only when the field value changes. If TR.Status !=DB.Status is like saying if the Status changes If TR.Status !=DB.Status and TR.Status = Closed is like saying when the ticket is closed Now I have heard that in some cases the TR causes some issues and it is best just to leave it off If Status !=DB.Status and Status = Closed again iss like saying when the ticket is closed and when I create a filter with a comparison, this is the format I use. Hope this helps Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of James Smith Sent: Thursday, May 08, 2014 11:22 AM To: arslist@ARSLIST.ORG Subject: Transactional (TR) and Database (DB) Hi List, We can achieve things without using TR and DB values in a filter by just using Field but I do not understand why they have been developed to use? I have heard from many remedy developers like Misi and BMC who suggest not to use TR and DB in Run If qualification of a filter but why? Why it is not recommended to use TR and DB values? What if I use TR.Field=DB.Field? Will it yield a correct result? In BMC documentation also they have not given any example where they used TR and DB together in a qualification. Appreciate your thoughts! Cheers, James ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years This E-mail and any of its attachments may contain Time Warner Cable proprietary information, which is privileged, confidential, or subject to copyright belonging to Time Warner Cable. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Notification needs to send every assignment changes into task.
Team, Got new requirement to send a email notification when assignment fields changes from one group to other. In OOB Task having an issue with email notification. if the task has been created by task template(Single template multi purpose, so assignment field is an empty) with out assignment fields that task went toStaging status.When the appropriate incident went from In progress that time task will go toPending stays with out assignment entry. After the pending status, i filled the assignee group and name and it's not sending the group and individual notification. Based on this scenario, need to write work flow every time assignment field changes notification will send. Can you please advise how to fix this? Remedy Version 8.1. Regards, SureshLoganathan . ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Dynamic user-specific color coding for table field rows and columns
Hi, This strategy is basically sound, but why do it with SQL-stuff when a normal Join-form will get the job done just as well? Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Hi Robin, Unfortunately, no, you can't directly do what you want here. The table column coloring configurations are embedded in some very low level display properties associated with the table column fields in the data dictionary. There is no way to either dynamically change these, or have user specific configurations. I actually *can* think of a solution, but it'd be pretty involved and would require: 1) An additional form to capture the users' color configurations for each Priority value to a limited pre-existing set of colors (one entry for each user and Priority value) 2) Creating a SQL view joining that configuration with the source table, and pulling in that user configuration data 3) Creating a Remedy View on top of the SQL View, and adding a Selection field on top of the user color configuration value 4) Setting up the table (or column) to use this field as the 'Resuts Color' source with the pre-existing colors. 5) You'd have to also add a UI allowing the users to add/edit this configuration. I'm not sure this is very clear...this is off the top of my head, but I'm pretty sure it could be made to work. Like I said though, it's pretty involved and would take a bit of time to put together. Charlie On Tue, May 6, 2014 at 11:56 PM, Robin Mathew robi...@rediffmail.comwrote: Hi all, I request your help for the following requirement. Requirement I need to provide a configuration screen to user where he can define color coding for table field rows and columns. Example,suppose a table field has 'Priority' column.In the configuration screen,provision should be given to the user for selecting any color for Priority column. if 'User A' selects green color for Priority column,when he view this table field,Priority column should be displayed in green color. if 'User B' selects Red color for Priority column,when he view this table field,Priority column should be displayed in Red color. Similarly, provision should be given to user for defining color coding for table field rows. Example,User A wants to define Blue color for table field row if a record has Priority = Medium. User B wants to define Yellow color for table field row if a record record has Priority = Medium. Is it possible to set user-specific color coding for table field rows and columns in remedy table field? if not possible in Remedy,kindly suggest any other options. Thanks Robin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Set Month End Date
No. Look at Action 1 again. It starts the calculations with the 1st of the month. I was just trying to illustrate the logic behind the calculation. As Misi points out (in another post) it can be performed in a single Set Fields action Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of pritch Sent: Wednesday, May 07, 2014 4:34 PM To: arslist@ARSLIST.ORG Subject: Re: Set Month End Date Wouldn't the calculation of 32 days cause it to possibly jump over a month? ie if the ticket is created on March 31 (or even March 30) it would calcuate a date in May. Rather than try to play with the days - could we do something like this? Set Fields actions (in Filter or Active Link) Action 1:$ztmp datetime field$ = DATEADD(mm, 1, $DATE$) Action 2:$ztmp datetime field$ = MONTH($ztmp datetime field$) + /1/ + YEAR($ztmp datetime field) Action 3:$ztmp datetime field$ = $ztmp datetime field$ - 1 - Original Message - From: Frederick W Grooms frederick.w.gro...@xo.com To: arslist@ARSLIST.ORG Sent: Wednesday, May 7, 2014 11:35:12 AM Subject: Re: Set Month End Date This is the way I have done it in the past (Note: I am using US date format so convert as needed) Set Fields actions (in Filter or Active Link) Action 1:$ztmp string field$ = MONTH($DATE$) + /1/ + YEAR($DATE) Action 2:$ztmp datetime field$ = $ztmp string field$ Action 3:$ztmp datetime field$ = $ztmp datetime field$ + (32 * 86400) Action 4:$ztmp string field$ = MONTH($ztmp datetime field$) + /1/ + YEAR($ztmp datetime field) Action 5:$ztmp datetime field$ = $ztmp string field$ Action 6:$ztmp datetime field$ = $ztmp datetime field$ - 1 At this point the display only datetime field has 11:59:59 PM of the last day of the month I broke the example out into individual set fields actions so you can see exactly what is happening. Here is what each action is doing: Action 1: Create a string of the first day of the current month Action 2: Put the string into a date field Action 3: Add enough days to make the temp field the next month Action 4: Create a string of the first day of the month of the temp date field Action 5: Put the string into a date field Action 6: Subtract 1 second from the temporary date field to get the last day of the previous month Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Terje Moglestue Sent: Wednesday, May 07, 2014 7:37 AM To: arslist@ARSLIST.ORG Subject: Re: Set Month End Date ** Karthick, It is years since I have done this type of calculations. In your example I would find the first day of the next month and then just take minus one day. The outcome would the last day of the month you are in. ~ Terje -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Karthick S Sent: Wednesday, May 07, 2014 8:50 AM To: arslist@ARSLIST.ORG Subject: Set Month End Date ** I need to Set a Month End Date in a field Called Due Date. Please find the below. Example: Ticket created Date is 7/05/2014 12:00:00 AM and the Due Date should have 31/05/2014 11:59:59 PM. it should automatically calculate or populate the Month End Date in Due Date field. I have used this condition ($DATE$ + 43200) + (86400 * 31)) - (86400 * DAY((($DATE$ + 43200) + (31 * 86400) - (3600 * HOUR((($DATE$ + 43200) + (31 * 86400) + (DAY($DATE$) * 86400)) - 1, Which given me the Due Date as 7/06/2014 11:59:00 PM. Can any one help me on this, Please. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Transactional (TR) and Database (DB)
Some wonder why TR was built others say it works fine. I thought I had a good handle on TR but now reading the differing opinions I am questing my understanding of TR. Some posts indicate it is completely useless and can't be trusted. Some other indicate like a weapon as long as you treat it with respect and know how to you it you'll be fine. So off the the archives I went: http://ars-action-request-system.1.n7.nabble.com/TR-vs-DB-sanity-check-please-tp99981p3.html Doug set it straight in 2010. After rereading his post I am questioning the purpose of TR. QUOTE: 'A' != 'DB.A' is all the testing you need to see if the value has changed If DB all that is needed what is a valid use case for having TR. Not one that can be down with TR or DB but what is that TR provides that cannot be done otherwise? Jason ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Transactional (TR) and Database (DB)
Hi, The TR values are pretty useless. The reason is that a TR value can be set to NULL either by a change to NULL or by not changing the field at all. In the latter case the field will retain the value in the database after the transaction, but in the first case the NULL will be written to the database. This is how you check for a field data change: ('Field' != 'DB.Field') Sometimes you want to trigger things only on a non-null-change on an optional field in which case you write: ('Field' != 'DB.Field' AND 'Field' != $NULL$) The TR values can be used as a lazy, and non exact, way to trigger a few things: ('TR.Assigned To' != $NULL$) = Send notification to new assignee It is sometimes possible that the notification will be sent without the data actually being changed, in which case you can extend the qualification. But in that case it is as easy to use 'Field' as 'TR.Field'. These are equivalent: ('Field' != 'DB.Field' AND 'Field' != $NULL$) ('TR.Field' != 'DB.Field' AND 'TR.Field' != $NULL$) Note that Push-Fields typically sends transactional values even without a change, but a normal 'Save' by the user will send TR-values only for those fields which has been changed. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Some wonder why TR was built others say it works fine. I thought I had a good handle on TR but now reading the differing opinions I am questing my understanding of TR. Some posts indicate it is completely useless and can't be trusted. Some other indicate like a weapon as long as you treat it with respect and know how to you it you'll be fine. So off the the archives I went: http://ars-action-request-system.1.n7.nabble.com/TR-vs-DB-sanity-check-please-tp99981p3.html Doug set it straight in 2010. After rereading his post I am questioning the purpose of TR. QUOTE: 'A' != 'DB.A' is all the testing you need to see if the value has changed If DB all that is needed what is a valid use case for having TR. Not one that can be down with TR or DB but what is that TR provides that cannot be done otherwise? Jason ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: What is the best possible way to build Asset - People relationship?
Are you looking to create many relationships at once? I have built filters against a custom shipping/fulfillment module that reads the instance ID of the user and the CI/asset and creates the required relationship record. This is dependent on the agent selecting a user from the People form in the same manner as when creating an Incident and then selecting the CI row in a table on a custom display-only form. If you are looking to create single relationships I can provide more detail. -Rick _ Rick Westbrock Remedy Administrator | IT Department 24 Hour Fitness USA, Inc. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hemant Jangid Sent: Thursday, May 08, 2014 10:58 AM To: arslist@ARSLIST.ORG Subject: What is the best possible way to build Asset - People relationship? At a client, the need is to do CI-People relationship. As per BMC, they had achieved this for BBCA by writing some rules – not sure at CMDB level or BBCA. Since footprints - BCM tool captures this information (CI and associated login name) – is there any way to build Asset-People Relationship or has anyone see/done this kind of automated relationship building? How to achieve this relationship? One way is creating the CSV template and load the data into the AST:AssetPeople form. But, populating the sheet is tedious job as it involves lot of manual steps. Please suggest. Thanks in advance. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Transactional (TR) and Database (DB)
Agreed. On May 10, 2014 1:08 PM, Joe D'Souza jdso...@shyle.net wrote: While most of everything you stated is in sync with my understanding of TR, there is one small difference. MAYBE, I'm wrong and if so, I would love to be corrected. I can best explain this with an example. Lets say a record is created and there is a field called 'City' and during creation, that field was set to Gotham.. Case 1: When there is no change in the 'City' value during the modification. 'City' = Gotham 'TR.City' = $NULL$ (as there was no transactional change in the value) 'DB.City' = Gotham Case 2: When the value in the field 'City' is changed during a modification to Xanadu 'City' = Xanadu 'TR.City' = Xanadu 'DB.City' = Gotham So according to my understanding, it is incorrect to say that 'TR.City' is the same as 'City' at all times. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow Sent: Friday, May 09, 2014 9:28 AM To: arslist@ARSLIST.ORG Subject: Re: Transactional (TR) and Database (DB) I think there's a few reasons. First, using TR. is redundant. Every value in a filter (unless it already has DB. in front of it) is by it's nature a transactional value. There's literally almost no reason to use, it, EXCEPT that it makes the code a bit more clear from a visual standpoint if you do decide to use DB. on a field. I think the reason most people don't use DB. on field workflow is that it's kind of perceived as lazy. Let's say you want to check and see if a phone # has changed. You can either use the Phone != DB.Phone at runtime - or you can do an actual lookup with some separate workflow prior to this action. That gives you greater control over the action going on for the most part. That said, it's just my opinion and I'm sure there's lots of place people have used both and been perfectly happy with it. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of James Smith Sent: Thursday, May 08, 2014 10:22 AM To: arslist@ARSLIST.ORG Subject: Transactional (TR) and Database (DB) Hi List, We can achieve things without using TR and DB values in a filter by just using Field but I do not understand why they have been developed to use? I have heard from many remedy developers like Misi and BMC who suggest not to use TR and DB in Run If qualification of a filter but why? Why it is not recommended to use TR and DB values? What if I use TR.Field=DB.Field? Will it yield a correct result? In BMC documentation also they have not given any example where they used TR and DB together in a qualification. Appreciate your thoughts! Cheers, James ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years - No virus found in this message. Checked by AVG - www.avg.com Version: 2014.0.4570 / Virus Database: 3931/7443 - Release Date: 05/05/14 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years