No, most of them don't! The only ones that I know of that require it are UCLA, SDSU and Berkeley. Most of the other Cal State schools do not require the GRE. From my research, the following do not:
CSULA
CSULB
CSUDH (Suggest if GPA is 3.0)
CSU Northrige (Only require if GPA is under 3.0)
SFSU
SJSU
CSU- East Bay
Sacramento State
I know there are several more schools in California, but those are just the ones I have looked into. Also, yes the macro track at SFSU is inactive. Really the only other macro tracks I have seen are SDSU, Berkeley and Dominguez Hills. But if you go on the CSWE website, you can search for schools by concentration area so I could be missing some.
Hope that helps!