ServerName                                                                                                                       SQLVersion                                                                                                                                                                                                                                                       Edition                                                                                                                                                                                                                                                          ProductVersion                                                                                                                                                                                                                                                   ProductLevel                                                                                                                                                                                                                                                     EngineEdition                                                                                                                                                                                                                                                    IsClustered                                                                                                                                                                                                                                                      MachineName                                                                                                                                                                                                                                                      InstanceName                                                                                                                                                                                                                                                     ServerCollation                                                                                                                                                                                                                                                  WindowsAuthOnly
-------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PANTHEON-WS2016\DATALAB                                                                                                          Microsoft SQL Server 2019 (RTM-GDR) (KB5046859) - 15.0.2130.3 (X64) 
	Oct 18 2024 15:25:23 
	Copyright (C) 2019 Microsoft Corporation
	Standard Edition (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Build 14393: ) (Hypervisor)
                        Standard Edition (64-bit)                                                                                                                                                                                                                                        15.0.2130.3                                                                                                                                                                                                                                                      RTM                                                                                                                                                                                                                                                              2                                                                                                                                                                                                                                                                0                                                                                                                                                                                                                                                                PANTHEON-WS2016                                                                                                                                                                                                                                                  DATALAB                                                                                                                                                                                                                                                          Slovenian_CI_AS                                                                                                                                                                                                                                                  0

(1 row(s) affected)

cpu_count   scheduler_count hyperthread_ratio PhysicalMemoryMB     sqlserver_start_time
----------- --------------- ----------------- -------------------- -----------------------
6           6               2                 12286                2026-07-25 13:11:14.260

(1 row(s) affected)

volume_mount_point                                                                                                                                                                                                                                               logical_volume_name                                                                                                                                                                                                                                              TotalGB              FreeGB
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------- --------------------
C:\                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               249                  47

(1 row(s) affected)

name                                                                                                                             database_id compatibility_level recovery_model_desc                                          state_desc                                                   create_date
-------------------------------------------------------------------------------------------------------------------------------- ----------- ------------------- ------------------------------------------------------------ ------------------------------------------------------------ -----------------------
DUN_N_BRADSTREET                                                                                                                 5           150                 SIMPLE                                                       ONLINE                                                       2022-01-11 11:29:41.833
master                                                                                                                           1           150                 SIMPLE                                                       ONLINE                                                       2003-04-08 09:13:36.390
model                                                                                                                            3           150                 FULL                                                         ONLINE                                                       2003-04-08 09:13:36.390
msdb                                                                                                                             4           150                 SIMPLE                                                       ONLINE                                                       2019-09-24 14:21:42.270
tempdb                                                                                                                           2           150                 SIMPLE                                                       ONLINE                                                       2026-07-25 13:11:16.933

(5 row(s) affected)

DatabaseName                                                                                                                     SizeMB
-------------------------------------------------------------------------------------------------------------------------------- -----------
DUN_N_BRADSTREET                                                                                                                 7750
tempdb                                                                                                                           56
msdb                                                                                                                             43
model                                                                                                                            16
master                                                                                                                           7

(5 row(s) affected)

