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