Crawling history from SSP search DB ( SQL Query)

Copy from MS:

 

select * from MSSCrawlhistory

select h.crawlid,
c.catalogid,
c.contentsourceid,
c.startaddressid,
typeofcrawl=
case h.crawltype
when 1 then 'full crawl'
when 2 then 'incremental crawl'
end,
h.status as status_id,
status=
case h.status
when 4 then 'start'
when 9 then 'pause'
when 10 then 'resume'
when 13 then 'stop'
when 11 then 'done'
else 'other'
end,
h.requesttime, h.starttime, h.endtime, datediff(n, h.starttime, h.endtime) as 'duration'
from msscrawlhistory h left join msscrawlcontent c
on h.crawlid=c.crawlid where h.projectid=1 order by h.requesttime desc