1 of 1 people found this helpful
thanks for all the detail. I’m not sure what your rules in reconn look like but here’s what I think might be occurring:
the gold dataset is updated from either the ADDM or sandbox datasets and that is reflected in the gold dataset by the reconid. So when you are setting the flag it is matching up with the reconid; which is the last one that did the update. So my thought is that if you want a 3-way reconciliation then you need to use something shared on the record between all three datasets; maybe matching serial number and manufacturer, or some combo that would join them altogether.
again not sure what your rules are but that’s just a guess to get us started towards a solution.
thank you for your suggestion. I did open an issue to get BMC's take on this and the response is below.
I checked with the SMEs and you'll need to utilize the delete activity in your sandbox recon job.
I realize below you said you're not using it, but that's why the problem is there. Having the ADDM or one of the other
datasets modify the sandbox will create different, bigger, problems, in other areas of Asset Management and the sandbox.
The only solution we have is that you'll need the delete activity for the sandbox job.
We were not utilizing the delete because we were trying to retain the submitter value on the sandbox record for auditing. When it runs thru the recon it changes from the $USER$ to "Remedy Application Service" but I will need to open that as another query with them.
Yeah they are looking at the purge job and you are just looking at mark for delete but keeping the record.
there’s a bigger picture here that concerns me in that if a user is making CI changes where’s the evidence of authorization (an approved change request or service request or even Work Order). I think support was looking at the big picture and assuming you had this associated to the CI already and they were giving you a best practice answer.
There are options to resolve this and get the same outcome, if you’d like to send me a private message with your contact, I’m happy to guide you.