Hi Santosh,
One possible scenario I can think of is that on some clusters you might have metric clamping occurring either at agent or EM Collector side, so EM is not receiving nor processing new metrics for them.
If yes some agents are still connected but only have historical metrics older than the 1 minute you are testing for with the CLW command, which would explain the Calculator value for "Connections:Number of Agents" being higher
Can you please check to see if that is a possibility?
Here are some relevant metrics.
Agent clamp:
*SuperDomain*|Custom Metric Host (Virtual)|Custom Metric Process (Virtual)|Custom Metric Agent (Virtual)(<collector>)(*SuperDomain*)|Agents|<your agent name>: IsClamped
EM Collector clamps:
*SuperDomain*|Custom Metric Host (Virtual)|Custom Metric Process (Virtual)|Custom Metric Agent (Virtual)(<collector>)(*SuperDomain*)|Enterprise Manager|Connections|EM Live Metric Clamped
*SuperDomain*|Custom Metric Host (Virtual)|Custom Metric Process (Virtual)|Custom Metric Agent (Virtual)(<collector>)(*SuperDomain*)|Enterprise Manager|Connections|EM Historical Metric Clamped
Hope this helps
Thanks
Lynn