Remedy - Server - How can I find which forms have a large number of records?

Version 19

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    Remedy AR System Server


    AR System


    Remedy AR System Server v8.x, v9.x


    I want to monitor the growth of data in my AR System. How can I get a count of the number of records in each form so I can see which ones are huge and which ones are growing?


    Attached are two database scripts, one for SQL Server and one for Oracle.
    These scripts can be run from a database prompt or query window to get a list of the forms and how many records they contain.

    The list is sorted by the number of records, with the highest being on top

    The results look like this example below:


    58Server Statistics3773828
    3588Time Entry40306
    1449CFG:Geography City24131
    For SQL Server only (not applicable for Oracle)

    sp_spaceused (Transact-SQL)
    Displays the number of rows, disk space reserved, and disk space used by a table, indexed view, or Service Broker queue in the current database, or displays the disk space reserved and used by the whole database.

    Alternatively, run Disk Usage by Top Tables report from within SQL Server Management Studio

    SQL Server Disk Usage by Top Tables screenshot


    Article Number:


    Article Type:


      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles