Need to find students that don't have a device assigned to them

Hi ​@BLamb 143a1ff mwcsd!

To find those students, I would create a new Custom View under Users. You’d filter by “Students” and exclude the “User Attribute” of “Has assigned device”.

​@BLamb 143a1ff mwcsd Thank you for submitting your question to our community! 😄

Looks like you have two of our CS Team lending a hand to you today! Please let us know if you have any additional questions! 

Is there a way to exclude ‘broken’ and ‘retired’ devices from the ‘Has Assigned Device’ Filter?  We keep those attached to the student for easy historical devices (at a glance we can tell how many broken devices they have had, for example).  Or another way to pull students that don’t have an ‘In Service’ device assigned?

​@RKEstrada Could you add the additional filter of “status” and exclude those 2 asset statues? 

Hi ​@Kathryn Carter,  Asset Status isn’t available as a filter from a User view, is it?  That would be perfect if I could do that.

​@RKEstrada It would be perfect but we cannot use that filter within a user view. 😔 Here is an idea to check out to have those filters across all modules: 

​@Kathryn Carter So, is there any way that I can get a list of students who don’t have an “in Service”  laptop assignment given the current limitations of the filters?  

​@RKEstrada I do not believe that is available at this time. I have not seen a use case where students are assigned devices are no longer in service. 

Wow - I wonder if we’re the only ones doing that. We really like the visual of being able to see the list/number of broken devices on the student profile record. Is there a better way to accomplish that view / information at a glance?

​@RKEstrada Here are a few threads that talk about tracking and looking at those repeat offenders: 

Hey Kathryn, I hope everything is going well today and sorry for the delay in chiming in here. While it’s true that the asset status filter isn’t utilized in User Views, using it in the Asset Views can get you close to what you want.

Essentially you’ll want to setup an Asset View with the Filter “Role = Student” and “Asset Status = [SELECTED STATUS]” as shown below:

Additionally, I recommend adding the “Owner Email” and “Owner School ID” as columns to the report. This will list all devices assigned to a student that match your status criteria and make it easy to export into a CSV. Using the CSV you can create a pivot table to identify the number of times a specific email address is mentioned in the report.

I hope this information helps!