How to identify clients with a specific module or feature active on their license

The following script must be run on the SWLM database on the developer server!

/****** Script for identifying list of clients with a specific module licensed ******/ --- fields you want returned --- Select [Id] ,[ClientId] ,[DatabaseName] ,[SetupDateUtc] ,[ServerIpAddress] ,[InstanceUrl] ,[InstanceVersion] ,[HardwareKey] ,[SpaceLimit] ,[IsUnlimited] ,[ExpiryDateUtc] ,[LicenseKey] ,[SynergyAppCode] ,[ExpirationNotificationPeriod] ,[CreatedAtUtc] ,[UpdatedAtUtc] ,[CreatedBy] ,[UpdatedBy] ,[LastLicenseKeyChangedDate] ,[LastLicenseKeyPropagatedDate] ,[LastPropagatedLicenseKeyStamp] ,[LicenseKeyStamp] ,[ExpiryStatus] ,[IsLatestKeyAppliedToClient] ,[LicenseType] ,[IsEasyClocking] FROM [WebLicenseManager].[dbo].[Licenses] Where [Id] IN --- This gives the ID of the licenses with cascade replace name with whatever module you are searching for--- (SELECT LicenseId FROM [WebLicenseManager].[dbo].[LicenseModulesAndLimitsInLicenses] where [LicenseModuleId] IN (SELECT [Id] FROM [WebLicenseManager].[dbo].[LicenseModules] where name = 'Cascade (UK)') ) order by DatabaseName; --- Save results sorted by the name of the database (usually the clients name) ---