SQL Archives - TechyGeeksHome

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 …

Guide / Microsoft / SCORCH / SQL

Migrate a System Center Orchestrator database to a different SQL Server

17th December 201819th September 2019 - 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 …

Guide / Microsoft / Query / SQL

SQL Query to find members of an Active Directory Security Group

26th November 201820th April 2019 - by A.J. Armstrong - Leave a 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 …

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 …

Guide / SCCM / SQL / Windows

SCCM – Report on PST File Locations

9th April 20189th July 2018 - 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, …

Guide / Microsoft / Query / SCCM / SQL

SCCM – Active Directory Security Group Query for User Collection

23rd March 20189th July 2018 - 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. …

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 …

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 …

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 …

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 …

Guide / Microsoft / Query / SCCM / SQL

SCCM SQL Query for Software not in Add Remove Programs

9th January 201817th July 2019 - 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: …

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 …

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 …

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. …

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 …

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 …

Guide / Microsoft / SCCM / SQL

SCCM SQL Query – Spotify Installations

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

We have recently been asked to report on Spotify installations within our SCCM environment. The reason is that the IT policies state that users should not be installing Spotify on …

News / Guide / Microsoft / SQL

SQL Server Management Studio (SSMS) 2016 Released

1st November 20167th April 2018 - 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 …