SCCM Computer GUID to Hostname report

Here is an SCCM report that can conver machine GUIDs to their hostname:

select * from v_R_System where v_R_System.SMS_Unique_Identifier0='GUID:45299371-2B3C-470B-8D5C-7C42BA1CD864'

Replace the GUID with your own and it should return your computer details.

EDIT: I just discovered something REALLY interesting! you can just enter into the all systems collection

GUID:45299371-2B3C-470B-8D5C-7C42BA1CD864

And it will return the computer in question, how cool is that? :)

SCCM Windows updates stuck in downloading state

This one is for my reference more than anything but im sure it will be of use to someone else. Here is how to fix the issue mentioned above (assuming boundaries etc are all ok)

1) Under the deployment package find the KB that is failing and delete it

2) Delete the KB from deployment management

3) Delete the KB from the update list

4) Update distribution points

5) Monitor the status messages until you see the MileStone "SMS distribution manager sucessfully Processed package"

6) Find the update in the update repository and drag to the update list (dont tick box to download)

7) Copy the update to deployment management and download the update again and add it to the correct deployment package.

8) Update the DPs and again wait for the same MileStone to appear

9) run a report and watch the number of sucessful installs begin to rise

I LOVE CAKE!!

Cakephp that is :)
check out http://cakephp.org/

It is basically a MVC oriented framework for buildiing PHP applications, I have been working with it the last few days and have to say it takes so much of the heavy lifting out of building a web based php app.

but what does it do I hear you ask?

well, how does creating your database, a few tables and then running a few commands sound to get yourself a skeleton app built automatically sound? too good to be true?

Thats what I though but get CakePHP and spend the time to learn it because once you do it is going to save you so much time!
Mad props to Larry Masters the creator of CakePHP for this wonderful framework, seriously why are you still reading? go get it!, now! ^_^