Bulk Delete Resources
Description: This script runs a user-defined SQL query and deletes the resulting items. Simply open the .cs file in any editor and include the SQL query that will return the list of items you wish to delete. It should be run from a command prompt and will show progress by adding a "." ('dot' or 'period') for every 50 items deleted. This will delete 1 item at a time but is able to delete as many items as are found in the result set returned by the SQL query. WARNING: when deleted a large amount of items, this script could take awhile to run. In testing, it will delete approximately 2,000 items per hour. Of course, this will vary depending on user environments.
Usage: 'nscript.exe deleteitems.cs' (Nscript.exe is found in c:\program files\altiris\notification server\bin, by default)
Disclaimer: Deleting items from the database is irreversible - please make a backup of all data before proceeding