Insert

InsertAuditAdminSiteAuthentication


InsertAuditAdminSiteAuthentication

logs each time the Identify*Admin site is being accessed by a user.

[Table].[Column] storing log information Description of information stored
[AuditEvent].[EventType] Identifies the event by the value in this column being InsertAuditAdminSiteAuthentication
[AuditEvent].[UTCTimestamp] Specifies the date and time in UTC that the event occurred.
[AuditEvent].[UserName] Saves the unique identity bearing claim into the Username column if this action is carried out via a federated user. The federated user might or might not exist in the Identify database; he will still be registered.
[AuditEvent].[ApplicationId] Registers the Identify Provider that is used to log on or off the Admin site.
[AuditAdminSiteAuthentication].[ActionType] Registers whether a user logged on or off the Admin site.

InsertAuthenticationConnection


Whenever an Authentication Connection is inserted, whether it be through Identify*Admin or Identify*Services, the insertion is registered under the InsertAuthenticationConnection event type.

[Table].[Column] storing log information Description of information stored
[AuditEvent].[EventType] Identifies the event by the value in this column being InsertAuthenticationConnection.
[AuditEvent].[UTCTimestamp] Specifies the date and time in UTC that the event occurred.
[AuditEvent].[UserName] Saves the unique identity bearing claim into the Username column if this action is carried out via a federated user. The federated user might or might not exist in the Identify database; he will still be registered.
[AuditEvent].[ApplicationId] Stores the name of the Service Provider from where the insert was made. This will either be the Identify*Admin site or the Identify*Service site.
[AuditAuthenticationConnection].[EntityId] All Authentication Connection records are identified by a unique identifier. This column registers this unique identifier in order to identify the specific Authentication Connection that the event in question occurred to.
[AuditAuthenticationConnection].[Name] Stores the name given to the connection in Identify.
[AuditAuthenticationConnection].[Description] Stores the description for the Authentication Connection record in this column, if a description exists.
[AuditAuthenticationConnection].[Enabled] Stores information on whether or not the Authentication Connection is enabled.
[AuditAuthenticationConnection].[ConfigurationClrType] Stores the Common Language Runtime reference for the Authentication Connection object.
[AuditAuthenticationConnection].[ConfigurationXml] Stores the configuration of the Authentication Connection’s various settings in XML.
[AuditAuthenticationConnection].[PlugInDescription] Stores a description of the plug-in that was chosen for the Authentication Connection.
[AuditAuthenticationConnection].[PlugInName] Stores the name of the plug-in used for the Authentication Connection.
[AuditAuthenticationConnection].[PlugInClrType] Stores the Common Language Runtime reference for the plug-in object used for this connection.
[AuditAuthenticationConnection].[PlugInEnabled] Identifies whether or not the plug-in is enabled. This will most likely always be 1 (true) because it would not be possible to update a disabled plug-in.
[AuditAuthenticationConnection].[PlugInType] Stores the plug-in type; will always be “Authentication.”

InsertClaimDefinition


Whenever a claim is inserted, whether it be through Identify*Admin or Identify*Services, the insertion is registered under the InsertClaimDefinition event type.

[Table].[Column] storing log information Description of information stored
[AuditEvent].[EventType] Identifies the event by the value in this column being InsertClaimDefinition
[AuditEvent].[UTCTimestamp] Specifies the date and time in UTC that the event occurred.
[AuditEvent].[UserName] Saves the unique identity bearing claim into the Username column if this action is carried out via a federated user. The federated user might or might not exist in the Identify database; he will still be registered.
[AuditEvent].[ApplicationId] Stores the name of the Service Provider from where the insert was made. This will either be the Identify*Admin site or the Identify*Service site.
[AuditClaimDefinition].[EntityId] All claim records are identified by a unique identifier. This column registers this unique identifier in order to identify the specific claims that the event in question occurred to.
[AuditClaimDefinition].[ClaimType] Registers the claim type name that is given to the claim.
[AuditClaimDefinition].[FriendlyName] Registers the friendly name that is given to the claim.
[AuditClaimDefinition].[Description] Stores the description for the claim record in this column if a description exists.
[AuditClaimDefinition].[CountSpecification] CountSpecification is used to decide how many values of a specific claim type are allowed for a user. The Free value means that the user can have any number of claims for such a claim type in the token issued for the user at login.

InsertIdentityProviderConfiguration


Identity Provider Configuration records will only be inserted at the time of the tenant’s installation. This table shows what the original settings were.

