Auto-populating host field during discovery

[blanm]

Hello!

I am fairly new to service now and I have been tasked with all things discovery and cmdb. I will try my best to explain this, as I have limited knowledge still.

Whenever discovery completes for network related ci's, the host field does not auto-populate, even when the pattern itself makes the connection from the ci to the server table. I will be using a specific example to explain this, but this does happen on all tables that has a host field. 

When discovering a MS SQL instance, it will set the instance name correctly - MSSQLSERVER@hostexample

The host field on this table however (which is set as a reference field to the server table), always shows "empty", meaning I have to double click the field and search for the host to manually add it. 

This field references our server table to find names. We would like the value of this field to be hostexample, so that we can click it and have it take us to the record of hostexample.

My question is how can I make this field populate with the host name automatically, since its already being discovered and added as a part of the instance's name?

Again though, this happens on other tables, the host field is always empty, even when a relationship is made to the IP/host and I can see it in the dependency view. 

I have looked tirelessly through the community articles, as well as all servicenow discovery, ci class manager, script action, business rules and many other documentation pages.

I feel like this would be a script action, but I am not quite there yet with my understanding of how to write this, I only know basic java and I am still learning all of the different functions and syntax. 

I tried to make a basic script, but I am not even sure where I could try to test this without affecting other data in our dev instance. We do have dev people as we are a large organization, but they are all very busy so I am a little on my own here. Any assistance would be greatly appreciated!