Show License Usage in Websense Manager v7.x PLEASE!!!!

Reply

ITVancouverSupport Posted: 17 Dec 2009 9:54 AM

rated by 0 users

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.

http://www.websense.com/support/article/t-kbarticle/How-do-I-get-a-seat-count-and-list-of-IP-addresses-for-my-Websense-users

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!

Reply

medcath replied on 7 Jan 2010 6:16 AM

rated by 0 users

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?

Reply

Tessien replied on 18 Jan 2010 8:05 AM

rated by 0 users

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.

Reply

PaulJ replied on 5 Feb 2010 11:01 AM

rated by 0 users

+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.

Reply

Jan Rockstedt replied on 10 Feb 2010 5:48 AM

rated by 0 users

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 = 'j.r@domain.com',
     @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';

Jan

Reply

J Sloan replied on 10 Feb 2010 6:11 AM

rated by 0 users

That's going into my bag of tricks.

Reply

Maritz replied on 25 Aug 2010 12:16

rated by 0 users

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 INT
SET @Rows = (SELECT DATEDIFF(DAY, MIN(DATE_TIME), getdate()) FROM wslogdb70.dbo.INCOMING_VIEW (NOLOCK))

DECLARE @DayName nchar(12)
DECLARE @DateValue datetime
DECLARE @LicenseCount int

DECLARE @counter int
SET @counter = 0
WHILE @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 #WebsenseLicenseCounts
WHERE (DATEPART(WeekDay, wDateValue) != 1)
AND (DATEPART(WeekDay, wDateValue) != 7)

SELECT AVG(wLicenseCount) AS [Average for WeekEnds] FROM #WebsenseLicenseCounts
WHERE (DATEPART(WeekDay, wDateValue) = 1)
OR (DATEPART(WeekDay, wDateValue) = 7)

SELECT MAX(wLicenseCount) AS [Max for WeekEnds] FROM #WebsenseLicenseCounts
WHERE (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                3847
2 Monday           2010-08-23 11:26:10.140                3760
3 Sunday           2010-08-22 11:27:55.373                1672
4 Saturday         2010-08-21 11:28:19.297                1672
5 Friday              2010-08-20 11:28:48.617                3526
6 Thursday         2010-08-19 11:30:31.990               3752
7 Wednesday    2010-08-18 11:32:15.957                3748
8 Tuesday          2010-08-17 11:34:09.637                3760

Maximum for All Dates   3847
Average for All Dates      3037
Average for WeekDays   3624
Average for WeekEnds  1597

Reply

Derek Ueki replied on 27 Aug 2010 1:24

rated by 0 users

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?

Reply

Ravikiran replied on 16 Dec 2010 6:19 AM

rated by 0 users

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)

Result Sample

======================

  DAY       IPS
----------- -----------
1           2186
2           2206
3           2130
4           1228
5           832
6           1971
7           2241
8           2246
9           2172
10          2179
11          1231
12          850
13          1925

(13 row(s) affected)

Reply

Rajadurai replied on 24 Oct 2011 5:36

rated by 0 users

can you mentioned the location where to run this script and the querie to for mail alert for the same.

thx,

Raj

Reply

Rajadurai replied on 24 Oct 2011 5:37

rated by 0 users

need location where to run the script and to run on every day

Reply

hazrat replied on 25 Oct 2011 11:59

rated by 0 users

hi,

rigth click on wslogdb70 and select new query

Reply

hazrat replied on 25 Oct 2011 11:59

rated by 0 users

hi,

rigth click on wslogdb70 and select new query

Reply

Rajadurai replied on 31 Oct 2011 11:32 AM

rated by 0 users

hi,

please share the exact location where the wslogdb70 file is located.

thx.