SQL examples for ODBC

The following SQL examples demonstrate common use cases for this connector. Select a scenario below to view the query syntax and parameters required to interact with ManageEngine ServiceDesk Plus (Zoho).

• Delete request
• Read asset by ID
• Read assets
• Read change by ID
• Read changes
• Read contract by ID
• Read contracts
• Read project by ID
• Read projects
• Read purchase order by ID
• Read purchase orders
• Read request by ID
• Read request note by ID
• Read request notes
• Read request task by ID
• Read request task comment by ID
• Read request task comments
• Read request task worklog by ID
• Read request task worklogs
• Read request tasks
• Read request worklog by ID
• Read request worklogs
• Read requests
• Read task by ID
• Read tasks