Linux Agent Reports

Does anyone have a good SQL query or SCOM query to report on how many Unix Agents or Unix Agent health at all? Everything built in only reports on Windows

Here is one regarding Number of Unix agents:

SELECT COUNT(*) AS NumManagedComps 
FROM (SELECT bme2.BaseManagedEntityID 
FROM BaseManagedEntity bme WITH (NOLOCK) INNER JOIN BaseManagedEntity bme2 WITH (NOLOCK) ON bme2.BaseManagedEntityID = bme.TopLevelHostEntityID WHERE bme2.IsDeleted = 0 AND bme2.IsDeleted = 0 AND bme2.BaseManagedTypeID = (SELECT TOP 1 ManagedTypeID 
FROM ManagedType WHERE TypeName = 'microsoft.unix.computer') 
GROUP BY bme2.BaseManagedEntityID ) AS Comps

is there an easy way to change this query to show the display names of those agents?

SELECT *
FROM (SELECT bme.BaseManagedEntityId, bme.path, bme.name --bme2.BaseManagedEntityID bme2.DisplayName, bme.name,
FROM BaseManagedEntity bme WITH (NOLOCK) INNER JOIN
BaseManagedEntity bme2 WITH (NOLOCK) ON bme2.BaseManagedEntityID = bme.TopLevelHostEntityID
WHERE bme2.IsDeleted = 0 AND bme2.IsDeleted = 0 AND bme.Name IS NULL AND bme.FullName LIKE ‘%OperatingSystem%’ AND bme2.BaseManagedTypeID = (SELECT TOP 1 ManagedTypeID
FROM ManagedType WHERE TypeName = ‘microsoft.unix.computer’)
GROUP BY bme.BaseManagedEntityId, bme.path, bme.name ) AS Comps