Hi everyone,
There is custom table which needs to get the database instance relationship with server and server relationships with business service records.
Getting database instance relationship with server is completed, as database instance has only one server but the problem is the server has relationship with multiple business services, now what we need to do is from custom table we have to fetch sever and send it to relationship table to fetch the number of business services it is connected to and insert those records into custom table.
But difficulty is lets assume in custom table we have db1, db2, db3 records with the same server-ivm1234 [please check picture1] and sever has 3 business services so now custom table should have 3 records with same instance name “db1” [this 3 we got from business service count] but each of these 3 record with instance name “db1” should have unique business service, similarly goes for bd2 and db3[please check picture2 that is the expected outcome]
PICTURE 1-
PICTURE 2-
Please let me know if there is a way
@BharathChintala
@Brad Bowman
Thankyou.
