License Report

Lambert asked a question.

June 6, 2019 at 7:00 AM

License Report

Dear SNOW Community,

i would like to have an "All Licenses" report with the following additional information

- active Maintenance Period or last maintenance period (should be the last item in the list)

- Documents - Title and URL (link to file) of the first item in the list

- Assignment Type

maybe somebody created this query already!

Thank you!

Kind regards

Lambert

markus.metzger@benteler.com
7 years ago
Hello Lambert here is a first try: Select org . FriendlyName , appl . Name , lic . LicenseID , lic . LegalLicenseCount , lic . Metric , lic . PurchaseDate , lic . InvoiceReference , doc . Title from tbllicense as lic left join tblOrganization as org on lic . LegalOrgChecksum = org . OrgChecksum left join tblApplication as appl on lic . ApplicationID = appl . ApplicationID right join tbldocuments as doc on lic . LicenseID = doc . ParentID based on report "Maintenance and Support overview" This shows licenses with documents only (RIGHT JOIN) - otherwise use LEFT JOIN url cannot be provided as document is stored in the DB as blob (in our installation) Best regards Markus
Expand Post
- markus.metzger@benteler.com
  7 years ago
  Sorry I forgot the maintenance part: Select org . FriendlyName , appl . Name , lic . LicenseID , lic . LegalLicenseCount , lic . Metric , lic . PurchaseDate , lic . InvoiceReference , maint . PeriodFrom , maint . PeriodTo , maint . MaintenanceCost , doc . Title from tbllicense as lic left join tblOrganization as org on lic . LegalOrgChecksum = org . OrgChecksum left join tblApplication as appl on lic . ApplicationID = appl . ApplicationID left join tblMaintenancePeriod as maint on lic . LicenseID = maint . LicenseID right join tbldocuments as doc on lic . LicenseID = doc . ParentID
  Expand Post
carolai
7 years ago
Hi all, Did you notice, that Snow changed a lot of reports and added a lot of columns. Lambert did you already check the new All Licenses report (SLM 9.2.1). I think you nearly can find all information you want know. like Assignment type, maintenance period, and at least a checkmark if a document is attached or not (but not the document path and name) Perhaps that may also help
Expand Post

Related Product Forums

→ Flexera One

→ Snow Atlas

→ FlexNet Manager

→ Snow License Manager

→ App Broker

Need help finding an answer?

Ask a Question →

License Report