如何得到MOSS 2007的最近的100次爬网的信息

在SharePoint中Shared Service的Search DB上运行下面的查询语句.

select top 100 
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
-- projectid=1 portal_content
-- projectid=2 anchorproject
-- projectid=3 profileimport
原文地址:https://www.cnblogs.com/awpatp/p/1872963.html