Machinery diagnostic techniques for maintenance optimization