I worked on a case where When we click on 'System Center 2012 R2 Endpoint Protection Status'->'Configuration Manager client not installed'->the view that opens does not give accurate information.
We have some clients which are listed as not Installed with the Clients, but when clicked on the same we do not see any information of those clients.
We see that the Client Not Installed Count here is 8 but when clicked on the view it does not return any records.
- We know the view it checks on the Page to list the Client in the 'Configuration Manager client not installed' pane. It is 'vSMS_EndpointProtectionHealthStatus'.
- We also know what query runs on the background to give the view of the clients -
- The view 'vSMS_EndpointProtectionHealthStatus' returns the result from the Column 'OverallNotClientCount'
- Worked a bit on the SQL and got the logic too it calculates.
The query it runs when drilled Pulls in from different views -
vSMS_G_System_EndpointProtectionStatus - This contains a field called 'NotClient' and we do have the Client here marked as not client.
-Moved ahead v_FullCollectionMembership returns those clients but when combined with a condition 'ClientType = 1' does not.
- So the discovered records are having a different Client type.
Ran the query -
Found from here that the ClientType for these NoClient=1 machines was NULL. And that now explains the reason why no records are returned.
Ran The query -
Returns the exact number of rows which do not turn up.
-Drilled down the view 'v_FullCollectionMembership' to check from where this information is stored. The table is system_disc.
The below query returns the records -
- Reproduced the same in the LAB. This is a BUG.
There are two options here for correction here-
1. To modify the view to exclude the condition 'c.ClientType = 1'
2. To Modify the System_Disc table to change the NULL values to 1.
Going by the risk analysis it is better to modify the discovery record. But it may change for rediscovery.
Ran the below -
Checked the console and we see the Not Client values now when drilled down.
Feeback filed - ID : 874343
Hope it helps!
Support Escalation Engineer | Microsoft System Center Configuration Manager
Disclaimer: This posting is provided "AS IS" with no warranties and confers no rights.