Get-NAVAppTableModification

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

Syntax

Get-NAVAppTableModification
   [-Id <Guid>]
   [-Name <String>]
   [-Publisher <String>]
   [-Version <Version>]
   [-Tenant <TenantId>]
   [-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 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

-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 Business Central 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:TenantId
Aliases:TenantId
Position:Named
Default value:None
Required:False
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

Inputs

System.Guid

By property name: Id

System.String

By property name: Name

System.String

By property name: Publisher

System.Version

By property name: Version

Microsoft.Dynamics.Nav.Types.TenantId

By property name: Tenant

System.String

By value and by property name: ServerInstance