Hi all, I am struggling to find all windows/Linux/Unix machines managed by SCOM using SQL.
This list is to be actual servers and not DAG/Cluster/Aliaseses etc. but actual
Windows Server Operating machines along with UNIX and Linux Servers
So far I have:
select distinct a.[ActiveDirectorySite], a.NetworkName, c.[IsAvailable],
(SELECT distinct ManagedTypeView.Name
FROM ManagedEntityGenericView
INNER JOIN ManagedTypeView ON
ManagedEntityGenericView.MonitoringClassId = ManagedTypeView.Id
where ManagedTypeView.Name like 'Agent'
and ManagedEntityGenericView.DisplayName = a.NetworkName)as
IsAgentinstalled
FROM [MT_Computer] a
inner JOIN [MT_Computer] b
ON a.ActiveDirectorySite = b.ActiveDirectorySite
AND a.NetbiosComputerName <> b.NetbiosComputerName
inner JOIN ManagedEntityGenericView c
ON a.[BaseManagedEntityId] = c.Id
order by a.NetworkName
However it returns 3,301 rows of data in the SCOM Agent Manage view I have
3,156 I suspect it returning all the discovered nodes like clusters etc.
Can anyone help.
Peter Hakesley PJH2711-RIPE, CDCT, MBCS
SCC Services
Data Centre Operations - Service Implementation - Enterprise Systems Engineer
SCC Cole Valley 1,
20 Westwood Avenue,
Tyseley,
BIRMINGHAM B11 3RZ
Tel: +44 (0)845 351 0680 xtn 4006
eMail: [email protected]<mailto:[email protected]>
Web : www.scc.com<http://www.scc.com/>
[Description: Description: BCS_Logo]
<<inline: image001.jpg>>
