First requirement can be achieved through RBAC reporting through report studio only.
Query1 with Users with Role Filter
Q2 with Users except (Not equal to clause) above Role Filter
Final query Q1(Minus)Q2
Second requirement have to be SQL Based report:
SELECT DISTINCT NAME FROM D_SERVER WHERE IS_LATEST_VERSION=1 AND IS_DECOMMISSION=0 AND SERVER_ID NOT IN (SELECT SERVER_ID B_SERVER_ALLOWED_ROLE)