Utility Procedures
Technical Details

Technical details for Utility Procedures used by dbOmnibus.

| Procedure List |

These utility procedures are used internally by dbOmnibus and are not intended to be executed manually.


sp_InsertEvent

Insert records in the [Events] table,

Usage:

EXEC [Util].[sp_InsertEvent] @CapturedTime=(SELECT GETDATE()) ,@Event='my Event Text' ,@EventTime=(SELECT GETDATE()) ,@ImpactId=1 ,@SourceId=1 ,@AlertItemId=1 ,@EntityTypeId=1 ,@Item='MyItem' ,@Details='More Details about the Event'

Parameters:

CapturedTime - (optional) Time captured
Event - (optional) Long description of the Event
EventTime - (optional) Time of the Event
ImpactId - (optional) Impact ID (see: [Impacts] table for values)
SourceId - (optional) Source ID (see: [EventSources] table for values)
AlertItemId - (optional) Alert Item ID (see: [AlertItems] table for values)
EntityTypeId - (optional) Entity Type ID (see: [EntityTypes] table for values)
Item - (optional) DriveLetter, DatabaseName etc
Details - (optional) Event details

 


Page Last Updated: 21 September 2025