DatabaseName                                                                                                                     name                                                                                                                             type_desc                                                    physical_name                                                                                                                                                                                                                                                    SizeMB
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -----------
DUN_N_BRADSTREET                                                                                                                 DataLab_Data                                                                                                                     ROWS                                                         C:\Databases\DUN_N_BRADSTREET.mdf                                                                                                                                                                                                                                5254
DUN_N_BRADSTREET                                                                                                                 DataLab_Log                                                                                                                      LOG                                                          C:\Databases\Logs\DUN_N_BRADSTREET.ldf                                                                                                                                                                                                                           2496
master                                                                                                                           master                                                                                                                           ROWS                                                         C:\Databases\MSSQL15.DATALAB\MSSQL\Data\MSSQL15.DATALAB\MSSQL\DATA\master.mdf                                                                                                                                                                                    5
master                                                                                                                           mastlog                                                                                                                          LOG                                                          C:\Databases\MSSQL15.DATALAB\MSSQL\Data\MSSQL15.DATALAB\MSSQL\DATA\mastlog.ldf                                                                                                                                                                                   2
model                                                                                                                            modeldev                                                                                                                         ROWS                                                         C:\Databases\MSSQL15.DATALAB\MSSQL\Data\MSSQL15.DATALAB\MSSQL\DATA\model.mdf                                                                                                                                                                                     8
model                                                                                                                            modellog                                                                                                                         LOG                                                          C:\Databases\MSSQL15.DATALAB\MSSQL\Data\MSSQL15.DATALAB\MSSQL\DATA\modellog.ldf                                                                                                                                                                                  8
msdb                                                                                                                             MSDBData                                                                                                                         ROWS                                                         C:\Databases\MSSQL15.DATALAB\MSSQL\Data\MSSQL15.DATALAB\MSSQL\DATA\MSDBData.mdf                                                                                                                                                                                  21
msdb                                                                                                                             MSDBLog                                                                                                                          LOG                                                          C:\Databases\MSSQL15.DATALAB\MSSQL\Data\MSSQL15.DATALAB\MSSQL\DATA\MSDBLog.ldf                                                                                                                                                                                   21
tempdb                                                                                                                           tempdev                                                                                                                          ROWS                                                         C:\Databases\MSSQL15.DATALAB\MSSQL\Data\MSSQL15.DATALAB\MSSQL\DATA\tempdb.mdf                                                                                                                                                                                    8
tempdb                                                                                                                           templog                                                                                                                          LOG                                                          C:\Databases\MSSQL15.DATALAB\MSSQL\Data\MSSQL15.DATALAB\MSSQL\DATA\templog.ldf                                                                                                                                                                                   8
tempdb                                                                                                                           temp2                                                                                                                            ROWS                                                         C:\Databases\MSSQL15.DATALAB\MSSQL\Data\MSSQL15.DATALAB\MSSQL\DATA\tempdb_mssql_2.ndf                                                                                                                                                                            8
tempdb                                                                                                                           temp3                                                                                                                            ROWS                                                         C:\Databases\MSSQL15.DATALAB\MSSQL\Data\MSSQL15.DATALAB\MSSQL\DATA\tempdb_mssql_3.ndf                                                                                                                                                                            8
tempdb                                                                                                                           temp4                                                                                                                            ROWS                                                         C:\Databases\MSSQL15.DATALAB\MSSQL\Data\MSSQL15.DATALAB\MSSQL\DATA\tempdb_mssql_4.ndf                                                                                                                                                                            8
tempdb                                                                                                                           temp5                                                                                                                            ROWS                                                         C:\Databases\MSSQL15.DATALAB\MSSQL\Data\MSSQL15.DATALAB\MSSQL\DATA\tempdb_mssql_5.ndf                                                                                                                                                                            8
tempdb                                                                                                                           temp6                                                                                                                            ROWS                                                         C:\Databases\MSSQL15.DATALAB\MSSQL\Data\MSSQL15.DATALAB\MSSQL\DATA\tempdb_mssql_6.ndf                                                                                                                                                                            8

(15 row(s) affected)

