trying to find out the size of a document library

i'm trying to find out the size of a document library, and wanted to
make sure we were on the right track. take a look at the query below:

select a.DirName, sum(cast(size as bigint))/1024 [doc_size_kb]
from dbo.docs a, dbo.Lists b
where b.tp_id=a.listid and a.size is not null and
b.tp_servertemplate=101
group by b.tp_id, a.listid, a.DirName
order by dirname

MuhammadMohtashimJangda
Wed Mar 21 06:34:00 CDT 2007

it is HIGHLY discouraged to hit the underlying schema of sharepoint directly
... use either the object model or the webservices ...
--
Muhammad Mohtashim Jangda
Technology Consultant
KalSoft (Pvt.) Ltd


"eric" wrote:

> i'm trying to find out the size of a document library, and wanted to
> make sure we were on the right track. take a look at the query below:
>
> select a.DirName, sum(cast(size as bigint))/1024 [doc_size_kb]
> from dbo.docs a, dbo.Lists b
> where b.tp_id=a.listid and a.size is not null and
> b.tp_servertemplate=101
> group by b.tp_id, a.listid, a.DirName
> order by dirname
>
>

eric
Wed Mar 21 07:13:16 CDT 2007

how would one go about doing that? i was also looking at using the sps
addon for reporting services.

On Mar 21, 7:34 am, Muhammad Mohtashim Jangda
<MuhammadMohtashimJan...@discussions.microsoft.com> wrote:
> it is HIGHLY discouraged to hit the underlying schema of sharepoint directly
> ... use either the object model or the webservices ...
> --
> Muhammad Mohtashim Jangda
> Technology Consultant
> KalSoft (Pvt.) Ltd
>
> "eric" wrote:
> > i'm trying to find out the size of a document library, and wanted to
> > make sure we were on the right track. take a look at the query below:
>
> > select a.DirName, sum(cast(size as bigint))/1024 [doc_size_kb]
> > from dbo.docs a, dbo.Lists b
> > where b.tp_id=a.listid and a.size is not null and
> > b.tp_servertemplate=101
> > group by b.tp_id, a.listid, a.DirName
> > order by dirname