dbachecks icon indicating copy to clipboard operation
dbachecks copied to clipboard

Add feature to allow different formats of mail output (text/basic html/advanced html)

Open JanMulkens opened this issue 7 years ago • 4 comments

The email output I receive is horribly misformed compared to the beautiful example currently posted in the readme. I get his issue in outlook 2010 on windows 7 but also outlook 2016 on windows 10.

While accepting that this has to do with my environment setup, I'd love to see some other options regarding different types of mail output.

I'm thinking of a parameter option for:

  • [ ] Pure text mails that cover the bare minimum,
  • [ ] HTML mails in some older/other format that's supported by all clients/setups. Just tables, perhaps a graph if possible.
  • [ ] The "advanced" output that is currently on display in the readme

This is the current output i receive in windows 7 + outlook 2010 image

This is the current output i receive in windows 10 + outlook 2016 image

JanMulkens avatar Jan 25 '18 13:01 JanMulkens

Thats interesting, I normally only see that if I am working off-line - The reportviewer generated HTML does indeed require some calls out to I think some API somewhere to build the graphs

Maybe we should consider Format-Pester, although I don't like the output so much (it could work for the basic option

Or we have to roll our own?

I'm happy to give this a go unless someone else wants to play

SQLDBAWithABeard avatar Jan 26 '18 12:01 SQLDBAWithABeard

The server generating the report mail is offline and I can imagine a lot of people running this offline somewhere. Could we include those graph building things? Because a beautiful mail like that is double-plus-good !

Format-Pester looks awesome for the "basic HTML" and "text" versions! Still would love the graphs tho ;)

JanMulkens avatar Jan 26 '18 13:01 JanMulkens

hey @SQLDBAWithABeard - i really like this idea. Please let me know if you have time this week to code it up

potatoqualitee avatar Feb 07 '18 11:02 potatoqualitee

Honestly, probably not with everything else we need to do for Bits

SQLDBAWithABeard avatar Feb 07 '18 12:02 SQLDBAWithABeard