name                                                                                                                             type_desc                                                    default_database_name                                                                                                            create_date             modify_date
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------ -------------------------------------------------------------------------------------------------------------------------------- ----------------------- -----------------------
##MS_PolicyEventProcessingLogin##                                                                                                SQL_LOGIN                                                    master                                                                                                                           2024-12-15 18:27:29.230 2024-12-15 18:27:29.243
##MS_PolicyTsqlExecutionLogin##                                                                                                  SQL_LOGIN                                                    master                                                                                                                           2019-09-24 14:21:53.570 2024-12-15 18:27:29.250
AC                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.620 2025-03-27 12:32:38.500
AD                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.670 2025-11-07 13:26:53.780
ADYU                                                                                                                             SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.677 2025-03-27 12:32:38.503
AG                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.687 2025-03-27 12:32:38.507
AK                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.693 2025-03-27 12:32:38.507
AL                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.700 2025-03-27 12:32:38.507
AMD                                                                                                                              SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.707 2025-03-27 12:32:38.510
ANAK                                                                                                                             SQL_LOGIN                                                    master                                                                                                                           2024-01-23 13:18:15.757 2024-01-23 13:19:03.003
BISNODE\pawdomres                                                                                                                WINDOWS_LOGIN                                                master                                                                                                                           2026-08-10 13:09:54.260 2026-08-10 13:09:54.280
BJ                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.713 2025-03-27 12:32:38.510
BO                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.720 2025-03-27 12:32:38.510
BS                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.723 2025-03-27 12:32:38.513
BZ                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.730 2025-03-27 12:32:38.513
DB                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.737 2025-03-27 12:32:38.513
DK                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.743 2025-03-27 12:32:38.517
DO                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.750 2025-03-27 12:32:38.517
DR                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.753 2025-03-27 12:32:38.517
DT                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.760 2025-03-27 12:32:38.520
EA                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2025-10-30 12:53:18.747 2025-11-07 13:26:08.453
EK                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.767 2025-03-27 12:32:38.520
ES                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.770 2025-03-27 12:32:38.520
Fisherman                                                                                                                        SQL_LOGIN                                                    master                                                                                                                           2022-01-14 13:39:47.837 2022-09-28 11:39:30.063
GC                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-09-05 14:46:10.577 2022-09-05 14:46:42.710
GS                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.777 2025-03-27 12:32:38.523
IJ                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2023-04-18 14:13:23.693 2023-04-18 14:13:23.703
IK                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.783 2025-03-27 12:32:38.523
IN                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 14:52:38.570 2025-03-27 12:32:38.527
JG                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.820 2025-03-27 12:32:38.527
JT                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.827 2025-03-27 12:32:38.527
LC                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.833 2025-03-27 12:32:38.530
linkedServerUser                                                                                                                 SQL_LOGIN                                                    master                                                                                                                           2022-01-14 13:01:26.357 2022-01-14 13:02:51.237
LOCAL\a.timotijevic                                                                                                              WINDOWS_LOGIN                                                master                                                                                                                           2022-01-11 09:54:28.407 2022-01-11 09:54:28.417
MAJ                                                                                                                              SQL_LOGIN                                                    master                                                                                                                           2023-04-18 14:16:39.223 2023-04-18 14:21:22.060
MD                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.840 2025-03-27 12:32:38.530
MG                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.847 2025-03-27 12:32:38.530
MJ                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.850 2025-03-27 12:32:38.533
MK                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2024-02-22 12:12:07.973 2024-02-22 12:12:07.983
MKOVAC                                                                                                                           SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.860 2025-03-27 12:32:38.533
MP                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.867 2025-03-27 12:32:38.537
NG                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.870 2025-03-27 12:32:38.537
NM                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2023-07-05 16:04:22.973 2023-07-05 16:04:28.590
NN                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.877 2025-03-27 12:32:38.540
NR                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.883 2025-03-27 12:32:38.540
NT                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.890 2025-03-27 12:32:38.540
NT AUTHORITY\SYSTEM                                                                                                              WINDOWS_LOGIN                                                master                                                                                                                           2022-01-11 09:54:28.433 2022-01-11 09:54:28.440
NT Service\MSSQL$DATALAB                                                                                                         WINDOWS_LOGIN                                                master                                                                                                                           2022-01-11 09:54:28.427 2022-01-11 09:54:28.437
NT SERVICE\SQLAgent$DATALAB                                                                                                      WINDOWS_LOGIN                                                master                                                                                                                           2022-01-11 09:54:29.070 2022-01-11 09:54:29.080
NT SERVICE\SQLTELEMETRY$DATALAB                                                                                                  WINDOWS_LOGIN                                                master                                                                                                                           2022-01-11 09:54:29.640 2022-01-11 09:54:29.647
NT SERVICE\SQLWriter                                                                                                             WINDOWS_LOGIN                                                master                                                                                                                           2022-01-11 09:54:28.413 2022-01-11 09:54:28.423
NT SERVICE\Winmgmt                                                                                                               WINDOWS_LOGIN                                                master                                                                                                                           2022-01-11 09:54:28.420 2022-01-11 09:54:28.430
NV                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.897 2025-03-27 12:32:38.540
NŽ                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.903 2025-03-27 12:32:38.543
PB                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.907 2025-03-27 12:32:38.543
PM                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.917 2025-03-27 12:32:38.543
sa                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2003-04-08 09:10:35.460 2026-08-10 13:07:37.247
SD                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.923 2025-03-27 12:32:38.547
SI                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.930 2025-03-27 12:32:38.547
SM                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.937 2025-03-27 12:32:38.547
SS                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.943 2025-03-27 12:32:38.550
ST                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.950 2025-03-27 12:32:38.550
VB                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.957 2025-03-27 12:32:38.550
VDCORP                                                                                                                           SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.967 2025-03-27 12:32:38.550
z-impvuser                                                                                                                       SQL_LOGIN                                                    master                                                                                                                           2022-09-28 11:12:04.653 2022-09-28 11:12:04.667
ZZ                                                                                                                               SQL_LOGIN                                                    master                                                                                                                           2022-01-11 11:34:13.973 2025-03-27 12:32:38.553

