Create a report based on SAM components or PowerShell

Shoro

I'm trying to create a report for AD users account that their passwords will expired within 7 days based on PowerShell script:

Get-ADUser -filter {Enabled -eq $true -and PasswordNeverExpires -eq $false -and PasswordExpired -eq $false} -Properties "Name", "EmailAddress", "msDS-UserPasswordExpiryTimeComputed" | 
Where-Object {$_."msDS-UserPasswordExpiryTimeComputed" -ne 0} | 
Select-Object -Property "Name", "EmailAddress", @{Name = "PasswordExpiry"; Expression = {[datetime]::FromFileTime($_."msDS-UserPasswordExpiryTimeComputed")}} | 
Where-Object {$_.PasswordExpiry -ge (Get-Date).Date -and $_.PasswordExpiry -le (Get-Date).Date.AddDays(7)}

Any idea how to create a daily report or an alert for that??

Thanks

KMSigma.SWI

SAM isn't meant to manage users, so it doesn't exactly have a mechanism to do this.  That being said, there is a pre-existing template made to run on Active Directory servers to pull similar information: Active Directory 2016 Domain Controller Security - Application Monitor Templates

You could always add your own script to include in this template.  But the data that you'll be receiving will be "numbers" (0 users have upcoming passwords expiring, 11 users, 26 users, etc.).  Can you also pull in their usernames or email addresses into a text field - yes, but I don't see what you'd benefit from it.