Delete Automatically Discovered Products
by
dportillo
—
last modified
2007-11-14 17:09
Contributors:
jack
How to clear the database and re-discover
By default, automatically discovered products cannot be deleted. Under this list the Delete option is greyed out or removed.
You can chose to ignore individual products, but if you want to start over by rediscovering all the applications on a standard build PC you'll have to bulk delete.
This would require you to directly manipulate your database, which is not recommended and unsupported. Please make sure to BACKUP YOUR DB before you proceed.
Using Query Analyzer (SQL 2000) or SQL Admin Studio (SQL 2005), enter the following command:
The above SQL statement will cause your 'Automatically Discovered Products' to become 'Custom Products'. You should then be able to delete them from within SLM's Custom section.
You can chose to ignore individual products, but if you want to start over by rediscovering all the applications on a standard build PC you'll have to bulk delete.
This would require you to directly manipulate your database, which is not recommended and unsupported. Please make sure to BACKUP YOUR DB before you proceed.
Using Query Analyzer (SQL 2000) or SQL Admin Studio (SQL 2005), enter the following command:
UPDATE Product
SET LDMSProduct = 0
WHERE LDMSProduct = 1
The above SQL statement will cause your 'Automatically Discovered Products' to become 'Custom Products'. You should then be able to delete them from within SLM's Custom section.