CesarCapillas

set autocommit=0;
begin;

-- get all active references to alf_prop_root
create temporary table temp1 (id bigint(20), index (id));
insert into temp1 select disabled_paths_id as id from alf_audit_app;
insert into temp1 select audit_values_id as id from alf_audit_entry;
insert into temp1 select prop1_id as id from alf_prop_unique_ctx;

-- determine the obsolete entries from alf_prop_root

CesarCapillas

# Alfresco users
curl -s -u user:pass http://localhost:8080/alfresco/service/api/people | jq '.people[] .userName'

curl -s -u user:pass http://localhost:8080/alfresco/service/api/people | jq '.people[] | "\(.userName),\(.firstName),\(.lastName),\(.email)"'

# Alfresco groups
curl -s -u user:pass http://localhost:8080/alfresco/service/api/groups | jq '.data[] .shortName'

curl -s -u user:pass http://localhost:8080/alfresco/service/api/groups | jq '.data[] | "\(.shortName),\(.fullName),\(.displayName)"'

CesarCapillas

# /bin/bash
set -e
export http_proxy=

ALF_HOST="http://localhost:8080/"
ALF_USER="admin"
ALF_PASS="secret"

if [ -z "$1" ]; then
  echo "Usage: alf-rest-search.sh <TYPE|SITE|ASPECT|property|TEXT|ISNULL|ISNOTNULL> <object>"

CesarCapillas

#!/bin/bash

export http_proxy=

MYHOST=https://alfrescohost
MYSECR="admin:secret"

if [[ $1 == "-h" ]]; then
  echo "Usage: cmis-browser.sh [PATH=] [ACTION=properties|parents|aspects" 
  echo "       cmis-browser.sh"