Websense Web Security

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

elnivek — Tue, 14 May 2013 01:13:59 GMT

bump...

Still no closer...

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

snathaniel — Wed, 06 Feb 2013 16:56:22 GMT

Is there any danger of this seemingly simple bit of functionality been added to WebSense Web Security? A year on and as far as I'm aware we're still no closer....

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

Jan Rockstedt — Fri, 16 Dec 2011 07:11:51 GMT

Phil,

Any date for it?

Jan

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

phylliszh — Fri, 16 Dec 2011 01:34:14 GMT

Already had this under consideration. Will update you by tech alert if there is a new release for that.

Phil

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

NY_North — Thu, 15 Dec 2011 12:04:25 GMT

PaulJ:

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

+1 I agree please add to the management console.

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

dwalker — Sun, 13 Nov 2011 15:02:37 GMT

open you sql management studio and right click on the wslogdb70 database, select properties > files , look at the file location. this is the path to the database file. see below on how to run a sql query http://www.serverintellect.com/support/sqlserver/sql-query.aspx

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

Rajadurai — Mon, 31 Oct 2011 18:32:06 GMT

hi,

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

thx.

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

hazrat — Wed, 26 Oct 2011 06:59:05 GMT

hi,

rigth click on wslogdb70 and select new query

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

hazrat — Wed, 26 Oct 2011 06:59:02 GMT

hi,

rigth click on wslogdb70 and select new query

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

Rajadurai — Tue, 25 Oct 2011 00:37:58 GMT

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

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

Rajadurai — Tue, 25 Oct 2011 00:36:29 GMT

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

thx,

Raj

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

Ravikiran — Thu, 16 Dec 2010 14:19:23 GMT

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)

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

Derek Ueki — Fri, 27 Aug 2010 20:24:50 GMT

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?

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

Maritz — Wed, 25 Aug 2010 19:16:17 GMT

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

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

J Sloan — Wed, 10 Feb 2010 14:11:49 GMT

That's going into my bag of tricks.