Wednesday 27 November 2013

SQL Script to pull Group Name and Group ID

Login to the SQL Server and expand the databases and click the database.

Click New Query & Paste the below query

SELECT  Name, NameAndDescriptionInstanceId as 'GroupId' 
      FROM BASLocaleNamesAndDescriptions 
      WHERE NameAndDescriptionTypeId = 7 
      AND PlugInId = 0
      AND Locale = 'en_US'

Click Execute

From the results you can copy the information of Group Name and Group Id.

No comments:

Post a Comment