LeBleuet.net

Here is a litle script i’ve build by digging through differents article to match what i needed :

#Extracting the date
$day = get-date -Format dd
$month = get-date -format MM
$year = get-date -format yy
$hour = get-date -Format hh
$min = get-date -Format mm
$today = $day+$month+$year+"-"+$hour+$min
$myFile = "c:\DATA\stats" + $today + ".txt"

#Getting stats from each zone and send all to the text file
Get-DnsServerZone | select zonename | Get-DnsServerStatistics > $myFile

#Sending stats file per email
$PSEmailServer = "email server IP"
Send-MailMessage -From "dnsserver@domain.com" -To "who need the report@domain.com" -Subject $Today" DNS Stats" -Attachments $myFile

First save that into a .ps1 file and then run that through a schedule task with that batch file

@ECHO OFF
PowerShell.exe -Command "& ‘getstats.ps1’"
PAUSE