How to access archived service requests
I am new to Cireson Portal and trying to learn as much as I can on the fly. Had a user asking why they could no longer see some tickets. I determined we are configured to purge closed tickets after 365 days. According to the setting "After a work item has been removed from the database, it is available only for offline reporting from the Service Manager data warehouse". Now I should add I am certainly no SQL expert either but can mange to get around. I am also using PowerBI. The problem is I can't figure out where this data is stored and how to retrieve. Any pointers would be greatly appreciated.