Hello Reader,
I had two great submissions this week and one of them surprised me because it was from my own fellow g-c'er Matt Seyer. Matt won this weeks competition because he took one step farther in his testing to show not only what the new tables in the Server 2019 SRUM database meant, he also showed where to go in the registry to get the answer.
The Winning Answer:
Matt Seyer (@forensic_matt)
Sunday Funday Submission
The Challenge
Methodology
Windows Versions Used
Table Differences
Base Tables
Windows 10 | Server 2019 Desktop Experience | Status |
--------------------------------------- Table: MSysObjects --------------------------------------- ObjidTable -> INTEGER_32BIT_SIGNED Type -> INTEGER_16BIT_SIGNED Id -> INTEGER_32BIT_SIGNED ColtypOrPgnoFDP -> INTEGER_32BIT_SIGNED SpaceUsage -> INTEGER_32BIT_SIGNED Flags -> INTEGER_32BIT_SIGNED PagesOrLocale -> INTEGER_32BIT_SIGNED RootFlag -> BOOLEAN RecordOffset -> INTEGER_16BIT_SIGNED LCMapFlags -> INTEGER_32BIT_SIGNED KeyMost -> INTEGER_16BIT_UNSIGNED LVChunkMax -> INTEGER_32BIT_SIGNED Name -> TEXT Stats -> BINARY_DATA TemplateTable -> TEXT DefaultValue -> BINARY_DATA KeyFldIDs -> BINARY_DATA VarSegMac -> BINARY_DATA ConditionalColumns -> BINARY_DATA TupleLimits -> BINARY_DATA Version -> BINARY_DATA SortID -> BINARY_DATA CallbackData -> LARGE_BINARY_DATA CallbackDependencies -> LARGE_BINARY_DATA SeparateLV -> LARGE_BINARY_DATA SpaceHints -> LARGE_BINARY_DATA SpaceDeferredLVHints -> LARGE_BINARY_DATA LocaleName -> LARGE_BINARY_DATA | --------------------------------------- Table: MSysObjects --------------------------------------- ObjidTable -> INTEGER_32BIT_SIGNED Type -> INTEGER_16BIT_SIGNED Id -> INTEGER_32BIT_SIGNED ColtypOrPgnoFDP -> INTEGER_32BIT_SIGNED SpaceUsage -> INTEGER_32BIT_SIGNED Flags -> INTEGER_32BIT_SIGNED PagesOrLocale -> INTEGER_32BIT_SIGNED RootFlag -> BOOLEAN RecordOffset -> INTEGER_16BIT_SIGNED LCMapFlags -> INTEGER_32BIT_SIGNED KeyMost -> INTEGER_16BIT_UNSIGNED LVChunkMax -> INTEGER_32BIT_SIGNED Name -> TEXT Stats -> BINARY_DATA TemplateTable -> TEXT DefaultValue -> BINARY_DATA KeyFldIDs -> BINARY_DATA VarSegMac -> BINARY_DATA ConditionalColumns -> BINARY_DATA TupleLimits -> BINARY_DATA Version -> BINARY_DATA SortID -> BINARY_DATA CallbackData -> LARGE_BINARY_DATA CallbackDependencies -> LARGE_BINARY_DATA SeparateLV -> LARGE_BINARY_DATA SpaceHints -> LARGE_BINARY_DATA SpaceDeferredLVHints -> LARGE_BINARY_DATA LocaleName -> LARGE_BINARY_DATA | Both table schemas match. |
--------------------------------------- Table: MSysObjectsShadow --------------------------------------- ObjidTable -> INTEGER_32BIT_SIGNED Type -> INTEGER_16BIT_SIGNED Id -> INTEGER_32BIT_SIGNED ColtypOrPgnoFDP -> INTEGER_32BIT_SIGNED SpaceUsage -> INTEGER_32BIT_SIGNED Flags -> INTEGER_32BIT_SIGNED PagesOrLocale -> INTEGER_32BIT_SIGNED RootFlag -> BOOLEAN RecordOffset -> INTEGER_16BIT_SIGNED LCMapFlags -> INTEGER_32BIT_SIGNED KeyMost -> INTEGER_16BIT_UNSIGNED LVChunkMax -> INTEGER_32BIT_SIGNED Name -> TEXT Stats -> BINARY_DATA TemplateTable -> TEXT DefaultValue -> BINARY_DATA KeyFldIDs -> BINARY_DATA VarSegMac -> BINARY_DATA ConditionalColumns -> BINARY_DATA TupleLimits -> BINARY_DATA Version -> BINARY_DATA SortID -> BINARY_DATA CallbackData -> LARGE_BINARY_DATA CallbackDependencies -> LARGE_BINARY_DATA SeparateLV -> LARGE_BINARY_DATA SpaceHints -> LARGE_BINARY_DATA SpaceDeferredLVHints -> LARGE_BINARY_DATA LocaleName -> LARGE_BINARY_DATA | --------------------------------------- Table: MSysObjectsShadow --------------------------------------- ObjidTable -> INTEGER_32BIT_SIGNED Type -> INTEGER_16BIT_SIGNED Id -> INTEGER_32BIT_SIGNED ColtypOrPgnoFDP -> INTEGER_32BIT_SIGNED SpaceUsage -> INTEGER_32BIT_SIGNED Flags -> INTEGER_32BIT_SIGNED PagesOrLocale -> INTEGER_32BIT_SIGNED RootFlag -> BOOLEAN RecordOffset -> INTEGER_16BIT_SIGNED LCMapFlags -> INTEGER_32BIT_SIGNED KeyMost -> INTEGER_16BIT_UNSIGNED LVChunkMax -> INTEGER_32BIT_SIGNED Name -> TEXT Stats -> BINARY_DATA TemplateTable -> TEXT DefaultValue -> BINARY_DATA KeyFldIDs -> BINARY_DATA VarSegMac -> BINARY_DATA ConditionalColumns -> BINARY_DATA TupleLimits -> BINARY_DATA Version -> BINARY_DATA SortID -> BINARY_DATA CallbackData -> LARGE_BINARY_DATA CallbackDependencies -> LARGE_BINARY_DATA SeparateLV -> LARGE_BINARY_DATA SpaceHints -> LARGE_BINARY_DATA SpaceDeferredLVHints -> LARGE_BINARY_DATA LocaleName -> LARGE_BINARY_DATA | Both table schemas match. |
--------------------------------------- Table: MSysObjids --------------------------------------- objid -> INTEGER_32BIT_SIGNED objidTable -> INTEGER_32BIT_SIGNED type -> INTEGER_16BIT_SIGNED | --------------------------------------- Table: MSysObjids --------------------------------------- objid -> INTEGER_32BIT_SIGNED objidTable -> INTEGER_32BIT_SIGNED type -> INTEGER_16BIT_SIGNED | Both table schemas match. |
--------------------------------------- Table: MSysLocales --------------------------------------- Type -> INTEGER_8BIT_UNSIGNED iValue -> INTEGER_32BIT_SIGNED Key -> BINARY_DATA | --------------------------------------- Table: MSysLocales --------------------------------------- Type -> INTEGER_8BIT_UNSIGNED iValue -> INTEGER_32BIT_SIGNED Key -> BINARY_DATA | Both table schemas match. |
--------------------------------------- Table: SruDbIdMapTable --------------------------------------- IdType -> INTEGER_8BIT_UNSIGNED IdIndex -> INTEGER_32BIT_SIGNED IdBlob -> LARGE_BINARY_DATA | --------------------------------------- Table: SruDbIdMapTable --------------------------------------- IdType -> INTEGER_8BIT_UNSIGNED IdIndex -> INTEGER_32BIT_SIGNED IdBlob -> LARGE_BINARY_DATA | Both table schemas match. |
--------------------------------------- Table: SruDbCheckpointTable --------------------------------------- ProviderId -> GUID CheckpointId -> INTEGER_32BIT_SIGNED NextIncId -> INTEGER_32BIT_SIGNED SeqNumber -> BINARY_DATA RecordSet -> LARGE_BINARY_DATA | --------------------------------------- Table: SruDbCheckpointTable --------------------------------------- ProviderId -> GUID CheckpointId -> INTEGER_32BIT_SIGNED NextIncId -> INTEGER_32BIT_SIGNED SeqNumber -> BINARY_DATA RecordSet -> LARGE_BINARY_DATA | Both table schemas match. |
Post a Comment