![]() ![]() MARC :: Record -> new_from_usmarc ( CGI -> new -> param ( 'marc' ) ) -> as_xml_record _END_ #!/usr/bin/perl use CGI use MARC :: Record use MARC :: File :: XML print "Content-type: application/marc xml \n \n". Using Bucardo's check_postgres script with Nagios/Icincga? Add checks for these:Ĭheck_postgres -query="SELECT COUNT(rpt.id) AS result, COALESCE(STRING_AGG(rpt.id::TEXT, ','), 'none') AS ids FROM reporter.template_folder AS rpt JOIN reporter.template_folder AS prpt ON (rpt.parent = prpt.id) WHERE rpt.shared IS TRUE AND (prpt.share_with NOT IN (SELECT id FROM _unit_ancestors(rpt.share_with)) OR prpt.shared IS FALSE) " -c 1 -u evergreen -H localhost -action=custom_query -db evergreenĬheck_postgres -query="SELECT COUNT(rpt.id) AS result, COALESCE(STRING_AGG(rpt.id::TEXT, ','), 'none') AS ids FROM reporter.report_folder AS rpt JOIN reporter.report_folder AS prpt ON (rpt.parent = prpt.id) WHERE rpt.shared IS TRUE AND (prpt.share_with NOT IN (SELECT id FROM _unit_ancestors(rpt.share_with)) OR prpt.shared IS FALSE) " -c 1 -u evergreen -H localhost -action=custom_query -db evergreenĬheck_postgres -query="SELECT COUNT(rpt.id) AS result, COALESCE(STRING_AGG(rpt.id::TEXT, ','), 'none') AS ids FROM reporter.output_folder AS rpt JOIN reporter.output_folder AS prpt ON (rpt.parent = prpt.id) WHERE rpt.shared IS TRUE AND (prpt.share_with NOT IN (SELECT id FROM _unit_ancestors(rpt.share_with)) OR prpt.shared IS FALSE) " -c 1 -u evergreen -H localhost -action=custom_query -db evergreen Listing users with permissions by work_ou share_with NOT IN ( SELECT id FROM actor. share_with AS "Parent Shared With" FROM reporter. This SQL will list the folders that are shared more widely than their parents: To fix this, the "top-level" folder has to be shared the most widely with the subfolders either at the same or a more restrictive level. Given a simple org tree of A->B->C, if a user at C shares a report folder with all of C and then shares a subfolder with A or B, the display of shared folders for all users at A or B will be broken (the location of the breakage depends on the sort order of the username). copy_circ_lib = 101 - OPTIONAL: set one or more org unit id numbers here GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13 ORDER BY copy_circ_lib, pgt. circ_limit_set_circ_mod_map lscm ON lscm. circ_mod ), ', ' ) AS "Limited Circ Mods" FROM config. items_out AS "Max Items Out" ,Īrray_to_string (array_agg (lscm. ![]() idĪnother approach, showing more columns and their human readable values, change the WHERE clause to get different ones or comment out WHERE clause to see all rules. ![]() Substitute a.org_unit=1 with the id of your library from the _unit table. ![]() A quick way to view the circulation policies, in PostgreSQL, with the names instead of id values, similar to the Staff Client Circulation Policy Editor. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |