John a local Visio MVP, sent me a note about Visualizing Operations Manager Data in Visio Services, check it out.
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?
Join dbo.v_GS_COMPUTER_SYSTEM CS on CS.ResourceID = NAC.ResourceID
IPAddress0 like '%:%'
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'
end as 'PC Type',
Count(v_GS_SYSTEM_ENCLOSURE.ChassisTypes0) AS 'Total'