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 HOWTO61268
Rate this Article
This is machine translated content
Login to Subscribe
Please login to set up your subscription.
Didn't find the article you were looking for? Try these resources.