Forum Discussion
List all NEW resources created within a week
Hello:
I wonder if there is a way to find out ALL Resources in our tenant that were created since specific date (like last 7 days).
Ideally I'd like to run it via PowerShell...
How can I do it?
We are not enforcing "create date" tags... I thought about Powershell, but sometimes there are CreateDate, sometimes CreateAt...
Thank you!
Try this:
Connect-AzAccount
$startDate = (Get-Date).AddDays(-7) # Change this to your desired start date
$endDate = Get-Date$activityLogs = Get-AzActivityLog -StartTime $startDate -EndTime $endDate -MaxRecord 1000 | Where-Object { $_.OperationName -like "Microsoft.Resources/subscriptions/resourceGroups/deployments/write" }
$createdResources = @()
foreach ($log in $activityLogs) {
$resource = @{
ResourceId = $log.ResourceId
ResourceName = $log.ResourceId.Split('/')[-1]
ResourceType = $log.ResourceType
ResourceGroupName = $log.ResourceGroupName
SubscriptionId = $log.SubscriptionId
CreatedTime = $log.EventTimestamp
}
$createdResources += New-Object PSObject -Property $resource
}# Display the results
$createdResources | Format-Table -AutoSize
3 Replies
Try this:
Connect-AzAccount
$startDate = (Get-Date).AddDays(-7) # Change this to your desired start date
$endDate = Get-Date$activityLogs = Get-AzActivityLog -StartTime $startDate -EndTime $endDate -MaxRecord 1000 | Where-Object { $_.OperationName -like "Microsoft.Resources/subscriptions/resourceGroups/deployments/write" }
$createdResources = @()
foreach ($log in $activityLogs) {
$resource = @{
ResourceId = $log.ResourceId
ResourceName = $log.ResourceId.Split('/')[-1]
ResourceType = $log.ResourceType
ResourceGroupName = $log.ResourceGroupName
SubscriptionId = $log.SubscriptionId
CreatedTime = $log.EventTimestamp
}
$createdResources += New-Object PSObject -Property $resource
}# Display the results
$createdResources | Format-Table -AutoSize