License shortage incorrectly indicated, system not reporting status of all clients
My location is running SEP on one server, upgraded approximately two months ago to 12.1.2015.2015. We have purchased hundreds of licenses. We are not synced with LDAP or Active Directory. Until the day we upgraded to 12.1, SEPM was reporting that we had about 50 less installed clients than licenses owned.
After upgrading to 12.1, we immediately began receiving warnings that we have insufficient licenses, to the tune of 700+ licenses.
As recommended elsewhere, weeks ago, I ran a database purge (down to 1 day, then back to 30 days), and now the console reports that we have only 50+ computers reporting their endpoint status. I can prove that we have more than 50 managed installations on computers on just one part of one floor of our office, and that they are receiving updates daily, so something seems very wrong.
My goal is to make the number of installed client licenses actually report correctly, and I'd like the console to reflect the fact that we have WAY more than 50 managed clients that are connecting and receiving daily updates and have it report their conditions.
I understand that queries can be run against the database, but I haven't found the manner in which to submit queries yet.
I have reindexed the databases twice.
Would someone be willing to guide me to instructions that I can use to (1) force any unmanaged clients that might have slipped through to be forced into a managed state, (2) create a list of machine names of all computers that SEPM counts as installed, so I can find the mistakes, and (3) force the system to correctly count and report our clients?