X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-xml%2Fevergreen_staged_report.xml;h=3cc0c12110a9e9b1d724c34a11a80c5296cef86c;hp=31fca03796f1ed30a3db9e5bd77e19d8ba2b2003;hb=404fba950704f6ed408e0018435d9036c2b8cf80;hpb=709fe65478a6acded9bab3f66fa1283ab619d62b

diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml
index 31fca03..3cc0c12 100644
--- a/mig-xml/evergreen_staged_report.xml
+++ b/mig-xml/evergreen_staged_report.xml
@@ -968,6 +968,18 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3</query>
         <query>SELECT COUNT(map.id), aou.name, au_sc.name FROM actor_stat_cat_entry_usr_map map JOIN actor_stat_cat au_sc ON au_sc.id = map.stat_cat JOIN actor.org_unit aou ON aou.id = au_sc.owner GROUP BY 2, 3 ORDER BY 2,3</query>
     </report>
 
+    <report>
+        <name>usr_thresholds</name>
+        <report_title>Patron Thresholds</report_title>
+        <tag>actors</tag>
+        <iteration>0</iteration>
+        <heading>Pateron Group.Org Unit.Penalty.Threshold</heading>
+        <query>SELECT pgt.name, aou.shortname, sp.name, p.threshold FROM permission_grp_penalty_threshold p 
+                JOIN actor.org_unit aou ON aou.id = p.org_unit JOIN permission.grp_tree pgt ON pgt.id = p.grp JOIN config.standing_penalty sp ON sp.id = p.penalty
+                ORDER BY 2, 1, 3</query>
+    </report>
+
+
     <!-- ACQUISITIONS REPORTS -->
     <report>
         <name>fund_count</name>