sp_confighistory

Creates the ch_events view and displays changes made to SAP ASE configuration.

Syntax

sp_confighistory create_view
	begin_date[, end_date]]
	last[items_num]
	{area | type | target | element}[, item_name]
	help

Parameters

create_view – indicates you are creating the ch_events view.
begin_date, [end_date – displays all items from begin_date value to the end_date value.
last – displays the latest configuration history items.
items_num – number of items to show from the list of latest configuration history items.
area | type | target | element – displays items from the specified area:
- area – area in which the auditable event occurs. One of:
  - server – server-level events.
  - database – database-level events.
  - cache – cache-level events.
  - traceflag – dbcc traceflag and set switch events.
  - SUSD – startup/shutdown.
  - audit – auditing state changes.
- type – type of auditable event. One of:
  - sp_configure
  - sp_serveroption
  - sp_dboption
  - sp_cacheconfig
  - sp_poolconfig
  - create thread pool
  - alter thread pool
  - drop thread pool
  - dbcc traceflag
  - set switch
  - configuration file change
  - startup
  - shutdown
  - shutdown with wait
  - shutdown with nowait
  - abrupt shutdown
  - global auditing
  - config history auditing
- target – name of the target objects to which the change applies (for example, server, cache, thread pool, and database names, traceflag number, and so on).
- element – configuration or other option name (for example, “enable monitoring”, “config pool: 4K, option: wash size”, and so on).
help – displays usage information for sp_confighistory.

Examples

Permissions

Only the system administrator (users with sa_role) can use this procedure to create the ch_events view.

Only the system administrator (users with sa_role) and users with mon_role can use this procedure to query the ch_events view.

The permission checks differ, based on your granular permission settings:
Setting Description
Enabled

Only users with:
select any audit table permission can query against the ch_events view.

manage auditing permission can change the option state of configuration history auditing

select any audit table permission can query against the ch_events view.

select any audit table permission can query the audit tables.

Disabled

Only:
System security officers (users with sso_role) can change the option state of configuration history auditing

only system administrators (users with sa_role) and users with mon_role can query against the ch_events view.

Setting	Description
Enabled	Only users with: `select any audit table` permission can query against the `ch_events` view. `manage auditing` permission can change the option state of configuration history auditing `select any audit table` permission can query against the `ch_events` view. `select any audit table` permission can query the audit tables.
Disabled	Only: System security officers (users with sso_role) can change the option state of configuration history auditing only system administrators (users with sa_role) and users with mon_role can query against the ch_events view.