Set up a lab for evaluating Configuration Manager with simulated real-life activities.
Find Installed Software using SCCM CMPivot. In the CMPivot tool, select the Query tab. If you run the InstalledSoftware query, it lists all the softwares installed on every computer in the …
How to configure Microsoft Configuration Manager to deploy software updates to Windows 10 Enterprise multi-session on Azure Virtual Desktop.
SQL Query. You should run the following SQL query against the SMS/SCCM database to spit out an entire list of machines on your network with their Chassis Type and Manufacturer. You need to know exactly what you have got in the field. SELECT v_GS_SYSTEM_ENCLOSURE.ChassisTypes0, v_R_System.Name0, …
Azure ad dynamic queries for Intune / MEM administrators. managing devices and users in your or customer enviroment but it's not always that easy to get the queries right and also find out what to query at times (speaking from my own experience). With that I wanted to create an overview of queries I often use when working with …
When creating SCCM task sequences to deploy desktops, seperate tasks are often used to apply different device drivers based on the hardware the desktop is being deployed to. For this to work we first need to find the model of the computer we want to apply the drivers to. Then we require a WMI query based on that computer model, which is applied as a …
In SCVMM, Virtual Machine Manager is a component of the parent System Center. SCVMM can be likened to the vCenter Server of Hyper-V. It unlocks many different management features that can be …
SCCM Create Collections for Laptops In Configuration Manager a query is a specific set of instructions that extract information about a defined set of objects. You can create queries and store them in the Configuration Manager 2012 site database.
I'm trying to determine if the cluster name is stored in SCCM audit data. I see the host name in [v_R_System], and I'm able to identify cluster nodes here. What I need is the virtual name for the c...
Your ultimate resource for the CrowdStrike Falcon® platform: In-depth videos, tutorials, and training.
If you are using SQL Server 2008 R2 RTM or older then there is a CMD Command " SYSTEMINFO " which has information about System model.
Learn how to use CMPivot in Configuration Manager to query clients in real time.
In this article I will show you how to create a task sequence in SCCM which can be used to deploy any operating system version you wish.
Custom Query Report: Get all MSIX/APPX apps. To get all the MSIX/APPX apps with the WMI class: 1. Navigate to Monitoring > Queries. 2. Right-click Queries and select Create Query. 3. In the new window, write a Name for the query. You can limit the query to a specific collection as we did for the default report.
SCCM Query to create collection for x86 and x64 machines In this post you will find the SCCM Query to create collection for x86 and x64 machines. Device collections in System Center 2012 Configuration Manager represent a logical container for a grouping of devices.
In Configuration Manager, your application uses the SMS_Collection Server WMI Class to define the attributes of a collection, such as the membership rules and the refresh schedule.
When you have multiple computer models in your organization, you have different driver packages available. Each model has his own driver package. You don't want to use a task sequence per model, but only one task sequence with multiple models in it with different driver packages. This can be accomplished by using a WMI query within …
How do I create an SCCM collection to show all machine with a name that starts with some particular characters
The following query lists the resources in the Configuration Manager hierarchy that are in a collection, the assigned site for client computers, the collection ID, collection name, and the last time the collection was refreshed. The v_FullCollectionMembership view is joined to the v_Collection view by using the …
Microsoft's new attribute explained in the below sections helped system admins to get the Window 11 Upgrade Compatible Matrix report and collection without writing complex WQL and SQL queries. SCCM Windows 11 Upgrade Readiness Report Using SQL Query helps to create a custom report for Windows 11 upgrade readiness …
Does anyone have an SCCM Query to find where a VM is hosted, OR all Virtual hosts?
Using WQL queries, you can create Windows 11 SCCM device collection, such as collections for Windows 11 21H1, 22H2. Let's look at the Windows 11 SCCM device collection creation process.
The following sample queries demonstrate how the Configuration Manager software inventory views can be joined to other views to retrieve specific data. The software inventory views are typically joined to other views by using …
In this article, we will show you how to centrally manage and patch your virtual machines using the new Azure Update Manager solution in and out of Azure!
The WQL query can be used to group the Windows Server versions, including 2025, 2022, 2019, and 2016. Windows servers can be managed using Configuration Manager current branch. The only prerequisite is that the SCCM client must be installed on Windows Server before you can begin managing it. Please refer to the …
In this article, I will show you how to find serial number of computer using different methods such as CMPivot query, SCCM Resource Explorer, WMI, and BIOS.
SCCM CMPivot has been introduced in SCCM 1806 and it's a pretty useful addition. This post lists 55 SCCM CMPivot Query Examples.
So is power management supported on virtual machines ?. – Configuration Manager power management is not supported on virtual machines. Therefore you cannot apply power plans to virtual machines, nor can you report power data from them.
This configuration manager report is considered one of the top reports as it helps remove duplicate records, and filter orphan records based on last time seen online. Provided also the SQL query powering this report, along with some tips to help you add more information.
How-To Guide. Enable SCVMM inventory resources in Azure. Set up and manage self-service access to SCVMM resources. Install Arc agent at scale for your SCVMM VMs. Install Arc agent using a script for SCVMM VMs.
SCCM device collection based on Device Manufacturer. The below collection query can be used to create a dynamic collection for all computer hardware based on device manufacturer such as HP, Dell, Lenovo etc. If you are using query designer then select the below attribute class and attribute name. Otherwise you can also copy the …
Azure Update Manager provides a SaaS solution to manage and govern software updates to Windows and Linux machines across Azure, on-premises, and multicloud environments. Following are the benefits of using Azure Update Manager: Oversee update compliance for your entire fleet of machines in Azure (Azure VMs), on …
The Get-SCVirtualMachine cmdlet gets one or more virtual machine objects from the Virtual Machine Manager (VMM) database. This cmdlet gets virtual machines that are deployed on a virtual machine host or stored in the VMM library.
In this article, I will cover the steps to create SCCM Windows Server 2022 device collection. Windows Server 2022 is out, and you can create a device collection in SCCM to group all servers.
A blog describing how to understand and write up SQL queries, then use them in SSRS to create beautiful reports!!!
In this post I will cover the steps to deploy VMware workstation using SCCM or Configuration Manager. VMware Workstation Pro lets you run multiple operating systems as Virtual Machine on a single windows or Linux PC.
This article describes how to connect Windows computers hosted in other clouds or on-premises to Azure Monitor with the Log Analytics agent for Windows.
Step 2: Create the Software Distribution Package. Place the software that you want to deploy (the exe, msi, etc…) into a shared folder on the SCCM server that can be accessed by everyone. Select Software Distribution. Right Click …
