This is a public Media Gallery  publicRSS

Action

    Query Database and Send results via e-mail...
    Action posted 11/13/09 by Zachary Loeber
    977 Views
    Name:
    Query Database and Send results via e-mail (optionally update the records as well)
    Description:

    This is a good compliment to the sql query active monitor. It will open a connection to a remote database first. If there are results it will then compose and e-mail and shoot it out to whom ever you specify in the variables at the top of the code.

    Optionally you can update the table values returned as well. I use this to help automate some internal processes but there are many uses for such functionality in the hands of a creative scripter.

    Language:
    VB Script
    Code:
    Disclaimer:
    All scripts found on wugSpace are provided as-is with no warranty or guarantee. These scripts are not supported by Ipswitch Technical Support. If you have a problem with this script, please ask any questions in the comments.