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

TechyGeeksHome

Making IT Happen

  • Home
    • About Us
    • 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
  • Reviews
  • YouTube
  • FAQ
  • Contact
    • Free Subscription
    • Social Media

Tag: SQL

How to Automatically Remove Spotify using SCCM
Guide / Microsoft / Power BI / SCCM / SQL

How to Automatically Remove Spotify using SCCM [2019 Updated]

15th October 201915th October 2019 - by A.J. Armstrong - 1 Comment

How to automatically uninstall Spotify installations using System Center Configuration Manager (SCCM).

Read More
How-to-migrate-a-scsm-database
SCSM / Guide / Microsoft / SQL

How to migrate a SCSM database

4th March 201920th April 2019 - by A.J. Armstrong - Leave a Comment

We recently had a situation where we needed to upgrade our SQL server that had the System Center Service Manager (SCSM) databases on it. This meant that we would need …

Read More
SCORCH Logo
Guide / Microsoft / SCORCH / SQL

Migrate a System Center Orchestrator database to a different SQL Server

17th December 20186th August 2020 - by A.J. Armstrong - Leave a Comment

We were running through our list of servers and looking at what each one was doing in terms of Domain Controllers, Exchange servers, SQL servers, System Center servers etc when …

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
sql2016
SCSM / Guide / Microsoft / SQL

Service Manager Database Using High RAM

11th June 201828th May 2018 - by A.J. Armstrong - Leave a Comment

We recently had a problem with our Service Manager database server using massively high RAM usage. It was using up all the RAM we gave it no matter how much …

Read More
microsoft black logo
Guide / SCCM / SQL / Windows

SCCM – Report on PST File Locations

9th April 201823rd April 2020 - by A.J. Armstrong - 12 Comments.

Users love to keep their email for as long as they possibly can, but when IT Admins start telling them to archive their email because their mailbox is too big, …

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
sccm logo
Guide / Microsoft / SCCM / SQL

SCCM – Create a device collection based on Exchange Server role

29th January 20189th July 2018 - by A.J. Armstrong - 2 Comments.

Following on from our recent posts for Configuration Manager collection queries, we have another one here for all devices that are Microsoft Exchange servers. Go ahead and create a new …

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
microsoft black logo
SCCM / Guide / Microsoft / SQL

SCCM – Differences between Add Remove Programs Database Tables

29th December 201724th March 2018 - by A.J. Armstrong - Leave a Comment

We had seen a few posts around the internet where people are asking the differences between the various Add_Remove_Programs data within the System Center Configuration Manager database. So we thought …

Read More
SQL CPU Information
News / Guide / Microsoft / SCCM / SQL

SCCM – SQL Query for all server CPU information

27th December 20172nd July 2018 - by A.J. Armstrong - Leave a Comment

If you are looking for an SQL query to use against your System Center Configuration Manager database to give you the ability to report on server CPU information, this is …

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
SystemCenter logo
SCORCH / Guide / SCCM / SCOM / SCSM / SQL

System Center Orchestrator – SQL Query to show log file data

11th April 201724th March 2018 - by A.J. Armstrong - Leave a Comment

If you are using System Center Orchestrator (SCORCH)  Runbooks then you may have run into issues where the database is increasing in size due to the large amount of log …

Read More
google earth pro MSI logo
Google / Guide / SCCM / SQL

SCCM SQL Query – Google Earth Installs

28th November 201614th April 2019 - by A.J. Armstrong - Leave a Comment

We have recently been asked to report on Google Earth installations within our SCCM environment. So, as we were already collecting the EXE file information within our hardware inventory, we could …

Read More
sql2016
News / Guide / Microsoft / SQL

SQL Server Management Studio (SSMS) 2016 Released

1st November 20164th October 2020 - by A.J. Armstrong - Leave a Comment

Microsoft have now released SQL Server Management Studio (SSMS) 2016 and is ready to download and use. You can get the download by clicking the button below: Download SSMS 2016 SQL …

Read More

Posts navigation

