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
Month: September 2008
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 […]
This weeks reading for the self study group is: 15.2 Configuring and Using Directory Certificate Services 28 55 16.1 Understanding and Installing Active Directory Rights 27
What is CRL?
What OU permission allows a user to “Create any OU valid object in the OU, including a sub OU”? Answer: Create All Child Objects Permission.
SELECT CS.Name0, CS.UserName0, BIOS.Manufacturer0, BIOS.SerialNumber0FROM dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_GS_PC_BIOS BIOSWHERE CS.ResourceID = BIOS.ResourceID AND BIOS.SerialNumber0=<Enter Serial Number here>
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
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
SELECT ARP.DisplayName0, ARP.ProdID0, ARP.Publisher0, ARP.Version0, Count(ARP.ProdID0) AS ‘Count’FROM dbo.v_Add_Remove_Programs ARPGROUP BY ARP.DisplayName0, ARP.ProdID0, ARP.Publisher0, ARP.Version0ORDER BY ARP.DisplayName0
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! http://www.microsoft.com/canada/awards/finalists_2008.mspx Let’s hope that they win this year!!!