Microspectrometric investigation of active substrates for surface enhanced Raman scattering