/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

10 votes185 views1 answer
Oracle dependency
SQL
47 votes212 views6 answers
Add column mysql
SQL
5 votes201 views4 answers
Mysql on duplicate key update
SQL
0 vote195 views1 answer
Subquery aggregation
SQL
0 vote204 views1 answer
Oracle table privileges
SQL
6 votes205 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
6 votes190 views1 answer
Postgresql get year
SQL
0 vote194 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
3 votes243 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
1 vote196 views1 answer
Sometimes i cant edit sql developer
SQL