I am in the throes of building a database and report that tracks number of streams per a particular subnet- I can see that we can get this detail from the 'voice streams by address' dashboard.
In terms of the where clause, what syntax do I use to track streams across a specific IP range(for example assume one of the subnets was 10.10.10.x) how would this be written into the wherclause to only show me a count of streams originating from a particular static address range?
CLEGSTAT = "Ac" AND
ROWCOUNT > 0 AND REMIP <> EMPTY
I might not have fully understand the question, so my appologies. But if you want to filter data based on IP range(s), I'd suggest using a regex match.
e.g SUBNET MATCHES REGEX "^10.10.10" to match 10.10.10.anything.
I have managed to get some data and i have worked out to filter out all the unwanted fields to just show REM IPA, REM IPB, REMIPC and row count.
One thing I have noticed is that when I view the results o the client GUI, some fields are shoiwng in darker shade of grey-why is that? Does that mean there is some additional filtering against these fields?