I don't have a ready report but this information can be found in default filters/report, just need to know that:
1. Managed computer without Patch Agent installed ---/// Doesn't consume Patch License
SQL Query to see them from default "Windows Computers without Software Update Plug-in Installed" filter
select * from fnGetAllMachinesWithoutPatchAgentInstalled('%Windows%')
2) Managed computer with Patch Agent installed but with "Retired" status ---/// Doesn't consume Patch License
SQL Query to see them:
SELECT
[vri1_Computer].[Guid] AS [Guid]
FROM
[vRM_Computer_Item] AS [vri1_Computer]
LEFT OUTER JOIN [Inv_AeX_AC_Client_Agent] AS [dca2_AeX AC Client Agent]
ON ([vri1_Computer].[Guid] = [dca2_AeX AC Client Agent].[_ResourceGuid])
LEFT OUTER JOIN ([ScopeMembership] AS [ajs3_ScopeMembership]
LEFT OUTER JOIN [FolderBaseFolder] AS [ajs4_FolderBaseFolder]
ON ([ajs3_ScopeMembership].[ScopeCollectionGuid] = [ajs4_FolderBaseFolder].[FolderGuid]))
ON ([vri1_Computer].[Guid] = [ajs3_ScopeMembership].[ResourceGuid])
INNER JOIN [vAC_AssetStatus] AS [ajs5_vAC_AssetStatus]
ON ([vri1_Computer].[Guid] = [ajs5_vAC_AssetStatus].[Guid])
WHERE
(
(
([ajs4_FolderBaseFolder].[ParentFolderGuid] = N'91c68fcb-1822-e793-b59c-2684e99a64cd')
AND
([vri1_Computer].[IsManaged] = 1)
AND
([ajs5_vAC_AssetStatus].[Asset Status] = '492c463b-afa2-4dd6-ae73-6fd2c7b0e489')
AND
(LOWER([dca2_AeX AC Client Agent].[Agent Name]) LIKE '%' + N'%software update%' + '%')
)
)
3) Managed computer with Patch Agent installed and are with "Active" status ---/// Currently consumes Patch License
SQL Query to see them:
SELECT
[vri1_Computer].[Guid] AS [Guid]
FROM
[vRM_Computer_Item] AS [vri1_Computer]
LEFT OUTER JOIN [Inv_AeX_AC_Client_Agent] AS [dca2_AeX AC Client Agent]
ON ([vri1_Computer].[Guid] = [dca2_AeX AC Client Agent].[_ResourceGuid])
LEFT OUTER JOIN ([ScopeMembership] AS [ajs3_ScopeMembership]
LEFT OUTER JOIN [FolderBaseFolder] AS [ajs4_FolderBaseFolder]
ON ([ajs3_ScopeMembership].[ScopeCollectionGuid] = [ajs4_FolderBaseFolder].[FolderGuid]))
ON ([vri1_Computer].[Guid] = [ajs3_ScopeMembership].[ResourceGuid])
INNER JOIN [vAC_AssetStatus] AS [ajs5_vAC_AssetStatus]
ON ([vri1_Computer].[Guid] = [ajs5_vAC_AssetStatus].[Guid])
WHERE
(
(
([ajs4_FolderBaseFolder].[ParentFolderGuid] = N'91c68fcb-1822-e793-b59c-2684e99a64cd')
AND
([vri1_Computer].[IsManaged] = 1)
AND
([ajs5_vAC_AssetStatus].[Asset Status] = '0a0203a5-d2b6-49f1-a53b-5ec31a89437c')
AND
(LOWER([dca2_AeX AC Client Agent].[Agent Name]) LIKE '%' + N'%software update%' + '%')
)
)
Regards,
IP.