I have the syntax I want to run. Just can't figure out what would be the best way to run this against all of our production databases at once. Tried going through Enterprise manager but none of the reporting tools or jobs seemed to do what I wanted them to do. Just want to know if anyone has done anything like this. Your words and wisdom would be much appreciated.
here is the report I want to run:
SELECT A.NAME, B.USERNAME, B.ACCOUNT_STATUS, B.EXPIRY_DATE,
TRUNC(B.EXPIRY_DATE)-TRUNC(SYSDATE) as num_days
FROM v$database A, DBA_USERS B
WHERE TRUNC(B.EXPIRY_DATE) - TRUNC(SYSDATE) < 30
ORDER BY num_days desc;