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

Hi

 

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,

Benjamin

Outcomes