command line

qSense qsense is an python library and command line tool for qliksense Some useful commands export_remove_old_apps Export (published or passing any other filter) applications to qvd files qsense export_delete_old_apps qliksense.redaelli.org ~/certificates/client.pem --target_path '/tmp' --modified_days=300 --last_reload_days=300 deallocate_analyzer_licenses_for_professionals Deallocate analyzer license fom users with a professional license qsense deallocate_analyzer_licenses_for_professionals qliksense.redaelli.org ~/certificates/client.pem --nodryrun delete_removed_exernally_users Delete users that were removed externally (from active directory?) qsense delete_removed_exernally_users qliksense.redaelli.org ~/certificates/client.pem GROUP --nodryrun

setup In these examples I use kerberos authentication but you could also use basic authentication with -D and -w options For semplicity I put common options into the environment and I have created an alias export LDAP_OPTS="-h myldap.group.example.com -LLL -Y GSSAPI -b dc=group,dc=example,dc=com -o ldif-wrap=no " alias adsearch="/usr/bin/ldapsearch ${LDAP_OPTS}" Extract locked users adsearch “(&(objectCategory=Person)(objectClass=User)(lockoutTime>=1))” dn Expired passwords date -d “1601/1/1+$(expr 132469210596077795 / 10000000 )Seconds” “(&(objectclass=user)(objectcategory=person)(!pwdlastset=0)(pwdlastset<={date})(!userAccountControl:1.2.840.113556.1.4.803:=65536))” Extracting the flat list of members of a group How to recursively retreiving teh list of members of a group...

I had a list of email addresses and my boss asked me to extract the login names (SamAccountname attribute in Active Directory). I quickly did it with: cat mails.txt | while read mail do echo /usr/bin/curl -s --proxy \"\" -u \"MYDOMAIN\\myuser:mypassword\" \"ldap://ldapserver:3268/DC=group,DC=mycompany,DC=com?sAMAccountName?sub?(mail=${mail})\" done | bash | grep "sAMAccountName:" | cut -f2 -d":" | sed -e 's/^ /"/' -e 's/$/",/'