Operator Console Dashboards that use sql probe from a vm in Infrastructure Manager displaying Duplicates
Article ID: 281978
Updated On:
Products
Issue/Introduction
I have 3 dashboards that are not working correctly with the sql probe response. The main dashboard keeps ticket counts for Service Desk reps during a 12-hour period. This has worked up until Tuesday March 26, 2024. I cannot delete the duplicate in the operator console. I also tried to create a new dashboard but it is seeing duplicates also.
Environment
- DX UIM 20.4 GA
Cause
- Server changes in the UIM environment
Resolution
Dashboard stopped working, ‘count’ values are no longer being displayed for users that submit service desk tickets.This appears to be due to duplicates in QOS data that started appearing in March.
The QOS object was for sql_response metric-> QOS_SQL_VALUE.
We ran the query-> select * from S_QOS_DATA where target = ‘<QOS_target_name>’ which yielded 3 entries for whichever target we chose to examine.
In the SLM webapp in the Operator Console, we selected the 3 lines a.k.a. the 'hamburger menu icon' and clicked Database Status.
Then click Ok.
Then we filtered on the QOS entries using ‘Contains’ and the target value. We filterd on each target/username.
We then clicked on the menu item (3 dots/ellipsis) and chose “Get Statistics” to see the actual data stats and most importantly to see where it is being saved.
In a few seconds the results were displayed which showed us under which QOS object (QOS, source, target, origin), the data was being saved.
We then checked the boxes for 2 of the 3 QOS object entries then chose the 3 dots/ellipsis and selected “Merge Objects.”
We then carefully chose the correct direction to merge the QOS using the arrow (based on the QOS attributes and the most current date, choose the QOS object that has the most current data being collected and saved).
After the Merge operation which may take a few minutes to complete, save and republish the dashboard.
The counts were then updating in the dashboard
Feedback
