How can I find out which computers are running a specific plugin?

Products

• IT Management Suite
• Client Management Suite

Issue/Introduction

How to create a report that lists the computers using a license for a specific plug-in.

Environment

Release: 8.5, 8.6

Resolution

Use the following SQL query. Replace "patch" with the name of the plug-in.

select

vi.Name as Solution,

vc.Name,

convert( varchar(10),liu.CreatedDate, 101 ) as CreatedDate,

convert( varchar(10),liu.ModifiedDate, 101 ) as ModifiedDate

from LicenseInUse liu

join vItem vi on vi.Guid = liu.LicensingPolicyGuid

join vitem vc on vc.Guid = liu.ResourceGuid

where vi.Name like '%patch%'

order by vc.name asc