Robert Marshall's Blog


Home for my ConfigMgr and Industry related ramblings


Owner of SMSMarshall Ltd, active Enterprise Management MVP

    • Thu, Mar 31 2011

    SQL query for Site servers and Site Systems

    Thought I'd blog this as an Aide mémoire more than anything. Determine which Site Systems are present in the Hierarchy select distinct ServerName as SiteSystems from v_SystemResourceList where servername not in (select servername from v_site) Notice that I'm referencing views and not tables here which is good practice when querying an SMS\ConfigMgr database.
    • Tue, Mar 29 2011

    ConfigMgr SP2 - Support for Win7 SP1 and W2K8 R2 SP1 platforms

    Microsoft released a patch that allows Win7 SP1 and W2K8 R2 SP1 to become valid recognised clients in ConfigMgr. As a patch, you request and download it, then apply to your Site servers and not to your Site systems. It modifies the entries in the Requirements tab of a Program so that these two platforms are included in the list of platforms available. These two new platforms will now show up when using the following...
    • Wed, Mar 23 2011

    ConfigMgr 2012 Beta 2 Public release has arrived

    After all this time waiting, we finally have a public of the Beta 2 build version. Check out the download here : The supported platforms document can be found here Manager 2012 Beta 2 Supported Configuration.pdf...
    • Fri, Mar 11 2011

    ZX81 - Way back ...

    I have vivid memories sitting in front of this computer: I owe a nod of appreciation towards Sir Clive Sinclair, this was the home computer that caught me in its headlights and put me on the path towards a career in IT (aided by a helpful Mum who saw the twinkle in my eye) ... I learnt to program and correct BASIC from mistyped computer listings, the first fumblings as...
    • Wed, Mar 2 2011

    HBGary - Hackery for the goverment

    Great article up on Ars Technica about the HBGary break-in and subsequent discovery of all their emails, this is pure geek at the lowest level, only clicky if you can handly some crazy crazy stuff!