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

Issues retrieving historical information events using GetAlarmDetailsFromDbMessage

211 views10th July 2023automation scipt information events SLNet
8
Luis Gonzalez [SLC] [DevOps Advocate]352 7th July 2023 0 Comments

Hi Dojo Community,

The use case is that I’m trying to retrieve historical Information Events from any date ranges up to two years ago.
I’m trying to use the GetAlarmDetailsFromDbMessage from an automation script (GQI) and I’m having some issues, this is the snippet of code I’m using to create the call:

Both StartTime and EndTime values are Dates with a day difference no higher than 7 days always, the filter only contains a wildcard match on the parameter description.

The issues I’m having:

  • When I set StartTime and EndTime to Dates with a day difference higher than 8 days, the call will always be empty, even if there are information events.

i.e., StartTime: 06/20/2023 EndTime: 07/06/2023

  • When I set StartTime and EndTime to Dates from more than 9 days ago, even with day difference less than 7 days, the call will not retrieve any information event.

i.e., StartTime: 06/20/2023 EndTime: 06/23/2023

A colleague also tried a similar call and failed to retrieve any information events.

When I try to replicate the search through the Alarm Console, I can see the information events there.

Do you know if there are any limitations or if I’m not building the message correctly? If so, can you provide a snippet of code for these use cases?

Also, is this the most efficient way to retrieve this amount of information events? Since the amount of data retrieved can grow to hundreds of thousands of events.

Davy Degrande [SLC] [DevOps Advocate] Answered question 10th July 2023

1 Answer

  • Active
  • Voted
  • Newest
  • Oldest
1
Davy Degrande [SLC] [DevOps Advocate]646 Posted 10th July 2023 6 Comments

Luis,
The biggest clue will probably be here what do you pass along as alarm filter object. You should at least select an element or parameter filter object or you will encounter max payload issues. The client does this async and requests the data paged. I would like to now more about the use case before continuing because if you don't pass the right arguments this is a sure way to let the SLAutomation.exe process run out of memory.

Davy Degrande [SLC] [DevOps Advocate] Posted new comment 12th July 2023
Luis Gonzalez [SLC] [DevOps Advocate] commented 10th July 2023

Hi Davy, thanks for answering.

The filter I’m doing is to get only information events that contains “Based Details”, so I’m using a wildcard for that, that avoids getting all the system information events and only getting the information events generated by a specific parameter but still system-wide.
As I mention, this works for recent days but as soon as I try to retrieve from back in time it is not working

Davy Degrande [SLC] [DevOps Advocate] commented 10th July 2023

Luis, since it is a wildcard with no specific element passed along, my guess will be that the query either returns too much data or just times out. Because the wildcard logic is done in post-filtering so basically with 2 years range you’ll just get too many information events back.

Luis Gonzalez [SLC] [DevOps Advocate] commented 10th July 2023

I agree that two years range is probably too much data.
But after doing it with 8 days range, is not working as expected neither.

Davy Degrande [SLC] [DevOps Advocate] commented 11th July 2023

Luis these will probably be because of may payload issues or timeout issues because everything has to be done in post filtering. You can check the logging of SLNet, SLDBConnection and SLMessagebrokerSLMessageBroker_SLNet.txt to try and track the requests sent and their potential exceptions being thrown.

Luis Gonzalez [SLC] [DevOps Advocate] commented 11th July 2023

Davy, after some testing we reached the point where doing a Message per day is working, two days will not work. So most probably there’s too much data as you mentioned.
Also, you mentioned that filtering on element would help this? How can I know which filters will be done post-filtering and which will be help with the load?

Show 1 more comments
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