InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 12:21:10 GMT20http://www.sqlservercentral.com/Forums/Topic1401212-391-1.aspxThose requirements are a bit vague. Are you running a select statement? An update? What will your CSV look like? Here is some boilerplate PowerShell code to help you get you started interacting with your CMS.[u][code="plain"]$serverGroupPath = 'SQLSERVER:\SQLRegistration\Central Management Server Group\<GroupName>\'$instanceNameList = dir $serverGroupPath -recurse | where-object { $_.Mode.Equals("-") } | select-object Name -Uniqueforeach($instanceName in $instanceNameList) { # do something against each server here}[/code][/u]Mon, 31 Dec 2012 12:10:00 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1401212-391-1.aspxHi ,I want to run a query on Multiple servers i am using CMS to run it on multiple on server.Now i want to automate this through job,powershell,sqlcmd ...and the result should export to CSV.Pls help.Sat, 29 Dec 2012 16:55:05 GMTbest_yunus