daniloalsilva

# default ids
$sensuId = (Get-Process sensu-client).id
$rubyId = (gwmi win32_process | ? {$_.ParentProcessId -eq $sensuId}).ProcessId

# define execution in minutes
$initialTime = Get-Date
$execTime = $initialTime + [timespan]"0:05:00"

# create an empty hashtable
$procCount = @{}

daniloalsilva

<#
.Synopsis

   Plesk Licensing script

.DESCRIPTION
   
   Plesk Licensing script
   This script intend to create a new license key in Plesk via API and 
   retrieve the XML content of created key in a plesk node.

daniloalsilva

-- Select all service plans with Presence Builder enable:
select t.name, td.element, td.value
from templates t, TmplData td
where td.tmpl_id = t.id
and td.element = 'max_site_builder'
and td.value <> 0;

-- Select all domains with Presence Builder enable:
select c.login, d.name as domain, t.name as subscription, l.value as limit_value
from subscriptions su, subscriptionproperties sp, domains d, planssubscriptions p, templates t, clients c, limits l