New Dba Date Desc -

SELECT name AS DatabaseName, create_date AS CreatedOn, state_desc AS Status FROM sys.databases ORDER BY create_date DESC;

-- New DBA date desc: latest first SELECT TOP 10 name, create_date, compatibility_level FROM sys.databases WHERE name NOT IN ('master', 'tempdb', 'model', 'msdb') ORDER BY create_date DESC; Schedule this query daily and output results to a monitoring table or email alert. 2. PostgreSQL PostgreSQL does not store database creation date in a system catalog by default. However, you can use the pg_database table in combination with the file system creation time of the pg_datadir – or better, create an audit table. new dba date desc

CREATE TABLE db_audit ( dbname TEXT, created_at TIMESTAMPTZ DEFAULT NOW() ); -- Trigger on new database creation (requires event trigger) However, you can use the pg_database table in

Introduction In the fast-paced world of database administration, staying on top of recent changes is critical. Whether you manage a fleet of SQL Server instances, Oracle databases, or open-source systems like PostgreSQL, the ability to retrieve a list of databases sorted by their creation date — most recent first — is a non-negotiable skill. Start by implementing the appropriate query for your

Start by implementing the appropriate query for your platform today. Then, expand into automated alerts and a cross-platform inventory. Your future self — and your audit team — will thank you. Need a ready-to-run script for your specific database system? Leave a comment below or reach out — we maintain open-source DBA toolkits for exactly these scenarios.

ls -lt /var/lib/mysql/ | grep "^d" | awk 'print $9' | tail -10 That lists directories (databases) sorted by modification time descending — close to "new dba date desc". Oracle’s V$DATABASE does not show creation timestamps for pluggable databases (PDBs). For CDB and PDB creation times, query: