While there were several Harry Potter games released for various platforms, "Harry Potter and the Chamber of Secrets" was primarily released for:
* PC
* PlayStation 2
* GameCube
* Xbox (original Xbox, not the later Xbox 360 or Xbox One)
It's likely that the game is no longer available for purchase due to its age, but you might be able to find a used copy for the original Xbox.