Galaxy Server SQL Tips

Galaxy Information

Get total number of active users on a repository

SELECT * FROM SKVirtualActor WHERE IsActiveUser = 1;

Template protection

Find template gobject ID

SELECT gobject_ID FROM GalaxyName.gobject WHERE tag_name LIKE 'TemplateName';

Unprotect template

DELETE FROM GalaxyName.gobject_protected WHERE gobject_id = #

Protect template

INSERT INTO GalaxyName.gobject_protected (gobject_id) VALUES (#);