please note that Location ID should not be used for location of an object but for location of a measurement.
For this reason, it is normal that location is mark as "unknown".
Given the complexity of your situation, I would suggest you get in touch with a Consulting company to get professional dedicated support.
You can ask your BMC Sales Rep for contacts.
Thanks Renato for your help. We do have a support contract with BMC. They recommended that we post this question on this forum to see if we can get any traffic, because our contract might not support custom view. Do I required additional contract/cost for this Consulting company?
I agree with Renato on couple points: 1. probably better not to re-purpose location id as location of object, 2. sometimes the complexity of the interaction is best served with consulting services.
Having read your post, and having received some information from support about your case prior to you submitting this post, I believe that you will likely be adding additional conditions in your query outside the CUST_FILTER macro to make sure that content from the 'Unassigned' Site is include along with the selected Site. The additional conditions would pretty much hard code 'Unassigned' site as a selection criteria and allow you to add the patterns you need in order to select subset of the 'Locations' - even if you decide not to re-purpose the location field long term.
Michael D. West
Thanks Mike and Renato, I have reached out to my lead requesting support from consultant. I think this adjustment is more involved than I original anticipated. I really appreciate the input and recommendation.