Get-AppVManagementConnectionGroup¶

Retrieves App-V Connection Groups (Package Groups) from the Management Database.

Syntax¶

Get-AppVManagementConnectionGroup
    [-SQLServer <String>]
    [-SQLInstance <String>]
    [-SQLDatabase <String>]
    [-SQLCredential <PSCredential>]
    [-ConnectionGroupName <String>]
    [<CommonParameters>]

Description¶

The Get-AppVManagementConnectionGroup function queries the App-V Management Database to retrieve Connection Group information including member packages and their configuration. It also resolves Active Directory group assignments (entitlements) for each Connection Group.

Each returned Connection Group object includes: - Connection Group metadata (ID, Name, Description, Enabled, Priority, Version) - Array of member packages with their load order, optional/required status, and version settings - Array of AD groups (entitlements) with SID and resolved group name

Parameters¶

-SQLServer¶

Specifies the SQL Server hostname or IP address where the App-V Management database is hosted.


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

-ConnectionGroupName¶

Specifies an optional filter to retrieve a specific Connection Group by name.


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

Examples¶

Example 1: Retrieve all Connection Groups¶

Get-AppVManagementConnectionGroup -SQLServer "sql01.domain.local" -SQLCredential $cred

Retrieves all Connection Groups from the specified SQL Server.

Example 2: Retrieve a specific Connection Group¶

Get-AppVManagementConnectionGroup -SQLServer "sql01.domain.local" -SQLCredential $cred -ConnectionGroupName "Office Suite"

Retrieves a specific Connection Group named "Office Suite".

Notes¶

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