p360-sql
Installation
$ npm install
Usage - duplicate contacts
$ ./cli.js duplicateContacts
Result
[
{"id":"0000000000"},
{"id":"0000000001"}
]
Usage - duplicate student folders
$ ./cli.js duplicateStudentFolders
Result
[
{"tittel":"Elevmappe - Harald Havre","antall":3},
{"tittel":"Elevmappe - Håvard Hode ","antall":2}
]
Usage - users by access group
$ ./cli.js usersByAccessGroup
Result
[
{"accessGroup":"Elev-Skien","name":"Testine Testen","userId":"01016101"},
{"accessGroup":"Elev-Skien","name":"Hans Håve","userId":"1104hava"}
]
Usage - users by role
$ ./cli.js usersByRole
Result
[
{"role":"Lærer","name":"Guest User","userId":"GuestUser","enterpriseNumber1":"974568039","enterpriseNumber2":null},
{"role":"Lærer","name":"Testine Testen","userId":"01016101","enterpriseNumber1":"974568039","enterpriseNumber2":null}
]
Usage - access groups on case documents
$ ./cli.js accessGroupsOnCase
Result
[
{"caseNumber":"14/02442","caseTitle":"elevmappe ","documentNumber":"14/02442-1","officialTitle":"Søknad om fritak fra vurdering i fag ","accessGroup":"Elev-Porsgrunn","personalIdNumber":"01010101010"},
{"caseNumber":"14/02442","caseTitle":"elevmappe ","documentNumber":"14/02442-2","officialTitle":"Elevsamtale ","accessGroup":"Elev-Porsgrunn","personalIdNumber":"01010101012"}
]