Sorting Helm 3.x Database

andy18    Helm    

If you need to sort out the username, domain name and the package type hosted under a reseller, the following SQL query may help:

use HelmDBName
select PackageType.ResellerAccountNumber, Package.AccountNumber, HostDomain.DomainName,PackageType.PackageTypeName
from PackageType, HostDomain,Package
where PackageType.PackageTypeId = Package.PackageTypeId AND
Package.PackageId = HostDomain.PackageId AND
ResellerAccountNumber = ‘Reseller_Username‘ AND
HostDomain.SubDomainId = 0 AND
HostDomain.DomainAliasId = 0

If you enjoyed this article please consider sharing it!