SMSUG.ca

...your virtual communITy
Welcome to SMSUG.ca Sign in | Join | Help
in Search

Garth Jones

May 2010 - Posts

  • Visualizing Operations Manager Data in Visio Services

    John a local Visio MVP, sent me a note about Visualizing Operations Manager Data in Visio Services, check it out.

     

    http://blogs.msdn.com/b/visio/archive/2010/05/26/visualizing-operations-manager-data-in-visio-services.aspx

    Digg This
    Posted May 27 2010, 09:15 PM by Garth with 1 comment(s)
    Filed under: ,
  • Free MS SQL 2008 administrator certification

    Now that I have your attention, every SMS / ConfigMgr administrator needs to know SQL in order to support SMS/ ConfigMgr. There are no “Ifs” “ands” or “buts” about it, without SQL, ConfigMgr / SMS could not run. You could not write reports or use SSRS. Neither MDT nor WSUS work without it either.  So without SQL there is no ConfigMgr / SMS /v.Next / CM11! Therefore you MUST know SQL at least from an administrator stand point and should be certified in it.

     

    So how can you get certified? There are a number of ways: take 70-431 (SQL 2005) or 70-432 (SQL 2008) or you can take the free certification from BrainBench.

     

    Yes, I did say free SQL 2008 administration certification. Brainbench has a number of free certifications http://brainbench.com/xml/bb/common/testcenter/freetests.xml, one of which is SQL 2008 Administrator.

     

    SQL is the backbone of ConfigMgr / SMS, heck even OpsMgr, MOM, SCSM, DPM, SCVMM, and SCE all use it. There is no excuse why you should not be at least BrainBench certified in SQL 2008, it’s free! What is stopping you? What is your excuse for not taking this certification?

    Digg This
  • PCs with IPv6 Address

    select
        CS.Name0,
        NAC.IPAddress0
    from
        dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC
        Join dbo.v_GS_COMPUTER_SYSTEM CS on CS.ResourceID = NAC.ResourceID
    Where
        IPAddress0 like '%:%'

    Digg This
    Posted May 13 2010, 05:31 PM by Garth with 1 comment(s)
    Filed under: , , , ,
  • Chassis type

    SELECT
    Case v_GS_SYSTEM_ENCLOSURE.ChassisTypes0
    when '1' then 'Other'
    when '2' then 'Unknown'
    when '3' then 'Desktop'
    when '4' then 'Low Profile Desktop'
    when '5' then 'Pizza Box'
    when '6' then 'Mini Tower'
    when '7' then 'Tower'
    when '8' then 'Portable'
    when '9' then 'Laptop'
    when '10' then 'Notebook'
    when '11' then 'Hand Held'
    when '12' then 'Docking Station'
    when '13' then 'All in One'
    when '14' then 'Sub Notebook'
    when '15' then 'Space-Saving'
    when '16' then 'Lunch Box'
    when '17' then 'Main System Chassis'
    when '18' then 'Expansion Chassis'
    when '19' then 'SubChassis'
    when '20' then 'Bus Expansion Chassis'
    when '21' then 'Peripheral Chassis'
    when '22' then 'Storage Chassis'
    when '23' then 'Rack Mount Chassis'
    when '24' then 'Sealed-Case PC'
    else 'Undefinded'
    end as 'PC Type',
    Count(v_GS_SYSTEM_ENCLOSURE.ChassisTypes0) AS 'Total'
    FROM
    v_GS_SYSTEM_ENCLOSURE v_GS_SYSTEM_ENCLOSURE
    GROUP BY
    v_GS_SYSTEM_ENCLOSURE.ChassisTypes0
    Order by
    'PC Type'

    Digg This
    Posted May 12 2010, 06:16 PM by Garth with 1 comment(s)
    Filed under: , , ,

This Blog

Syndication

News

Training

Powered by Community Server (Non-Commercial Edition), by Telligent Systems