(66 row(s) affected)

SRV_NAME                                                                                                                         SRV_PROVIDERNAME                                                                                                                 SRV_PRODUCT                                                                                                                      SRV_DATASOURCE                                                                                                                                                                                                                                                   SRV_PROVIDERSTRING                                                                                                                                                                                                                                               SRV_LOCATION                                                                                                                                                                                                                                                     SRV_CAT
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------
PANTHEON-WS2016\DATALAB                                                                                                          SQLNCLI                                                                                                                          SQL Server                                                                                                                       PANTHEON-WS2016\DATALAB                                                                                                                                                                                                                                          NULL                                                                                                                                                                                                                                                             NULL                                                                                                                                                                                                                                                             NULL

(1 row(s) affected)

name                                                                                                                             enabled date_created
-------------------------------------------------------------------------------------------------------------------------------- ------- -----------------------
syspolicy_purge_history                                                                                                          1       2022-01-11 09:54:29.140

(1 row(s) affected)

JobName                                                                                                                          ScheduleName                                                                                                                     enabled
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -----------
syspolicy_purge_history                                                                                                          syspolicy_purge_history_schedule                                                                                                 1

(1 row(s) affected)

profile_id  name                                                                                                                             description                                                                                                                                                                                                                                                      last_mod_datetime       last_mod_user
----------- -------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------- --------------------------------------------------------------------------------------------------------------------------------

(0 row(s) affected)

credential_id name                                                                                                                             credential_identity                                                                                                                                                                                                                                              create_date             modify_date             target_type                                                  target_id
------------- -------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------- ----------------------- ------------------------------------------------------------ -----------

(0 row(s) affected)

name                                minimum     maximum     config_value run_value
----------------------------------- ----------- ----------- ------------ -----------
allow polybase export               0           1           0            0
allow updates                       0           1           0            0
backup checksum default             0           1           0            0
backup compression default          0           1           0            0
clr enabled                         0           1           1            1
column encryption enclave type      0           2           0            0
contained database authentication   0           1           0            0
cross db ownership chaining         0           1           0            0
default language                    0           9999        0            0
external scripts enabled            0           1           0            0
filestream access level             0           2           0            0
hadoop connectivity                 0           7           0            0
max text repl size (B)              -1          2147483647  65536        65536
nested triggers                     0           1           1            1
polybase enabled                    0           1           0            0
polybase network encryption         0           1           1            1
remote access                       0           1           1            1
remote admin connections            0           1           0            0
remote data archive                 0           1           0            0
remote login timeout (s)            0           2147483647  10           10
remote proc trans                   0           1           0            0
remote query timeout (s)            0           2147483647  600          600
server trigger recursion            0           1           1            1
show advanced options               0           1           0            0
user options                        0           32767       0            0

