SELECT COUNT(*) AS WARNING_MESSAGE_COUINT FROM ACTLOG WHERE SEVERITY = ‘W’ AND DATE_TIME> ‘YYYY-MM-DD HH:MM‘
WHERE
YYYY = Year
MM = Month
DD = Day
HH = Hour
MM = Month
Posted in: Helpful TSM SQL Commands
SELECT COUNT(*) AS WARNING_MESSAGE_COUINT FROM ACTLOG WHERE SEVERITY = ‘W’ AND DATE_TIME> ‘YYYY-MM-DD HH:MM‘
WHERE
YYYY = Year
MM = Month
DD = Day
HH = Hour
MM = Month
Posted in: Helpful TSM SQL Commands