The basic information for subscriptions such as ID, name, schedule, recipient, etc. is stored in the DSSCSSUBINST table, and each subscription has further entries in the DSSCSPSNLZTN table that include the other settings such as compression, password, expiration, etc.
In general, each subscription will be represented by three or more rows in the DSSCSPSNLZTN table, each with four columns; INST_ID, SUB_ID, VAL_SEQ, and P_VALUE.
INST_ID contains the GUID for the subscription.
SUB_ID contains an entry type ID for the row
VAL_SEQ contains a sequence value in case more than one row is needed to store a particular type of entry; 0 unless multiple rows exist
P_VALUE contains the subscriptions properties that belong to the row entry type.
Rows with SUB_ID of 16777216 contain all of the options for the delivery of the subscription such as Message, Subject, Filename, Expiration Date, etc. If the properties are too long to fit in one row, an additional row will be created with SUB_ID of 16777216 and VAL_SEQ incremented by 1. Each property will be listed in the format:
<Property Name>++++<Property Value>***
The row with SUB_ID of 67108864 contains the name of the report for the subscription and the schedule that the subscription is attached to.
The row with SUB_ID of 536870912 contains some XML tags and is not generally useful to examine in Strategy 2021. In most cases, the row with SUB_ID 16777216 will be the only row that is relevant from the DSSCSPSNLZTN table, and the P_VALUE column can be searched for values relevant to whatever is being investigated.
