So, I have created a sql query that allows me to view user, status, fname, lname querying I3_IC. (AgentActivityLog, and Individual table).
I can find nearly everything about a user, except for Status Notes (Notes about the reason for their specific status of forward, out of office, away, etc). At our organization we use the 'status notes' field for multiple purposes such as stating the best reasons to call that person. Such as what loan products they support.
I have searched
every single table, view, etc...and even the local registry of the machine and I cannot for the life of me find this data to get into a report.
Any thoughts or direction on where "Status Notes" is stored?