Empty the database of all assets?

[Roofus_143]

I want to remove all assets from the LS database; what's the easiest way to do that?

Rob

[miketrike]

I'm replying just to subscribe.

I'm super curious as to why one might do this... Versus say a clean installation...

[Jeff_Ziegler]

I have a lot of assets, so from the Assets list isn't feasible.

Won't deleting everything from tblAssets leave correlated orphan rows in other tables, such as tblAssetCustom? Or does the Database Scripts page insure that the data removal is cascaded to the child tables?

[Karel_DS]

The easiest way would be to run a query on the database deleting all from tblassets. However (if you don't have thousands of assets), we advise doing the following instead:

• Go to the assets page
• Select maximum amount of assets to be shown (top right corner)
• Check all assets by clicking the top checkbox
• Press the delete action in the menu to the left

This will remove all asset data including asset images.

[Irena2602]

Karel DS wrote:
The easiest way would be to run a query on the database deleting all from tblassets. However (if you don't have thousands of assets), we advise doing the following instead:

• Go to the assets page
• Select maximum amount of assets to be shown (top right corner)
• Check all assets by clicking the top checkbox
• Press the delete action in the menu to the left

This will remove all asset data including asset images.

I have more than 20000 assets, and the maximum display is 1000.
Is there an easier way to delete all assets and not going through all pages?
thanks,