Policy

Policies are between all solutions in each Tempus Serva installation

SELECT tsbase.systempolicygroup.PolicyGroup, tsbase.systempolicymeta.PolicyName, tslive.systempolicy.DisplayName FROM tslive.systempolicy JOIN tsbase.systempolicymeta ON tsbase.systempolicymeta.PolicyName = tslive.systempolicy.PolicyName JOIN tsbase.systempolicygroup ON tsbase.systempolicymeta.PolicyGroupID = tsbase.systempolicygroup.PolicyGroupID ORDER BY 1,3