how to flush the data from Asset Manager
I working on AM9.30
havI want to integrate UCMDB to AM but AM is havi ng old data disocvered from ddmi which we wnt to remove from AM.
Can we delete the same from client or any other method to flush all related tables from AM database.
Re: how to flush the data from Asset Manager
There is no OOB automated way to do such a thing, but if you have a way to identify the data that you no longer want, that makes it easier. For example, if you know that all of the old data that you don't want was last inventoried before 12/31/2013, then you could write a query to find all of that data.
Deleting, however, is the tricky part. Because of the integrity checks, deleting assets can be time-consuming. If the number of records you need to get rid of is fairly low -- say just a hundred -- then doing it manually from the client is probably the most efficient. Just delete them in batches of 25 or so and you'll work your way through them.
If the number of records is much higher -- like thousands -- then the best solution would probably be to write a script to delete them and either run it manually or let the APM run it. You may even want to have the script do them in batches as well so it doesn't sit and run for hours in one execution.
HPE Software Support
If this post has helped you resolve the issue, please flag it as solved.