Randy's Notes

Create a somewhat random collection using SMSUniqueIdentifier

Published by Randy on March 17, 2017 | Leave a response

This query will allow you to create a somewhat random collection based on the SMSUniqueIdentifier add more or less numbers depending on your target deployment size

select SMS_R_SYSTEM
.ResourceID
,SMS_R_SYSTEM.ResourceType
,SMS_R_SYSTEM.Name
,SMS_R_SYSTEM.SMSUniqueIdentifier
,SMS_R_SYSTEM.ResourceDomainORWorkgroup
,SMS_R_SYSTEM.Client 
from SMS_R_System where SMS_R_System.SMSUniqueIdentifier like "%[012]"
--from SMS_R_System where SMS_R_System.SMSUniqueIdentifier like "%[0123456789ABCDEF]"

select SMS_R_SYSTEM

.ResourceID

,SMS_R_SYSTEM.ResourceType

,SMS_R_SYSTEM.Name

,SMS_R_SYSTEM.SMSUniqueIdentifier

,SMS_R_SYSTEM.ResourceDomainORWorkgroup

,SMS_R_SYSTEM.Client

from SMS_R_System where SMS_R_System.SMSUniqueIdentifier like "%[012]"

--from SMS_R_System where SMS_R_System.SMSUniqueIdentifier like "%[0123456789ABCDEF]"

Posted in Uncategorized

SCCM Client Install – Could not access network location %APPDATA%

Published by Randy on February 23, 2017 | Leave a response

Today I was troubleshooting an SCCM Client install issue. checking the CCMSetup.log file the setup was returning “Could not access network location %APPDATA%” To resolve this issue I updated the appdata location under the following registry key

HKEY_USERS\S-1-5-18\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders

1	HKEY_USERS\S-1-5-18\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders

the location was set to “%APPDATA%” instead of “%USERPROFILE%\AppData\Roaming” after updating this location I was able to successfully […]

Posted in Uncategorized

SCCM SQL query to list deployments with User Notifications set to show all

Published by Randy on February 20, 2017 | Leave a response

Today I needed get a list of deployments that had the user notification set to “Display in Software Center and show all notifications” so I could update the deployments so users would not get the “New Software is Available” toast on available deployments. I was able to use this query to determine this.

SELECT [AssignmentName]
      ,[CollectionName]
      ,[NotifyUser]
      ,[EnforcementDeadline]
  FROM [vSMS_AssignmentBase]
  WHERE (NotifyUser='1' AND EnforcementDeadline Is Null)

SELECT [AssignmentName]

,[CollectionName]

,[NotifyUser]

,[EnforcementDeadline]

FROM [vSMS_AssignmentBase]

WHERE (NotifyUser='1' AND EnforcementDeadline Is Null)

[…]

Posted in Microsoft System Center Configuration Manager, SQL Query

Purge Transactional dead-letter queue messages using PowerShell

Published by Randy on February 16, 2017 | Leave a response

Here is a snippet I used to purge messages from the System Transactional dead-letter queue using PowerShell.

[Reflection.Assembly]::LoadWithPartialName("System.Messaging")
$msmq = [System.Messaging.MessageQueue] 
$queuetd = New-Object $msmq("FormatName:Direct=os:.\System$;DEADXACT");
$queuetd.Purge()

[Reflection.Assembly]::LoadWithPartialName("System.Messaging")

$msmq = [System.Messaging.MessageQueue]

$queuetd = New-Object $msmq("FormatName:Direct=os:.\System$;DEADXACT");

$queuetd.Purge()

Posted in Powershell

Purge MSMQ Private Queue using PowerShell

Published by Randy on February 16, 2017 | Leave a response

