SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE [dbo].[Mbx_test](
    [GroupOrMbx] [varchar](10) NOT NULL,	
    [GroupName] [varchar](255) NULL,
	[GroupEmail] [varchar](255) NULL,
    [GroupType] [varchar](10) NULL,
	[MBXName] [varchar](255) NULL,
	[MBXEmail] [varchar](255) NULL,
	[Connected] [bit] NOT NULL,
	[CreatedDate] [datetime] NOT NULL
) 
INSERT INTO Mbx_test
VALUES 
('mbx', NULL, NULL,NULL,'mbx1','mbx1@test.com',1,'2022-09-22'),
('group', 'group1','group1@test.com','W','mbx1','mbx1@test.com',1,'2022-09-22'),
('group', 'group2','group2@test.com','M','mbx1','mbx1@test.com',1,'2022-09-22'),
('group', 'group3','group3@test.com','R','mbx1','mbx1@test.com',1,'2022-09-22'),

('mbx', NULL, NULL,NULL,'mbx2','mbx2@test.com',1,'2022-09-22'),
('group', 'group4','group4@test.com','W','mbx2','mbx2@test.com',1,'2022-09-22'),
('group', 'group5','group5@test.com','M','mbx2','mbx2@test.com',1,'2022-09-22'),
('group', 'group6','group6@test.com','R','mbx2','mbx2@test.com',1,'2022-09-22'),

('mbx', NULL, NULL,NULL,'mbx3','mbx3@test.com',0,'2022-09-22'),
('group', 'group7','group7@test.com','W','mbx3','mbx3@test.com',0,'2022-09-22'),
('group', 'group8','group8@test.com','M','mbx3','mbx3@test.com',0,'2022-09-22'),
('group', 'group9','group9@test.com','R','mbx3','mbx3@test.com',0,'2022-09-22'),

('mbx', NULL, NULL,NULL,'mbx4','mbx4@test.com',0,'2022-09-22'),
('group', 'group10','group10@test.com','W','mbx4','mbx4@test.com',0,'2022-09-22'),
('group', 'group11','group11@test.com','M','mbx4','mbx4@test.com',0,'2022-09-22'),
('group', 'group12','group12@test.com','R','mbx4','mbx4@test.com',0,'2022-09-22')
16 rows affected

  Select cast (CreatedDate as Date), Connected,GroupOrMbx,GroupType from [dbo].[Mbx_test]
  group by cast (CreatedDate as Date), Connected,GroupOrMbx,GroupType


(No column name)
Connected
GroupOrMbx
GroupType


2022-09-22
False
group
M

2022-09-22
False
group
R

2022-09-22
False
group
W

2022-09-22
False
mbx
null

2022-09-22
True
group
M

2022-09-22
True
group
R

2022-09-22
True
group
W

2022-09-22
True
mbx
null

(No column name)	Connected	GroupOrMbx	GroupType
2022-09-22	False	group	M
2022-09-22	False	group	R
2022-09-22	False	group	W
2022-09-22	False	mbx	null
2022-09-22	True	group	M
2022-09-22	True	group	R
2022-09-22	True	group	W
2022-09-22	True	mbx	null