SCCM Report for computer Name and Mac Address

 

                    SCCM Report for computer Name and Mac Address

In this blog post, we will explore how to generate a System Center Configuration Manager (SCCM) report that provides computer names and MAC addresses. The ability to obtain computer names and MAC addresses is essential for network troubleshooting, asset management, and inventory tracking. Here is SCCM Query...

SELECT

    SubQuery.ComputerName,

    SubQuery.MACAddress

FROM

    (

        SELECT

            CS.Name0 AS 'ComputerName',

            MAC.MACAddress0 AS 'MACAddress',

            ROW_NUMBER() OVER (PARTITION BY MAC.MACAddress0 ORDER BY MAC.Index0 DESC) AS RowNum

        FROM

            v_GS_COMPUTER_SYSTEM CS

            JOIN v_GS_NETWORK_ADAPTER MAC ON CS.ResourceID = MAC.ResourceID

        WHERE

            MAC.MACAddress0 IS NOT NULL

            AND MAC.MACAddress0 != ''

    ) SubQuery

WHERE

    SubQuery.RowNum = 1

“The User Profile Service failed the logon. User profile cannot be loaded.”

How to fix The User Profile Service failed the logon

Overview

Steps to fix for error “The User Profile Service failed the logon. User profile cannot be loaded.”

Steps to Fix

Please login to the computer with Administrator Account.

Navigate to C:\Users folder

Right click on the default folder and choose properties then click on the security tab

Click the Advanced button in the lower right hand corner

Click on the change Permissions button on the left hand side of below image

In the below image Check “Replace all child object permissions with inheritable permissions from this object”

Close all windows reboot system

SCCM Query for Specific Patch

SCCM Query for Specific Patch

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System   inner join SMS_G_System_QUICK_FIX_ENGINEERING on SMS_G_System_QUICK_FIX_ENGINEERING.ResourceId = SMS_R_System.ResourceId   where SMS_G_System_QUICK_FIX_ENGINEERING.HotFixID = "KB1234567"

SCCM Patch mgmt Processes and Steps

Win10 v1507 reaches EOS with no further updates beyond 26/03/2017

What’s the Change?

Windows 10 v1607 has been designated as the second CBB and after a 60 day grace period which will end on 26 March 2017, Windows 10 v1507 will no longer be supported through servicing updates by Microsoft

Why this change?

As per Redmond, only two versions of Windows are designated as CBB at any given time, which means that Version 1511 released after v1507, also known as the November [2015] Update, would be the second CBB. 

How to get a list of Windows Updates installed in a specific computer

Windows Updates installed in a specific computer. You can use power shell or command line to run this. This can be accessed remotely using power shell to get the list of patches installed in a computer.


wmic qfe list full /format:csv > hotfixes.csv

Converting Text Files (like CSV files) to Excel Files

1. Highlight the table (or part of the table) that you want and copy it.
2. Paste the copied material into a text file. ...
3. Name the Notepad file somename.txt and close it.
4. Open Excel and from inside Excel, open up somename.txt.
5. Tick Comma Checkbox.

How to create the Output of the Command Line to a File

The command below will print the result to a file type of your choice and location 

net user administrator | findstr /B /C:"Last logon" >> C:\Temp\lastlogon.txt