Ioan-Popovici

/* 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)

Ioan-Popovici

//.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

Ioan-Popovici

<#
.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

Ioan-Popovici

<#
.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

Ioan-Popovici

<#
.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

Ioan-Popovici

<?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>

Ioan-Popovici

/*
.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.
*/

Ioan-Popovici

/*
.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.
*/

Ioan-Popovici

/*
.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.
*/

Ioan-Popovici

/*
.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.
*/