servicename                                                                                                                                                                                                                                                      startup_type_desc                                                                                                                                                                                                                                                status_desc                                                                                                                                                                                                                                                      service_account
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL Server (DATALAB)                                                                                                                                                                                                                                             Automatic                                                                                                                                                                                                                                                        Running                                                                                                                                                                                                                                                          NT Service\MSSQL$DATALAB
SQL Server Agent (DATALAB)                                                                                                                                                                                                                                       Automatic                                                                                                                                                                                                                                                        Running                                                                                                                                                                                                                                                          NT Service\SQLAgent$DATALAB
SQL Full-text Filter Daemon Launcher (DATALAB)                                                                                                                                                                                                                   Manual                                                                                                                                                                                                                                                           Running                                                                                                                                                                                                                                                          NT Service\MSSQLFDLauncher$DATALAB
SQL Server Launchpad (DATALAB)                                                                                                                                                                                                                                   Automatic                                                                                                                                                                                                                                                        Running                                                                                                                                                                                                                                                          NT Service\MSSQLLaunchpad$DATALAB

(4 row(s) affected)

name                                                                                                                             endpoint_id principal_id protocol protocol_desc                                                type type_desc                                                    state state_desc                                                   is_admin_endpoint
-------------------------------------------------------------------------------------------------------------------------------- ----------- ------------ -------- ------------------------------------------------------------ ---- ------------------------------------------------------------ ----- ------------------------------------------------------------ -----------------
Dedicated Admin Connection                                                                                                       1           1            2        TCP                                                          2    TSQL                                                         0     STARTED                                                      1
TSQL Local Machine                                                                                                               2           1            4        SHARED_MEMORY                                                2    TSQL                                                         0     STARTED                                                      0
TSQL Named Pipes                                                                                                                 3           1            3        NAMED_PIPES                                                  2    TSQL                                                         0     STARTED                                                      0
TSQL Default TCP                                                                                                                 4           1            2        TCP                                                          2    TSQL                                                         0     STARTED                                                      0
TSQL Default VIA                                                                                                                 5           1            5        VIA                                                          2    TSQL                                                         0     STARTED                                                      0

(5 row(s) affected)

Linked Server                                                                                                                    Local Login                                                                                                                      Is Self Mapping Remote Login
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- --------------- --------------------------------------------------------------------------------------------------------------------------------
PANTHEON-WS2016\DATALAB                                                                                                          NULL                                                                                                                             1               NULL

(1 row(s) affected)

