Month – January 2011

SCAM Alert!!!

Wow, I have to say that I just had the pushiest guys try to scam me! Edward (11868) from online PC care. He called me out of the blue to tell me that my PC is having problems!!! He then explains that Facebook , Amazon, and a few other site will infect my PC! (What […]

Why you should not use IP address data in a report

As most of you know I NEVER use IP data within a report. due to the large number of duplicate rows. however…. Notice that E6510, ES-04, ES-06 are list twice.. Hence why I NEVER use IP address date within a report. select  distinct R.Netbios_Name0 AS ‘Computer Name’, R.Resource_Domain_OR_Workgr0 AS ‘Domain/Workgroup’, S.SiteName as ‘SMS Site Name’, […]

Adding AD site to Query

select  distinct     R.Netbios_Name0 AS ‘Computer Name’,     R.Resource_Domain_OR_Workgr0 AS ‘Domain/Workgroup’,     S.SiteName as ‘SMS Site Name’,     R.AD_Site_name0 as ‘AD Site’,     ‘Top Console User’ = CASE         when (SCUM.TopConsoleUser0 is NULL or SCUM.TopConsoleUser0 = ‘-1’) then ‘Unknown’         Else SCUM.TopConsoleUser0     End,     OS.Caption0 AS ‘Operating System’,     OS.CSDVersion0 AS ‘Service Pack Level’, […]

2011 myITforum.com Donation

With the start of a new year, it is that time again to support the System Management Community, with that in mind I have made my yearly donation of $250 USD to MyITForum (MIF). Have you made a donation to your community yet? http://www.myitforum.com/donations/donate.asp

Auditing your BITS settings

Use the following MOF edits to audit your BITS settings.   configuration.mof // RegKeyToMOF by Mark Cochrane (thanks to Skissinger, Steverac & Jonas Hettich) // this section tells the inventory agent what to collect // 1/19/2011 10:21:30 AM // Created by Enhansoft – Garth Jones   #pragma namespace (“\\\\.\\root\\cimv2”) #pragma deleteclass(“BITS”, NOFAIL) [DYNPROPS] Class BITS […]

Afterbackup.bat

Here is an Afterbackup.bat file that will make a daily backup of ConfigMgr Backup, so that you have a full week of backups. ::: Created Garth Jones Jan 13 2011 ::: —– REM @echo off setlocal enabledelayedexpansion set target=\\FP.Enhansoft.com\D$\sccmbackup\%date:~0,3% If not exist %target% goto datacopy RD %target% /s /q   :datacopy xcopy “D:\sccmbak\*” “%target%\” /E […]

PCs without SEP

*** updated to use spaces instead of tabs *** 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 SMS_R_System.ResourceId not in (select SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID   from     SMS_G_System_ADD_REMOVE_PROGRAMS   where    SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like “%Symantec Endpoint Protection%”) and SMS_R_System.ResourceId not in (select SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID   from     SMS_G_System_ADD_REMOVE_PROGRAMS_64   where    SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like “%Symantec Endpoint Protection%”)