SQL Archives - TechyGeeksHome

How to migrate a SCSM database

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

Post Views: 98 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 …

Guide / Microsoft / SCORCH / SQL

Migrate a System Center Orchestrator database to a different SQL Server

17th December 201820th April 2019 - by A.J. Armstrong - Leave a Comment

Post Views: 83 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 …

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

Post Views: 137 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 …

Guide / Microsoft / SCSM / SQL

Service Manager Database Using High RAM

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

Post Views: 70 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 …

Guide / SCCM / SQL / Windows

SCCM – Report on PST File Locations

9th April 20189th July 2018 - by A.J. Armstrong - 8 Comments.

Post Views: 516 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 …

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

Post Views: 295 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 …

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

Post Views: 250 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 …

Guide / Microsoft / SCCM / SQL

SCCM – Create a device collection based on Exchange Server role

29th January 20189th July 2018 - by A.J. Armstrong - 1 Comment

Post Views: 99 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 …

Guide / Microsoft / Query / SCCM / SQL

SCCM – Create a device collection based on Domain Controller role

24th January 201820th April 2019 - by A.J. Armstrong - 1 Comment

Post Views: 168 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 …

Guide / Microsoft / Query / SCCM / SQL

SCCM – Hardware and Client Version SQL Query

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

Post Views: 65 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 …

Guide / Microsoft / Query / SCCM / SQL

SCCM SQL Query for Software not in Add Remove Programs

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

Post Views: 186 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 …

Guide / Microsoft / SCCM / SQL

SCCM – Differences between Add Remove Programs Database Tables

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

Post Views: 76 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. …

Guide / Microsoft / News / SCCM / SQL

SCCM – SQL Query for all server CPU information

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

Post Views: 142 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 …

Guide / Microsoft / Query / SCCM / SQL

SCCM – SQL Query for all Laptops

1st November 20177th April 2018 - by A.J. Armstrong - Leave a Comment

Post Views: 135 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 …

Guide / SCCM / SCOM / SCORCH / SCSM / SQL

System Center Orchestrator – SQL Query to show log file data

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

Post Views: 74 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 …

Google / Guide / SCCM / SQL

SCCM SQL Query – Google Earth Installs

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

Post Views: 56 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 …

Guide / Microsoft / SCCM / SQL

SCCM SQL Query – Spotify Installations

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

Post Views: 92 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 …

Guide / Microsoft / News / SQL

SQL Server Management Studio (SSMS) 2016 Released

1st November 20167th April 2018 - by A.J. Armstrong - Leave a Comment

Post Views: 179 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 …

Tag: SQL

How to migrate a SCSM database

Migrate a System Center Orchestrator database to a different SQL Server

SQL Query to find members of an Active Directory Security Group

Service Manager Database Using High RAM

SCCM – Report on PST File Locations

SCCM – Active Directory Security Group Query for User Collection

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

SCCM – Create a device collection based on Exchange Server role

SCCM – Create a device collection based on Domain Controller role

SCCM – Hardware and Client Version SQL Query

SCCM SQL Query for Software not in Add Remove Programs

SCCM – Differences between Add Remove Programs Database Tables

SCCM – SQL Query for all server CPU information

SCCM – SQL Query for all Laptops

System Center Orchestrator – SQL Query to show log file data

SCCM SQL Query – Google Earth Installs

SCCM SQL Query – Spotify Installations

SQL Server Management Studio (SSMS) 2016 Released

Windows 10 Language Packs

The Best Games to Test Your New Graphics Card