How to show Duplicate Server name with count in dashboard using performance analytics?

[Saranya K]

I want to show duplicate server name along with count in cmdb_ci_server table using performance analytics. Can anyone help me on this to achieve.

Thanks

[Kieran Anson]

PA probably isn't the right fit for this unless you're wanting some trend related metrics on the count id duplicate devices. 

Can you explain the purpose of what you're wanting and we can help with the most appropriate solution 

[Saranya K]

Hi @Kieran Anson ,

Thanks for your response my requirement is in cmdb_ci_server there are multiple records for same server with same class 

In My dashboard i need show those servers in below format

ServerName.       Class name.        Count (No of time same server)

Regards,

Saranya K

[Kieran Anson]

Using platform analytics you might be limited as I don't believe it supports a "having" condition

However, CMDB Workspace already has duplicate detection as part of CMDB Health. Have you explored this? This detects duplicate on further critiera(s) then name