Difference between revisions of "Policy"
Jump to navigation
Jump to search
old>Admin |
old>Admin |
||
| Line 7: | Line 7: | ||
tslive.systempolicy.DisplayName | tslive.systempolicy.DisplayName | ||
FROM tslive.systempolicy | FROM tslive.systempolicy | ||
JOIN tsbase.systempolicymeta ON tsbase.systempolicymeta.PolicyName | JOIN tsbase.systempolicymeta ON tsbase.systempolicymeta.PolicyName = tslive.systempolicy.PolicyName | ||
JOIN tsbase.systempolicygroup ON tsbase.systempolicymeta.PolicyGroupID = tsbase.systempolicygroup.PolicyGroupID | JOIN tsbase.systempolicygroup ON tsbase.systempolicymeta.PolicyGroupID = tsbase.systempolicygroup.PolicyGroupID | ||
ORDER BY 1,3 | ORDER BY 1,3 | ||
Revision as of 14:50, 1 February 2013
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