Disabled AD Users in SCCM

Below Query will provide you with the list of diabled user account.

SELECT TOP 100000 * from v_R_User SYS

WHERE ((POWER(2,1)) & SYS.User_Account_Control0) <> 0

ORDER BY SYS.User_Account_Control0