TechyGeeksHome

Making IT Happen

TechyGeeksHome

Making IT Happen

SCCM

SCCM – WQL Query for machines with a valid Hardware Scan in the last x days

SCCM – WQL Query for machines with a valid Hardware Scan in the last x days

By Andrew ArmstrongPosted on Posted in System CenterTagged , , , No Comments on SCCM – WQL Query for machines with a valid Hardware Scan in the last x days

If you would like to identify the machines that have had a valid hardware inventory scan within the last x amount of days, you can use this WQL query as per below. select SMS_R_System.Name, SMS_G_System_WORKSTATION_STATUS.LastHardwareScan from SMS_R_System inner join SMS_G_System_WORKSTATION_STATUS on SMS_G_System_WORKSTATION_STATUS.ResourceId = SMS_R_System.ResourceId where DateDiff(dd,SMS_G_System_WORKSTATION_STATUS.LastHardwareScan,GetDate() ) <= 15 This query is defaulted to 15 […]

Read More
SCCM – WQL Query for MAC Address Prompt

SCCM – WQL Query for MAC Address Prompt

By Andrew ArmstrongPosted on Posted in Guide, System CenterTagged , , , , No Comments on SCCM – WQL Query for MAC Address Prompt

If you would like to search for a machine based upon its MAC address, you can use a WQL query to do this. The WQL query that you should use for this is below: select distinct SMS_R_System.Name, SMS_R_System.MACAddresses from SMS_R_System where SMS_R_System.MACAddresses = ##PRM:SMS_R_System.MACAddresses## order by SMS_R_System.MACAddresses More Queries Our full range of SQL and […]

Read More
SCCM – Query for devices in a specific Active Directory Organisational Unit (OU)

SCCM – Query for devices in a specific Active Directory Organisational Unit (OU)

By Andrew ArmstrongPosted on Posted in Guide, System CenterTagged , , , , 3 Comments on SCCM – Query for devices in a specific Active Directory Organisational Unit (OU)

If you are looking for a SCCM query query that will return all machines that are in a specified organisational unit (OU), then you can use this one below. All you need to do is change the demo OU below to your own required OU. Organisational Unit TECHYGEEKSHOME/LAB/COMPUTERS/WINDOWS 10 Query Script SELECT distinct * FROM SMS_R_System […]

Read More
Server Information SQL Query for SCCM

Server Information SQL Query for SCCM

By Andrew ArmstrongPosted on Posted in Guide, System CenterTagged , , , No Comments on Server Information SQL Query for SCCM

The below SQL query can be used against your SCCM database to return information about your servers. You can edit this query to bring back different information and also use it to create a report using SSRS. This query by default brings back the following information: Query More Queries Our full range of SQL and […]

Read More
Uninstalling Google Earth using SCCM

Uninstalling Google Earth using SCCM

By Andrew ArmstrongPosted on Posted in Guide, System CenterTagged , , No Comments on Uninstalling Google Earth using SCCM

Most users in organisations believe that Google Earth is a great tool for their work and freely install it on their work machines and think nothing of it. Well, Google Earth is NOT free for commercial use and if business users want to use Google Earth for work purposes on work machines, then a licence […]

Read More
SCCM – WQL Query for devices with Google Earth installed

SCCM – WQL Query for devices with Google Earth installed

By Andrew ArmstrongPosted on Posted in Guide, System CenterTagged , , , 2 Comments on SCCM – WQL Query for devices with Google Earth installed

If you want to identify machines with Google Earth software installed, you can utilise the Add/Remove Programs software inventory to do this by using this query. This WQL query can then be used as part of an import function to create a device collection within SCCM. More Queries Our full range of SQL and WQL […]

Read More
Nitro PDF Serial Number Collection using SCCM

Nitro PDF Serial Number Collection using SCCM

By Andrew ArmstrongPosted on Posted in System Center, GuideTagged , , , No Comments on Nitro PDF Serial Number Collection using SCCM

Sorry but we have been forced to remove this page as NitroPDF believe that we are giving out serial numbers illegally. Although this is just a tutorial for how to gather your OWN PAID FOR serial numbers using SCCM, it seems this is not good enough for NitroPDF or Google. So, we have had to […]

Read More
Updating a WIM Image File using Offline Updates

Updating a WIM Image File using Offline Updates

By Andrew ArmstrongPosted on Posted in Microsoft, Guide, WindowsTagged , , , , No Comments on Updating a WIM Image File using Offline Updates

If you have custom build images that you are using in your SCCM OSD environment, you may find that keeping them up to date is a real problem. However, there is a way of running Windows Updates against your custom WIM files offline and then simply redistributing your WIM file. Below is a guide on how to carry this […]

Read More
Windows Updates during SCCM OSD from Replica WSUS Servers

Windows Updates during SCCM OSD from Replica WSUS Servers

By Andrew ArmstrongPosted on Posted in Guide, MicrosoftTagged , , , , No Comments on Windows Updates during SCCM OSD from Replica WSUS Servers

I have been asked to provide a solution to a situation where during SCCM OSD, they want to run Windows Updates across multiple sites worldwide using the local WSUS replica servers. So as an example, the main Headquarters office is in New York with the main WSUS server and then in Rome there is another […]

Read More
CCMClean – Uninstalling Configuration Manager Clients

CCMClean – Uninstalling Configuration Manager Clients

By Andrew ArmstrongPosted on Posted in System Center, GuideTagged , , , 6 Comments on CCMClean – Uninstalling Configuration Manager Clients

You may sometimes come across Configuration Manager clients that are not working correctly. The tell-tale signs for this on a client machine are missing tabs, missing selections under the Actions tab and incorrect or missing information on the General tab. In short, your Configuration Manager Control Panel applet may look like below: I have had […]

Read More
SCCM clients stuck on 0% downloading applications

SCCM clients stuck on 0% downloading applications

By Andrew ArmstrongPosted on Posted in Guide, MicrosoftTagged , , , No Comments on SCCM clients stuck on 0% downloading applications

If you have a client that is not downloading its required files in the Software Center (having requested from the software catalog and is seemingly stuck on 0%) then it could be an issue with the local DP server. To fix this, login to the local server and go into IIS Manager. You should then […]

Read More
Installing WSUS Console from the Software Center in SCCM

Installing WSUS Console from the Software Center in SCCM

By Andrew ArmstrongPosted on Posted in Microsoft, GuideTagged , , , No Comments on Installing WSUS Console from the Software Center in SCCM

You may wish to add the WSUS console to the Software Center in SCCM. This stops people logging onto WSUS servers and also provides quick and easy access to multiple WSUS servers. However, the installer requires a few setup parameters to make it work correctly. Download WSUS Console Windows Server Update Services Console 3.0 SP2 […]

Read More
Scroll to top