Is there a stored procedure to remove all assets from "All Assets"?

[bleepie]

Hi,

I want to remove all assets that I see in Hardware Assets -> Assets -> All Assets. I can do this manually (takes a lot of time) or I can just empty the asset database table. But I don't want to leave data behind in the database pointing towards these assets. For example in "All Inventory" a device can be linked with an asset. I don't want to leave the FK of the asset in the compliance computer table.

My question:

Is there a stored procedure for removing all assets and its traces?

And if not:

What is the best way to remove all assets?

[Flex-Jeremy · Accepted solution]

The stored procedure "AssetRemoveAll" run against the compliance database will remove all assets stored in the Asset table. 
If you only want to remove some assets then the stored procedure "AssetRemoveBatch" can be run providing an a temp table named #Asset with the specific asset that you want to remove.