May 4 2011

Schedule SCCM reports to be emailed without SQL reporting services



----------------------------------------------------------------------------
I use a maximum of one Google Ad per post to help offset some of my blog hosting costs.

----------------------------------------------------------------------------

I recently had a requirement to be able to email SCCM reports on a schedule in an environment without SQL reporting services. I achieved this by creating a VB script to create an email that has the report ASP page as the body of the email. The script I used and scheduled as a Windows scheduled task was:


Set objMessage = CreateObject("CDO.Message")
objMessage.Subject = "Computers that do NOT have ......"
objMessage.From = "from@email.address"
objMessage.To = "to@email.address"
'==This section provides the configuration information for the remote SMTP server.
'==Normally you will only change the server name or IP.
objMessage.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
'Name or IP of Remote SMTP Server
objMessage.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "smtp.server.address.here"
'Server port (typically 25)
objMessage.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
objMessage.Configuration.Fields.Update
'==End remote SMTP server configuration section==
'The line below shows how to send a webpage from a remote site
objMessage.CreateMHTMLBody "http://serverURL/SMSReporting_P00/Report.asp?ReportID=422"
objMessage.Send

Just change the variables for your environment.
 
 



----------------------------------------------------------------------------
I use a maximum of one Google Ad per post to help offset some of my blog hosting costs.

----------------------------------------------------------------------------

March 12 2010

Send SCCM task sequence email report

I wanted an easy way to know if OS deployments were failing or succeeding. We’ve come up with a good way of sending an email outlining task sequence completion status.

  • In SCCM, create a Status Filter rule by going to Site Database – Site Management – Primary Site – Site Settings – Status Filter Rules.
  • On the general tab, use Component : Task Sequence Manager, Message ID: 11170 . (11170 signifies failure, 11171 is for success.)
  • On the actions tab, tick Run a program and use something like ‘powershell.exe D:SCRIPTSTS_Email_Notification.PS1 %msgsys’.

TS_Email_Notification.PS1 should contain the following:

param([string]$strComputerName)
$erroractionpreference = "SilentlyContinue"
$strSMTP = "mail.domain.com"
$strSubject = "SCCM OSD Deployment Completed for $strComputerName"
$strBody = "$strComputerName has Completed the Task Sequence"
$MailMessage = New-Object System.Net.Mail.MailMessage
$MailMessage.IsBodyHtml = $true
$SMTPClient = New-Object System.Net.Mail.smtpClient
$SMTPClient.host = $strSMTP
$Sender = New-Object System.Net.Mail.MailAddress("sender@domain.com", "Sender")
$Recipient = New-Object System.Net.Mail.MailAddress("recipient@domain.com", "Recipient")
$MailMessage.Sender = $Sender
$MailMessage.From = $Sender
$MailMessage.Subject = $strSubject
$MailMessage.To.add($Recipient)
$MailMessage.Body = $strBody
$SMTPClient.Send($MailMessage)

You just need to adjust the above Powershell script for your mail settings and you will now receive an email each time there is a successful or failed OS deployment.

November 18 2009

Migrating email to Google Apps

I recently made the choice to move my email hosting to Google Apps after having several bad experiences with my previous email hosting provider.

I decided to use the ‘free’ Standard Edition which seemed to meet my requirements. It was a surprising easy transition which involved the following steps:

  • Verify domain ownership – this required me to upload a small file to my www.danovich.com.au website to provide that I had ownership of the domain
  • Create accounts – using the Google Apps web interface, I created new accounts for all users using danovich.com.au
  • Google Email Uploader – I used this fantastic tool to upload all of my email from my existing Outlook PST file. It was a very easy to use tool and can be stopped and started as  needed. My Outlook emails then started to appear in the Google Apps web interface. It also preserved information such as sent dates and sender/recipient data, as well as the folder structure used by Outlook.
  • Change MX DNS records – I updated the domain MX records to point to the Google servers, which also provided many more entries than previous hosting company, giving an added level of comfort
  • Imported my Outlook calendar into Google Apps

So far I’ve found Google Apps to have a fantastic web interface and I’ve also configured an IMAP connection so that I can still use the feature of Outlook if required. I’m really enjoying the powerful search within Google Apps as well as the web-based Offline mode provided by Gears.  I still have access to all of my old emails throught a single interface and not a single email was lost for any users during the transition.

The only negative thing I have found so far is that with the web-based version of Google Apps, you cannot set a default font for when you compose an email, which can be quite frustrating.

I now gain the benefits of hosting email for free with a company like Google, which give me many connectivity options and allows for almost unlimited customization. Overall, this was a very painless experience and I would highly recommend it as a solution to anyone having issues with email hosting.

September 1 2009

optushome.com.au emails stop working?

For those of you who are unaware, optushome.com.au is a domain name belonging to Optus from when their broadband product was called Optus @ Home. There are many thousand of customers including myself who have been using Optus Cable broadband for over 8 years and therefore have a optushome.com.au email address.

Then last night, without notice, they switched it off this domain. What does this mean? Any emails send to anybody@optushome.com.au will get bounced back and not delivered to the loyal Optus customer.

This is very poor form Optus, considering you are affecting your most loyal customers, the ones that have been with you for many years.

There is a simple technical solution involving domain name rediection that you could easily have implemented. It’s really not that hard. If you are stuggling, drop me a line and I’ll come and assist you.

It’s pathetic Optus, really pathetic.

More details from this news article –> http://www.australianit.news.com.au/story/0,25197,26012012-15306,00.html

Category: Geek | LEAVE A COMMENT