Kaseya Audit - Software licence

Follow

With this Query, you'll grab all software licence information grabbed by Kaseya. You can then make gauge for Microsoft Office counts and version, list server licences and more.

SELECT DISTINCT

vLicenseInfo.agentGuid AS 'agentGuid',

vLicenseInfo.ComputerName AS 'Computer Name',

vLicenseInfo.GroupName AS 'GroupName',

vLicenseInfo.Publisher AS 'Publisher',

vLicenseInfo.ProductName AS 'Product Name',

vLicenseInfo.LicenseCode AS 'License Code',

vLicenseInfo.ProductKey AS 'Product Key',

vLicenseInfo.LicenseVersion AS 'License Version',

vLicenseInfo.InstallDate AS 'Installation Date',

vLicenseInfo.OperatingSystem AS 'Operating System',

vLicenseInfo.OperatingSystemVersion AS 'Operating System Version',

vLicenseInfo.loginName AS 'Login Name',

vLicenseInfo.lastLoginName AS 'last Login Name',

vLicenseInfo.partitionId AS 'Partition Id',

CASE

WHEN ((vLicenseInfo.OperatingSystem = 'Windows 2000' and vLicenseInfo.OperatingSystemVersion not like 'Professional%') OR vLicenseInfo.OperatingSystem = 'Windows 2003' OR vLicenseInfo.OperatingSystem = 'Windows 2008' OR vLicenseInfo.OperatingSystem = 'Windows 2012') THEN 'Server'

ELSE 'Workstation'

END AS 'Machine Type'

FROM vLicenseInfo INNER JOIN vMachine ON vLicenseInfo.agentGuid = vMachine.agentGuid

INNER JOIN machGroup mg ON mg.orgFK = {client_service_id} AND mg.reverseName = vMachine.groupName

Happy Reporting !