CREATE
TABLE
#eventNames (eventId
int
, eventName nvarchar(2000))
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(0,
'netSecurityUser'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(1,
'netSecurityBusiness'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(2,
'netSecurityOrganization'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(3,
'netMetadata'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(4,
'netMetadataEntity'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(5,
'netSettingsOrganization'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(6,
'netSettingsUser'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(7,
'netSchedulingEngineInvalidateContainerCache'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(8,
'netSchedulingEngineInvalidateResourceExpansionCache'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(9,
'netSchedulingEngineInvalidateScheduleCache'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(12,
'netSqmSessionReset'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(13,
'netSiteMap'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(14,
'netHardExpiry'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(15,
'netInfo'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(16,
'netMessageProcessorInvalidatePipelineCache'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(17,
'netSavedQuery'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(18,
'netPluginTypeInvalidateCache'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(19,
'netPluginAssemblyInvalidateCache'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(20,
'netStepDescriptionInvalidateCache'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(21,
'netStepImageDescriptionInvalidateCache'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(22,
'netConfigCreate'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(23,
'netConfigUpdate'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(24,
'netConfigDelete'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(25,
'netConfigAll'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(26,
'netScaleGroupSetState'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(27,
'netServerSetState'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(28,
'netEncryptionConfigurationChange'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(29,
'netOrganizationCreate'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(30,
'netOrganizationSetState'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(31,
'netOrganizationUpdate'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(32,
'netOrganizationDelete'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(33,
'netSubscriptionEntity'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(34,
'netOutlookFilter'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(35,
'netCacheItemRemove'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(36,
'netStepSecureConfigInvalidateCache'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(37,
'netTransactionCurrency'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(38,
'netLocator'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(39,
'netSchedulingEngineMustRunPublishResourceGroupExpansion'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(40,
'netOrganizationMove'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(41,
'netUserInvitationUpdate'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(42,
'netSolution'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(43,
'netServerCreate'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(44,
'netServerMove'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(45,
'netServerDelete'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(46,
'netSecurityTeam'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(47,
'netRibbonCustomizationUpdate'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(48,
'netDependencyNode'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(50,
'netDnsUpdate'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(51,
'netSystemForm'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(52,
'netSrsExtensionsInstalled'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(53,
'netFederationProviderCreate'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(54,
'netFederationProviderUpdate'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(55,
'netFederationProviderDelete'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(56,
'netCertificateCreate'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(57,
'netCertificateUpdate'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(58,
'netCertificateDelete'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(59,
'netWebResource'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(60,
'netSolutionImportFailure'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(62,
'netFlushRecordCountSnapshotCache'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(63,
'netFlushPrincipalObjectAccessReadSnapshotCache'
)
INSERT
INTO
#eventNames (eventId, eventName)
VALUES
(64,
'netMaxEventCount'
)
SELECT
n.CreatedOn, l.eventName, n.EventData ,n.EventId, n.OrganizationId
FROM
MSCRM_CONFIG.dbo.Notification n
LEFT
OUTER
JOIN
#eventNames l
ON
n.EventId = l.eventId
ORDER
BY
CreatedOn
desc