SAP MSSPFNTOPS table - Display MSQSNAP table: Server set details in SAP

Description: Day (for Collector)
Field Name: DAYOW
Data Element: DAYOFWEEK
Data Type: CHAR
length (Dec): 7(0)
Check table:
Conversion Routine:
Domain Name: CHAR7
MemoryID:
AppClass: SDIN
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DAYOW

Description: Date
Field Name: RECORDDATE
Data Element: DATUM
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RECORDDATE

Description: Time
Field Name: RECORDTIME
Data Element: UZEIT
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: UZEIT
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RECORDTIME

Description: Version of the database management system.
Field Name: SQLVERSION
Data Element: MSQVERSN
Data Type: CHAR
length (Dec): 50(0)
Check table:
Conversion Routine:
Domain Name: CHAR50
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLVERSION

Description: SQL Server build number (corresponding to a Service Pack).
Field Name: SQLBUILDNM
Data Element: MSQDBVER
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLBUILDNM

Description: SQL Server edition: 'X' = Enterprise Ed., 'C' Cluster in use
Field Name: SQLEE
Data Element: MSQSSSQLEE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLEE

Description: Trace flags which are currently set for SQL Server.
Field Name: TRACEFLAGS
Data Element: MSQSSTFLG
Data Type: CHAR
length (Dec): 255(0)
Check table:
Conversion Routine:
Domain Name: CHAR255
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRACEFLAGS

Description: Configuration options set differ from current values ( ='X')
Field Name: PARAMDIFF
Data Element: MSQSSPDIFF
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARAMDIFF

Description: Hostname of the application server logged into SQL Server.
Field Name: HOSTNAME
Data Element: MSQHOSTNE
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: CHAR128
MemoryID:
AppClass: SPO
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOSTNAME

Description: Date and time of last SQL Server start.
Field Name: SQLSTARTTM
Data Element: MSQDBUPTME
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLSTARTTM

Description: Number of user connections to the SQL Server system
Field Name: USERCONCTS
Data Element: MSSPSUSCON
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USERCONCTS

Description: Operating system version running on SQL Server host.
Field Name: WINVER
Data Element: MSQSSWVER
Data Type: CHAR
length (Dec): 80(0)
Check table:
Conversion Routine:
Domain Name: CHAR80
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WINVER

Description: Processor type being used on the host running SQL Server.
Field Name: CHIP
Data Element: MSQSSCHIP
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHIP

Description: Number of seconds SQL Server has been running.
Field Name: SQLUPTIME
Data Element: MSQDSSQLSC
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLUPTIME

Description: Date the executable sqlservr.exe was created.
Field Name: PRODLEVEL
Data Element: MSQSSBLDDT
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: CHAR12
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PRODLEVEL

Description: OS edition: A=Advanced Server, S=Server, D=Datacenter.
Field Name: NTVER
Data Element: MSQSSNTEE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NTVER

Description: Is SQL Server clustered 'Y' or 'N'
Field Name: ISCLUSTER
Data Element: MSSISCLUSTER
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ISCLUSTER

Description: Is SQL Server on machine with /3GB switch on 'Y' or 'N'
Field Name: IS3GB
Data Element: MSSIS3GB
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IS3GB

Description: Is SQL Server on machine with PAE 'Y' or 'N'
Field Name: ISPAE
Data Element: MSSISPAE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ISPAE

Description: Is SQL Server AWE enabled Y' or 'N'
Field Name: ISAWE
Data Element: MSSISAWE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ISAWE