name                                                                                                                             certificate_id principal_id pvt_key_encryption_type pvt_key_encryption_type_desc                                 is_active_for_begin_dialog issuer_name                                                                                                                                                                                                                                                      cert_serial_number                                               sid                                                                                                                                                                          string_sid                                                                                                                       subject                                                                                                                                                                                                                                                          expiry_date             start_date              thumbprint                                                                                                                         attested_by                                                                                                                                                                                                                                                      pvt_key_last_backup_date key_length
-------------------------------------------------------------------------------------------------------------------------------- -------------- ------------ ----------------------- ------------------------------------------------------------ -------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------- ----------------------- ---------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------ -----------
##MS_SQLResourceSigningCertificate##                                                                                             101            1            NA                      NO_PRIVATE_KEY                                               0                          MS_SQLResourceSigningCertificate                                                                                                                                                                                                                                 2e 17 26 43 4c df b8 b6 45 dc 0b 76 10 f5 95 c9                  0x0106000000000009010000001B894C898334366A96AAB652C193AAF2135F3F80                                                                                                           S-1-9-1-2303494427-1781937283-1387702934-4071265217-2151636755                                                                   MS_SQLResourceSigningCertificate                                                                                                                                                                                                                                 2025-10-18 22:52:22.000 2024-10-18 22:52:22.000 0x1B894C898334366A96AAB652C193AAF2135F3F80                                                                                         NULL                                                                                                                                                                                                                                                             NULL                     2048
##MS_SQLReplicationSigningCertificate##                                                                                          102            1            NA                      NO_PRIVATE_KEY                                               0                          MS_SQLReplicationSigningCertificate                                                                                                                                                                                                                              77 2b 7a b5 63 7a a4 80 4c 88 7f 92 18 8f 34 92                  0x010600000000000901000000F60F6B2F622C7F9657DBECA33BA10227F16AD4F3                                                                                                           S-1-9-1-795545590-2524916834-2750208855-654483771-4090784497                                                                     MS_SQLReplicationSigningCertificate                                                                                                                                                                                                                              2025-10-18 22:52:22.000 2024-10-18 22:52:22.000 0xF60F6B2F622C7F9657DBECA33BA10227F16AD4F3                                                                                         NULL                                                                                                                                                                                                                                                             NULL                     2048
##MS_SQLAuthenticatorCertificate##                                                                                               103            1            NA                      NO_PRIVATE_KEY                                               0                          MS_SQLAuthenticatorCertificate                                                                                                                                                                                                                                   79 28 25 7e 17 44 af b8 4d 7f df e0 5d 03 c2 f2                  0x01060000000000090100000094C073DA39C09B421F2C2FC2CDCCF73032863D37                                                                                                           S-1-9-1-3665019028-1117503545-3257871391-821546189-926778930                                                                     MS_SQLAuthenticatorCertificate                                                                                                                                                                                                                                   2025-10-18 22:52:22.000 2024-10-18 22:52:22.000 0x94C073DA39C09B421F2C2FC2CDCCF73032863D37                                                                                         NULL                                                                                                                                                                                                                                                             NULL                     2048
##MS_AgentSigningCertificate##                                                                                                   104            1            NA                      NO_PRIVATE_KEY                                               1                          MS_AgentSigningCertificate                                                                                                                                                                                                                                       1f a5 56 36 69 e6 c4 97 4b 24 b5 40 9a 1c ac 21                  0x010600000000000901000000D6F23D713AA50B7B58D36F088367879A187A4966                                                                                                           S-1-9-1-1899885270-2064360762-141546328-2592565123-1716091416                                                                    MS_AgentSigningCertificate                                                                                                                                                                                                                                       2025-12-15 17:27:33.000 2024-12-15 17:27:33.000 0xD6F23D713AA50B7B58D36F088367879A187A4966                                                                                         NULL                                                                                                                                                                                                                                                             NULL                     2048
##MS_PolicySigningCertificate##                                                                                                  105            1            NA                      NO_PRIVATE_KEY                                               0                          MS_PolicySigningCertificate                                                                                                                                                                                                                                      4e c9 bd 1c 25 19 7c b1 47 a2 1e f0 40 1b 5f f2                  0x010600000000000901000000739950AD65750F67EE19145495B1363B249E0AB8                                                                                                           S-1-9-1-2907740531-1729066341-1410603502-993440149-3087703588                                                                    MS_PolicySigningCertificate                                                                                                                                                                                                                                      2025-10-18 22:52:22.000 2024-10-18 22:52:22.000 0x739950AD65750F67EE19145495B1363B249E0AB8                                                                                         NULL                                                                                                                                                                                                                                                             NULL                     2048
##MS_SmoExtendedSigningCertificate##                                                                                             106            1            NA                      NO_PRIVATE_KEY                                               0                          MS_SmoExtendedSigningCertificate                                                                                                                                                                                                                                 1c bc 24 59 ca 39 b7 a7 4a 46 e7 ac fd 36 e8 9e                  0x01060000000000090100000074EAD0837A0CD0A4906748BE3937BEC20150B190                                                                                                           S-1-9-1-2211506804-2765098106-3192416144-3267245881-2427539457                                                                   MS_SmoExtendedSigningCertificate                                                                                                                                                                                                                                 2025-10-18 22:52:22.000 2024-10-18 22:52:22.000 0x74EAD0837A0CD0A4906748BE3937BEC20150B190                                                                                         NULL                                                                                                                                                                                                                                                             NULL                     2048
##MS_SchemaSigningCertificateF5DC096FAF20C89D15C0E7B798CD384DACD92ADB##                                                          257            1            NA                      NO_PRIVATE_KEY                                               1                          MS_SchemaSigningCertificateF5DC096FAF20C89D15C0E7B798CD384DACD92ADB                                                                                                                                                                                              31 fe 52 a8 d3 97 53 a2 4f d8 0c 93 0c ec 33 ee                  0x0106000000000009010000008ACEBAADBFB4404F670942864B03807DB9D77253                                                                                                           S-1-9-1-2914700938-1329640639-2252474727-2105541451-1400035257                                                                   MS_SchemaSigningCertificateF5DC096FAF20C89D15C0E7B798CD384DACD92ADB                                                                                                                                                                                              2020-09-24 21:23:14.000 2019-09-24 21:23:14.000 0x8ACEBAADBFB4404F670942864B03807DB9D77253                                                                                         NULL                                                                                                                                                                                                                                                             NULL                     2048

