Hi @kumaraj ,
1. As per my understanding why You’re Seeing Duplicates
* In CMDB, application-to-server mappings usually come from relationships in cmdb_rel_ci.
* If multiple relationship records exist between the same Application CI and the same Server CI (e.g., due to Discovery, Service Mapping, or manual creation), your report query will return duplicates.
* This can also happen if:
* The application is linked to both a cmdb_ci_server and its child cmdb_ci_computer
* The relationship is recorded multiple times with different relationship_type values.
2. Building the Report Without Duplicates using query builder.
Option A – Report Builder with Grouping
1. Table: Start from cmdb_rel_ci (Relationship table).
2. Conditions:
* Parent CI: Application classes only (cmdb_ci_appl, cmdb_ci_business_app, cmdb_ci_web_app, etc.).
* Child CI: Server class only (cmdb_ci_server or specific subclasses).
3. Add Related Fields:
* Parent → Name (Application)
* Child → Name (Server)
* Child → FQDN (from fqdn field in server CI)
4. In Report Settings:
* Use Aggregation or Group by: Application Name, Server Name, FQDN.
* This will collapse duplicate rows into a single unique combination.
5. Optional:
* Add a Count column if you want to see how many duplicate relationship records existed before grouping.
Option B – Use a Database View
If you want more control and potentially feed this into a dashboard or export:
1. Create a DB View:
* Join cmdb_rel_ci → cmdb_ci (parent) → cmdb_ci (child).
* Filter parent to Application classes, child to Server classes.
2. In the DB View definition, use DISTINCT on application_name, server_name, fqdn columns to remove duplicates at the SQL level.
3. Report on this DB view instead of the raw relationship table.
Option C – Clean Up CMDB Relationships
If duplicates are not expected:
* Use CMDB Health → Duplicate CI Relationships to identify and remove redundant relationships.
* Adjust Identification & Reconciliation (IRE) rules to avoid creating the same relationship multiple times from different data sources.
Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.
Thank You
AJ - TechTrek with AJ - ITOM Trainer
LinkedIn:- https://www.linkedin.com/in/ajay-kumar-66a91385/
YouTube:- https://www.youtube.com/@learnitomwithaj
Topmate:- https://topmate.io/aj_techtrekwithaj (Connect for 1-1 Session)
ServiceNow Community MVP 2025
