AnsweredAssumed Answered

SQL Query to get license information

Question asked by ITSO-AS Advocate on Mar 29, 2019
Latest reply on Mar 29, 2019 by MarcoCambon



Since it's not possible to automatically send an alert per mail to the right person if a license expires, I want to do this with Powershell. In order to do that, I need the following data from the Snow DB.

- License Application

- License Expiration Date

- Custom Fields

- All Snow Users with Name and E-Mali Address


Is there someone who knows an SQL Query to get these informations?


Thanks and kind regards,