Damberg Online

Function Check-PackageWMIvsLIB

Damberg 12th February 2020 0 Comments

This function compare what the Distribution Point has in WMI againt ContentLib

<#
        .Synopsis
        
        Compare WMI with ContentLIB locally on DP 

        .DESCRIPTION
        

        .EXAMPLE
        
        .EXAMPLE
   
   
#>




Function Check-PackageWMIvsLIB {


$WMIPkgList = Get-WmiObject -Namespace Root\SCCMDP -Class SMS_PackagesInContLib | Select -ExpandProperty PackageID | Sort-Object

$ContentLib = (Get-ItemProperty HKLM:SOFTWARE\Microsoft\SMS\DP).ContentLibraryPath

$PkgLibPath = ($ContentLib) + ‘\PkgLib’

$PkgLibList = (Get-ChildItem $PkgLibPath | Select -ExpandProperty Name | Sort-Object)

$PkgLibList = ($PKgLibList | ForEach-Object {$_.replace(‘.INI’,”")})

$PksinWMIButNotContentLib = Compare-Object -ReferenceObject $WMIPkgList -DifferenceObject $PKgLibList -PassThru | Where-Object { $_.SideIndicator -eq "<=" } 

$PksinContentLibButNotWMI = Compare-Object -ReferenceObject $WMIPkgList -DifferenceObject $PKgLibList -PassThru | Where-Object { $_.SideIndicator -eq "=>" } 

write-host
write-host
Write-Host Items in WMI but not the Content Library -ForegroundColor Green
 Write-Host ========================================
 $PksinWMIButNotContentLib

Write-Host Items in Content Library but not WMI -ForegroundColor Green
 Write-Host ====================================
 $PksinContentLibButNotWMI

}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

<#

.Synopsis

Compare WMI with ContentLIB locally on DP

.DESCRIPTION

.EXAMPLE

#>

Function Check-PackageWMIvsLIB {

$WMIPkgList = Get-WmiObject -Namespace Root\SCCMDP -Class SMS_PackagesInContLib | Select -ExpandProperty PackageID | Sort-Object

$ContentLib = (Get-ItemProperty HKLM:SOFTWARE\Microsoft\SMS\DP).ContentLibraryPath

$PkgLibPath = ($ContentLib) + ‘\PkgLib’

$PkgLibList = (Get-ChildItem $PkgLibPath | Select -ExpandProperty Name | Sort-Object)

$PkgLibList = ($PKgLibList | ForEach-Object {$_.replace(‘.INI’,”")})

$PksinWMIButNotContentLib = Compare-Object -ReferenceObject $WMIPkgList -DifferenceObject $PKgLibList -PassThru | Where-Object { $_.SideIndicator -eq "<=" }

$PksinContentLibButNotWMI = Compare-Object -ReferenceObject $WMIPkgList -DifferenceObject $PKgLibList -PassThru | Where-Object { $_.SideIndicator -eq "=>" }

write-host

Write-Host Items in WMI but not the Content Library -ForegroundColor Green

Write-Host ========================================

$PksinWMIButNotContentLib

Write-Host Items in Content Library but not WMI -ForegroundColor Green

Write-Host ====================================

$PksinContentLibButNotWMI

}

If you want to remove WMI entry that not are in lib

Get-WMIObject -ComputerName "DPNAME" -Namespace "root\sccmdp" -Query ("Select * from SMS_PackagesInContLib where PackageID = 'PACKAGEID'") | Remove-WmiObject

1	Get-WMIObject -ComputerName "DPNAME" -Namespace "root\sccmdp" -Query ("Select * from SMS_PackagesInContLib where PackageID = 'PACKAGEID'") \| Remove-WmiObject

Of if you want to remove from ContentLIB

##Delete .ini´s in PkgLib not in WMI
Remove-Item -Path "$PkgLibPath\PackageID.INI" -Confirm

1 2	##Delete .ini´s in PkgLib not in WMI Remove-Item -Path "$PkgLibPath\PackageID.INI" -Confirm

To be used at own…
Read more

ConfigMgr Script, Standalone Script

Primary user on device

Damberg 11th February 2020 0 Comments

With this query you get a list of devices and topuser (primary user) on device

SELECT
    SMS_R_User.FullUserName, SMS_R_User.UniqueUserName, SMS_R_System.Name
FROM
    SMS_R_System
INNER JOIN
    SMS_G_System_SYSTEM_CONSOLE_USAGE
    ON
    SMS_G_System_SYSTEM_CONSOLE_USAGE.ResourceId = SMS_R_System.ResourceId
INNER JOIN
    SMS_R_User
    ON
    SMS_G_System_SYSTEM_CONSOLE_USAGE.TopConsoleUser = SMS_R_User.UniqueUserName

1

2

3

4

5

6

7

8

9

10

11

12

SELECT

SMS_R_User.FullUserName, SMS_R_User.UniqueUserName, SMS_R_System.Name

FROM

SMS_R_System

INNER JOIN

SMS_G_System_SYSTEM_CONSOLE_USAGE

ON

SMS_G_System_SYSTEM_CONSOLE_USAGE.ResourceId = SMS_R_System.ResourceId

INNER JOIN

SMS_R_User

ON

SMS_G_System_SYSTEM_CONSOLE_USAGE.TopConsoleUser = SMS_R_User.UniqueUserName

SQL Query SCCM

Splash Screen for Driver and BIOS Update – OSDeploy | Sune Thomsen

Damberg 28th December 2019 0 Comments

www.osdsune.com/home/blog/2019/splash-screen-driver-bios-update

ConfigMgr Script

Add multiple users to multiple AD-groups

Damberg 9th May 2019 0 Comments

I got a question from the support at a customer how they could add multiple users to multiple groups without user the mmc “users and computers”, this is my quick solution…

<#
.Synopsis
   Combine two txt-files to one csv-file to import multi-user to multi-groups in AD
.DESCRIPTION
   This script can be used to import x-numbers of users to x-numbers of ad-groups
.EXAMPLE
   The script is based on three files...
   - users.txt - a txt-file with users samaccountname
   - groups.txt - a txt-file with the groups which the users should be member of
.EXAMPLE
   Another example of how to use this workflow
.NOTES


**************************************************************
 
Created:    2019-05-08
Version:    1.0
 
Disclaimer:
This script is provided "AS IS" with no warranties
 
Author - Christian Damberg 
    Twitter: @DambergC
    Blog   : https://www.damberg.org
 
************************************************************** 
#>


#step one - read users.txt file 

$users = get-content .\users.txt -Encoding UTF8

#step two  - this loop will run for all users in txt-file "users.txt"
foreach ($user in $users)
{
  #step three - this loop run all groups in "groups.txt" for each user 
  $rk1_group = Get-Content .\groups.txt -Encoding UTF8
  foreach ($group in $groups)
  {
    #step four - merge both txt-files to "result.txt"
    "$($user);$group" | Out-File .\result.txt -Append utf8
    
     }
}

#Step five - import the txt-file "result.txt" and export it to a csv-file named "user_group.csv"
import-csv .\result.txt -Delimiter ";" -Header user,group | export-csv .\user_group.csv -NoClobber -Encoding UTF8

#Step six - Read csv-file och run a loop with add-adgroupmember to add each user to each group.
#jobbet att lägga till, läs in csv och kör en lopp på hela filen
import-csv .\user_group.csv | ForEach-Object {Add-ADGroupMember -Identity $_.group -Members $_.user}

#Done

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

<#

.Synopsis

Combine two txt-files to one csv-file to import multi-user to multi-groups in AD

.DESCRIPTION

This script can be used to import x-numbers of users to x-numbers of ad-groups

.EXAMPLE

The script is based on three files...

- users.txt - a txt-file with users samaccountname

- groups.txt - a txt-file with the groups which the users should be member of

.EXAMPLE

Another example of how to use this workflow

.NOTES

**************************************************************

Created: 2019-05-08

Version: 1.0

Disclaimer:

This script is provided "AS IS" with no warranties

Author - Christian Damberg

Twitter: @DambergC

Blog : https://www.damberg.org

**************************************************************

#>

#step one - read users.txt file

$users = get-content .\users.txt -Encoding UTF8

#step two - this loop will run for all users in txt-file "users.txt"

foreach ($user in $users)

{

#step three - this loop run all groups in "groups.txt" for each user

$rk1_group = Get-Content .\groups.txt -Encoding UTF8

foreach ($group in $groups)

{

#step four - merge both txt-files to "result.txt"

"$($user);$group" | Out-File .\result.txt -Append utf8

}

#Step five - import the txt-file "result.txt" and export it to a csv-file named "user_group.csv"

import-csv .\result.txt -Delimiter ";" -Header user,group | export-csv .\user_group.csv -NoClobber -Encoding UTF8

#Step six - Read csv-file och run a loop with add-adgroupmember to add each user to each group.

#jobbet att lägga till, läs in csv och kör en lopp på hela filen

import-csv .\user_group.csv | ForEach-Object {Add-ADGroupMember -Identity $_.group -Members $_.user}

#Done

Active Directory

Folders in ConfigMgr – Work in progress

Damberg 8th May 2019 0 Comments

If you have a folder-structure in ConfigMgr and you need to remove the folders (if they are empty) and you tried to right-click and select remove…you noticed that it takes….looooong time to remove…. The following script removes all folders under…
Read more

ConfigMgr Script

Configure rights on WMI for monitoring

Damberg 8th May 2019 0 Comments

If you have PRTG and want to monitor thru wmi i´ve put together a guide based on two scripts (not created by me) what you need to do…. You need an service-account in your domain, not with domain-admin-rights, only a…
Read more

Standalone Script

Create CI and Baseline for verifying SNMP-service installed and running

Damberg 14th March 2019 0 Comments

Case: You need to verify that SNMP-service is running on servers, and if not it must be installed. To do after running the script: You need to set “supported platforms” on the CI after creation. This CI and Baseline only…
Read more

ConfigMgr Compliance Scripts

Find path to configurationmanager.psd1

Damberg 5th March 2019 0 Comments

A module to find path to ConfigMgr module on client/server

function Get-CMModule {
    [CmdletBinding()]
    param()
    
    Try {
        Write-Verbose "Trying to import SCCM Module"
        Import-Module (Join-Path $(Split-Path $ENV:SMS_ADMIN_UI_PATH) ConfigurationManager.psd1) -Verbose:$false
        Write-Verbose "Nice...imported the SCCM Module"
        }
    Catch 
        {
        Throw "Failure to import SCCM Cmdlets."
        } 
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

function Get-CMModule {

[CmdletBinding()]

param()

Try {

Write-Verbose "Trying to import SCCM Module"

Import-Module (Join-Path $(Split-Path $ENV:SMS_ADMIN_UI_PATH) ConfigurationManager.psd1) -Verbose:$false

Write-Verbose "Nice...imported the SCCM Module"

}

Catch

{

Throw "Failure to import SCCM Cmdlets."

}

ConfigMgr Script

Set up maintanence for cache folder with CI and Baseline with powershell

Damberg 5th March 2019 0 Comments

There is the GUI-way and the Powershell-way… This scripts creates: A Configuration Item A Baseline A Baseline Deployment The only thing you need is admin-rights in the ConfigMgr, select schedule-inteval and count and what collection to deploy to. note: At…
Read more

ConfigMgr Compliance Scripts

Extract productcode from MSI

Damberg 4th March 2019 0 Comments

Here is a script you can use to extract productcode from msi-file it´s raw…

param(

  [Parameter(ValueFromPipeline = $true,HelpMessage = 'Enter CSV path')]
  [String[]]$Path = $null
)

if($Path -eq $null) 
{
  Add-Type -AssemblyName System.Windows.Forms

  $Dialog = New-Object -TypeName System.Windows.Forms.OpenFileDialog
  $Dialog.InitialDirectory = "$InitialDirectory"
  $Dialog.Title = 'Select MSI File'
  $Dialog.Filter = 'MSI File|*.MSI'        
  $Dialog.Multiselect = $true
  $Result = $Dialog.ShowDialog()

  if($Result -eq 'OK') 
  {
    Try 
    {
      $Path = $Dialog.FileNames
    }

    Catch 
    {
      $Path = $null
      Break
    }
  }

  else 
  {
    #Shows upon cancellation of Save Menu
    Write-Host -ForegroundColor Yellow -Object 'Notice: No file(s) selected.'
    Break
  }
}

$Path = $Dialog.FileName

$comObjWI = New-Object -ComObject WindowsInstaller.Installer
$MSIDatabase = $comObjWI.GetType().InvokeMember('OpenDatabase','InvokeMethod',$null,$comObjWI,@($Path, 0))
$Query = "SELECT Value FROM Property WHERE Property = 'ProductCode'"
$View = $MSIDatabase.GetType().InvokeMember('OpenView','InvokeMethod',$null,$MSIDatabase,($Query))
$View.GetType().InvokeMember('Execute', 'InvokeMethod', $null, $View, $null)
$Record = $View.GetType().InvokeMember('Fetch','InvokeMethod',$null,$View,$null)
$Value = $Record.GetType().InvokeMember('StringData','GetProperty',$null,$Record,1)

$Value

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

param(

[Parameter(ValueFromPipeline = $true,HelpMessage = 'Enter CSV path')]

[String[]]$Path = $null

)

if($Path -eq $null)

{

Add-Type -AssemblyName System.Windows.Forms

$Dialog = New-Object -TypeName System.Windows.Forms.OpenFileDialog

$Dialog.InitialDirectory = "$InitialDirectory"

$Dialog.Title = 'Select MSI File'

$Dialog.Filter = 'MSI File|*.MSI'

$Dialog.Multiselect = $true

$Result = $Dialog.ShowDialog()

if($Result -eq 'OK')

{

Try

{

$Path = $Dialog.FileNames

}

Catch

{

$Path = $null

Break

}

else

{

#Shows upon cancellation of Save Menu

Write-Host -ForegroundColor Yellow -Object 'Notice: No file(s) selected.'

Break

}

$Path = $Dialog.FileName

$comObjWI = New-Object -ComObject WindowsInstaller.Installer

$MSIDatabase = $comObjWI.GetType().InvokeMember('OpenDatabase','InvokeMethod',$null,$comObjWI,@($Path, 0))

$Query = "SELECT Value FROM Property WHERE Property = 'ProductCode'"

$View = $MSIDatabase.GetType().InvokeMember('OpenView','InvokeMethod',$null,$MSIDatabase,($Query))

$View.GetType().InvokeMember('Execute', 'InvokeMethod', $null, $View, $null)

$Record = $View.GetType().InvokeMember('Fetch','InvokeMethod',$null,$View,$null)

$Value = $Record.GetType().InvokeMember('StringData','GetProperty',$null,$Record,1)

$Value

Standalone Script

Latest Posts

Function Check-PackageWMIvsLIB

Primary user on device

Splash Screen for Driver and BIOS Update – OSDeploy | Sune Thomsen

Add multiple users to multiple AD-groups

Folders in ConfigMgr – Work in progress

Configure rights on WMI for monitoring

Create CI and Baseline for verifying SNMP-service installed and running

Find path to configurationmanager.psd1

Set up maintanence for cache folder with CI and Baseline with powershell

Extract productcode from MSI

Post navigation