Fun fact: the 5.7mm round the P90 uses was not being produced as a blank. So the armorers bought TONS of live 5.7mm and made those into blanks.
This actually caused a supply bottleneck for none other than the US Secret Service, who were also using P90s at the time. They actually had to ask, or buy, not sure which, several thousand rounds from the show armorers for training until ammo production could ramp up stateside IIRC.
I read it they had trouble getting ammunition for the P90 because of the Iraq war so they switched to different weapons towards the end of the show. I'm not totally sure though I'm too lazy to look it up.