Category: 6. Reports

Database structure

In order to be able to put queries to a database, one must know the structures, object and field names of the database. Here, the structure of the database is to be outlined, as well as the names of the nodes and edges.

Continue reading

Permanent link to this post: https://help.migraven.com/datenbankaufbau/

Key values ​​for permissions and propagation

Some field contents are numeric. Behind it are key values ​​for permissions and the distribution of permissions. Here the decryption.

Continue reading

Permanent link to this post: https://help.migraven.com/schluesselwerte-fuer-berechtigungen-und-propagation/

Show directories and permissions of a group

Project-related query
Just like a user's permissions, we can also view the permissions of a group on already scanned directories. It should be noted that a group may be entitled to a directory directly or it may be granted rights as a member of an authorized group.

Continue reading

Permanent link to this post: https://help.migraven.com/verzeichnisse-und-berechtigungen-einer-gruppe-anzeigen/

View directories and permissions of a user

Project-related query

It displays the direct and indirect explicit rights of a selected user across all projects and paths. Issued are Path, ACE and Propagation (Dissemination).

Continue reading

Permanent link to this post: https://help.migraven.com/verzeichnisse-und-berechtigungen-eines-benutzers-anzeigen/

migRaven Report API with Query Language CYPHER

migRaven uses a database that works on the basis of graph theory. It comes the graph database neo4j by Neotechnology. This database belongs to the category of noSQL databases.

On the migRavenDatabase can be accessed through a web browser. Access is via port 7474: http: // localhost: 7474 / browser /.

Queries can be made with the query language CYPHER. Before we take a look at some example commands, some preliminary remarks on how to use the web interface.

Continue reading

Permanent link to this post: https://help.migraven.com/migraven_report_api/

Requirements

1. migRaven-Database

Prerequisite for evaluations with the migRaven API is the use of migRaven for reading in existing domains and scanning shares.

The addressed is the migRavenDatabase through a web browser, as in the "migRaven Report API"Described. For the evaluations of migRaven API is the program migRaven not mandatory.

Continue reading

Permanent link to this post: https://help.migraven.com/voraussetzungen/

Last login of users and expiration date of user accounts

AD query
From the with migRaven scanned AD data, it is possible to determine the last filing date and expiration date of all user accounts.

It makes sense to create this list occasionally (after the current AD scan) and look for two aspects:

  • Are the users who have not registered for over three months still employees of the company?
  • Are there any users who are currently enrolling, even though they have not been employees of the company for a long time?

Continue reading

Permanent link to this post: https://help.migraven.com/letztes-anmelde-und-ablaufdatum/

View orphaned SIDs and remove them with the ACL Cleaner

Project-related query

From the migRavenDatabase, it is possible to output a list of orphaned SIDs. This list can also be used to automatically remove these orphan SIDs from your system using the ACL Cleaner.

Continue reading

Permanent link to this post: https://help.migraven.com/verwaiste-sids-anzeigen-und-entfernen/

Find a string in object names and OUs

AD query

Find a string in the object name of a specific OU

We have three query commands available in Cypher:

CONTAINS "..." - contains
STARTS WITH "..." - begins with
ENDS WITH "..." - ends with

Continue reading

Permanent link to this post: https://help.migraven.com/zeichenkette-suchen/

Determine effective permissions on directories

Project-related query

The following Cypher command lets you see who has permissions to your directories.

1. requirement

The evaluation is based on the migRaven-Database. You can only see the permissions of directories that you use migRaven have scanned.

In a web browser you can use "localhost: 7474" the migRavenCall database. Copy the query command into the upper middle field. The command is executed by clicking on the arrow on the far right.

Continue reading

Permanent link to this post: https://help.migraven.com/effektive-berechtigungen-auf-verzeichnisse-ermitteln/

Load more