Powershell cmdlet that lists all agents with online/offline status

Mattias_Canberger

I would like to have a powershell cmdlet that lists all SQL Clone agents and their status (online/offline) much like the one you can get from the Server interface. Is that possible to do with the current cmdlets? I can't find a way to do that

RichardMacaskill

Appreciate the suggestion Mattias. We had a user story around 'more reporting, visibility of state', which we've added this to, and this will help us guide the prioritisation. Can I ask how you would use that cmdlet? Is it for a report or as part of a larger workflow?
thanks
Richard (Product Manager for SQL Clone)

Mattias_Canberger

I'm creating a simple application where people can handle their own clones. (creating, removing, refreshing etc).
For this application I'm relying on the cmdlets that you provide and I would like to have a check that the agent is online before trying to run a create or remove on a clone on that agent.
A work around I'm using right now is to check the state of the SQL Clone Agent-service using SQL (exec xp_servicecontrol).
Since I'm already querying the destination SQL Server, this was an easy work around, but a bit ugly.

ChrisHurley

Thanks for your feedback, and it's great to see that you're getting value out of SQL Clone in this way.

This does make sense, and it's something that we're interested in implementing soon. We do also have potential future plans to make our .NET client library available to help with building your own clients for SQL Clone - while we don't have an ETA for this, it would be great to get your thoughts on it.

ErdoganOzkoca

Hi Mattias,

Thank you for your feedback. A new powershell cmdlet (Get-SqlCloneMachine) has been implemented and released in version SQL Clone 2.3.
Get-SqlCloneMachine returns the details of machines from SQL Clone Server. You can get the details of cmdlet here.

Mattias_Canberger

Excellent!
Thank you

Mattias_Canberger

I just upgraded and tested the new cmdlet. Great work! :-)