Get-AppVManagementPackage

Retrieves App-V packages with AD access entitlements from the Microsoft App-V Management database.

Syntax 

Get-AppVManagementPackage
    [-SQLServer <String>]
    [-SQLInstance <String>]
    [-SQLDatabase <String>]
    [-SQLCredential <PSCredential>]
    [-EnabledOnly]
    [<CommonParameters>]

Get-AppVManagementPackage
    [-SQLServer <String>]
    [-SQLInstance <String>]
    [-SQLDatabase <String>]
    [-SQLCredential <PSCredential>]
    -PackageGuid <Guid>
    [-EnabledOnly]
    [<CommonParameters>]

Get-AppVManagementPackage
    [-SQLServer <String>]
    [-SQLInstance <String>]
    [-SQLDatabase <String>]
    [-SQLCredential <PSCredential>]
    -VersionGuid <Guid>
    [<CommonParameters>]

Get-AppVManagementPackage
    [-SQLServer <String>]
    [-SQLInstance <String>]
    [-SQLDatabase <String>]
    [-SQLCredential <PSCredential>]
    -Name <String>
    [-EnabledOnly]
    [<CommonParameters>]

Description

The Get-AppVManagementPackage function queries the App-V Management database to retrieve complete package information including package metadata, version details, and AD entitlements.

Each package includes:

  • DeploymentConfigurationXml: Global deployment configuration (one per package)
  • ADGroups: Array of AD entitlements, each with:
    • UserConfigurationXml: The AD group’s specific user configuration (if any)
    • DeploymentConfigurationXml: Combined deployment config where the UserConfiguration element from the global deployment config is replaced with this AD group’s UserConfiguration (if available)

Parameters

-SQLServer

Specifies the SQL Server hostname or IP address.

   
Type: String
Position: Named
Default value: localhost
Accept pipeline input: False
Accept wildcard characters: False

-SQLInstance

Specifies the SQL Server instance name. If not specified, the default instance will be used.

   
Type: String
Position: Named
Default value: None (default instance)
Accept pipeline input: False
Accept wildcard characters: False

-SQLDatabase

Specifies the App-V Management database name.

   
Type: String
Position: Named
Default value: AppVManagement
Accept pipeline input: False
Accept wildcard characters: False

-SQLCredential

Specifies the PSCredential object for SQL Server authentication. If not specified, Windows Integrated Authentication will be used.

   
Type: PSCredential
Position: Named
Default value: None (Windows Authentication)
Accept pipeline input: False
Accept wildcard characters: False

-PackageGuid

Retrieves a specific package by its PackageGuid. This can be used to get all versions of a specific package.

   
Type: Guid
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-VersionGuid

Retrieves a specific package version by its VersionGuid.

   
Type: Guid
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Name

Filters packages by name using wildcards (). For example, “Adobe” will return all packages starting with “Adobe”.

   
Type: String
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: True

-EnabledOnly

Returns only enabled packages (Enabled = 1).

   
Type: SwitchParameter
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: False

Examples

Example 1: Retrieve all packages 

Get-AppVManagementPackage -SQLServer "sql01.domain.local"

Retrieves all packages with their AD entitlements from the App-V Management database.

Example 2: Retrieve packages using SQL Authentication 

$cred = Get-Credential
Get-AppVManagementPackage -SQLServer "sql01.domain.local" -SQLCredential $cred

Retrieves all packages using SQL Server authentication.

Example 3: Retrieve only enabled packages from a named instance 

Get-AppVManagementPackage -SQLServer "SQLSRV01" -SQLInstance "INSTANCE01" -EnabledOnly

Retrieves only enabled packages from a named SQL Server instance.

Example 4: Filter packages by name 

Get-AppVManagementPackage -SQLServer "SQLSRV01" -Name "Adobe*"

Retrieves all packages with names starting with “Adobe”.

Example 5: Retrieve a specific package by PackageGuid 

Get-AppVManagementPackage -SQLServer "SQLSRV01" -PackageGuid "FB4267F4-6B2B-45E1-A55B-0FE9C69A3DC2"

Retrieves all versions of a specific package by its PackageGuid with AD entitlements.

Notes

  • Requires the SqlServer PowerShell module
  • AD group SIDs are resolved to group names; use Set-AppVentiXADCredential if explicit credentials are needed
  • Use Test-AppVManagementSQLConnection to verify connectivity before querying