Ran in to a project today where I had to revisit the old LDAP query.

ADUC Advanced Custom Search Results

Here are some useful links:

LDAP Query Basics

https://technet.microsoft.com/en-us/library/aa996205%28EXCHG.65%29.aspx

· Doing a Search Using Active Directory Users and Computers

Search Filter Syntax
http://msdn2.microsoft.com/en-us/library/aa746475.aspx

Famous LDAP Filters for Active Directory Environments

http://www.ldapexplorer.com/en/manual/109050000-famous-filters.htm

How to search and find user accounts in Active Directory

http://www.selfadsi.org/extended-ad/search-user-accounts.htm

Using Ldp.exe to Find Data in the Active Directory

https://support.microsoft.com/en-us/kb/224543

How to Create Custom Active Directory LDAP Searches

http://blogs.msdn.com/b/muaddib/archive/2011/10/24/active-directory-ldap-searches.aspx

 

More…

How Can I Get a List of All the Users Whose Passwords Never Expire with PowerShell?

http://blogs.technet.com/b/heyscriptingguy/archive/2005/08/29/how-can-i-get-a-list-of-all-the-users-whose-passwords-never-expire.aspx

LDAP/AD Claims Provider For SharePoint 2013

http://ldapcp.codeplex.com/

Tags: | Categories: Database | Tips and tricks

The SharePoint Config log DB can grow quite large!

The following way can help you shrink the config databases. But do only use these in test or development enviroments!

SharePoint 2010 on SQL 2008 R2

  1. Right click on you DB -> Properties
  2. Select Options
  3. Change the Recovery Model to SIMPLE and Click Ok
Once that is done ,
-Right click on DB -> Tasks - > Shrink -> Files
- In File type select log and click OK
 
Note : Simple recovery model is not suggested for Production Systems
 

SharePoint 2007 on SQL 2005

Make two new Queries

BACKUP LOG [Sharepoint_Config] WITH TRUNCATE_ONLY
USE [SharePoint_Config]
GO
 

DBCC SHRINKFILE (N’SharePoint_Config_log’ , 50)
GO



Tags: , , | Categories: Database | SharePoint Development
To create the asp.net membership database, please follow the steps below.
 
  1. Find the setup file aspnet_regsql.exe located at either of the following locations depending upon your OS:
    %windir%\Microsoft.NET\Framework\v2.0.5027
    %windir%\Microsoft.NET\Framework64\v2.0.5027
  2. When the ASP.NET SQL Server Setup Wizard appears, select “Configure SQL Server for application services”, then click Next
  3. Enter the SQL Server and Database name.
     
  4. Click Next and Finish

  To run the command line version of aspnet_regsql.exe, you need to open a command prompt and run this command, which will create the proper database tables for the membership database.
-- To use SQL Server credentials (a UserID and Password), use:

aspnet_regsql.exe -S <server> -U <login id> -P <password> -d <database> -A all
Tags: , , | Categories: Database | Tips and tricks | Web development