Month: September 2008

Find all PCs with out any v_gs_Computer_System data

Use this query to find all PCs that don’t have any data within the v_GS_* views.  Right John… 🙂 select     R.Netbios_Name0,    R.* from     v_R_System rwhere     R.ResourceID not in (select                             cs.resourceId                         from                             v_gs_computer_system cs)Order by    R.Netbios_Name0

TechDays – Ottawa

v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);}     Buy your ticket to our first Tech·Days training event in your city Tech·Days: The rich learning experience of Tech·Ed, without the travel. You’ve probably heard of Tech·Ed, the annual technology education and networking conference on Microsoft-based technologies. Perhaps you’ve even attended. Now, we’re happy to […]

70-640 Week 17 Q&A Answer

What versions of Windows 2008 can be used to publish PKI certs to AD? Windows 2008 Web Windows 2008 Web Core Windows 2008 Standard Windows 2008 Standard Core Windows 2008 Enterprise Windows 2008 Enterprise Core Windows 2008 Datacenter Windows 2008 Datacenter Core Answer Windows 2008 Enterprise Windows 2008 Datacenter

Resently Installed Programs

SELECT     CS.Name0,     CS.UserName0,     ISW.ProductName0,     ISW.VersionMajor0,     ISW.VersionMinor0,     ISW.Publisher0,     ISW.RegisteredUser0,     ISW.InstallDate0,     ISW.InstallSource0FROM     dbo.v_GS_COMPUTER_SYSTEM CS,     dbo.v_GS_INSTALLED_SOFTWARE ISWWHERE     ISW.ResourceID = CS.ResourceIDORDER BY     ISW.InstallDate0 DESC,     CS.Name0,    CS.UserName0,    ISW.ProductName0

2008 IMPACT Awards Finalists

Congratulations to CTE Solution for being a finalist in this year’s “Learning Solution of the Year” they have been truly extraordinary in helping out the user group,  study groups and self-study groups!   Let’s hope that they win this year!!!