Endpoint Protection

Upgraded SEPM (running on Windows Server 2012 R2) to 12.1.5, and clients don't show in GUI.

When I click Details it shows number of clients, when I run Monitors > Logs, etc it shows clients, when I run DB query it shows clients.

Short of uninstalling and reinstalling the management console, how do I fix this?

Details on the Home page?

You mean the Clients page is where they don't show? If you do a search do they show?

Yes, Details on Home page

Does a search show them in the console?

When I searching using Monitors > Logs, it shows

When I search in Clients > Search Clients, no show

We tried stopping the services, rebooting the server, no success :-(

Seems to me something is up in the DB or with the query that SEPM uses to retrieve clients within that window

The database works fine. I can query things and it returns clients.

Just now, I reduced the Heartbeat from 1 hour to 10 minutes .......

I'm talking about how the SEPM queries the DB, maybe something is wrong there (internally).

You can force a client check-in though by doing an smc -updateconfig by connecting remotely with psexec or powershell if you don't want to wait.

When we upgraded SEPM on our Staging servers, we didn't have these problems.....

It turns out the schema for the database was inconsistent. Had to run SQL queries to change this and now clients are showing in GUI

To find default schema

select ssp.name[SQL Login],
  sdp.default_schema_name[Default Schema] FROM sys.server_principals ssp  INNER JOIN sys.database_principals sdp on ssp.sid = sdp.sid  WHERE ssp.name = <SQL Login>

To find tables and views that do NOT have default schema

SELECT ist.TABLE_SCHEMA,ist.TABLE_NAME FROM INFORMATION_SCHEMA.TABLES ist  WHERE TABLE_CATALOG =<Database Name>
 AND ist.TABLE_SCHEMA NOT IN (
 select default_schema_name[Default Schema]  FROM sys.server_principals ssp  INNER JOIN sys.database_principals sdp on ssp.sid = sdp.sid  WHERE ssp.name=<SQL Login>)

And finally, update tables and views with incorrect schema to have default schema 

ALTER SCHEMA <Default Schema> TRANSFER <Incorrect Schema>.Name of table or view

Is there also some database consistency check for the embedded dabase (SQL Anywhere)?

I'm not sure about embedded databases, unless you can run query similar to the one below to find tables and views that don't have default schema

SELECT ist.TABLE_SCHEMA,ist.TABLE_NAME FROM INFORMATION_SCHEMA.TABLES ist  WHERE TABLE_CATALOG =<Database Name>
 AND ist.TABLE_SCHEMA NOT IN (
 select default_schema_name[Default Schema]  FROM sys.server_principals ssp  INNER JOIN sys.database_principals sdp on ssp.sid = sdp.sid  WHERE ssp.name=<SQL Login>)

I already figured that out, a similar query ;-)

The question was about what the similar query would be in SQLanywhere 16, because that internal database management system doesn't know about schema's, and principals.