Why is there no network printer connection?

Question

SQL

There is a Canon6100 printer, the print management role is installed on the AD server. The printer is installed there and tied to the user through group policy. gpresult /r says the GPU has applied. gpresult /h says there are no errors. But the printer does not appear. Everything is ok with other printers. Where to look?

Answer 1

select 
iduser,
sum(reward)
from ochk 
where EXTRACT(YEAR_MONTH FROM dateadd) = EXTRACT(YEAR_MONTH FROM CURRENT_DATE()) 
group dy iduser;

Answer 2

It turned out that if in the printer properties on the "Access" tab you do not check the publish in AD checkbox, then it will not connect.