query for users and their sc ids