Gets a list of all available database schema versions for the Machine Creation Service.
Get-ProvInstalledDBVersion [-Upgrade] [-Downgrade] [-BearerToken <String>] [-TraceParent <String>] [-TraceState <String>] [-VirtualSiteId <String>] [-AdminAddress <String>] [<CommonParameters>]
Gets the current version number of the Citrix Machine Creation Service database schema when called with no parameters.
When called with the -Upgrade parameter, gets the service schema version numbers to which an upgrade could be performed.
When called with the -Downgrade parameter, gets the service schema version numbers to which a downgrade could be performed.
The SQL scripts to perform schema upgrades and downgrades can be obtained using the Get-ProvDBVersionChangeScript cmdlet. Citrix recommends that where possible service schema upgrades are performed using Citrix Studio rather than manually via the SDK.
Only one of the -Upgrade or -Downgrade parameters may be supplied at once.
|Name||Description||Required?||Pipeline Input||Default Value|
|Upgrade||Specifies that only schema versions to which the current database version can be upgraded should be returned.||false||false|
|Downgrade||Specifies that only schema versions to which the current database version can be downgraded should be returned.||false||false|
|BearerToken||Specifies the bearer token assigned to the calling user||false||false|
|TraceParent||Specifies the trace parent assigned for internal diagnostic tracing use||false||false|
|TraceState||Specifies the trace state assigned for internal diagnostic tracing user||false||false|
|VirtualSiteId||Specifies the virtual site the PowerShell snap-in will connect to.||false||false|
|AdminAddress||The address of a Citrix Virtual Apps and Desktops controller the PowerShell snap-in will connect to. You can provide this as a host name or an IP address.||false||false||Localhost. Once a value is provided by any cmdlet, this value becomes the default.|
You cannot pipe input into this cmdlet.
Get-ProvInstalledDBVersion returns database schema version numbers as requested:
If the command fails, the following errors can be returned.
InvalidParameterCombination Both the Upgrade and Downgrade flags were specified. NoOp The operation was successful but had no effect. NoDBConnections The database connection string for the Machine Creation Service has not been specified. DatabaseError An error occurred in the service while attempting a database operation. DatabaseNotConfigured The operation could not be completed because the database for the service is not configured. DataStoreException An error occurred in the service while attempting a database operation - communication with the database failed for various reasons. PermissionDenied You do not have permission to execute this command. AuthorizationError There was a problem communicating with the Citrix Delegated Administration Service. CommunicationError There was a problem communicating with the remote service. ExceptionThrown An unexpected error occurred. For more details, see the Windows event logs on the controller or the Citrix Virtual Apps and Desktops logs.
PS C:\>Get-ProvInstalledDBVersion Major Minor Build Revision ----- ----- ----- -------- 5 6 0 0
Gets the current Citrix Machine Creation Service database schema version number.
Get the versions of the Machine Creation Service database schema for which upgrade scripts are supplied.