How to get last crawl time of document in Sharepoint 2007?

Question

How to get last crawl time of document in Sharepoint 2007?

I want to know in which table I will get this information ?

Answer 1

With the help of below query you can get last crawl time of document.

SELECT LastTouchStart
FROM MSSCrawlURL
WHERE (DisplayURL = '<displayURL>')