Month: September 2013

Running a User Discovery for ONE user…

Isn’t it annoying when a customer has a “bad” AD-structure that makes it impossible to run user-discovery or system discovery often enough? By “bad” AD-structure I mean putting computers or users for an entire organization in one OU for example. The drawback of not being able to run User/System-discovery often enough is that users will have to wait for their applications after the computer is installed since SCCM doesn’t know about the group memberships until the discovery tasks are run.

I’ve come up with a method for inventoring only one computer/user. In this first post of two I’ll describe the process for users, which is useful if you run user-based installations.

Read More…Read More…

Report of all Packages in a Folder

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...