How to Purge or wipe clean assets from the Track-It! 20xx and Client Management (BCM) Inventory to start afresh

NOTE: BMC recommends that the assets must be deleted from the Track-It! application and the Client Management (BCM) Console.

However if you simply want to start fresh and wipe clean all assets from the Inventory, follow the below mentioned steps:

• First, take a Backup of the BCM Database (named TI_BCM by default) and then run below queries against it, refer How to run a SQL Query:

delete from [bcmdbuser].[FAMDeviceHierarchy] where parentID <> 100
delete from bcmdbuser.FAM where deviceid <> 1000
delete from bcmdbuser.Devices where deviceid <> 1000

NOTE: In the above example, we assume that the BCM Master deviceID =100. So, the query says delete all the assets expect the master server ID's (100.1000). If the deviceID is different in your environment then update the queries accordingly. Feel free to contact support, if you're unsure about this.

• Once the above queries complete execution, below query needs to be run against the Track-It! 20xx Database, in case you're not sure where the Database is, How to check the Database name and SQL Server/Instance name for Track-It! 20.xx shall help. Also make sure sure to take a Fresh Backup of the DB, refer How to backup Track-It! 2020 database for instructions:

delete  from [_SMDBA_].[_INVENTORY_] where SEQUENCE <> 101