Skip to main content

Custom report - filters and columns

Lists all filters and columns available for each object type in ShareGate Migrate custom reports.

When you create a custom report in ShareGate Migrate, you choose an object type to report on.

Each object type comes with its own filters and columns you can use to narrow down results and add detail to your report.

This article lists every filter available for each object type, organized by category.

To learn how to edit reports, see Create a custom report and modify a built-in report.

Tip: The columns available for each report match its filters. You can add any filter as a column to display that data in your results, then export to Excel for additional sorting and filtering.

SharePoint

Site collection

Filter

Category

Administrators

General

Description

General

Is hub site

General

Number of subsites (child)

General

Number of subsites (total)

General

RSS feeds

General

Site address

General

Site depth

General

Site level

General

Site owners

General

Size

General

Title

General

Custom master page

Display

Language

Display

Master page

Display

Site template

Display

Site collection features

Advanced

Site features

Advanced

Current navigation

Navigation

Global navigation

Navigation

Audited events

Audit

Days of audit log data to retain

Audit

Report storage location

Audit

Trim audit log

Audit

Access request email

Security

Allow access request

Security

Anonymous access

Security

Custom permissions

Security

Permissions

Security

Share by email

Security

Share by link

Security

SharePoint Designer access

Security

Created date

Authors and timestamps

Last modified date

Authors and timestamps

Lists

Relations

SharePoint groups

Relations

Site columns

Relations

Site content types

Relations

Users

Relations

OneDrive for Business

Note: OneDrive for Business uses the same filters as Site collection. See the Site collection section above for the full list.

Site

Filter

Category

Description

General

Number of subsites (child)

General

Number of subsites (total)

General

RSS feeds

General

Site address

General

Site collection address

General

Site depth

General

Site level

General

Site owners

General

Size

General

Title

General

Custom master page

Display

Language

Display

Master page

Display

Site template

Display

Site features

Advanced

Current navigation

Navigation

Global navigation

Navigation

Access request email

Security

Allow access request

Security

Anonymous access

Security

Custom permissions

Security

Permissions

Security

Created date

Authors and timestamps

Last modified date

Authors and timestamps

Lists

Relations

Site columns

Relations

Site content types

Relations

List

Filter

Category

Attachments

General

Audience targeting

General

Base type

General

Description

General

Has workflows

General

Is system

General

Number of items

General

On quick launch

General

Size

General

Title

General

List experience

Display

List template

Display

Allow new folders

Advanced

Content type management

Advanced

Document template

Advanced

Exclude from search results

Advanced

Offline client availability

Advanced

Allow multiple responses

Survey

Show user

Survey

Content approval

Versioning

Major version limit

Versioning

Major with minor versions limit

Versioning

Minor versions

Versioning

Require checkout

Versioning

Versioning

Versioning

Anonymous access

Security

Custom permissions

Security

Draft item security

Security

Has content with unique permissions

Security

Permissions

Security

Created date

Authors and timestamps

Last modified date

Authors and timestamps

Documents

Relations

List columns

Relations

List content types

Relations

Site

Relations

List item

Filter

Category

Approval status

General

Content type

General

Title

General

Version number

Versioning

Custom permissions

Security

Permissions

Security

Retention label

Security

Created by

Authors and timestamps

Created date

Authors and timestamps

Last modified by

Authors and timestamps

Last modified date

Authors and timestamps

List

Relations

Document

Filter

Category

Approval status

General

Checked out status

General

Checked out to

General

Content type

General

File extension

General

Name

General

Size

General

Total size (all versions)

General

Never checked in

Versioning

Version number

Versioning

Anonymous guest link

Security

Custom permissions

Security

Organization guest link

Security

Permissions

Security

Retention label

Security

Created by

Authors and timestamps

Created date

Authors and timestamps

Last modified by

Authors and timestamps

Last modified date

Authors and timestamps

List

Relations

Site address

Relations

Microsoft 365

Microsoft 365 group

Filter

Category

Allow external senders

General

Associated site address

General

Auto subscribe new members to alerts

General

Description

General

Display name

General

Email address

General

Group privacy

General

Guests

General

ID

General

Is dynamic

General

Is team connected

General

Members

General

Owners

General

Created date

Authors and timestamps

Microsoft team

Filter

Category

Associated site address

General

Channel count

General

Classification

General

Description

General

Display name

General

Group privacy

General

Guests

General

ID

General

Members

General

Owners

General

Private channel count

General

Standard channel count

General

Created date

Authors and timestamps

Planner plan

Filter

Category

Group name

General

Group privacy

General

Guests

General

ID

General

Members

General

Plan title

General

Created by

Authors and timestamps

Created date

Authors and timestamps

Active tasks count

Buckets and tasks

Buckets count

Buckets and tasks

Completed tasks count

Buckets and tasks

In progress tasks count

Buckets and tasks

Late tasks count

Buckets and tasks

Not started tasks count

Buckets and tasks

Total tasks count

Buckets and tasks

People and permissions

User

Filter

Category

Account

General

Email

General

Name

General

Is external

Security

Is orphaned

Security

Is site collection administrator

Security

Site collection

Relations

SharePoint group

Filter

Category

Allow join/leave requests

General

Auto-accept membership requests

General

Everyone can view membership

General

Members

General

Members can edit membership

General

Membership request email

General

Name

General

Notes

General

Owner

General

Site collection

Relations

Site permission

Filter

Category

Inherited

General

Permission levels

General

Principal type

General

User/group

General

Site

Relations

List permission

Filter

Category

Inherited

General

Permission levels

General

Principal type

General

User/group

General

List

Relations

Item-level permission

Filter

Category

Inherited

General

Permission levels

General

Principal type

General

User/group

General

List

Relations

Schema

Site content type

Filter

Category

Description

General

Document template

General

Group

General

Name

General

Parent name

General

Read only

General

Scope

General

Columns

Relations

Site

Relations

Site column

Filter

Category

Default value

General

Description

General

Enforce unique values

General

Formula

General

Group

General

Indexed

General

Required

General

Title

General

Type

General

Site

Relations

List content type

Filter

Category

Description

General

Document template

General

Group

General

Name

General

Parent name

General

Read only

General

Scope

General

Columns

Relations

List

Relations

List column

Filter

Category

Default value

General

Description

General

Enforce unique values

General

Formula

General

Group

General

Indexed

General

Required

General

Title

General

Type

General

List

Relations

Workflows

Site workflow

Filter

Category

Category

General

Description

General

Enabled

General

Name

General

Platform type

General

Site address

General

Site collection address

General

Start manually

Advanced

Created date

Authors and timestamps

Modified date

Authors and timestamps

History list

Associations

Task list

Associations

Site

Relations

List workflow

Filter

Category

Category

General

Description

General

Enabled

General

Is built-in workflow

General

Name

General

Platform type

General

Start manually

Advanced

Start when an item is created

Advanced

Start when an item is modified

Advanced

Created date

Authors and timestamps

Modified date

Authors and timestamps

Associated content type

Associations

History list

Associations

Task list

Associations

Associated list

Relations

Site address

Relations

Site collection address

Relations

Did this answer your question?