topic Re: How do I run a query for a user's Internet activity and create a table by date and url? in Splunk Search

How do I run a query for a user's Internet activity and create a table by date and url?

rsmaddox — Fri, 07 Sep 2018 16:32:43 GMT

I need to run a query for a user's Internet activity. I would like to create a table/report for the output that's limited to date, and URL. Thank you.

Re: How do I run a query for a user's Internet activity and create a table by date and url?

horsefez — Fri, 07 Sep 2018 16:46:18 GMT

DEPENDS

Do you want to make a statistic about the internet usage of users in your company or about the users that use your splunk system?

if COMPANY USERS
Do you have any proxy logs in your splunk system?

if SPLUNK USERS
Check out index=_internal source="*ui_access*"

Re: How do I run a query for a user's Internet activity and create a table by date and url?

renjith_nair — Fri, 07 Sep 2018 16:49:26 GMT

index="my_user_index" user="my_user"|timechart count by url,

Re: How do I run a query for a user's Internet activity and create a table by date and url?

rsmaddox — Fri, 07 Sep 2018 16:54:26 GMT

Sorry for the ambiguity. I need to generate a report on Internet (Web) activity. In other words, the URLs visited by a specific user, over a specified time range. I've run the index=proxy query successfully, but like to transform the results into a table with "URL," "Date," and "User" fields/columns.

Re: How do I run a query for a user's Internet activity and create a table by date and url?

rsmaddox — Fri, 07 Sep 2018 16:59:45 GMT

Thanks. I'll give that a try.