Fog clients with issues

[Greg Plamondon]

Is there any way that I can see what fog clients are having issues with the fogserver?
I have come across multiple clients recently that have not been checking in for user reports. A simple resetting of the Encryption Data in the GUI fixed the issue. If there was a report I could run that displayed the last successful check-in of the clients I think that would help.

[Sebastian Roth]

@Greg-Plamondon Interesting point you have there. You might take a look at the hostSecTime column in hosts table in the database. I am not sure how often this is being updated but it should let you find hosts that have not checked in in a long time.