{"id":138,"date":"2005-09-22T14:28:33","date_gmt":"2005-09-22T18:28:33","guid":{"rendered":"\/?p=138"},"modified":"2005-09-24T07:42:06","modified_gmt":"2005-09-24T11:42:06","slug":"calling-vandyke-crt-in-a-microsoft-dts","status":"publish","type":"post","link":"https:\/\/toddsingleton.net\/chronicle\/2005\/09\/22\/calling-vandyke-crt-in-a-microsoft-dts\/","title":{"rendered":"Calling VanDyke CRT from a Microsoft DTS"},"content":{"rendered":"

\"CRT\"\/<\/a>One of the things I have always disliked about administering Windows servers and workstations is their inherent inability to act as a basic terminal. You’ve got to use terminal emulation software to login to NFS based firmware and appliances. Recently this became a huge issue when we were required to delete the contents of a volume on a NetApp SAN at Dillon Supply. Here was the scenario:<\/p>\n

We have a volume vol0\/dscsql2db<\/i> on a NetApp FAS270 filer. Every night all of the NetApp “snapshots” on this volume need to be deleted. The snap delete<\/i> command native to the snapdrive service on Windows 2003 servers cannot perform the force deletion of an entire volume. The snap delete<\/i> command in the OS of the filer can delete the entire contents of a volume regardless of a snapshots state or condition. More specifically, one of the snapshots we wanted to delete is mounted as a read\/writable volume on a server (busy, LUNs). Therefore the arguments available in the snap delete<\/i> command on the filer are required.<\/p>\n

So we needed a way to log on directly to the NetApp filer from within a Microsoft SQL DTS (Data Transformation Service) and execute the snap delete command to remove the entire contents of the volume. Basically, I needed to run a Vbscript as a job executed by a DTS against the Netapp filer. That’s where VanDyke CRT<\/a> came in. I could have used custom expect scripts and spent a long time figuring out how to get them to run through Telnet. Instead we set up a default Telnet session for the CRT application to use when called by the parent DTS (by IP Address) then it automatically executes the following login script:<\/p>\n

#$language = “VBScript”
\n#$interface = “1.0”<\/p>\n

Sub main<\/p>\n

‘ turn on synchronous mode so we don’t miss any data
\n crt.Screen.Synchronous = True<\/p>\n

‘ Wait for a string that looks like “login: ” or “Login: ”
\n crt.Screen.WaitForString “ogin: ”<\/p>\n

‘ Send your username followed by a carriage return
\n crt.Screen.Send “root” & vbCr<\/p>\n

‘ Wait for a tring that looks like “password: ” or “Password: ”
\n crt.Screen.WaitForString “assword:”<\/p>\n

‘ Send your password followed by a carriage return
\n crt.Screen.Send “ya, you wish” & vbCr<\/p>\n

crt.Screen.WaitForString “etapp1”<\/p>\n

‘ ++++ Begin Production commands to delete snapshots<\/p>\n

crt.Screen.Send “snap delete -a -f -q dscsql2db” & vbCr<\/p>\n

crt.Screen.WaitForString “etapp1”<\/p>\n

crt.Screen.Send “snap delete -a -f -q dscsql2logs” & vbCr<\/p>\n

‘ ++++ End Production commands to delete snapshots<\/p>\n

‘ turn off synchronous mode to restore normal input processing<\/p>\n

crt.Screen.Synchronous = False<\/p>\n

‘ This will wait 30 seconds
\ncrt.Sleep 30000
\n‘ dismiss the app
\ncrt.quit<\/p>\n

End Sub<\/i><\/p>\n

Notice the crt.whatever.wait and .send<\/i> vb scripting objects. It’s these objects included in CRT that made this all possible. Once the script command executes to delete the contents of the volume on the NetApp filer, it closes CRT and our SQL DTS can proceed with creating a new snapshot of our production database volume, mounting this snapshot to a remote server where it is then attached to MS SQL as one of the last steps. Bang! The refreshed reporting server is on-line.<\/p>\n

None of this would have been possible without our $35 copy of CRT.<\/p>\n","protected":false},"excerpt":{"rendered":"

One of the things I have always disliked about administering Windows servers and workstations is their inherent inability to act as a basic terminal. You’ve got to use terminal emulation software to login to NFS based firmware and appliances. Recently this became a huge issue when we were required to delete the contents of a … Continue reading Calling VanDyke CRT from a Microsoft DTS<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-138","post","type-post","status-publish","format-standard","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/toddsingleton.net\/chronicle\/wp-json\/wp\/v2\/posts\/138","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/toddsingleton.net\/chronicle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/toddsingleton.net\/chronicle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/toddsingleton.net\/chronicle\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/toddsingleton.net\/chronicle\/wp-json\/wp\/v2\/comments?post=138"}],"version-history":[{"count":0,"href":"https:\/\/toddsingleton.net\/chronicle\/wp-json\/wp\/v2\/posts\/138\/revisions"}],"wp:attachment":[{"href":"https:\/\/toddsingleton.net\/chronicle\/wp-json\/wp\/v2\/media?parent=138"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/toddsingleton.net\/chronicle\/wp-json\/wp\/v2\/categories?post=138"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/toddsingleton.net\/chronicle\/wp-json\/wp\/v2\/tags?post=138"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}