[Table].[Column] storing log information Description of information stored
[AuditEvent].[EventType] Identifies the event by the value in this column being InsertIdentityProviderConfiguration
[AuditEvent].[UTCTimestamp] Specifies the date and time in UTC that the event occurred.
[AuditEvent].[UserName] Saves the unique identity bearing claim into the Username column if this action is carried out via a federated user The federated user might or might not exist in the Identify database; he will still be registered.
[AuditEvent].[ApplicationId] Stores the name of the Service Provider from where the insert was made. This will always be the Identify Configurator.
[AuditIdentityProviderConfiguration].[EntityId] All Identify Configuration records are identified by a unique identifier. This column registers this unique identifier in order to identify the specific Identify Configuration that the event in question occurred to.
[AuditIdentityProviderConfiguration].[Description] Stores the description for the Identity Provider Configuration record in this column, if a description exists.
[AuditIdentityProviderConfiguration].[ClrType] Stores the Common Language Runtime reference for the Identity Provider Configuration object.
[AuditIdentityProviderConfiguration].[Xml] Stores the configuration of the Identity Provider’s various settings in XML.

InsertOrganization


Whenever an organization is inserted, whether it be through Identify*Admin or Identify*Services, the insertion is registered under the InsertOrganization event type.

[Table].[Column] storing log information Description of information stored
[AuditEvent].[EventType] Identifies the event by the value in this column being InsertOrganization
[AuditEvent].[UTCTimestamp] Specifies the date and time in UTC that the event occurred.
[AuditEvent].[UserName] Saves the unique identity bearing claim into the Username column if this action is carried out via a federated user. The federated user might or might not exist in the Identify database; he will still be registered.
[AuditEvent].[ApplicationId] Stores the name of the Service Provider from where the insert was made. This will either be the Identify*Admin site or the Identify*Service site.
[AuditOrganization].[OrganizationId] All organization records are identified by a unique identifier. This column registers this unique identifier in order to identify the specific organization that the event in question occurred to.
[AuditOrganization].[Name] Stores the name of the organization.
[AuditOrganization].[ParentId] Stores the parent organization’s unique identifier.

InsertPersistentPseudonym


Every time that Identify*Runtime issues a persistent pseudonym for a user, information of the user as well as the Service Provider requesting authentication is stored in this table.

[Table].[Column] storing log information Description of information stored
[AuditEvent].[EventType] Identifies the event by the value in this column being InsertPersistentPseudonym.
[AuditEvent].[UTCTimestamp] Specifies the date and time in UTC that the event occurred.
[AuditEvent].[UserName] Saves the unique identity bearing claim into the Username column if this action is carried out via a federated user. The federated user might or might not exist in the Identify database; he will still be registered.
[AuditEvent].[ApplicationId] Specifies the site that issued the persistent pseudonym (which will, in fact, always be Identify*Runtime).
[PersistentPseudonym].[UserName] Specifies the Identify username ([User].[UserName]) that the persistent pseudonym was issued for.
[PersistentPseudonym].[ProtocolConnectionName] Specifies the Service Provider that the persistent pseudonym was issued to.

InsertProtocolConnection


Whenever a Protocol Connection is updated, whether it be through Identify*Admin or Identify*Services, the insertion is registered under the InsertProtocolConnection event type.

[Table].[Column] storing log information Description of information stored
[AuditEvent].[EventType] Identifies the event by the value in this column being InsertProtocolConnection
[AuditEvent].[UTCTimestamp] Specifies the date and time in UTC that the event occurred.
[AuditEvent].[UserName] Saves the unique identity bearing claim into the Username column if this action is carried out via a federated user. The federated user might or might not exist in the Identify database; he will still be registered.
[AuditEvent].[ApplicationId] Stores the name of the Service Provider from where the insert was made. This will either be the Identify*Admin site or the Identify*Service site.
[AuditProtocolConnection].[EntityId] All Protocol Connection records are identified by a unique identifier. This column registers this unique identifier in order to identify the specific Protocol Connection that the event in question occurred to.
[AuditProtocolConnection].[UsePersistentPseudonym] Stores information on whether or not the Protocol Connection is using persistent pseudonyms.
[AuditProtocolConnection].[Name] Stores the name given to the connection in Identify.
[AuditProtocolConnection].[Description] Stores the description for the Protocol Connection record in this column if a description exists.
[AuditProtocolConnection].[Enabled] Saves information on whether the Protocol Connection is enabled or disabled.
[AuditProtocolConnection].[ConfigurationClrType] Specifies the Common Language Runtime reference for the Protocol Connection object.
[AuditProtocolConnection].[ConfigurationXml] Stores the configuration of the Protocol Connection’s various settings in XML.
[AuditProtocolConnection].[PlugInDescription] Stores a description of the plug-in that was chosen for the Protocol Connection.
[AuditProtocolConnection].[PlugInName] Specifies the name of the plug-in used for the Protocol Connection.
[AuditProtocolConnection].[PlugInClrType] Specifies the Common Language Runtime reference for the plug-in object used for this connection.
[AuditProtocolConnection].[PlugInEnabled] Identifies whether or not the plug-in is enabled. This will most likely always be 1 (true) because it would not be possible to update a disabled plug-in.
[AuditProtocolConnection].[PlugInType] Specifies the plug-in type; will always be “Protocol.”

