How to Extract Orion Server using Powershell?

DaveW1501

Hi All,
Be nice - 1st post!
I'm relatively new to using the swispowershell cmdlets so stumbling around a bit. Is it possible to extract a list of the servers in our deployment & what role they play, if any? For example:
Hostname IPAddress HARole HAPool

AI has helped me build out this query but it's not returning non-pool, members.

SELECT
p.DisplayName AS PoolName,
pm.HostName,
pm.PoolMemberType,
CASE
WHEN p.PoolMasterMemberId = pm.PoolMemberId
THEN 'ACTIVE'
ELSE 'STANDBY'
END AS Status,
p.PoolType
FROM Orion.HA.Pools p
JOIN Orion.HA.PoolMembers pm
ON p.PoolId = pm.PoolId
ORDER BY p.DisplayName, Status DESC
"@

Any help much appreciated.

Lofstrand

Hi @DaveW1501

I don't have any HA pools in my lab, but hopefully below SWQL will give you the info you need

SELECT 

    S.ServerType

    ,S.HostName

    ,S.Node.IP_Address

    ,S.PoolMember.PoolMemberType

    ,ISNULL(S.PoolMember.Pool.DisplayName,'-') AS [HA Pool]

    ,CASE

        WHEN S.PoolMember.Pool.PoolMasterMemberId = S.PoolMember.PoolMemberId THEN 'Active'

        WHEN S.PoolMember.Pool.PoolMasterMemberId IS NULL THEN '-'

        ELSE 'Standby'

    END AS [HA Status]

FROM Orion.OrionServers AS S