How to Check Statewise Active and Vacant User Status?

How to Check Statewise Active and Vacant User Status?