Widget that show the current version of Orion/DPA/NCM?

For most SolarWinds products, the following Custom Query should give you what you're looking for:

SELECT CASE
WHEN Name = 'APM'     THEN 'Server & Application Monitor'
WHEN Name = 'IPAM'    THEN 'IP Address Manager'
WHEN Name = 'NCM'     THEN 'Network Configuration Manager'
WHEN Name = 'NPM'     THEN 'Network Performance Monitor'
WHEN Name = 'NTA'     THEN 'NetFlow Traffic Analyzer'
WHEN Name = 'Orion'   THEN 'Orion Core'
WHEN Name = 'SEUM'    THEN 'Web Performance Analyzer'
WHEN Name = 'SRM'     THEN 'Storage Resource Monitor'
WHEN Name = 'Toolset' THEN 'Enterprise Toolset'
WHEN Name = 'UDT'     THEN 'User Device Tracker'
WHEN Name = 'VoIP'    THEN 'VoIP & Network Quality Manager'
WHEN Name = 'EOC'     THEN 'Enterprise Operations Console'
ELSE Name END AS [Product Name]
, Version

, CASE
WHEN IsEval = 'True' THEN  CONCAT('Evaluation (', [DaysRemaining], ' days left)')
ELSE 'Licensed' END AS [License Type]
      
FROM Orion.InstalledModule

I'm unable to test in my environment, but something similar may show you the status of DPA:

SELECT

[PI].DisplayName AS [Name]
, [PI].ProductVersion AS [Version]

FROM DPA.ProductInfo [PI]

If the above query doesn't work for DPA, the widget I currently use is a Custom Table with the following SQL query:

SELECT 
       Product = 'Database Performance Analyzer'
	  ,ProductABV = 'DPA'
	  ,[PROPERTY]
      ,[VALUE] AS 'Version'
  FROM [dpa_repository].[ignite].[CON_SWIP_PRODUCT_INFO]
 where PROPERTY = 'dpa_version'

It doesn't look as pretty, but it works in my environment whereas the SWQL query does not since my DPAS server has invalid credentials at the moment.

This is working but it is not showing my  DPA server names. 

SELECT

[PI].DisplayName AS [Name]
, [PI].ProductVersion AS [Version]

FROM DPA.ProductInfo [PI]

Again, apologies for not being able to test in my own environment, but I'm hoping something like this should give you the Node Caption of the DPA server.

SELECT

[N].Caption
, [PI].DisplayName AS [Name]
, [PI].ProductVersion AS [Version]


FROM DPA.ProductInfo [PI]
JOIN Orion.DPA.DpaServer [DS] ON [DS].DisplayName = [PI].DisplayName
JOIN Orion.Nodes [N] ON [N].NodeID = [DS].DpaServerId

Again, apologies for not being able to test in my own environment, but I'm hoping something like this should give you the Node Caption of the DPA server.

SELECT

[N].Caption
, [PI].DisplayName AS [Name]
, [PI].ProductVersion AS [Version]


FROM DPA.ProductInfo [PI]
JOIN Orion.DPA.DpaServer [DS] ON [DS].DisplayName = [PI].DisplayName
JOIN Orion.Nodes [N] ON [N].NodeID = [DS].DpaServerId