Spectrum Spatial (SSA/LIM)

We were recently asked
"any idea of the number of simultaneous users the current  Spectrum/SSA server is clocking up?"
"how many unique users per day/week/month?"

The only way I could find of starting to look at this was...

1. Enable stats based on https://support.pb.com/help/spectrum/18.2/en/webhelp/Spatial/index.html#PerformanceTuning/source/MonitoringPerformance/UsingJMXPerformanceMonitor.html

2. This gives output like


3. I also noticed https://support.pitneybowes.com/VFP06_KnowledgeWithSidebarTroubleshoot?id=kA2800000004MU9CAM&popup=false&lang=en_US but neither article mentions where the stats file is. I checked some of the log files but these (connect-date.log) seem to only show errors...




------------------------------
George Corea
Mangoesmapping
------------------------------

Hi George
We are about to go to market with MapStats - an application that tracks usage with SSA. I'll send some screenshots later and happy to discuss further.
Rob Rowell, Insight GIS

------------------------------
Rob Rowell
MD
INSIGHT GIS
Hobart
------------------------------

Original Message:
Sent: 12-04-2019 21:34
From: George Corea
Subject: Get usage statistics from Spectrum/SSA 2018

We were recently asked
"any idea of the number of simultaneous users the current  Spectrum/SSA server is clocking up?"
"how many unique users per day/week/month?"

The only way I could find of starting to look at this was...

1. Enable stats based on https://support.pb.com/help/spectrum/18.2/en/webhelp/Spatial/index.html#PerformanceTuning/source/MonitoringPerformance/UsingJMXPerformanceMonitor.html

2. This gives output like

It doesn't seem very useful for seeing the number of concurrent users/total users for the day/week/month.

3. I also noticed https://support.pitneybowes.com/VFP06_KnowledgeWithSidebarTroubleshoot?id=kA2800000004MU9CAM&popup=false&lang=en_US but neither article mentions where the stats file is. I checked some of the log files but these (connect-date.log) seem to only show errors...

4. localhost_access_log-date.txt seems to be close to what I want...but the ip's are the same. This is an internal system but still I would expect different IP's

This could be analysed as in the process I quickly created and linked below but I don't think this is unique views - it's just hits that aren't at the same time https://docs.google.com/spreadsheets/d/19qgEHyC6tbOTE79BZrn21xcER1kuWrXpmKUKE3mglaA/edit?usp=sharing


Is there a log file I could use regex on to count the unique IP's and session times?

I'd also like to be able to know how long a user is on a page - can we install Google Analytics?

------------------------------
George Corea
Mangoesmapping
------------------------------

Hi George


Here are a couple of images of MapStats - happy to discuss further

------------------------------
Rob Rowell
MD
INSIGHT GIS
Hobart
------------------------------

Original Message:
Sent: 12-05-2019 03:26
From: Rob Rowell
Subject: Get usage statistics from Spectrum/SSA 2018

Hi George
We are about to go to market with MapStats - an application that tracks usage with SSA. I'll send some screenshots later and happy to discuss further.
Rob Rowell, Insight GIS

------------------------------
Rob Rowell
MD
INSIGHT GIS
Hobart

Original Message:
Sent: 12-04-2019 21:34
From: George Corea
Subject: Get usage statistics from Spectrum/SSA 2018

We were recently asked
"any idea of the number of simultaneous users the current  Spectrum/SSA server is clocking up?"
"how many unique users per day/week/month?"

The only way I could find of starting to look at this was...

1. Enable stats based on https://support.pb.com/help/spectrum/18.2/en/webhelp/Spatial/index.html#PerformanceTuning/source/MonitoringPerformance/UsingJMXPerformanceMonitor.html

2. This gives output like

It doesn't seem very useful for seeing the number of concurrent users/total users for the day/week/month.

3. I also noticed https://support.pitneybowes.com/VFP06_KnowledgeWithSidebarTroubleshoot?id=kA2800000004MU9CAM&popup=false&lang=en_US but neither article mentions where the stats file is. I checked some of the log files but these (connect-date.log) seem to only show errors...

4. localhost_access_log-date.txt seems to be close to what I want...but the ip's are the same. This is an internal system but still I would expect different IP's

This could be analysed as in the process I quickly created and linked below but I don't think this is unique views - it's just hits that aren't at the same time https://docs.google.com/spreadsheets/d/19qgEHyC6tbOTE79BZrn21xcER1kuWrXpmKUKE3mglaA/edit?usp=sharing


Is there a log file I could use regex on to count the unique IP's and session times?

I'd also like to be able to know how long a user is on a page - can we install Google Analytics?

------------------------------
George Corea
Mangoesmapping
------------------------------

This looks super cool Rob!

------------------------------
Arkadiusz Gotfryd
Knowledge Community Shared Account
Shelton CT
------------------------------

Original Message:
Sent: 12-06-2019 00:41
From: Rob Rowell
Subject: Get usage statistics from Spectrum/SSA 2018

Hi George


Here are a couple of images of MapStats - happy to discuss further

------------------------------
Rob Rowell
MD
INSIGHT GIS
Hobart

Original Message:
Sent: 12-05-2019 03:26
From: Rob Rowell
Subject: Get usage statistics from Spectrum/SSA 2018

Hi George
We are about to go to market with MapStats - an application that tracks usage with SSA. I'll send some screenshots later and happy to discuss further.
Rob Rowell, Insight GIS

------------------------------
Rob Rowell
MD
INSIGHT GIS
Hobart

Original Message:
Sent: 12-04-2019 21:34
From: George Corea
Subject: Get usage statistics from Spectrum/SSA 2018

We were recently asked
"any idea of the number of simultaneous users the current  Spectrum/SSA server is clocking up?"
"how many unique users per day/week/month?"

The only way I could find of starting to look at this was...

1. Enable stats based on https://support.pb.com/help/spectrum/18.2/en/webhelp/Spatial/index.html#PerformanceTuning/source/MonitoringPerformance/UsingJMXPerformanceMonitor.html

2. This gives output like

It doesn't seem very useful for seeing the number of concurrent users/total users for the day/week/month.

3. I also noticed https://support.pitneybowes.com/VFP06_KnowledgeWithSidebarTroubleshoot?id=kA2800000004MU9CAM&popup=false&lang=en_US but neither article mentions where the stats file is. I checked some of the log files but these (connect-date.log) seem to only show errors...

4. localhost_access_log-date.txt seems to be close to what I want...but the ip's are the same. This is an internal system but still I would expect different IP's

This could be analysed as in the process I quickly created and linked below but I don't think this is unique views - it's just hits that aren't at the same time https://docs.google.com/spreadsheets/d/19qgEHyC6tbOTE79BZrn21xcER1kuWrXpmKUKE3mglaA/edit?usp=sharing


Is there a log file I could use regex on to count the unique IP's and session times?

I'd also like to be able to know how long a user is on a page - can we install Google Analytics?

------------------------------
George Corea
Mangoesmapping
------------------------------

Wow...that's really great. Is there anything to install to get this to work? or does it analyse some existing log?

It will be a wonderful resource...can we beta test?

------------------------------
George Corea
Mangoesmapping
------------------------------

Original Message:
Sent: 12-06-2019 00:41
From: Rob Rowell
Subject: Get usage statistics from Spectrum/SSA 2018

Hi George


Here are a couple of images of MapStats - happy to discuss further

------------------------------
Rob Rowell
MD
INSIGHT GIS
Hobart

Original Message:
Sent: 12-05-2019 03:26
From: Rob Rowell
Subject: Get usage statistics from Spectrum/SSA 2018

Hi George
We are about to go to market with MapStats - an application that tracks usage with SSA. I'll send some screenshots later and happy to discuss further.
Rob Rowell, Insight GIS

------------------------------
Rob Rowell
MD
INSIGHT GIS
Hobart

Original Message:
Sent: 12-04-2019 21:34
From: George Corea
Subject: Get usage statistics from Spectrum/SSA 2018

We were recently asked
"any idea of the number of simultaneous users the current  Spectrum/SSA server is clocking up?"
"how many unique users per day/week/month?"

The only way I could find of starting to look at this was...

1. Enable stats based on https://support.pb.com/help/spectrum/18.2/en/webhelp/Spatial/index.html#PerformanceTuning/source/MonitoringPerformance/UsingJMXPerformanceMonitor.html

2. This gives output like

It doesn't seem very useful for seeing the number of concurrent users/total users for the day/week/month.

3. I also noticed https://support.pitneybowes.com/VFP06_KnowledgeWithSidebarTroubleshoot?id=kA2800000004MU9CAM&popup=false&lang=en_US but neither article mentions where the stats file is. I checked some of the log files but these (connect-date.log) seem to only show errors...

4. localhost_access_log-date.txt seems to be close to what I want...but the ip's are the same. This is an internal system but still I would expect different IP's

This could be analysed as in the process I quickly created and linked below but I don't think this is unique views - it's just hits that aren't at the same time https://docs.google.com/spreadsheets/d/19qgEHyC6tbOTE79BZrn21xcER1kuWrXpmKUKE3mglaA/edit?usp=sharing


Is there a log file I could use regex on to count the unique IP's and session times?

I'd also like to be able to know how long a user is on a page - can we install Google Analytics?

------------------------------
George Corea
Mangoesmapping
------------------------------

Hi @Rob Rowell, happy to receive further info on this product when it's available.​  Very interesting!!   

If I can Beta test for you, please let me know.

Cheers

Tim

------------------------------
Tim Warfe
GIS Officer
MOORABOOL SHIRE COUNCIL
------------------------------

Original Message:
Sent: 12-06-2019 00:41
From: Rob Rowell
Subject: Get usage statistics from Spectrum/SSA 2018

Hi George


Here are a couple of images of MapStats - happy to discuss further

------------------------------
Rob Rowell
MD
INSIGHT GIS
Hobart

Original Message:
Sent: 12-05-2019 03:26
From: Rob Rowell
Subject: Get usage statistics from Spectrum/SSA 2018

Hi George
We are about to go to market with MapStats - an application that tracks usage with SSA. I'll send some screenshots later and happy to discuss further.
Rob Rowell, Insight GIS

------------------------------
Rob Rowell
MD
INSIGHT GIS
Hobart

Original Message:
Sent: 12-04-2019 21:34
From: George Corea
Subject: Get usage statistics from Spectrum/SSA 2018

We were recently asked
"any idea of the number of simultaneous users the current  Spectrum/SSA server is clocking up?"
"how many unique users per day/week/month?"

The only way I could find of starting to look at this was...

1. Enable stats based on https://support.pb.com/help/spectrum/18.2/en/webhelp/Spatial/index.html#PerformanceTuning/source/MonitoringPerformance/UsingJMXPerformanceMonitor.html

2. This gives output like

It doesn't seem very useful for seeing the number of concurrent users/total users for the day/week/month.

3. I also noticed https://support.pitneybowes.com/VFP06_KnowledgeWithSidebarTroubleshoot?id=kA2800000004MU9CAM&popup=false&lang=en_US but neither article mentions where the stats file is. I checked some of the log files but these (connect-date.log) seem to only show errors...

4. localhost_access_log-date.txt seems to be close to what I want...but the ip's are the same. This is an internal system but still I would expect different IP's

This could be analysed as in the process I quickly created and linked below but I don't think this is unique views - it's just hits that aren't at the same time https://docs.google.com/spreadsheets/d/19qgEHyC6tbOTE79BZrn21xcER1kuWrXpmKUKE3mglaA/edit?usp=sharing


Is there a log file I could use regex on to count the unique IP's and session times?

I'd also like to be able to know how long a user is on a page - can we install Google Analytics?

------------------------------
George Corea
Mangoesmapping
------------------------------

Hello George,

I had written this article a couple of months ago, does this help? 

Configuring Usage Statistics in Spectrum Spatial Analyst
https://support.pitneybowes.com/SearchArticles/VFP05_KnowledgeWithSidebarHowTo?id=kA11E000000k9dYSAQ&popup=false;&lang=en_US

------------------------------
Susan Bardet
Software & Data support EMEA
susan.bardet@pb.com

Pitney Bowes
Davidson House, Forbury Square
Reading RG1 3EU
Berkshire, United Kingdom
pitneybowes.com
------------------------------

Original Message:
Sent: 12-04-2019 21:34
From: George Corea
Subject: Get usage statistics from Spectrum/SSA 2018

We were recently asked
"any idea of the number of simultaneous users the current  Spectrum/SSA server is clocking up?"
"how many unique users per day/week/month?"

The only way I could find of starting to look at this was...

1. Enable stats based on https://support.pb.com/help/spectrum/18.2/en/webhelp/Spatial/index.html#PerformanceTuning/source/MonitoringPerformance/UsingJMXPerformanceMonitor.html

2. This gives output like

It doesn't seem very useful for seeing the number of concurrent users/total users for the day/week/month.

3. I also noticed https://support.pitneybowes.com/VFP06_KnowledgeWithSidebarTroubleshoot?id=kA2800000004MU9CAM&popup=false&lang=en_US but neither article mentions where the stats file is. I checked some of the log files but these (connect-date.log) seem to only show errors...

4. localhost_access_log-date.txt seems to be close to what I want...but the ip's are the same. This is an internal system but still I would expect different IP's

This could be analysed as in the process I quickly created and linked below but I don't think this is unique views - it's just hits that aren't at the same time https://docs.google.com/spreadsheets/d/19qgEHyC6tbOTE79BZrn21xcER1kuWrXpmKUKE3mglaA/edit?usp=sharing


Is there a log file I could use regex on to count the unique IP's and session times?

I'd also like to be able to know how long a user is on a page - can we install Google Analytics?

------------------------------
George Corea
Mangoesmapping
------------------------------

Thank you @Susan Bardet for the article.

I'll have a crack at turning this on, uploading the data to SQL using FME and displaying the information in PowerBI.

Happy to share my results when I get something useful.

Cheers

Tim​

------------------------------
Tim Warfe
GIS Officer
MOORABOOL SHIRE COUNCIL
------------------------------

Original Message:
Sent: 12-11-2019 08:00
From: Susan Bardet
Subject: Get usage statistics from Spectrum/SSA 2018

Hello George,

I had written this article a couple of months ago, does this help?

Configuring Usage Statistics in Spectrum Spatial Analyst
https://support.pitneybowes.com/SearchArticles/VFP05_KnowledgeWithSidebarHowTo?id=kA11E000000k9dYSAQ&popup=false;&lang=en_US

------------------------------
Susan Bardet
Software & Data support EMEA
susan.bardet@pb.com

Pitney Bowes
Davidson House, Forbury Square
Reading RG1 3EU
Berkshire, United Kingdom
pitneybowes.com

Original Message:
Sent: 12-04-2019 21:34
From: George Corea
Subject: Get usage statistics from Spectrum/SSA 2018

We were recently asked
"any idea of the number of simultaneous users the current  Spectrum/SSA server is clocking up?"
"how many unique users per day/week/month?"

The only way I could find of starting to look at this was...

1. Enable stats based on https://support.pb.com/help/spectrum/18.2/en/webhelp/Spatial/index.html#PerformanceTuning/source/MonitoringPerformance/UsingJMXPerformanceMonitor.html

2. This gives output like

It doesn't seem very useful for seeing the number of concurrent users/total users for the day/week/month.

3. I also noticed https://support.pitneybowes.com/VFP06_KnowledgeWithSidebarTroubleshoot?id=kA2800000004MU9CAM&popup=false&lang=en_US but neither article mentions where the stats file is. I checked some of the log files but these (connect-date.log) seem to only show errors...

4. localhost_access_log-date.txt seems to be close to what I want...but the ip's are the same. This is an internal system but still I would expect different IP's

This could be analysed as in the process I quickly created and linked below but I don't think this is unique views - it's just hits that aren't at the same time https://docs.google.com/spreadsheets/d/19qgEHyC6tbOTE79BZrn21xcER1kuWrXpmKUKE3mglaA/edit?usp=sharing


Is there a log file I could use regex on to count the unique IP's and session times?

I'd also like to be able to know how long a user is on a page - can we install Google Analytics?

------------------------------
George Corea
Mangoesmapping
------------------------------

Original Message------

Thank you @Susan Bardet for the article.

I'll have a crack at turning this on, uploading the data to SQL using FME and displaying the information in PowerBI.

Happy to share my results when I get something useful.

Cheers

Tim​

------------------------------
Tim Warfe
GIS Officer
MOORABOOL SHIRE COUNCIL
------------------------------

Hello George,

Please open a case with Technical support (software.support@pb.com​), and we shall help you with this and take a closer look at your files and requirements. 

Best regards

------------------------------
Susan Bardet
Software & Data support EMEA
susan.bardet@pb.com

Pitney Bowes
Davidson House, Forbury Square
Reading RG1 3EU
Berkshire, United Kingdom
pitneybowes.com
------------------------------

Original Message:
Sent: 12-13-2019 07:41
From: George Corea
Subject: Get usage statistics from Spectrum/SSA 2018

Thanks Susan,

I am getting these logs but the admin console reports tool just keeps coming back with "No record found!"

But there is data in the log and I have used regex to analyze them as in the example in the original post but I had some questions...

In C:\Program Files\Pitney Bowes\SpectrumSpatialAnalyst\Tomcat\AnalystConnect\logs I see

are these the logs activated in the process in your article?

localhost_access_log-date.txt seems to be close to what I want...but the ip's are the same. This is an internal system but still I would expect different IP's

This could be analysed as in the process I quickly created and linked below but I don't think this is unique views - it's just hits that aren't at the same time https://docs.google.com/spreadsheets/d/19qgEHyC6tbOTE79BZrn21xcER1kuWrXpmKUKE3mglaA/edit?usp=sharing


Is there a log file I could use regex on to count the unique IP's and session times?

Original Message------

Thank you @Susan Bardet for the article.

I'll have a crack at turning this on, uploading the data to SQL using FME and displaying the information in PowerBI.

Happy to share my results when I get something useful.

Cheers

Tim​

------------------------------
Tim Warfe
GIS Officer
MOORABOOL SHIRE COUNCIL
------------------------------