Monday, November 16, 2009

How to delete all CCMDB Authorized CI classification

Here is the script to delete all CCMDB Authorized CI classification:

delete from select classstructure where classstructureid in (select classstructureid from classusewith where objectname = 'CI')

Wills, do it at your own risk.

No comments: