The below query can be run in Aeries to list all assets checked out to students, along with the barcode, item number, and student information. This query works at the School or District level.


LIST DRA DRI DRT STU STU.FN STU.LN DRT.TI DRA.ID DRA.DT DRI.BC IF DRA.RD = NULL AND DRA.ST = "S"


This query will list all assets checked out to Staff, however, this query only work at the District level since the DRA table only displays Students at the School level.


LIST DRT DRI DRA STF STF.FN STF.LN DRT.TI DRA.ID DRA.DT DRI.BC IF DRA.RD = NULL AND DRA.ST = "T"