You can remove the unwanted, redundant, or obsolete inventoried workstations from the Inventory database using the Inventory Removal service.
The Inventory Removal service is a manual service that runs on the Inventory server. The service removes the inventoried workstations from the Inventory database using the inventoryremovallist.txt file. The inventoryremovallist.txt contains a list of inventoried workstations that must be removed from the Inventory database.
IMPORTANT: You must ensure that the Inventory Service Manager is loaded when you run the Inventory Removal Service.
IMPORTANT: You can run the Inventory Removal service on the Intermediate Server only if the Intermediate Server has either inventoried workstations or database attached to it.
To remove the inventoried workstations from the Inventory database:
Create inventoryremovallist.txt, containing a list of inventoried workstations to be removed from the Inventory database, by using any of the following methods:
After generating a lookup file, do the following:
DN of the inventoried workstation (as stored in the Inventory database) to be removed from the Inventory database
DN of the inventoried workstation (as stored in the Inventory database) to be removed from the Inventory database
...
...
DN of the inventoried workstation (as stored in the Inventory database) to be removed from the Inventory database
A sample inventoryremovallist.txt file is as follows:
CN=WS1.OU=WORKSTATIONS.OU=WEST.O=XYZ.T=XYZ-TREE
CN=WS99.OU=WORKSTATIONS.OU=NORTH.O=XYZ.T=XYZ-TREE
CN=WS50.OU=WORKSTATIONS.OU=EAST.O=XYZ.T=XYZ-TREE
To generate the list of inventoried workstations that must be removed you can either perform a query on a selected criteria or manually enter the names of the inventoried servers. For more information on Query, see Viewing Inventory Information by Querying the Database.
Copy the inventoryremovallist.txt file to the ZENworks_installation_path\zenworks\inv\server\wminv\properties directory.
In the ZENworks_installation_path\zenworks\inv\server\wminv\properties\
inventoryremoval.properties file, ensure that the value of FilePath is the location of inventoryremovallist.txt (specified in Step 2).
NOTE: Ensure that the path separator is a forward slash ( / ) and not a backslash ( \ ).
At the server console prompt, enter StartSer RemoveInventory to start the Inventory Removal service.
The Inventory Removal service follows the order below:
The delete str file is saved in the scandir directory if the Selector is running, else it will be placed in the dbdir or entmergedir directories depending on the Inventory server role.
The inventoried workstation is deleted from the Inventory database at all Inventory servers deployed at the enterprise level.
NDS Lookup for DB automatically generates a list of inventoried workstations that are stored in the Inventory database but do not have a corresponding entry in eDirectory. By default, this lookup file is named deletewslist.txt
The excess workstations in the Inventory database exist because these workstations have been deleted from eDirectory but their corresponding entries were not removed from the database.
The list generated by NDS Lookup for DB helps you in identifying the redundant workstation objects to be removed from the Inventory database by using the Inventory Removal Service.
IMPORTANT: You must run this utility only on the Inventory server to which an Inventory database is attached. Also, you must ensure that the Service Manager is loaded when you run this utility.
To run this utility:
Specify the path of the lookup file in inventory_server_installation_path\inv\server\wminv\properties\
inventoryremoval.properties.
NOTE: Ensure that the path separator is a forward slash ( / ) and not a backslash ( \ ).
(Optional) Configure the lookup filename in the server role property file, which can be any of the following files, depending on role of the Inventory server: root_db_wks.properties, root_db.properties, int_db_wks.properties, int_db.properties, leaf_db_wks.properties, or standalone.properties.
The server role property file contains the [NDSLookupForDB Service] section with the lookup filename in the ARGUMENTS parameter. The default lookup filename is deletewslist.txt.
IMPORTANT: The lookup filename should consist of alphanumeric characters only.
At the server console prompt, enter startser NDSLookupForDB.