Comments
Sort by recent activity
Thanks for the response. But something in the users settings got out of wake. He did a reset default settings and everything started working as he expected. / comments
Thanks for the response. But something in the users settings got out of wake. He did a reset default settings and everything started working as he expected.
Sweet, thanks for that info. / comments
Sweet, thanks for that info.
I guess I could find and replace to remove the INSERT INTO and VALUES to nothing.
I actually just need the actual data in the () for what I am trying to accomplish.
So I ended up breaking it up. Do 1000, then sort desc and grab the extra 346 values. / comments
I guess I could find and replace to remove the INSERT INTO and VALUES to nothing.
I actually just need the actual data in the () for what I am trying to accomplish.
So I ended up breaking it up. D...
$redgateCloneURL = 'http://devclndbs01.exclaim-dev.com:14145'
Connect-SqlClone -ServerUrl $redgateCloneURL
$imagelist = Get-SqlCloneImage
$clonelist = Get-SqlClone
foreach ($name in $imagelist) {
$clonelist | Where-Object ParentImageId -EQ $name.Id | Select-Object @{Name="Image Name";Expression={$name.name}}, Name, State
}
$clonelist = Get-SqlClone
I put this code together. Do you know how I can return the located on server that the clone is hosted on? I could not figure out how to capture this server name. / comments
$redgateCloneURL = 'http://devclndbs01.exclaim-dev.com:14145'
Connect-SqlClone -ServerUrl $redgateCloneURL
$imagelist = Get-SqlCloneImage
$clonelist = Get-SqlClone
foreach ($name in $imagelist) ...