/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

0 vote297 views1 answer
Hibernate with springboot mysql
SQL
2 votes307 views2 answers
How to DROP a table in mysql
SQL
0 vote281 views0 answer
SQL
2 votes320 views2 answers
How to run postgresql in linux
SQL
7 votes314 views5 answers
Show details of table postgres
SQL
0 vote325 views1 answer
Shrink database file in sql server
SQL
0 vote295 views1 answer
Postgres 11 add primary key
SQL
5 votes288 views1 answer
Oracle asynchronous procedure
SQL
1 vote328 views5 answers
Postgresql difference between two dates in days
SQL
2 votes345 views1 answer
Mysql shell insert into
SQL