How to set unique key for a ci in discovery?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-03-2019 02:06 AM
Hi,
I configured mid server and discovery.
While I am doing quick discovery, duplicate ci's going to be added.
Please let me know how to prevent duplicate ci's adding to cmdb table.
Thanks in advance.
Regards,
Venu Suri
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-03-2019 02:30 AM
Hi Venu,
This duplicate CI insertion is an issue and hence,servicenow has provided with a new functionality 'CMDB identification rules'.
Actually there is no way to uniquely identify the CIs,cause some have name to be unique,some got serial number and some have ip addresses.But,that depends on cmdb classes.
Hence,you can define in these rules that if for 'router' class,serial number would be unique and next rule for 'computer' class i.e. name is unique.
Please find the link for CMDB identification rules:
Regards,
Munender
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-03-2019 05:24 AM
So more then likely your credentials aren't setup properly and you aren't getting the proper information back to identify on. if you check the identification rule for cmdb_ci_hardware you will see all the things it is looking at. I would focus in on serial number especially if you are discovering unix/linux as dmidecode SUDO permissions are needed to discover that. Either way your next step is to compare what is happening in identification and figure out why it's creating duplicates. You can turn on debug for identification and it should tell you what rules are matching or being skipped.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-03-2019 02:25 PM
As Munender Singh and robertgreen mentioned the Identification rules are used by Discovery to determine whether to update an existing CI or create a new CI. To access the Identifiers enter "Identifiers" in the Navigation pane. In London there are over 400 Identifiers. The Hardware Rule Identifier is shown.
For some of the more common discovered CIs, the Hardware Rule Identifier rule is used for Identification. The rule applies to the Hardware [cmdb_ci_hardware] table as well as child tables off the Hardware class. For example, Windows Server [cmdb_ci_win_server] and UNIX Server [cmdb_ci_unix_server] tables are child tables off the Hardware table and the Hardware Identifier rule applies to these 2 tables.
On the Hardware Rule Identifier form, the Identifier Entries tab contains 4 active records. Each active record contains different Criterion attributes. Criterion attributes are used for coalescing/identification and are applied in Priority order as shown.
For example, when discovering a Windows Host the Hardware Rule Identifier is used to determine if the CI needs to be updated or create a new CI. During identification, the 1st Identifier Entry (Priority 100) attempts to match on the serial_number and serial_number_type Criterion attribute. If a match isn't found in the CMDB, then the next Identifier Entry is attempted. The 2nd Identifier Entry (Priority 200) attempts to match on the serial_number Criterion attribute. If a match isn’t found in the CMDB, then the next Identifier Entry is attempted. The 3rd Identifier Entry (Priority 300) attempts to match on the name Criterion attribute in the CMDB. If a match on name is found, no other Identifier Entries are attempted and discovery updates the CI in the CMDB.
To troubleshoot Identification issues during discovery, the Discovery Log will contain more information. As an example, the following discovery log entry found a match on the 1st Identifier Entry.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-04-2019 01:41 AM
Hi Chuck,
I configured identification rules choosing name, serial number as coalesce and re run the discovery.
After running the discovery, I am not getting any ci added to the cmdb table.
If I made the ci identification rule inactive, again re run the discovery.
I am getting duplicate ci value inserting into the cmdb_ci_computer table.
Please help me to resolve the issue.
Thanks in advance.
Regards,
Venu Suri