CHRS Knowledge Base

Query UserID and EmplID

Updated on

Overview

This job aid shows you how to use a public query to obtain User IDs and Employee IDs.

Background

  • Employees have two IDs: an Employee ID and a User ID.
  • Sometimes you might need to obtain an Employee ID or a User ID when you have the other.
  • You can build a personal query to get this information, but there is an existing public query.

Run the CSU_SEC_15 query

Step 1: Navigate to Query Viewer.

  • Menu > Reporting Tools > Query > Query Viewer.
image of navigation page

Step 2: Search for the query:

  1. Type CSU_SEC_15 in the search field.
  2. Click Search.
image of query viewer page

Step 3 Optional: Add to Favorites.

  • Add to favorites if you need to use this query frequently.
image of adding favorites

Step 4: Click Excel export the data to a Microsoft Excel file.

image of run to excel

Step 5: Enter your campus abbreviation in the Company field, then click View Results.

image of entering campus abbreviation fields
  • The file is downloaded to your default browser download location.
  • You can search this file to find any user by name or User ID and the associated employee ID.

End of Article

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Previous Article (job aid) Find Security Queries
Do you need an article? Contact Us