-
-
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 r
where
R.ResourceID not in (select
cs.resourceId
from
v_gs_computer_system cs)
Order by
R.Netbios_Name0
-
-
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 | |
-
-
SELECT
CS.Name0,
CS.UserName0,
BIOS.Manufacturer0,
BIOS.SerialNumber0
FROM
dbo.v_GS_COMPUTER_SYSTEM CS,
dbo.v_GS_PC_BIOS BIOS
WHERE
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
ARP.DisplayName0,
ARP.ProdID0,
ARP.Publisher0,
ARP.Version0,
Count(ARP.ProdID0) AS 'Count'
FROM
dbo.v_Add_Remove_Programs ARP
GROUP BY
ARP.DisplayName0,
ARP.ProdID0,
ARP.Publisher0,
ARP.Version0
ORDER 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!!!
-
-
You can fake maintenance windows in SMS 2003 by setting the reoccurrence option and the advert expiry options. understand, this will NOT stop an advert from going over its allot time!
-
-
SELECT
CS.Name0,
CS.UserName0,
ISW.ProductName0,
ISW.VersionMajor0,
ISW.VersionMinor0,
ISW.Publisher0,
ISW.RegisteredUser0,
ISW.InstallDate0,
ISW.InstallSource0
FROM
dbo.v_GS_COMPUTER_SYSTEM CS,
dbo.v_GS_INSTALLED_SOFTWARE ISW
WHERE
ISW.ResourceID = CS.ResourceID
ORDER BY
ISW.InstallDate0 DESC,
CS.Name0,
CS.UserName0,
ISW.ProductName0
-
-
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
-
-
SELECT
CS.Name0,
HNAC.TimeStamp,
HNAC.DefaultIPGateway0,
HNAC.DHCPServer0,
HNAC.DNSDomain0,
HNAC.DNSHostName0,
HNAC.IPAddress0,
HNAC.IPSubnet0,
HNAC.MACAddress0,
HNAC.ServiceName0
FROM
dbo.v_GS_COMPUTER_SYSTEM CS,
dbo.v_HS_NETWORK_ADAPTER_CONFIGUR HNAC
WHERE
HNAC.ResourceID = CS.ResourceID
and HNAC.DHCPEnabled0 = 1
and HNAC.IPAddress0 != 'NULL'
and HNAC.IPAddress0 != '0.0.0.0'
Order by
CS.Name0,
HNAC.TimeStamp
-
-
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 from when I started to updating my certifications to Win2k3 and Win2k8. So with one more to go to meet that target now the question is which exam of my remaining exams should I write? 70-400, 646, 647, I’m toying with 70-656 exam too, 402 (if released), and 403 (when).
I am leaning towards 70-400 or 70-646.
Why 70-400 because I need to update my lab from MOM 2k5 to OpsMgr 2k7, this is a good excuse to do so.
Why 70-646 because I already have the MS press book and I have started to read it a bit.
So what do you think?
And yes the 15 exam goal was not the original goal, the goals were:
- ConfigMgr Exam and the TS: Windows Vista, Configuring exam (70-401 & 70-620)
- Add the Supporting and Troubleshooting Applications on a Windows Vista Client for Enterprise Support Technicians (70-622) to get MCITP: Enterprise Support Technician which allowed me to get my MCT
- But then I need to upgrade to MCSE so that I could teach the one class I wanted to teach Planning, Deploying and Managing Microsoft Systems Center Configuration Manager 2007 (6451A aka 70-401 exam) (70-290, 291, 293, 294 and 298) I got my MCSA Win2k3 at this point.
- Before completing Goal 3, I was asked to pass TS: Deploying and Maintaining Windows Vista Client and 2007 Microsoft Office System Desktops (70-624) for some contract work so I put 624 before 298
- Back to Goal 3 (70-298) and my MCSE for Win2k3
- After goal 3 was done it make seen to work on TS: Upgrading Your MCSE on Windows Server 2003 to Windows Server 2008, Technology Specialist (70-649)
- Since I bought a new server (new to me that is, I’m not that rich) I decide to do the TS: Windows Server Virtualization, Configuring (70-652) next
- Should it be 70-400, 70-646 or other and why?
-
-
lol sure I wouldn't mind becoming a How would you like to become a Microsoft Certified Non-Professional in AOS: Server Virtualization!
