Skip to main content

Need a report containing list of assets having no managed account

Hi, 

 

You can either open a ideia to create such report or use API to collect this information and transform in a csv


@Chitta2019 Is this on-prem Password Safe? If so, the following SQL query will provide this information:

USE RetinaCSDatabase
GO

SELECT ms.ManagedSystemID, ms.Name
FROM pmm.PmmManagedSystem ms
WHERE ms.ManagedSystemID NOT IN (
    SELECT DISTINCT ma.ManagedSystemID
    FROM pmm.PmmManagedAccount ma
);

 


Hi ​@droache It’s SAAS based


Reply