Installed Orion Modules
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
ORDER BY CASE
WHEN Name = 'APM' THEN 9
WHEN Name = 'IPAM' THEN 5
WHEN Name = 'NCM' THEN 4
WHEN Name = 'NPM' THEN 2
WHEN Name = 'NTA' THEN 3
WHEN Name = 'Orion' THEN 0
WHEN Name = 'SEUM' THEN 11
WHEN Name = 'SRM' THEN 10
WHEN Name = 'Toolset' THEN 8
WHEN Name = 'UDT' THEN 6
WHEN Name = 'VoIP' THEN 7
WHEN Name = 'EOC' THEN 1
ELSE 99
END