A former health adviser has been found guilty of accessing medical records of patients without a valid legal reason.