Column defined in table

[Arjun Thakur]

I need to query sys_dictionary table and list all columns that reference to sys_user table. The challenge here is to list column only once. I do not want to list the child tables in my list.

For example, column defned in cmdb_ci_servers should be listed once, and should not list with extended tables like  cmdb_ci_lb, cmdb_ci_lb_f5_ltm, cmdb_ci_lb_isa....

Is there any attribute available to filter this requirement. I certainly believe so, because if you define a column in table, the red-cross is available in only in definition of that table to delete it. In extended tables, that option is not available.

[#2]

I'm not aware of how to do this in the list views.  The script used to check if a column is inherited uses the GlideTableDescriptor API which is not available via list view filtering.  You can see the Display first table name for TPP tables business rule which does this check when you open a column:

You could write a script to return the tables/columns and print them out but I am not aware of how to do this via list views.

[Arjun Thakur]

Awesome. Thats what I am looking for. Thank you so much.