Skip to content
Top Menu
11th April 2021
  • About Us
  • Daily Giveaway
  • Links
  • Free Subscription
  • Privacy Policy
  • Site Map
  • Donate to Us
  • how2genius
  • Contact
  • Facebook
  • Twitter
  • Instagram
  • Pinterest
  • YouTube
  • Medium

TechyGeeksHome

Making IT Happen

  • Home
    • About Us
    • Authors
    • Donate
    • Links
    • Privacy Policy
    • Site Map
  • Freeware
    • Apple
    • Autodesk
    • Cisco
    • DustyPad
    • GitHub
    • Giveaways
      • Archives
      • Daily Giveaway
      • eBooks
    • Microsoft
      • Exchange ToolKit Panel
      • Language Packs
    • MSI Archive
    • MSI Packs
      • Adobe MSI Packs
      • FileZilla Client MSI Packs
      • FoxIt MSI Packs
      • Java MSI Installers
      • Notepad++ MSI Installers
      • PuTTy MSI Packs
      • Skype MSI Installers
      • VLC Player MSI Packs
    • Password Generator
    • Shoretel
    • Ultimate Settings Panel
    • WordPress
  • Microsites
    • Cisco VPN Client Fix
      • Cisco VPN Client Fix – Instructions
    • MD5 Hash Encryption Tool
    • Shoretel Account Viewer
    • Ultimate Settings Panel
      • Instructions
      • Videos
      • Screenshots
    • Windows 7 Lock Screen Changer
  • Guides
    • Adobe
    • Autodesk
    • Blogging
      • Google Blogger
      • WordPress
    • Cisco
    • Gaming
    • General Tech
    • Microsoft
      • Active Directory
      • Exchange
      • Group Policy
      • Microsoft Product Keys
      • Power BI
      • Powershell
      • OneDrive
      • Servers
      • Skype
      • SQL
        • Queries
      • Visual Studio
      • WDS
      • Windows
      • WSUS
    • Misc
      • Amazon
      • Apple
      • Chrome
      • Firefox
      • FoxIt
      • Java
      • Linux
      • Notepad++
      • Photoshop
      • Printers
      • PuTTy
      • Raspberry Pi
      • SharePoint
      • Sky
      • VoIP
        • Skype
        • Shoretel
    • Social Media
      • Facebook
      • Instagram
      • Twitter
    • System Center
      • SCCM
      • SCOM
      • SCORCH
      • SCSM
      • OSD
    • Virtualisation
      • VMWare
    • YouTube
      • Video Guides
  • News
    • Cars
  • Reviews
  • YouTube
  • FAQ
  • Contact
    • Free Subscription
    • Social Media

Query

System Center Configuration Manager SCCM
SCCM / Microsoft / Query

SCCM Collection Query for Virtual Machines

20th July 202020th July 2020 - by A.J. Armstrong - Leave a Comment

Just a quick post to add to our list of SCCM collection queries. We needed one today for a collection of virtual machines only. This query you can use to …

Read More
sccm logo 600x400
Guide / Microsoft / Query / SCCM / Servers / Windows

SCCM Query for Microsoft Server 2019

2nd December 201910th November 2019 - by A.J. Armstrong - 3 Comments.

I’ve not done a post about SCCM queries for a while now so in addition to a load I did some time ago, I thought I’d bring things up to …

Read More
sql2016
Guide / Microsoft / Query / SQL

SQL Query to find members of an Active Directory Security Group

26th November 20184th October 2020 - by A.J. Armstrong - 1 Comment

We recently helped out with a data migration which included creating a completely new set of Active Directory security groups. They wanted all the members to have the same level …

Read More
microsoft black logo
Guide / Microsoft / Query / SCCM / SQL

SCCM – Active Directory Security Group Query for User Collection

23rd March 201811th June 2020 - by A.J. Armstrong - Leave a Comment

If you are looking at setting up a SCCM user collection based on membership of an Active Directory Security Group, then you can use this WQL query for the collection. …

