Get-PowerPivotEngineServiceInstance cmdlet

Article
04/01/2012

Returns one or more instances of SQL Server Analysis Services running on application servers in the farm.

Syntax

Get-PowerPivotEngineServiceInstance [-Identity <PowerPivotEngineServiceInstancePipeBind>] [<CommonParameters>]

Description

The Get-PowerPivotEngineServiceInstance cmdlet returns the properties of one or more SQL Server Analysis Services (PowerPivot) instances running in the farm. The cmdlet reports the application type, status (online or offline), and the identity. To view additional properties of a specific instance, add the Identity parameter and the format-list option to the cmdlet.

Parameters

-Identity <PowerPivotEngineServiceInstancePipeBind>

Specifies the service instance to get. The value must be a valid GUID that uniquely identifies the object in the farm.

Required?	false
Position?	0
Default value
Accept pipeline input?	true
Accept wildcard characters?	false

<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug, ErrorAction, ErrorVariable, WarningAction, WarningVariable,OutBuffer and OutVariable. For more information, see About_CommonParameters

Inputs and Outputs

The input type is the type of the objects that you can pipe to the cmdlet. The return type is the type of the objects that the cmdlet returns.

Inputs	None.
Outputs	None.

Example 1

C:\PS>Get-PowerPivotEngineServiceInstance -Identity 1234567-890a-bcde-fghijklm | format-list

This example returns additional properties of the specified instance, including the server name, version, configuration properties, and upgrade status.