How can I set up an identifier rule that matches on Serial Number only if the Mac address is empty other wise matches on SN and Mac

[codycotulla]

I am setting up identifiers and I want to set up the following rules:

• Match on the Serial Number / MAC address combination.
• Match on the Serial Number, but only if the incoming data doesn't have a MAC address or if the MAC address field in the target record is blank.
• Match on the MAC address field, but only if the incoming data doesn't have a Serial Number or if the Serial number field in the target record is blank.

Essentially, I have cases where I have duplicate serial numbers, but the combination of serial number and mac address is unique. So, I have created a Serial Number / MAC address rule, but sometimes, the data I'm getting doesn't contain a serial number or it doesn't contain a MAC address. In those case it tries to match on the serial number only or mac address only rule, and finds a match, but that match can be for the wrong record because of the duplicate serial numbers.

Any ideas on how to do what I'm asking to do will be very helpful.

Let me know if you have any questions.

Thanks,

Cody

[christianmalone]

Best practice is Identification Reconciliation Engine but that allows serial and/or IP & MAC. If you can also provide IP then run the /query in what ever order you want feeding it identifiers until you get a match you are confident in then pass that payload to the engine. Make sense?

[Ashutosh Munot1]

Hi,

You can make use of optional Condition.

So you can add a condition for your second Rule as MAC address is Empty. Also if you don't click Allow Null Attribute then what will happen is, first if you provide a condition in optional condition then this rule will check if the MAC address is empty on target record. 

Second, If Allow Null Attribute is false then Null values coming from integration wont be consider.

Thanks,
Ashutosh

[Anders Pr_stega]

Hi Cody

Your post is more than 2 years old which triggers a new super-service that reveals suggested answers.

Just kidding..

Try looking at this post and see if it helps (it helped me):

Sincirely,

Anders