Absent Member.. Nick2345 Absent Member..
Absent Member..

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.




with regards,


1 Reply
Jason_Dowd Acclaimed Contributor.
Acclaimed Contributor.

Re: how to flush the data from Asset Manager

Hi Nick,

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.

Jason Dowd
HPE Software Support

If this post has helped you resolve the issue, please flag it as solved.
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.