Kevin's Ramblings

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