Get all Target.Machines per Environment per Project

Mohammad.Nouman · 19 October 2022 03:17

Hi,

First of all thanks for this great product !

I have been given a task to identify how many machines are used in octopus as Deployment target in respect to all Projects.
Suppose we have 3 Projects : Project-A, Project-B and Project-C
All three projects have 3 environments : Dev, QA, PROD
Each Environment of a project has deployment machines : Server 1, Server 2 and Server 3 (total 9 Machines)

I want to extract this data so that we can identify how many machines are been used in Dev environment under Project A
Currently we have almost 1100 deployment targets and more than 50 environments

Thanks
Mohd

Kenneth_Bates · 19 October 2022 04:31

Hi Mohammad,

Thanks for getting in touch, and we appreciate the kind words! It’s always great to hear that Octopus has provided value.

I had a look in our sample script repo and found one that looks to be very close to what you’re after.

github.com

OctopusDeploy/OctopusDeploy-Api/blob/master/REST/PowerShell/Projects/GetCurrentTargetCountPerProject.ps1

# Gives a count of enabled targets per project at the time of the script running
#
# Output in JSON in the format:
# [{
#     "Id": "Projects-61",
#     "Name": "Canary Environment",
#     "WebUrl": "https://samples.octopus.app/app#/Spaces-43/projects/Projects-61",
#     "space": "Spaces-43",
#     "TargetRoles": [
#       "@{Name=OctoFX-Web; CountOfTargets=9}"
#     ],
#     "CountOfTargets": 9
#   },
#   {
#     "Id": "Projects-63",
#     "Name": "One Environment",
#     "WebUrl": "https://samples.octopus.app/app#/Spaces-43/projects/Projects-63",
#     "space": "Spaces-43",
#     "TargetRoles": [
#       "@{Name=OctoFX-Web-Canary; CountOfTargets=2}",

This file has been truncated. show original

I imagine you may want to tweak that to filter machines only in the Dev environment, but I’m curious to hear how close the data returned in that script is to what you need.

Best regards,

Kenny

Mohammad.Nouman · 19 October 2022 04:56

Hi Kenny,

Thanks for sharing the feedback on this. I am currently getting a 404 error on Line 60 in this script

Invoke-WebRequest : The remote server returned an error: (404) Not Found.

At line:60 char:36
+ ... tProcess = (Invoke-WebRequest $deploymentProcessUrl -Headers $header) ...
+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-WebRequest], WebException
    + FullyQualifiedErrorId : WebCmdletWebResponseException,Microsoft.PowerShell.Commands.InvokeWebRequestCommand

Can I test this script on one any test Octopus instances ?

Kenneth_Bates · 19 October 2022 06:05

Hi Mohammad,

Thanks for following up! I can’t see the reason why a 404 would be thrown at that point, unfortunately, as it looks to simply be in the foreach loop making a request to the current project. You can test it against the https://samples.octopus.app cloud instance using the api key API-GUEST, and that seemed to have run as expected in my identical test. Does that work for you?

Best regards,

Kenny

system · 19 November 2022 06:06

This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.