Kaido Järvemets Kaidja

## ObjectsInFolderSCCM2
$ObjectPath = "/Dell/Sub1"
$ApplicationsInFolder = Get-WmiObject -Namespace "ROOT\SMS\Site_PS1" `
    -Query "select * from SMS_ApplicationLatest where ObjectPath = '$ObjectPath'"

$ApplicationsInFolder

## ConvertTo-CMIResultObject
$SCCMCMPSHObject = ConvertTo-CMIResultObject -InputObject $ApplicationsInFolder
Set-CMApplication -InputObject $SCCMCMPSHObject -NewName "IT - Dell Command Monitor 2"

## ModifySCCMObject
Set-CMApplication -InputObject $ApplicationsInFolder -NewName "IT - Dell Command Monitor 2"

## ObjectsInFolderSCCM
$FolderID = 16777224 # ContainerNodeID property value
$SiteCode = "PS1"
$Query = "select * from SMS_ApplicationLatest where ModelName is
in(select InstanceKey from SMS_ObjectContainerItem where ObjectType='6000' and ContainerNodeID='$FolderID')"

$ApplicationsInFolder = Get-WmiObject -Namespace "ROOT\SMS\Site_$SiteCode" -Query $Query
$ApplicationsInFolder

## SCCMContainerNodeID
Get-ChildItem PS1:\Application | Select-Object -Property Name,ContainerNodeID,ObjectType

## Import Maintenance Windows before import
Import-CMMaintenanceWindows.ps1 -MWsInputFile E:\Scripts\MW\Maintenance_Solution.csv -Delimiter ',' -Production

## Preview Maintenance Windows before import
Import-CMMaintenanceWindows.ps1 -MWsInputFile E:\Scripts\MW\Maintenance_Solution.csv -Delimiter ',' -Preview

## Getting data from ConfigMgr - Invoke-CMQuery
Import-Module $env:SMS_ADMIN_UI_PATH.Replace("\bin\i386","\bin\configurationmanager.psd1")
$CMSite = Get-PSProvider -PSProvider CMSITE
Set-Location -Path "$($CMSite.Drives.Name):\"

Invoke-CMQuery -Name 'All Non-Client Systems'

## Check if device exists in Configuration Manager
#Check if device exists in Configuration Manager
Import-Module $env:SMS_ADMIN_UI_PATH.Replace("\bin\i386","\bin\configurationmanager.psd1")
$CMSite = Get-PSProvider -PSProvider CMSITE
Set-Location -Path "$($CMSite.Drives.Name):\"

#Query against Configuration Manager
$ADComputerInfo = Get-ADComputer -Identity PC1
Get-CMDevice -Name $ADComputerInfo.Name

## AD computer LastLogonDate
#AD Computer account last logon date
Get-ADComputer -Identity KLASSB315-2 -Properties LastLogonDate

#AD Computer account last logon date in days
$ADComputerInfo = Get-ADComputer -Identity PC1 -Properties LastLogonDate
$TimeSpan = New-TimeSpan -Start $ADComputerInfo.LastLogonDate -End (Get-Date)
$TimeSpan.Days
	$ObjectPath = "/Dell/Sub1"
	$ApplicationsInFolder = Get-WmiObject -Namespace "ROOT\SMS\Site_PS1" `
	-Query "select * from SMS_ApplicationLatest where ObjectPath = '$ObjectPath'"

	$ApplicationsInFolder
	$SCCMCMPSHObject = ConvertTo-CMIResultObject -InputObject $ApplicationsInFolder
	Set-CMApplication -InputObject $SCCMCMPSHObject -NewName "IT - Dell Command Monitor 2"
	$FolderID = 16777224 # ContainerNodeID property value
	$SiteCode = "PS1"
	$Query = "select * from SMS_ApplicationLatest where ModelName is
	in(select InstanceKey from SMS_ObjectContainerItem where ObjectType='6000' and ContainerNodeID='$FolderID')"

	$ApplicationsInFolder = Get-WmiObject -Namespace "ROOT\SMS\Site_$SiteCode" -Query $Query
	$ApplicationsInFolder
	Import-Module $env:SMS_ADMIN_UI_PATH.Replace("\bin\i386","\bin\configurationmanager.psd1")
	$CMSite = Get-PSProvider -PSProvider CMSITE
	Set-Location -Path "$($CMSite.Drives.Name):\"

	Invoke-CMQuery -Name 'All Non-Client Systems'
	#Check if device exists in Configuration Manager
	Import-Module $env:SMS_ADMIN_UI_PATH.Replace("\bin\i386","\bin\configurationmanager.psd1")
	$CMSite = Get-PSProvider -PSProvider CMSITE
	Set-Location -Path "$($CMSite.Drives.Name):\"

	#Query against Configuration Manager
	$ADComputerInfo = Get-ADComputer -Identity PC1
	Get-CMDevice -Name $ADComputerInfo.Name
	#AD Computer account last logon date
	Get-ADComputer -Identity KLASSB315-2 -Properties LastLogonDate

	#AD Computer account last logon date in days
	$ADComputerInfo = Get-ADComputer -Identity PC1 -Properties LastLogonDate
	$TimeSpan = New-TimeSpan -Start $ADComputerInfo.LastLogonDate -End (Get-Date)
	$TimeSpan.Days