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