none
Decoding values in SqlServer_Inventory.Inventory.sqlservicetype RRS feed

  • Question

  • Hi

    I'm using the following script snippet to decode the values contained in the SqlServer_Inventory.Inventory.sqlservicetype column in the MAPS database:

    SELECT sqlservicetype, 
    CASE sqli.sqlservicetype            
       WHEN 1 THEN 'Database'            
       WHEN 2 THEN 'other 2'            
       WHEN 3 THEN 'other 3'            
       WHEN 4 THEN ''            
       WHEN 5 THEN ''            
       WHEN 6 THEN 'Reporting Services'            
       ELSE CAST(sqli.sqlservicetype AS NVARCHAR(20))       END                   AS Component 
    FROM SqlServer_Inventory.Inventory sqli
     

    Does anybody know the translated values for 2, 3, 4, 5 and any other values?

    Any help appreciated. I've recently found out that 5 = OLAP (Analysis Services).

    Thanks.


    • Edited by hot2use Thursday, January 9, 2014 10:08 AM new value found
    Thursday, January 9, 2014 7:30 AM

Answers

  •  2= an Agent Service
    3 = Full Text Engine
    4= Integration Services
    5= Analysis Services  (OLAP I believe)

    qed   ;)

    Steve at AssetLabs.

    Thursday, January 30, 2014 2:21 AM

All replies