Name |
Purpose |
add_dashboard_data.sh
|
Adds Dashboard Author data to an CES database. |
add_number_of_notes_ attachments_in_custom_ configs.sql |
Adds properties for the number of notes and attachments to custom
configurations. |
attach_notes_update.sh |
Adds notes and attachments icons and properties to classes and items
and maintain the count of how many exist. |
cascade_evvs.sql |
Performs the cascading of enumerated valid values. |
cascade_rvvs.sql |
Cascades the range valid values to the bottom class. |
check_clp_ldd_data.sql |
Identifies logical data types that are not defined but are used by
Class Properties. |
compile_views.sql |
Restores the corrupted views in CES. |
create_index_on_bottom_class_ id.sql |
Creates an index for the Bottom Class ID property for each item in
the database. |
delete_act_not_classes.sql |
Removes Activation, Activation to User Group, Activation to User
Link, and Notice classes. |
delete_blb_not_dep_classes.sql |
Removes the unused classes such as Department, Binary Large Objects,
Notice. |
delete_cf_evv_rvv.sql |
Deletes custom functions from the database that were not implemented
in the CES custom function libraries. |
delete_duplicate_evvs.sql |
Deletes duplicate EVVs from EVV table. |
delete_gco_goe_uoe_classes.sql |
Removes obsolete classes S_GCO_CLASS, S_GOE_CLASS, S_UOE_CLASS . |
delete_orphan_classes.sql |
Deletes all orphan classes from the database. |
delete_orphan_config_objects.sql |
Deletes all orphan configuration objects in Search, Result and
Configuration included classes. |
delete_orphan_objects.sql |
Deletes the orphan objects from all the classes except the Root class
which do not have their corresponding objects in the Root class. |
delsmon.sql |
Deletes items from the License Monitor class for the specified
period. |
delete_uem_class.sql |
Deletes the obsolete class User Extensible Menu, its related
configuration and meta-model objects. |
estimate_tablesize.sh |
Estimates the database size on UNIX. |
estimate_tablesize.sql |
Estimates the database size on Windows. |
increase_email_length.sql |
Increases the size of the email address. |
initialize_create_date_user.sql |
Initializes Create Data and Create User properties in the Root class
with input provided by user if Create User is Null. |
insert_objects.sql |
Populates the classes in the middle hierarchy with obj_id, obj_type,
and class_id from objects in each of the bottom classes. |
report_child_classes.sql |
Identifies and reports child classes under a given class label. |
report_orphan_classes.sql |
Identifies and reports all orphan classes in the CES system. |
rollup_max_objects.sql |
Rolls up the value of s_cls_max_objects of bottom classes in their
parents. |
S_DELETE_DETDEF_CONFIG_ PR.sql |
Deletes all DEFAULT and DETAIL configurations in CES. |
set_evv_cascade.sql |
For the given parent class, sets the EVV class, Cascade Flag property
to Yes in all child classes. |
upd_all_att_note_count.sh |
Updates the S_ROT_CLASS rot_att_count and s_rot_note_count for all
the objects. |
upd_cls_att_count.sh |
Updates the S_CLS_TABLEs cls_att_count to the number of attachments
associated with every class. |
upd_obj_att_note_count.sh |
Updates the S_ROT_TABLEs rot_att_count and s_rot_note_count for a
given class. |
set_rvv_cascade.sql |
Updates the RVV cascade flag from False to True. |