Skip to content

Instantly share code, notes, and snippets.

View mikehas's full-sized avatar

Michael Haskell (mikehas) mikehas

View GitHub Profile
@mikehas
mikehas / modules_by_course_detail_v1
Created July 30, 2012 01:12
Moodle Modules by Course Detail V1
select c.id as course_id,
c.visible as visible,
c.shortname as course_name,
fac.userid as instructor,
COALESCE(q.all_quizs,0) as all_quizs,
COALESCE(ass.all_assignments,0) as all_assignmenets,
COALESCE(wiki.all_wikis,0) as all_wikis,
COALESCE(r.all_resources,0) as all_resources,
COALESCE(u.all_urls,0) as all_urls,
COALESCE(pa.all_pages,0) as all_pages,
@mikehas
mikehas / count_instructors.sql
Created August 1, 2012 07:22
Counts the number of active instructors in moodle.
select count(distinct(ue.userid)) from mdl_user_enrolments ue
join mdl_enrol e on (ue.enrolid=e.id)
join mdl_course c on (c.id=e.courseid)
join (select * from mdl_context where contextlevel=50) ct on (ct.instanceid=c.id)
join (select * from mdl_role_assignments where component='enrol_engine') ra on (ra.contextid=ct.id and ue.userid=ra.userid)
join mdl_role r on (ra.roleid = r.id)
where c.idnumber like '%-<insert_quarter_suffix_here>'
and c.visible=1
and ue.status=0
and r.name = 'Instructor'
@mikehas
mikehas / count_students.sql
Created August 1, 2012 07:23
Counts the number of active students in moodle.
select count(distinct(ue.userid)) from mdl_user_enrolments ue
join mdl_enrol e on (ue.enrolid=e.id)
join mdl_course c on (c.id=e.courseid)
join (select * from mdl_context where contextlevel=50) ct on (ct.instanceid=c.id)
join (select * from mdl_role_assignments where component='enrol_engine') ra on (ra.contextid=ct.id and ue.userid=ra.userid)
join mdl_role r on (ra.roleid = r.id)
where c.idnumber like '%-<insert_quarter_suffix_here>'
and c.visible=1
and ue.status=0
and r.name = 'Student'
@mikehas
mikehas / count_courses.sql
Created August 1, 2012 07:24
Counts the number of active courses in moodle.
select count(*) from mdl_course
where idnumber like '%-<insert_quarter_suffix_here>'
and visible = 1

Transparent Git Encryption

This document has been modified from its [original format][m1], which was written by Ning Shang (geek@cerias.net). It has been updated and reformatted into a [Markdown][m2] document by [Woody Gilk][m3] and [republished][m4].

Description

When working with a remote git repository which is hosted on a third-party storage server, data confidentiality sometimes becomes

@mikehas
mikehas / README.md
Created May 6, 2014 18:45 — forked from rmoff/README.md
OBIEE 11.1.1.7.1 Load Test

Save the JMX file to your local machine and open it in JMeter. Tested with OBIEE 11.1.1.7.1. Other versions may require modifications to the Assertion tests.

NB you need to change instanceconfig.xml so that the Loading... text doesn't disrupt the test. See here for more details, and additional information on using JMeter with OBIEE.