Month: August 2008

PCs with the no logon information for 30 days

SELECT distinct CS.Name0 AS ‘Computer’, isnull(CS.UserName0,HCS.UserName0) AS ‘User Name’ , CS.TimeStampFROM v_GS_COMPUTER_SYSTEM CS Left outer join v_HS_COMPUTER_SYSTEM HCS on CS.ResourceID = HCS.ResourceID WHERE HCS.UserName0 is not NULL and datediff(dd,CS.TimeStamp,getdate()) > 30Group by CS.Name0, CS.UserName0, CS.TimeStamp, HCS.UserName0order by CS.Name0

Free Exam Stuff

There is lots of legal study material out there. Here is just is some of it. Yes, in some cases you do have to sign up to get access to the free stuff but what do you expect these companies do need to make a living too. BTW if you want to confirm that website […]

70-649 stuff

As you know I’m working on my 70-649 Exam, Why not passing one exam give me three certifications! MCTS: Windows Server 2008 Active Directory, Configuring MCTS: Windows Server 2008 Network Infrastructure, Configuring MCTS: Windows Server 2008 Applications, Configuring Anyways.. Here are a few things that you should know. Do you only have one chance at […]