Yes, you can place the cursor on the Package Folder in the SCCM-console and select
Show->Export List to export all packages in a folder. BUT. There seems to be a limit to maximum 500 packages so you will not get all packages in your folder if you have a lot of them. AND maybe someone in management want the report as a webreport too… So here are the three things you need to do.
1. Create the Report. Easy, I’ve got it here for you:
SELECT v_Package.PackageID, v_Package.Name, vSMS_Folders.Name AS Expr1
FROM v_Package INNER JOIN
vFolderMembers ON v_Package.PackageID = vFolderMembers.InstanceKey INNER JOIN
vSMS_Folders ON vFolderMembers.ContainerNodeID = vSMS_Folders.ContainerNodeID
WHERE (vSMS_Folders.Name LIKE @Foldername)
Read More...Read More...