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
    • E-learning Courses
    • 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
    • Tutorials
    • 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
    • DataMiner Insights
      • Security
      • Integration Studio
      • System Architecture
      • DataMiner Releases & Updates
      • DataMiner Apps
    • 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
  • Downloads
  • More
    • Feature Suggestions
    • Climb the leaderboard!
    • Swag Shop
    • Contact
      • General Inquiries
      • DataMiner DevOps Support
      • Commercial Requests
    • Global Feedback Survey
  • PARTNERS
    • All Partners
    • Technology Partners
    • Strategic Partner Program
    • Deal Registration
  • >> Go to dataminer.services

Duplicates in GQI query

Solved766 views13th March 2024duplicate GQI GQI Filter
2
Dave Keller [DevOps Enabler]1.60K 24th October 2023 2 Comments

Hi Dojo,

Is there a simple way to remove duplicate entries from a GQI query?  My query is retrieving multiple alarm messages from different elements, all talking to the same end point, and I want to have only 1 instance of each entry.

Thanks

Dave Keller [DevOps Enabler] Selected answer as best 13th March 2024
Sebastiaan Dumoulein [SLC] [DevOps Enabler] commented 25th October 2023

Hi Dave, are you getting these duplicate alarm messages from an out-of-the box data source? If so, can you share your query?

Dave Keller [DevOps Enabler] commented 25th October 2023

Hi Sebastiaan,
We have 4 elements, hosted in 4 separate availability zones, all receiving the same alarm string from a single end point Playout Automation interface.
Using a GQI
> Get parameters for elements where
> Protocol = Playout Automation Interface
> Version = Production
> Selected parameter =Unacknowledged Alarms

This produces 4 versions of every alarm string message from the Playout Automation system, but we have resilience in case any of the availability zones/elements is not working correctly. Removing duplicates in the table would achieve what we are after.

1 Answer

  • Active
  • Voted
  • Newest
  • Oldest
2
Miguel Obregon [SLC] [DevOps Catalyst]18.56K Posted 24th October 2023 2 Comments

Hi Dave,

I believe this use case can be tackled through aggregation/group by operations . For example, you can aggregate by alarm message type and group by element name to have different alarm types per element name.

Dave Keller [DevOps Enabler] Selected answer as best 13th March 2024
Dave Keller [DevOps Enabler] commented 24th October 2023

Thanks for the suggestion Miguel.

For Aggregate I only see Count and Distinct Count, so I guess I’m not running a version that supports GroupBy.
The documentation suggests that this is supported from 10.3.3 and I’m running 10.3.4, but I don’t know if it is Soft Launch from 10.3.3?

Sebastiaan Dumoulein [SLC] [DevOps Enabler] commented 26th January 2024

Hi Dave, this should be possible in your version. It only becomes available after doing an initial aggregation. So you could for instance do a count first and then add another operator to do the group by.

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

Recent questions

Alarm Dashboard PDF/CSV Export 0 Answers | 0 Votes
Is the Microsoft SharePoint Connector Still Usable 0 Answers | 0 Votes
Is the Microsoft SharePoint Connector Still Usable 0 Answers | 0 Votes

Question Tags

adl2099 (115) alarm (62) Alarm Console (82) alarms (100) alarm template (83) Automation (223) automation scipt (111) Automation script (167) backup (71) Cassandra (180) Connector (108) Correlation (68) Cube (150) Dashboard (194) Dashboards (188) database (83) DataMiner Cube (57) DIS (81) DMS (71) DOM (139) driver (65) DVE (55) Elastic (83) Elasticsearch (115) elements (80) Failover (104) GQI (159) HTTP (76) IDP (74) LCA (151) low code app (166) low code apps (93) lowcodeapps (75) MySQL (53) protocol (203) QAction (83) security (88) services (51) SNMP (86) SRM (337) table (54) trending (87) upgrade (62) Visio (539) Visual Overview (345)
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

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