The actual queries executed against a data source are only recorded in Tableau's logs unless the Performance Recorder is actively running - and you can't run it 24 x 7 so that won't work.
Therefore, you're going to need a tool like Splunk which can index / parse / search / archive the logs
Thank you for your input, but Splunk is another BI tool.
Is there any Widget that can control or captures the SQL generate by users navigation/activity on dashboard ?
Or can we use any API's to code and capture that level of information ?
How this is supported in the Health care when tackling with PHI?
I would really appreciate any kind of input.
Sorry, no. There are no widgets or APIs that return SQL being executed.
Those who need this level of auditing lean on the logs, as I mentoned. You don't have to use Splunk to do this, there are lots of tools which can do the same thing.
Since you are using the term SQL...I am assuming you are connecting live to a database. If my assumption is wrong please ignore.
Why are you focusing on what SQL Tableau generates.,,...wouldn't you want an enterprise wide solution that encompasses any all users that connect to the data (Operational systems and other BI tools)? Maybe your organization is already doing this?
I would focus on monitoring the database logs (Oracle, SQL Server, etc...). Most databases have the ability to track at the granularity you are looking for. Plus you will have the added bonus if tracking Tableau Desktop usage as well (and any other BI tools you have).