How to filter by csvaLastPost and csvaLastFileAccessTimestamp in Microsoft Teams reports

Summary: Cayosoft Administrator provides built-in csvaLastPost and csvaLastFileAccessTimestamp virtual attributes to store the last file access time and the last post time for each Team.

This article contains step-by-step instructions on how to filter by these virtual attributes in the Microsoft Teams report.

Applies to: Cayosoft Administrator 6.3.1 or later

Example

Find all Teams that have at least one post or access a file for the last 10 days.

Step-by-step instructions

Before using the csvaLastPost, csvaLastFileAccessTimestamp virtual attributes, run the Analytics Collection | Teams Usage rule that queries Microsoft Teams and records for each Team the last file access time and the last post time to these attributes.

1. In the Cayosoft Administrator console, create a new Microsoft Teams rule.

2. Open the Other Query Settings section.

3. In the Initialization script settings, specify this script:

   Copy

   {
   $global:DatePeriod = (Get-Date).AddDays(-10)
   $DatePeriod = $DatePeriod.ToUniversalTime().ToString("u")
   }

4. In the Post-query filter, specify this script:

   Copy

   {$_.csvaLastPost -ge $DatePeriod}

5. 

6. Click Save Changes.