Skip to main content
abrigham
abrigham
New Member
May 5, 2017
Question

Detailed User Report on Multiple accounts

  • May 5, 2017
  • 1 reply
  • 5440 views

Hi Everyone,

I work in a school and for obvious reasons we are required to be able to produce a report of Web Activity for a hundreds of students at one time. The built in report only lets you select one username, but I am looking for anyone who can help write a query. The good news is I have a VLAN for each year group of students so its likely a query could be built filter out a network range but must include user name, time & date and web url visited.

 

Any help would be greatly appreciated. 

1 reply

abrigham
abrighamAuthor
New Member
May 5, 2017

I have been playing with the Datasets and I believe something like the following would give me the simple report needed. I could then use the filters in the reports for the time frame and network range.

 

select from_itime(itime) as itime, `user`, `srcip`, `keyword`, `hostname`, `url` from $log where $filter

hzhao_FTNT
Staff
hzhao_FTNT
Staff
May 5, 2017

Hi there,

 

If you want to see one report per student, you have to create a custom report, then clone it for each student and specify user filter on each report. Please also enable report group function under CLI, it will save you lots of time. If the report names are student 001, student 002... in root ADOM,  the CLI will be:

 

config system report group

edit 1 set adom root

set report-like student

config group-by

edit user

end

end

 

regards,

hz

 

 

Terms & ConditionsAccessibility statement