And when was the last time they logged into their Exchange mailbox? Very important questions on the Microsoft side of the house.

Currently have an Exchange 2010 server on-prem (soon O365) and several aged accounts that needed to be disabled.

On a Windows machine open a command prompt and type quser.exe. This will show you all of the users currently logged in as well as when they logged in, and any idle time. Especially helpful on the Terminal Services hosts/RDS machines.
USERNAME SESSIONNAME ID STATE IDLE TIME LOGON TIME
>BSDMAN console 1 Active none 9/8/2017 7:31 AM
>ADMIN rdp-tcp#0 2 Active none 9/11/2017 11:52 AM

How about for Mailbox exchange users?
Open the Exchange Management PowerShell
get-mailboxstatistics -server YOUREXSERVERNAME | sort LastLogonTime -Decending
To save it to a file just add the > c:\temp\ex_last_logon.txt to the end.

Profit.

So I had been used to having shared workbooks/excel sheets for years. It allowed me to have a single repository for a ton of useful information that I could share with others – and have them edit accordingly. But when I went to start a new one (at my new job, yay!) with Office 2016, I found the option had been replaced with “co-authoring”. Co-authoring is roughly the same feature set but it required the use of sharepoint, onedrive for business, etc. We’re not currently in O365 land, so this wasn’t a great option for me. Where’s my shared workbook??

Open Excel
File > Options > Quick Access Toolbar
List All Commands (drop down)
Scroll down to Compare and Merge Workbooks and click Add
Scroll down to Protect Sharing (Legacy) and click Add
Scroll down to Share Workbook (Legacy) and click Add
Scroll down to Track Changes (Legacy) and click Add
Now you technically only need the Share Workbook option, but since I had used the other options to track changes and do comparisons, I figured you may find those options useful as well.
Click OK.

The four new options (or fewer if you selected less than 4) show up at the top of Excel. Yay!

I had an issue where a certificate template was inadvertently used for all users and machines. Creating a new request daily. For 3 months. Without overwriting the old request. Ouch.

So in my Certificate Authority MMC I saw under Issued Certificates thousands of certs that were expired and I wanted them to just go away. Enter the Admin Command Prompt (I didn’t try with powershell).

certutil -deleterow 5/10/2016 Cert
Apparently this command will only delete up to 3000 per attempt, so I had to run it a few times to get my results.

https://technet.microsoft.com/en-us/library/cc732443.aspx?f=255&MSPPError=-2147217396#BKMK_deleterow

IT and the Legal team recently started working on correcting several key issues. One of those included the ability to keep company email from auto forwarding out to other non-company accounts/companies/etc.

Open a powershell prompt (run as administrator)
$LiveCred = Get-Credential
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.outlook.com/powershell/ -Credential $LiveCred -Authentication Basic -AllowRedirection
Import-PSSession $Session
foreach ($i in (Get-Mailbox -ResultSize unlimited)) { Get-InboxRule -Mailbox $i.DistinguishedName | where {$_.ForwardTo} | fl MailboxOwnerID,Name,ForwardTo >> c:\text\Forward_Rule_list.txt }

If you receive an error “Files cannot be loaded because running scripts is disabled on this system”
Set-ExecutionPolicy RemoteSigned

So I was trying to add Skype For Business PSTN to my O365 account:
Billing > Purchase Services

I couldn’t find the Skype for Business PSTN add-on.

Then I did some searching and found a link that allowed me to see all of the available subscriptions:
https://portal.office.com/commerce/catalog.aspx?empty=1