Collection query - Collection Members

Question

Hello,

I have a collection with the following query:

and this is the Member I obtained:

The Client Version displayed does not match the query!!!
I checked the Resource Explorer and it is matching the Member List Version seen.
How does the query get the new information?

Thanks,
Dom

Answer 1

Hello Dom,

I have reviewed my lab and it seems that all worked normally.

Also I query the client version in SSMS as the following query command:

select A.Name0,A.Client_Version0,A.Client0 from dbo.vSMS_R_System A  

The result is as the same. It seems that the issue in your environment is more related with Performance with the SQL Server. It will be better if you could open ta ticket with MS. The phone Support Engineer with cooperate with SQL Server related Engineer to handle this case.
Global Customer Service phone numbers:
https://support.microsoft.com/en-us/topic/global-customer-service-phone-numbers-c0389ade-5640-e588-8b0e-28de8afeb3f2

Thanks for your understanding and cooperation.

Have a great day.

Best regards,
Rita

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Apparently this seems to be a latency especially on the SQL Server which is at 99% CPU !!! as some machines are up-to-date in SQL 5.00.9078.1025... but the console is still not up-to-date... SQL is giving a total of 12,000+ machines when the console is showing only 7,300 !!! What is the delay expected after upgrading to MECM 2203 + KB14480034 + KB14244456.

The number of previously client was 32,000 roles are on separated servers:

• 1 Primary Server( also MP): 8 Cores 2.20 Ghz, RAM 64 Gb
• 1 SQL Server: Quad 2.20 Ghz, RAM 196 Gb
• 1 Management Point(2nd MP most likely the one used by the Clients): 10 Cores 2.20 Ghz, RAM 32 Gb
  All servers are VMs with VMware.

Thanks,
Dom

Answer 3

Hello,

Yes all roles are on separated servers:

• VRPSCCMPR01 for the Primary
• VRPSCCMSQL01 for SQL
• VRPSCCMMS03 for the 2nd Management Point server

Thanks,
Dom