SCCM Archives » Chad's Tech

Cleanup System Disk Files

There have been many scripts and solutions written for cleaning up unnecessary files on Windows computers to free up disk space. I’ve used several over the years, but nothing out on the interwebs fit what I thought was the best

Easy IIS log reading for ConfigMgr

This is just a bit of PowerShell to make reading and filtering IIS logs quick and easy.

#.Synopsis
#  Convert IIS log file to CSV
#.LINK
#  Based on https://stevenaskwith.com/2012/05/22/parse-iis-log-files-with-powershell/
#  Performance inspired by http://www.happysysadm.com/2014/10/reading-large-text-files-with-powershell.html
###########################################################################################################
#define the ConfigMgr Distribution Point's IIS log file to parse
$File = <span class="pl-pds">"</span>C:\InetPub\Logs\LogFiles\W3SVC1\u_ex$(<span class="pl-c1">Get-Date</span> <span class="pl-k">-</span>Format yyMMdd).log<span class="pl-pds">"</span>
#read the 4th line in the most efficient way to generate an array of the column headers
$Headers = @((Get-Content -Path $File -ReadCount 4 -TotalCount 4)[3].split(' ') | Where-Object {$_ -ne '#Fields:'})
Write-Output "Reading $([math]::Round($(Get-Item -Path $File).length/1mb,1)) MB file..."
$FileCSV = Import-Csv -Delimiter ' ' -Header $Headers -Path $File | Where-Object {$_.date -notlike '#*'}
$FileCSV | Out-GridView -Title "IIS log: $File"

#.Synopsis

# Convert IIS log file to CSV

#.LINK

# Based on https://stevenaskwith.com/2012/05/22/parse-iis-log-files-with-powershell/

# Performance inspired by http://www.happysysadm.com/2014/10/reading-large-text-files-with-powershell.html

###########################################################################################################

#define the ConfigMgr Distribution Point's IIS log file to parse

$File = "C:\InetPub\Logs\LogFiles\W3SVC1\u_ex$(Get-Date -Format yyMMdd).log"

#read the 4th line in the most efficient way to generate an array of the column headers

$Headers = @((Get-Content -Path $File -ReadCount 4 -TotalCount 4)[3].split(' ') | Where-Object {$_ -ne '#Fields:'})

Write-Output "Reading $([math]::Round($(Get-Item -Path $File).length/1mb,1)) MB file..."

$FileCSV = Import-Csv -Delimiter ' ' -Header $Headers -Path $File | Where-Object {$_.date -notlike '#*'}

$FileCSV | Out-GridView -Title "IIS log: $File"

Get the latest version on GitHub.

Report all ConfigMgr admin console users

So, who exactly has access to the ConfigMgr admin console? This bit of PowerShell will generate a CSV report of each Active Directory user in each role/group*. *Note: nested groups are not yet supported.

