MOSS: Report of Users and their permissions

-- All users in site collection

Select tp_Title,tp_Login, tp_IsActive from UserInfo order by tp_Title,tp_Login, tp_IsActive


-- All users in a group

Select Distinct Title, tp_Title,tp_Login from Groups gr

inner join GroupMembership grm on gr.ID = grm.GroupID

inner join UserInfo usr on usr.tp_ID = grm.MemberId

order by Title,tp_Title,tp_Login




-- All groups for a user

Select Distinct tp_Title,tp_Login, Title from Groups gr

inner join GroupMembership grm on gr.ID = grm.GroupID

inner join UserInfo usr on usr.tp_ID = grm.MemberId

order by tp_Title,tp_Login,Title


Thanks to my mate Navneet Singh.

MOSS: Report how many web pages are under the SiteCollection

You can find only by using SQL query


Select distinct DirName,LeafName from AllDocs where DirName like '%Pages' and LeafName like '%.aspx'

order by DirName,LeafName

Office documents prompt for login in anonymous SharePoint site

I have a MOSS 07 site that is configured for anonymous access. There is a document library within this site that also has anonymous access enabled. When an anonymous user clicks on a PDF file in this library, he or she can read or download it with no problem. When a user clicks on an Office document, he or she is prompted with a login box. The user can cancel out of this box without entering a log in, and will be taken to the document.

This happens in IE but not FireFox.

Solutions

Unfortuantly the only work around I've found breaks some functionality for logged in users (can't upload multiple files, connect to outlook ect..)
If that is acceptable, or you want to try it and see:
In central admin > application management > application security > authentication providers select your web app and select your provider (likely "default").
Select No for client integration and save the settings.

Open your web config, find the line add verb="OPTIONS,PROPFIND,PUT,LOCK,UNLOCK..... and remove the verb OPTIONS.

You should no longer be asked in ie for credentials.

Reference:
http://stackoverflow.com/questions/375390/office-documents-prompt-for-login-in-anonymous-sharepoint-site