List of all technicians according to their status: online and offline

List of all technicians according to their status: online and offline

Please give me a SQL Query:
1.List of all technicians according to their status: online and offline.
And  a Query:
2. Get the name of the current requester who has entered the service desk.
like var x=$CS.getValue("REQUESTER");


                New to ADSelfService Plus?