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