powershell command wmiobject not giving output

Question

i am running a powershell command through SQL,please find below code

     declare @sql varchar(200)

set @sql = 'powershell.exe Get-WmiObject -Class MSFT_PhysicalDisk -Namespace root\Microsoft\Windows\Storage| select FriendlyName'


EXEC xp_cmdshell @sql

its gives me output

 output
'select' is not recognized as an internal or external command,
operable program or batch file.
NULL

why it is giving like that if i remove select than powershell command is working

Tom Dee · Accepted Answer · 2018-12-07 15:05:19Z

1

You need to put the arguments in quotes like this:

declare @sql varchar(200)
set @sql = 'powershell.exe "Get-WmiObject -Class MSFT_PhysicalDisk -Namespace root\Microsoft\Windows\Storage| select FriendlyName"'
EXEC xp_cmdshell @sql

Just now it's basically running two separate commands which are:

powershell.exe Get-WmiObject -Class MSFT_PhysicalDisk -Namespace root\Microsoft\Windows\Storage|

Then

select| FriendlyName

So the second command is invalid and causing the error, the quotes group them together to make it process it as one.

edited Dec 7, 2018 at 15:05

answered Dec 7, 2018 at 14:50

Tom Dee

2,6844 gold badges20 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

deepti Over a year ago

but what about SQL

Tom Dee Over a year ago

@deepti I've updated my answer so its set in the variable for you

Collectives™ on Stack Overflow

powershell command wmiobject not giving output

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related