migrating from ePO to PMC to manage endpoints.
We have a requirement to integrate PMC solution with in-house end-point compliance Dashboard.
The tool is used to measure compliance of various tools with agent component installed across end-points, by querying solution specific Database.
Till date we are using McAfee ePO specific tables to fetch production compliance of Avecto agent & pass it to EPC system.
For the new integration we have following requirements:
Show agent & adapter version installed against active & authorized end-point(s)
show only authorized system(s) ignoring Deactivated/Pending authorization systems.
As I refer Management Database, above mentioned information is unavailable in single table. It’s listed as:
dbo.agenthost – Agent & adapter version details are available
dbo.agent – Shows deactivated/authorization status of machine(s)
With above mentioned integration requirement, need to understand whether we need to join these 2 tables to create Query OR is there any other single table/view already available to get all the information I mentioned.