Forum Discussion

Copper Contributor

Aug 25, 2024

Solved

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 i...

Azure Resource Management

Kidd_Ip
Aug 25, 2024
Oleg_A

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

Kidd_Ip

MVP

Aug 25, 2024

Oleg_A

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

Oleg_A
Copper Contributor
Aug 26, 2024
Kidd_Ip ,

Thanks a lot!!! It worked perfectly!

I just had to adjust one line:

$activityLogs = Get-AzActivityLog -StartTime $startDate -EndTime $endDate -MaxRecord 1000 | Where-Object { $_.OperationName -like "Create*"}

Thanks again!
Oleg_A
Copper Contributor
Aug 26, 2024
Kidd_Ip ,

Thank you very much!
Such a great idea to use logs...

I'll try tomorrow and let you know.

Thank you!