Re: [cisco-voip] DRS Backups - File & Database Record Extraction
Look at the bright side. They create interesting learning opportunities for folks like us. You could argue that I owe my Java & C# education to the Cisco DRS team. Had to learn both to create the backup decrypter; ended up getting a job as a tools engineer as a result. I should send those guys a nice fruit basket for Christmas! But you're right, it would be nice if they had some sort of selective restore tool. Please let us know if you end up working on one. From: Anthony Holloway Sent: Friday, November 17, 2017 6:23 PM To: Pete Brown Cc: cisco-voip@puck.nether.net Subject: Re: [cisco-voip] DRS Backups - File & Database Record Extraction Maybe I should make a backup tool for UCCX so you can selectively restore objects. You know, like how COBRAS is. Or maybe Cisco should just shift their focus from chasing Microsoft and actually invest in their current products and the customers who run them. I’m so tired of apologizing for Cisco’s short comings. Sorry, thread hijacking. I’ll see myself out. On Fri, Nov 17, 2017 at 5:03 PM Pete Brown mailto:j...@chykn.com>> wrote: That's pretty slick! Well commented, too. Thanks for sharing. From: Anthony Holloway mailto:avholloway%2bcisco-v...@gmail.com>> Sent: Friday, November 17, 2017 3:51 PM To: Pete Brown Cc: cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net> Subject: Re: [cisco-voip] DRS Backups - File & Database Record Extraction This is a good time to remind people that they could use automation tools to download the scripts and prompts outside of DRS all together. https://twitter.com/avholloway45633/status/647450649353846784<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2Favholloway45633%2Fstatus%2F647450649353846784&data=02%7C01%7Cjpb%40chykn.com%7Ccc35bed198fc4207df0208d52e0571dd%7C84df9e7fe9f640afb435%7C1%7C0%7C636465523268451660&sdata=%2BllY11qUDZiGIa%2BEzdEQRa7WI0nEYzr70XhFV7r3QWk%3D&reserved=0> On Fri, Nov 17, 2017 at 1:17 PM Pete Brown mailto:j...@chykn.com>> wrote: An update for those who have asked about extracting database records directly from DRS backups. I've had some success reading BLOB data from Informix ontape files, so we can read flat files from the TARs as well as files stored as BLOB fields in Informix. It's working well enough to extract prompt & script files from a sample UCCX 9 backup. Definitely not stable enough to release, but it's getting there. The next step is to design an interface which allows users to open DRS backups and browse the contents. Think DRS Message Fisher, but for reading UCCX and CUCM backups as well. Since the tools are free and I can't exactly afford a design team, this is where I could use some assistance from the community. Please let me know if you're interested in providing some creative input on a UI. Have an idea about how you'd want to browse and extract data? Put it in a Visio. Sketch it out in MS Paint. Scribble it on a napkin. Whatever works. Have some C# experience and want to create a mockup? Bless you. One day you'll be an unsung hero to some poor soul who accidentally overwrites the wrong script in UCCX and relies on your work to save their bacon. Thanks, Pete ___ cisco-voip mailing list cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net> https://puck.nether.net/mailman/listinfo/cisco-voip<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fpuck.nether.net%2Fmailman%2Flistinfo%2Fcisco-voip&data=02%7C01%7Cjpb%40chykn.com%7Ccc35bed198fc4207df0208d52e0571dd%7C84df9e7fe9f640afb435%7C1%7C0%7C636465523268451660&sdata=NAD%2FnU3s3kKOIl%2Fb7oJwHfp7jfdSv6lWqjLQv81xokY%3D&reserved=0> ___ cisco-voip mailing list cisco-voip@puck.nether.net https://puck.nether.net/mailman/listinfo/cisco-voip
Re: [cisco-voip] DRS Backups - File & Database Record Extraction
I like how he just got almost everyone on this list to follow him on twitter :) guilty as charged, in case he does create the restore utility On Fri, Nov 17, 2017 at 4:03 PM, Pete Brown wrote: > That's pretty slick! Well commented, too. Thanks for sharing. > > > > -- > *From:* Anthony Holloway > *Sent:* Friday, November 17, 2017 3:51 PM > *To:* Pete Brown > *Cc:* cisco-voip@puck.nether.net > *Subject:* Re: [cisco-voip] DRS Backups - File & Database Record > Extraction > > This is a good time to remind people that they could use automation tools > to download the scripts and prompts outside of DRS all together. > > https://twitter.com/avholloway45633/status/647450649353846784 > <https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2Favholloway45633%2Fstatus%2F647450649353846784&data=02%7C01%7Cjpb%40chykn.com%7Ccc35bed198fc4207df0208d52e0571dd%7C84df9e7fe9f640afb435%7C1%7C0%7C636465523268451660&sdata=%2BllY11qUDZiGIa%2BEzdEQRa7WI0nEYzr70XhFV7r3QWk%3D&reserved=0> > > On Fri, Nov 17, 2017 at 1:17 PM Pete Brown wrote: > > An update for those who have asked about extracting database > records directly from DRS backups. I've had some success reading BLOB > data from Informix ontape files, so we can read flat files from the TARs as > well as files stored as BLOB fields in Informix. It's working well > enough to extract prompt & script files from a sample UCCX 9 backup. > Definitely not stable enough to release, but it's getting there. > > The next step is to design an interface which allows users to open DRS > backups and browse the contents. Think DRS Message Fisher, but for > reading UCCX and CUCM backups as well. Since the tools are free and I > can't exactly afford a design team, this is where I could use some > assistance from the community. > > Please let me know if you're interested in providing some creative input > on a UI. Have an idea about how you'd want to browse and extract data? > Put it in a Visio. Sketch it out in MS Paint. Scribble it on a napkin. > Whatever works. Have some C# experience and want to create a mockup? > Bless you. One day you'll be an unsung hero to some poor soul who > accidentally overwrites the wrong script in UCCX and relies on your work to > save their bacon. > > Thanks, > Pete > ___ > cisco-voip mailing list > cisco-voip@puck.nether.net > https://puck.nether.net/mailman/listinfo/cisco-voip > <https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fpuck.nether.net%2Fmailman%2Flistinfo%2Fcisco-voip&data=02%7C01%7Cjpb%40chykn.com%7Ccc35bed198fc4207df0208d52e0571dd%7C84df9e7fe9f640afb435%7C1%7C0%7C636465523268451660&sdata=NAD%2FnU3s3kKOIl%2Fb7oJwHfp7jfdSv6lWqjLQv81xokY%3D&reserved=0> > > > ___ > cisco-voip mailing list > cisco-voip@puck.nether.net > https://puck.nether.net/mailman/listinfo/cisco-voip > > ___ cisco-voip mailing list cisco-voip@puck.nether.net https://puck.nether.net/mailman/listinfo/cisco-voip
Re: [cisco-voip] DRS Backups - File & Database Record Extraction
Maybe I should make a backup tool for UCCX so you can selectively restore objects. You know, like how COBRAS is. Or maybe Cisco should just shift their focus from chasing Microsoft and actually invest in their current products and the customers who run them. I’m so tired of apologizing for Cisco’s short comings. Sorry, thread hijacking. I’ll see myself out. On Fri, Nov 17, 2017 at 5:03 PM Pete Brown wrote: > That's pretty slick! Well commented, too. Thanks for sharing. > > > > -- > *From:* Anthony Holloway > *Sent:* Friday, November 17, 2017 3:51 PM > *To:* Pete Brown > *Cc:* cisco-voip@puck.nether.net > *Subject:* Re: [cisco-voip] DRS Backups - File & Database Record > Extraction > > This is a good time to remind people that they could use automation tools > to download the scripts and prompts outside of DRS all together. > > https://twitter.com/avholloway45633/status/647450649353846784 > <https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2Favholloway45633%2Fstatus%2F647450649353846784&data=02%7C01%7Cjpb%40chykn.com%7Ccc35bed198fc4207df0208d52e0571dd%7C84df9e7fe9f640afb435%7C1%7C0%7C636465523268451660&sdata=%2BllY11qUDZiGIa%2BEzdEQRa7WI0nEYzr70XhFV7r3QWk%3D&reserved=0> > > On Fri, Nov 17, 2017 at 1:17 PM Pete Brown wrote: > > An update for those who have asked about extracting database > records directly from DRS backups. I've had some success reading BLOB > data from Informix ontape files, so we can read flat files from the TARs as > well as files stored as BLOB fields in Informix. It's working well > enough to extract prompt & script files from a sample UCCX 9 backup. > Definitely not stable enough to release, but it's getting there. > > The next step is to design an interface which allows users to open DRS > backups and browse the contents. Think DRS Message Fisher, but for > reading UCCX and CUCM backups as well. Since the tools are free and I > can't exactly afford a design team, this is where I could use some > assistance from the community. > > Please let me know if you're interested in providing some creative input > on a UI. Have an idea about how you'd want to browse and extract data? > Put it in a Visio. Sketch it out in MS Paint. Scribble it on a napkin. > Whatever works. Have some C# experience and want to create a mockup? > Bless you. One day you'll be an unsung hero to some poor soul who > accidentally overwrites the wrong script in UCCX and relies on your work to > save their bacon. > > Thanks, > Pete > ___ > cisco-voip mailing list > cisco-voip@puck.nether.net > https://puck.nether.net/mailman/listinfo/cisco-voip > <https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fpuck.nether.net%2Fmailman%2Flistinfo%2Fcisco-voip&data=02%7C01%7Cjpb%40chykn.com%7Ccc35bed198fc4207df0208d52e0571dd%7C84df9e7fe9f640afb435%7C1%7C0%7C636465523268451660&sdata=NAD%2FnU3s3kKOIl%2Fb7oJwHfp7jfdSv6lWqjLQv81xokY%3D&reserved=0> > > ___ cisco-voip mailing list cisco-voip@puck.nether.net https://puck.nether.net/mailman/listinfo/cisco-voip
Re: [cisco-voip] DRS Backups - File & Database Record Extraction
That's pretty slick! Well commented, too. Thanks for sharing. From: Anthony Holloway Sent: Friday, November 17, 2017 3:51 PM To: Pete Brown Cc: cisco-voip@puck.nether.net Subject: Re: [cisco-voip] DRS Backups - File & Database Record Extraction This is a good time to remind people that they could use automation tools to download the scripts and prompts outside of DRS all together. https://twitter.com/avholloway45633/status/647450649353846784<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2Favholloway45633%2Fstatus%2F647450649353846784&data=02%7C01%7Cjpb%40chykn.com%7Ccc35bed198fc4207df0208d52e0571dd%7C84df9e7fe9f640afb435%7C1%7C0%7C636465523268451660&sdata=%2BllY11qUDZiGIa%2BEzdEQRa7WI0nEYzr70XhFV7r3QWk%3D&reserved=0> On Fri, Nov 17, 2017 at 1:17 PM Pete Brown mailto:j...@chykn.com>> wrote: An update for those who have asked about extracting database records directly from DRS backups. I've had some success reading BLOB data from Informix ontape files, so we can read flat files from the TARs as well as files stored as BLOB fields in Informix. It's working well enough to extract prompt & script files from a sample UCCX 9 backup. Definitely not stable enough to release, but it's getting there. The next step is to design an interface which allows users to open DRS backups and browse the contents. Think DRS Message Fisher, but for reading UCCX and CUCM backups as well. Since the tools are free and I can't exactly afford a design team, this is where I could use some assistance from the community. Please let me know if you're interested in providing some creative input on a UI. Have an idea about how you'd want to browse and extract data? Put it in a Visio. Sketch it out in MS Paint. Scribble it on a napkin. Whatever works. Have some C# experience and want to create a mockup? Bless you. One day you'll be an unsung hero to some poor soul who accidentally overwrites the wrong script in UCCX and relies on your work to save their bacon. Thanks, Pete ___ cisco-voip mailing list cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net> https://puck.nether.net/mailman/listinfo/cisco-voip<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fpuck.nether.net%2Fmailman%2Flistinfo%2Fcisco-voip&data=02%7C01%7Cjpb%40chykn.com%7Ccc35bed198fc4207df0208d52e0571dd%7C84df9e7fe9f640afb435%7C1%7C0%7C636465523268451660&sdata=NAD%2FnU3s3kKOIl%2Fb7oJwHfp7jfdSv6lWqjLQv81xokY%3D&reserved=0> ___ cisco-voip mailing list cisco-voip@puck.nether.net https://puck.nether.net/mailman/listinfo/cisco-voip
Re: [cisco-voip] DRS Backups - File & Database Record Extraction
This is a good time to remind people that they could use automation tools to download the scripts and prompts outside of DRS all together. https://twitter.com/avholloway45633/status/647450649353846784 On Fri, Nov 17, 2017 at 1:17 PM Pete Brown wrote: > An update for those who have asked about extracting database > records directly from DRS backups. I've had some success reading BLOB > data from Informix ontape files, so we can read flat files from the TARs as > well as files stored as BLOB fields in Informix. It's working well > enough to extract prompt & script files from a sample UCCX 9 backup. > Definitely not stable enough to release, but it's getting there. > > The next step is to design an interface which allows users to open DRS > backups and browse the contents. Think DRS Message Fisher, but for > reading UCCX and CUCM backups as well. Since the tools are free and I > can't exactly afford a design team, this is where I could use some > assistance from the community. > > Please let me know if you're interested in providing some creative input > on a UI. Have an idea about how you'd want to browse and extract data? > Put it in a Visio. Sketch it out in MS Paint. Scribble it on a napkin. > Whatever works. Have some C# experience and want to create a mockup? > Bless you. One day you'll be an unsung hero to some poor soul who > accidentally overwrites the wrong script in UCCX and relies on your work to > save their bacon. > > Thanks, > Pete > ___ > cisco-voip mailing list > cisco-voip@puck.nether.net > https://puck.nether.net/mailman/listinfo/cisco-voip > ___ cisco-voip mailing list cisco-voip@puck.nether.net https://puck.nether.net/mailman/listinfo/cisco-voip
[cisco-voip] DRS Backups - File & Database Record Extraction
An update for those who have asked about extracting database records directly from DRS backups. I've had some success reading BLOB data from Informix ontape files, so we can read flat files from the TARs as well as files stored as BLOB fields in Informix. It's working well enough to extract prompt & script files from a sample UCCX 9 backup. Definitely not stable enough to release, but it's getting there. The next step is to design an interface which allows users to open DRS backups and browse the contents. Think DRS Message Fisher, but for reading UCCX and CUCM backups as well. Since the tools are free and I can't exactly afford a design team, this is where I could use some assistance from the community. Please let me know if you're interested in providing some creative input on a UI. Have an idea about how you'd want to browse and extract data? Put it in a Visio. Sketch it out in MS Paint. Scribble it on a napkin. Whatever works. Have some C# experience and want to create a mockup? Bless you. One day you'll be an unsung hero to some poor soul who accidentally overwrites the wrong script in UCCX and relies on your work to save their bacon. Thanks, Pete ___ cisco-voip mailing list cisco-voip@puck.nether.net https://puck.nether.net/mailman/listinfo/cisco-voip