QuerySnapshot Table
QuerySnapshot
holds the snapshot of data for a report
Note: To cater for multi-tenant mode, this table may contain data for
multiple tenants. Access requires that the database
TenantID
has been set in the SQL Server
connection context information. That setting filters an underlying table to produce this
view of data for the single, selected tenant.
Database Column |
Details |
---|---|
QuerySnapshotID
|
Type: integer. Key. Generated ID A unique identifier for a query snapshot. |
QueryContext
|
Type: text (max 200 characters). Key The query context to partition different queries. |
ComplianceSavedSearchID
|
Type: integer. Key. Nullable The query definition this snapshot is for. Foreign key to the |
ComplianceOperatorID
|
Type: integer. Key The operator who ran the report. Foreign key to the |
SnapshotName
|
Type: text (max 200 characters) Name of snapshot. |
SnapshotSchema
|
Type: XML Schema of snapshot. |
SnapshotDate
|
Type: datetime Date and time of snapshot (UTC) |
SnapshotBuildTime
|
Type: big integer Number of milliseconds taken to build the snapshot. |
SnapshotRows
|
Type: big integer Number of rows in the snapshot. |