Report On All Advertised Packaged in Software Portal

[MonitorMan]

I haven't been able to find a report or query that tells if a package is advertised through the SWP. Don't suppose someone know the column / table that holds the flags to advertise a package through the SWP?

Thanks in advance

[MonitorMan]

I was able to figure out the necessary SQL. Sharing the below for any others looking to understand what is completely listed in the software portal.

SELECT        
i.Guid [_itemGuid]
, i.Name
, i.Description
,CAST(CAST(State AS NVARCHAR(MAX)) AS XML).value(N'(//item/IsPublished)[1]','nvarchar(max)') [IsPublished]
,i.CreatedDate
,i.CreatedBy
FROM  Item i 
INNER JOIN ItemClass ic 
ON i.Guid = ic.Guid
WHERE        
ic.ClassGuid = 'E1C9F80B-5AC5-4970-8722-9E2BBB1E8147' --Altiris.SoftwarePortal.Resources.SoftwarePublishingItem
ORDER BY i.Name

 

[Pavankumar Yarlagatti]

Thank you very much for the SQL query. Works wonderfully. Is there any way you can add "Requested By" field in this one. I need to understand who is requesting the software. 

Thanks in advance.

[Chris Farrell]

There is a report to see requests at Reports > All Reports > Software > Portal > Software Request Status

[easy_coy]

You are a genius. I've been looking for this for years.

The E.

[Arthur Prosso]

Hi!
I suppose you are looking for this.
https://help.symantec.com/cs/itms8.5/SWM/v128399272_v127279765/Managing-software-publications?locale=EN_US

It is both a report and central page for managing the Software publications on Software Portal
Regards,
Artur

------------------------------
Software Engineer 5
Broadcom Inc.
------------------------------