How do I get the ParentID from a single API request?

[mitch_reid]

I have a machine name and I'd like to get its ParentID.  I tried:

https://epo-server/remote/core.executeQuery?target=EPOLeafNode&select=(select EPOComputerProperties.ParentID)&where=(where eq (EPOComputerProperties.ComputerName 'COMPUTER'))

I know I'm not using the correct syntax for the where statement. Any suggestions?   Thanks.

[Former Member · Accepted solution]

The two things I see there are:

1)  the parent ID of the computer properties table is the EPOLeafNode AutoID; so it would make more sense to select EPOLeafNode.AutoID directly

2) I think you just have to use double quotes around the computer name (double quotes worked for me but singles didn't).

Try this:

<pre>https://localhost:8443/remote/core.executeQuery?target=EPOLeafNode&select=(select EPOLeafNode.AutoID EPOComputerProperties.ComputerName)&where=(where(eq EPOComputerProperties.ComputerName "COMPUTERNAME"))</pre>

Jon

[mitch_reid]

That's it!  Thanks.