I am trying to use powershell to look for all database servers inside a resource group. I don't have the server name to pass in, I want to query for it but get-azsqlserver isn't working unless I pass in the servername.
If I run get-azsqlserver without a server name none of my SQL Servers come up. If I specify the server name, it comes up. ( Examples 1 and 2 in the picture)
If I pass in the ResourceID found from get-azsqlserver into get-azresource, it comes up fine. If I don't pass it in, it doesn't come up at all.
Could anyone show me a link or steps to query all database servers within a resource group?