Facing difficulties for data mapping

vatsal.shah · 2024-07-19T07:32:32.762Z

Hello, I have two database tables namely IPv6_health and system_mapping. In IPv6_health table i have the columns: system_ID, assigned_at, assigned_time_min, status, updated_at. In system_mapping I have the columns system_ID and device_name.
So basically there are many systems which we have, each with their own unique address and a human readable name so that we can identify that system on the hardware side (ie. server room). So lets say if an error occurs in system_id D3:11:43:37 then a person would have to find that specific system in the server room so that he can fix it. So in the server room all systems will be labeled such as S1, S2 and so on.
What i want to do is I want to join both these both tables and display the device_name associated with each system_ID along with its other data which is assigned_at, assigned_time_min, status, updated_at. These data is varying in length and I am using API to fetch all these data. I am using a table element to display this data but I am not able to do it. Can you guys please help!
Thanks.

system · 2024-09-27T07:32:58.070Z

This topic was automatically closed after 70 days. New replies are no longer allowed.