We need to check the workbook related details on server like Run time, SQL generated and the user executing it.
I tried the log present in the Dataengine folder (C:\ProgramData\Tableau\Tableau Server\data\tabsvc\logs\dataengine) on server but I couldn’t find these details.
I also tried to change the server log level to Debug and Trace but I couldn’t see any difference. I need to see the workbook executed and the SQL for it.
For desktop we can see the SQL in log file present in “My Tableau Repository” but how can we check on server?
Any help is appreciated.
You may need to ask Tableau Support to help, but you should also consider looking at database tracing. You didn't mention which database you were using. There are several tools which can do this depending on database.
Why are you looking for this information? If it's performance related then consider using performance tracing (see: http://onlinehelp.tableausoftware.com/current/server/en-us/help.htm#perf_record_create_server.htm?Highlight=performance)