Archives of the TeradataForum

Message Posted: Wed, 26 Oct 2005 @ 15:56:09 GMT

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

Here is a query that works as long as you are collecting resusage.

This is probably not the most efficient way of finding it.

There are several other views and macros with this information.

     select nodeid
     from dbc.ResGeneralInfoView
     where thedate = date
     group by 1 order by 1

Thanks,

Bob Diehl

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