SCCM

SCCM report for hardware specs of all desktops and laptops on the domain

by

      —select * from v_GS_SYSTEM_ENCLOSURE SELECT  distinct CS.name0 as ‘Computer Name’, CS.domain0 as ‘Domain’, CS.UserName0 as ‘User’, BIOS.SerialNumber0 as ‘Bios serial’, SE.SerialNumber0 as ‘System Enclosure serial’, CS.Manufacturer0 as ‘Manufacturer’, CS.Model0 as ‘model’, OS.Caption0 as ‘OS’, RAA.SMS_Assigned_Sites0 as ‘Site’, RAM.TotalPhysicalMemory0 as ‘Total Memory’, sum(isnull(LDisk.Size0,’0′)) as ‘Hardrive Size’, sum(isnull(LDisk.FreeSpace0,’0′)) AS ‘Free Space’, CPU.MaxClockSpeed0 as ‘Max … Read more

What is Altiris and what are the modules it has inside??

by

Altiris service-oriented management solutions provide a modular and future-proof approach to managing highly diverse and widely distributed IT infrastructures. They are open solutions that enable lifecycle integration of client, handheld, server, network and other IT assets with audit-ready security and automated operation. below are the modules it has inside. Asset Management Suite Backup Exec System … Read more

Single system required Patch’s report from SQL

by

—Single system required Patch’s report from SQL   SELECT DISTINCT SYS.Name0 AS [Machine Name], UCS.Status AS [Patch Status Code], CASE WHEN UCS.Status = ‘2’ THEN ‘Applicable’ WHEN UCS.Status = ‘3’ THEN ‘Installed’ ELSE ” END AS ‘Patch Status’, UI.BulletinID, UI.ArticleID, UI.Title FROM v_R_System AS SYS LEFT OUTER JOIN v_Update_ComplianceStatusAll AS UCS ON SYS.ResourceID = UCS.ResourceID … Read more

state messages for some reason is not being updated correctly Causes Updates Compliance Report Issue

by

run the below script to get the actual system state. this will help to report back actual compliance of patch level to SCCM Server   Option ExplicitOn Error Resume Next Call RefreshServerComplianceState ‘ WScript.Echo “Finished” Sub RefreshServerComplianceState()     ‘ Initialize the UpdatesStore variable.    dim newCCMUpdatesStore     ‘ Create the COM object.    set newCCMUpdatesStore = CreateObject … Read more

SCCM: Content Download to Cache Issues – 2008 / 2008 r2 / IIS 7 and IIS 7.5 and Webdav Issues

by

Issue The issue that was reported to me was that the content was not downloading. My datatransferservice.log, my CAS.log, and ContentTransferManager.log all looked good. The client found a local DP to download the content from. However when I looked at my cache folder, I saw that only a couple of MB of data was downloaded … Read more

BITS Local Policy for Clients : Like WSUS Policy for Easy Bandwidth Throttling

by

SMSUtils has a great tool to audit and report on your BITS 2.0 settings for your SMS 2003 Advanced Clients.  You can download the tool from here: https://www.smsutils.com/CommunityDownloads/tabid/58/Default.aspx Here is some background information that I wrote up about the tool a few months ago: BITS (binary intelligent transfer service) is the technology that SMS uses … Read more

Configuring SCCM and Branch Cache

by

Configuring SCCM and Branch Cache Branch cache is a feature introduced with Windows 2008 R2 that allows systems within the same subnet and separated from a content source (such as a WSUS server) to share downloaded content locally rather than each system having to traverse a latent network link back to the content source. Branch … Read more