none
SQL Server Inventory Report

    Question

  • Guten Morgen,

    ich suche einen SQL Server Inventory Report für SCCM, der SQL-Server Versionen bis einschließlich SQL-Server 2016 anzeigt.

    Habt ihr mir Tipps? :-)

    Grüße

    Julian

    Thursday, September 14, 2017 9:01 AM

All replies

  • Hi Torsten,

    ich habe Probleme beim Hochladen des Reports auf die SQL Server Reporting Services Webseite:

    The definition of this report is not valid or supported by this version of Reporting Services. The report definition may have been created with a later version of Reporting Services, or contain content that is not well-formed or not valid based on Reporting Services schemas. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition' which cannot be upgraded. (rsInvalidReportDefinition)

    Was kann ich hier tun?

    Ich habe SCCM 2012R2 SP1; SQL-Server: 2012


    • Edited by Julian79 Thursday, September 14, 2017 11:43 AM
    Thursday, September 14, 2017 11:38 AM
  • Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition' which cannot be upgraded. (rsInvalidReportDefinition)

    [...]Ich habe SCCM 2012R2 SP1; SQL-Server: 2012


    2016 rdl vs 2012 SQL server ...

    Hatte den Fall noch nicht, aber es sollte kein Problem sein, den Report manuell neu zu erstellen. Query und Datasets stehen ja lesbar im rdl.


    Torsten Meringer | http://www.mssccmfaq.de

    Thursday, September 14, 2017 1:17 PM
    Answerer
  • Danke für den Tipp Torsten. Ich habe es mal probiert, die Datasets und Queries in einen neuen Report einzubauen, hat aber nicht funktioniert. Ich habe hierzu den SQL Server 2012 Report Builder 3.0 verwendet.

    Ich habe damit noch nicht so viel Erfahrung, gibt es evtl. einen Edit/Text-View in dem ich den Code kopieren könnte?

    Grüße

    Julian

    Friday, September 15, 2017 7:21 AM
  • Die Query aus dem rdl kannst Du auch im SQL Management Studio ausführen.

    Torsten Meringer | http://www.mssccmfaq.de

    Friday, September 15, 2017 8:12 AM
    Answerer
  • Hi Torsten,

    danke für den Tipp. Ich habe versucht nur die Query herauszukopieren und im SSMS laufen zu lassen. Leider bekomme ich auch da wieder eine Fehlermeldung. Die Variablen Collid und UserSIDs fehlen. Hast du mir einen Tipp? :-)

    SELECT
       v_Collection_Alias.CollectionID ,v_Collection_Alias.Name
     FROM
    fn_rbac_Collection(@UserSIDs) v_Collection_Alias
     WHERE
      v_Collection_Alias.CollectionType = 2
    order by v_Collection_Alias.Name
    
    WITH temp([ResourceID],
              [ComputerName],
              [Company],
              [SQL TYPE],
              [SQL Service Pack],
              [SQL Version],
              [SQL CU Version],
              [Version])
         AS (SELECT DISTINCT
                    [ResourceID],
                    [ComputerName],
                    [Company],
                    [SQL TYPE],
                    [SQL Service Pack],
                    [SQL Version],
                    [SQL CU Version],
                    [Version]
                    FROM
                         (
                         -- SQL 2016
                         SELECT [vrs].[resourceID] [ResourceID],
                                [VRS].[Netbios_name0] [ComputerName],
                                ISNULL([vrs].[company0], '<Unknown>') AS
                                'Company',
                                --vrs.company0 as 'Company',
                                MAX(CASE [sql2016].[PropertyName0]
                                        WHEN 'SKUName'
                                        THEN [sql2016].[PropertySTRValue0]
                                    END) AS [SQL TYPE],
                                MAX(CASE [sql2016].[PropertyName0]
                                        WHEN 'SPLEVEL'
                                        THEN [sql2016].[PropertyNUMValue0]
                                    END) AS [SQL Service Pack],
                                MAX(CASE [sql2016].[PropertyName0]
                                        WHEN 'VERSION'
                                        THEN [sql2016].[PropertySTRValue0]
                                    END) AS [SQL Version],
                                MAX(CASE [sql2016].[PropertyName0]
                                        WHEN 'FILEVERSION'
                                        THEN [sql2016].[PropertySTRValue0]
                                    END) AS [SQL CU Version],
                                MAX(CASE [sql2016].[PropertyName0]
                                        WHEN 'FILEVERSION'
                                        THEN CASE LEFT([sql2016].
                                        [PropertySTRValue0], 4)
                                                 WHEN '2016'
                                                 THEN '2016'
                                                 WHEN '2014'
                                                 THEN '2014'
                                                 WHEN '2011'
                                                 THEN '2012'
                                                 WHEN '2009'
                                                 THEN '2008 R2'
                                                 WHEN '2007'
                                                 THEN '2008'
                                                 WHEN '2005'
                                                 THEN '2005'
                                                 WHEN '2000'
                                                 THEN '2000'
                                                 ELSE '2016'
                                             END
                                    END) AS [Version]
                                FROM [dbo].[v_R_System] [VRS]
                                     LEFT JOIN 
                                     [v_GS_CUSTOM_SQL_2016_Property_2_00]
                                     [sql2016] ON [sql2016].[ResourceID] =
                                     [VRS].[ResourceID]
                                     LEFT OUTER JOIN
                                     [v_ClientCollectionMembers] [c] ON [c].
                                     [ResourceID] = [vrs].[ResourceID]
                                WHERE [sql2016].[PropertyName0] IN('SKUNAME',
                                'SPLevel', 'version', 'fileversion'
                                                                  )
                                AND [c].[CollectionID] = @CollID
                                AND ISNULL([sql2016].[ServiceName0], 0) NOT
                                LIKE '%EXPRESS%'
                                GROUP BY [VRS].[Netbios_name0],
                                         [sql2016].[ServiceName0],
                                         [vrs].[company0],
                                         [vrs].[resourceID]
    
                         -- SQL 2014
                         UNION ALL
                         SELECT [vrs].[resourceID] [ResourceID],
                                [VRS].[Netbios_name0] [ComputerName],
                                ISNULL([vrs].[company0], '<Unknown>') AS
                                'Company',
                                --vrs.company0 as 'Company',
                                MAX(CASE [sql2014].[PropertyName0]
                                        WHEN 'SKUName'
                                        THEN [sql2014].[PropertySTRValue0]
                                    END) AS [SQL TYPE],
                                MAX(CASE [sql2014].[PropertyName0]
                                        WHEN 'SPLEVEL'
                                        THEN [sql2014].[PropertyNUMValue0]
                                    END) AS [SQL Service Pack],
                                MAX(CASE [sql2014].[PropertyName0]
                                        WHEN 'VERSION'
                                        THEN [sql2014].[PropertySTRValue0]
                                    END) AS [SQL Version],
                                MAX(CASE [sql2014].[PropertyName0]
                                        WHEN 'FILEVERSION'
                                        THEN [sql2014].[PropertySTRValue0]
                                    END) AS [SQL CU Version],
                                MAX(CASE [sql2014].[PropertyName0]
                                        WHEN 'FILEVERSION'
                                        THEN CASE LEFT([sql2014].
                                        [PropertySTRValue0], 4)
                                                 WHEN '2016'
                                                 THEN '2016'
                                                 WHEN '2014'
                                                 THEN '2014'
                                                 WHEN '2011'
                                                 THEN '2012'
                                                 WHEN '2009'
                                                 THEN '2008 R2'
                                                 WHEN '2007'
                                                 THEN '2008'
                                                 WHEN '2005'
                                                 THEN '2005'
                                                 WHEN '2000'
                                                 THEN '2000'
                                                 ELSE '2014'
                                             END
                                    END) AS [Version]
                                FROM [v_R_System] [VRS]
                                     LEFT JOIN 
                                     [v_GS_CUSTOM_SQL_2014_Property_2_00]
                                     [sql2014] ON [sql2014].[ResourceID] =
                                     [VRS].[ResourceID]
                                     LEFT OUTER JOIN
                                     [v_ClientCollectionMembers] [c] ON [c].
                                     [ResourceID] = [vrs].[ResourceID]
                                WHERE [sql2014].[PropertyName0] IN('SKUNAME',
                                'SPLevel', 'version', 'fileversion'
                                                                  )
                                AND [c].[CollectionID] = @CollID
                                AND ISNULL([sql2014].[ServiceName0], 0) NOT
                                LIKE '%EXPRESS%'
                                GROUP BY [VRS].[Netbios_name0],
                                         [sql2014].[ServiceName0],
                                         [vrs].[company0],
                                         [vrs].[resourceID]
                         -- SQL 2012
                         UNION ALL
                         SELECT [vrs].[resourceID] [ResourceID],
                                [VRS].[Netbios_name0] [ComputerName],
                                ISNULL([vrs].[company0], '<Unknown>') AS
                                'Company',
                                MAX(CASE [sql2012].[PropertyName0]
                                        WHEN 'SKUName'
                                        THEN [sql2012].[PropertySTRValue0]
                                    END) AS [SQL TYPE],
                                MAX(CASE [sql2012].[PropertyName0]
                                        WHEN 'SPLEVEL'
                                        THEN [sql2012].[PropertyNUMValue0]
                                    END) AS [SQL Service Pack],
                                MAX(CASE [sql2012].[PropertyName0]
                                        WHEN 'VERSION'
                                        THEN [sql2012].[PropertySTRValue0]
                                    END) AS [SQL Version],
                                MAX(CASE [sql2012].[PropertyName0]
                                        WHEN 'FILEVERSION'
                                        THEN [sql2012].[PropertySTRValue0]
                                    END) AS [SQL CU Version],
                                MAX(CASE [sql2012].[PropertyName0]
                                        WHEN 'FILEVERSION'
                                        THEN CASE LEFT([sql2012].
                                        [PropertySTRValue0], 4)
                                                 WHEN '2016'
                                                 THEN '2016'
                                                 WHEN '2014'
                                                 THEN '2014'
                                                 WHEN '2011'
                                                 THEN '2012'
                                                 WHEN '2009'
                                                 THEN '2008 R2'
                                                 WHEN '2007'
                                                 THEN '2008'
                                                 WHEN '2005'
                                                 THEN '2005'
                                                 WHEN '2000'
                                                 THEN '2000'
                                                 ELSE '2012'
                                             END
                                    END) AS [Version]
                                FROM [V_R_System] [VRS]
                                     LEFT JOIN 
                                     [v_GS_CUSTOM_SQL_2012_Property_2_00]
                                     [sql2012] ON [sql2012].[ResourceID] =
                                     [VRS].[ResourceID]
                                     LEFT OUTER JOIN
                                     [v_ClientCollectionMembers] [c] ON [c].
                                     [ResourceID] = [vrs].[ResourceID]
                                WHERE [sql2012].[PropertyName0] IN('SKUNAME',
                                'SPLevel', 'version', 'fileversion'
                                                                  )
                                AND [c].[CollectionID] = @CollID
                                AND ISNULL([ServiceName0], 0) NOT LIKE
                                '%EXPRESS%'
                                GROUP BY [VRS].[Netbios_name0],
                                         [sql2012].[ServiceName0],
                                         [vrs].[company0],
                                         [vrs].[resourceID]
                         -- SQL 2008
                         UNION ALL
                         SELECT [vrs].[resourceID] [ResourceID],
                                [VRS].[Netbios_name0] [ComputerName],
                                ISNULL([vrs].[company0], '<Unknown>') AS
                                'Company',
                                MAX(CASE [sql2008].[PropertyName0]
                                        WHEN 'SKUName'
                                        THEN [sql2008].[PropertySTRValue0]
                                    END) AS [SQL TYPE],
                                MAX(CASE [sql2008].[PropertyName0]
                                        WHEN 'SPLEVEL'
                                        THEN [sql2008].[PropertyNUMValue0]
                                    END) AS [SQL Service Pack],
                                MAX(CASE [sql2008].[PropertyName0]
                                        WHEN 'VERSION'
                                        THEN [sql2008].[PropertySTRValue0]
                                    END) AS [SQL Version],
                                MAX(CASE [sql2008].[PropertyName0]
                                        WHEN 'FILEVERSION'
                                        THEN [sql2008].[PropertySTRValue0]
                                    END) AS [SQL CU Version],
                                MAX(CASE [sql2008].[PropertyName0]
                                        WHEN 'FILEVERSION'
                                        THEN CASE LEFT([sql2008].
                                        [PropertySTRValue0], 4)
                                                 WHEN '2016'
                                                 THEN '2016'
                                                 WHEN '2014'
                                                 THEN '2014'
                                                 WHEN '2011'
                                                 THEN '2012'
                                                 WHEN '2009'
                                                 THEN '2008 R2'
                                                 WHEN '2007'
                                                 THEN '2008'
                                                 WHEN '2005'
                                                 THEN '2005'
                                                 WHEN '2000'
                                                 THEN '2000'
                                                 ELSE '2008'
                                             END
                                    END) AS [Version]
                                FROM [V_R_System] [VRS]
                                     LEFT JOIN 
                                     [v_GS_CUSTOM_SQL_2008_Property_2_00]
                                     [sql2008] ON [sql2008].[ResourceID] =
                                     [VRS].[ResourceID]
                                     LEFT OUTER JOIN
                                     [v_ClientCollectionMembers] [c] ON [c].
                                     [ResourceID] = [vrs].[ResourceID]
                                WHERE [sql2008].[PropertyName0] IN('SKUNAME',
                                'SPLevel', 'version', 'fileversion'
                                                                  )
                                AND [c].[CollectionID] = @CollID
                                AND ISNULL([sql2008].[ServiceName0], 0) NOT
                                LIKE '%EXPRESS%'
                                AND ISNULL([sql2008].[ServiceName0], 0) NOT
                                LIKE 'SQLBrowser'
                                GROUP BY [VRS].[Netbios_name0],
                                         [sql2008].[ServiceName0],
                                         [vrs].[company0],
                                         [vrs].[resourceID]
                         -- SQL Legacy
                         UNION ALL
                         SELECT [vrs].[resourceID] [ResourceID],
                                [VRS].[Netbios_name0] [ComputerName],
                                ISNULL([vrs].[company0], '<Unknown>') AS
                                'Company',
                                MAX(CASE [sqlLgcy].[PropertyName0]
                                        WHEN 'SKUName'
                                        THEN [sqlLgcy].[PropertySTRValue0]
                                    END) AS [SQL TYPE],
                                MAX(CASE [sqlLgcy].[PropertyName0]
                                        WHEN 'SPLEVEL'
                                        THEN [sqlLgcy].[PropertyNUMValue0]
                                    END) AS [SQL Service Pack],
                                MAX(CASE [sqlLgcy].[PropertyName0]
                                        WHEN 'VERSION'
                                        THEN [sqlLgcy].[PropertySTRValue0]
                                    END) AS [SQL Version],
                                MAX(CASE [sqlLgcy].[PropertyName0]
                                        WHEN 'FILEVERSION'
                                        THEN [sqlLgcy].[PropertySTRValue0]
                                    END) AS [SQL CU Version],
                                MAX(CASE [sqllgcy].[PropertyName0]
                                        WHEN 'FILEVERSION'
                                        THEN CASE LEFT([sqllgcy].
                                        [PropertySTRValue0], 4)
                                                 WHEN '2016'
                                                 THEN '2016'
                                                 WHEN '2014'
                                                 THEN '2014'
                                                 WHEN '2011'
                                                 THEN '2012'
                                                 WHEN '2009'
                                                 THEN '2008 R2'
                                                 WHEN '2007'
                                                 THEN '2008'
                                                 WHEN '2005'
                                                 THEN '2005'
                                                 WHEN '2000'
                                                 THEN '2000'
                                                 ELSE '2005'
                                             END
                                    END) AS [Version]
                                FROM [V_R_System] [VRS]
                                     LEFT JOIN 
                                     [v_GS_CUSTOM_SQL_Legacy_Property_2_00]
                                     [sqlLgcy] ON [sqlLgcy].[ResourceID] =
                                     [VRS].[ResourceID]
                                     LEFT OUTER JOIN
                                     [v_ClientCollectionMembers] [c] ON [c].
                                     [ResourceID] = [vrs].[ResourceID]
                                WHERE [sqlLgcy].[PropertyName0] IN('SKUNAME',
                                'SPLevel', 'version', 'fileversion'
                                                                  )
                                AND [c].[CollectionID] = @CollID
                                AND ISNULL([sqlLgcy].[ServiceName0], 0) NOT
                                LIKE '%EXPRESS%'
                                AND ISNULL([sqlLgcy].[ServiceName0], 0) NOT
                                LIKE 'SQLBrowser'
                                GROUP BY [VRS].[Netbios_Name0],
                                         [sqlLgcy].[ServiceName0],
                                         [vrs].[company0],
                                         [vrs].[resourceID]
                         ) [SQLInv]
                    WHERE [SQL TYPE] NOT LIKE 'Express%'
                          AND [SQL TYPE] NOT LIKE 'Windows Internal Database%'
                          AND SUBSTRING([SQL Version], 1, 2) != SUBSTRING(
                          [SQL CU Version], 1, 2))
    
    SELECT distinct
    	[Company],
    	[ComputerName],
    	[SQL TYPE],
    	[SQL Service Pack],
    	[SQL Version],
    	[SQL CU Version],
    	[version] as VER,
    	(CASE
    				 WHEN [sql type] LIKE '%develop%' THEN 'Developer Edition' 
    				 WHEN [sql type] LIKE '%standard%' THEN 'Standard Edition' 
    				 WHEN [sql type] LIKE '%enterprise%' THEN 'Enterprise Edition' 
    				 END)  AS 'Version'
    FROM temp
    order by temp.[Company], ver,version, ComputerName

    Wednesday, September 20, 2017 11:53 AM
  • Zum Test im Mgmt Studio AND [c].[CollectionID] = @CollID einfach durch AND [c].[CollectionID] = 'SMS00001' (bzw die ID der Collection) ersetzen. Und fn_rbac_Collection(@UserSIDs) v_Collection_Alias durch fn_rbac_Collection('disabled') v_Collection_Alias.


    Torsten Meringer | http://www.mssccmfaq.de

    Wednesday, September 20, 2017 1:37 PM
    Answerer
  • Jetzt bekomme ich folgende Fehlermeldung:

    Msg 207, Level 16, State 1, Line 87
    Invalid column name 'company0'.
    Msg 207, Level 16, State 1, Line 31
    Invalid column name 'company0'.
    Msg 207, Level 16, State 1, Line 150
    Invalid column name 'company0'.
    Msg 207, Level 16, State 1, Line 94
    Invalid column name 'company0'.
    Msg 207, Level 16, State 1, Line 211
    Invalid column name 'company0'.
    Msg 207, Level 16, State 1, Line 156
    Invalid column name 'company0'.
    Msg 207, Level 16, State 1, Line 274
    Invalid column name 'company0'.
    Msg 207, Level 16, State 1, Line 217
    Invalid column name 'company0'.
    Msg 207, Level 16, State 1, Line 337
    Invalid column name 'company0'.
    Msg 207, Level 16, State 1, Line 280
    Invalid column name 'company0'.

    Wednesday, September 20, 2017 2:23 PM
  • Ist denn die Spalte "company0" überhaupt in v_R_System vorhanden? Das ist kein Standard. Ansonsten lasse halt einfach company0 jwls weg.

    Torsten Meringer | http://www.mssccmfaq.de

    Thursday, September 21, 2017 6:06 AM
    Answerer
  • Ohne die Company-Spalte funktioniert das Skript zwar - es kommen zumindest keine Fehlermeldungen mehr. Leider werden mir aber nur 2 Server angezeigt. Was aber zu wenig ist! :-(

    Grüße

    Julian

    Monday, October 02, 2017 5:44 AM
  • Jetzt sind es ein paar mehr Server geworden. Aber immer noch zu wenig. In Messages erhalte ich folgende Meldung:

    (64 row(s) affected)
    Warning: Null value is eliminated by an aggregate or other SET operation.

    (6 row(s) affected)

    Monday, October 02, 2017 6:14 AM
  • Schaue Dir doch mal einen fehlenden Server im Resource-Explorer an. Werden die SQL-Daten dort gelistet?

    Torsten Meringer | http://www.mssccmfaq.de

    Wednesday, October 04, 2017 7:21 AM
    Answerer
  • Jetzt wird es interessant. Ich habe mal einen Server gecheckt, der in der Liste fehlt. Und da ist im Hardware-Inventory kein Eintrag "SQL Server 2012 Property". Im Resource Explorers eines funktionierenden SQL-Servers ist dieser Eintrag im Hardware-Inventory vorhanden. In dem Fall ein "SQL Server 2016 Property"-Eintrag.

    Ich habe jetzt mal einen Hardware Inventory Cycle auf dem Server gestartet, der den Eintrag nicht hat.

    Hast du sonst noch eine Idee, was ich probieren könnte?

    Grüße

    Julian


    • Edited by Julian79 Wednesday, October 04, 2017 9:23 AM
    Wednesday, October 04, 2017 9:22 AM
  • Liegt dann auf jeden Fall an der HW Inventur. Ist es eine Custom Computer Policy oder die Default? Steht was im InventoryAgent.log am Client bzw dataldr.log am Server?

    Torsten Meringer | http://www.mssccmfaq.de

    Wednesday, October 04, 2017 12:18 PM
    Answerer
  • Es ist die Default Policy.

    Ich starte nochmals den Hardware Inventory Cycle und checke die beiden LogFiles!

    Thursday, October 05, 2017 11:22 AM
  • Es werden in der InvetoryAgent.log folgende Fehler protokolliert:

    Failed to get IWbemService Ptr for \\localhost\root\Microsoft\appvirt\client Namespace: 8004100E InventoryAgent 10/5/2017 1:35:58 PM 6332 (0x18BC)

    Failed to enumerate instances of Package: 8004100E InventoryAgent 10/5/2017 1:35:58 PM 6332 (0x18BC)

    Failed to get IWbemService Ptr for \\localhost\root\Microsoft\appvirt\client Namespace: 8004100E InventoryAgent 10/5/2017 1:36:03 PM 6332 (0x18BC)

    Failed to enumerate instances of Application: 8004100E InventoryAgent 10/5/2017 1:36:03 PM 6332 (0x18BC)

    Unknown error encountered processing an instance of class SQL_2008: 8004100E InventoryAgent 10/5/2017 1:36:05 PM 6332 (0x18BC)

    Unknown error encountered processing an instance of class SQL_2000_And_2005: 8004100E InventoryAgent 10/5/2017 1:36:07 PM 6332 (0x18BC)

    Unknown error encountered processing an instance of class SQL_2014: 8004100E InventoryAgent 10/5/2017 1:36:22 PM 6332 (0x18BC)

    Failed to get IWbemService Ptr for \\localhost\root\vm\VirtualServer Namespace: 8004100E InventoryAgent 10/5/2017 1:36:24 PM 6332 (0x18BC)

    Failed to enumerate instances of VirtualMachine: 8004100E InventoryAgent 10/5/2017 1:36:24 PM 6332 (0x18BC)

    Unknown error encountered processing an instance of class SQL_2016: 8004100E InventoryAgent 10/5/2017 1:36:25 PM 6332 (0x18BC)

    Inventory: 15 Collection Task(s) failed. InventoryAgent 10/5/2017 1:36:25 PM 6332 (0x18BC)

    Auf dem betroffenen Server ist SQL2012 installiert, folgenden Eintrag finde ich im Log:

    Collection: Namespace = \\.\root\cimv2; Query = SELECT __CLASS, __PATH, __RELPATH, PropertyIndex, PropertyName, ServiceName, SqlServiceType, IsReadOnly, PropertyNumValue, PropertyStrValue, PropertyValueType FROM SQL_2012; Timeout = 600 secs. InventoryAgent 10/5/2017 1:36:07 PM 6332 (0x18BC)

    Any ideas?

    Grüße

    Julian



    • Edited by Julian79 Thursday, October 05, 2017 12:40 PM
    Thursday, October 05, 2017 12:37 PM
  • Die "unknown"-Fehler sollten unrelevant sein. Was steht denn in der WMI-Klasse SQL_2012 (müsste select * from SQL_2012 in root\cimv2 sein)?

    Torsten Meringer | http://www.mssccmfaq.de

    Thursday, October 05, 2017 12:48 PM
    Answerer
  • Wo finde ich denn diese info? Habe mal die SQL 2012 Property aus dem Hardware Inventory exportiert und folgendes gefunden:

    [ SMS_Report (TRUE),
      SMS_Group_Name ("SQL 2012 Property"),
      SMS_Class_ID ("CUSTOM|SQL_2012_Property|2.0"),
      Namespace ("\\\\\\\\.\\\\root\\\\cimv2") ]
    class SQL_2012 : SMS_Class_Template
    {
        [ SMS_Report (TRUE), key ]
        UInt32     PropertyIndex;
        [ SMS_Report (TRUE), key ]
        String     PropertyName;
        [ SMS_Report (TRUE), key ]
        String     ServiceName;
        [ SMS_Report (TRUE), key ]
        UInt32     SqlServiceType;
        [ SMS_Report (TRUE) ]
        Boolean     IsReadOnly;
        [ SMS_Report (TRUE) ]
        UInt32     PropertyNumValue;
        [ SMS_Report (TRUE) ]
        String     PropertyStrValue;
        [ SMS_Report (TRUE) ]
        UInt32     PropertyValueType;

    • Edited by Julian79 Thursday, October 05, 2017 1:12 PM
    Thursday, October 05, 2017 1:06 PM
  • Per Powershell:

    gwmi-Query"select * from SQL_2012"


    Torsten Meringer | http://www.mssccmfaq.de

    Thursday, October 05, 2017 1:39 PM
    Answerer

  • __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=0,PropertyName="SQLSTATES",ServiceName="MSSQLSERVER",SqlServiceType=1
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=0,PropertyName="SQLSTATES",ServiceName="MSSQLSERVER"
                        ,SqlServiceType=1
    IsReadOnly        : True
    PropertyIndex     : 0
    PropertyName      : SQLSTATES
    PropertyNumValue  : 2053
    PropertyStrValue  :
    PropertyValueType : 2
    ServiceName       : MSSQLSERVER
    SqlServiceType    : 1
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=1,PropertyName="VERSION",ServiceName="MSSQLSERVER",SqlServiceType=1
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=1,PropertyName="VERSION",ServiceName="MSSQLSERVER",S
                        qlServiceType=1
    IsReadOnly        : True
    PropertyIndex     : 1
    PropertyName      : VERSION
    PropertyNumValue  :
    PropertyStrValue  : 11.3.6020.0
    PropertyValueType : 0
    ServiceName       : MSSQLSERVER
    SqlServiceType    : 1
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=2,PropertyName="SPLEVEL",ServiceName="MSSQLSERVER",SqlServiceType=1
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=2,PropertyName="SPLEVEL",ServiceName="MSSQLSERVER",S
                        qlServiceType=1
    IsReadOnly        : True
    PropertyIndex     : 2
    PropertyName      : SPLEVEL
    PropertyNumValue  : 3
    PropertyStrValue  :
    PropertyValueType : 2
    ServiceName       : MSSQLSERVER
    SqlServiceType    : 1
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=3,PropertyName="CLUSTERED",ServiceName="MSSQLSERVER",SqlServiceType=1
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=3,PropertyName="CLUSTERED",ServiceName="MSSQLSERVER"
                        ,SqlServiceType=1
    IsReadOnly        : True
    PropertyIndex     : 3
    PropertyName      : CLUSTERED
    PropertyNumValue  : 0
    PropertyStrValue  :
    PropertyValueType : 1
    ServiceName       : MSSQLSERVER
    SqlServiceType    : 1
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=4,PropertyName="INSTALLPATH",ServiceName="MSSQLSERVER",SqlServiceType=1
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=4,PropertyName="INSTALLPATH",ServiceName="MSSQLSERVE
                        R",SqlServiceType=1
    IsReadOnly        : True
    PropertyIndex     : 4
    PropertyName      : INSTALLPATH
    PropertyNumValue  :
    PropertyStrValue  : InstallPath
    PropertyValueType : 0
    ServiceName       : MSSQLSERVER
    SqlServiceType    : 1
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=5,PropertyName="DATAPATH",ServiceName="MSSQLSERVER",SqlServiceType=1
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=5,PropertyName="DATAPATH",ServiceName="MSSQLSERVER",
                        SqlServiceType=1
    IsReadOnly        : True
    PropertyIndex     : 5
    PropertyName      : DATAPATH
    PropertyNumValue  :
    PropertyStrValue  : Pfad_zu_DB_Directory
    PropertyValueType : 0
    ServiceName       : MSSQLSERVER
    SqlServiceType    : 1
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=6,PropertyName="LANGUAGE",ServiceName="MSSQLSERVER",SqlServiceType=1
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=6,PropertyName="LANGUAGE",ServiceName="MSSQLSERVER",
                        SqlServiceType=1
    IsReadOnly        : True
    PropertyIndex     : 6
    PropertyName      : LANGUAGE
    PropertyNumValue  : 1033
    PropertyStrValue  :
    PropertyValueType : 2
    ServiceName       : MSSQLSERVER
    SqlServiceType    : 1
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=7,PropertyName="FILEVERSION",ServiceName="MSSQLSERVER",SqlServiceType=1
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=7,PropertyName="FILEVERSION",ServiceName="MSSQLSERVE
                        R",SqlServiceType=1
    IsReadOnly        : True
    PropertyIndex     : 7
    PropertyName      : FILEVERSION
    PropertyNumValue  :
    PropertyStrValue  : 2011.110.6248.0
    PropertyValueType : 0
    ServiceName       : MSSQLSERVER
    SqlServiceType    : 1
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=8,PropertyName="VSNAME",ServiceName="MSSQLSERVER",SqlServiceType=1
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=8,PropertyName="VSNAME",ServiceName="MSSQLSERVER",Sq
                        lServiceType=1
    IsReadOnly        : True
    PropertyIndex     : 8
    PropertyName      : VSNAME
    PropertyNumValue  :
    PropertyStrValue  :
    PropertyValueType : 0
    ServiceName       : MSSQLSERVER
    SqlServiceType    : 1
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=11,PropertyName="REGROOT",ServiceName="MSSQLSERVER",SqlServiceType=1
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=11,PropertyName="REGROOT",ServiceName="MSSQLSERVER",
                        SqlServiceType=1
    IsReadOnly        : True
    PropertyIndex     : 11
    PropertyName      : REGROOT
    PropertyNumValue  :
    PropertyStrValue  : Software\Microsoft\Microsoft SQL Server\MSSQL11.MSSQLSERVER
    PropertyValueType : 0
    ServiceName       : MSSQLSERVER
    SqlServiceType    : 1
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=9,PropertyName="SKU",ServiceName="MSSQLSERVER",SqlServiceType=1
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=9,PropertyName="SKU",ServiceName="MSSQLSERVER",SqlSe
                        rviceType=1
    IsReadOnly        : True
    PropertyIndex     : 9
    PropertyName      : SKU
    PropertyNumValue  : 2760240536
    PropertyStrValue  :
    PropertyValueType : 2
    ServiceName       : MSSQLSERVER
    SqlServiceType    : 1
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=10,PropertyName="SKUNAME",ServiceName="MSSQLSERVER",SqlServiceType=1
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=10,PropertyName="SKUNAME",ServiceName="MSSQLSERVER",
                        SqlServiceType=1
    IsReadOnly        : True
    PropertyIndex     : 10
    PropertyName      : SKUNAME
    PropertyNumValue  :
    PropertyStrValue  : Standard Edition (64-bit)
    PropertyValueType : 0
    ServiceName       : MSSQLSERVER
    SqlServiceType    : 1
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=12,PropertyName="INSTANCEID",ServiceName="MSSQLSERVER",SqlServiceType=1
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=12,PropertyName="INSTANCEID",ServiceName="MSSQLSERVE
                        R",SqlServiceType=1
    IsReadOnly        : True
    PropertyIndex     : 12
    PropertyName      : INSTANCEID
    PropertyNumValue  :
    PropertyStrValue  : MSSQL11.MSSQLSERVER
    PropertyValueType : 0
    ServiceName       : MSSQLSERVER
    SqlServiceType    : 1
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=14,PropertyName="ERRORREPORTING",ServiceName="MSSQLSERVER",SqlServiceType=1
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=14,PropertyName="ERRORREPORTING",ServiceName="MSSQLS
                        ERVER",SqlServiceType=1
    IsReadOnly        : False
    PropertyIndex     : 14
    PropertyName      : ERRORREPORTING
    PropertyNumValue  : 0
    PropertyStrValue  :
    PropertyValueType : 1
    ServiceName       : MSSQLSERVER
    SqlServiceType    : 1
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=15,PropertyName="DUMPDIR",ServiceName="MSSQLSERVER",SqlServiceType=1
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=15,PropertyName="DUMPDIR",ServiceName="MSSQLSERVER",
                        SqlServiceType=1
    IsReadOnly        : False
    PropertyIndex     : 15
    PropertyName      : DUMPDIR
    PropertyNumValue  :
    PropertyStrValue  : Pfad_zu_Directory\LOG\
    PropertyValueType : 0
    ServiceName       : MSSQLSERVER
    SqlServiceType    : 1
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=16,PropertyName="SQMREPORTING",ServiceName="MSSQLSERVER",SqlServiceType=1
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=16,PropertyName="SQMREPORTING",ServiceName="MSSQLSER
                        VER",SqlServiceType=1
    IsReadOnly        : False
    PropertyIndex     : 16
    PropertyName      : SQMREPORTING
    PropertyNumValue  : 0
    PropertyStrValue  :
    PropertyValueType : 1
    ServiceName       : MSSQLSERVER
    SqlServiceType    : 1
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=17,PropertyName="ISWOW64",ServiceName="MSSQLSERVER",SqlServiceType=1
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=17,PropertyName="ISWOW64",ServiceName="MSSQLSERVER",
                        SqlServiceType=1
    IsReadOnly        : True
    PropertyIndex     : 17
    PropertyName      : ISWOW64
    PropertyNumValue  : 0
    PropertyStrValue  :
    PropertyValueType : 1
    ServiceName       : MSSQLSERVER
    SqlServiceType    : 1
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=1,PropertyName="INSTANCEID",ServiceName="SQLBrowser",SqlServiceType=7
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=1,PropertyName="INSTANCEID",ServiceName="SQLBrowser"
                        ,SqlServiceType=7
    IsReadOnly        : True
    PropertyIndex     : 1
    PropertyName      : INSTANCEID
    PropertyNumValue  :
    PropertyStrValue  : MSSQL11.MSSQLSERVER
    PropertyValueType : 0
    ServiceName       : SQLBrowser
    SqlServiceType    : 7
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=0,PropertyName="CLUSTERED",ServiceName="SQLBrowser",SqlServiceType=7
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=0,PropertyName="CLUSTERED",ServiceName="SQLBrowser",
                        SqlServiceType=7
    IsReadOnly        : True
    PropertyIndex     : 0
    PropertyName      : CLUSTERED
    PropertyNumValue  : 0
    PropertyStrValue  :
    PropertyValueType : 1
    ServiceName       : SQLBrowser
    SqlServiceType    : 7
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=2,PropertyName="ERRORREPORTING",ServiceName="SQLBrowser",SqlServiceType=7
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=2,PropertyName="ERRORREPORTING",ServiceName="SQLBrow
                        ser",SqlServiceType=7
    IsReadOnly        : False
    PropertyIndex     : 2
    PropertyName      : ERRORREPORTING
    PropertyNumValue  : 0
    PropertyStrValue  :
    PropertyValueType : 1
    ServiceName       : SQLBrowser
    SqlServiceType    : 7
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=3,PropertyName="DUMPDIR",ServiceName="SQLBrowser",SqlServiceType=7
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=3,PropertyName="DUMPDIR",ServiceName="SQLBrowser",Sq
                        lServiceType=7
    IsReadOnly        : False
    PropertyIndex     : 3
    PropertyName      : DUMPDIR
    PropertyNumValue  :
    PropertyStrValue  : Pfad_zu_Directory\LOG\
    PropertyValueType : 0
    ServiceName       : SQLBrowser
    SqlServiceType    : 7
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=4,PropertyName="SQMREPORTING",ServiceName="SQLBrowser",SqlServiceType=7
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=4,PropertyName="SQMREPORTING",ServiceName="SQLBrowse
                        r",SqlServiceType=7
    IsReadOnly        : False
    PropertyIndex     : 4
    PropertyName      : SQMREPORTING
    PropertyNumValue  : 0
    PropertyStrValue  :
    PropertyValueType : 1
    ServiceName       : SQLBrowser
    SqlServiceType    : 7
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=5,PropertyName="BROWSER",ServiceName="SQLBrowser",SqlServiceType=7
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=5,PropertyName="BROWSER",ServiceName="SQLBrowser",Sq
                        lServiceType=7
    IsReadOnly        : False
    PropertyIndex     : 5
    PropertyName      : BROWSER
    PropertyNumValue  : 1
    PropertyStrValue  :
    PropertyValueType : 1
    ServiceName       : SQLBrowser
    SqlServiceType    : 7
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=6,PropertyName="ISWOW64",ServiceName="SQLBrowser",SqlServiceType=7
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=6,PropertyName="ISWOW64",ServiceName="SQLBrowser",Sq
                        lServiceType=7
    IsReadOnly        : True
    PropertyIndex     : 6
    PropertyName      : ISWOW64
    PropertyNumValue  : 0
    PropertyStrValue  :
    PropertyValueType : 1
    ServiceName       : SQLBrowser
    SqlServiceType    : 7
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=3,PropertyName="ERRORREPORTING",ServiceName="SQLSERVERAGENT",SqlServiceType=
                        2
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=3,PropertyName="ERRORREPORTING",ServiceName="SQLSERV
                        ERAGENT",SqlServiceType=2
    IsReadOnly        : False
    PropertyIndex     : 3
    PropertyName      : ERRORREPORTING
    PropertyNumValue  : 0
    PropertyStrValue  :
    PropertyValueType : 1
    ServiceName       : SQLSERVERAGENT
    SqlServiceType    : 2
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=4,PropertyName="DUMPDIR",ServiceName="SQLSERVERAGENT",SqlServiceType=2
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=4,PropertyName="DUMPDIR",ServiceName="SQLSERVERAGENT
                        ",SqlServiceType=2
    IsReadOnly        : False
    PropertyIndex     : 4
    PropertyName      : DUMPDIR
    PropertyNumValue  :
    PropertyStrValue  : Pfad_zu_Directory\LOG\
    PropertyValueType : 0
    ServiceName       : SQLSERVERAGENT
    SqlServiceType    : 2
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=5,PropertyName="SQMREPORTING",ServiceName="SQLSERVERAGENT",SqlServiceType=2
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=5,PropertyName="SQMREPORTING",ServiceName="SQLSERVER
                        AGENT",SqlServiceType=2
    IsReadOnly        : False
    PropertyIndex     : 5
    PropertyName      : SQMREPORTING
    PropertyNumValue  : 0
    PropertyStrValue  :
    PropertyValueType : 1
    ServiceName       : SQLSERVERAGENT
    SqlServiceType    : 2
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=1,PropertyName="INSTANCEID",ServiceName="SQLSERVERAGENT",SqlServiceType=2
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=1,PropertyName="INSTANCEID",ServiceName="SQLSERVERAG
                        ENT",SqlServiceType=2
    IsReadOnly        : True
    PropertyIndex     : 1
    PropertyName      : INSTANCEID
    PropertyNumValue  :
    PropertyStrValue  : MSSQL11.MSSQLSERVER
    PropertyValueType : 0
    ServiceName       : SQLSERVERAGENT
    SqlServiceType    : 2
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=0,PropertyName="CLUSTERED",ServiceName="SQLSERVERAGENT",SqlServiceType=2
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=0,PropertyName="CLUSTERED",ServiceName="SQLSERVERAGE
                        NT",SqlServiceType=2
    IsReadOnly        : True
    PropertyIndex     : 0
    PropertyName      : CLUSTERED
    PropertyNumValue  : 0
    PropertyStrValue  :
    PropertyValueType : 1
    ServiceName       : SQLSERVERAGENT
    SqlServiceType    : 2
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=2,PropertyName="VSNAME",ServiceName="SQLSERVERAGENT",SqlServiceType=2
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=2,PropertyName="VSNAME",ServiceName="SQLSERVERAGENT"
                        ,SqlServiceType=2
    IsReadOnly        : True
    PropertyIndex     : 2
    PropertyName      : VSNAME
    PropertyNumValue  :
    PropertyStrValue  :
    PropertyValueType : 0
    ServiceName       : SQLSERVERAGENT
    SqlServiceType    : 2
    PSComputerName    : HostName

    __GENUS           : 2
    __CLASS           : SQL_2012
    __SUPERCLASS      :
    __DYNASTY         : SQL_2012
    __RELPATH         : SQL_2012.PropertyIndex=6,PropertyName="ISWOW64",ServiceName="SQLSERVERAGENT",SqlServiceType=2
    __PROPERTY_COUNT  : 8
    __DERIVATION      : {}
    __SERVER          : HostName
    __NAMESPACE       : root\cimv2
    __PATH            : \\HostName\root\cimv2:SQL_2012.PropertyIndex=6,PropertyName="ISWOW64",ServiceName="SQLSERVERAGENT
                        ",SqlServiceType=2
    IsReadOnly        : True
    PropertyIndex     : 6
    PropertyName      : ISWOW64
    PropertyNumValue  : 0
    PropertyStrValue  :
    PropertyValueType : 1
    ServiceName       : SQLSERVERAGENT
    SqlServiceType    : 2
    PSComputerName    : HostName

    Thursday, October 05, 2017 2:28 PM
  • In der Klasse sind also Instanzen vorhanden, also muss unterwegs etwas verloren gehen --> dataldr.log auf dem Site Server.

    Torsten Meringer | http://www.mssccmfaq.de

    Thursday, October 05, 2017 9:10 PM
    Answerer