cancel
Showing results for 
Search instead for 
Did you mean: 
imanfauzi
Level 7

Log time on database Web Reporter

Jump to solution

Hi All,

I want to ask about database web reporter,

I've search the log time when user access / browse some web, but no data.

my customer want to create a table for their reporting with a date / time from Web Reporter's Database.

Please advise..

Many Thanks,

Iman Fauzi

1 Solution

Accepted Solutions
yuems
Level 11

Re: Log time on database Web Reporter

Jump to solution

Hi,

Web Reporter DB collect time data as epoch time.
Webreportertimedata.jpg

You may use this web site to convert this date-time data to epoch format.
Epoch Converter - Unix Timestamp Converter

or

Date/Epoch Time Converter - JavaScript Utilities/Tools - ESQSoft

Then use epoch time format for your queries.

Example:

Epoch timestamp: 1412072022

Timestamp in milliseconds: 1412072022000

Human time (GMT): Tue, 30 Sep 2014 10:13:42 GMT

Kind Regards.

11 Replies
mbagheryan
Level 12

Re: Log time on database Web Reporter

Jump to solution

At first you have to check the server registration inepo then can do this from ePO query to make a special report.

0 Kudos
imanfauzi
Level 7

Re: Log time on database Web Reporter

Jump to solution

I don't install epo, i only have licensed for web gateway and web reporter anyway.

0 Kudos
mbagheryan
Level 12

Re: Log time on database Web Reporter

Jump to solution

imanfauzi wrote:



Hi All,



I want to ask about database web reporter,


I've search the log time when user access / browse some web, but no data.


my customer want to create a table for their reporting with a date / time from Web Reporter's Database.



Please advise..


Many Thanks,



Iman Fauzi



It is free and you can download then install it under your Grant Number.

0 Kudos
mbagheryan
Level 12

Re: Log time on database Web Reporter

Jump to solution
0 Kudos
imanfauzi
Level 7

Re: Log time on database Web Reporter

Jump to solution

Hi Movses,

Thanks for your information,

i asking about log time on SQL Database Web Reporter.

because we need to create a query from several database into one executive report. (database HR, database web reporter and database audit)

where can i find a log time on SQL Database Web Reporter?

0 Kudos
mbagheryan
Level 12

Re: Log time on database Web Reporter

Jump to solution

As far as I remember it will set During the Configuration of web reporter.

0 Kudos
yuems
Level 11

Re: Log time on database Web Reporter

Jump to solution

Hi,

Web Reporter DB collect time data as epoch time.
Webreportertimedata.jpg

You may use this web site to convert this date-time data to epoch format.
Epoch Converter - Unix Timestamp Converter

or

Date/Epoch Time Converter - JavaScript Utilities/Tools - ESQSoft

Then use epoch time format for your queries.

Example:

Epoch timestamp: 1412072022

Timestamp in milliseconds: 1412072022000

Human time (GMT): Tue, 30 Sep 2014 10:13:42 GMT

Kind Regards.

imanfauzi
Level 7

Re: Log time on database Web Reporter

Jump to solution

Many Thanks yoems,

then i have to convert all epoch time then insert to my report manually?