Hi there,

This PowerShell prints all users along with what groups they belong to. I need this to print the URL of the sites as well. Any suggestions?

Thanks.

$urlWeb = "http://dev"
Get-SPUser -Web $urlWeb -Limit All | select UserLogin, @{name="Explicit given roles";expression={$_.Roles}}, @{name="Roles given via groups";expression={$_.Groups | %{$_.Roles}}},Groups | format-Table -auto

• Edited by frob 12 hours 17 minutes ago

The PowerShell command Get-SPUser gives information about a user of the site. It cannot be used to get the url of the sites. If your aim is to get the url of all sites in a given site, you can use following code:

Get-SPWeb "http://dev" |Select -ExpandProperty Webs | Select Url, Title

 

Frob,

you can use this way to print the supplied url 

$weburl = "http://yourweburl"
Get-SPUser -web $weburl | ?{$_.UserLogin -eq "NT AUTHORITY\authenticated users"} | %{$_.UserLogin + " - " + $weburl}

• Edited by Hatim Johar 7 hours 24 minutes ago typo

HI Frob,

Since you are using -Web attribute so the site url will always be the same as the url you have passed in the attribute parameter. If you want to print that url in output then this can be achived using below script

Get-SPUser -Web $urlWeb -Limit All | select UserLogin, @{name="Url";expression={$_.ParentWeb.Url}}, @{name="Explicit given roles";expression={$_.Roles}}, @{name="Roles given via groups";expression={$_.Groups | %{$_.Roles}}},Groups | format-Table -auto