Hi,

First of all add the rev 0 for all the tags.

You can run the following command:

Update udf_component set udf_c01 = ‘Rev 0’ where eng_proj_id <>0;

Commit;

Go to admin module and open system administration à Domain Definition

And select the domain and check the check box “Audit trail option”

To active database history.

To found changes for each tag the you can use one of the following options:

Option 1:

Go to Specification module or Process Data module and select option menu

And “History option” and “mark changes” and select date range and open the index brows.

after the report retrieve (It will take time till the process complete) the system will mark the changes for each column change (per tag).

Now you can change the udf column with the right revision.

Don’t forget to turn off the history in the history option before you log out from INtools

Otherwise it will effect the performance for the browser ,spec sheet data and process data.

Option 2:

Run the following SQL

Select distinct pk_list_col_values  from changes_log where pk_list_col_names like ‘%cmpnt_id%’ and seq_num > XXXXX;

After Each time you make this check you need to find the max(seq_num) and remember it for the next check to use it for seq_num > XXXXX condition in this way you check the changes from the last check.

When you get the list of the cmpnt_id you can run the following sql to find  the name of the tags and the revision:

Select c.cmpnt_id,c.cmpnt_name,u.udf_c01 from component c,udf_component u

Where c.cmpnt_id = u.cmpnt_id and c.cmpnt_id in(cmpnt_id1,cmpnt_id2,etc);

Save the results in excel file and from there you can create sql to update udf for revision.

Regards

Ilan Hills