Personal tools
You are here: Home Inventory and SLM Delete Automatically Discovered Products

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:
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.
Server Says:
Sometimes a man will tell his bartender things he'll never tell his doctor.
-- Dr. Phillip Boyce, "The Menagerie" ("The Cage"),
stardate unknown.
Safety First!
63 Days without a Dumpster fire.
 

Powered by Plone CMS, the Open Source Content Management System

This site conforms to the following standards: