Skip to main content

system.kanoa.asset.populateAssetHierarchy

Requires kanoaOPS license

Description

Forces a rebuild of the mes.assetHierarchy_MAT table by calling the stored procedure spPopulateAssetHierarchy. This is a materialized table used by the vwAssets db view and system.kanoa.asset.getAssets() function.

Syntax

populateAssetHierarchy()

Parameters:
  • None

  • Returns:
  • None
  • Code Examples

    system.kanoa.asset.populateAssetHierarchy()