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,