Additionally, there is a spreadsheet in the Data Management Tool that can load Asset-People relationships if you can recover the data. It is in the "Transactions" section. Spreadsheet is called Transactional-Asset.xls
Nathan Aker ITSM Solution Architect McAfee, Inc. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Roger J Sent: Monday, January 28, 2013 9:28 AM To: arslist@ARSLIST.ORG Subject: Re: AST:AssetPeople ** There are only two ways to delete all entries, either through the Application and a Delete all or through the Database with a truncate. If you can find a list of Computer Names with the login of the user workflow can be created to populate the ASTAssetPeople records. -----Original Message----- From: Koyb P. Liabt <tekkyto...@aol.com<mailto:tekkyto...@aol.com>> To: arslist <arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>> Sent: Mon, Jan 28, 2013 10:18 am Subject: AST:AssetPeople ** I would have to try to find this spreadsheet in the organization. I need to understand what caused the entire table to be wiped out. How could this happen - outside of someone manually deleting this? The reconciliation job would not have done this correct? If this info was once in the system, would I be able to build this through workflow by merging data from other tables? We would need the instance id - reconciliation id, person info, ci, etc.. ** What do you have to be able to rebuild this such as a spreadsheet with the Computer name and the User Login? -----Original Message----- From: Koyb P. Liabt <tekkyto...@aol.com<mailto:tekkyto...@aol.com>> To: arslist <arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>> Sent: Mon, Jan 28, 2013 10:02 am Subject: AST:AssetPeople ** Hi, This is a problem for us. What could have wiped out the AST:AssetPeople records? (outside of some manually going into the table and wiping it). The records were there before. We need this info for the "used by" relationship. We cannot associate the CIs with the people without this data in AST:AssetPeople. ** Hi, Entries from AST:AssetPeople are missing. Do we have to reload spreadsheets? Or is there a way through workflow to get this data populated? Is there a way to automatically load this? _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
