cancel
Showing results for 
Search instead for 
Did you mean: 

How to use PQL Explorer to test and validate PQL queries

Highlighted

How to use PQL Explorer to test and validate PQL queries

PQLExplorer is a Prognosis tool to execute and validate PQL queries. Use this tool to test the query

statement and the result.

 

After download and install it, launch the PQL Explorer UI, and enter the following information:
Server:  the Prognosis web application server IP address

Port: 6767, the default PQL query port

User name: Prognosis user name

Password: Prognosis user password


1: List Prognosis configuration

Enter the following PQL statement in the PQL Query box, as below.

execute list_conf 'Prognosis'

a1.PNG

Then clcik on Execute button, it shows the Prognosis configuration details in Result:
a2.PNG

2. List all configured users for webUI access and their role
Enter the following PQL statement in the PQL Query box, and Execute:
select * from sys.security.users

a3.PNG


Note, the History keeps the previous successful queries.

 

3. Using Parameters - list a particular Process by its name param.
Enter the following query in the PQL Queries box, and then type in the Parameters Name and Value (ProcessName and epmd in the below example), click Execute:

select * from ntprocess where ProcessName = @ProcessName

a4.PNG


Enter multiple parameters if needed. 

To re-run the query in the History box, select it and then Load and Execute.