Need help to make Automation using two (or more) Object Schemas

[Koczka Bence]

Even a general idea, how these kinds of tasks are usually handled (or an example) would be welcome.

I have a Infrastructure object schema, which has an IP addressess object type.
This object type has an IP attribute containing the address of a virtual server. 

I have another object schema (let's call it Blacklisted IPs) which has an IP object type containing an IP attribute. This also has an IP Reference attribute, which is suppossed to be a reference to an IP addresses object in the Infrastructure object schema.

My task is to automate one of the object schemas, so it can recognize if a Blacklisted IP and an IP addresses has the same IP. Then it should set the value of the IP reference attribute to point to the corresponding virtual server's IP in Infrastructure.

If you have any ideas so far, where and how to use IQL (or if I should get into Groovy scripting) to achieve this, would be greatly appreciated, in the following I want to picture the whole picture: 

There is a third object schema called CRM which has Customers in it. These customers have virtual servers, referencing the ones in Infrastructure.

My ultimate goal is to make an automation which sends an email to these Customers whenever an IP of their virtual server appears in the Blacklist IP object schema.

As mentioned before, any general idea would be mostly welcome, regarding the direction of solving this issue.

[David Sumlin]

So, how about simplifying things and having a single IP objectType, (I would assume the Name/label attribute would be the IP address) and then have an attribute that identifies if it's blacklisted?

If instead you need to have a distinct Blacklisted objectType (which might have some additional information (such as source, dates, people, etc), then just have have an object reference attribute to the IP objectType.

For your Infrastructure schema, if you have a Virtual Servers object, then it could also have an object reference attribute to the IP objectType.

This allows you to find IP objects which are blacklisted AND in a customers Virtual Server. 

Would that work?

[Koczka Bence]

Thanks you for the answer!

"If instead you need to have a distinct Blacklisted objectType (which might have some additional information (such as source, dates, people, etc), then just have have an object reference attribute to the IP objectType."

So this would work. But I have hundreds or thousands of objects, and I don't want to manually pair up the objects with the corresponding ones. How could I automate this task? Both objects have an attribute (IP) as a key to identify the pairs, there has to be a way, I just have no idea how.