convert Last Logon from Date to number of days?

spiceuser-iqxup · 2021-11-04T04:46:04.000Z

How to convert Last Logon from Date to number of days since Last Logon, this is my script. Also for users without a mailbox how do I get it to not give me “the user doenst exist” while script is running

Connect-MsolService
Connect-ExchangeOnline
$Result=@()
$mailboxes = Get-MsolUser -MaxResults 5000 | where islicensed -eq true
$totalmbx = $mailboxes.Count
$i = 1
$mailboxes | ForEach-Object {
$i++
$mbx = $_
$mbs = Get-MailboxStatistics -Identity $mbx.UserPrincipalName | Select LastLogonTime
if ($mbs.LastLogonTime -eq $null){
$lt = “Never Logged In”
}else{
$lt = $mbs.LastLogonTime }

Write-Progress -activity “Processing $mbx” -status “$i out of $totalmbx completed”

$Result += New-Object PSObject -property @{
Name = $mbx.DisplayName
UserPrincipalName = $mbx.UserPrincipalName
licenses = $mbx.Licenses[0].AccountSkuId
LastLogonTime = $lt }
}

$Result | Export-CSV “C:\O365-LastLogon-Info.csv” -NoTypeInformation -Encoding UTF8

Neally · 2021-11-04T06:02:39.000Z

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don't say "Need help" or "PowerShell Help", actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy, past…

192033ab-bb8f-4032-88a5-8e2313af0344-codebutton_small.png

Neally Bot

Neally · 2021-11-04T06:08:07.000Z

you don’t ‘convert’ it.

You create a new timespan to calculate it.

new-timespan -start $lastLogonTime -end (get-date)

spiceuser-iqxup:

$mbs.LastLogonTime -eq $null

if you compare to $null, $null should be on the left

rencore.com

PowerShell – Null comparison demystified

I have been working recently on the guidance for PowerShell rules. Rule research requires a lot of research and digging into how a programming language […]

and for the error, you can use try/catch with erroraction stop if the user exists.

Also in PowerShell += should be avoided, it’s the Array serial Killer

Just assign it to a variable or use a generic list.