The 12-month investigation targeted the manufacture and supply of Ecstasy, or pills purporting to be the class-B drug, which were linked to serious aggression that led to people, including schoolgirls, being taken to hospitals in Auckland and Hamilton.
Court documents show Hodgetts was approached by an associate to do a police computer check on Shalendra Singh.
In a bugged phone conversation, Singh allegedly arranged with Hodgetts' associate to organise a police computer check to establish whether there was any police interest in him.
Singh, 32, allegedly agreed to pay $5000 for the confidential information. At first, Hodgetts was unable to obtain Singh's police file because his security clearance was not high enough.
He later checked the database using a computer logged on under a police colleague's identity.
He printed two pages of information which were given to his associate and faxed to Singh. Singh said the information was worth only $200, not $5000.
Hodgetts' lawyer, Todd Simmonds, said his client was sorry for what he had done.
"Mr Hodgetts is fundamentally a decent and generous young man who has made a serious blunder."
He said he was aware that he had breached the trust of the New Zealand police.
"He sincerely apologises to the police ... for any harm his actions may have caused to their good name and reputation in the community."
