Needs some help with new tpl or taxonomy extention.

We grab a list of servers to scan from a source database. This server data is updated daily. The source data includes the hostname that we resolve to an ip to and an internal unique id (INKA). Unfortunatelly the source db does not maintain ip.
I scan the servers. When the scan is complete i export the results into a staging db. The results are validated against the source db to ensure we have full scan coverage.

The problem we are facing is, the servers that have failed to be scanned cannot be validated with the source db because Tideway may only return an ip. hostnames and ip’s may change so the best way to validate is with the INKA.

The way it is done now is that i have an integration point on a consolidation instance. The process queries the source db and looks up the inka by hostname if tideway returns a “host created” flag. if the scan fails, no “host created” is triggered the INKA cannot be retrieved.

What i would like to do is load the the INKA with hostname/ip into tideway. When a server is processed by Tideway it will lookup the pre-loaded INKA by ip. This way we can pass back the unique identifyer to the source db and validate all servers we sent to tideway for scanning.

The source db is updated daily so creating tpl with static inka’s is out. I was thinking a taxonomy extention along with some tpl to do the lookup?

Any ideas are appreciated.