Every morning we get a few hundred emails from our various customers servers that tell us how their backup went that previous night. Somebody has to go through these and fill out an excel spread sheet. I would like to automate this, we have our own server running a .NET application so i can schedule something every morning.
There are two main parts. The first is i want to know how to create a table that has customers down the left and dates accross the right, they are called pivot tables in access but not sure how to recreate them in MSSQL and to do it on the fly as i dont want to have to sit there entering 100's of days at a time.
The second is that differnt customers use differnt backup solutions, so i want to write some code that scans a particular mailbox in exchange, looks for emails that have come in in the past 12 hours, look at the from email address and match that to one in the database, then according to the subject line it will be able to identify what type of backup solution it is, e.g. if it says "Backup Exec Job completd Sucessfully" it knows its backup exec and will look for a particular text (completed successfully, completed with exceptions, no media etc) and can insert that, or if its a differnet backup solution then go and look at a specific place in that email for it.
I know this could be quite time consuming but any hel
View Complete Post