Report that shows the Command Line that is published to the Software Portal

Products

• IT Management Suite
• Client Management Suite

Issue/Introduction

Is there a report that shows which Command Line is published to the Software Portal for each software package?

Environment

ITMS 8.7.x

Resolution

This report was created to show the Command Line that is published to the Portal.

select swp.Guid, swp.Name, cl.Name, cl.Description, cl.Guid
from vSWP_PublishingItemEx swp
join vItem cl
on cl.Guid = swp.CommandLine
where cl.classguid = '8FBC055F-D9BC-4255-ADB5-762F0839C7C9'
order by swp.Name

 

If you want to see more details, like the actual Command Lines available for each Software Package, try the query below.  It will show YES for the Command Line that is published to the Portal, and No for the rest of them.

select a.name as [Software Release Name], 
a.description as [Software Release Description],
g.name as [Command Line Name],
Cast((cast(i.state as xml).query('data(/item/commandLine)')) as varchar(max)) as [Command Line],
case when g.Guid = ex.CommandLine then 'YES'
else 'No'
end as [Published in Software Portal]
from vSoftwareComponent a 
join vAC_DeliverableSoftware b on a.guid = b.guid
join ResourceAssociation f on b.guid = f.ChildResourceGuid and f.ResourceAssociationTypeGuid = '2D12146F-8AA9-4A41-B7DB-577892EF8692'
join vItem G on f.ParentResourceGuid = g.guid and g.classguid = '8FBC055F-D9BC-4255-ADB5-762F0839C7C9'
join ItemReference H on f.ParentResourceGuid = h.ParentItemGuid and Hint = 'commandlinecontainsprogram'
join vItem i on H.ChildItemGuid = i.guid
join ItemReference ir on ir.ParentItemGuid = b.guid
join vSWP_PublishingItemEx ex on ex.guid = ir.ChildItemGuid
order by a.name, g.Name