Hello,
We have some logs generated by video conference systems that we use to create utilization and quality report. Now, we would like to create a report showing room usage by time of day. The log data has the following fields
Room Name, Meeting Start time and Duration
So lets assume that room A3 has a meeting at 4:00 PM for 90 Minutes. I would like to create a report that looks like this:
Time Room A3 Active
15:00 No
15:15 No
15:30 No
15:45 No
16:00 Yes
16:15 Yes
16:30 Yes
16:45 Yes
17:00 Yes
17:15 Yes
17:30 Yes
17:45 No
18:00 No
18:15 No
18:30 No
I know we can do this in Excel but I would like to move to this to Splunk but I can't figure this out. Anyone have any ideas?
... View more