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.
- In Cayosoft Administrator console create a new Microsoft Teams report
- Open Other Query Settings section
- In Initialization script setting specify this script:
{
$global:DatePeriod = (Get-Date).AddDays(-10)
$DatePeriod = $DatePeriod.ToUniversalTime().ToString("u")
} - In Post-query filter specify this script: {$_.csvaLastPost -ge $DatePeriod}
- Click Save Changes
Comments
0 comments
Please sign in to leave a comment.