...
Go to https://home.cunyfirst.cuny.edu/oam/Portal_Login1.html to access CUNYfirst log-in page. Place Username and Password then click Log-in.
Click on 'Reporting Tools'.
Click on 'Query Viewer' link to access query.
Type a query name next to 'begin with' and hit 'search' button to fetch the query.
Click on 'Excel' to download a report from a separate window or 'Schedule' the same query for a Query Manger or Query Viewer.
...
Query Manager can view, schedule, create, delete, edit, organize queries by using reporting Instance . However, Query Viewer can be able to view and schedule queries. Note The public queries can be customize through CUNYfrist Reporting Instance. Note that: all data are one day older than CUNYfirst production system.
From menu choose select and click 'Reporting Tools' to access queriesQuery Manager/viewer.
Select Query Manger or Query Viewer based on user permission level.
Search to find an existing query. For example: CU_BAR or any public query then hit 'Search' button. User can be very specific to type their own query as the image shown below:
Select the appropriate query and click 'Edit' link to display properties for a query for a Query Manger. Click 'Excel' link to download a report for a Query Manger or Query Viewer.
Useful Production Queries
...