Last update by (administrator) query

[Arrow]

Hi folks,
I had an audit and as a result had to delete some admin users who are no longer with the company. Recently I found out that scripts etc. will fail if it was last updated by the an admin which is no longer registered.
My question is, does anyone know of a query etc. that I can run to find out all scripts and schedules etc. that was last updated by a certain admin? Quite worried that things will fail as one of the admins I deleted originally set up TSM and was with the company for a very long time.
Thanks.

 

[marclant]

You can use this:
select chg_admin,schedule_name,chg_time from admin_schedules order by chg_admin
select distinct chg_admin,name,chg_time from scripts order by chg_admin