SCCM – Differences between Add Remove Programs Database Tables

microsoft black logo

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 we would post a quick reference here to confirm which table of data means what. There are five different tables of data available to you for Add Remove Programs, knowing on what information you want out of your database is the first step.

v_Add_Remove_Programs Combination of 32 and 64 bit programs data
v_GS_Add_Remove_Programs 32 bit programs data
v_GS_Add_Remove_Programs_64 64 bit programs data
v_HS_Add_Remove_Programs Historical 32 bit programs data
v_HS_Add_Remove_Programs_64 Historical 64 bit programs data

So the v_Add_Remove_Programs table is the one that would provide you with active data for both 32-bit and 64-bit programs, but you may want to choose to only have 32-bit data, in which case would be v_GS_Add_Remove_Programs table.

More Queries

Our full range of SQL and WQL Collection queries are available here.

Feedback

If you have any questions or feedback about this post, or if you would like us to create any queries for you, please go ahead and leave us a message below in the comments section and we will get back to you as quick as we can.

Power BI – Refresh data every working hour

microsoft power bi 600x315

If you are using Power BI and a personal gateway, you may want to ensure that your report data is updating regularly during working hours.

Well you can easily set this up within your dataset schedule refresh options.

Instructions

Just go into the dataset settings and open up the Scheduled refresh option:

Power BI - Refresh data every working hour 1

You will see that you can choose on the drop down menu to refresh Daily or Weekly:

Power BI - Refresh data every working hour 2

This is fine, but, like we said above, what if you want it to refresh every hour during working hours?

Underneath the Time zone area you will see Time and then under that, Add another time:

Power BI - Refresh data every working hour 3

You can then keep adding up to 8 different times for the refresh schedule to take place:

Power BI - Refresh data every working hour 4

Once you are happy with your schedule, just click the Apply button and you are finished!

Feedback

If you have any questions or feedback on this guide, please feel free to leave us a message in our comments section towards the bottom of this page.

SCCM – SQL Query for all server CPU information

SQL CPU Information

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 the query for you!

You can use the below to get various information on the CPU or you can use SELECT * to bring back all information and make your own choices. We have gone for the basics of what you would normally need for a report using SSRS or Power BI.

SELECT
   DISTINCT(CPU.SystemName0) AS [System Name],
   CS.Manufacturer0 AS [Make],
   CS.Model0 AS [Model],
   OS.Caption0 AS [Operating System],
   CS.SystemType0 AS [Architecture],
   CPU.Name0 AS [CPU Model],
   COUNT(CPU.ResourceID) AS [Number of CPUs],
   CPU.NumberOfCores0 AS [Number of Cores per CPU],
   CPU.NumberOfLogicalProcessors0 AS [Logical CPU Count]
FROM [dbo].[v_GS_PROCESSOR] CPU
   LEFT OUTER JOIN dbo.v_GS_COMPUTER_SYSTEM CS
ON CS.ResourceID = CPU.ResourceID
   LEFT OUTER JOIN dbo.v_GS_Operating_System OS
ON CS.ResourceID = OS.ResourceID
   WHERE OS.Caption0 LIKE '%server%'
GROUP BY
   CS.Manufacturer0,
   CS.Model0,
   OS.Caption0,
   CS.SystemType0,
   CPU.SystemName0,
   CPU.Name0,
   CPU.NumberOfCores0,
   CPU.NumberOfLogicalProcessors0
ORDER BY [System Name] ASC

This should then produce SQL information like this:

SCCM - SQL Query for all server CPU information 5

You can then use this to create pretty reports in SSRS or Power BI!

More Queries

Our full range of SQL and WQL Collection queries are available here.

Feedback

If you have any questions or feedback about this post, or if you would like us to create any queries for you, please go ahead and leave us a message below in the comments section and we will get back to you as quick as we can.

Merry Christmas 2017!!

christmas

We would like to wish all our of visitors a very Merry Christmas today and we hope you got everything that you wished for and spent the day with the people you care about the most!

Merry Christmas from all at TechyGeeksHome.

Merry Christmas 2017!! 6

Filestore Microsite Announcement

filestore

We are delighted to announce our new filestore microsite which we have now launched and is available at https://filestore.techygeekshome.info

All our new downloads will now be uploaded to this microsite and we have so far uploaded our most popular downloads already and will continue to migrate all of our existing downloads over the next few coming weeks.

You will find on here the latest version of Ultimate Settings Panel as well as MSI installer packs for the likes of Adobe Flash Player, Java client, FileZilla client and VLC Player.

We have also setup a SSL certificate on the site to ensure that you can have full confidence in using the microsite.

If there is any downloads that you would like us to look at getting uploaded, please feel free to contact us.

Disable Windows Defender GPO

Blue and White Windows 10 Logo

If you are going to install a different anti-malware program onto your corporate computers, you may want to disable the built in Windows Defender from Windows 10 machines.

Although you cannot uninstall Windows Defender as such, you can disable it which is as good as carrying out an uninstall.

To do this, you should create a new Group Policy Object (GPO) and browse to the following location:

Computer Configuration > Policies > Administrative Templates > Windows Components > Windows Defender Antivirus

You will then see the option to Turn off Windows Defender Antivirus:

Disable Windows Defender GPO 7

Change this setting to Enabled to turn off Windows Defender and then deploy this new GPO to whichever Organisation Unit you require this action to take place on.

Comments

If you have any questions or feedback on this guide, please feel free to leave us a message below in the comments section.

VLC Player v2.2.8 MSI Installers Released

VLC Player v3.0.11

