SqlService WMI query in PowerShell returns nothing

Question

I'm trying to run a simple Get-WmiObject call in PowerShell.

Get-WmiObject -computerName $srv -namespace root\Microsoft\SqlServer\ComputerManagement -class SqlService

When running under an account that has administrator rights to the remote server I get no response. The command does complete, but no data is shown. When running this command under an account that does not have rights to the server I get an "Access Denied" message.

When I run this on the remote server directly I get "Invalid namespace", but the server is definitely our SQL Server 2008.

Why doesn't this kind of script return the object as expected?

Peter Mortensen · Accepted Answer · 2015-07-29 18:40:11Z

3

Try

Get-WmiObject -computerName $srv -namespace root\Microsoft\SqlServer\ComputerManagement10 -class SqlService

On several machines I have, the namespace is ComputerManagement10.

BTW, just in case, you need to find the namespace names:

Get-WmiObject -ComputerName $srv -NameSpace root\Microsoft\SQLServer -Class "__NAMESPACE" | Select Name

The above command will tell you the right namespace names.

edited Jul 29, 2015 at 18:40

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Apr 20, 2011 at 4:27

ravikanth

26k4 gold badges62 silver badges61 bronze badges

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

1 Comment

Peter Over a year ago

Turned out all I needed to do was add "10" on to the end of ComputerManagement. Thanks.

Emiliano Poggi · Accepted Answer · 2011-04-20 05:35:41Z

0

Have you checked services with get-service -computername $srv -include “*sql*”?

I would also check whether the class is present in:

Get-WmiObject -Namespace root\Microsoft\SqlServer\ComputerManagement10 -List

answered Apr 20, 2011 at 5:35

Emiliano Poggi

24.9k8 gold badges58 silver badges66 bronze badges

Collectives™ on Stack Overflow

SqlService WMI query in PowerShell returns nothing

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related