---
sourceDocument: Australia API Reference
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/api-reference

 Release :

    - australia

ft:locale :

    - en-US

ft:publication_title :

    - Australia API Reference

ft:clusterId :

    - crapiref

bundleId :

    - crapiref

workflow :

    - Creator


---

# Test a query

# Test a query {#ariaid-title1}

Release version: Australia  
Updated March 12, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read  
To verify that the user has the appropriate permissions to send requests to the
instance using ODBC, run a query using Interactive SQL.

## About this task

For testing, use a query that returns exactly one record, such as a query using the Number value of a record.

## Procedure

1. In the base system instance, navigate to IncidentAll.
2. Record the Number of an incident record.
3. On the computer where the ODBC driver is installed, navigate to StartProgramsServiceNow ODBCInteractive SQL.
4. Enter <kbd class="ph userinput">connect "odbc.user"*"password"@ServiceNow</kbd> and press Enter.
5. Enter the following text, substituting the incident number you recorded.  
   <kbd class="ph userinput">select short_description from incident where number=’&lt;incident number&gt;';</kbd>
6. Press Enter.

## Result

The instance should respond with the short description of the incident record.

*[\>]: and then