Get-NAVAppTableModification

Gets information about the tabled added or modified by an Extension based on the specified Microsoft Dynamics NAV Server instance.

Syntax

Get-NAVAppTableModification
   [-Id <Guid>]
   [-Name <String>]
   [-Publisher <String>]
   [-Version <Version>]
   [-CompatibilityId <Version>]
   [-ServerInstance] <String>
   [<CommonParameters>]
Get-NAVAppTableModification
   -Tenant <String>
   [-ServerInstance] <String>
   [<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 Microsoft Dynamics NAV 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.

Type:Version
Aliases:AppCompatibilityId
Position:Named
Default value:None
Required:False
Accept pipeline input:True
Accept wildcard characters:False

-Id

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

Type:Guid
Aliases:AppId
Position:Named
Default value:None
Required:False
Accept pipeline input:True
Accept wildcard characters:False

-Name

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

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

-Publisher

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

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

-ServerInstance

Specifies the Microsoft Dynamics NAV Server instance to which the Extension is deployed, such as DynamicsNAV91.

Type:String
Position:0
Default value:None
Required:True
Accept pipeline input:True
Accept wildcard characters: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.

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

-Version

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

Type:Version
Aliases:AppVersion
Position:Named
Default value:None
Required:False
Accept pipeline input:True
Accept wildcard characters:False