Skip to content
DataMiner DoJo

More results...

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Search in posts
Search in pages
Search in posts
Search in pages
Log in
Menu
  • Updates & Insights
  • Questions
  • Learning
    • E-learning Courses
    • Empower Replay: Limited Edition
    • Tutorials
    • Open Classroom Training
    • Certification
      • DataMiner Fundamentals
      • DataMiner Configurator
      • DataMiner Automation
      • Scripts & Connectors Developer: HTTP Basics
      • Scripts & Connectors Developer: SNMP Basics
      • Visual Overview – Level 1
      • Verify a certificate
    • Video Library
    • Books We Like
    • >> Go to DataMiner Docs
  • Expert Center
    • Solutions & Use Cases
      • Solutions
      • Use Case Library
    • Markets & Industries
      • Media production
      • Government & defense
      • Content distribution
      • Service providers
      • Partners
      • OSS/BSS
    • Agile
      • Agile Webspace
      • Everything Agile
        • The Agile Manifesto
        • Best Practices
        • Retro Recipes
      • Methodologies
        • The Scrum Framework
        • Kanban
        • Extreme Programming
      • Roles
        • The Product Owner
        • The Agile Coach
        • The Quality & UX Coach (QX)
    • DataMiner DevOps Professional Program
      • About the DevOps Program
      • DataMiner DevOps Support
  • Downloads
  • More
    • DataMiner Releases & Updates
    • Feature Suggestions
    • Climb the leaderboard!
    • Swag Shop
    • Contact
    • Global Feedback Survey
  • PARTNERS
    • All Partners
    • Technology Partners
    • Strategic Partner Program
    • Deal Registration
  • >> Go to dataminer.services

Most efficient manner to get Element table parameter

Solved811 views23rd November 2023Automation SLAutomation
4
Vish Arivalagan [DevOps Advocate]116 23rd November 2023 0 Comments

Hi Dojo,

I need to grab multiple parameters across multiple tables belonging to an Element, wondering what is the most efficient manner to go about this given I have the column/parameter ID and primary key? Are there any asynchronous methods that can be used? Currently using a series of synchronous Element.GetParameterByPrimaryKey method calls and it is currently the hotspot in my Automation script.

Thanks!

Vish Arivalagan [DevOps Advocate] Selected answer as best 23rd November 2023

1 Answer

  • Active
  • Voted
  • Newest
  • Oldest
5
Ive Herreman [SLC] [DevOps Enabler]13.59K Posted 23rd November 2023 3 Comments

Hi Vish,

You could use GetRow or GetColumn functions as shown in the example below.

Note, you’ll need to add the Skyline.DataMiner.Core.DataMinerSystem.Common and Skyline.DataMiner.Core.DataMinerSystem.Automation nugets to your solution to use these functions.

e.g.

using Skyline.DataMiner.Automation;

using Skyline.DataMiner.Core.DataMinerSystem.Common;
using Skyline.DataMiner.Core.DataMinerSystem.Automation;

/// <summary>
/// Represents a DataMiner Automation script.
/// </summary>
public class Script
{
/// <summary>
/// The script entry point.
/// </summary>
/// <param name=”engine”>Link with SLAutomation process.</param>
public void Run(IEngine engine)
{
IDms idms = engine.GetDms();

var myElement = idms.GetElement(“test element”);
var myTable = myElement.GetTable(96);

var myRow = myTable.GetRow(“winlogon:0”);

foreach (var cell in myRow)
{
engine.GenerateInformation(cell.ToString());
}
}
}

Vish Arivalagan [DevOps Advocate] Selected answer as best 23rd November 2023
Michiel Saelen [SLC] [DevOps Enabler] commented 23rd November 2023

FYI: myTable.GetRows() will retrieve all rows at once

Vish Arivalagan [DevOps Advocate] commented 23rd November 2023

Thanks Ive for the prompt response.

I should have specified that these parameters are across different tables – unsure whether that would change your suggestion. Also with your suggested solution how can I link each cell in myRow with its corresponding column name/id?

Ive Herreman [SLC] [DevOps Enabler] commented 23rd November 2023

Hi Vish,

If you only need one cell from every table, then I would stick with the getparameterbyprimarykey.
As soon as you need multiple values I would go for the GetRow or GetColumn methods.

The GetRow() call returns an object array, where the index in the array is the idx of the column as specified in the protocol. I’m not aware of any other way to extract the column name through iDms.

Please login to be able to comment or post an answer.

My DevOps rank

DevOps Members get more insights on their profile page.

My user earnings

0 Dojo credits

Spend your credits in our swag shop.

0 Reputation points

Boost your reputation, climb the leaderboard.

Promo banner DataMiner DevOps Professiona Program
DataMiner Integration Studio (DIS)
Empower Katas
Privacy Policy • Terms & Conditions • Contact

© 2025 Skyline Communications. All rights reserved.

DOJO Q&A widget

Can't find what you need?

? Explore the Q&A DataMiner Docs