Posts

Showing posts from May, 2012

How to find the source of a locked out account in Windows Server 2008 R2 / Windows 7

Image
How to find the source of a locked out account in Windows Server 2008 R2 / Windows 7 Check in the DC, for event 4771 in the Security Log: From the Client Address, you found the source of the problem. Log into the client, check the event log/security log: Here you can see a stored password is causing the problem. Delete the entry from the Stored Passwords app (Control Panel/User Accounts/Manage my network passwords).

SQL query for SCCM 2007 R2 to find all Dell desktops and laptops

My colleague wrote a SQL query for SCCM 2007 R2 that finds all the Dell desktops and laptops in our environment. select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System   INNER JOIN SMS_G_System_COMPUTER_SYSTEM   ON SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId  WHERE SMS_R_System.NetbiosName NOT LIKE "SR%"   AND SMS_R_System.Active = 1  AND SMS_G_System_COMPUTER_SYSTEM.Manufacturer00 like "%Dell%"