How to find the extended tables which are having the custom field that was there in task??

[KM SN]

I have a business service field in task but someone else have created same field which starts with "u_" but now i need to remove the field but removing directly from task may effect the child tables extended from task where they might have used the custom field instead OOB field.

What is the best practice to go further?

How to find the child tables at a time which are  using custom field? 

[Dr Atul - LNG · Accepted solution]

Hi @KM SN 

Try like this

Go to Dictionary and search for field

You will get some information.

Also don't remove the field directly, take the data back up and then remove and bring the data in OOTB field. 

[Anil Lande]

Hi,

Follow below steps:

1. You can open task table list using task.LIST
2. Add custom field and Task type fields on list view by personalising list

3. Use filter out option for your custom field column where value is empty. (or apply filter like Business service IS Empty)

4. You will get the list of all tasks where custom field have some value selected by user.

5. Now group by 'Task type' Column.

This will show the records grouped by child table (like incidents, problems etc) where this field is used.