-
-
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
-
-
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?
-
-
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 '%:%'
-
-
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'
