Manitou Core - SQL Query - Find Logs

01/02/2024 6:16 pm EST

USE MANITOU
GO

DECLARE @LOG_ID as INT;

DECLARE ID_CURSOR CURSOR FOR
	select ID from syslog01
	where msgtext like '%Priorities to service%'
	and apptype in (1, 4, 16);

OPEN ID_CURSOR

FETCH NEXT FROM ID_CURSOR
 INTO @LOG_ID

WHILE @@FETCH_STATUS=0
BEGIN
	SELECT * from SYSLOG01
	WHERE ID < @LOG_ID + 500 and ID > @LOG_ID - 5000 and apptype in (1, 4, 16)
	FETCH NEXT FROM ID_CURSOR
	INTO @LOG_ID
END

CLOSE ID_CURSOR;
DEALLOCATE ID_CURSOR;

Was this article helpful?