Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Help: Custom software report

Created: 06 Mar 2014 | 4 comments

Hi...

I'm looking to create two reports and struggling to find the right method.

One to list all Deliverable Software. The other to list all tasks available from Quick Delivery folder.

Any help is appreciated!

Operating Systems:

Comments 4 CommentsJump to latest comment

SK's picture

For the quick delivery request, the following blog will help:-  https://www-secure.symantec.com/connect/blogs/how-...

The following query will isolate your search to just the Quick Delivery folder (the guid is from 7.5 so maybe different if you are using 7.1):

SELECT vi1.Name As Folder,vi2.Name AS Item
FROM vItem vi1
JOIN vItemFolder vif ON vif.ParentFolderGuid = vi1.[Guid]
JOIN vItem vi2 ON vi2.[Guid] = vif.ItemGuid
WHERE vif.ParentFolderGuid = 'acbbbbcd-dcf4-4c3a-afe4-070050b1c053'

Can you please elaborate on what you mean by deliverable software?  All software resources that have actual physical files associated with them?

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.

Jayel's picture

Thanks SK. Perfect.

Yes... Deliverable software on the software console, which have actual files assigned to it.

SK's picture

This thread should hopefully help you out with your deliverable software requirement:-  https://www-secure.symantec.com/connect/forums/lis...

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.

SK's picture

Do you still need assistance?

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.