1 2 … 4 Next

Follow Us

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

Trending Posts

Betway

Categories

Latest Posts

small white dice placed on wooden table

How to use online betting tools

24th January 202124th January 2021

two pens beside macbook

The Top 4 Benefits of Guest Posting in 2021

21st January 202121st January 2021

blue-glow-tablet

How to Shield Your Eyes From Digital Screens?

21st January 202122nd January 2021

poker-card-cards-casino

A Geeky Guide to Online Casino

19th January 202119th January 2021

proxies

An In-Depth Look at the Use of Proxies

19th January 202119th January 2021

blogging

5 Key Elements of Writing a Perfect Blog Post

19th January 202119th January 2021

4 Ways Your Users Will Destroy Your Company Without Even Trying

How to Find Out If Your Data Has Been Leaked onto the Dark Web

19th January 202119th January 2021

Why Digital Rumble is a Great Site for Xbox Players 2

Why Digital Rumble is a Great Site for Xbox Players

13th January 202113th January 2021

Coding

How to clear interview in React Native Development Company

5th January 20215th January 2021

pexels-torsten-dettlaff-193003

How To Use Outlook For Mail Management

5th January 20215th January 2021

Top Downloads

Ultimate Settings Panel
Ultimate Settings Panel
Downloads: 35558
Size: 3.07 MB
Version: 6.6
Updated: 24th November 2020
Windows Easy Transfer for Windows 10
Windows Easy Transfer for Windows 10
Downloads: 24286
Size: 18.88 MB
Version: 1.0
Updated: 24th November 2020
Cisco VPN Client Fix for Windows 10 Package
Cisco VPN Client Fix for Windows 10 Package
Downloads: 10868
Size: 0.00 KB
Version: 3.6
Updated: 11th July 2020
Autodesk Serial Number Collection MOF v2017
Autodesk Serial Number Collection MOF v2017
Downloads: 10018
Size: 0.00 KB
Version: 2017
Updated: 11th July 2020
Cisco Client VPN Fix Package Pro
Cisco Client VPN Fix Package Pro
Downloads: 9148
Size: 0.00 KB
Version: 3.6
Updated: 11th July 2020
CCMClean
CCMClean
Downloads: 8993
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: 8352
Size: 0.00 KB
Version: 24.0.0.186
Updated: 11th July 2020

Random Posts

  • blue search image Outrank your Competitors with Content Writing Techniques
  • security camera How to Choose the Best Security Camera for Your House
  • Is Texting Good or Bad for Relationships? 3 Is Texting Good or Bad for Relationships?
  • Windows 8 1 3 300x168 How to Fix Bluetooth Issues in Windows 8.1
  • powershell How do I type a Powershell “Pipe”?

Archives

Top Rated Posts

PAD File Submissions
5 (1)

PAD File Submissions

Adobe Reader DC MSI Installer
5 (1)

Adobe Reader DC MSI Installer

Windows 10 Language Pack – Japanese
5 (1)

Windows 10 Language Pack – Japanese

Windows 10 Language Pack – Hungarian
5 (1)

Windows 10 Language Pack – Hungarian

Deploy Autodesk DWG Trueview 2017 using SCCM
5 (1)

Deploy Autodesk DWG Trueview 2017 using SCCM

Tag Cloud

Adobe Apple Autodesk Blogger CD Keys Chrome Exchange FileZilla Firefox Flash Gaming General General Tech Google Group Policy Guide Java Microsoft MSI News Notepad 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

Meta

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

Recent Comments

  • Anonymous on Windows Easy Transfer for Windows 10
  • Bill on Windows Easy Transfer for Windows 10
  • Bill on Windows Easy Transfer for Windows 10
  • A.J. Armstrong on SCCM Query for Microsoft Server 2019
  • Onur on SCCM Query for Microsoft Server 2019

Our RSS Feeds

RSS Feed RSS - Posts

RSS Feed RSS - Comments

Subscribe via Email

Join 531 other subscribers.

(c) TechyGeeksHome 2020