Year: 2010

SCCM: Collection Query to get all machines who haven’t rebooted in X amount of Days

May 13, 2010

Here's a query that I use to see all machines who haven't rebooted in 7 days. You can change the 7 to however many days you want. 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 inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where DATEDIFF(DD, SMS_G_System_OPERATING_SYSTEM.LastBootUpTime, GETDATE()) > 7

SCCM: How to Determine Content Download to Cache Issues

May 12, 2010

Over the past couple of days I've been fighting with an application that a 3rd party vendor packaged for us. The package in question is an MSI that calls numerous other files. In total, the package has over 3000 files and is about 180 MB in size. Issue The issue that was reported to me…
Read more

SCCM: Program failed (download failed – content mismatch) for advertisement failures

May 11, 2010

Today I was noticing on a few of our advertisements that all of our machines in the collection had received the "Program failed (download failed - content mismatch)" failure message. Upon receiving this error message, I came across a blog post by Matthew Boyd that referred to the following: Binary Differential Replication – If this…
Read more

Windows 7 System Image Recovery: How to Deal with error 0x80042412

March 20, 2010

So tonight my hard drive in my home theater PC decided it was a good time to crash during a movie the girlfriend and I were watching. I heard a whirr, some nasty scratching, and a few minutes later the screen just went blank. After taking the machine apart, the drive wouldn't power up, it…
Read more

Tech Support and Social Media: It’s Comcastic!

January 30, 2010

We live in a society today that's "always on". People have mobile devices, laptops, desktops, HTPCs, etc. that are always connected to the internet and at the click of a button we can order an HDTV and have it shipped to our house within a few days. We never have to leave the house anymore…
Read more

©  2024 Richard Balsley. Built using WordPress and the Mesmerize Theme