Skip to main content
Solved

How to determine whether a withdrawn student still has a device assigned in IIQ?

J
Forum|alt.badge.img+2

A student withdrew from the district three months ago and was deactivated through the integration with our SIS. I needed to determine whether the student returned the laptop. The student is no longer in a list of users. I can’t find him using the SIS = inactive filter. We happened to have an external database that is linked to Active Directory, so I was able to look up the serial number and find the device is still assigned to the inactive student in IIQ..

 

How can I go about running reports or filters to find withdrawn students and whether they still have a device assigned to them solely within IIQ?

Best answer by Carina Burns Randolph

We have 40k students and 7k of staff so with that volume we couldn’t use queries/views from the user side….We had to search from the asset side and set a filter where role = no access to find devices assigned to former students/staff.

View original
Did you find this article helpful?

5 replies

J
Forum|alt.badge.img+2
  • JMcGowan711
  • Author
  • Observer
  • 3 replies
  • May 3, 2022

Found part of my answer, but can’t add the Asset Number to the export to create a workable file.

 

https://community.incidentiq.com/discussions-tips-and-tricks-70/custom-view-no-access-with-assigned-device-581

 

JAdkins_iiQ
T
2 people like this
  • JAdkins_iiQ
    JAdkins_iiQ
  • T
    Tammy Forby
Hannah Bailey
Forum|alt.badge.img+16
  • Hannah Bailey
  • iiQ Community Manager
  • 1690 replies
  • May 4, 2022

@JMcGowan711 
Glad you found the best practice article. 

When exporting your custom view you are able to add the additional columns for asset tag or serial number to your export. Please see the image below: 
 

 

Hannah Bailey - Director, Customer Engagement
JAdkins_iiQ
1 person likes this
  • JAdkins_iiQ
    JAdkins_iiQ
M
Forum|alt.badge.img+1
  • Mark Geer
  • Observer
  • 2 replies
  • June 9, 2022

I created a new view in Users with these filters.  You have to open each user to view the device, but if you don’t have a lot of peolpe that have left its manageable.

 

 

JAdkins_iiQ
J
2 people like this
  • JAdkins_iiQ
    JAdkins_iiQ
  • J
    JMcGowan711
C
Contributor
Forum|alt.badge.img+2

We have 40k students and 7k of staff so with that volume we couldn’t use queries/views from the user side….We had to search from the asset side and set a filter where role = no access to find devices assigned to former students/staff.

Hannah Bailey
JAdkins_iiQ
I
3 people like this
  • Hannah Bailey
    Hannah Bailey
  • JAdkins_iiQ
    JAdkins_iiQ
  • I
    iiqadmin
M
Forum|alt.badge.img+1
  • Mark Geer
  • Observer
  • 2 replies
  • July 20, 2022

I didn’t think of doing it from the asset side. I just created it, adn its’ way better than what I caome up with!  Thanks for sharing.

Mark

Hannah Bailey
JAdkins_iiQ
2 people like this
  • Hannah Bailey
    Hannah Bailey
  • JAdkins_iiQ
    JAdkins_iiQ

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
Incident IQ logo

Incident IQ is a service management platform built for K-12 school districts, featuring asset management, help ticketing, facilities maintenance solutions, and more.

Corporate Headquarters:
750 Glenwood Ave SE, Suite 320
Atlanta, GA 30316