Choose from several options for complete web, email and data security.
Evaluate Websense products by watching demos and installing evaluation software.
Learn how Websense solutions help keep our customer safe, secure and productive
Get information on product updates, support resources and more.
Get the most out of support in five simple steps.
Find tools and assets to help sell Websense solutions.
Come work for the global leader in unified information security.
You know, it would be really nice and effective and LOGICAL & PRACTICAL to put license usage / seat count in the Websense Manager.
Having to go to the server and do the seat count in DOS is not only cumbersome, but looks unprofessional and poor excuse for a corporate/enterprise class product.
This KB Article looks like a band-aid solution to a missing feature that is supposed to be included in the Websense Manager as a basic functionality to begin with!
I completely agree. I would like to see a live license count and either the source user/ IP so I can report effectively.
When would a feature like this be available?
This would be amazing. I am so sick of having to run consoleclient against each of my ~10 filtering services just to figure out how my licensing is doing.
Would it be too much to ask to make this part of the Broker's database? Or even the log server's database? As long as it's broken out by filtering service and day I'd be estatic. Me personally I wouldn't need to see source IP often, and in the rare instances where I would I wouldn't mind using consoleclient, but having to use it all the time to get basic subscription usage data is ridiculous.
+1 for this feature to be added. The "90%" alert email tends to be more annoying than useful, so a real-time display would be perfect.
Now that I think of it, putting the current user count IN the "90%" alert email would be really useful too! Then I could see my threshold use when it counts most.
I have done a sql job that email to me.Setup sqlmail and scheduled this script.
EXEC msdb.dbo.sp_send_dbmail @profile_name = 'SQL Mail', @recipients = 'firstname.lastname@example.org', @query = 'SELECT COUNT (DISTINCT SOURCE_IP) AS IPs FROM wslogdb70.dbo.INCOMING_VIEW WHERE (DATE_TIME > CAST(CONVERT(VARCHAR(10), GETDATE() - 1, 101) AS DATETIME)) AND (DATE_TIME < CAST(CONVERT(VARCHAR(10), GETDATE(), 101) AS DATETIME))', @subject = 'IPs Count';
Regards Jan Rockstedt
That's going into my bag of tricks.
JACOB SLOAN, CCNA, WCSE
I wrote this query to provide user count stats over the number of days of data - providing max and average counts. Helpful in understanding license usage overall, on weekdays, and weekends. FYI - it takes a little longer to run.
CREATE TABLE #WebsenseLicenseCounts( wDayNum int, wDayName nchar(12), wDateValue datetime, wLicenseCount int )
DECLARE @Rows INTSET @Rows = (SELECT DATEDIFF(DAY, MIN(DATE_TIME), getdate()) FROM wslogdb70.dbo.INCOMING_VIEW (NOLOCK))
DECLARE @DayName nchar(12)DECLARE @DateValue datetimeDECLARE @LicenseCount int
DECLARE @counter intSET @counter = 0WHILE @counter < @Rows BEGIN SET @counter = @counter + 1 SET @DayName = (select DATENAME(dw ,DATEADD(dd, -@counter, GETDATE()))) SET @DateValue = (select DATEADD(dd, -@counter, GETDATE()))
SET @LicenseCount = (SELECT COUNT (DISTINCT SOURCE_IP) AS IPs FROM wslogdb70.dbo.INCOMING_VIEW (NOLOCK) WHERE (DATE_TIME > CAST(CONVERT(VARCHAR(10), DATEADD(dd, -@counter, GETDATE()), 101) AS DATETIME)) AND (DATE_TIME < CAST(CONVERT(VARCHAR(10), DATEADD(dd, -@counter + 1, GETDATE()), 101) AS DATETIME))) INSERT INTO #WebsenseLicenseCounts ( wDayNum, wDayName, wDateValue, wLicenseCount ) VALUES ( @counter, @DayName, @DateValue, @LicenseCount ) END
SELECT MAX(wLicenseCount) AS [Maximum for All Dates] FROM #WebsenseLicenseCounts
SELECT AVG(wLicenseCount) AS [Average for All Dates] FROM #WebsenseLicenseCounts
SELECT AVG(wLicenseCount) AS [Average for WeekDays] FROM #WebsenseLicenseCountsWHERE (DATEPART(WeekDay, wDateValue) != 1) AND (DATEPART(WeekDay, wDateValue) != 7)
SELECT AVG(wLicenseCount) AS [Average for WeekEnds] FROM #WebsenseLicenseCountsWHERE (DATEPART(WeekDay, wDateValue) = 1) OR (DATEPART(WeekDay, wDateValue) = 7)
SELECT MAX(wLicenseCount) AS [Max for WeekEnds] FROM #WebsenseLicenseCountsWHERE (DATEPART(WeekDay, wDateValue) = 1) OR (DATEPART(WeekDay, wDateValue) = 7)
SELECT * FROM #WebsenseLicenseCounts
DROP TABLE #WebsenseLicenseCounts
It provides output such as:
1 Tuesday 2010-08-24 11:24:27.013 38472 Monday 2010-08-23 11:26:10.140 37603 Sunday 2010-08-22 11:27:55.373 16724 Saturday 2010-08-21 11:28:19.297 16725 Friday 2010-08-20 11:28:48.617 35266 Thursday 2010-08-19 11:30:31.990 37527 Wednesday 2010-08-18 11:32:15.957 37488 Tuesday 2010-08-17 11:34:09.637 3760
Maximum for All Dates 3847Average for All Dates 3037Average for WeekDays 3624Average for WeekEnds 1597
Yes, this would be a great feature. Not everyone has the time to create scripts, run SQL queries, run consoleclient, etc. Seems like a simple thing for Websense to add to the interface. Customers are paying for specific user counts and are penalized with unfiltered users or blocked users when they exceed the count. Websense gets reports daily on license counts, why can't they share this with the customer in the interface?
You can use following SQL query if your DB is MS SQL.
This query has to be executed for wslogdb70
SELECT DAY(DATE_TIME), COUNT(DISTINCT SOURCE_IP) AS IPS
FROM INCOMING_VIEW WHERE MONTH(DATE_TIME)=12 AND YEAR(DATE_TIME)=2010
GROUP BY DAY(DATE_TIME)
DAY IPS----------- -----------1 21862 22063 21304 12285 8326 19717 22418 22469 217210 217911 123112 85013 1925(13 row(s) affected)
can you mentioned the location where to run this script and the querie to for mail alert for the same.
need location where to run the script and to run on every day
rigth click on wslogdb70 and select new query
please share the exact location where the wslogdb70 file is located.