Home Forums SQL Server 2008 SQL Server 2008 - General 2008 Central Management Server - Schedule Multi Server Query? RE: 2008 Central Management Server - Schedule Multi Server Query?

  • December 20, 2010 at 1:57 pm

    #1264798

    Hi shew and others.

    Did you find a way to schedule multi-server queries using PowerShell? I would like to do this too and have been looking at a way to have Enterprise Policy Management Framework use queries in addition to policies.

    Howard

    shew (11/24/2010)

    MysteryJimbo (10/11/2010)

    There's no way of doing it through management studio.

    I accomplished this by using powershell and combining multiple resultset along with @@SERVERNAME into a $variable and pinging a HTML email report with the result.

    This sounds like exactly what I need to do. Can you post some code?