How to find out who using Sharepoint MySites in Sharepoint 2013

Question

In firm we have got MySites turn on at Sharepoint 2013. How could I find out who using My Sites by powerscript in Sharepoint 2013, Or this is on Central Administration in GUI ? Please Help.

Answer 1

In additional to the answer of PowerShell:

My Sites are just site collections for special usage, so they should all be listed under Central Administration > Application Management > Site Collections > View all site collections.

The user will be listed as Primary Administrator of his own My Site.

You can find the My Site Host via User Profile Service Application > My Site Settings > Setup My Sites.

---

UPDATE:

One line script to list all Site Owners for a web application (My Site Host):

Get-SPWebApplication "http://mysite.com" | Get-SPSite | Select Owner

And to export the list to Excel:

Get-SPWebApplication "http://mysite.com" | Get-SPSite | Select Owner | Export-CSV "C:\Temp\MySitesUsers.csv" -NoTypeInformation

Answer 2

Something like this? What information do you need in detail? This gives you all the sites in the MySite webapplication (replace the URL to your MySite webapplication) with their URL, name of the owner and their Email.

Add-PSSnapin microsoft.sharepoint.powershell

$arr = @()
$wa = Get-SPWebApplication -Identity "https://mysite.com"

foreach($s in $wa.Sites) {
$arr += [pscustomobject]@{
    Url = $s.Url
    Owner = $s.Owner.DisplayName
    Email = $s.Owner.Email
    }
}

$arr | Out-GridView