{"id":629,"date":"2013-09-09T10:00:47","date_gmt":"2013-09-09T10:00:47","guid":{"rendered":"http:\/\/sccm.haas.se\/?p=629"},"modified":"2013-09-09T11:27:09","modified_gmt":"2013-09-09T11:27:09","slug":"report-of-all-packages-in-a-folder","status":"publish","type":"post","link":"https:\/\/sccm.haas.se\/?p=629","title":{"rendered":"Report of all Packages in a Folder"},"content":{"rendered":"

Yes, you can place the cursor on the Package Folder in the SCCM-console and select
\nShow->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.<\/p>\n

1. Create the Report. Easy, I’ve got it here for you:<\/p>\n

SELECT v_Package.PackageID, v_Package.Name, vSMS_Folders.Name AS Expr1\r\nFROM v_Package INNER JOIN\r\n vFolderMembers ON v_Package.PackageID = vFolderMembers.InstanceKey INNER JOIN\r\n vSMS_Folders ON vFolderMembers.ContainerNodeID = vSMS_Folders.ContainerNodeID\r\nWHERE (vSMS_Folders.Name LIKE @Foldername)\r\n<\/pre>\n
Now you see there’s a variable there (@Foldername) so you have to Press Prompt and enter the values like here:<\/p>\n
\"Prompt\"<\/a><\/p>\n
As you can see, I have a default value filled in because you cannot browse SCCM-folders from the Web-report. In this case my SCCM-folder is called “Orderable Applications”.<\/p>\n
Because the to SQL-Views vSMS_Folders and vFolderMembers are hidden you need to add rights for all Reporting Users to see those tables. If you’re not the SQL-Admin of your SCCM-database you might also need a beer for your admin here. (Personally I like craft beer.)<\/p>\n
In MS SQL Server Management Studio, open the properties for dbo.vSMS_Folders<\/em> first:<\/p>\n
\"sql\"<\/a><\/p>\n
Click on Search above and add webreport_approle<\/em> to vSMS_Folder.<\/p>\n
\"sql2\"<\/a><\/p>\n
Grant the Application Role\u00a0webreport_approle<\/em> Select rights like below:<\/p>\n
\"sql3\"<\/a><\/p>\n
Important:<\/strong> You have to the steps above again for\u00a0for the View dbo.vFolderMembers<\/em>.
\nIf you’ve added rights for both<\/strong> Views you should be able to run your report which will look like this:<\/p>\n
\"report\"<\/a><\/p>\n
That’s it. Good luck!<\/p>\n","protected":false},"excerpt":{"rendered":"
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<\/p>\n
Continue Reading… Report of all Packages in a Folder<\/span>Continue Reading…<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[39,38,13],"_links":{"self":[{"href":"https:\/\/sccm.haas.se\/index.php?rest_route=\/wp\/v2\/posts\/629"}],"collection":[{"href":"https:\/\/sccm.haas.se\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sccm.haas.se\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sccm.haas.se\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sccm.haas.se\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=629"}],"version-history":[{"count":13,"href":"https:\/\/sccm.haas.se\/index.php?rest_route=\/wp\/v2\/posts\/629\/revisions"}],"predecessor-version":[{"id":648,"href":"https:\/\/sccm.haas.se\/index.php?rest_route=\/wp\/v2\/posts\/629\/revisions\/648"}],"wp:attachment":[{"href":"https:\/\/sccm.haas.se\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=629"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sccm.haas.se\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=629"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sccm.haas.se\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=629"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}