Alerts for Lost Devices and Inactive Devices

Nice, very clever use of those filters. I also had to add Grade: Exclude (Not Assigned) Because there are teachers who also don’t sign into their Chromebooks. But that’s another story.

Thank you for testing this. I needed something like this for our agents to know when a Chromebook hasn’t been used in 30 days. One issue we’re running into is that the Google Device Data: Last Login isn’t always accurate. For some reason, we have devices that have active sessions less than 30 days, but the device hasn’t been signed into in over 30 days. We are testing with Google Device Data: Last Sync to see how this would fare. 

Also, I have a suspicion the moving date field “last month” might not always equal “a month” (even though not all months have 30 days). We’ve seen some false positives where the device was reported as inactive, but they were inactive a week or two short of “a month” using the Last Login data. 

After looking over the rule and using the filters for the same rule in an asset view, the “last month” filter is not a good choice for this type of thing. Once a new month starts, it matches all assets synched on 3/1-3/31, so that isn’t helpful. You can only choose one option in the rule, so I thought maybe if I selected Last Month and Current Month, then exclude both, it would help, but only being able to select a single option eliminates that possibility.

Ideally this would work best with something like “Last 30 days, exclude those” then it would match anything that has not logged in or synched in over 30 days. We have a “Last 7 days” option but 7 days is not enough time for what we’re trying to do here.

I was also not able to actually locate the “last login time” field in IIQ or in Google Admin, so I switched my own rule to Last Sync instead and then I can actually verify the data it’s looking at. That’s where I saw that it was now matching stuff that was synched on 3/29 which is not what we need here.

Figured out a good way I think for this, you can add a filter of “Google last sync” with Current Month, excluded, then another filter of the same “Google last sync” with Last Month, excluded. Now my list has only assets that have NOT synched either in April or March currently. That is what we’re looking for I believe.

After running the rule, it looks like we’re getting emails for devices other than chromebooks like Chromebook Carts, Windows Laptops, and iPads. One would think that doing a Google last sync would only apply to chromebook devices. I’m going to open a ticket with IIQ support to clarify.