sharepoint 2007 - sql query list papers site collection


i need list papers site collection, i trust i presumably alldocs list alluserdata list (moss 2007 sp1) nonetheless i author information document. i need essence request (e.g. alldocstreams content)



something this:



select     tp_dirname, tp_leafname, tp_version, tp_modified, tp_created
from alluserdata
where (tp_contenttype = 'document')
and (tp_leafname '%.css')
and (tp_leafname '%.jpg')
and (tp_leafname '%.png')
and (tp_leafname '%.wmf')
and (tp_leafname '%.gif')
and (tp_dirname '%template%')
and (tp_iscurrentversion = 1)
and (tp_leafname '%.xsl')
order tp_siteid, tp_listid, tp_dirname, tp_leafname, tp_iscurrentversion desc


is there improved proceed this?



Comments

Popular posts from this blog

why does floated <input> control floated component slip over too distant right ie7, nonetheless firefox?

grails record upload problems

how i emanate permitted url asp.net mvc?