1.2 Breaking Changes

1.2.1 Deprecated Views

The following views are deprecated as of File Reporter 4.0 in favor of their corresponding generic view names:

  • srs.current_fs_scandata_ad

  • srs.previous_fs_scandata_ad

  • srs.baseline_fs_scandata_ad

Please use the following views instead, as the *_ad views are subject to removal in a later release:

  • srs.current_fs_scandata

  • srs.previous_fs_scandata

  • srs.baseline_fs_scandata

1.2.2 Removed Tables

The ms365.site_drives table has been removed as of File Reporter 4.1.

The ms365.drives table now include a site_id reference column that replaces the need for this bridge table.

Upgrading from File Reporter 4.0 to 4.1 automatically extends this table and populates the corresponding new reference column using the legacy ms365.site_drives table before dropping it.

IMPORTANT:Any Custom Queries that reference the legacy ms365.site_drives table will need to be updated to make use of the new ms365.drives.site_id column instead.

Any queries that continue to reference the legacy table will no longer work after upgrading to File Reporter 4.1 or later until this change has been made.

1.2.3 Removed Columns

The grantedto_id_type string-typed column in the ms365.permissions table has been removed as of File Reporter 4.1.

A replacement column grantedto_type has been added which is an integer type representing a discrete enumeration.