I needed to be able to purge all Private Queues using PowerShell. I also needed to have this work on Powershell 3.0. here is the snippet I used to complete this task.

        [Reflection.Assembly]::LoadWithPartialName("System.Messaging") | Out-Null 
        $queues = [System.Messaging.MessageQueue]::GetPrivateQueuesByMachine(".")| % { $_.QueueName }
        foreach ($q in $queues)
        {
            $queuename = ".\" + $q
            [Reflection.Assembly]::LoadWithPartialName("System.Messaging") | Out-Null 
            $queue = New-Object -TypeName "System.Messaging.MessageQueue"
            $queue.Path = $queuename
            $queue.Purge()
        }

[Reflection.Assembly]::LoadWithPartialName("System.Messaging") | Out-Null

$queues = [System.Messaging.MessageQueue]::GetPrivateQueuesByMachine(".")| % { $_.QueueName }

foreach ($q in $queues)

{

$queuename = ".\" + $q

[Reflection.Assembly]::LoadWithPartialName("System.Messaging") | Out-Null

$queue = New-Object -TypeName "System.Messaging.MessageQueue"

$queue.Path = $queuename

$queue.Purge()

}

with Powershell 4.0 you can use Get-MsmQueue

        $queues = Get-MsmqQueue –QueueType Private | select QueueName
        foreach ($q in $queues)
        {
            $queuename = ".\" + $q.QueueName
            [Reflection.Assembly]::LoadWithPartialName("System.Messaging") | Out-Null 
            $queue = New-Object -TypeName "System.Messaging.MessageQueue"
            $queue.Path = $queuename
            $queue.Purge()
        }

$queues = Get-MsmqQueue –QueueType Private | select QueueName

foreach ($q in $queues)

{

$queuename = ".\" + $q.QueueName

[Reflection.Assembly]::LoadWithPartialName("System.Messaging") | Out-Null

$queue = New-Object -TypeName "System.Messaging.MessageQueue"

$queue.Path = $queuename

$queue.Purge()

}

Posted in Powershell

C# Install SCCM Package on Client

Published by Randy on August 28, 2015 | Leave a response

I needed to be able to kick of an installation of a SCCM Package on a client from a C# windows form. I discovered the SDKClient WMI Namespace and am using the following code.

