Device Collection - All Laptops

 Modified from https://www.prajwaldesai.com/sccm-create-collections-for-laptops/:


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 inner join SMS_G_System_SYSTEM_ENCLOSURE on SMS_G_System_SYSTEM_ENCLOSURE.ResourceID = SMS_R_System.ResourceId where
SMS_G_System_SYSTEM_ENCLOSURE.ChassisTypes in ('8','9','10','14','30','31','32')
view raw device collection - all laptops hosted with ❤ by GitHub

Comments

Post a Comment

Popular posts from this blog

Powershell Install-Module Error - Unable to Download from URI ... 0x409

This happened recently while trying to install a module. WARNING: Unable to download from URI 'https://go.microsoft.com/fwlink/?LinkID=627338&clcid=0x409' to ''. WARNING: Unable to download the list of available providers. Check your internet connection. PackageManagement\Get-PackageProvider : Unable to find package provider 'NuGet'. It may not be imported yet. Try 'Get-PackageProvider -ListAvailable'. At C:\Program Files\WindowsPowerShell\Modules\PowerShellGet\1.0.0.1\PSModule.psm1:7415 char:30 + ... tProvider = PackageManagement\Get-PackageProvider -Name $script:NuGet ... +                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~     + CategoryInfo          : ObjectNotFound: (Microsoft.Power...PackageProvider:GetPackageProvider) [Get-PackageProvider], Exception     + FullyQualifiedErrorId : UnknownProviderFromA...
Read more

Configuring App-only Authentication for Exchange Online for Powershell Scripts

Image
Azure AD - Create App Registration Login into Azure AD > App Registrations Click New Registration menu item, just add the name and click Register . (MAKE NOTE)     Copy and make note of the Application (client) ID Click API permissions menu item. You should see the Microsoft Graph API. Click on the 3 dots and Remove Permission Now click on Add a permission . Click APIs my organization uses , and search for Office 365 Exchange Online . Click Application permissions Look for Exchange , and tick Exchange.ManageAsApp . Finally, click Grant admin consent . You should see a green tick. Create Certificate Run Powershell to create a new self-signed certificate. It will create two certs, one .pfx and one .cer.  Azure AD - Upload Certificate Back in Azure AD, click Certificates & secrets menu item, and Upload certificate . You'll be uploading the .cer file. Azure AD - Assign Role Go back to the main Azure AD page, click Roles and administrators menu item. Search for an...
Read more