Windows 10 and Dell 1600 MFP Printer

If you have an old Dell printer that has no Windows 10 drivers available but has a network interface, try installing the printer via TCP/IP and using the Windows 7 x64 drivers.  If you don't have a network switch, you should be able to use a crossover cable from PC to printer.

I had given up on making it work from all the posts on the internet.  I didn't really care if I used it via USB or not, just wanted something to print from that was reliable.  I had spent $80 on ink for a free HP inkjet printer which ended up drying out and was ready to toss that thing.

I only came across this because I used a Macbook for my kid's remote school learning and surprised it found the printer.   After that, I tried installing the Bonjour service to no avail and then installed it via TCP/IP and was able to get it to print.  

This was a printer from a company I use to work for 12+ years ago that went out of business and still has 21% toner left. Rather than throwing something that still has plenty of life, it is usable again!  The inkjet however will be given away or disposed of... 

LDAP Query for Active Windows Client Workstations

If you are using ADUC or a security scan engine tool, this is how you can limit to searches for active machines.

Copy and paste the text into a custom search in ADUC or whatever you need it for.

(&(&(&(objectCategory=computer)(objectClass=computer)(|(operatingSystem=Windows\2010*)(operatingSystem=Windows\207*))(!userAccountControl:1.2.840.113556.1.4.803:=2))))

The "\20" is a placeholder for a space.  If you need to add other operating systems, add another "(operatingSystem=Windows\207*)" after it. 

XP: 

(operatingSystem=Windows\20XP*)

SCCM - AutoPilot Hardware (HW) IDs Report Query

We're trialing Intune to either replace or co-manage with SCCM and testing out Autopilot.

The generic canned report doesn't give you the computer name and only serial information, it is located under Hardware  - General -> Windows AutoPilot Device Information

Here's a query to pull more information modifying the same query to include computer name so you can enroll specific computers.  

SELECT        v_R_System.Name0 AS [PC Name], v_GS_PC_BIOS.SerialNumber0 AS [Serial Number], v_GS_MDM_DEVDETAIL_EXT01.DeviceHardwareData0 AS [Device HW ID], v_GS_OPERATING_SYSTEM.SerialNumber0 as [OS Serial], v_GS_OPERATING_SYSTEM.Caption0 as [Operating System] 

                         

FROM            v_R_System INNER JOIN

                         v_GS_MDM_DEVDETAIL_EXT01 ON v_R_System.ResourceID = v_GS_MDM_DEVDETAIL_EXT01.ResourceID INNER JOIN

                         v_GS_COMPUTER_SYSTEM_PRODUCT ON v_R_System.ResourceID = v_GS_COMPUTER_SYSTEM_PRODUCT.ResourceID INNER JOIN

                         v_GS_OPERATING_SYSTEM ON v_R_System.ResourceID = v_GS_OPERATING_SYSTEM.ResourceID INNER JOIN

                         v_GS_PC_BIOS ON v_R_System.ResourceID = v_GS_PC_BIOS.ResourceID

ORDER BY v_GS_COMPUTER_SYSTEM_PRODUCT.Version0

Old Adobe Software Downloads

If you have the keys but lost the install media, here's the Adobe site to download the older CS suites.

https://helpx.adobe.com/download-install/kb/cs6-product-downloads.html

SCCM - Windows Update Agent Compliance Item

This is a script I created to pro-actively detect systems that failed to add the WSUS server settings.

I set the threshold high due to the initial client install will have errors until the client applies the settings.

Most of the time, the fix was to delete the c:\windows\system32\GroupPolicy\Machine\Registry.pol and re-run the actions.

Const ForReading = 1
Set objRegEx = CreateObject("VBScript.RegExp")
objRegEx.Pattern = "Failed to Add Update Source for WUAgent"

Set objFSO = CreateObject("Scripting.FileSystemObject")

Set objFile = objFSO.OpenTextFile("C:\Windows\CCM\Logs\WUAHandler.log", ForReading)

i =0 

Do Until objFile.AtEndOfStream
    strSearchString = objFile.ReadLine
    Set colMatches = objRegEx.Execute(strSearchString)
    If colMatches.Count > 0 Then
        For Each strMatch in colMatches

i = i + 1
        Next
    End If
Loop

'Wscript.Echo "Number of failures: " & i

If i > 20 then 
Wscript.quit(1)
End If

objFile.Close

How to Re-Install SCCM Current Branch Updates

I recently updated it to 1806 and noticed something was missing when the Third Party Software Updates  feature wasn't available to enable in the console. 

I checked the log file CMUpdate.log in the directory below.  There was a lot errors seemingly in validating the files but nothing that I can make out to see what caused why it had the issues.

C:\Program Files\Microsoft Configuration Manager\Logs\

To reinstall the components, you would perform a site reset.

From MS, when a site reset runs at a central administration site or primary site, the site: (https://docs.microsoft.com/en-us/sccm/core/servers/manage/modify-your-infrastructure#bkmk_reset)

• Reapplies the default Configuration Manager file and registry permissions
• Reinstalls all site components and all site system roles at the site

The update should be in this directory below and run the splash.hta to bring up the menu.

C:\Program Files\Microsoft Configuration Manager\cd.latest\

Click Next and select the Reset site with no configuration changes.

You can view the log from the View Log button during the progress.

How to Install the SCCM Admin Console on a System without the Installation Media

I'm using the Microsoft Office 365 virtual lab and want to install it on another VM I created.  Unfortunately, this doesn't contain the install media to run the consolesetup.exe.

After some digging on the system, the installer can be found on the SCCM server or other sources could be another computer with the console installed and has been updated.

The directory where the files are found:  "C:\Program Files (x86)\ConfigMgr10\AdminconsoleSetup"




In the directory, you'll find some GUID named folders.  They will contain the "Adminconsole.msi" or the Console Update.

Depending on which source you get it from, you may have more than one folder containing the "Adminconsole.msi".  Install using the newest created date.

After installing the console, run the latest console update from searching the same directory to avoid the console from prompting to update on first launch.