User profile for Mattias_Canberger

Thanks. Will have a look at it after our next upgrade / comments

Thanks. Will have a look at it after our next upgrade

0 votes

Or even better, add all meta data regarding images, clones, agents etc to all Get-cmdlets :-) / comments

Or even better, add all meta data regarding images, clones, agents etc to all Get-cmdlets :-)

0 votes

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

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

0 votes

Excellent! Thank you / comments

Excellent! Thank you

0 votes

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. [image] [image] / comments

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 t...

0 votes

I thik you can join to SourceLocation from Clones on Clones.LocationId = SourceLocation.Id to get the instance name. But I would recommend to use Powershell instead. / comments

I thik you can join to SourceLocation from Clones on Clones.LocationId = SourceLocation.Id to get the instance name. But I would recommend to use Powershell instead.

0 votes

This would give you pretty much what you are looking for: SELECT sl.Server AS ComputerName ,c.Name AS CloneName ,c.CreatedBy ,i.FriendlyName AS ImageName ,CAST(RIGHT(i.FriendlyName, 19) AS DATE) AS ImageDate FROM dbo.Clones AS c INNER JOIN dbo.Images AS i ON c.ParentImageId = i.Id INNER JOIN dbo.SourceLocations AS sl ON c.LocationId = sl.Id WHERE c.DeletedOn IS NULL ORDER BY sl.Server ,ImageDate ,c.Name / comments

This would give you pretty much what you are looking for: SELECT sl.Server AS ComputerName ,c.Name AS CloneName ,c.CreatedBy ,i.FriendlyName AS ImageName ,CAST(RIGHT(i.FriendlyName, 19) AS DATE) AS...

0 votes

I suspect you ignored this ",CAST(RIGHT(i.FriendlyName, 19) AS DATE) AS ImageDate" :-) We name our images on a special format and include the date in the image name / comments

I suspect you ignored this ",CAST(RIGHT(i.FriendlyName, 19) AS DATE) AS ImageDate" :-) We name our images on a special format and include the date in the image name

0 votes

Hmm. ImageState doesn't work and I can't find any documenation on RedGate.SqlClone.Client.Api.Objects.ImageResource that the documentation refers to / comments

Hmm. ImageState doesn't work and I can't find any documenation on RedGate.SqlClone.Client.Api.Objects.ImageResource that the documentation refers to

0 votes

Found it. Image.State works Thanks Intellisense :-) / comments

Found it. Image.State works Thanks Intellisense :-)

0 votes

How can we help you today?

Mattias_Canberger

Comments