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
Imported Document Id
This is machine translated content
Login to Subscribe
Please login to set up your
For security reasons, your link to this document has expired. Please click on the attachment link to access this file.
The attachment that you are looking for no longer exists.
There has been an issue retrieving your attachment. Please try again.
Currently server is down.
Didn't find the article you were looking for? Try these resources.