Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

replication on the modern dashboard

Has anyone come up with a way to display replication failures as a count on the modern dashboard? I can see it in the AD appinsight, but I would like to have it as a number since I have 50 dc to monitor.

Thanks

Find more posts tagged with

Accepted answers

All comments

jm_sysadmin

If you are looking for data via SWQL I'd look in: Orion.APM.ActiveDirectory.Replication

I am not sure what widget you are hoping to use, but you asked for a number, so maybe the KPI?

SELECT Count (SourceNodeID) as [Number of DCs with Failures Replicating]
FROM Orion.APM.ActiveDirectory.Replication
Where ConsecutiveSyncFailureCount > 0

If you are looking to use the table, maybe:
SELECT SourceDomainControllerFqdn, DestinationDomainControllerFqdn, ConsecutiveSyncFailureCount, LastFailureTime, LastSuccessTime, LastAttemptTime
FROM Orion.APM.ActiveDirectory.Replication
-- Where ConsecutiveSyncFailureCount > 0

The proportional (for the bar chart?) might use something like:
SELECT SourceDomainControllerFqdn, Sum (ConsecutiveSyncFailureCount) as [Total Failures]
FROM Orion.APM.ActiveDirectory.Replication
-- Where ConsecutiveSyncFailureCount > 0
Group By SourceDomainControllerFqdn

Tell me what you are thinking about doing. And hopefully most of the replication error counts are 0.

trilobite_rex

Im going to use the first two you listed. The PKI worked great, the table I can't seem to get a propper format for the table so it won't let me save it.