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
Month: May 2010
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 […]
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 […]