Determine which nodes in your environment report the version of the MA certificate bus.
Execute the query below directly on the ePO database:
- Open SQL Server Management Studio (SSMS).
- Connect to the SQL Server and instance hosting the ePO database.
- Expand Databases in the Object Explorer.
- Right-click on the database name for your ePO server, and select New Query.
- Paste the script below into the query window.
- Click Execute or press F5.
SELECT EPOLeafNode.NodeName, EPOProductSettings.Value as 'MessageBus Cert Version'
FROM EPOLeafNode
INNER JOIN EPOProductProperties ON EPOLeafNode.AutoID = EPOProductProperties.ParentID
INNER JOIN EPOProductFamilies ON EPOProductProperties.ProductCode = EPOProductFamilies.ProductCode
INNER JOIN EPOProductSettings ON EPOProductProperties.AutoID = EPOProductSettings.ParentID
WHERE EPOProductFamilies.ProductFamily = 'EPOAGENT'
AND EPOProductSettings.SettingName = 'MessageBus Cert Version'
- Review the Messages tab in SSMS for the results of the query.