The ARSchema table contains relevant BMC Remedy form names, schema ID, and view information. So, for example, if I’m trying to create an escalation to delete old Remedy People audit log data and would like to find out more about the CTM:AuditLogSystem form the following SQL query can be run:
SELECT * FROM arschema WHERE name = ‘CTM:AuditLogSystem’