Read More
System Center Configuration Manager SCCM
Guide / Query / SCCM / SQL

SCCM – SQL Queries for Make, Model and Architectures of Devices

19th March 20189th July 2018 - by A.J. Armstrong - Leave a Comment

These simple SQL queries can be used to pull data from the Configuration Manager database to provide you with a count of all make, model and architecture devices in your …

Read More
microsoft black logo
Guide / Microsoft / Query / SCCM / SQL

SCCM – Create a device collection based on Domain Controller role

24th January 201820th April 2019 - by A.J. Armstrong - 2 Comments.

We have another WQL query here for you today to enable you to create a Configuration Manager collection based on whether a device is used as a domain controller. Go …

Read More
sql2016
Guide / Microsoft / Query / SCCM / SQL

SCCM – Hardware and Client Version SQL Query

17th January 20189th July 2018 - by A.J. Armstrong - Leave a Comment

If you are looking for a SQL query to pull back hardware inventory information and the SCCM client version, then you can use the below to pull all this information …

Read More
sccm logo 600x400
Guide / Microsoft / Query / SCCM / SQL

SCCM SQL Query for Software not in Add Remove Programs

9th January 201810th May 2020 - by A.J. Armstrong - Leave a Comment

If you are looking for an SCCM SQL query to create a report to search for machines which do not have a particular software installed, you can use the following: …

Read More
System Center Configuration Manager SCCM
Guide / Microsoft / Query / SCCM / SQL

SCCM – SQL Query for all Laptops

1st November 20171st September 2019 - by A.J. Armstrong - Leave a Comment

If you are using Configuration Manager, you will be aware that you can create a number of custom reports using the SCCM SQL data and SSRS to produce the reports. …

Read More
ssc 0
Guide / Query / SCCM

SCCM WQL Query – All Windows 10 Installs

15th September 201615th May 2018 - by A.J. Armstrong - Leave a Comment

If you are using Configuration Manager and you want to create a collection based on all Windows 10 installations, you can use this WQL query below: select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, …

Read More
sql
Guide / Microsoft / Query / SCCM / SQL

SCCM SQL Query – Count Computers by Model

14th September 20163rd June 2020 - by A.J. Armstrong - 2 Comments.

If you are using Configuration Manager and want to run an SQL query on your database to count the number of different models you have in your organisation, you can use …

Read More
ssc 0
SCCM / Guide / Query

SCCM WQL Query – No ConfigMgr Client Installed

12th September 20169th December 2020 - by A.J. Armstrong - 3 Comments.

If you are using Configuration Manager and you want to create a collection of all devices that do not have the Configuration Manager Client installed, then you can use this …

Read More
sccm logo
SCCM / Guide / Query

SCCM WQL Query – Clients without latest version installed

7th September 201624th March 2018 - by A.J. Armstrong - Leave a Comment

If you want to create a collection in Configuration Manager to show you all the devices that are not up to a specified version, then you can use the WQL …

Read More
ssc 0
Guide / Query / SCCM / SQL

SCCM WQL Query – All Inactive Clients

6th September 201615th July 2018 - by A.J. Armstrong - Leave a Comment

If you want to create a Configuration Manager Collection with all inactive devices in it, you can use the following WQL query. You can also change the last “0” to …

Read More
sccm logo
Query / Guide / SCCM / SQL

SCCM – 52 Operational Collections

16th March 201616th June 2018 - by A.J. Armstrong - Leave a Comment

There is an excellent Powershell download available giving you 52 operational collections within SCCM. You should go over to the link below and take a look: 52 SCCM Powershell Collections …

Read More
sccm logo
Query / Guide / Microsoft / SCCM / SQL

SCCM Collection Query – Virtual Machines

16th February 201620th April 2019 - by A.J. Armstrong - 2 Comments.

If you are looking for a SCCM collection query for virtual machines in your environment, then you can use this query below: Feedback is critical to our site so please, …

