Asset Definition Spreadsheets

NI InsightCM™ 3.3 Help

Edition Date: December 2018

Part Number: 374498G-01

»View Product Info
Download Help (Windows Only)

InsightCM allows users to edit multiple assets at one time using an exported spreadsheet. Asset spreadsheets contain the following worksheets:

  • AssetNodes—The settings that determine the functionality of an asset.
    • FullName—The full path to the asset in the asset tree with each level separated by pipes. For example, Location|Equipment|Accelerometer.
    • Type—The name of the asset type, such as, Accelerometer, Equipment, or Tachometer.
    • Disabled—Disables the asset if set to true.
    • MeasType—Indicates whether the asset acquires data as a waveform or a single point and what type of measurement you want the asset to perform. For example, Waveform|Tachometer.
    • Categories—Categories that describe the asset type and determine what capabilities are available for the asset type, such as Dynamic, RotatingEquipment, or Accelerometer.
  • AssetNodeProperties—The properties that are available for an asset.
    • FullName—The full path to the asset in the asset tree with each level separated by pipes. For example, Location|Equipment|Accelerometer.
    • PropertyName—The name that the NI InsightCM web application displays for the property.
    • PropertyValue—The value you want the NI InsightCM web application to set for the property when you import the spreadsheet.
  • OperatingStates—The operating states that are available for an asset.
    • FullName—The full path to the asset in the asset tree with each level separated by pipes. For example, Location|Equipment|Accelerometer.
    • Name—The name of the operating state that the NI InsightCM web application displays.
  • OperatingStateProperties—The properties an operating state has when it is assigned to a specific asset.
    • FullName—The full path to the asset in the asset tree with each level separated by pipes. For example, Location|Equipment|Accelerometer.
    • OperatingState—The operating state to which the property defined in this row applies.
    • PropertyName—The name of the property that the NI InsightCM web application displays.
    • PropertyValue—The value you want the NI InsightCM web application to set for the property when you import the spreadsheet.
  • Triggers—The triggers that are available on an operating state assigned to a specific asset.
    • FullName—The full path to the asset in the asset tree with each level separated by pipes. For example, Location|Equipment|Accelerometer.
    • OperatingState—The name of the operating state to which the property applies.
    • Type—The kind of trigger you want to configure. For example, EnterTrigger.
    • Expression—The expression or combination of expressions required to activate the trigger.
  • TriggerConditions—The trigger conditions that are available for each trigger on an operating state assigned to a specific asset.
    • FullName—The full path to the asset in the asset tree with each level separated by pipes. For example, Location|Equipment|Accelerometer.
    • OperatingState—The name of the operating state to which the trigger condition applies.
    • TriggerType—Which trigger the condition applies to.
    • Type—Specifies whether the trigger is time-based, such as Cron or Timespan, or feature-based, such as Trend.
    • Source—The feature that determines a feature-based trigger.
    • Operator—How the NI InsightCM web application compares the trend value to the compare value. For example, Greater than or Equal to.
    • CompareTo—The value that the NI InsightCM web application compares the trend value to.
    • DwellSeconds—How long the trigger condition must be true before the NI InsightCM web applications activates the trigger.
  • Features—The features that are available for an asset.
    • FullName—The full path to the asset in the asset tree with each level separated by pipes. For example, Location|Equipment|Accelerometer.
    • Feature—The name of the feature that the NI InsightCM web application displays.
  • FeatureProperties—The properties a feature has when assigned to a specific asset.
    • FullName—The full path to the asset in the asset tree with each level separated by pipes. For example, Location|Equipment|Accelerometer.
    • Feature—The name of the feature to which the property applies.
    • PropertyName—The name of the property that the NI InsightCM web application displays.
    • PropertyValue—The value you want the NI InsightCM web application to set for the property when you import the spreadsheet.
  • TrendAlarmRules—Alarm rules for features assigned to a specific asset.
    • FullName—The full path to the asset in the asset tree with each level separated by pipes. For example, Location|Equipment|Accelerometer.
    • Id—The string that other sections of the spreadsheet use to reference the alarm rule.
    • TrendName—The name of the feature to which the alarm rule applies.
    • Operator—How the NI InsightCM web application compares the trend value to the compare value. For example, Greater than or Equal to.
    • OperatingState—The operating state or states to which the alarm rule applies.
    • Hysteresis—An offset from the set point whose value causes NI InsightCM Server to clear the alarm when crossed.
    • OnDelaySeconds—The amount of time, in seconds, the set point must remain crossed before NI InsightCM Server sets the alarm.
    • OffDelaySeconds—The amount of time, in seconds, the hysteresis level must remain crossed before NI InsightCM Server clears the alarm.
    • AutoConfigCalc—Specifies whether to automatically configure levels from baseline values.
    • Disabled—Disables the alarm rule when set to true.
  • TrendAlarmLevels—How alarm levels are calculated for specific alarm rules.
    • RuleId—A string that specifies which alarm rule the level applies to.
    • Severity—The urgency of the level.
    • CompareTo—The value that the NI InsightCM web application compares the trend value to.
    • AutoConfig—Specifies whether to automatically configure levels from baseline values.
  • AlarmActions—Specifies whether the NI InsightCM web application takes any action when a specific alarm is set.
    • AlarmId—A string that specifies which alarm rule the action applies to.
    • Severity—The urgency of the alarm level.
    • ActionName—A name that distinguishes this action from others.
    • Type—Specifies whether to send an email notification when the alarm is set.
  • AlarmActionProperties—The action the NI InsightCM web application takes when a specific alarm is set.
    • AlarmId—A string that specifies which alarm rule the action applies to.
    • Severity—The urgency of the alarm level.
    • ActionName—The name of the action to which the property applies.
    • PropertyName—Specifies whether this property specifies an address group or an email template.
    • PropertyValue—A string that specifies a particular address group or email template.
  • SpectralAlarmRules—Spectral alarm rules for features assigned to a specific asset.
    • FullName—The full path to the asset in the asset tree with each level separated by pipes. For example, Location|Equipment|Accelerometer.
    • Id—The string that other sections of the spreadsheet use to reference the alarm rule.
    • OperatingState—The operating state or states to which the alarm rule applies.
    • Unit—Specifies the units in which to measure sensor data on the asset the sensor monitors.
    • Integration—Specifies the type of integration, if any, to apply to asset data to check for this rule.
    • Cutoff—Specifies the frequency, in Hz, at which to set the highpass filter when performing double integration on asset data.
  • SpectralAlarmLevels—How alarm levels are calculated for specific spectral alarm rules.
    • RuleId—A string that specifies which alarm rule the level applies to.
    • Severity—The urgency of the level.
    • CompareTo—The value that the NI InsightCM web application compares the trend value to.
  • SpectralAlarmActions—Specifies whether the NI InsightCM web application takes any action when a specific spectral alarm is set.
    • AlarmId—A string that specifies which alarm rule the action applies to.
    • Severity—The urgency of the alarm level.
    • ActionName—A name that distinguishes this action from others.
    • Type—Specifies whether to send an email notification when the alarm is set.
  • SpectralAlarmActionProperties—The action the NI InsightCM web application takes when a specific spectral alarm is set.
    • AlarmId—A string that specifies which alarm rule the action applies to.
    • Severity—The urgency of the alarm level.
    • ActionName—The name of the action to which the property applies.
    • PropertyName—Specifies whether this property specifies an address group or an email template.
    • PropertyValue—A string that specifies a particular address group or email template.
  • FaultFrequencies—Known frequencies that are problematic for an asset so that the NI InsightCM web application notes them on the Data Viewer page.
    • FullName—The full path to the asset in the asset tree with each level separated by pipes. For example, Location|Equipment|Accelerometer.
    • Name—A unique name for the fault frequency.
    • Type—Specifies whether the fault level is in orders or frequency
    • Level—The fault level.
  • NamedGroups—The name of a group of fault frequencies assigned to an asset.
    • FullName—The full path to the asset in the asset tree with each level separated by pipes. For example, Location|Equipment|Accelerometer.
    • Type—Enter fault frequencies as the value for this column.
    • Name—A unique name for the fault frequency group.

WAS THIS ARTICLE HELPFUL?

Not Helpful