It appears that "Data Analysis" stats are completely wrong.

In a 2 Node Cluster that both share a remote database and single eDirectory, the two nodes report different counts and neither match "actual".

For example, "Users that have saved an OTP Secret" (configured to store in Remote Database):


  1. Node 1: 79
  2. Node 2: 63
  3. Database: 47 (SELECT COUNT([id]) FROM [SSPR].[dbo].[OTP]


This just makes the whole Administration console pointless if the statistics are completely wrong.

The same goes for "Profile Updates" and "Challenge Response".

We run a multi-tenanted environment so not only require accurate statistics, but also need to segregate statistics based on Profiles within SSPR.