How to create a report that lists the computers using a license for a specific plug-in.
Release: 8.5, 8.6
Use the following SQL query. Replace "patch" with the name of the plug-in.
selectvi.Name as Solution,convert( varchar(10),liu.CreatedDate, 101 ) as CreatedDate,convert( varchar(10),liu.ModifiedDate, 101 ) as ModifiedDatefrom LicenseInUse liujoin vItem vi on vi.Guid = liu.LicensingPolicyGuidjoin vitem vc on vc.Guid = liu.ResourceGuid