Report: To list all ACTIVE Package Servers

Article:HOWTO61270  |  Created: 2011-12-12  |  Updated: 2013-03-07  |  Article URL
Article Type
How To

Please use the following steps to create a custom Report

SMP Console > Reports > Custom Reports > Right Click > New > Report > SQL Report
Paste the following SQL query within Parameterised Query Section





-- All Package Servers registered with SMP as PS
select aaca._ResourceGuid, vcx.Name, vcx.[IP Address], aaca.[Agent Name],
aaca.[Product Version], aaca.[Build Number], aaca.[Install Path]
from Inv_AeX_AC_Client_Agent aaca (nolock)
inner join vComputerEx vcx on vcx.Guid = aaca._ResourceGuid
where aaca.[Agent Name] = 'Package Server' 
and aaca._ResourceGuid in (
select ra.ChildResourceGuid  from vRM_PackageService vPS
inner join ResourceAssociation ra on vPS.Guid = ra.ParentResourceGuid
where vPS.Deleted='0'

Related KB
Title: Report listing site servers where package services have failed to install

Article URL

Terms of use for this information are found in Legal Notices