Read More
sccm logo 600x400
Guide / Microsoft / Query / SCCM / SQL

SCCM – Report on Outlook Archive PST files on Devices

25th August 20147th April 2018 - by A.J. Armstrong - Leave a Comment

If you want to report on machines that have Outlook archive (PST’s) on them, where they are and how big they are, then you can use this guide to create …

Read More
sql2016
Guide / Microsoft / Query / SCCM / SQL

SCCM – WQL Query for Devices with Configuration Manager Client Installed and no System Center Endpoint Protection Installed

23rd August 20144th June 2018 - by A.J. Armstrong - Leave a Comment

We have had a report that one of our WQL queries has not been working correctly, this is the one for devices that have Configuration Manager client installed but do …

Read More

Posts navigation

1 2 … 4 Next
Ezoic Invitation

Trending Posts

Betway

Categories

Top Downloads

Ultimate Settings Panel
Ultimate Settings Panel
Downloads: 35813
Size: 0.00 KB
Version: 6.6
Updated: 24th November 2020
Windows Easy Transfer for Windows 10
Windows Easy Transfer for Windows 10
Downloads: 26887
Size: 0.00 KB
Version: 1.0
Updated: 24th November 2020
Cisco VPN Client Fix for Windows 10 Package
Cisco VPN Client Fix for Windows 10 Package
Downloads: 10950
Size: 0.00 KB
Version: 3.6
Updated: 11th July 2020
Autodesk Serial Number Collection MOF v2017
Autodesk Serial Number Collection MOF v2017
Downloads: 10044
Size: 0.00 KB
Version: 2017
Updated: 11th July 2020
Cisco Client VPN Fix Package Pro
Cisco Client VPN Fix Package Pro
Downloads: 9236
Size: 0.00 KB
Version: 3.6
Updated: 11th July 2020
CCMClean
CCMClean
Downloads: 9091
Size: 0.00 KB
Version: 2.5
Updated: 11th July 2020
Adobe Flash Player MSI Package v24.0.0.186
Adobe Flash Player MSI Package v24.0.0.186
Downloads: 8421
Size: 0.00 KB
Version: 24.0.0.186
Updated: 11th July 2020

Random Posts

  • pi Install Node.JS on Raspberry Pi
  • Java Client 7 Update 67 MSI Installers Released
  • vistaupdate stage3of3 Windows Stuck on Configuring Updates 3 of 3 0% Completed Fix
  • Adobe Logo Adobe Reader DC version 19.0122.0040 MSP Download and Installation Command Lines
  • system center SQL Reporting Services Error – Maximum request length exceeded

Archives

Subscribe via Email

Join 530 other subscribers.

Tag Cloud

Adobe Apple Autodesk Blogger CD Keys Chrome Cisco Exchange FileZilla Firefox Flash Gaming General General Tech Google Group Policy Guide Java Microsoft MSI News OSD Powershell Product Keys Program Query Review SCCM security Serial Keys Servers Shoretel Skype Social Media SQL TechyGeeksHome Updates USP Video Guides VoIP WDS Windows Wordpress WSUS YouTube

Recent Comments

  • Alison Santos on VMWare ESXi 5.5 – Adding RealTek and Atheros Network Card Drivers – Version 2.0
  • Anonymous on VMWare ESX Serial Number Activation
  • Christian Langeland on Adobe Flash Player 18.0.0.232 Released – MSI Download
  • Anonymous on Enable Windows Task Scheduler History
  • Anonymous on Windows Easy Transfer for Windows 10

Meta

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Blog Stats

  • 5,885,757 hits
Ezoic Invitation

Social Media

  • Facebook
  • Twitter
  • Instagram
  • Pinterest
  • YouTube
  • Medium

Subscribe via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 530 other subscribers.

Meta

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
(c) TechyGeeksHome 2021
  • Home
  • Freeware
  • Microsites
  • Guides
  • News
  • Reviews
  • YouTube
  • FAQ
  • Contact