{"id":124,"date":"2019-12-30T07:51:38","date_gmt":"2019-12-30T07:51:38","guid":{"rendered":"https:\/\/datarebus.wordpress.com\/?p=124"},"modified":"2021-04-09T08:14:12","modified_gmt":"2021-04-09T08:14:12","slug":"sql-server-cpu-bilgileri","status":"publish","type":"post","link":"https:\/\/datarebus.com\/index.php\/2019\/12\/30\/sql-server-cpu-bilgileri\/","title":{"rendered":"Getting Information About Your Operating System from SQL SERVER by Scripts"},"content":{"rendered":"\n<p>You can get information about your operating system ,cpu and versions that your SQL is running on: <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img src=\"https:\/\/datarebus.files.wordpress.com\/2019\/12\/300px-sqlservermanagementstudio.jpg?w=300\" alt=\"\" class=\"wp-image-126\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-verse\"><strong><em>SELECT @@SERVERNAME AS [Server Name], @@VERSION AS [SQL Server and OS Version Info];<\/em>\n<\/strong>\ngives your server name and SQL SERVER version<\/pre>\n\n\n\n<pre class=\"wp-block-verse\"><em><strong>SELECT @@SERVERNAME AS [Server Name], createdate AS [SQL Server Install Date]\nFROM sys.syslogins\nWHERE loginname = N'NT AUTHORITY\\SYSTEM'\nOR loginname = N'NT AUTHORITY\\NETWORK SERVICE';<\/strong><\/em>\n\ngives your server name and install date of your SQL SERVER<\/pre>\n\n\n\n<pre class=\"wp-block-verse\">-- Get selected server properties (SQL Server 2014) (Query 3) (Server Properties)\nSELECT SERVERPROPERTY('MachineName') AS [MachineName], SERVERPROPERTY('ServerName') AS [ServerName],\nSERVERPROPERTY('InstanceName') AS [Instance], SERVERPROPERTY('IsClustered') AS [IsClustered],\nSERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS <em>[ComputerNamePhysicalNetBIOS],\nSERVERPROPERTY('Edition') AS [Edition], SERVERPROPERTY('ProductLevel') AS [ProductLevel],\nSERVERPROPERTY('ProductVersion') AS [ProductVersion], SERVERPROPERTY('ProcessID') AS [ProcessID],\nSERVERPROPERTY('Collation') AS [Collation], SERVERPROPERTY('IsFullTextInstalled') AS [IsFullTextInstalled],\nSERVERPROPERTY('IsIntegratedSecurityOnly') AS [IsIntegratedSecurityOnly],\nSERVERPROPERTY('IsHadrEnabled') AS [IsHadrEnabled], SERVERPROPERTY('HadrManagerStatus') AS [HadrManagerStatus],\nSERVERPROPERTY('IsXTPSupported') AS [IsXTPSupported];<\/em><\/pre>\n\n\n\n<p><em>SELECT windows_release, windows_service_pack_level,<br>windows_sku, os_language_version<br>FROM sys.dm_os_windows_info WITH (NOLOCK) OPTION (RECOMPILE);<\/em><\/p>\n\n\n\n<div class=\"wp-container-1 wp-block-group\"><div class=\"wp-block-group__inner-container\">\n<pre class=\"wp-block-verse\">EXEC xp_readerrorlog 0, 1, \"Manufacturer\";<\/pre>\n\n\n\n<pre class=\"wp-block-verse\">EXEC xp_instance_regread N'HKEY_LOCAL_MACHINE', N'HARDWARE\\DESCRIPTION\\System\\CentralProcessor\\0', N'ProcessorNameString';<\/pre>\n<\/div><\/div>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>You can get information about your operating system ,cpu and versions that your SQL is running on: SELECT @@SERVERNAME AS [Server Name], @@VERSION AS [SQL Server and OS Version Info]; gives your server name and SQL SERVER version SELECT @@SERVERNAME AS [Server Name], createdate AS [SQL Server Install Date] FROM sys.syslogins WHERE loginname = N&#8217;NT [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[],"_links":{"self":[{"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/posts\/124"}],"collection":[{"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/comments?post=124"}],"version-history":[{"count":1,"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/posts\/124\/revisions"}],"predecessor-version":[{"id":473,"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/posts\/124\/revisions\/473"}],"wp:attachment":[{"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/media?parent=124"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/categories?post=124"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/tags?post=124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}