Hi All
I sat down and learned some SQL and got this figured out, the SQL query is below in case it is useful to anyone else.
You will have to look at the tips_tag_definitions table to find the id of your attribute
SELECT t1.tag_value::int + 1 as attrubute_plus_1 FROM tips_tag_values t1 JOIN tips_endpoint_tag_mappings t2 ON (t1.id = t2.tag_value_id) JOIN tips_endpoints t3 ON (t2.instance_id = t3.id) WHERE t1.tag_id = <id of your attribute> AND t3.mac_address = LOWER('%{Connection:Client-Mac-Address-NoDelim}');
Thanks
Dave