Count of active document

poonam_kulwal — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have data for QV server session log.

Data is about when the document opened and closed on access point.

I want to count concurrent sessions for document on Daily/Hourly basis.

Sample data in first pic.

In above data, row number 6, document was active for hour 10 and hour 11.

Row number 15, document was active for hour 14, hour 15 and hour 16.

I want hourly count when document was active.

Basically result as sown below

This is sample data. I have data for multiple servers, multiple documents and I have 3 years data.

Appreciate your help on this.

Thanks & Regards,

Poonam

Re: Count of active document

JordyWegman — Tue, 04 Jun 2019 15:06:21 GMT

Hi,

First get with DoDir and a For each loop all the session logs.

Then create a timetable for all hours/minutes/seconds.

Map all the session logs to this table.

Load the table and do a count on the hours.

Jordy

Climber