Delete Users Assets Report
The "Deleted Users Assets Report" provides an overview of assets (content and course assets) created by users who have been deleted from the system. The report involves the following steps:
Fetch Deleted Users: Retrieve a list of users who have been marked as deleted from the database.
Extract User IDs: Extract the unique identifiers for these deleted users.
Fetch Content Assets: Query an external API to fetch assets (such as documents, media, etc.) created by these deleted users.
Fetch Course Assets: Query an external API to fetch course-related assets (like course batches) associated with these deleted users.
Process DataFrames: Integrate the dataframes for deleted users and their assets, and perform necessary processing, such as filtering and deduplication.
Save Report to Blob Storage: Save the final processed report to a cloud-based blob storage, typically in CSV format.
This report is useful for auditing, tracking, and removing assets that are no longer needed, ensuring system cleanliness and compliance with data retention policies.
Data provider:
Cassandra - User table
Course Batch API
Content Search API
Delete Asset report CSV content:
Sample data:
Last updated