IBM Sterling B2B: Queries for Archive - Revision history

Ebasso: /* Messages on Mailboxes by Year */

2023-10-23T15:11:44Z

Messages on Mailboxes by Year

← Older revision		Revision as of 15:11, 23 October 2023
Line 75:		Line 75:
	\| 2021 \|\| 4198		\| 2021 \|\| 4198
	\|}		\|}

			== Messages on Mailboxes by Year and Extractable Count ==

			select to_char(mm.CREATED_DATETIME, 'YYYY') as YEAR1, mec.EXTRACTABLE_COUNT, count(1) as CONT
			from MBX_MESSAGE mm, MBX_EXTRACT_COUNT mec
			WHERE mm.MESSAGE_ID = mec.MESSAGE_ID
			group by to_char(mm.CREATED_DATETIME, 'YYYY'),mec.EXTRACTABLE_COUNT
			order by 1,2

	==Messages on mailboxes by created date==		==Messages on mailboxes by created date==

2021-12-13T20:02:08Z

Messages on Mailboxes by Year

← Older revision		Revision as of 20:02, 13 December 2021
Line 56:		Line 56:
	== Messages on Mailboxes by Year ==		== Messages on Mailboxes by Year ==

	select to_char(mm.CREATED_DATETIME, 'YYYY') as YEAR1, count(1) as CONT		select to_char(mm.CREATED_DATETIME, 'YYYY') as YEAR1, count(1) as CONT
	from MBX_MESSAGE mm		from MBX_MESSAGE mm
	group by to_char(mm.CREATED_DATETIME, 'YYYY')		group by to_char(mm.CREATED_DATETIME, 'YYYY')
Line 75:		Line 75:
	\| 2021 \|\| 4198		\| 2021 \|\| 4198
	\|}		\|}



	==Messages on mailboxes by created date==		==Messages on mailboxes by created date==

2021-04-23T14:41:23Z

← Older revision		Revision as of 14:41, 23 April 2021
Line 1:		Line 1:

	Verificar o artigo [[IBM Sterling B2B: Archive e Purge]]		Verificar também o artigo [[IBM Sterling B2B: Archive e Purge]]

	= Archive Info=		= Archive Info=
Line 19:		Line 19:

	=Queries=		=Queries=

			Calcula os registros para archive conforme o ARCHIVE_FLAG

	SELECT ARCHIVE_FLAG, count(1) as CNT FROM ARCHIVE_INFO GROUP BY ARCHIVE_FLAG ORDER BY ARCHIVE_FLAG		SELECT ARCHIVE_FLAG, count(1) as CNT FROM ARCHIVE_INFO GROUP BY ARCHIVE_FLAG ORDER BY ARCHIVE_FLAG

2021-04-23T14:39:58Z

← Older revision		Revision as of 14:39, 23 April 2021
Line 1:		Line 1:

			Verificar o artigo [[IBM Sterling B2B: Archive e Purge]]

	= Archive Info=		= Archive Info=

2021-04-23T14:39:41Z

Ver também

← Older revision		Revision as of 14:39, 23 April 2021
Line 90:		Line 90:

	= Ver também =		= Ver também =
			* [[IBM Sterling B2B: Archive e Purge]]
	* [[IBM Sterling B2B: SELECT a Code List]]		* [[IBM Sterling B2B: SELECT a Code List]]
	* [[IBM Sterling B2B: SELECT Queue, Lifespan, PersistentLevel of Business Process]]		* [[IBM Sterling B2B: SELECT Queue, Lifespan, PersistentLevel of Business Process]]

2021-04-23T14:39:09Z

Business Process

@@ Line 13: / Line 13: @@
 |-
 | 2 || Archive Complete, Ready for Purge
 |}

2021-04-17T13:32:37Z

@@ Line 1: / Line 1: @@
-=Queries=
+= Archive Info=
 {| class="wikitable"
@@ Line 17: / Line 16: @@
   SELECT ARCHIVE_FLAG, count(1) as CNT FROM ARCHIVE_INFO GROUP BY ARCHIVE_FLAG ORDER BY ARCHIVE_FLAG

2021-04-17T13:27:58Z

Archive Info

@@ Line 2: / Line 2: @@
 =Queries=
 == Archive Info==
   SELECT ARCHIVE_FLAG, count(1) as CNT FROM ARCHIVE_INFO GROUP BY ARCHIVE_FLAG ORDER BY ARCHIVE_FLAG

2021-04-17T10:46:57Z

Archive Info

@@ Line 18: / Line 18: @@
 |-
 | 2 || 4198
 |}

2021-04-17T10:40:35Z

← Older revision		Revision as of 10:40, 17 April 2021
Line 1:		Line 1:

			=Queries=
			== Archive Info==

	SELECT ARCHIVE_FLAG, count(1) as CNT FROM ARCHIVE_INFO GROUP BY ARCHIVE_FLAG ORDER BY ARCHIVE_FLAG		SELECT ARCHIVE_FLAG, count(1) as CNT FROM ARCHIVE_INFO GROUP BY ARCHIVE_FLAG ORDER BY ARCHIVE_FLAG
Line 18:		Line 20:
	\|}		\|}

	== ==		== Messages on Mailboxes by Year ==

	select to_char(mm.CREATED_DATETIME, 'YYYY') as YEAR1, count(1) as CONT		select to_char(mm.CREATED_DATETIME, 'YYYY') as YEAR1, count(1) as CONT