Data Adapter SQL Query to view data submitted through Excel
I am here with one of my typical requests to see if anyone has (SQL query) code I can borrow 🙂
We had an issue with two users who discovered how to submit data through Excel and circumvent the workflow forms. As a result they are inputting data to intersections where we do not want forecast data.
I would like to have a dashboard I can run where I can select a specific scenario and it will return a list of intersections that were modified through an Excel submit. Or just a list of users and then I can run the ONC application report User Data Entry Detail to get the details of the intersections.
I know the data lives in a table somewhere but I am not sure the table name and the fields to filter on and return.
In the ONC User Data Entry Detail report I am able to select a scenario, WF time and user name and can see data they changed via forms and data that was changed via Excel. But, there is no option to see all Excel edits for all users and I am trying to catch the rule breakers 🤫.
Any help with a SQL query would be greatly appreciated so I can create a data adapter, and display it via a grid view in a dashboard.
Thank you,
Denise