Difference between revisions of "Policy"
Jump to navigation
Jump to search
old>Admin |
old>Admin |
||
| Line 1: | Line 1: | ||
Policies are between all solutions in each Tempus Serva installation | Policies are between all solutions in each Tempus Serva installation | ||
<blockquote><p> | |||
SELECT | |||
tsbase.systempolicygroup.PolicyGroup, | |||
tsbase.systempolicymeta.PolicyName, | |||
tslive.systempolicy.DisplayName | |||
FROM tslive.systempolicy | |||
JOIN tsbase.systempolicymeta ON tsbase.systempolicymeta.PolicyName | |||
JOIN tsbase.systempolicygroup ON tsbase.systempolicymeta.PolicyGroupID = tsbase.systempolicygroup.PolicyGroupID | |||
ORDER BY 1,3 | |||
</p></blockquote> | |||
== Local system == | == Local system == | ||
Revision as of 13:49, 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 JOIN tsbase.systempolicygroup ON tsbase.systempolicymeta.PolicyGroupID = tsbase.systempolicygroup.PolicyGroupID ORDER BY 1,3