Skip to content

Instantly share code, notes, and snippets.

@klpatil

klpatil/active-collection.sql

Created July 21, 2019 05:20
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 klpatil/ddeb16028673a1565d2fafbda7f2a02c to your computer and use it in GitHub Desktop.
Save klpatil/ddeb16028673a1565d2fafbda7f2a02c to your computer and use it in GitHub Desktop.
Download ZIP
Active-Collection-SQL
Raw
active-collection.sql
SELECT TOP (1000) [ID
,[Key]
,[Value]
FROM [dbo].[Properties]
WHERE [Key] LIKE '%_RD00155D7621FD%' -- This is our Machinename
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment