New Member
September 16, 2016
Question
Custom Report Services per policy
- September 16, 2016
- 1 reply
- 8802 views
Hi,
I have been asked to list the services used per policy on our equipment.. I managed to create the following dataset.
select policyid, service, sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0)) as bandwidth from $log group by policyid, service having sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0))>0 order by bandwidth desc
However, for some reason, on the report i find policyids that do not exist on this specific equipment (I have more than one in my FAZ).
Please, any help would be much appreciated.
