MSSQL 쿼리 히스토리 알아내기

대체적으로 성공한 'SELECT' 에 해당하는 쿼리만 반환하는 것 같음.

select
  db_name(st.dbid) DBName
  , object_schema_name(objectid, st.dbid) SchemaName
  , object_name(objectid, st.dbid) SPName
  , qs.total_elapsed_time
  , creation_time
  , last_execution_time
  , text
from
  sys.dm_exec_query_stats qs
cross apply
  sys.dm_exec_sql_text(qs.plan_handle) st
join
  sys.dm_exec_cached_plans cp
on 
  qs.plan_handle = cp.plan_handle
where last_execution_time > '2017-08-08 09:10:00'
and text like '%200510310061%'
order by last_execution_time