Client Automation Standard Practitioners Forum
cancel

How to remove device information from inventory database?

Fred Fang
Trusted Contributor.

How to remove device information from inventory database?

Is there someone could tell me how to remove device information from inventory database? Is there tool or script could help?
4 REPLIES
Highlighted
Roy O Gatewood_
Acclaimed Contributor.

Re: How to remove device information from inventory database?

Never done it for CCM but there are several postings in the Forums on that subject and several sql scripts and tools have been provided.
Search the forum and I'm sure you'll find something to your liking.
Biju V George!
Acclaimed Contributor.

Re: How to remove device information from inventory database?

Hi,


You can use site reports or use DB admin tool to remove the records from deviceconfig and other related tables.


Thanks

Biju
Steve Berube
Outstanding Contributor.

Re: How to remove device information from inventory database?

For CAS/CCM you can do this by accessing the Configuration > Reporting > Maintenance area.

You wil be presented with a list of devices and you can choose which data to delete for them. Deleting a device from this panel will remove all Patch, Inventory and Usage data.
Fred Fang
Trusted Contributor.

Re: How to remove device information from inventory database?

Thanks for your help. I guess I posted in the wrong place. I want to ask OVCM (Radia) questions. Do you guys know how to do that in OVCM? Also, do you know where I can find database schema of OVCM Inventory Manger?