Skip to content

Instantly share code, notes, and snippets.

@BrianMRO
Last active May 23, 2022 19:53
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save BrianMRO/be9ad997806d696cbdcb9bd76fae54e1 to your computer and use it in GitHub Desktop.
Save BrianMRO/be9ad997806d696cbdcb9bd76fae54e1 to your computer and use it in GitHub Desktop.
SQL Script - Get Default Mobile Site Map
/* NOTE: Replace [2022R1] with the name of YOUR database */
/* Right-Click the Table in MS SQL Server Mgmt Studio and select "Select Top 1000 Rows" */
SELECT TOP (1000) [CompanyID]
,[ScreenID]
,[Script]
,[Type]
,[CompanyMask]
,[CreatedByID]
,[CreatedByScreenID]
,[CreatedDateTime]
,[LastModifiedByID]
,[LastModifiedByScreenID]
,[LastModifiedDateTime]
,[RecordSourceID]
FROM [2022R1].[dbo].[MobileSiteMap];
/* Trim the script to just the Script column */
SELECT TOP (1000) [Script]
FROM [2022R1].[dbo].[MobileSiteMap]
Where [CompanyID] = 1
@BrianMRO
Copy link
Author

Be sure to replace [2022R1] with the name of your own database!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment