cancel
Showing results for 
Search instead for 
Did you mean: 
cawighton
Level 9

Web Reporter Custom Report - IP Connection Summary

Jump to solution

Hi All

I have a business requirement to create a Web Reporter summary report of how many different IP's were logged for each day.

The report may look something like:

Date     Total User IP     Total Bytes      Total Hits

16/7/12     499                    800 M               29000

17/7/12     520                    850 M               32000

......  for all avaliable dates

Where Total User IP is the amount of unique IPs used for a particular day.  Total Bytes / Hits is the rollout count of the traffic the User IPs generated.

Anyone help me out here please !!

Cheers

Craig

0 Kudos
1 Solution

Accepted Solutions
eelsasser
Level 15

Re: Web Reporter Custom Report - IP Connection Summary

Jump to solution

Piece of cake...

Create a table query on the summary file with Date, IP address, hits, and bytes.

On the IP address column checkmark Count Distinct.

Capture.jpg

Put the query in a report and run.

I've attached an exported report definition and the output.

0 Kudos
5 Replies
eelsasser
Level 15

Re: Web Reporter Custom Report - IP Connection Summary

Jump to solution

Piece of cake...

Create a table query on the summary file with Date, IP address, hits, and bytes.

On the IP address column checkmark Count Distinct.

Capture.jpg

Put the query in a report and run.

I've attached an exported report definition and the output.

0 Kudos
cawighton
Level 9

Re: Web Reporter Custom Report - IP Connection Summary

Jump to solution

Excellent - Seems to work well.... many thanks....    .

....however... Im seeing only 4 lines of data. I presume this is becuase I have not got the Premium features enabled ?

0 Kudos
eelsasser
Level 15

Re: Web Reporter Custom Report - IP Connection Summary

Jump to solution

Yes. That would be the reason there are only 4 entries.

0 Kudos
cawighton
Level 9

Re: Web Reporter Custom Report - IP Connection Summary

Jump to solution

Yep - thought so - no worries - time to part with $$.

Thanks muchly for your help.

Cheers

Craig

0 Kudos
eelsasser
Level 15

Re: Web Reporter Custom Report - IP Connection Summary

Jump to solution

You could also try out the new Content Security Reporter.

It will be the successor to Web Reporter eventually.

It is based on an ePO interface and uses ePO queries...and it's free to all owners of MWG.

Capture.jpg

Plus it gives pretty drill-down dashboards.

Capture2.jpg

Do you use ePO at all? If not, check your grant number and download it.

I have a bundle ePO, SQL, CSR and a lot of the packages and extensions used for web and SaaS all rolled into a simple one-click install.

Let me know if you want it and I'll point you to the download.

0 Kudos