The port should go after ":" and not ",". Maybe this is why is ot picking it up and will still default to to 1433.
Original Message:
Sent: Apr 18, 2024 01:30 PM
From: Miller Echagarreta
Subject: Ingest data and take it to the UIM DB to create a dashboard. Is possible ?
Hi Marco, how are you?
Do yo know how can i change the port for the connections. For this connection I must go to port 5150 and it is looking for 1433
I configured this JDB URL ---> jdbc:sqlserver://172.39.39.33,5150;DatabaseName=master
Original Message:
Sent: Apr 12, 2024 04:52 AM
From: Marco Ippati
Subject: Ingest data and take it to the UIM DB to create a dashboard. Is possible ?
Hi Miller, with the sqlserver, the custom query being used MUST yield numeric values so thresholds can be configured for those values. Strings will not work for thresholds/threshold breaches and alarms. That's why only "connections" is showing as possible custom QoS.
Have you considered using the 'SQL Table' Widget in the Dashboard Designer? you can use the internal datasource (nis) for testing or connect to an external resource and run a query against it and that serves as datasource for populating the SQL Table with Data.
https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/unified-infrastructure-management/23-4/configuring-and-viewing-monitoring-data/the-dashboard-portlet.html#concept.dita_b16cf5bbacc03a55bfddbea026a3832c7639e2c9_AddaWidget
------------------------------
Marco Ippati
Technical Support Engineer 4
Broadcom Software | UIM Certified Expert
Barcelona, Spain | marco.ippati@broadcom.com
Original Message:
Sent: Apr 11, 2024 04:56 PM
From: Miller Echagarreta
Subject: Ingest data and take it to the UIM DB to create a dashboard. Is possible ?
Hi Everyone
I need to capture some data for showing on a dashboard. The data come from a db mssql, so i am thinking ingest the data with sqlserver probe because UIM It does not allow you to directly consult another database, or yes....?
So i set the query in sqlserver probe and capture the variables, but for some reason it does not recognize the "character" fields to create the QOS, only "Connections" that the field is numeric.
These are the data that I need to ingest into the UIM DB and later use them to create a dashboard exactly like this one
These are the varibles...
The creation of QOS only for Connections
Why does this happen? Could it be that it is not possible to ingest this type "character" data, only numeric? The idea is to create a QOS for "login", "program_name".
Any ideas or suggestions?