Need a report containing list of assets having no managed account
Page 1 / 1
Hi,
You can either open a ideia to create such report or use API to collect this information and transform in a csv
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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.