I'm trying to automate some data extraction from Prognosis using the irpqlcli command line tool and I'm facing an issue with the extracted data.
From one of our Prognosis management server (it sees all the Prognosis servers we have in our infrastructure) I'm trying to extract the list of all the Thresholds we run on all our Prognosis servers.
This information is available in the PSTATUS record using the following Where Clause :
TYPE = "THRESH"
I built this display to visualize the data:
That display shows me 239 lines
When using the irpqlcli tool to extract the information, I run the following command line from the same Management server:
MYDRIVE:\Prognosis\Server\Configuration>..\irpqlcli "Select META.NODE, Customer() As Customer, ID from pstatus where type='thresh' node all ORDER BY Customer, META.NODE" -r
That command returns 105 lines, sometimes 138 lines, sometimes more and sometimes less.
How can I make sure the irpqlcli tool retrieves all the data before outputing the query result?