Serena Dimensions admin script

Dimensions: Find bad item lib files

Query that might help locate item library files that have been inserted incorrectly
 
 
select filename
from pcms_item_data, pcms_workset_items, pcms_workset_info
where file_version > 1
and lib_file_length = 0
and pcms_workset_info.product_id = '$GENERIC'
and pcms_workset_info.workset_name = '$GLOBAL'
and pcms_workset_info.workset_uid = pcms_workset_items.workset_uid
and pcms_item_data.item_uid = pcms_workset_items.item_uid
order by lib_filename
 
Another useful command on the OS CLI in the item libs directory (on Windows you'll need to install Cygwin or similar)
 
find . -type f -size 0 ! -name \*.1 | sort