Month: September 2008

WQL – PCs with more that 2 GB free on C:

select distinct     SMS_R_System.Name,     SMS_G_System_LOGICAL_DISK.* from      SMS_R_System inner join SMS_G_System_LOGICAL_DISK on SMS_G_System_LOGICAL_DISK.ResourceID = SMS_R_System.ResourceId where     SMS_G_System_LOGICAL_DISK.FreeSpace > 2048     and SMS_G_System_LOGICAL_DISK.DeviceID = “C:” order by     SMS_R_System.Name

IP History

SELECT     CS.Name0,     HNAC.TimeStamp,     HNAC.DefaultIPGateway0,     HNAC.DHCPServer0,     HNAC.DNSDomain0,     HNAC.DNSHostName0,     HNAC.IPAddress0,     HNAC.IPSubnet0,     HNAC.MACAddress0,     HNAC.ServiceName0FROM     dbo.v_GS_COMPUTER_SYSTEM CS,     dbo.v_HS_NETWORK_ADAPTER_CONFIGUR HNACWHERE     HNAC.ResourceID = CS.ResourceID     and HNAC.DHCPEnabled0 = 1    and HNAC.IPAddress0 != ‘NULL’    and HNAC.IPAddress0 != ‘’Order by    CS.Name0,     HNAC.TimeStamp

What is Goal 8?

Well, this morning I passed this exam 70-652 and this put me one step closer to becoming a “Microsoft Certified Non-Professional in AOS: Server Virtualization”! I hope they change the title of that certification! Well I have set a personal target of passing 15 exams by Dec 10th 2008, that date will be 1 year […]

More free training for 70-652, 70-403, & 70-643

  Free virtualization e-learning collection Take Microsoft E-Learning Collection 6333: Exploring Microsoft Virtualization Technologies for free! Collection 6333 includes the following: • Clinic 5935: Introducing Hyper-V in Windows Server 2008 • Clinic 6334: Exploring Microsoft System Center Virtual Machine Manager 2008 • Clinic 6335: Exploring Microsoft Application Virtualization • Clinic 6336: Exploring Terminal Services in […]

70-640 Week 17 Q&A

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