What if you import the entire data, verify it and then delete all data old date... Create Date < $DATE$
From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Thursday, December 10, 2009 1:18 PM To: arslist@ARSLIST.ORG Subject: Re: Using AIE to restore Asset Data ** Note that you can use multiple fields for identification in reconciliation. So, if you can define a groups of fields that uniquely identifies each asset, you should be able to import the backup data into a dataset, identify between them using this group of fields, and then merge them. Note that what you're currently having to do provides a good justification for at least running an auto-identification activity on your gold dataset, even if you never merge anything in from another dataset, because then you know that you have a single field that you can use to identify assets if you ever have to do this again. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn Sent: Thursday, December 10, 2009 12:04 PM To: arslist@ARSLIST.ORG Subject: Re: Using AIE to restore Asset Data ** 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 hyperlink, please e-mail sender. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"