Skip to content
Top Menu
13th 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

sccm logo
Guide / Microsoft / Query / SCCM / SQL

Configuration Manager Report Query for Servers not rebooted in the last week

3rd July 201415th April 2020 - by A.J. Armstrong - Leave a Comment

If you want to report on the servers that have not had a reboot in the last week within your Configuration Manager environment then you can run this query directly …

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

SCCM Report Query for Machines without Client Installed

2nd July 201415th April 2020 - by A.J. Armstrong - Leave a Comment

If you want to report on the machines that do not have the ConfigMgr client installed within your Configuration Manager environment then you can run this query directly on your …

Read More
sql2016
Guide / Query / SCCM / SQL

Configuration Manager Report Query for Client Version

1st July 20144th June 2018 - by A.J. Armstrong - Leave a Comment

If you want to report on the versions of your ConfigMgr clients that you have within your Configuration Manager environment then you can run this query directly on your SQL …

Read More
sql2016
Guide / Query / SCCM / SQL

Configuration Manager Report Query for Machine Count by Manufacturer

28th May 201415th April 2020 - by A.J. Armstrong - Leave a Comment

If you want to report on the number of machines per manufacturer that you have within your Configuration Manager environment then you can run this query directly on your SQL …

Read More
sql2016
Guide / Query / SCCM / SQL

Configuration Manager Report Query for Server Name and Properties

27th May 201415th April 2020 - by A.J. Armstrong - 2 Comments.

If you want to report on the server names and properties of those servers that you have within your Configuration Manager environment then you can run this query directly on …

Read More
sql2016
Guide / Query / SCCM / SQL

SCCM Report Query for Machine Make and Model Count

26th May 201415th April 2020 - by A.J. Armstrong - Leave a Comment

If you want to report on the number of certain makes and models of machines that you have within your Configuration Manager environment then you can run this query directly …

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

Configuration Manager Report Query for Systems with Torrent Software Installed

23rd May 20144th November 2020 - by A.J. Armstrong - Leave a Comment

If you want to check if any of the client machines within your Configuration Manager network have torrent software installed, you can run this query directly on your SQL database …

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

Report Query for Package Distribution Status on Configuration Manager Distribution Points

22nd May 20144th June 2018 - by A.J. Armstrong - Leave a Comment

If you want to check the distribution status on your Configuration Manager Distribution Points you can run this query directly on your SQL database or you can use it to …

Read More
Get WMI Query
Guide / Microsoft / News / Program / Query / SCCM / WDS

Get WMI Query v1.6 Released

13th April 201418th April 2020 - by A.J. Armstrong - 2 Comments.

A free utility to get the WMI information from a computer. This is a great tool for SCCM administrators.

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

Configuration Manager SQL Query for Installed Software Per Machine & Per Collection

9th April 20141st September 2019 - by A.J. Armstrong - 6 Comments.

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

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

SCCM – Low Disk Space SQL Query

3rd February 201414th April 2019 - by A.J. Armstrong - Leave a Comment

This is a SQL query for your SCCM database or you can use it to create a report using SSRS. For this work, you must ensure that you have the …

Read More
sql
Query / SCCM / SQL

ConfigMgr SQL Query – ConfigMgr clients installed per AD Site

29th January 201427th April 2019 - by A.J. Armstrong - Leave a Comment

This query will give you the amount of ConfigMgr clients that are installed on machines per AD site. This can be run on your Configuration Manager SQL database or you …

Read More
sccm logo
Query / SCCM / SQL

SQL Query for SCCM – Hierarchy information

26th January 201424th March 2018 - by A.J. Armstrong - Leave a Comment

This is a very simple SQL query but still very useful and will give you a lot of information about your Configuration Manager hierarchy. select * from sites Run this …

Read More
sql2016
Query / SCCM / SQL

SQL query for retrieving Site Roles from ConfigMgr Database

23rd January 201424th March 2018 - by A.J. Armstrong - Leave a Comment

If you want to retrieve the site roles from your ConfigMgr environment, you can use the following SQL query: select SiteCode, RoleName, ServerName from SysResList More Queries Our full range …

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

Query for all machines with SQL installed using Installed Software

22nd January 20141st September 2019 - by A.J. Armstrong - Leave a Comment

If you wish to run a SQL query against your SCCM database to find all machines with SQL installed, then you can use this SQL query below: More SQL Queries …

Read More
microsoft windows white logo
Query / Guide / Microsoft / SCCM / SQL

SCCM – WQL Query for machines without Endpoint Protection installed

21st January 20147th April 2018 - by A.J. Armstrong - 9 Comments.

If you need to identify machines that have the Configuration Manager client installed but do not have the System Center Endpoint Protection client installed, then you can use the following …

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

SCCM – WQL Query for machines with 4GB RAM or more

20th January 201415th April 2020 - by A.J. Armstrong - 2 Comments.

If you have a requirement to identify machines with 4GB RAM or more, then you can use the following WQL query to do this. select distinct SMS_R_System.Name, SMS_R_System.ADSiteName, SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory, SMS_R_System.IPAddresses, …

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

SCCM – WQL Query for devices with specific software installed

16th January 20147th April 2018 - by A.J. Armstrong - 4 Comments.

If you want to identify machines with a specific piece of software installed, you can utilise the Add/Remove Programs software inventory to do this by using this query. select distinct …

Read More

Posts navigation

Previous 1 2 3 4 Next
Ezoic Invitation

Trending Posts

Betway

Categories

Top Downloads

Ultimate Settings Panel
Ultimate Settings Panel
Downloads: 35822
Size: 0.00 KB
Version: 6.6
Updated: 24th November 2020
Windows Easy Transfer for Windows 10
Windows Easy Transfer for Windows 10
Downloads: 26956
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: 10951
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: 9238
Size: 0.00 KB
Version: 3.6
Updated: 11th July 2020
CCMClean
CCMClean
Downloads: 9093
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

  • fm16 Steam Error 55 – Football Manager 2015 – Will not load – Incomplete Installation
  • Adobe Flash Player 1 Adobe Flash Player MSI Package v32.0.0.403
  • Visual Studio 2013 Update 1 Released
  • filezilla FileZilla FTP Client MSI Installer v3.17.0 Released
  • sql2016 SCCM – WQL Query for MAC Address Prompt

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,888,665 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