Wednesday, November 9, 2011

SQL to find Out all the active users in the system

select distinct SCUSER NT_ID, ABALPH, ULUGRP
  from sys7334.F0092 a, sys7334.f98owsec b, proddta.F0101 c
 where a.ULUSER = b.SCUSER
   and a.ULUSER = c.ABALKY
   and b.SCEUSER = '01'
   and c.ABAT1 = 'E'
   order by ULUGRP;

No comments:

Post a Comment