-- Auto-generated stored procedure for ops search
-- Generated: 2026-06-11 02:31:53
-- Search Query: vendor

CREATE PROCEDURE [dbo].[usp_SearchOps_20260611_023153]
    @SearchQuery NVARCHAR(255),
    @SearchType NVARCHAR(50) = NULL,
    @Severity NVARCHAR(10) = NULL
AS
BEGIN
    SET NOCOUNT ON;

    DECLARE @SearchTerm NVARCHAR(255) = CONCAT('%', @SearchQuery, '%');

    -- Result set combining incidents and runbooks
    SELECT
        'Incident' as ResultType,
        ic.IncidentId as Id,
        ic.Title,
        ic.Severity,
        ic.StartTimeUtc as CreatedDate,
        ic.AffectedServices as Details,
        ic.MinuteToResolve as MetricValue
    FROM dbo.OpsIncidentCases ic
    WHERE ic.IsActive = 1
        AND (@SearchType IS NULL OR @SearchType = 'incident')
        AND (@Severity IS NULL OR ic.Severity = @Severity)
        AND (
            ic.IncidentId LIKE @SearchTerm
            OR ic.Title LIKE @SearchTerm
            OR ic.AffectedServices LIKE @SearchTerm
            OR ic.RootCause LIKE @SearchTerm
        )

    UNION ALL

    SELECT
        'Runbook' as ResultType,
        CAST(rb.Id AS NVARCHAR(50)) as Id,
        rb.Title,
        rb.Severity,
        CAST(GETUTCDATE() AS DATETIME2) as CreatedDate,
        rb.Platform as Details,
        rb.TotalUseCount as MetricValue
    FROM dbo.OpsRunbooks rb
    WHERE rb.IsActive = 1
        AND (@SearchType IS NULL OR @SearchType = 'runbook')
        AND (
            rb.Title LIKE @SearchTerm
            OR rb.Description LIKE @SearchTerm
            OR rb.Platform LIKE @SearchTerm
            OR rb.DetectionSteps LIKE @SearchTerm
        )

    ORDER BY ResultType, CreatedDate DESC;

END;

-- Execute the stored procedure:
-- EXEC [dbo].[usp_SearchOps_20260611_023153] @SearchQuery = 'vendor'