Deployment Solution

 View Only
Back to discussions
Expand all | Collapse all

Find path to computer_group

  • 1.  Find path to computer_group

    Posted Nov 04, 2011 06:18 AM

    Deployment Server 6.9 SP5

    I need to find from within a job the complete path to the computer_group in which the computer resides, e.g.

    All Computers\Workstations\Build 9.0.0\Laptops\ComputerA<computername> </computername>

    <computername>

     

    The direct parent-folder I can find with:

    set GROUP_NAME=%#*"Select name from computer_group where group_id = ( Select group_id from computer where computer_id=%ID% )"%

    But I want to iterate this process up to the root (All Computers). How can I achieve this?

    </computername>