Powershell, ConfigMgr, Windows Client, Windows server…
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
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
This function compare what the Distribution Point has in WMI againt ContentLib
|
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 .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 } |
If you want to remove WMI entry that not are in lib
|
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
|
1 2 |
##Delete .ini´s in PkgLib not in WMI Remove-Item -Path "$PkgLibPath\PackageID.INI" -Confirm |
To be used at own…
Read more
With this query you get a list of devices and topuser (primary user) on device
|
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 |
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…
|
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 |
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
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
A module to find path to ConfigMgr module on client/server
|
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." } } |
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
Here is a script you can use to extract productcode from msi-file it´s raw…
|
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 |