我想获取SharePoint服务器场中所有用户的列表 [英] I want to get a list of all users in sharepoint farm

问题描述

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"

这篇关于我想获取SharePoint服务器场中所有用户的列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！