Powershell Scripts

A collection of various powershell scripts I am using daily as a EUC Support Analyst. Most of them are related to SCCM / MEM & Application / Software Update deployments.

Config

Small config file named sccm-config.json contians common variables to be used within these scripts. E.g the SITE_SERVER_NAME & SITE_CODE. An example file is included.

Script Reference

Get-CollectionDeviceInfo.ps1

Params:

  • CollectionId
  • OutputFile

Given a device collection id, exports a csv file with Name, ADLastLogonTime, ADSiteName, CurrentLogonUser, LastActiveTime, LastClientCheckTime, LastDDR, LastLogonUser, PrimaryUser

Useful for getting a report of device online state from a particular colleciton.


Get-CollectionsWithDeployment.ps1

Params:

  • OutputFile

Returns a CSV with Collections that have at least one deployment

Useful for getting a report of collections that have a deployment tied to them.


Get-CollectionsWithoutDeployment.ps1

Params:

  • OutputFile

Returns a CSV with Collections that have no deployments.

Useful for getting a report of collections that can be cleaned up.


Get-CollectionsWithoutDeployment.ps1

Params:

  • OutputFile

Returns a CSV with Collections that have no deployments.

Useful for getting a report of collections that can be cleaned up.