| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SDF/SQLTIMST | SQL Monitor History: Timestamps - Mapping to time frame | 7 | LASTRUN | Timestamp for SQLM Data Collection | decimal | 15 | 0 | | |
TOPCCMS Database Monitors for SQL Server |
2 | MSSDBSTATT | Table statistics for MS SQL Server | 22 | LASTRUN | | nvarchar | 8 | 0 | | |
TOPMobile Applications |
3 | /ISDFPS/MECAP1J | Last Run (Deletion Records & DB Logs) | 3 | LASTRUN | Last Run (Time Stamp) | nvarchar | 14 | 0 | | |
TOPProcess Monitoring Infrastructure |
4 | SSPIADMAS | Administration Table for Assembler Runs | 4 | LASTRUN | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | | |
5 | SSPIADMDATASUP2 | Administration Table for PMI Data Supplier | 12 | LASTRUN | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
6 | SSPIADMREORG | Administration Table for Reorganizations | 4 | LASTRUN | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | | |
7 | SSPIADMTR2 | PMI: Status Table for Transport Jobs (Central) | 5 | LASTRUN | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | | |
8 | SSPIADMTRANS | BPT: Status Table for Transport Jobs (Central) | 5 | LASTRUN | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | | |
9 | SSPILSADM | BPT: Status Table for Transport Jobs (Central) | 5 | LASTRUN | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | | |
TOPSchedule Manager |
10 | SMRTA | Runtime Analysis of Scheduler Jobs | 7 | LASTRUN | Runtime of Last Processing Run | int | 10 | 0 | | |