Sophos database table size query

  • Article ID: 119514
  • Rating:
  • 1 customers rated this article 3.0 out of 6
  • Updated: 06 May 2014

This article explains how to get a listing of the number of rows and size of the tables in the Sophos core database.  On a system where you need to know the number of rows and the size of the tables, you can run this query to get the important data.

Applies to the following Sophos product(s) and version(s)

Enterprise Console

What To Do

Download this file and save to the computer hosting the Sophos core database: SQL file to output disk space usage

Usage

sqlcmd -E -S (server)\(instance) -d SOPHOSXX -i diskusage.sql.txt -o DiskSpaceOutput.txt

Replace server, instance, and sophosxx with the appropriate information (.\ is local with no name, .\sophos is the default).  See article 17323 for more information on database naming conventions.

 This outputs (to the DiskSpaceOutput.txt file) the number of rows, used memory, and allocated memory for each table.

 
If you need more information or guidance, then please contact technical support.

Rate this article

Very poor Excellent

Comments