$query="SELECT inet_ntoa(IP) as IP,
                VirtualMachine.Name,
                Status.Value,
                VirtualMachine.Status,
                VirtualMachine.InitialPassword,
                VirtualMachine.Description,
                VirtualMachine.DisplayName as ServerName,
                VMI.OSName,
                HardwareProfile.CPUNumber,
                HardwareProfile.DiskSize,
                HardwareProfile.MemorySize,
                inet_ntoa(VMNetwork.PrivateIP) as PrivateIP,
                VMNetwork.MacAddress,
                Account.AccountName as CustomerId
                from PublicIPPool
                left join VirtualMachine on PublicIPPool.AssociatedVMId = VirtualMachine.Id
                left join Account on VirtualMachine.AccountId=Account.Id
                left join Status on VirtualMachine.Status=Status.Id
                left join VMI on VirtualMachine.VMIId=VMI.Id
                left join HardwareProfile on VirtualMachine.HardwareProfileId=HardwareProfile.Id
                left join VMNetwork on IP=VMNetwork.PublicIP
                where Used=1
                ";


$query="SELECT inet_ntoa(IP) as IP,
                VirtualMachine.Name,
                Status.Value,
                \"Flex\",
                VirtualMachine.Status,
                VirtualMachine.InitialPassword,
                VirtualMachine.Description,
                VirtualMachine.DisplayName as ServerName,
                VMI.OSName,
                HardwareProfile.CPUNumber,
                HardwareProfile.DiskSize,
                HardwareProfile.MemorySize,
                inet_ntoa(VMNetwork.PrivateIP) as PrivateIP,
                VMNetwork.MacAddress,
                Account.AccountName as CustomerId
                from FlexibleIPPool
                left join VirtualMachine on FlexibleIPPool.VirtualMachineId = VirtualMachine.Id
                left join Account on VirtualMachine.AccountId=Account.Id
                left join Status on VirtualMachine.Status=Status.Id
                left join VMI on VirtualMachine.VMIId=VMI.Id
                left join HardwareProfile on VirtualMachine.HardwareProfileId=HardwareProfile.Id
                left join VMNetwork on IP=VMNetwork.PublicIP
                where Used=1 and FlexibleIPPool.VirtualMachineId is not NULL
                ";