Search for students or staff without photos

You can easily find all students or staff in your district or school who do not have a photo in their Aspen record by using a queryClosed a request to find a group of records that match specific criteria at a particular time.

To search for students or staff without a photo in their Aspen record:

  1. Log on to the District, Intermediate Organization, or School view.
  2. Click the Student tab.
  3. Select Options> Query.
  4. In the upper-right corner drop-down, select Direct SQL Mode.
  1. Under SELECT * FROM STUDENT, copy and paste one of the following queries in the field:

    To find students without photos:

  WHERE STD_PSN_OID NOT IN

(SELECT PSN_OID

      FROM PERSON, PERSON_PHOTO

WHERE PSN_PHO_OID_PRIMARY = PHO_OID)

To find staff without photos:

WHERE STF_PSN_OID NOT IN

      (SELECT PSN_OID

      FROM PERSON, PERSON_PHOTO

WHERE PSN_PHO_OID_PRIMARY = PHO_OID)

  1. Click Save As.
  2. In the Save As pop-up, enter a Name for the query.
  3. Click Save.
  4. Click Search. The query can now be run from the Student tab.