does anyone have the link that shows a data dictionary of the site database?
what i want to do is perform a sql query to list ALL sites (not just top level) and the members along with thier roles..
anyone by chance gotten that?
ive kind of gotten a query that will return all the sites - this is where im at now (dba's please dont laugh):
SELECT
d.DirName AS Site,
d.LeafName AS DocName,
d.Size AS Size,
d.TimeCreated AS Created,
d.timelastmodified AS modified
FROM Docs d
WHERE d.leafname = 'default.aspx'
and d.dirname like 'sites/%'
ORDER BY Site
-----
so my rudimentary caveman query will return all sites and subsites, basically anything with a default.aspx and a dirname that starts with /sites.
anyone have any ideas? i have been asked to produce a report with a summary of each site and thier users along with roles, considering my query returns 201 sites - thats going to take a while going through the user interface and copy/pasting..