//Populate Listview with Packages    
            try
            {
            ManagementObjectSearcher searcher = new ManagementObjectSearcher(wmipath, select);
                ManagementObjectCollection instances = searcher.Get();
                foreach (ManagementObject queryObj in instances)
                {

                    if (queryObj["FullName"].ToString().StartsWith("Package"))
                    {
                        ListViewItem lvi = new ListViewItem();
                        lvi.Name = queryObj["FullName"].ToString();
                        lvi.Text = queryObj["Description"].ToString();
                        lvi.Tag = queryObj["ProgramID"].ToString() + "^" + queryObj["PackageID"].ToString();
                        lvi.ToolTipText = queryObj["Description"].ToString();

                        this.ListView1.Items.Add(lvi);
                    }
                }
            }

            catch
            {

            }


       private void btnRun_Click(object sender, EventArgs e)
        {
            try
            {
                // Split ProgramID and PackageID out form string
                string[] progInfo = listTopSolutions.SelectedItems[0].Tag.ToString().Split('^');
                programID = progInfo[0];
                packageID = progInfo[1];

                // Get the object on which the method will be invoked
                ManagementClass processClass = new ManagementClass(@"root\ccm\clientsdk", "CCM_ProgramsManager", null);

                // Get an input parameters object for this method
                ManagementBaseObject inParams = processClass.GetMethodParameters("ExecuteProgram");

                // Fill in input parameter values
                inParams["ProgramID"] = programID;
                inParams["PackageID"] = packageID;
                
                // Execute the method
                ManagementBaseObject outParams = processClass.InvokeMethod("ExecuteProgram", inParams, null);
            }
            catch
            {

            }

//Populate Listview with Packages

try

{

ManagementObjectSearcher searcher = new ManagementObjectSearcher(wmipath, select);

ManagementObjectCollection instances = searcher.Get();

foreach (ManagementObject queryObj in instances)

{

if (queryObj["FullName"].ToString().StartsWith("Package"))

{

ListViewItem lvi = new ListViewItem();

lvi.Name = queryObj["FullName"].ToString();

lvi.Text = queryObj["Description"].ToString();

lvi.Tag = queryObj["ProgramID"].ToString() + "^" + queryObj["PackageID"].ToString();

lvi.ToolTipText = queryObj["Description"].ToString();

this.ListView1.Items.Add(lvi);

}

catch

{

}

private void btnRun_Click(object sender, EventArgs e)

{

try

{

// Split ProgramID and PackageID out form string

string[] progInfo = listTopSolutions.SelectedItems[0].Tag.ToString().Split('^');

programID = progInfo[0];

packageID = progInfo[1];

// Get the object on which the method will be invoked

ManagementClass processClass = new ManagementClass(@"root\ccm\clientsdk", "CCM_ProgramsManager", null);

// Get an input parameters object for this method

ManagementBaseObject inParams = processClass.GetMethodParameters("ExecuteProgram");

// Fill in input parameter values

inParams["ProgramID"] = programID;

inParams["PackageID"] = packageID;

// Execute the method

ManagementBaseObject outParams = processClass.InvokeMethod("ExecuteProgram", inParams, null);

}

catch

{

}

Posted in C#, Microsoft System Center Configuration Manager

Deploying Office 365 using System Center Configuration Manager

Published by Randy on May 5, 2015 | Leave a response

This article walks you through preparing and deploying Office 365. Download and install the Office Deployment tools from here. https://www.microsoft.com/en-us/download/details.aspx?id=36778With O365 configurations are done using the Office Deployment Tool for Click to Run and .xml files verses the Customization Toolkit and .msp files that are used in the volume license .msi version Browse to the folder that […]

Posted in Microsoft Office, Microsoft System Center Configuration Manager

Creating SCCM User and Device Collections based on Active Directory Groups

Published by Randy on May 9, 2014 | 3 Responses

Create a User Collection and a Device Collection that pulls its members from an active directory group 1. Make sure you have Discovery set up on your Active Directory or Specific OU containing groups. You can do this by clicking Administration > Discover Methods then right click on “Active Directory Group Discovery” and choose Properties. […]

Posted in Microsoft System Center Configuration Manager

C# convert WMI DateTime to standard DateTime

Published by Randy on March 26, 2014 | Leave a response

WMI Dates and times are in DMTF datetime format. The following is the command to convert a given DMTF datetime to DateTime.

DateTime Date = ManagementDateTimeConverter.ToDateTime(WMIDate);

1	DateTime Date = ManagementDateTimeConverter.ToDateTime(WMIDate);

Microsoft Documentation

Posted in C#

Configuration Manager 2012 how to add users in an AD group to a user collection

Published by Randy on March 25, 2014 | Leave a response

In SCCM the below query string can be used to populate a user collection based on AD group.

select *  from  SMS_R_User where SMS_R_User.SecurityGroupName = "DOMAIN\\User_Group”

1	select * from SMS_R_User where SMS_R_User.SecurityGroupName = "DOMAIN\\User_Group”

Posted in Microsoft System Center Configuration Manager

Application Deployment, Client Health, and task automation

Create a somewhat random collection using SMSUniqueIdentifier

Like this:

SCCM Client Install – Could not access network location %APPDATA%

Like this:

SCCM SQL query to list deployments with User Notifications set to show all

Like this:

Purge Transactional dead-letter queue messages using PowerShell

Like this:

Purge MSMQ Private Queue using PowerShell

Like this:

C# Install SCCM Package on Client

Like this:

Deploying Office 365 using System Center Configuration Manager

Like this:

Creating SCCM User and Device Collections based on Active Directory Groups

Like this:

C# convert WMI DateTime to standard DateTime

Like this:

Configuration Manager 2012 how to add users in an AD group to a user collection

Like this:

Search

Categories

Blogroll

Archives

Subscribe

Application Deployment, Client Health, and task automation

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Search

Categories

Blogroll

Archives

Subscribe