It does not run from SQLAgent.

Message

Executed as user: The error information returned by PowerShell is: 'The term 'Send-MailMessage' is not recognized as the name of a cmdlet, function, script file,...

Send-MailMessage –From abcdef@abcd.org –To edft@gsdg.org –Subject “Test Email” –Body “Powershell Email Testing” –SmtpServer smtp.abcd.org

When I run the above command from the powershell window it sends out an email,but...

I do not get any email alert

Then is there a foolproof waay of finding all the windows servers/or sql instances within in a domain using powershell/or any process.

I tried the above process but my list did...

Yes, that column name has changed in 2012 and it is shown in kbs and bytes across these different versions.Hence this issue.

How do I get this working ?

I can't use...

Only the Servername is changing but it is returning the same data for all the servers:

$Results = Foreach ($Server in (get-content "C:\serverlist\Server.txt"))

{Get-WmiObject Win32_LogicalDisk | Select @{Name="Server";Expression={$Server}},DeviceID,VolumeName,Drive,Size,FreeSpace | Format-Table ...

I am trying to collect drives space details (total and available) from across a list of 150 servers using t-sql and SSIS with t-sql as part of the SSIS package.

Noted and thank you again !

Thanks...That is one of the solutions but was curious to know if I could do using only t-sql.

Anyways thank you for the response.

Thank you

Apologies to disappoint people on board for their 'humour'. But that is not the case.

I need to extract the result from the stored procedure from a bunch of servers along...

I have already built the package.It works fine as long as the servers exists.

Lets say a server is not reachable for any reason.My foreachloop should skip that server and go...

Permanent tables is not a option.I think SSIS works with temp table with some settings but no sure how...

Cant create permanent DB objects.In SSIS I will be running the above query across many servers to gather the information as per the query details.

Yes it works perfectly in management studio.