Postgres 10

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

CREATE TABLE machines_in_operation (
source text, object text, serial_number text, redirect text, model text);
INSERT INTO machines_in_operation (source, object, serial_number, redirect, model)VALUES('Inf1','Cont1','abc1235','Client1', 'S10');
INSERT INTO machines_in_operation (source, object, serial_number, redirect, model)VALUES('Inf2','Cont2','abc12356','Client2', 'S10');
INSERT INTO machines_in_operation (source, object, serial_number, redirect, model)VALUES('Inf3','Cont2','abc124','Client3', 'L10');
INSERT INTO machines_in_operation (source, object, serial_number, redirect, model)VALUES('Inf1','Cont2','abc12378','Client1', 'L10');
INSERT INTO machines_in_operation (source, object, serial_number, redirect, model)VALUES('Inf2','Cont2','abc12390','Client3', 'L10');
INSERT INTO machines_in_operation (source, object, serial_number, redirect, model)VALUES('Inf3','Cont2','abc12312','Client1', 'L10');
INSERT INTO machines_in_operation (source, object, serial_number, redirect, model)VALUES('Inf2','Cont2','abc12345','Client2', 'S10');
INSERT INTO machines_in_operation (source, object, serial_number, redirect, model)VALUES('Inf1','Cont4','abc17313','Client6', 'L10');
INSERT INTO machines_in_operation (source, object, serial_number, redirect, model)VALUES('Inf2','Cont4','abc18313','Client6', 'L10');
INSERT INTO machines_in_operation (source, object, serial_number, redirect, model)VALUES('Inf2','Cont2','abc12356','Client2', 'S10');

SELECT * FROM machines_in_operation;
CREATE TABLE result (
source text, object text, redirect text, model text, quantity int);

INSERT INTO result(source, object, redirect, model, quantity)
SELECT source, object, redirect, model, count(*)
FROM machines_in_operation
GROUP BY source, object, redirect, model
ORDER BY redirect;

SELECT * FROM result;

SELECT source, object, redirect, model, count(DISTINCT serial_number) AS quantity 
FROM machines_in_operation
GROUP BY source, object, redirect, model
ORDER BY redirect;

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

source	object	serial_number	redirect	model
Inf1	Cont1	abc1235	Client1	S10
Inf2	Cont2	abc12356	Client2	S10
Inf3	Cont2	abc124	Client3	L10
Inf1	Cont2	abc12378	Client1	L10
Inf2	Cont2	abc12390	Client3	L10
Inf3	Cont2	abc12312	Client1	L10
Inf2	Cont2	abc12345	Client2	S10
Inf1	Cont4	abc17313	Client6	L10
Inf2	Cont4	abc18313	Client6	L10
Inf2	Cont2	abc12356	Client2	S10

8 rows affected

source	object	redirect	model	quantity
Inf1	Cont1	Client1	S10	1
Inf1	Cont2	Client1	L10	1
Inf3	Cont2	Client1	L10	1
Inf2	Cont2	Client2	S10	3
Inf3	Cont2	Client3	L10	1
Inf2	Cont2	Client3	L10	1
Inf2	Cont4	Client6	L10	1
Inf1	Cont4	Client6	L10	1

source	object	redirect	model	quantity
Inf1	Cont1	Client1	S10	1
Inf1	Cont2	Client1	L10	1
Inf3	Cont2	Client1	L10	1
Inf2	Cont2	Client2	S10	2
Inf2	Cont2	Client3	L10	1
Inf3	Cont2	Client3	L10	1
Inf1	Cont4	Client6	L10	1
Inf2	Cont4	Client6	L10	1