storagepool purge argument: Delete storage pool entries (SQL administration API)

Use the storagepool purge argument with the admin() or task() function to delete all storage pool entries, storage pool entries that have a status of Full, or storage pool entries that have a status of Error.

Read syntax diagramSkip visual syntax diagramEXECUTE FUNCTIONadmintask( "storagepool purge all""storagepool purge full""storagepool purge errors");

Usage

Use the storagepool purge all argument to delete all entries in the storage pool.

Use the storagepool purge full argument to delete all storage pool entries that have a status of Full.

Use the storagepool purge errors argument to delete all storage pool entries that have a status of Error.

The storagepool table in the sysadmin database contains a column that shows the status of each entry in the storage pool.

Example

The following command deletes all storage pool entries that have a status of Full:

EXECUTE FUNCTION task("storagepool purge full");