SQL script to display basic call data includind call creation date, time and current assignee

Version 2
    Question

    Customer would like an SQL script wich will return basic call data including the call creation date and time.

    Answer

     

    The attached script shows basic call data including the current assigned group and analyst and the call creation data and time, converted from the Helpdesk date and time.

     

    Environment

    Helpdesk Classic All