Welcome to the Inedo Forums! Check out the Forums Guide for help getting started.

If you are experiencing any issues with the forum software, please visit the Contact Form on our website and let us know!

Global Plan Template Usage



  • Hello!

    In BuildMaster, is there a way I can find out where a global plan template has been used across actual application plans?

    Many thanks,

    Jamie

    Product: BuildMaster
    Version: 5.6.8


  • inedo-engineer

    Hello Jamie,

    There's not a way to do this through the BuildMaster interface, but if you have access to the SQL database, you can run this:

    SELECT P.[Plan_Name], A.[Application_Name]
      FROM [Plans] P
      LEFT JOIN [Applications] A ON P.[Application_Id] = A.[Application_Id]
     WHERE CONVERT(VARCHAR(MAX), P.[Plan_Bytes]) LIKE '%call MyPlanTemplateName%'
    

    There's a possibility of false positives because the SQL query doesn't actually parse the plans, but it should be able to give you a rough idea of where a template has been used.



Inedo Website HomeSupport HomeCode of ConductForums GuideDocumentation