Reporting Project:
hi we have a network filtering app called [login to view URL]
Feel free to test the trial version. You should actually try for sure:-)
Tasks:
Create a Reports section in a new tab in our filter controls
link/button you see from app
What we want:
1. i have login that shows all clients
and how many users they have using the system..
so we can see in report
if client is demo or paying and how many
users or machines and calls they make to Our system( internal API)+ The Proxy
to see if any usage from a demo account or paying account
in summary to see:
From: To:
Client Name # of machines/users # of API/Proxy Calls for filter
Status(DEMO/Active)
1. Create a table that will include the Client(user),his computers(sub clients), Site domain, date, blocked/Allowed, Time Visited(same DB we use now for filter from APP link)
2. Create a traps handler for incoming events from the Client
work with our Programmer
3. Change the current mechanism to create events in the database
4. Create a listing output by Main Client username
showing reports for all his users/Stations by date.
5. Create a back end offline procedure to calculate surfing times on websites
(domain only for now - we care on each site not so much on what page)
6. Reporting for each client login
from as shown in app now
by adding another tab called reports
USING same DB as we use now for this internal DB'
Search By Date Start End
machine/User Name, site URL , Allowed/Blocked , Category (if any) , Time on Site
ex:
Mike Machine Win [login to view URL] blocked Adult 00:01
John Machine Mac [login to view URL] Allowed Social network 00:14:30
rest in zip file