This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* Testing variables !! Need to be commented for Production !! */ | |
DECLARE @UserSIDs AS NVARCHAR(10) = 'Disabled'; | |
DECLARE @CollectionID AS NVARCHAR(10) = 'SMS00001' | |
DECLARE @OnInternet AS NVARCHAR(3) = '0' --You could make this into a multiselection in the report | |
SELECT | |
Device = ( | |
IIF( | |
SystemNames.Resource_Names0 IS NOT NULL, UPPER(SystemNames.Resource_Names0) | |
, IIF(Systems.Full_Domain_Name0 IS NOT NULL, ClientBaseline.Name + '.' + Systems.Full_Domain_Name0, ClientBaseline.Name) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
//.SYNOPSIS | |
// Summarizes Windows 10 versions. | |
//.DESCRIPTION | |
// Summarizes Windows 10 versions and renders a barchart with the results. | |
//.LINK | |
// https://SCCM.Zone/ | |
//.LINK | |
// https://SCCM.Zone/GIT | |
//.LINK | |
// https://SCCM.Zone/ISSUES |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<# | |
.SYNOPSIS | |
Starts a MEMCM task sequence. | |
.DESCRIPTION | |
Starts a MEMCM task sequence by triggering te schedule for that task sequence. | |
.PARAMETER TaskSequenceName | |
Specifies the task sequence name. | |
.EXAMPLE | |
Start-CMTaskSequence.ps1 -Name 'TS-App-Install' | |
.INPUTS |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<# | |
.SYNOPSIS | |
Starts a MEMCM task sequence. | |
.DESCRIPTION | |
Starts a MEMCM task sequence by triggering te schedule for that task sequence. | |
.PARAMETER TaskSequenceName | |
Specifies the task sequence name. | |
.EXAMPLE | |
Start-CMTaskSequence.ps1 -Name 'TS-App-Install' | |
.INPUTS |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<# | |
.SYNOPSIS | |
Runs a script in the MEMCM run script feature. | |
.DESCRIPTION | |
Runs a string input in the MEMCM run script feature by converting it to a script block and using Invoke-Command. | |
.PARAMETER | |
Script. | |
.EXAMPLE | |
Run-CMScript.ps1 -Script 'Get-BCStatus | Select-Object -Property BranchCacheIsEnabled, BranchCacheServiceStatus' | |
.INPUTS |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="utf-8"?> | |
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns:cl="http://schemas.microsoft.com/sqlserver/reporting/2010/01/componentdefinition" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition"> | |
<Description>Lists BIOS, hardware and operating system information by manufacturer and model.</Description> | |
<Author>Popovici Ioan @ SCCM-Zone.com</Author> | |
<AutoRefresh>0</AutoRefresh> | |
<DataSources> | |
<DataSource Name="DataSource"> | |
<DataSourceReference>/ConfigMgr_A01/{5C6358F2-4BB6-4a1b-A16E-8D96795D8602}</DataSourceReference> | |
<rd:SecurityType>None</rd:SecurityType> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
.SYNOPSIS | |
Summarizes the update scan states for a Collection in SCCM. | |
.DESCRIPTION | |
Summarizes the window update scan states in SCCM by Collection and Status Name. | |
.NOTES | |
Requires SQL 2012 R2. | |
Part of a report should not be run separately. | |
*/ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
.SYNOPSIS | |
Summarizes the unique required updates for a Collection in SCCM. | |
.DESCRIPTION | |
Summarizes the unique required updates in SCCM by Collection and Update Classification. | |
.NOTES | |
Requires SQL 2012 R2. | |
Part of a report should not be run separately. | |
*/ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
.SYNOPSIS | |
Gets the top 100 unpatched devices for a Collection in SCCM. | |
.DESCRIPTION | |
Gets the top 100 unpatched devices in SCCM by Collection and All Updates. | |
.NOTES | |
Requires SQL 2012 R2. | |
Part of a report should not be run separately. | |
*/ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
.SYNOPSIS | |
Summarizes the software update compliance for a Collection in SCCM. | |
.DESCRIPTION | |
Summarizes the software update compliance in SCCM by Collection and All Updates. | |
.NOTES | |
Requires SQL 2012 R2. | |
Part of a report should not be run separately. | |
*/ |
NewerOlder