Share via

Get-NAVAppTableModification

Module:
Microsoft.Dynamics.Nav.Apps.Management Module

Gets information about the tabled added or modified by an Extension based on the specified Business Central Server instance.

Syntax

Properties (Default) 

Get-NAVAppTableModification
    [-ServerInstance] <String>
    [-Id <Guid>]
    [-Name <String>]
    [-Publisher <String>]
    [-Version <Version>]
    [-CompatibilityId <Version>]
    [<CommonParameters>]

Tenant 

Get-NAVAppTableModification
    [-ServerInstance] <String>
    -Tenant <TenantId>
    [<CommonParameters>]

Description

Use the Get-NAVAppTableModification cmdlet to get information about tables modified or added by one or more Extension that have been deployed.

The list of deployed Extensions can include all Extensions that have been published to a Business Central Server instance, filtered by Extension properties, or Extensions that are installed for a specific tenant.

Examples

EXAMPLE 1

Get-NAVAppTableModification -ServerInstance DynamicsNAV91

          Id             : 9a47a833-e22f-4812-03f2-ade314219c53
          Name           : SmartApp Base
          Publisher      : Proseware, Inc.
          Version        : 2.0.0.300
          TablesModified : {3, 4}
          TablesAdded    : {42001}
          Dependencies   : {}

          Id             : 3c88160c-e0eb-4fe1-b4f6-011e45d74b10
          Name           : Proseware SmartApp
          Publisher      : Proseware, Inc.
          Version        : 2.3.4.500
          TablesModified : {3, 4}
          TablesAdded    : {42002}
          Dependencies   : {SmartApp Base}

This example returns table modifications from all of the Extensions published on the DynamicsNAV91 server instance.

EXAMPLE 2

Get-NAVAppTableModification -ServerInstance DynamicsNAV91 -Name 'Proseware SmartApp' -Version 2.3.4.500

          Id             : 3c88160c-e0eb-4fe1-b4f6-011e45d74b10
          Name           : Proseware SmartApp
          Publisher      : Proseware, Inc.
          Version        : 2.3.4.500
          TablesModified : {3, 4}
          TablesAdded    : {42002}
          Dependencies   : {SmartApp Base}

This example returns table modifications from the Extension with the specified name and version on the DynamicsNAV91 server instance.

EXAMPLE 3

Get-NAVAppTableModification -ServerInstance DynamicsNAV91 -Publisher 'Proseware, Inc.'

          Id             : 9a47a833-e22f-4812-03f2-ade314219c53
          Name           : SmartApp Base
          Publisher      : Proseware, Inc.
          Version        : 2.0.0.300
          TablesModified : {3, 4}
          TablesAdded    : {42001}
          Dependencies   : {}

          Id             : 3c88160c-e0eb-4fe1-b4f6-011e45d74b10
          Name           : Proseware SmartApp
          Publisher      : Proseware, Inc.
          Version        : 2.3.4.500
          TablesModified : {3, 4}
          TablesAdded    : {42002}
          Dependencies   : {SmartApp Base}

This example returns table modifications from the Extensions on the DynamicsNAV91 server instance that are published by Proseware, Inc.

EXAMPLE 4

Get-NAVAppTableModification -ServerInstance DynamicsNAV91 -Tenant 'Tenant1'

          Id             : 3c88160c-e0eb-4fe1-b4f6-011e45d74b10
          Name           : Proseware SmartApp
          Publisher      : Proseware, Inc.
          Version        : 2.3.4.500
          TablesModified : {3, 4}
          TablesAdded    : {42002}
          Dependencies   : {SmartApp Base}

This example returns table modifications from the Extensions installed for Tenant1 on the DynamicsNAV91 server instance.

EXAMPLE 5

Get-NAVAppTableModification -ServerInstance DynamicsNAV91 -Tenant default

          Id             : 3c88160c-e0eb-4fe1-b4f6-011e45d74b10
          Name           : Proseware SmartApp
          Publisher      : Proseware, Inc.
          Version        : 2.3.4.500
          TablesModified : {3, 4}
          TablesAdded    : {42002}
          Dependencies   : {SmartApp Base}

This example returns table modifications from the Extensions installed in a single tenant NAV server instance.

Parameters

-CompatibilityId

Specifies the compatibility ID of the Extension. The compatibility ID is a version string in the format of Major.Minor.Build.Revision such as 1.0.0.0. The value is used to indicate if there are compatibility-related code changes between different versions of the Extension.

Parameter properties

Type:Version
Default value:None
Supports wildcards:False
DontShow:False
Aliases:AppCompatibilityId

Parameter sets

Properties
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:True
Value from remaining arguments:False

-Id

Specifies the ID of the Extension whose table modifications are to be returned.

Parameter properties

Type:Guid
Default value:None
Supports wildcards:False
DontShow:False
Aliases:AppId

Parameter sets

Properties
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:True
Value from remaining arguments:False

-Name

Specifies the name of the Extension whose table modifications are to be returned.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False
Aliases:AppName

Parameter sets

Properties
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:True
Value from remaining arguments:False

-Publisher

Specifies the publisher of the Extension whose table modifications are to be returned.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False
Aliases:AppPublisher

Parameter sets

Properties
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:True
Value from remaining arguments:False

-ServerInstance

Specifies the Business Central Server instance to which the Extension is deployed, such as DynamicsNAV91.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

(All)
Position:0
Mandatory:True
Value from pipeline:True
Value from pipeline by property name:True
Value from remaining arguments:False

-Tenant

Specifies the ID of the tenant whose installed Extensions you want to get table modifications for, such as Tenant1. Provide a value of 'default' if the specified server instance is not configured to run multiple tenants.

Parameter properties

Type:TenantId
Default value:None
Supports wildcards:False
DontShow:False
Aliases:TenantId

Parameter sets

Tenant
Position:Named
Mandatory:True
Value from pipeline:False
Value from pipeline by property name:True
Value from remaining arguments:False

-Version

Specifies the version of the Extension whose table modifications are to be returned.

Parameter properties

Type:Version
Default value:None
Supports wildcards:False
DontShow:False
Aliases:AppVersion

Parameter sets

Properties
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:True
Value from remaining arguments:False

CommonParameters

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutBuffer, -OutVariable, -PipelineVariable, -ProgressAction, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.