Input list of "Subscriptions" where there is no Scheduled Backup

[rossgile]

Hi,

It would be great to get a list of subscriptions that has no Scheduled Backup.

Thanks,

Ross

 

[Bitpalast]

This is a bit tricky, because when a user has never before scheduled a backup, Plesk does not have a backup dataset, while when he has scheduled a backup, but then turned it "inactive" by unchecking the "active" checkbox, Plesk has a dataset with a flag.

To see all subscriptions (subscription user name and main domain name of subscription) where either a user has never before scheduled a backup or he did schedule a backup before but the backup is set to "inactive", please run this query from "plesk db" database interface:

select a.login AS login, c.name AS domainname
FROM sys_users AS a
INNER JOIN hosting AS b ON b.sys_user_id = a.id
INNER JOIN domains AS c ON c.id = b.dom_id
INNER JOIN Subscriptions AS d ON d.object_id = c.id
LEFT JOIN BackupsScheduled as e ON e.obj_id = c.id
WHERE ((e.id IS NULL) OR (e.active LIKE 'true')) AND (c.webspace_id LIKE '0')

You can also run this in a single line from the Linux console:

#plesk db "select a.login AS login, c.name AS domainname FROM sys_users AS a INNER JOIN hosting AS b ON b.sys_user_id = a.id INNER JOIN domains AS c ON c.id = b.dom_id INNER JOIN Subscriptions AS d ON d.object_id = c.id LEFT JOIN BackupsScheduled as e ON e.obj_id = c.id WHERE ((e.id IS NULL) OR (e.active LIKE 'true')) AND (c.webspace_id LIKE '0')"

 

[Jan Bludau]

is really nice working.

thx

why not showing up in the Scheduled Backup??