Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

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

  Asked By: Ashu    Date: May 14    Category: Sharepoint    Views: 1490

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?



3 Answers Found

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

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:

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

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

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