How to consolidate all the Operating System Objects with the same name and correct reference
Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.
Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles for non-Data Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Purpose
When using the default configuration described in SCCM data imported into Insight, the results are that multiple Operating System objects for each System discovered are created, which is indeed expected.
However, this article provides guidelines on how to:
- Consolidate all the Operating System Objects, having the same name and correctly reference them from respective System objects
Step-by-step guide
- Create a new Object Type to store the Resource IDs. Let's call it "Resource ID"
- Add one additional attribute: "Operating System" of the Type Object, referencing the "Operating System" object Type
- Add one additional attribute: "Operating System" of the Type Object, referencing the "Operating System" object Type
Create a new Object Type Mapping for the new "Resource ID" Object Type. Use the following configuration:
Object Type Mapping Configuration
- Selector: OPERATING_SYSTEM;
- Data Locator: Resource Id
- Insight Attribute: Name
- Data Locator: Name;
- Insight Attribute: Operating System
- IQL: Name = ${Name}
- Data Locator: Resource Id
- This will result in the creation of Resource ID Objects mapped to the respective "grouped" OS Object.
- Ensure that Selector: OPERATING_SYSTEM; ends with ';'
- Selector: OPERATING_SYSTEM;
- In the Operating Systems Object Type mapping:
- Set Name as the only identifier, and remove the map to the (old) Resource Id Text attribute
- Set Name as the only identifier, and remove the map to the (old) Resource Id Text attribute
- In the System Object Type mapping change the current IQL:
- From: "Resource Id" = ${Operating System}
- TO: object having inR(Name = ${Operating System})
- From: "Resource Id" = ${Operating System}
Notes
- The limitation here is that the System Reference is being established in the System Object Type map, based on the OS' Resource ID and not its Name
- It's recommended to test this out in a new Insight Test Schema for testing purpose
- When users synchronize the import, it will group OS objects by their name and will reference these from Systems based on the Resource Id Objects used here for Mapping the reference