Nov-09-2023, 09:29 PM
The support system file doesn't have the information you need to know if a down register has an open ticket. The support system file should have a register column. As is, you have to parse the description, which appears to be free-form, in hope that it contains the register number.
Are register numbers unique, or can two stores have the same register number? If register numbers are unique there is no reason to look at the store. If register numbers are unique, I would open up the support system file and get a list of all registers that have open tickets. Next I would open up the ping file and filter out all registers that are online. Using the register numbers pulled from the support system file I would filter out all registers mentioned in the support file. That leaves you with a ping file of registers that are offline and not mentioned in the support system file.
Are register numbers unique, or can two stores have the same register number? If register numbers are unique there is no reason to look at the store. If register numbers are unique, I would open up the support system file and get a list of all registers that have open tickets. Next I would open up the ping file and filter out all registers that are online. Using the register numbers pulled from the support system file I would filter out all registers mentioned in the support file. That leaves you with a ping file of registers that are offline and not mentioned in the support system file.