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'
Then clcik on Execute button, it shows the Prognosis configuration details in Result:
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
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
Enter multiple parameters if needed.
To re-run the query in the History box, select it and then Load and Execute.