We didn't do any reconciliations because the users who own this data don't trust automation (which unfortunately did cause the problem in this case) so they wanted to perform the creation and updates of Computer System CIs manually.
My plan was to use AIE, but since the data I want to fix is limited to the computer system data itself, I may just try doing it all through SQL and getting it fixed faster even if it's not the recommended way. Thanks, Shawn From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Thursday, December 10, 2009 12:15 PM To: arslist@ARSLIST.ORG Subject: Re: Using AIE to restore Asset Data ** Are you saying that you have a backup of the Asset data that was in Remedy? Does that backup include the Reconciliation ID? If it does, then you don't need to match on anything, you would simply need to do a Merge between the datasets, because everything should already be matched up (by definition, anything that has a recon id (something other than zero) is already matched to something, so it doesn't try to identify it again). You might need to define Precedence rules to only set the fields that have gone missing (to avoid overwriting any other data that may have changed since the backup), though. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn Sent: Thursday, December 10, 2009 10:29 AM To: arslist@ARSLIST.ORG Subject: Using AIE to restore Asset Data ** Good morning, We had a recent problem where a bunch of our Asset data was wiped out. The records exist, but some of the fields were made null. I came up with the idea of using AIE to fix this problem by restoring the Asset data from a backup and treating it as external data to import. However, I've been told that I can't match on either the Request ID or the Instance ID, so I am curious if anyone here knows of a system generated unique id that I can use to match the old record with the new record. Thanks, Shawn Pierson Remedy Developer | Southern Union Private and confidential as detailed here<http://www.sug.com/disclaimers/default.htm#Mail>. If you cannot access hyperlink, please e-mail sender. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"