SqlService, ROOT\Microsoft\SqlServer\ComputerManagement12 - Instances

Class | Methods (7) | Properties (15) | Qualifiers (3) | Instances (5) | Namespaces (2)
Samples: VB Script | C# | VB.Net | Search on:Microsoft

Instances of SqlService

This section contains sample wmi instances of SqlService class with their properties from Microsoft Windows Server 2012 R2 Datacenter Evaluation.

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlService.ServiceName="MSSQLFDLauncher",SQLServiceType=9

Properties={
   'AcceptPause' : False //Boolean, 0x0
   'AcceptStop' : True //Boolean, 0xFFFFFFFF
   'BinaryPath' : '"C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\fdlauncher.exe" -s MSSQL12.MSSQLSERVER' //String
   'Dependencies' : [] //Variant()
   'Description' : 'Service to launch full-text filter daemon process which will perform document filtering and word breaking for SQL Server full-text search. Disabling this service will make full-text search features of SQL Server unavailable.' //String
   'DisplayName' : 'SQL Full-text Filter Daemon Launcher (MSSQLSERVER)' //String
   'ErrorControl' : 1 //Long, 0x1
   'ExitCode' : 0 //Long, 0x0
   'HostName' : '.' //String
   'ProcessId' : 5240 //Long, 0x1478
   'ServiceName' : 'MSSQLFDLauncher' //String
   'SQLServiceType' : 9 //Long, 0x9
   'StartMode' : 3 //Long, 0x3
   'StartName' : 'NT Service\MSSQLFDLauncher' //String
   'State' : 4 //Long, 0x4
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlService.ServiceName="MSSQLSERVER",SQLServiceType=1

Properties={
   'AcceptPause' : True //Boolean, 0xFFFFFFFF
   'AcceptStop' : True //Boolean, 0xFFFFFFFF
   'BinaryPath' : '"C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER' //String
   'Dependencies' : ['SQLSERVERAGENT'] //Variant()
   'Description' : 'Provides storage, processing and controlled access of data, and rapid transaction processing.' //String
   'DisplayName' : 'SQL Server (MSSQLSERVER)' //String
   'ErrorControl' : 1 //Long, 0x1
   'ExitCode' : 0 //Long, 0x0
   'HostName' : '.' //String
   'ProcessId' : 2228 //Long, 0x8B4
   'ServiceName' : 'MSSQLSERVER' //String
   'SQLServiceType' : 1 //Long, 0x1
   'StartMode' : 2 //Long, 0x2
   'StartName' : 'NT Service\MSSQLSERVER' //String
   'State' : 4 //Long, 0x4
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlService.ServiceName="ReportServer",SQLServiceType=6

Properties={
   'AcceptPause' : False //Boolean, 0x0
   'AcceptStop' : True //Boolean, 0xFFFFFFFF
   'BinaryPath' : '"C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\ReportServer\bin\ReportingServicesService.exe"' //String
   'Dependencies' : [] //Variant()
   'Description' : 'Manages, executes, renders, schedules and delivers reports.' //String
   'DisplayName' : 'SQL Server Reporting Services (MSSQLSERVER)' //String
   'ErrorControl' : 1 //Long, 0x1
   'ExitCode' : 0 //Long, 0x0
   'HostName' : '.' //String
   'ProcessId' : 2544 //Long, 0x9F0
   'ServiceName' : 'ReportServer' //String
   'SQLServiceType' : 6 //Long, 0x6
   'StartMode' : 2 //Long, 0x2
   'StartName' : 'NT Service\ReportServer' //String
   'State' : 4 //Long, 0x4
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlService.ServiceName="SQLBrowser",SQLServiceType=7

Properties={
   'AcceptPause' : False //Boolean, 0x0
   'AcceptStop' : False //Boolean, 0x0
   'BinaryPath' : '"C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe"' //String
   'Dependencies' : [] //Variant()
   'Description' : 'Provides SQL Server connection information to client computers.' //String
   'DisplayName' : 'SQL Server Browser' //String
   'ErrorControl' : 1 //Long, 0x1
   'ExitCode' : 1077 //Long, 0x435
   'HostName' : '.' //String
   'ProcessId' : 0 //Long, 0x0
   'ServiceName' : 'SQLBrowser' //String
   'SQLServiceType' : 7 //Long, 0x7
   'StartMode' : 4 //Long, 0x4
   'StartName' : 'NT AUTHORITY\LOCALSERVICE' //String
   'State' : 1 //Long, 0x1
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlService.ServiceName="SQLSERVERAGENT",SQLServiceType=2

Properties={
   'AcceptPause' : False //Boolean, 0x0
   'AcceptStop' : False //Boolean, 0x0
   'BinaryPath' : '"C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\SQLAGENT.EXE" -i MSSQLSERVER' //String
   'Dependencies' : [] //Variant()
   'Description' : 'Executes jobs, monitors SQL Server, fires alerts, and allows automation of some administrative tasks.' //String
   'DisplayName' : 'SQL Server Agent (MSSQLSERVER)' //String
   'ErrorControl' : 1 //Long, 0x1
   'ExitCode' : 1077 //Long, 0x435
   'HostName' : '.' //String
   'ProcessId' : 0 //Long, 0x0
   'ServiceName' : 'SQLSERVERAGENT' //String
   'SQLServiceType' : 2 //Long, 0x2
   'StartMode' : 4 //Long, 0x4
   'StartName' : 'NT AUTHORITY\NETWORKSERVICE' //String
   'State' : 1 //Long, 0x1
}
comments powered by Disqus
online utility - toplist
WUtils.com