Re: [1'b68'1 astrad v8] clear stat of telephones with problems on all servers

[Task-By Emin Gabrielyan <emin.gabrielyan@switzernet.com>]

Assume that we have the following location history table which is growing as a result of triggers of location table:
 Start
 Stop
 Domain
 Account
 IP
 Port
 Count

Assume we have a period from A to B.

For each account
  Count records
    Where
      Start < B and Stop > A (meaning any intersection)
  If count = 1
    Then the account does not loose its port
    Else the telephone looses the connection

A php script or an excel file must display hour by hour the percentage of accounts loosing their port.

Emin Gabrielyan

Le Jun 14, 2011 à 1:05, Emin Gabrielyan <emin.gabrielyan@switzernet.com> a écrit :

> Need a clear quantity of telephones with lost ports on all servers. Write a script that can compute it automatically.
> 
> Envoyé de mon iPad