Administer PS Query

That was one of the requirements from the client, to monitor the frequent query usage by the faculty and the students to improve the query to provide better results. I was reminded about the Google Analytics strategy when I heard this requirement.

PeopleSoft provided this flexibility which aids the System administrators to:

Monitor query performance
Monitor query Usage
Monitor average runtime, number of times run, and the dates last run
Cancel queries that are currently running in Query Manager
Enable and disable queries and logging.

Navigations:

PeopleTools > Utilities > Administration > Query Administration
PeopleTools > Utilities > Administration > Query Administration > Executing
PeopleTools > Utilities > Administration > Query Administration > Settings

Cool feature