For example, I want to see if a particular user(s) in my Organisation has got any Open Cases.

To do this, I have searched by Owner eg ‘Aaron Cope’ and set the status to ‘Open’.