very Urjent !! Eliminate duplicate records in the report.

[Bhavana Reddy]

Hello Guys,

I am stuck in a problem where i need to report on a table ( consider 2 reference fields below)

1) Contract 

2)configuration item

we have so many records with duplicate values and i need to remove this duplicate values and show only one record in the report

Note : The main problem here one contract might also be linked to multiple configuration item ( see below screen shot configuration item is different )

SO when i create the report i need to group by both "Configuration item and Contract " so that all the duplicate entries will be filtered 

Note : The above table i am reporting on is  huge ( more than 2 lakh records and i need to consider performance also)

Please suggest me guys how i can eliminate duplicates

@Ankur Bawiskar @Aman Kumar @Mohith Devatte @shloke04 

[Uncle Rob]

Express to me what records you want (and what table they're in), not what records you don't want.

Will be easier for us to figure it out.

[Bhavana Reddy]

The table is (Contract_rel_ci) , we have 2 reference fields 

1) Contract

2) Configuration Item

1) First issue is we have duplicate records in that table (refer screenshot 1 in the part where question is posted )

2) If i do group by Contracts then i can't eliminate duplicate records ( since the same contract can be linked to multiple Configuration item) 

here i need a report removing all the duplicates 

[Ankur Bawiskar]

Hi,

So you should identify first why there are duplicates in that table?

Is that fine or it's an issue?

As per images both the highlighted records are unique as same CI is tied to multiple contracts.

Regards
Ankur

[Bhavana Reddy]

This data is handled by CMDB team and for now we need to find a workaround to overcome duplicates

in the 2nd screenshot where i posted question, if u observe clearly its different CI's ( BKHL-RFS_1  , BKHL-RFS_2 )

please refer my above reply