We believe that VLC Player is the best media player available on the internet at the moment and has been for some time, but there is no MSI installer for it. MSI installers can be used easily for distribution using systems like Configuration Manager, WDS or Group Policy.

So, we have taken the standalone version of VLC Player v2.2.8 and created a MSI installer from it.

You can download the MSI installer from our new filestore microsite by clicking the link below:

Download

Download VLC Player v2.2.8 MSI Installer

Instructions

For full instructions on how to use MSI installations, you should take a look at our MSI installer guide here.

If you want to distribute VLC Player as a silent install, then you can use the code as below:

WDS or Group Policy

VLC Player v2.2.4.msi /q /norestart

Configuration Manager

msiexec /i "VLC Player v2.2.4.msi" /q /norestart

Comments

If you have any questions, feedback or comments on this post, please feel free to leave us a message below in the comments section.

Adobe Flash Player MSI Installers v28.0.0.126

Adobe Flash Player MSI Package

Adobe have released another update to their Adobe Flash Player software, this time taking it up to version 28.0.0.126.

As always, you can download the executable file but if you want the MSI files so that you can load it into your Configuration Manager Software Catalog, you can get that here.

The update is also now available to import through System Center Update Publisher (SCUP) so you can inject it into your WSUS or Configuration Manager systems.

You can the download the MSI installers for Adobe Flash (ActiveX, Plugin, PPAPI) by clicking the button link below:

Download

Download Flash Player MSI Package

Comments

If you have any feedback or questions, please feel free to leave a message below in our comments section.

Uninstalling System Center Endpoint Protection

microsoft black logo

If you have been using System Center Endpoint Protection and you now want to move away from it, you will need to carry out an uninstall of the software.

This can be very easily carried out either through a manual process of uninstalling using the Programs and Features within the Windows Control Panel or if you have the original installer, simply build a command line to carry out the uninstall for you.

You can then use a system like Group Policy or Configuration Manager to carry out the uninstall for you on a larger amount of computers.

The command line that you will need to use with the original installer is:

scepinstall.exe /u /s

This will then run the original installer package but with the uninstall and silent parameters. You can then push this command out to multiple computers where required.

Comments

If you have any questions or feedback on this guide, please feel free to leave us a message below in the comments section.

Ultimate Settings Panel – Version 5.8 Released

We are pleased to announce the release of Ultimate Settings Panel version 5.8.

This version includes the changes in relation to our recent branding program and a few minor bug fixes and web link updates.

Video Demo

See Ultimate Settings Panel in action below:

Download

Download Ultimate Settings Panel v5.8

Prerequisites

This program requires Microsoft .Net 4.5.2 to work correctly. You can download this directly from Microsoft by clicking here.

Instructions

For full instructions on how to use the Ultimate Settings Panel utility, click here.

Licence

This utility is free to use for both personal and commercial use.

Distribution

You are free to distribute this utility in it’s original form. No amendments or installation wrapping with PuP is permitted.

Comments

If you have any comments on this new release, please feel free to leave us a message below in the comments section.

FileZilla FTP Client MSI Installer v3.29.0 Released

FileZilla FTP

With the new FileZilla FTP Client release to v3.29.0 we have now created the MSI installer for it and added to our Filestore download website.

This is the standalone version that has been repackaged by us into an MSI installer. This means that you can use this for deployment with ConfigMgr, WDS, Group Policy and MDT amongst other systems.

Download

Download FileZilla MSI Installer

Instructions 

If you want to distribute FileZilla as a silent install, then you can use the code as below:

WDS or Group Policy

FileZilla FTP Client v3.25.2.msi /q /norestart

Configuration Manager

msiexec /i "FileZilla FTP Client v3.25.2.msi" /q /norestart

Comments

If you have any questions or feedback on this post, please feel free to leave us a message below in our comments section and we will get back to you as soon as possible.

5 Tech-Savvy Features to Consider for Your Home

smart home 2769210 640

Technology is in nearly every aspect of life, and your home is no exception. New gadgets are revolutionizing how people accomplish everyday tasks. Here are five common smart technologies to integrate into your home to make life just a little bit easier.

Smart Lighting

Changing your home over to smart lighting can make your life much simpler. An intelligent home lighting system eliminates the need to use the switch on the wall and puts control in your hands through an app on your phone, tablet, or computer. You can turn the lights on or off when you want or schedule them to turn on and off at specific times. You can also adjust the brightness of the lights to match the light outside. There’s no need to wonder if you have left the lights on at home since you can use your phone to check from wherever you are.

Smart Thermostat

A smart thermostat is not only convenient but helps save money on heating and cooling costs. You have total control of your home’s cooling and heating no matter where you are. You can adjust the temperature, program it to turn on or off shortly before you arrive, and put total control in your hands. Adjust the temperature without even getting out of bed right from your phone.

Home Security

A home security system is a way to keep your eyes on your home at all times. Most systems allow you to look at the camera in real-time from an app. There’s also the ability to record footage and look at it later if there is anything you need to review. Some also include sound recording or other features that are beneficial, such as carbon monoxide monitoring.

Robot Vacuums

A robotic vacuum has the sensory technology to allow it to vacuum your entire house while you do something else. The vacuum navigates around obstacles, and some even include a feature that automatically empties the dustbin. Different modes clean various types of flooring for the most efficient results.

Smart Refrigerator

A refrigerator with a wi-fi screen on the outside is the ultimate cold storage device. These fridges interact with your phone to help you keep and maintain an inventory of its contents. Energy-consumption details and compatible apps make it easy to manage your shopping list and remember all the things that you need to pick up while you are out running errands.  

A smart home is the direction renovations and upgrades are headed. Get in on the rage and add one or more of these to your home for an updated and tech-driven home.