You don't really need a custom query. Open Powershell on any DC, or Windows computer that has the RSAT feature installed, and run:
Get-ADComputer -Filter *
To expand on your PoSh:
Get-ADComputer -filter {operatingsystem -like “*Novell*”} -properties operatingsystem
That’s assuming the system is running a Novell OS and is joined to the domain.
You could also go into the Schema Admin and look for attributes and classes related to Novell. Or use a PoSh one-liner:
Get-AdObject -filter {name -like “*Novell*”} -searchBase “CN=Schema,CN=Configuration,dc=contoso,dc=com”
Most migrations don’t carry over Novell-based attributes unless they’re needed. I manage a forest that was migrated from a Novell environment, and aside from some old IDM service accounts I can’t decommission for one reason or another, there’s no trace of Novell left.
Roger that