How do I link Physical servers and Rack locations?

[kerwin63]

I am looking for a way (Best practices) to relate all the physical servers and devices to the Rack table. I have the racks defined in cmdb_ci_rack and wanted to import new and existing servers, chassis and switches, from cmdb_ci but I don't want to modify any tables. Is there a way? Ultimately, we need to be able to see a RACK and all it's components and, also, search a CI and be able to determine its Rack location.  

[sachin_namjoshi]

You need to define suggested relationships between server and rack class so that you can relate CI between these classes.

Please check below for more details

https://docs.servicenow.com/bundle/london-servicenow-platform/page/product/configuration-management/reference/r_SuggestedRelationshipModel.html

Regards,

Sachin

[kerwin63]

Thanks. I need to go a bit more detailed - I have the specific RU etc, on the CI and the Rack name.

[kerwin63]

Thank you. I will give that a shot. I am avoiding using reference fields in tables. But I may need to change since each server has a specific Rack unit. 

[Paul Coste2]

If your Asset and your CI have a Location defined down to the specific grid location that designates the location of the rack in your data center, you can then create business rules that set the Rack reference (or relationship) on the CI based on whether there is a Rack found at that location. 

Example:

1. Define a Location of "Grid-YZ05" with a parent Location of "Room123" (etc.)
2. The location of my Windows Server CI "MyWinServer" is "Room123/Grid-YZ05"
3. Is there a Rack CI with a location: "Room123/Grid-YZ05"?  Yes.  It's called "ServerFarmRack_03".
4. Associate the "MyWinServer" Server CI with the "ServerFarmRack_03" Rack CI.

This is a similar approach to setting the Stockroom on an Asset. Set the Location of an Asset to "Room1001".  Is there a Stockroom at this Location?  If so, set the Stockroom of the Asset to that Stockroom.