May 27 2016

Recursively Query v_R_user in Configuration Manager

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.

Read More >>

Mar 9 2016

Video: How to use VLOOKUP in Microsoft Excel

In this video demo I’m going to show you how use VLOOKUP on a table in Excel.

 

Read More >>

Mar 2 2016

Citrix – Installation Error DVCRenderingAdapter.dll Failed to Register

I recently was troubleshooting the following error on roughly 400 systems that we were deploying the Citrix Receiver v14 to:

Citrix Receiver DVCRenderingAdapter failed to register

Image Credit Christopher Cable.

 

CustomAction +DVCRenderingAdapter.dll.827545C6_7013_4DE1_8E6C_DAEE4C57F54A returned actual error code -2147319780 (note this may not be 100% accurate if translation happened inside sandbox)MSI (s) (5C:9C) [10:08:57:789]: Product: Online Plug-in — Error 1904. Module C:\Program Files\Citrix\ICA Client\DVCRenderingAdapter.dll failed to register.  HRESULT -2147319780.  Contact your support personnel.
Error 1904. Module C:\Program Files\Citrix\ICA Client\DVCRenderingAdapter.dll failed to register.  HRESULT -2147319780.  Contact your support personnel.

 

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.

Read More >>

Oct 27 2015

PowerShell Script to Report SCCM DP Disk Space

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.

Read More >>

Oct 19 2015

Video: Text Manipulation in Microsoft Excel

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.

 

Read More >>