/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

5 votes182 views2 answers
Postgre insert select
SQL
0 vote184 views1 answer
Dns slave zone convert
SQL
2 votes175 views3 answers
Postgres remove foreign key constraint
SQL
0 vote191 views1 answer
Oracle last user logon
SQL
15 votes185 views2 answers
Open postgress in terminal mac
SQL
10 votes181 views5 answers
Create table mysql query
SQL
4 votes180 views1 answer
Oracle session date format
SQL
0 vote225 views1 answer
Oracle list user locked
SQL
0 vote167 views2 answers
Postgresql create role
SQL
14 votes237 views1 answer
Excel is not a database
SQL