If your database is on SQL Server then you can use the SQL Server Profiler tool to run a database trace to see all the SQL executed against the Landesk database.
You can also activate the"Database access" diagnostic from the Configuration Center for the Framework (if you run the query in the console) or for WebAccess (if you run it in WebDesk/Self Service). See this article which explains it in detail:
Don't forget to deactivate the diagnostics afterwards as they logs size can grow quite quickly.
Thanks a lot both, i am trying this now. Logging bit was helpful i have managed to track the sql query without using profile