I would be grateful if someone could help me out on this one.
I've got a SQL report to pull out APPV packages installed on a particular system object(uses h/W inventory). It's prompting for the system name, and it works great.
I would like this report to run on a Collection to pull out the same information.
However my collections are in 2007 and some are nested.
ie Col1 > Col2> Col3
Now this structure can vary a bit so collections might have 3 childs and some have 5 child collections. Each collection will have system objects added
I want to use my report to prompt for the top parent collection and pull out the information of the parent and ALL the child collections.
Its easy to setup just pointing to the one collection, but I envisage non-It staff using it. So I want to make it easy for them to use.
Help would be grate on this one