Server Audit Filter Values For [class_type]

( For an explanation of what these values are used for and why I published this chart, please see: Server Audit Mystery: Filtering class_type gets Error Msg 25713 )

The values in the chart below were taken from the results of the following query. The query was executed against all versions of SQL Server starting with 2012 since that is when Server Audit’s first became filterable.

SELECT   spt.[name], spt.[number]
FROM     [master].[dbo].[spt_values] spt
WHERE    spt.[type] = N'EOD'
ORDER BY spt.[name];

The number of values per each version are:

  • SQL Server 2012 = 86
  • SQL Server 2014 = 90
  • SQL Server 2016 = 98
  • SQL Server 2017 = 100


Available in SQL Server version:
Name Number 2012 2014 2016 2017
ADHOC QUERY 20801 X X X X
AGGREGATE 17985 X X X X
APPLICATION ROLE 21057 X X X X
ASSEMBLY 21313 X X X X
ASYMMETRIC KEY 19265 X X X X
ASYMMETRIC KEY LOGIN 19521 X X X X
ASYMMETRIC KEY USER 21825 X X X X
AUDIT 21828 X X X
AVAILABILITY GROUP 18241 X X X X
BROKER PRIORITY 21072 X X X X
CERTIFICATE 21059 X X X X
CERTIFICATE LOGIN 19523 X X X X
CERTIFICATE USER 21827 X X X X
CHECK CONSTRAINT 8259 X X X X
COLUMN ENCRYPTION KEY 19267 X X
COLUMN MASTER KEY 19779 X X
CONTRACT 21571 X X X X
CREDENTIAL 17475 X X X X
CRYPTOGRAPHIC PROVIDER 20547 X X X X
DATABASE 16964 X X X X
DATABASE AUDIT SPECIFICATION 16708 X X X X
DATABASE ENCRYPTION KEY 19268 X X X X
DATABASE EVENT SESSION 17732 X X X
DATABASE SCOPED CONFIGURATION 21316 X X
DATABASE SCOPED CREDENTIAL 17220 X X
DATABASE SCOPED RESOURCE GOVERNOR 21060 X
DEFAULT 8260 X X X X
ENDPOINT 20549 X X X X
EVENT NOTIFICATION 20037 X X X X
EVENT NOTIFICATION DATABASE 20036 X X X X
EVENT NOTIFICATION OBJECT 20047 X X X X
EVENT NOTIFICATION SERVER 17491 X X X X
EVENT SESSION 17747 X X X X
EXTERNAL DATA SOURCE 17477 X X X
EXTERNAL FILE FORMAT 17989 X X X
EXTERNAL LIBRARY 19525 X
EXTERNAL RESOURCE POOL 21061 X X
EXTERNAL SCRIPT QUERY 22597 X X
EXTERNAL TABLE 21573 X X
FOREIGN KEY CONSTRAINT 8262 X X X X
FULLTEXT CATALOG 17222 X X X X
FULLTEXT STOPLIST 19526 X X X X
FUNCTION SCALAR ASSEMBLY 21318 X X X X
FUNCTION SCALAR INLINE SQL 21321 X X X X
FUNCTION SCALAR SQL 20038 X X X X
FUNCTION TABLE-VALUED ASSEMBLY 21574 X X X X
FUNCTION TABLE-VALUED INLINE SQL 17993 X X X X
FUNCTION TABLE-VALUED SQL 18004 X X X X
GROUP USER 21831 X X X X
INDEX 22601 X X X X
INTERNAL TABLE 21577 X X X X
LOGIN 22604 X X X X
MASTER KEY 19277 X X X X
MESSAGE TYPE 21581 X X X X
OBJECT 16975 X X X X
PARTITION FUNCTION 18000 X X X X
PARTITION SCHEME 21328 X X X X
PREPARED ADHOC QUERY 20816 X X X X
PRIMARY KEY 19280 X X X X
QUEUE 20819 X X X X
REMOTE SERVICE BINDING 20034 X X X X
RESOURCE GOVERNOR 18258 X X X X
ROLE 19538 X X X X
ROUTE 21586 X X X X
RULE 8274 X X X X
SCHEMA 17235 X X X X
SEARCH PROPERTY LIST 20550 X X X X
SECURITY POLICY 20563 X X
SEQUENCE OBJECT 20307 X X X X
SERVER 21075 X X X X
SERVER AUDIT 8257 X X X X
SERVER AUDIT SPECIFICATION 16723 X X X X
SERVER CONFIG 20291 X X X X
SERVER ROLE 18259 X X X X
SERVICE 22099 X X X X
SQL LOGIN 19539 X X X X
SQL USER 21843 X X X X
STATISTICS 21587 X X X X
STORED PROCEDURE 8272 X X X X
STORED PROCEDURE ASSEMBLY 17232 X X X X
STORED PROCEDURE EXTENDED 8280 X X X X
STORED PROCEDURE REPLICATION FILTER 18002 X X X X
SYMMETRIC KEY 19283 X X X X
SYNONYM 20051 X X X X
TABLE 8277 X X X X
TABLE SYSTEM 8275 X X X X
TRIGGER 21076 X X X X
TRIGGER ASSEMBLY 16724 X X X X
TRIGGER DATABASE 21572 X X X X
TRIGGER SERVER 8276 X X X X
TYPE 22868 X X X X
Undocumented 20545 X X X X
UNIQUE CONSTRAINT 20821 X X X X
USER 21333 X X X X
VIEW 8278 X X X X
WINDOWS GROUP 18263 X X X X
WINDOWS LOGIN 19543 X X X X
WINDOWS USER 21847 X X X X
XML SCHEMA COLLECTION 22611 X X X X
XREL TREE 21080 X X X X