SELECT SL.CommonName, SL.CommonVersion, SL.CommonPublisher FROM v_LU_SoftwareList SL WHERE (SL.CommonName Like ‘%oracle%’) ORDER BY SL.CommonName
Month: July 2007
select type, count(type) as ‘count’ from v_SchemaViews group by type order by type
select viewname from v_SchemaViews where type = ‘inventory’ order by viewname
This stencil and template provided enable you to create Visio drawings that contain Exchange Server 2007 objects. These shapes include icons for Exchange 2007 server roles, networking, telephony and Unified Messaging objects, Active Directory and directory service objects, client computers and devices, and other Exchange organization elements. http://www.microsoft.com/downloads/details.aspx?FamilyID=45f7ea49-ceb2-4b04-8d46-2b0ae5e10694&DisplayLang=en So when will they produce a ConfigMgr […]
SELECT Distinct CS.Name0, CPU.CurrentClockSpeed0, CPU.MaxClockSpeed0 FROM v_GS_COMPUTER_SYSTEM CS, v_GS_PROCESSOR CPU WHERE CS.ResourceID = CPU.ResourceID AND CPU.REsourceID not IN (select ResourceID from v_GS_PROCESSOR CPU group by ResourceID having count(CPU.ResourceID) > 1) AND CPU.MaxClockSpeed0 < ‘1800’
select interfacetype0, count(interfacetype0) as ‘count’ from v_GS_DISK group by interfacetype0
BC Ferries is using Virtual Earth not only for maps, but when you click on the arrow icon, you can see the destination, heading, and speed! http://orca.bcferries.com:8080/cc/conditions/maps.asp
This question was asked yesterday “…The SiteSystem and SiteObject columns return data that looks like this: MSWNET:\\Server\Share\ What I expect to see, (what I see in the console) is this: \\Server\Share Can anyone point me in the correct direction?” Here is the answer Select replace (left(SiteSystem,charindex(‘MSWNET’,SiteSystem)-3),'[“Display=’,”), SiteCode, replace (left(SiteObject,charindex(‘MSWNET’,SiteObject)-3),'[“Display=’,”) as ‘Storage Object’, Role, cast (BytesTotal/1024/1024 […]
I’m not sure how this SQL task was created on only some of the site servers and not others, I could have created it myself however, for those that don’t have it. This is how you create it. From you SMS console: Drill down to “Site Database | <your site code> | Site […]