InsertSaml2Assertion


The InsertSaml2Assertion logs every time Identify receives a SAML 2.0 assertion as an Service Provider from an Identify Provider..

[Table].[Column] storing log information Description of information stored
[AuditEvent].[EventType] Identifies the event by the value in this column being InsertSaml2Assertion.
[AuditEvent].[UTCTimestamp] Specifies the date and time in UTC that the event occurred.
[AuditEvent].[UserName] Saves the unique identity bearing claim into the Username column if this action is carried out via a federated user. The federated user might or might not exist in the Identify database; he will still be registered.
[AuditEvent].[ApplicationId] Specifies the Service Provider that the assertion was received from.
[AuditIncomingAssertion].[AssertionId] Specifies a unique assertion ID generated by the token issuer
[AuditIncomingAssertion].[NotOnOrAfter] Identifies the Datetime for when the received saml2assertion token expires.

InsertUser


Whenever a user is inserted, whether it be through Identify*Admin or Identify*Services, the insertion is registered under the InsertUser event type.

[Table].[Column] storing log information Description of information stored
[AuditEvent].[EventType] Identifies the event by the value in this column being InsertUser
[AuditEvent].[UTCTimestamp] Specifies the date and time in UTC that the event occurred.
[AuditEvent].[UserName] Saves the unique identity bearing claim into the Username column if this action is carried out via a federated user. The federated user might or might not exist in the Identify database; he will still be registered.
[AuditEvent].[ApplicationId] Stores the name of the Service Provider from where the insert was made. This will either be the Identify*Admin site or the Identify*Service site.
[AuditUser].[EntityId] All user records are identified by a unique identifier. This column registers this unique identifier in order to identify the specific user that the event in question occurred to.
[AuditUser].[UserName] Saves the Identify name of the user being updated ([User].[UserName]).
[AuditUser].[Enabled] Saves information on whether the user is disabled or enabled.

InsertLdapAttributeDefinition


Whenever an LDAP attribute definition is inserted, whether it be through Identify*Admin or Identify*Services, the insertion is registered under the InsertLdapAttributeDefinition event type.

[Table].[Column] storing log information Description of information stored
[AuditEvent].[EventType] Identifies the event by the value in this column being InsertLdapAttributeDefinition
[AuditEvent].[UTCTimestamp] Specifies the date and time in UTC that the event occurred.
[AuditEvent].[UserName] Saves the unique identity bearing claim into the Username column if this action is carried out via a federated user. The federated user might or might not exist in the Identify database; he will still be registered.
[AuditEvent].[ApplicationId] Stores the name of the Service Provider from where the insert was made. This will either be the Identify*Admin site or the Identify*Service site.
[AuditLdapAttributeDefinition].[EntityId] All user records are identified by a unique identifier. This column registers this unique identifier in order to identify the specific LDAP attribute that the event in question occurred to.
[AuditLdapAttributeDefinition].[UserName] Registers the LDAP attribute definition’s name that is given to the LDAP attribute definition.
[AuditLdapAttributeDefinition].[DisplayName] Registers the LDAP attribute definition’s display name that is given to the LDAP attribute definition.

InsertClaimSet


Whenever a claim set is inserted, whether it be through Identify*Admin or Identify*Services, the insertion is registered under the InsertClaimSet event type.

[Table].[Column] storing log information Description of information stored
[AuditEvent].[EventType] Identifies the event by the value in this column being InsertClaimSet
[AuditEvent].[UTCTimestamp] Specifies the date and time in UTC that the event occurred.
[AuditEvent].[UserName] Saves the unique identity bearing claim into the Username column if this action is carried out via a federated user. The federated user might or might not exist in the Identify database; he will still be registered.
[AuditEvent].[ApplicationId] Stores the name of the Service Provider from where the insert was made. This will either be the Identify*Admin site or the Identify*Service site.
[AuditClaimSet].[EntityId] All claim set records are identified by a unique identifier. This column registers this unique identifier in order to identify the specific claim set that the event in question occurred to.
[AuditClaimSet].[Name] Registers the claim set name that is given to the claim set.
[AuditClaimSet].[Headline] Registers the claim set headline that is given to the claim set.
[AuditClaimSet].[Description] Registers the claim set description that is given to the claim set.
[AuditClaimSet].[Required] Registers the required status that is given to the claim set.
[AuditClaimSet].[AccessOrganizationId] Registers the parent organization of the claim set.
[AuditClaimDefinition].[ClaimTypes] Registers the claim types that are given to the claim set.