#.LINK https://github.com/ChadSimmons/Scripts/blob/default/ConfigMgr/Document/Get-MECMAdminConsoleUsers.ps1
$SiteCode = 'LAB'
$SiteServer = 'CMPrimary.contoso.com'
$ExportFile = 'C:\Data\Get-MECMAdminConsoleUsers.csv'
Push-Location -Path "$SiteCode`:"
$CMAdminUsers = Get-CMAdministrativeUser | Select-Object LogonName, IsGroup
Pop-Location
$CMAdminUserList = @()
ForEach ($CMAdminUser in $CMAdminUsers) {
    Write-Output $CMAdminUser.LogonName
    If ($CMAdminUser.IsGroup -eq $true) {
        $CMAdminUserIDs = (Get-WmiObject -ComputerName $SiteServer -Namespace "root\SMS\site_$($SiteCode)" -Query "Select UniqueUserName from SMS_R_User where UserGroupName like `"$($CMAdminUser.LogonName.replace('\','\\'))`"").UniqueUserName
    } Else {
        $CMAdminUserIDs = (Get-WmiObject -ComputerName $SiteServer -Namespace "root\SMS\site_$($SiteCode)" -Query "Select * from SMS_R_User where UniqueUserName = `"$($CMAdminUser.LogonName.replace('\','\\'))`"").UniqueUserName
    }
    ForEach ($CMAdminUserID in $CMAdminUserIDs) {
        $CMAdminUserList += @(Get-WmiObject -ComputerName $SiteServer -Namespace "root\SMS\site_$($SiteCode)" -Query "Select * from SMS_R_User where UniqueUserName = `"$($CMAdminUserID.replace('\','\\'))`"" | Select-Object @{N = 'Group'; E = { $CMAdminUser.LogonName } }, UniqueUserName, ResourceID, ResourceType, UserName, Name, displayname, WindowsNTDomain, distinguishedName, FullDomainName, FullUserName, UserPrincipalName, mail, mobile, telephoneNumber, UserGroupName)
    }
}
$CMAdminUserList | Select-Object Group, UniqueUserName, ResourceID, ResourceType, UserName, Name, displayname, WindowsNTDomain, distinguishedName, FullDomainName, FullUserName, UserPrincipalName, mail, mobile, telephoneNumber | Export-Csv -Path "filesystem::$($ExportFile)" -NoTypeInformation

#.LINK https://github.com/ChadSimmons/Scripts/blob/default/ConfigMgr/Document/Get-MECMAdminConsoleUsers.ps1

$SiteCode = 'LAB'

$SiteServer = 'CMPrimary.contoso.com'

$ExportFile = 'C:\Data\Get-MECMAdminConsoleUsers.csv'

Push-Location -Path "$SiteCode`:"

$CMAdminUsers = Get-CMAdministrativeUser | Select-Object LogonName, IsGroup

Pop-Location

$CMAdminUserList = @()

ForEach ($CMAdminUser in $CMAdminUsers) {

Write-Output $CMAdminUser.LogonName

If ($CMAdminUser.IsGroup -eq $true) {

$CMAdminUserIDs = (Get-WmiObject -ComputerName $SiteServer -Namespace "root\SMS\site_$($SiteCode)" -Query "Select UniqueUserName from SMS_R_User where UserGroupName like `"$($CMAdminUser.LogonName.replace('\','\\'))`"").UniqueUserName

} Else {

$CMAdminUserIDs = (Get-WmiObject -ComputerName $SiteServer -Namespace "root\SMS\site_$($SiteCode)" -Query "Select * from SMS_R_User where UniqueUserName = `"$($CMAdminUser.LogonName.replace('\','\\'))`"").UniqueUserName

}

ForEach ($CMAdminUserID in $CMAdminUserIDs) {

$CMAdminUserList += @(Get-WmiObject -ComputerName $SiteServer -Namespace "root\SMS\site_$($SiteCode)" -Query "Select * from SMS_R_User where UniqueUserName = `"$($CMAdminUserID.replace('\','\\'))`"" | Select-Object @{N = 'Group'; E = { $CMAdminUser.LogonName } }, UniqueUserName, ResourceID, ResourceType, UserName, Name, displayname, WindowsNTDomain, distinguishedName, FullDomainName, FullUserName, UserPrincipalName, mail, mobile, telephoneNumber, UserGroupName)

}

$CMAdminUserList | Select-Object Group, UniqueUserName, ResourceID, ResourceType, UserName, Name, displayname, WindowsNTDomain, distinguishedName, FullDomainName, FullUserName, UserPrincipalName, mail, mobile, telephoneNumber | Export-Csv -Path "filesystem::$($ExportFile)" -NoTypeInformation

The latest code can be

ConfigMgr SSRS – UserTokenSIDs contains an error: “The trust relationship between this workstation and the primary domain failed”

A few days ago I began receiving errors when running reports in the ConfigMgr console and the web portal.

The DefaultValue expression for the report parameter UserTokenSIDs contains an error: "The trust relationship between this workstation and the primary domain failed". (rsRuntimeErrorInExpression)

1	The DefaultValue expression for the report parameter UserTokenSIDs contains an error: "The trust relationship between this workstation and the primary domain failed". (rsRuntimeErrorInExpression)

A few other very generic errors were displayed as well, but this one was the most prevalent and detailed (if

ConfigMgr Database Maintenance – 2020 edition

Steve Thompson, ConfigMgr MVP and SQL MVP, has a nice write up on using Ola’s Maintenance Solution with ConfigMgr. It’s good stuff. Matthew Teegarden has a follow-up article with more info and some alterations. There’s only one problem… both are

Protected: Preventing ConfigMgr from affecting specific computers (like servers)

There is no excerpt because this is a protected post.

Windows 10 Upgrade without Upgrade Readiness

When Microsoft made the Upgrade Readiness solution freely available to anyone back in the Spring of 2017 it was a major step forward in the monumental task of upgrading Windows 7 and Windows 8.1 computers to Windows 10 and keeping

ConfigMgr Chassis Type Global Condition / Requirement

Working with a customer recently we wanted to deploy a ConfigMgr Application to all all laptops in the organization without creating a new collection of just laptops. Using the ChassisTypes property of the Win32_SystemEnclosure WMI namespace is a great way

« Previous