Submit Query

Submit Query - an option that provides administrators with a great flexibility in accessing the database. It helps you to query the Central or Probe database for some specific data, submit a select query to get a customizable report and much more from the Central web client itself. From the Probe web client you can access only the respective Probe's database.

To access the Submit Query

1. Login to the Central Server.
2. Now enter the url "https://<hostname>/SubmitQuery.do" in the address bar. For example if you are running the Central service on https://abc.msp.com,
   
   
   then type the url https://abc.msp.com/SubmitQuery.do.
   
   
   Now the Submit Query window opens.
   
3. Select the Central or the Probe on which you want to execute the query.
   
   
4. Select the Database which you want to access.
   
   Support Center - Help desk database
   
5. Enter the Query.
6. Click Execute.

Now the required details will be displayed.

For example, if you need to view the devices of Windows type in a particular customer environment (or probe), then you can execute the below given select query to view the list of Windows devices.

Query: select managedobject.name,managedobject.type from managedobject,TopoObject where managedobject.name=topoobject.name and managedobject.name like '%.mspxp2%' and issnmp='true'  and type like 'Windows%'

The below given command helps you to get a customizable report with Display Name, IP address, Device Type, device availability, downtime in seconds and last failure time.

Click here to view the query.

You can export these reports by simply copy pasting it into an excel sheet.