Design
Hello, In a previous post I am using a shell script allowing me sending mailboxes statistics. I have the below report about the servers Disk space and I would need your help to "re-disign" my html file as I would like my report to look like the same as the below one. Please find my script below: Company - Exchange 2007 Servers Disk Space xxxxx01 Drive Label Drive / Mount Size (in GB) Freespace (in GB) Freespace Pcnt OS C: 12 2,77 23,07 LOGS D: 55,64 48,63 87,4 QUEUE E: 67,75 66,9 98,75 Last Updated: 21/12/2009 09:00:00 xxxxx02 Drive Label Drive / Mount Size (in GB) Freespace (in GB) Freespace Pcnt OS C: 12 2,46 20,47 LOGS D: 55,64 49,45 88,89 QUEUE E: 67,75 67,59 99,77 Last Updated: 21/12/2009 09:00:00 ----------------------------- function SendMail($Recipient) { $SmtpClient = new-object system.net.mail.smtpClient $MailMessage = New-Object system.net.mail.mailmessage $SmtpClient.Host = "xxxxx.company.intra" $mailmessage.from = "admin@company.com " $mailmessage.To.add("$Recipient") $mailmessage.Subject = "[COMPANY] Mailbox Statistics - $date" $mailmessage.IsBodyHTML = $true $mailmessage.Body = $body #add attachment $mailattachment = new-object System.Net.Mail.Attachment($attachment) $mailmessage.attachments.add($mailattachment) $smtpclient.Send($mailmessage) } $date = $(get-date).GetDateTimeFormats()[6] $a = "<style>" $a = $a + "BODY{background-color:#FFFFFF;}" $a = $a + "TABLE{border-width: 1px;border-style: solid;border-color: black;border-collapse: collapse;}" $a = $a + "TH{border-width: 1px;padding: 0px;border-style: solid;border-color: black;background-color:#E3CEF6}" $a = $a + "TD{border-width: 1px;padding: 0px;border-style: solid;border-color: black;background-color:#E3CEF6}" $a = $a + "</style>" Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | ConvertTo-HTML -head $a -property DisplayName, lastlogontime, @{l="TotalItemSize(KB)";expression={$_.TotalItemSize.Value.ToKB()}},ItemCount | Out-File c:\scripts\mailboxes.htm $Recipient = "graig@company.com " $body = $Statistics $attachment = "c:\scripts\mailboxes.htm" SendMail($Recipient) #End
December 23rd, 2009 5:53pm

Wow. Now this needs CSS HTML coding. customizing $a block of the script-let. Need to create multiple CSS Templates and call them while converting output to HTML where required. Will try to do that. Thanks. Vishal Ramnani MCITP - Exchange 2007, MCSE Messaging, MCTS - Win 2008 Config
Free Windows Admin Tool Kit Click here and download it now
December 24th, 2009 9:26am

Hello, Regarding the issue, I suggest you contact our CSS at: https://support.microsoft.com/oas/default.aspx?ln=en-us&x=18&y=14&c1=508&gprid=10926&&st=1 Or write the post in our development forum to see if someone can help: http://social.technet.microsoft.com/Forums/en-US/exchangesvrdevelopment/threads Thanks, Elvis
December 25th, 2009 10:05am

Hello Elvis,Sorry for not getting back to you sooner.. I was on holidays.I did follow your advice and post a new threat in the development forum.Many Thanks,Graig
Free Windows Admin Tool Kit Click here and download it now
January 7th, 2010 12:07pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics