One more help I need.
I need to know the list of users who ran a set of stored procedures between a certain timeframe like between 12 to 3 am/pm.
i tried with SELECT * FROM TABLE (MonitorSession(-1,'*',0)) AS dt; but didn't get the expected output.
MonitorSession returns info about the currently logged on sessions (QueryMonitor in Viewpoint).
You need to query dbc.QryLogV for historical data.