Fragensteller
SQL Server Inventory Report
Frage
Alle Antworten
-
Als Start: http://sccmzone.ro/sql-detection-and-report oder so https://sccm-zone.com/sql-version-detection-and-report-sccm-2012-r2-12f299b5e63b
Torsten Meringer | http://www.mssccmfaq.de
-
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
- Bearbeitet Julian79 Donnerstag, 14. September 2017 11:43
-
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
-
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
-
Die Query aus dem rdl kannst Du auch im SQL Management Studio ausführen.
Torsten Meringer | http://www.mssccmfaq.de
-
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 -
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
-
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'.
-
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
-
Schaue Dir doch mal einen fehlenden Server im Resource-Explorer an. Werden die SQL-Daten dort gelistet?
Torsten Meringer | http://www.mssccmfaq.de
-
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
- Bearbeitet Julian79 Mittwoch, 4. Oktober 2017 09:23
-
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
-
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
- Bearbeitet Julian79 Donnerstag, 5. Oktober 2017 12:40
-
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
-
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;- Bearbeitet Julian79 Donnerstag, 5. Oktober 2017 13:12
-
-
__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 -
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
