Hi, Joanne: I would expect there to be changes.
ITSM 8.1.02 was just a Service Pack, but came with significant changes and many undocumented features. ;) Much to our surprise, one of the undocumented features was a change in field Ids for existing fields between ITSM 8.1.00 and ITSM 8.1.02 (aka SP2) . The impact of this was felt especially by the reporting team. This was apparent on all of the main forms like Change, HPD:Help Desk, Work Order, etc…. Shown below are the field Id discrepancies for the Work Order form when we upgraded from 8.1.00 to 8.1.02. ITSM_8.1.02_FIELDID ITSM_8.1.00_FIELDID FIELDNAME 420050002 550000004 Abydos Process Status 420050003 550000008 Abydos Process Version 420050101 550000001 Abydos Process Name 420050100 550000005 Abydos Template ID 420050103 550000007 Abydos SLA Name 420050005 550000050 Abydos Use Wizard? 420050001 550000020 Abydos Notify Text 420050000 550000021 Abydos Notify Recipient 420050004 550000009 Abydos Tasks Generated 420050008 550000068 Total Fields Count 420050007 550000011 Override Group 420050102 550000040 Abydos AuditFlag 420050006 550000110 Active Tasks 420050012 550000140 z1D StatusInt 420050015 555000000 z1PF_ProcessDesigner 420050024 550000113 z5Text_Additional_Data 420050021 550000115 z2TH_ProcessData 420050106 550000114 z3Btn_Refresh_Table 420050025 550000118 z5Text_SRM_Title 420050020 550000091 z2TH_Add_SR_Data 420050022 550000125 z3Btn_Refresh_SRTable 420050014 555000004 z1PF_Additional Details 420050036 550000116 z2TF_Fld_Name 420050018 550000117 z2TF_Char_Val 420050017 550000092 z2TF_Add_SR_Data_FieldName 420050016 550000093 z2TF_Add_SR_Data_CharValue 420050104 550000101 btn_Abydos Wizard 420050105 550000103 btn_View Request Status Hope this helps, Michelle From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Ben Chernys Sent: Thursday, August 06, 2015 1:21 PM To: [email protected] Subject: Re: Transition from 7.6.4 to 8.1 impact to reporting? ** There are minor changes to existing schemas. If you pick up our Free 7.6.04 and 8.1 forms and fields spreadsheets<http://softwaretoolhouse.com/freebies>, you can easily do “diff”s. Cheers, Ben Chernys Senior Software Architect [logoSthInc-sm] Canada / Deutschland Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: Ben.Chernys_AT_softwaretoolhouse.com <mailto:Ben.Chernys_AT_softwaretoolhouse.com>Web: www.softwaretoolhouse.com<http://www.softwaretoolhouse.com/> We are a BMC Technology Alliance Partner Check out Software Tool House's free Diary Editor and our Freebies<http://softwaretoolhouse.com/freebies> Section for ITSM Forms and Fields spreadsheet. 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. Meta-Archive does ITSM Archiving your way: with your forms and your multi-tenant rules, treating each root request as the tree of data and forms that it is it is. Pre ITSM 7.6.04? Clarify? Roll your own? No problem! You can keep your valuable data! http://www.softwaretoolhouse.com/ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joanne Janssen Sent: August-06-15 19:49 To: [email protected]<mailto:[email protected]> Subject: Re: Transition from 7.6.4 to 8.1 impact to reporting? ** It includes ITSM On Thu, Aug 6, 2015 at 1:39 PM, Lucero, Michelle <[email protected]<mailto:[email protected]>> wrote: ** Hi, Joanne: Does your transition include ITSM 8.1.02? Or, is this just AR System? Michelle From: Action Request System discussion list(ARSList) [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Joanne Janssen Sent: Thursday, August 06, 2015 12:14 PM To: [email protected]<mailto:[email protected]> Subject: Re: Transition from 7.6.4 to 8.1 impact to reporting? ** That's a good start! But you know its always the little things that get ya. Well see On Thu, Aug 6, 2015 at 12:49 PM, LJ LongWing <[email protected]<mailto:[email protected]>> wrote: ** there is not a fundamental shift or anything if that's what you are asking :) On Thu, Aug 6, 2015 at 10:48 AM Joanne Janssen <[email protected]<mailto:[email protected]>> wrote: ** All, Our organization is transitioning from V7.6.4 to V8.1 and I am responsible for a number of reports. I have been assured by the team that there are no changes to the underlying database, but have not been given access to test this out. Does anyone know if there are changes to field names, tables or relationships between tables? I hate to find out on the fly. Thanks Joanne _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_ ________________________________ This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditions available at http://www.bankofamerica.com/emaildisclaimer. If you are not the intended recipient, please delete this message. _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ No virus found in this message. Checked by AVG - www.avg.com<http://www.avg.com> Version: 2015.0.6086 / Virus Database: 4392/10383 - Release Date: 08/06/15 ________________________________ No virus found in this message. Checked by AVG - www.avg.com<http://www.avg.com> Version: 2015.0.6081 / Virus Database: 4392/10323 - Release Date: 07/28/15 Internal Virus Database is out of date. _ARSlist: "Where the Answers Are" and have been for 20 years_ ---------------------------------------------------------------------- This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditions available at http://www.bankofamerica.com/emaildisclaimer. If you are not the intended recipient, please delete this message. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
