The following query will allow you to search the view v_R_user in the Microsoft Configuration Manager database so that you can identify a manager and then find everyone who works for that manager all the way down the tree. I’ve found this useful in the past for joining with other information in the database to identify all the systems used by a specific group within an organization. This requires that you collect the manager name during user discovery. You can remove any fields that you don’t discover. It also requires that you have managers identified in Active Directory for discovery.
I recently was troubleshooting the following error on roughly 400 systems that we were deploying the Citrix Receiver v14 to:
Image Credit Christopher Cable.
There are a few discussion board posts online that discuss this issue and provide some helpful tips for manually fixing the issue. Ones that helped me the most was this response by Mike Moskal on the Citrix Discussion Board.
I wrote the following script to quickly output how much disk space my SCCM Distribution Points consumed. If you’re not running a CAS, you’ll want to change line 21 to point to your primary. This requires that you have the Configuration Manager console installed on the machine.
It’s not pretty but it did the trick. I’m certainly open to suggestions in the comments.
In this video demo I’m going to show you how concatenate strings, as well as the functions LEFT, MID, RIGHT, FIND, TRIM, and LEN, and then how to use them together to get what it is you’re looking for. At the end of the demo, we’ll touch on the IF function and show you how you can manipulate the table based on some set of criteria.