InsertOAuthAccessToken


Whenever an OAuth access token is inserted, the insertion is registered under the InsertOAuthAccessToken event type.

[Table].[Column] storing log information Description of information stored
[AuditEvent].[EventType] Identifies the event by the value in this column being InsertOAuthAccessToken
[AuditEvent].[UTCTimestamp] Specifies the date and time in UTC that the event occurred.
[AuditEvent].[UserName] Saves the unique identity bearing claim into the Username column if this action is carried out via a federated user. The federated user might or might not exist in the Identify database; he will still be registered.
[AuditEvent].[ApplicationId] Stores the name of the Service Provider from where the insert was made. This will either be the Identify*Admin site or the Identify*Service site.
[AuditOAuthAccessToken].[Code] Registers the code that is given to the OAuth access token.
[AuditOAuthAccessToken].[HashedCode] Registers the hash code that is given to the OAuth access token.
[AuditOAuthAccessToken].[ClientIdentifier] Registers the client ID that is given to the OAuth access token.
[AuditOAuthAccessToken].[Scope] Registers the scope that is given to the OAuth access token.
[AuditOAuthAccessToken].[Type] Registers the type of the OAuth access token.
[AuditOAuthAccessToken].[UserName] Registers the username that is given to the OAuth access token.
[AuditOAuthAccessToken].[AuthenticationConnectionId] Registers the authentication ID that is given to the OAuth access token.
[AuditOAuthAccessToken].[UserId] Registers the user ID that is given to the OAuth access token.
[AuditOAuthAccessToken].[CreationDate] Registers the created date of the OAuth access token.
[AuditOAuthAccessToken].[ExpirationDate] Registers the expired date of the OAuth access token.
[AuditOAuthAccessToken].[AllowRefreshToken] Registers the RefreshToken status that is given to the OAuth refresh token.
[AuditOAuthAccessToken].[RefreshTokenExpirationDate] Registers the expired date of the OAuth refresh token.
[AuditOAuthAccessToken].[ProtocolConnectionId] Registers the protocol ID that is given to the OAuth.
[AuditOAuthAccessToken].[SerializedClaimsPrincipal] Registers the claim principal of the OAuth.
[AuditOAuthAccessToken].[UserInfoSessionId] Registers the user info session ID of the OAuth token.

InsertAuthenticationContextMethodClass


Whenever an authentication context method class is inserted, the insertion is registered under the InsertAuthenticationContextMethodClass event type.

[Table].[Column] storing log information Description of information stored
[AuditEvent].[EventType] Identifies the event by the value in this column being InsertAuthenticationContextMethodClass
[AuditEvent].[UTCTimestamp] Specifies the date and time in UTC that the event occurred.
[AuditEvent].[UserName] Saves the unique identity bearing claim into the Username column if this action is carried out via a federated user. The federated user might or might not exist in the Identify database; he will still be registered.
[AuditEvent].[ApplicationId] Stores the name of the Service Provider from where the insert was made. This will either be the Identify*Admin site or the Identify*Service site.
[AuditClaimSet].[MethodClass] Registers the name that is given to the authentication context class method.
[AuditClaimSet].[ComparableValue] Registers the integer value that is given to the authentication context class method.

InsertCorrelationError


Whenever an insert correlation error is inserted, the insertion is registered under the InsertCorrelationError event type

[Table].[Column] storing log information Description of information stored
[AuditEvent].[EventType] Identifies the event by the value in this column being InsertCorrelationError
[AuditEvent].[UTCTimestamp] Specifies the date and time in UTC that the event occurred.
[AuditEvent].[UserName] Saves the unique identity bearing claim into the Username column if this action is carried out via a federated user. The federated user might or might not exist in the Identify database; he will still be registered.
[AuditEvent].[ApplicationId] Stores the name of the Service Provider from where the insert was made. This will either be the Identify*Runtime site or the Identify*Service site
[AuditCorrelationError].[CorrelationId] All correlation error records are identified by a unique identifier. This column registers this unique identifier in order to identify the specific correlation error that the event in question occurred to.
[AuditCorrelationError].[Source] Registers the source where user experiences the error report.
[AuditCorrelationError].[UserReport] Registers the user comment on the error.