User/table relationships

[Simon Hendery]

I've been off the tools for a while, so this is probably a dumb question...

Is there a simple way to get a full list of all the tables that a particular user appears in?

E.g., if there is a user John Doe, is it possible to return a list of all the tables that store data related specifically to John Doe? If so, how?

[Dr Atul G- LNG · Accepted solution]

Hi @Simon Hendery 

I don't think there is a direct way to do this. However, you can use the Schema Map to see where the User table is being used, which might be helpful.

https://devxxxxx.service-now.com/now/nav/ui/classic/params/target/sys_db_object.do%3Fsys_id%3D7ff7da...

[Dr Atul G- LNG · Accepted solution]

Hi @Simon Hendery 

I don't think there is a direct way to do this. However, you can use the Schema Map to see where the User table is being used, which might be helpful.

https://devxxxxx.service-now.com/now/nav/ui/classic/params/target/sys_db_object.do%3Fsys_id%3D7ff7da...

[glideFather · Accepted solution]

ahoy @Simon Hendery,

perhaps database view could help but it would require lots of manual configurations.

Example of usage of Database view: How to get values from multiple tables in a single report (data visualisation)

Perhaps the easiest way would be to write a script for given tables to do the checks - it can be either fix script and/or scheduled job..

Let me sleep for that and perhaps I will have ab etter ideas in the morning :))

[Simon Hendery]

Thanks @glideFather 

[Simon Hendery]

Meanwhile, once again ...

What a f**king debacle.