June 30, 2015

Microsoft wants to hear YOU! UserVoice

The below links are a great way to provide feedback for the Microsoft future roadmap, research & development, and cloud first releases. Please give feedback and help the community steer in the right direction. Cheers!

May 18, 2015

Office 365 – Monitor site collection storage (PS1 daily email)

I wrote the below PowerShell script to gather site collection storage data for any Office 365 tenant. This PS1 could be scheduled daily for a quick email to keep an eye on sites approaching storage limits.

Hope this helps!

# Plugin
Import-Module Microsoft.Online.SharePoint.PowerShell -ErrorAction SilentlyContinue

# Config -- get URL from "Tenant Admin" page in Office 365
$url	= "https://company-admin.sharepoint.com"
$user	= "admin@company.com"
$smtp	= "mailrelay"

# Connect
Connect-SPOService -url $url -credential $user

# Gather data
$sites = Get-SPOSite -Detailed
$coll = @()
foreach ($s in $sites) {
	$curr = $s.StorageUsageCurrent
	$quota = $s.StorageQuota
	if ($quota -eq 0) {
		$prct = [math]::Round($curr, 2) * 100
	} else {
		$prct = [math]::Round($curr/$quota, 2) * 100
	}
	$surl = $s.Url
	$coll += New-Object -TypeName PSObject -Prop (@{'curr'=$curr;'quota'=$quota;'prct'=$prct;'surl'=$surl})
}
$coll = $coll | sort prct -Desc
	
# Format HTML
$html = "<table><tbody><tr><td><b>URL</b></td><td><b>Current (MB)</b></td><td><b>Quota (MB)</b></td><td><b>Percent</b></td><td></td></tr>"
foreach ($c in $coll) {
	$row = "<tr><td><a href=""{0}/_layouts/15/storman.aspx"">{0}</a></td><td>{1}</td><td>{2}</td><td>{3} %</td><td><div style=""background-color: blue; width: {3}px; height:20px"">&nbsp;</div></td></tr>" -f $c.surl, $c.curr, $c.quota, $c.prct
	$html += $row
}
$html += "</tbody></table>"

# Send email
Send-MailMessage -To $user -From $user -Subject "Office 365 Storage" -Body $html -BodyAsHtml -SmtpServer $smtp

# Plugin

Import-Module Microsoft.Online.SharePoint.PowerShell -ErrorAction SilentlyContinue

# Config -- get URL from "Tenant Admin" page in Office 365

$url = "https://company-admin.sharepoint.com"

$user = "admin@company.com"

$smtp = "mailrelay"

# Connect

Connect-SPOService -url $url -credential $user

# Gather data

$sites = Get-SPOSite -Detailed

$coll = @()

foreach ($s in $sites) {

$curr = $s.StorageUsageCurrent

$quota = $s.StorageQuota

if ($quota -eq 0) {

$prct = [math]::Round($curr, 2) * 100

} else {

$prct = [math]::Round($curr/$quota, 2) * 100

}

$surl = $s.Url

$coll += New-Object -TypeName PSObject -Prop (@{'curr'=$curr;'quota'=$quota;'prct'=$prct;'surl'=$surl})

}

$coll = $coll | sort prct -Desc

# Format HTML

$html = "<table><tbody><tr><td><b>URL</b></td><td><b>Current (MB)</b></td><td><b>Quota (MB)</b></td><td><b>Percent</b></td><td></td></tr>"

foreach ($c in $coll) {

$row = "<tr><td><a href=""{0}/_layouts/15/storman.aspx"">{0}</a></td><td>{1}</td><td>{2}</td><td>{3} %</td><td><div style=""background-color: blue; width: {3}px; height:20px""> </div></td></tr>" -f $c.surl, $c.curr, $c.quota, $c.prct

$html += $row

}

$html += "</tbody></table>"

# Send email

Send-MailMessage -To $user -From $user -Subject "Office 365 Storage" -Body $html -BodyAsHtml -SmtpServer $smtp

February 27, 2014

SharePoint 2013 SP1 – new Central Admin menus

After patching with Service Pack 1 (build 15.0.4569.1000) I noticed a few new menus in Central Admin for connectivity to Office 365 Yammer and Sites. Pretty cool stuff. Screenshots below.

November 11, 2013

MSODAL – Microsoft Online Services Diagnostics and Logging

With more people using Office365 every day, it can be helpful to have a few troubleshooting tools nearby. I had issues sending files over Lync IM and found this helpful download during my research. It verifies the local PC client configuration and is able to apply minor repairs for common configuration issues. Something to keep nearby as we all support more Office365 users.

http://support.microsoft.com/kb/2386684