New Dba Date Desc !!better!! | Hot • 2025 |
SELECT name AS DatabaseName, create_date AS CreatedOn, state_desc AS Status FROM sys.databases ORDER BY create_date DESC;
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. new dba date desc
$lastCheck = (Get-Date).AddMinutes(-15) $query = "SELECT name FROM sys.databases WHERE create_date > '$lastCheck'" Invoke-Sqlcmd -ServerInstance "yourServer" -Query $query | ForEach-Object Send-MailMessage -To "dba@company.com" -Subject "New DB: $($_.name)" Need a ready-to-run script for your specific database system
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: Oracle’s V$DATABASE does not show creation timestamps for