SQL Query - Technician List

SQL Query - Technician List


Could someone please provide a simple SQL query to get a list of all active Technicians in SDP?

The methods I used to use have apparently become obsolete as table structures have changed with various SDP releases.  (For instance, at one point, queries relied on HelpDeskCrew table which no longer exists.)

Thank you.

SDP 11.1,  Build 11115