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
  • Blog
  • Questions
  • Learning
    • Courses
    • Certification
      • DataMiner Operator
      • DataMiner Administrator
      • DataMiner Automation
      • Scripts & Connectors Developer: HTTP Basics
      • Scripts & Connectors Developer: SNMP Basics
      • Visual Overview – Level 1
    • Video Library
    • Books We Like
    • Third-party Courses
    • DevOps Enablement Services
    • Quizzes
  • RESOURCES
  • 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)
  • Expert Hubs
    • DataMiner DevOps Professional Program
    • DataMiner
      • DataMiner Releases & Updates
      • System Architecture
      • Integration Studio
      • Visual Overview
      • Security
    • Technologies
      • CI/CD
      • Converged Interconnect Networks
      • DOCSIS 3.1 / DAA
      • Elasticsearch
      • Kubernetes
      • Telemetry / Flow Monitoring
      • PTP
      • SDN / ST2110 / NMOS
    • Business
      • Software Business models
      • Perpetual Use or Usage-based Services
  • Discover
    • Markets
      • Media production
      • Government & defense
      • Content distribution
      • Service providers
      • Partners
      • OSS/BSS
    • Solutions
    • Use Case Library
    • DataMiner Dashboards
    • DataMiner Downloads
    • DataMiner Modules
      • Core features
      • SRM features
    • DataMiner Apps
    • Professional Services
  • PARTNERS
    • All Partners
    • Technology Partners
    • Strategic Partner Program
    • Deal Registration
  • Pricing
  • More
    • Feature Suggestions
    • Online DataMiner Systems
    • Leaderboard
    • Swag Shop
    • Contact
      • General Inquiries
      • DataMiner DevOps Support
      • Commercial Requests
    • Global Feedback Survey
    • Verify a certificate
  • >> Go to dataminer.services

Get linked tables

Solved748 views30th August 2023
6
Fenta Alemahu [SLC] [DevOps Advocate]264 11th August 2023 0 Comments

Hi all,
In an automation script, I have information about a table (let's say Table1) which has a foreign key relation to other tables (let's say Table2, Table3, ...). Given Table1 PID, is there a way to get all the linked tables (Table2 PID, Table3 PID, ...)?

Marieke Goethals [SLC] [DevOps Enabler] Selected answer as best 30th August 2023

1 Answer

  • Active
  • Voted
  • Newest
  • Oldest
0
Jan Vanhove [SLC] [DevOps Advocate]869 Posted 25th August 2023 0 Comments

Hi Fenta, this is not possible using an out-of-the-box available call.

The only possibility I currently see is through SLNet calls.  Below is a snippet that can be used.

Note:

  • no safety check included yet in the code
  • be careful with SLNet calls as these might change over time
  • if you would execute this script frequently, please use some caching to limit the performance overhead.

GetProtocolInfoResponseMessage gpirm = engine.SendSLNetSingleResponseMessage(new GetProtocolMessage("ProtocolName", "ProtocolVersion")) as GetProtocolInfoResponseMessage;

ParameterInfo pi = gpirm.FindParameter(PID OF Table1);

foreach(TableColumnDefinition tcd in pi.TableColumnDefinitions) {
if (tcd.ForeignKeyDestTableID != -1)
{
engine.GenerateInformation($"{pi.Name} is linked to {gpirm.FindParameter(tcd.ForeignKeyDestTableID).Name}");
}
}

Marieke Goethals [SLC] [DevOps Enabler] Selected answer as best 30th August 2023
You are viewing 1 out of 1 answers, click here to view all answers.
Please login to be able to comment or post an answer.

My Dojo Points

0 Credits
0 Reputation

Question Tag Cloud

adl2099 (54) Alarm Console (53) alarms (70) alarm template (58) API (35) Automation (144) automation scipt (65) Automation script (95) backup (54) Cassandra (142) cloud (37) Connector (44) Correlation (42) Cube (114) Dashboard (134) Dashboards (136) database (64) DataMiner Cube (37) DIS (53) DMS (48) DOM (68) driver (48) DVE (43) Elastic (73) Elasticsearch (99) elements (49) Failover (90) GQI (51) HTTP (45) IDP (55) low code app (70) low code apps (43) MySQL (50) protocol (145) QAction (58) resources (35) security (71) SNMP (56) SRM (267) SRM resources (39) timeout (35) trending (66) upgrade (44) Visio (373) Visual Overview (290)
Privacy Policy • Terms & Conditions • Contact

© 2023 Skyline Communications. All rights reserved.

[ Placeholder content for popup link ] WordPress Download Manager - Best Download Management Plugin