cancel
Showing results for 
Search instead for 
Did you mean: 

OUSR User table Deleted Users

former_member747168
Discoverer
0 Kudos

Hi,

I want to write a query that removes all users that were deleted.

I can't seem to find anything on the OUSR table or any USR tables. Can someone please advise?

Thanks,

Brian

Accepted Solutions (1)

Accepted Solutions (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Try with AUSR table.

Regards,

Nagarajan

Answers (2)

Answers (2)

prince_ebi
Explorer
0 Kudos

HI,

The below should work.

SELECT * FROM OUSR WHERE GROUPS<>99

Regards,

Prince

former_member747168
Discoverer
0 Kudos

Ah that is perfect Nagarajan. Didn't think to use the user history table as a check.