我想获取SharePoint服务器场中所有用户的列表
问题描述：
HI朋友
我试图在SQL的cmd下执行
I tried to execute below cmd in SQL
从[dbo]中选择#.[userinfo]
它检索了其中存在用户信息表的sharepoint db之一的用户列表.请指导我如何使用sql查询获取sharepoint中所有用户的列表，并共享查询.还请让我知道我必须在哪个数据库上执行
It retrieved the user list for one of sharepoint db where user info table is present. Please guide me how to get list of all users in sharepoint using sql query and please share the query. Also please let me know on which database I have to execute
如果不通过SQL，请与我分享SharePoint Power Shell脚本以获取所有用户的列表.
IF not through SQL please share me SharePoint power shell script to get the list of all users.
感谢&问候
Shyam.CH
9177991620
9177991620
答
Shyam-使用PowerShell:
Hi Shyam- use PowerShell:
#getalluserseverywhere
Add-PSSnapin microsoft.sharepoint.powershell -ErrorAction SilentlyContinue
timestamp = get-date -format"yyyyMMdd_hhmmtt"
timestamp = get-date -format "yyyyMMdd_hhmmtt"
filenameStart ="AllFARMUsers"
filenameStart = "AllFARMUsers"