I have a need to provide certain stats every month for our managerial teams on some of our contracts. One of which is the Terminal Services licensing.<\/p>\n
So instead of emailing them when they remember to ask us for it, I automated it using Powershell.<\/p>\n
[CC lang=\u2019powershell\u2019]<\/p>\n
# Short and Nasty Wee script for counting RDS CALs<\/p>\n
Push-Location (Split-Path -path $MyInvocation.MyCommand.Definition -Parent)
\n$Date = Get-Date -Format dd-MM-yy<\/p>\n
# DCs
\n$dcs = @(‘DC01′,’DC02’)
\n$results = @()<\/p>\n
$dcs | %{
\n$cals = GWMI -class win32_TSLicenseKeyPack -computername $_
\n$results += “`nServer: `t” + $_
\n$results += “Total: `t`t” + $cals.totallicenses[1]
\n$results += “Available: `t” + $cals.AvailableLicenses[1]
\n$results += “Issued: `t`t” + $cals.IssuedLicenses[1]
\n}<\/p>\n
$results | SC ‘.\\temp\\body.txt’<\/p>\n
$smtpserver = ‘mail.yourdomain.uk’
\n$emailFrom = ‘RDSCALCounter@yourdomain.uk’
\n$emailto = ‘recipient@yourdomain.uk’
\n$subject = “Monthly CAL Counts”
\n$encoding = [System.Text.Encoding]::UTF8<\/p>\n
if (Test-Path ‘.\\temp\\body.txt’){
\n$body = GC ‘.\\temp\\body.txt’ -raw
\nSend-MailMessage -SmtpServer $smtpserver -from $emailfrom -to $emailto -Subject $subject -body $body -Priority high -Encoding $encoding
\nRemove-Item ‘.\\temp\\body.txt’
\n}
\nElse{
\nSend-MailMessage -SmtpServer $smtpserver -from $emailfrom -to $emailto -Subject $subject -body ‘File Doesnt Exist’ -Priority high -Encoding $encoding
\n}<\/p>\n
[\/CC]<\/p>\n","protected":false},"excerpt":{"rendered":"
I have a need to provide certain stats every month for our managerial teams on…<\/p>\n","protected":false},"author":1,"featured_media":988,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[19,11],"tags":[22,67],"class_list":["post-963","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-powershell","category-scripts","tag-cals","tag-rds"],"jetpack_featured_media_url":"https:\/\/ihni.uk\/wp-content\/uploads\/2020\/02\/Powershell.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/posts\/963","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ihni.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=963"}],"version-history":[{"count":0,"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/posts\/963\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/media\/988"}],"wp:attachment":[{"href":"https:\/\/ihni.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=963"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ihni.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=963"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ihni.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=963"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}