Sensor for measuring frequency

This thread twists and turns! First it was how to measure frequency of vibration but the sensor could not be attached to the pipe. Later it turns out to be allowed to attach things to the pipe. Now the question is how to induce the vibrations in the first place, but a motor can't be used. Oh, and now it's copper instead of steel. What next?