[
https://issues.apache.org/jira/browse/CLOUDSTACK-4291?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kishan Kavala resolved CLOUDSTACK-4291.
---------------------------------------
Resolution: Fixed
> listusage record is not lisitng records for VPN users
> -----------------------------------------------------
>
> Key: CLOUDSTACK-4291
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-4291
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Components: Usage
> Affects Versions: 4.2.0
> Reporter: shweta agarwal
> Assignee: Kishan Kavala
> Priority: Blocker
> Fix For: 4.2.0
>
>
> Started Usage server
> Created vpn users
> Once usage server has processed the job call listusage record api with type
> =14
> list usagerecords startdate=2013-08-07 enddate=2013-08-14 accountid=5 type=14
> usage_events shows entries for vpn users:
> "id" "type" "account_id" "created" "zone_id" "resource_id"
> "resource_name" "offering_id" "template_id" "size" "resource_type"
> "processed" "virtual_size"
> "2605" "VPN.USER.ADD" "5" "2013-08-12 11:46:28" "0" "1"
> "bcd" "" "" "" "" "1" ""
> "2606" "VPN.USER.ADD" "5" "2013-08-12 11:46:47" "0" "2"
> "czszd" "" "" "" "" "1" ""
> "2609" "VPN.USER.ADD" "5" "2013-08-12 11:47:37" "0" "1"
> "bcd" "" "" "" "" "1" ""
> "2607" "VPN.USER.REMOVE" "5" "2013-08-12 11:47:08" "0"
> "2" "czszd" "" "" "" "" "1" ""
> "2608" "VPN.USER.REMOVE" "5" "2013-08-12 11:47:17" "0"
> "1" "bcd" "" "" "" "" "1" ""
> cloud_usage table shows :
> "id" "zone_id" "account_id" "domain_id" "description"
> "usage_display" "usage_type" "raw_usage" "vm_instance_id"
> "vm_name" "offering_id" "template_id" "usage_id" "type"
> "size" "network_id" "start_date" "end_date" "virtual_size"
> "170101" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.053334 Hrs" "14" "0.0533341690897942" "" "" "" ""
> "1" "" "" "" "2013-08-12 11:40:25" "2013-08-12
> 11:50:00" ""
> "170102" "0" "5" "1" "VPN User: czszd, Id: 2 usage time"
> "0.005834 Hrs" "14" "0.00583361089229584" "" "" "" ""
> "2" "" "" "" "2013-08-12 11:40:25" "2013-08-12
> 11:50:00" ""
> "170271" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166683 Hrs" "14" "0.16668276488781" "" "" "" ""
> "1" "" "" "" "2013-08-12 11:50:00" "2013-08-12
> 12:00:00" ""
> "170440" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.005311 Hrs" "14" "0.00531111098825932" "" "" "" ""
> "1" "" "" "" "2013-08-12 12:00:00" "2013-08-12
> 12:00:19" ""
> "170609" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.161375 Hrs" "14" "0.161374717950821" "" "" "" ""
> "1" "" "" "" "2013-08-12 12:00:19" "2013-08-12
> 12:10:00" ""
> "170778" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166638 Hrs" "14" "0.166638046503067" "" "" "" ""
> "1" "" "" "" "2013-08-12 12:10:00" "2013-08-12
> 12:20:00" ""
> "170947" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.003176 Hrs" "14" "0.00317638879641891" "" "" "" ""
> "1" "" "" "" "2013-08-12 12:20:00" "2013-08-12
> 12:20:11" ""
> "171116" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.163484 Hrs" "14" "0.163483619689941" "" "" "" ""
> "1" "" "" "" "2013-08-12 12:20:11" "2013-08-12
> 12:30:00" ""
> "171286" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166686 Hrs" "14" "0.166685551404953" "" "" "" ""
> "1" "" "" "" "2013-08-12 12:30:00" "2013-08-12
> 12:40:00" ""
> "171456" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.002935 Hrs" "14" "0.00293472199700773" "" "" "" ""
> "1" "" "" "" "2013-08-12 12:40:00" "2013-08-12
> 12:40:10" ""
> "171626" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.163713 Hrs" "14" "0.163713321089745" "" "" "" ""
> "1" "" "" "" "2013-08-12 12:40:10" "2013-08-12
> 12:50:00" ""
> "171796" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166666 Hrs" "14" "0.166666403412819" "" "" "" ""
> "1" "" "" "" "2013-08-12 12:50:00" "2013-08-12
> 13:00:00" ""
> "171966" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 13:00:00" "2013-08-12
> 13:10:00" ""
> "172136" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 13:10:00" "2013-08-12
> 13:20:00" ""
> "172306" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 13:20:00" "2013-08-12
> 13:30:00" ""
> "172477" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 13:30:00" "2013-08-12
> 13:40:00" ""
> "172647" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.16669 Hrs" "14" "0.16669000685215" "" "" "" ""
> "1" "" "" "" "2013-08-12 13:40:00" "2013-08-12
> 13:50:00" ""
> "172817" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166643 Hrs" "14" "0.166643336415291" "" "" "" ""
> "1" "" "" "" "2013-08-12 13:50:00" "2013-08-12
> 14:00:00" ""
> "172987" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 14:00:00" "2013-08-12
> 14:10:00" ""
> "173157" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 14:10:00" "2013-08-12
> 14:20:00" ""
> "173327" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 14:20:00" "2013-08-12
> 14:30:00" ""
> "173498" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 14:30:00" "2013-08-12
> 14:40:00" ""
> "173668" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 14:40:00" "2013-08-12
> 14:50:00" ""
> "173838" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 14:50:00" "2013-08-12
> 15:00:00" ""
> "174008" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.005389 Hrs" "14" "0.00538861099630594" "" "" "" ""
> "1" "" "" "" "2013-08-12 15:00:00" "2013-08-12
> 15:00:19" ""
> "174178" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.161278 Hrs" "14" "0.161278054118156" "" "" "" ""
> "1" "" "" "" "2013-08-12 15:00:19" "2013-08-12
> 15:10:00" ""
> "174348" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 15:10:00" "2013-08-12
> 15:20:00" ""
> "174518" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 15:20:00" "2013-08-12
> 15:30:00" ""
> "174689" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 15:30:00" "2013-08-12
> 15:40:00" ""
> "174859" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 15:40:00" "2013-08-12
> 15:50:00" ""
> "175029" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.002548 Hrs" "14" "0.00254777772352099" "" "" "" ""
> "1" "" "" "" "2013-08-12 15:50:00" "2013-08-12
> 15:50:09" ""
> "175199" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.164119 Hrs" "14" "0.164118900895119" "" "" "" ""
> "1" "" "" "" "2013-08-12 15:50:09" "2013-08-12
> 16:00:00" ""
> "175369" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166673 Hrs" "14" "0.166673332452774" "" "" "" ""
> "1" "" "" "" "2013-08-12 16:00:00" "2013-08-12
> 16:10:00" ""
> "175539" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.004687 Hrs" "14" "0.00468722218647599" "" "" "" ""
> "1" "" "" "" "2013-08-12 16:10:00" "2013-08-12
> 16:10:16" ""
> "175709" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.161974 Hrs" "14" "0.161974430084229" "" "" "" ""
> "1" "" "" "" "2013-08-12 16:10:16" "2013-08-12
> 16:20:00" ""
> "175879" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166701 Hrs" "14" "0.166700825095177" "" "" "" ""
> "1" "" "" "" "2013-08-12 16:20:00" "2013-08-12
> 16:30:00" ""
> "176050" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166631 Hrs" "14" "0.166630819439888" "" "" "" ""
> "1" "" "" "" "2013-08-12 16:30:00" "2013-08-12
> 16:40:00" ""
> "176220" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166674 Hrs" "14" "0.166673615574837" "" "" "" ""
> "1" "" "" "" "2013-08-12 16:40:00" "2013-08-12
> 16:50:00" ""
> "176390" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.16666 Hrs" "14" "0.166659727692604" "" "" "" ""
> "1" "" "" "" "2013-08-12 16:50:00" "2013-08-12
> 17:00:00" ""
> "176560" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166682 Hrs" "14" "0.166681677103043" "" "" "" ""
> "1" "" "" "" "2013-08-12 17:00:00" "2013-08-12
> 17:10:00" ""
> "176730" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.018932 Hrs" "14" "0.0189319439232349" "" "" "" ""
> "1" "" "" "" "2013-08-12 17:10:00" "2013-08-12
> 17:11:08" ""
> "176900" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.147744 Hrs" "14" "0.147744178771973" "" "" "" ""
> "1" "" "" "" "2013-08-12 17:11:08" "2013-08-12
> 17:20:00" ""
> "177070" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.019095 Hrs" "14" "0.0190947223454714" "" "" "" ""
> "1" "" "" "" "2013-08-12 17:20:00" "2013-08-12
> 17:21:08" ""
> "177240" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.147547 Hrs" "14" "0.147547498345375" "" "" "" ""
> "1" "" "" "" "2013-08-12 17:21:08" "2013-08-12
> 17:30:00" ""
> "177411" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 17:30:00" "2013-08-12
> 17:40:00" ""
> "177581" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.006486 Hrs" "14" "0.00648583378642797" "" "" "" ""
> "1" "" "" "" "2013-08-12 17:40:00" "2013-08-12
> 17:40:23" ""
> "177751" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.160181 Hrs" "14" "0.16018083691597" "" "" "" ""
> "1" "" "" "" "2013-08-12 17:40:23" "2013-08-12
> 17:50:00" ""
> "177921" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 17:50:00" "2013-08-12
> 18:00:00" ""
> "178091" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 18:00:00" "2013-08-12
> 18:10:00" ""
> "178261" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 18:10:00" "2013-08-12
> 18:20:00" ""
> "178431" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.002614 Hrs" "14" "0.00261388882063329" "" "" "" ""
> "1" "" "" "" "2013-08-12 18:20:00" "2013-08-12
> 18:20:09" ""
> "178601" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.164053 Hrs" "14" "0.164052784442902" "" "" "" ""
> "1" "" "" "" "2013-08-12 18:20:09" "2013-08-12
> 18:30:00" ""
> "178772" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 18:30:00" "2013-08-12
> 18:40:00" ""
> "178942" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 18:40:00" "2013-08-12
> 18:50:00" ""
> "179112" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166677 Hrs" "14" "0.166677236557007" "" "" "" ""
> "1" "" "" "" "2013-08-12 18:50:00" "2013-08-12
> 19:00:00" ""
> "179282" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166664 Hrs" "14" "0.166663616895676" "" "" "" ""
> "1" "" "" "" "2013-08-12 19:00:00" "2013-08-12
> 19:10:00" ""
> "179452" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166659 Hrs" "14" "0.16665917634964" "" "" "" ""
> "1" "" "" "" "2013-08-12 19:10:00" "2013-08-12
> 19:20:00" ""
> "179622" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.003256 Hrs" "14" "0.00325638870708644" "" "" "" ""
> "1" "" "" "" "2013-08-12 19:20:00" "2013-08-12
> 19:20:11" ""
> "179792" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.16341 Hrs" "14" "0.163410261273384" "" "" "" ""
> "1" "" "" "" "2013-08-12 19:20:11" "2013-08-12
> 19:30:00" ""
> "179963" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 19:30:00" "2013-08-12
> 19:40:00" ""
> "180133" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166713 Hrs" "14" "0.166713044047356" "" "" "" ""
> "1" "" "" "" "2013-08-12 19:40:00" "2013-08-12
> 19:50:00" ""
> "180303" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.16662 Hrs" "14" "0.166620284318924" "" "" "" ""
> "1" "" "" "" "2013-08-12 19:50:00" "2013-08-12
> 20:00:00" ""
> "180473" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 20:00:00" "2013-08-12
> 20:10:00" ""
> "180643" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 20:10:00" "2013-08-12
> 20:20:00" ""
> "180813" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 20:20:00" "2013-08-12
> 20:30:00" ""
> "180984" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.166666939854622" "" "" "" ""
> "1" "" "" "" "2013-08-12 20:30:00" "2013-08-12
> 20:40:00" ""
> "181154" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 20:40:00" "2013-08-12
> 20:50:00" ""
> "181324" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166666 Hrs" "14" "0.166666403412819" "" "" "" ""
> "1" "" "" "" "2013-08-12 20:50:00" "2013-08-12
> 21:00:00" ""
> "181494" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 21:00:00" "2013-08-12
> 21:10:00" ""
> "181664" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 21:10:00" "2013-08-12
> 21:20:00" ""
> "181834" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166677 Hrs" "14" "0.166676670312881" "" "" "" ""
> "1" "" "" "" "2013-08-12 21:20:00" "2013-08-12
> 21:30:00" ""
> "182005" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166662 Hrs" "14" "0.166661664843559" "" "" "" ""
> "1" "" "" "" "2013-08-12 21:30:00" "2013-08-12
> 21:40:00" ""
> "182175" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166662 Hrs" "14" "0.166661664843559" "" "" "" ""
> "1" "" "" "" "2013-08-12 21:40:00" "2013-08-12
> 21:50:00" ""
> "182345" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 21:50:00" "2013-08-12
> 22:00:00" ""
> "182515" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 22:00:00" "2013-08-12
> 22:10:00" ""
> "182685" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 22:10:00" "2013-08-12
> 22:20:00" ""
> "182855" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 22:20:00" "2013-08-12
> 22:30:00" ""
> "183025" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.002667 Hrs" "14" "0.00266666687093675" "" "" "" ""
> "1" "" "" "" "2013-08-12 22:30:00" "2013-08-12
> 22:30:09" ""
> "183196" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.164 Hrs" "14" "0.164000004529953" "" "" "" ""
> "1" "" "" "" "2013-08-12 22:30:09" "2013-08-12
> 22:40:00" ""
> "183366" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 22:40:00" "2013-08-12
> 22:50:00" ""
> "183536" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 22:50:00" "2013-08-12
> 23:00:00" ""
> "183706" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 23:00:00" "2013-08-12
> 23:10:00" ""
> "183876" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 23:10:00" "2013-08-12
> 23:20:00" ""
> "184046" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 23:20:00" "2013-08-12
> 23:30:00" ""
> "184217" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 23:30:00" "2013-08-12
> 23:40:00" ""
> "184387" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-12 23:40:00" "2013-08-12
> 23:50:00" ""
> "184557" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166699 Hrs" "14" "0.166699171066284" "" "" "" ""
> "1" "" "" "" "2013-08-12 23:50:00" "2013-08-13
> 00:00:00" ""
> "184727" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166634 Hrs" "14" "0.166634157299995" "" "" "" ""
> "1" "" "" "" "2013-08-13 00:00:00" "2013-08-13
> 00:10:00" ""
> "184897" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 00:10:00" "2013-08-13
> 00:20:00" ""
> "185067" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 00:20:00" "2013-08-13
> 00:30:00" ""
> "185238" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 00:30:00" "2013-08-13
> 00:40:00" ""
> "185408" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166694 Hrs" "14" "0.166694432497025" "" "" "" ""
> "1" "" "" "" "2013-08-13 00:40:00" "2013-08-13
> 00:50:00" ""
> "185578" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166645 Hrs" "14" "0.166645005345345" "" "" "" ""
> "1" "" "" "" "2013-08-13 00:50:00" "2013-08-13
> 01:00:00" ""
> "185748" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166661 Hrs" "14" "0.166660562157631" "" "" "" ""
> "1" "" "" "" "2013-08-13 01:00:00" "2013-08-13
> 01:10:00" ""
> "185918" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 01:10:00" "2013-08-13
> 01:20:00" ""
> "186088" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 01:20:00" "2013-08-13
> 01:30:00" ""
> "186259" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 01:30:00" "2013-08-13
> 01:40:00" ""
> "186429" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 01:40:00" "2013-08-13
> 01:50:00" ""
> "186599" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 01:50:00" "2013-08-13
> 02:00:00" ""
> "186769" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 02:00:00" "2013-08-13
> 02:10:00" ""
> "186939" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166693 Hrs" "14" "0.166692510247231" "" "" "" ""
> "1" "" "" "" "2013-08-13 02:10:00" "2013-08-13
> 02:20:00" ""
> "187109" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166641 Hrs" "14" "0.166640818119049" "" "" "" ""
> "1" "" "" "" "2013-08-13 02:20:00" "2013-08-13
> 02:30:00" ""
> "187280" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.16667 Hrs" "14" "0.166670009493828" "" "" "" ""
> "1" "" "" "" "2013-08-13 02:30:00" "2013-08-13
> 02:40:00" ""
> "187450" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166664 Hrs" "14" "0.166663616895676" "" "" "" ""
> "1" "" "" "" "2013-08-13 02:40:00" "2013-08-13
> 02:50:00" ""
> "187620" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166666 Hrs" "14" "0.166666403412819" "" "" "" ""
> "1" "" "" "" "2013-08-13 02:50:00" "2013-08-13
> 03:00:00" ""
> "187790" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 03:00:00" "2013-08-13
> 03:10:00" ""
> "187960" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166698 Hrs" "14" "0.166698351502419" "" "" "" ""
> "1" "" "" "" "2013-08-13 03:10:00" "2013-08-13
> 03:20:00" ""
> "188130" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.002696 Hrs" "14" "0.00269583333283663" "" "" "" ""
> "1" "" "" "" "2013-08-13 03:20:00" "2013-08-13
> 03:20:09" ""
> "188300" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.163939 Hrs" "14" "0.16393917798996" "" "" "" ""
> "1" "" "" "" "2013-08-13 03:20:09" "2013-08-13
> 03:30:00" ""
> "188471" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 03:30:00" "2013-08-13
> 03:40:00" ""
> "188641" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 03:40:00" "2013-08-13
> 03:50:00" ""
> "188811" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 03:50:00" "2013-08-13
> 04:00:00" ""
> "188981" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 04:00:00" "2013-08-13
> 04:10:00" ""
> "189151" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 04:10:00" "2013-08-13
> 04:20:00" ""
> "189321" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 04:20:00" "2013-08-13
> 04:30:00" ""
> "189492" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 04:30:00" "2013-08-13
> 04:40:00" ""
> "189662" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166672 Hrs" "14" "0.166671678423882" "" "" "" ""
> "1" "" "" "" "2013-08-13 04:40:00" "2013-08-13
> 04:50:00" ""
> "189832" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166662 Hrs" "14" "0.166661664843559" "" "" "" ""
> "1" "" "" "" "2013-08-13 04:50:00" "2013-08-13
> 05:00:00" ""
> "190002" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166687 Hrs" "14" "0.166686952114105" "" "" "" ""
> "1" "" "" "" "2013-08-13 05:00:00" "2013-08-13
> 05:10:00" ""
> "190172" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.002804 Hrs" "14" "0.00280444440431893" "" "" "" ""
> "1" "" "" "" "2013-08-13 05:10:00" "2013-08-13
> 05:10:10" ""
> "190342" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.163846 Hrs" "14" "0.163845553994179" "" "" "" ""
> "1" "" "" "" "2013-08-13 05:10:10" "2013-08-13
> 05:20:00" ""
> "190512" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166663 Hrs" "14" "0.166663065552711" "" "" "" ""
> "1" "" "" "" "2013-08-13 05:20:00" "2013-08-13
> 05:30:00" ""
> "190683" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 05:30:00" "2013-08-13
> 05:40:00" ""
> "190853" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 05:40:00" "2013-08-13
> 05:50:00" ""
> "191023" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166672 Hrs" "14" "0.166672497987747" "" "" "" ""
> "1" "" "" "" "2013-08-13 05:50:00" "2013-08-13
> 06:00:00" ""
> "191193" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166682 Hrs" "14" "0.166682228446007" "" "" "" ""
> "1" "" "" "" "2013-08-13 06:00:00" "2013-08-13
> 06:10:00" ""
> "191363" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.003872 Hrs" "14" "0.0038719445001334" "" "" "" ""
> "1" "" "" "" "2013-08-13 06:10:00" "2013-08-13
> 06:10:14" ""
> "191533" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.162773 Hrs" "14" "0.162773340940475" "" "" "" ""
> "1" "" "" "" "2013-08-13 06:10:14" "2013-08-13
> 06:20:00" ""
> "191703" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166672 Hrs" "14" "0.166671946644783" "" "" "" ""
> "1" "" "" "" "2013-08-13 06:20:00" "2013-08-13
> 06:30:00" ""
> "191874" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166661 Hrs" "14" "0.166661396622658" "" "" "" ""
> "1" "" "" "" "2013-08-13 06:30:00" "2013-08-13
> 06:40:00" ""
> "192044" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166684 Hrs" "14" "0.166683614253998" "" "" "" ""
> "1" "" "" "" "2013-08-13 06:40:00" "2013-08-13
> 06:50:00" ""
> "192214" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.16665 Hrs" "14" "0.166649729013443" "" "" "" ""
> "1" "" "" "" "2013-08-13 06:50:00" "2013-08-13
> 07:00:00" ""
> "192384" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 07:00:00" "2013-08-13
> 07:10:00" ""
> "192554" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.007488 Hrs" "14" "0.00748805562034249" "" "" "" ""
> "1" "" "" "" "2013-08-13 07:10:00" "2013-08-13
> 07:10:26" ""
> "192724" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.159179 Hrs" "14" "0.159178629517555" "" "" "" ""
> "1" "" "" "" "2013-08-13 07:10:26" "2013-08-13
> 07:20:00" ""
> "192894" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.167058 Hrs" "14" "0.167058050632477" "" "" "" ""
> "1" "" "" "" "2013-08-13 07:20:00" "2013-08-13
> 07:30:01" ""
> "193064" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.028249 Hrs" "14" "0.0282494444400072" "" "" "" ""
> "1" "" "" "" "2013-08-13 07:30:01" "2013-08-13
> 07:31:43" ""
> "193234" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.001107 Hrs" "14" "0.00110722216777503" "" "" "" ""
> "1" "" "" "" "2013-08-13 07:31:43" "2013-08-13
> 07:31:47" ""
> "193405" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.136919 Hrs" "14" "0.136918604373932" "" "" "" ""
> "1" "" "" "" "2013-08-13 07:31:47" "2013-08-13
> 07:40:00" ""
> "193575" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 07:40:00" "2013-08-13
> 07:50:00" ""
> "193745" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.003824 Hrs" "14" "0.00382388872094452" "" "" "" ""
> "1" "" "" "" "2013-08-13 07:50:00" "2013-08-13
> 07:50:13" ""
> "193915" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.162844 Hrs" "14" "0.162843614816666" "" "" "" ""
> "1" "" "" "" "2013-08-13 07:50:13" "2013-08-13
> 08:00:00" ""
> "194085" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166666 Hrs" "14" "0.166666105389595" "" "" "" ""
> "1" "" "" "" "2013-08-13 08:00:00" "2013-08-13
> 08:10:00" ""
> "194255" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166672 Hrs" "14" "0.166671946644783" "" "" "" ""
> "1" "" "" "" "2013-08-13 08:10:00" "2013-08-13
> 08:20:00" ""
> "194425" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166661 Hrs" "14" "0.166661098599434" "" "" "" ""
> "1" "" "" "" "2013-08-13 08:20:00" "2013-08-13
> 08:30:00" ""
> "194596" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 08:30:00" "2013-08-13
> 08:40:00" ""
> "194766" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 08:40:00" "2013-08-13
> 08:50:00" ""
> "194936" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 08:50:00" "2013-08-13
> 09:00:00" ""
> "195106" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.002589 Hrs" "14" "0.00258944439701736" "" "" "" ""
> "1" "" "" "" "2013-08-13 09:00:00" "2013-08-13
> 09:00:09" ""
> "195276" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.164077 Hrs" "14" "0.16407722234726" "" "" "" ""
> "1" "" "" "" "2013-08-13 09:00:09" "2013-08-13
> 09:10:00" ""
> "195446" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 09:10:00" "2013-08-13
> 09:20:00" ""
> "195616" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 09:20:00" "2013-08-13
> 09:30:00" ""
> "195787" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 09:30:00" "2013-08-13
> 09:40:00" ""
> "195957" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166673 Hrs" "14" "0.166673049330711" "" "" "" ""
> "1" "" "" "" "2013-08-13 09:40:00" "2013-08-13
> 09:50:00" ""
> "196127" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.16666 Hrs" "14" "0.166660279035568" "" "" "" ""
> "1" "" "" "" "2013-08-13 09:50:00" "2013-08-13
> 10:00:00" ""
> "196297" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 10:00:00" "2013-08-13
> 10:10:00" ""
> "196467" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.002932 Hrs" "14" "0.00293222209438682" "" "" "" ""
> "1" "" "" "" "2013-08-13 10:10:00" "2013-08-13
> 10:10:10" ""
> "196637" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.163734 Hrs" "14" "0.163734436035156" "" "" "" ""
> "1" "" "" "" "2013-08-13 10:10:10" "2013-08-13
> 10:20:00" ""
> "196807" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 10:20:00" "2013-08-13
> 10:30:00" ""
> "196978" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166674 Hrs" "14" "0.166673615574837" "" "" "" ""
> "1" "" "" "" "2013-08-13 10:30:00" "2013-08-13
> 10:40:00" ""
> "197148" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.16666 Hrs" "14" "0.166660010814667" "" "" "" ""
> "1" "" "" "" "2013-08-13 10:40:00" "2013-08-13
> 10:50:00" ""
> "197318" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166666 Hrs" "14" "0.166666403412819" "" "" "" ""
> "1" "" "" "" "2013-08-13 10:50:00" "2013-08-13
> 11:00:00" ""
> "197492" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166667 Hrs" "14" "0.16666667163372" "" "" "" ""
> "1" "" "" "" "2013-08-13 11:00:00" "2013-08-13
> 11:10:00" ""
> "197666" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.006904 Hrs" "14" "0.00690416665747762" "" "" "" ""
> "1" "" "" "" "2013-08-13 11:10:00" "2013-08-13
> 11:10:24" ""
> "197840" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.159763 Hrs" "14" "0.159762516617775" "" "" "" ""
> "1" "" "" "" "2013-08-13 11:10:24" "2013-08-13
> 11:20:00" ""
> "198014" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166681 Hrs" "14" "0.166681379079819" "" "" "" ""
> "1" "" "" "" "2013-08-13 11:20:00" "2013-08-13
> 11:30:00" ""
> "198188" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.008596 Hrs" "14" "0.00859611108899117" "" "" "" ""
> "1" "" "" "" "2013-08-13 11:30:00" "2013-08-13
> 11:30:31" ""
> "198363" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.15806 Hrs" "14" "0.158060282468796" "" "" "" ""
> "1" "" "" "" "2013-08-13 11:30:31" "2013-08-13
> 11:40:00" ""
> "198537" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.166662 Hrs" "14" "0.166662231087685" "" "" "" ""
> "1" "" "" "" "2013-08-13 11:40:00" "2013-08-13
> 11:50:00" ""
> "198711" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.002421 Hrs" "14" "0.00242111110128462" "" "" "" ""
> "1" "" "" "" "2013-08-13 11:50:00" "2013-08-13
> 11:50:08" ""
> "198885" "0" "5" "1" "VPN User: bcd, Id: 1 usage time"
> "0.164246 Hrs" "14" "0.164245560765266" "" "" "" ""
> "1" "" "" "" "2013-08-13 11:50:08" "2013-08-13
> 12:00:00" ""
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
