Archives of the TeradataForum

Message Posted: Tue, 03 Feb 2004 @ 08:42:17 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

pmaid wasn't on the resusage view (on our system at least) but

Select count(distinct(nodeid))
from dbc.resusagespma;

also works

Cheers

Andy

	<Prev	Next>		<<First	<Prev	Next>	Last>>