LogoLogo
LogoLogo
  • Welcome
    • Navigation
  • RealmJoin Deployment
    • Onboarding
    • Required Permissions
    • Infrastructure Considerations
      • Multi User Devices
    • Migration to RealmJoin vNext
  • User, Group and Device Management
    • Overview
    • User Profile
    • Organization Details
    • User, Group and Device Lists
      • Advanced Search
      • User Details
      • Group Details
      • Device Details
    • User and Group Settings
      • Available RealmJoin Policies
  • App Management
    • Packages
      • Package Store
        • Application Store Details
      • Package Management
      • Package Details
      • Package Assignments
        • Package Migration
      • Package Settings
      • Packaging Requests
        • Organic Packages
    • AVD Templates
  • Automation
    • Connecting Azure Automation
      • Required Permissions
      • Runbook Parameters
    • Runbooks
      • Runbook Customization
      • Runbook Permissions
      • Naming Conventions
      • Runbook Scheduling
      • Runbook Logs
        • Runbook Job Details
      • Runbooks Changelog
    • Requirements
    • Remediation Scripts
  • RealmJoin Agent
    • Features
      • Local Admin Password Solution (LAPS)
        • KeyVault
        • Application Insights
      • Notifications
      • AnyDesk Integration
        • AnyDesk configuration
      • App Deployment using the Agent
        • RealmJoin ESP
    • Deploying the Agent
    • User Interface
  • Logs
    • Connecting Azure Log Analytics Workspace
    • Audit Log
  • RealmJoin Settings
    • Overview
    • General
    • Roles and Permissions
      • Pre-defined Roles
      • Custom Roles
        • Available Permissions
    • Group Namespaces
    • Workplace Cloud Storage
    • Self Service Forms
  • Developer Reference
    • RealmJoin API
      • Authentication
    • Interacting with Runbooks
    • Simulating a Runbook Environment
    • Local Admin Password Management
  • Other
    • FAQ
      • Security
    • Troubleshooting
      • Package Installation Issues
        • Collecting Logfiles
        • Logfiles Structure
        • Analysing chocolatey.log
        • Troubleshooting failed chocolatey packages
        • Troubleshooting failed craft packages
        • Fixes for common issues
        • Intunewin Debugging
      • LAPS Issues
        • LAPS account passwords cannot be retrieved
        • Requested LAPS Accounts are not being created
    • Changelog
  • Legal
    • Licensing
    • Support
  • RealmJoin Website
Powered by GitBook
On this page
  • Basic Search
  • Advanced Search
  • Advanced Search Syntax Overview
  • Examples
  • FAQ

Was this helpful?

Edit on GitHub
  1. User, Group and Device Management
  2. User, Group and Device Lists

Advanced Search

Experience nearly load-free access to your data

Last updated 2 hours ago

Was this helpful?

From May 9th, RealmJoin introduces a revamped search mechanism that enables real-time access to tenant data. This enhancement ensures efficient performance even for tenants with a large volume of user, device, and group objects.

Tables can be searched using the basic or the advanced search feature.

All searches have to be confirmed by either using the enter key or the symbol.

Basic Search

Basic Search uses the Graph API to directly query tenant data, providing real-time results.

Basic Search is always available as a fallback when Advanced Search is not. It also appears during the initial loading of the cached table, allowing users to search immediately—even before the cache is fully built.

Advanced Search

RealmJoin's advanced search feature uses caching and tokenization, making searches fast and reliable, and supports Unicode characters like Ø. This tokenization enables partial name searches, so a query like "Ma Mu" can locate a user named "Maren Müller".

Additionally, information not displayed in the table is also searchable, like post-codes or UPN.

Advanced Search Syntax Overview

Advanced Search allows querying across available table values using a flexible and powerful syntax. Below are the key features and rules:

  • Tokenized Search: Search terms are automatically tokenized to improve matching accuracy. For example, typing lu sk will match names like Luke Skywalker. The search always uses a starts-with approach rather than a full-text or "contains" search. This means a search for walk would not return Skywalker.

  • Logical AND: All filters are combined using logical AND. Every condition must be met. Example: Luke Skywalker country:france searches for Luke Skywalker where the country starts with "france".

  • Column-specific Search: Use column: to search within a specific column. Example: country:france searches for entries where the country starts with "france".

  • Operators:

    • : → startsWith search Example: name:jo matches "John", "Joanna", etc.

    • = → equals search Example: city=Stuttgart matches exactly "Stuttgart"

    • != or !: → negation Example: city!=Stuttgartor city!:Stuttgart excludes "Suttgart"

  • Special Behavior:

    • Umlaut substitution: Umlauts are normalized (e.g., Björn can be found by searching for Bjorn).

    • Unicode support: Unicode characters are supported in search terms.

    • Brackets () are ignored in startsWith searches.

    • Empty value search:

      • zip:"" searches for empty values

      • zip: searches for any value

  • Supported Columns:

    • Aliases for column names may exist and are listed in brackets

    • User table:

      • name, upn, language (lang), jobtitle (job), city, country, zip (plz), enabled, department (dept)

        • enabled: → accepts true or false (enabled:true)

    • Groups table

      • name

    • Device table

      • name, operatingsystem (os), manufacturer (manu), model

Examples

Get all users of a specific department:

department:"Sales Department"

Get all users with job title CEO:

job:CEO

Get all users with job title CEO not in Germany:

job:CEO country!:Germany

Get all users starting with ADM- with an empty department:

name:ADM- department=""

Get all users with postal code 63065:

zip:63065

List all users with specific domain:

domain.com

Get all Dell XPS devices:

manu:dell model:xps

FAQ

How often is the data cached?

The table is cached on a schedule, currently set to 1 hour.

Can I refresh the data manually?

In the top right corner of each table, there's a button to refresh the cached data.

Can other users use my refreshed data?

The table is available for all users in the same RealmJoin portal instance. Thus, a triggered rebuild will do so for all those users.

What is an RealmJoin portal instance?

The RealmJoin portal has three different instances for load balancing and redundancy reasons.

How long will a rebuild/refresh of the advanced search take?

The rebuild time depends on the size of the tenant and the number of objects. It is not uncommon, that the rebuild might take several minutes. During the rebuild, only the basic search is available. All data is then queried directly via Graph, thus reducing the capabilities in filtering and speed.