Tagged: SQL

google earth 12 700x406

SCCM SQL Query – Google Earth Installs

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 make use...

sql

SQL Server Version Numbers

Below is a full list of SQL Server version numbers dating from version 7.0 through to the current 2016 RTM release. Codename RTM Service Pack 1 Service Pack 2 Service Pack 3...

sql

Microsoft SQL Server 2012 Express

This is more of a reminder for ourselves, but if you are looking to download Microsoft SQL Server 2012 express, for which you can use to install the SQL Console Management Tools...

sccm

SCCM – 52 Operational Collections

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 Full list...

sccm

SCCM Collection Query – Virtual Machines

If you are looking for a SCCM collection query for virtual machines in your environment, then you can use this query below: select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from SMS_R_System where...