List all command lines associated with the deliverable software resource.
I hope someone can guide me in the right direction. Using ASDK we developed a software delivery tool that allows our helpdesk to setup the SWD task without the need to visit the console.
Basically the analyst selects the package from the dropdown list. Based on the package selection they select the command (Install, Uninstall etc.) assigned to the given software package. It worked like a charm in NS6. When we migrated to NS7.1, it also worked because we moved the packages to the new platform.
The troubles started when started adding the software packages. NS 7.1. The new version allows you to create command lines assigned to the software resource even without the software package as far as I could find.
In the old NS6 all command lines were assigned to the packages.
We use the following queries to obtain the command lines assigned to any given package.
First query runs to get the GUID of the package given the name...
SELECT [SWDPackage].[PackageID] AS 'PackageID' FROM [SWDPackage] WHERE [Name] = '302963 Adobe Reader XI 11.0.04'
2nd query uses this GUID to then get the commands:
SELECT Distinct [SWDProgram].[Name] AS 'Name' FROM [SWDProgram] WHERE [PackageID] = '36827F8B-BA21-48BC-BAEF-8435119BF787' ORDER BY Name
Question is: how to get all command lines assigned to the deliverable software resource regardless the command line requires a package or not in NS7.1?