Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

SQL Query to identify all those in a site collection with Admin role

Asked By: Ashu Chaliha Date: May 14, 2008 Category: Sharepoint Views: 292

We're on wss v2 with over 1000 sites in a single site collection. We
want to notify all the admins that their sites are being upgraded to
v3. Does anyone know a sql query that can pull their email addresses or
user ids?

Tagged:sql query to identify all those in site collection with admin role

3 Answers Found

Answer #1 Answered By: Graham Ingram Answered On: May 14, 2008

Microsoft does NOT support direct queries to the database, it
invalidates your support agreement. Not only that, this could easily be
done with a simple .NET console application or Power Shell script
running against the SharePoint API.

See post:
blogs.msdn.com/.../evaluating-sharepoint-par
tner-solutions-and-applications-built-on-sharepoint.aspx

Answer #2 Answered By: Donte Jefferson Answered On: May 14, 2008

At this point, we've just been using wss
out of the box and don't have a SharePoint developer handy by so
script this for us.

Answer #3 Answered By: Beau Pena Answered On: May 14, 2008

That was supposed to say "to script this for us", not "so script this
for us."

Didn't find what you were looking for? Find more on SQL Query to identify all those in a site collection with Admin role Or get search suggestion and latest updates.