/SQL/Sql last time database was accessed

Sql last time database was accessed

SELECT d.name,
last_user_seek = MAX(last_user_seek),
last_user_scan = MAX(last_user_scan),
last_user_lookup = MAX(last_user_lookup),
last_user_update = MAX(last_user_update)
FROM sys.dm_db_index_usage_stats AS i
JOIN sys.databases AS d ON i.database_id=d.database_id
GROUP BY d.name

Source: stackoverflow.com

Similar codes

9 votes139 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote138 views1 answer
PSQL qith variables
SQL
2 votes130 views2 answers
Select multiple tables mysql
SQL
0 vote137 views1 answer
Compare two tables to find unmatched records
SQL
0 vote154 views1 answer
Sqlite version check
SQL
0 vote131 views2 answers
Sqlite unix timestamp
SQL
0 vote156 views1 answer
Sql query inline if
SQL
3 votes145 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
3 votes166 views2 answers
How to list columns for particular tables in postgresql
SQL
0 vote143 views1 answer
Setval postgres example table id
SQL