AnsweredAssumed Answered

How to fetch All analyst with their respectives groups from sql

Question asked by La-Qa on Oct 18, 2016
Latest reply on Oct 20, 2016 by La-Qa

Hello SD Team

i have 2 request for the sql queries

 

1. i need to pull All the Analysts with their respective groups/departments. Please provide query to fulfill my need.

 

2.i need to know the last time each of the Analysts login into servicedesk. i know the records are maintain in session_log table. Please provide query for this.

 

Thanks

Outcomes