Remember that as of 7.5 when you create/ modify a CTM:People record a new BMC_Person is created in the Sandbox then reconciled into BMC_Person. We found out when we ran our People update job and ground the system to a halt due to the reconciliation job running "inline" instead of "scheduled".
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of strauss Sent: Friday, March 12, 2010 12:44 PM To: [email protected] Subject: Audit Log data ** We are in the process of testing the move of all necessary data from an ITSM 7.0 system to an ITSM 7.6 system, which we will have to do again or at least update prior to moving the 7.6 system into production. Several of the tables with data are the three aliased identically (by some clueless BMC programmer(s)) as "HelpDesk System Audit Log" - they are really CTM:AuditLogSystem, HPD:HelpDesk_AuditLogSystem, and CHG:ChangeRequest_AuditLogSystem. The HPD one has 193 K records, and the CTM one has over 2 million records. We don't use Change enough for those records to matter (138 of them). Does anyone have a feel for how abandon-able this data is??? We have been studying it, and don't really see any utility in bringing it forward. We have never used it for anything, so I don't think we're going to miss it - unless doing so breaks something in the plumbing. The act of importing our CTM:People data generated one NEW CTM:AuditLogSystem record for every person imported or updated (rrrchive overwrite moved 214,966 records); bringing in the data from the source server would overwrite that, but why bother at all?? At this point, those 2 million-plus records look expendable to me. Any thoughts from the list?? Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
