Determining User Count on Websense (Forcepoint)

It is very important to see how many users your Websense proxy counted today, because if you exceed the number of your licence, it means your clients will not be blocked in that day anymore. To see the count, login to SQL Server Management Studio in Triton Manager server, and open a "New Query" window for the catalog database like that;

and run the query below. It will show you the number of the clients that Websense counted in last 100 days.


SELECT TOP (100) PERCENT DAY(date_time) AS day, MONTH(date_time) AS month, YEAR(date_time) AS year, COUNT(DISTINCT source_ip_int) AS ip_count

FROM dbo.incoming WITH (NOLOCK)

GROUP BY DAY(date_time), MONTH(date_time), YEAR(date_time)

ORDER BY month desc, day desc