![\"Glossary](\"\/sis-training\/files\/2025\/06\/Glossary-icon.png\"){kind=icon}
<\/a>![\"Video](\"\/sis-training\/files\/2025\/05\/Video-icon.png\"){kind=icon}
<\/a>![\"PDF](\"\/sis-training\/files\/2025\/05\/PDF-icon.png\"){kind=icon}
<\/a><\/p>\nIntroduction<\/h4>\n
This resource outlines instructions on how to use the Query Viewer page. It also lists common queries in MyBU Student that are helpful in advising processes. The following reports are included in this resource, but they do not represent all queries that advisors have access to:<\/p>\n
- \n
- Student Basic Info by Advisor<\/li>\n
- Advisee Email Download<\/li>\n
- Student List with Advisor Info<\/li>\n
- Students with Student Groups<\/li>\n
- Blocked Registrations<\/li>\n
- Legacy Advising Notes<\/li>\n<\/ul>\n
Each report included in this resource lists the prompts<\/strong> used for running the report and the data fields<\/strong> included in the results. This is meant to guide advisors in quickly identifying what report might be helpful depending on the search criteria that\u2019s needed and\/or the information that\u2019s desired to review. <\/p>\n
TIP! <\/strong>Try using the Ctrl+f keyboard shortcut to search this resource for a particular field.<\/p>\n
All queries have a unique identifier, called the Query Name. The Query Name is not meant to be a user-friendly title but a system identifier composed of keywords and abbreviations separated by underscores (for example: BU_R0010M_SR_CPP_HIST). Since the Query Name doesn’t always give a clear indication of the full description\/scope of the report, it may be helpful to add relevant queries to Favorites. Refer to the Query Viewer section below for more information about running queries and saving favorites.<\/p>\n
\u26a0\ufe0e Screen options, menus, and reports will vary by user; please note that displays may differ for you based on access that has been granted. All screens shown are for training purposes only.<\/p>\n
Query Viewer<\/h4>
\nQuery Viewer is the page used to access and run queries. All queries have a <\/p>\n- \n
- Log into MyBU Student<\/a>.<\/li>\n
- Upon landing on the Dashboard, scroll through the left menu and select Reporting Center > Query Viewer<\/strong>.<\/li>\n
- If the name or partial name of the query is known, it can be entered into the first field.\n
- \n
- If more criteria are needed to find the desired query, click Advanced Search<\/strong>.<\/li>\n<\/ol>\n
![\"Query](\"\/sis-training\/files\/2025\/06\/queries-for-advising-2-636x227.png\")
<\/a><\/li>\n- Additional fields will display to allow for the entry of more search criteria. Click Search<\/strong>.\n
Query results matching the search values will be listed. Commonly used options to compile the report include:<\/p>\n
- \n
- Run to HTML<\/strong>: click to run report directly in the web browser. Once compiled, the report can still be exported to excel.<\/li>\n
- Run to Excel<\/strong>: click to run report directly as a spreadsheet download.<\/li>\n<\/ul>\n
![\"This](\"\/sis-training\/files\/2025\/06\/queries-for-advising-4-636x146.png\")
<\/a><\/p>\nTo mark the query as a Favorite for easier access later, click Favorite. When the Query Viewer page is opened, any queries that have been saved as favorites will automatically display.<\/p>\n
![\"This](\"\/sis-training\/files\/2025\/06\/queries-for-advising-6-636x233.png\")
<\/a>\n<\/li>\n<\/ol>\n<\/div>\n<\/div>\n\n
Frequently Used Advising Reports<\/h4>
<\/p>\nThe following reports are identified as frequently used for advising needs and processes. They are not comprehensive of all reports that may be available for advisors. Proper security access must be granted.<\/p>\n
- \n
- Upon compiling, all reports can be downloaded. Click on the desired option above the list of results.<\/li>\n
- Click Rerun Query<\/strong> to enter new criteria for a new search.<\/li>\n<\/ul>\n
For help with searching and understanding terms and class\/course numbers, refer to the Prompt Field Search Tips, Course\/Class Identifier Information, and Term (Semester) Overview sections in the Appendix of this guide.<\/p>\n
STUDENT BASIC INFO BY ADVISOR<\/h5>\n
QUERY NAME:<\/strong> BU_R0046C_SR_STDNT_LST_BY_ADVR<\/p>\n
This report shows student’s basic information for advisor selection.<\/p>\n
- \n
- For a term, select advisor in report criteria to list all students assigned to that advisor.<\/li>\n<\/ul>\n
PROMPTS:<\/strong><\/p>\n
- \n
- Institution, Term, Advisor (all required)<\/li>\n<\/ul>\n
DATA FIELDS DISPLAYED IN RESULTS<\/strong>:<\/p>\n
- Institution, Term, Advisor (all required)<\/li>\n<\/ul>\n
- For a term, select advisor in report criteria to list all students assigned to that advisor.<\/li>\n<\/ul>\n
- Run to Excel<\/strong>: click to run report directly as a spreadsheet download.<\/li>\n<\/ul>\n
- Additional fields will display to allow for the entry of more search criteria. Click Search<\/strong>.\n
- Upon landing on the Dashboard, scroll through the left menu and select Reporting Center > Query Viewer<\/strong>.<\/li>\n
- Log into MyBU Student<\/a>.<\/li>\n
![\"This](\"\/sis-training\/files\/2025\/05\/queries-for-advising-8-636x320.png\")
<\/a><\/p>\n![\"MyBU](\"\/sis-training\/files\/2025\/05\/Advisees-Email-Download-menu-313x636.png\")
<\/a><\/p>\n![\"Advisees](\"\/sis-training\/files\/2025\/05\/Advisees-Email-Download-results-636x383.png\")
<\/a><\/p>\n![\"Student](\"\/sis-training\/files\/2025\/05\/queries-for-advising-9-528x636.png\")
<\/a>QUERY NAME:<\/strong> BU_R0046AV_SR_STDNT_ADVR_INFO<\/p>\n![\"This](\"\/sis-training\/files\/2025\/05\/queries-for-advising-15-636x282.png\")
<\/a>![\"This](\"\/sis-training\/files\/2025\/04\/Class-Numbers-Explained-QC-636x511.png\")
<\/p>\n