Powershell – Damberg Online

Automation of Conference booking in Cisco TMS with Powershell

Damberg 27th August 2021 0 Comments

The plot for the assignment 🙂 We got a question if we could automate the booking of Cisco TMS Video Conference for a customer that before this script managed about 2000 booking a month by clicking i Cisco TMS portal….
Read more

Powershell, Standalone Script

Presentation on remote screen

Damberg 22nd June 2021 0 Comments

Remote-presention with schedule task and Powershell For this solution you need the following: AD-user (not domainadmin!!!) with lowest rights. AD-group populated by the user (above) who will access the folder and run the scheduletask. The group is also populated with…
Read more

Powershell

Remote Schedule Task Manager 1.0

Damberg 19th May 2021 0 Comments

I have a customer who needed some sort of application/bat-file or powershell-script to restart a remote computer running a presentation. The presentation was updated with a schedule task on the client, but sometimes they needed to update extra. Instead of…
Read more

Application, Powershell

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

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, Powershell

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

Powershell, 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, Powershell

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