(7 row(s) affected)

audit_id    name                                                                                                                             audit_guid                           create_date             modify_date             principal_id type type_desc                                                    on_failure on_failure_desc                                              is_state_enabled queue_delay predicate
----------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------------ ----------------------- ----------------------- ------------ ---- ------------------------------------------------------------ ---------- ------------------------------------------------------------ ---------------- ----------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

(0 row(s) affected)

server_specification_id name                                                                                                                             create_date             modify_date             audit_guid                           is_state_enabled
----------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------- ----------------------- ------------------------------------ ----------------

(0 row(s) affected)

group_id                             name                                                                                                                             resource_id                              resource_group_id                        failure_condition_level health_check_timeout automated_backup_preference automated_backup_preference_desc                             version basic_features dtc_support db_failover is_distributed cluster_type cluster_type_desc                                            required_synchronized_secondaries_to_commit sequence_number      is_contained
------------------------------------ -------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------- ---------------------------------------- ----------------------- -------------------- --------------------------- ------------------------------------------------------------ ------- -------------- ----------- ----------- -------------- ------------ ------------------------------------------------------------ ------------------------------------------- -------------------- ------------

(0 row(s) affected)

replica_id                           group_id                             replica_metadata_id replica_server_name                                                                                                                                                                                                                                              owner_sid                                                                                                                                                                    endpoint_url                                                                                                                                                                                                                                                     availability_mode availability_mode_desc                                       failover_mode failover_mode_desc                                           session_timeout primary_role_allow_connections primary_role_allow_connections_desc                          secondary_role_allow_connections secondary_role_allow_connections_desc                        create_date             modify_date             backup_priority read_only_routing_url                                                                                                                                                                                                                                            seeding_mode seeding_mode_desc                                            read_write_routing_url
------------------------------------ ------------------------------------ ------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------- ------------------------------------------------------------ ------------- ------------------------------------------------------------ --------------- ------------------------------ ------------------------------------------------------------ -------------------------------- ------------------------------------------------------------ ----------------------- ----------------------- --------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------ ------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

(0 row(s) affected)

replica_id                           group_id                             is_local role role_desc                                                    operational_state operational_state_desc                                       connected_state connected_state_desc                                         recovery_health recovery_health_desc                                         synchronization_health synchronization_health_desc                                  last_connect_error_number last_connect_error_description                                                                                                                                                                                                                                   last_connect_error_timestamp write_lease_remaining_ticks current_configuration_commit_start_time_utc
------------------------------------ ------------------------------------ -------- ---- ------------------------------------------------------------ ----------------- ------------------------------------------------------------ --------------- ------------------------------------------------------------ --------------- ------------------------------------------------------------ ---------------------- ------------------------------------------------------------ ------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------- --------------------------- -------------------------------------------

(0 row(s) affected)

