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 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
Re: Using AIE to restore Asset Data
How was the data put into Asset? Config Discovery? Manual? If it's Configuration Discovery, there's a bunch of unique fields... Why wouldn't you be able to match using Instance ID? Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn Sent: Thursday, December 10, 2009 12:29 PM 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_ ** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. 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, or the employee or agent responsible for delivering this e-mail to the intended recipient, 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 Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Using AIE to restore Asset Data
It was manually entered, unfortunately. Thanks, Shawn From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Chowdhury, Tauf Sent: Thursday, December 10, 2009 11:34 AM To: arslist@ARSLIST.ORG Subject: Re: Using AIE to restore Asset Data ** How was the data put into Asset? Config Discovery? Manual? If it's Configuration Discovery, there's a bunch of unique fields... Why wouldn't you be able to match using Instance ID? Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn Sent: Thursday, December 10, 2009 12:29 PM 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 herehttp://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_ This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. 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, or the employee or agent responsible for delivering this e-mail to the intended recipient, 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. _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
Re: Using AIE to restore Asset Data
why don't you match on CI Name? On Thu, Dec 10, 2009 at 10:37 AM, Pierson, Shawn shawn.pier...@sug.comwrote: ** It was manually entered, unfortunately. Thanks, Shawn *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Chowdhury, Tauf *Sent:* Thursday, December 10, 2009 11:34 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Using AIE to restore Asset Data ** How was the data put into Asset? Config Discovery? Manual? If it’s Configuration Discovery, there’s a bunch of unique fields… Why wouldn’t you be able to match using Instance ID? *T**auf** **C**howdhury** **|** **F**orest** **L**aboratories**, **I**nc.* ** Analyst, Service Management Mobile:646.483.2779 *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Pierson, Shawn *Sent:* Thursday, December 10, 2009 12:29 PM *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 herehttp://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_ -- This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. 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, or the employee or agent responsible for delivering this e-mail to the intended recipient, 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. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ Private and confidential as detailed herehttp://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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
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 herehttp://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. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Using AIE to restore Asset Data
There are duplicates in the CI Name field, as there are in serial number. This data was not of great quality but it's what the users want. Thanks, Shawn From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of DCI Remedy Sent: Thursday, December 10, 2009 12:00 PM To: arslist@ARSLIST.ORG Subject: Re: Using AIE to restore Asset Data ** why don't you match on CI Name? On Thu, Dec 10, 2009 at 10:37 AM, Pierson, Shawn shawn.pier...@sug.commailto:shawn.pier...@sug.com wrote: ** It was manually entered, unfortunately. Thanks, Shawn From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Chowdhury, Tauf Sent: Thursday, December 10, 2009 11:34 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Using AIE to restore Asset Data ** How was the data put into Asset? Config Discovery? Manual? If it's Configuration Discovery, there's a bunch of unique fields... Why wouldn't you be able to match using Instance ID? Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Pierson, Shawn Sent: Thursday, December 10, 2009 12:29 PM To: arslist@ARSLIST.ORGmailto: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 herehttp://www.sug.com/disclaimers/default.htm#Mail. If you cannot access hyperlink, please e-mail sender. _Platinum Sponsor: rmisoluti...@verizon.netmailto:rmisoluti...@verizon.net ARSlist: Where the Answers Are_ This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. 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, or the employee or agent responsible for delivering this e-mail to the intended recipient, 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. _Platinum Sponsor: rmisoluti...@verizon.netmailto:rmisoluti...@verizon.net ARSlist: Where the Answers Are_ Private and confidential as detailed herehttp://www.sug.com/disclaimers/default.htm#Mail. If you cannot access hyperlink, please e-mail sender. _Platinum Sponsor: rmisoluti...@verizon.netmailto:rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _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
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 herehttp://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
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 herehttp://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 herehttp://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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Using AIE to restore Asset Data
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 herehttp://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 herehttp://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
Re: Using AIE to restore Asset Data
I've just come up with a way to solve my problem. I am matching on the TokenID field, but I copied the contents of the InstanceID field over to the TokenID so it is truly unique now, and I don't have to worry about duplicate CI Names, Serial Numbers, etc. Thanks, Shawn Pierson 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 herehttp://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 herehttp://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_ 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