How to filter by csvaLastPost, csvaLastFileAccessTimestamp virtual attributes in Microsoft Teams report

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 Microsoft Teams report.

Applies to: Cayosoft Administrator 6.3.1 or later

ID: KB20191022-1

---

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 csvaLastPost, csvaLastFileAccessTimestamp virtual attributes you should run 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 Cayosoft Administrator console create a new Microsoft Teams report
2. Open Other Query Settings section
3. In Initialization script setting specify this script: 

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

4. In Post-query filter specify this script: {$_.csvaLastPost -ge $DatePeriod}
   
   
5. Click Save Changes