Scripting Blog

A place to learn about PowerShell and share stories of automation

February 2009 - Scripting Blog

Hey, Scripting Guy! How Do I Query and Retrieve DNS Information?

February 26, 2009 Feb 26, 2009 02/26/09
ScriptingGuy1
Hey, Scripting Guy! I know I can use the DNS WMI provider and query a DNS server. But what if I am not using a Microsoft DNS server? Or what if I do not have admin rights on the DNS server? What happens then? I really do not want to resort to parsing the output from NSLookup. Can you hook me up?- BP Hi BP, You know, "Hook Me Up" was the ...

Hey, Scripting Guy! How Do I Create a New DNS Zone?

February 25, 2009 Feb 25, 2009 02/25/09
ScriptingGuy1
Hey, Scripting Guy! I need to create several new zones in DNS, and I do not want to waste time working through the GUI wizard. I mean, real network administrators do not use wizards. In the old days, this was easy: I’d just edit a .dns file and I’d be done. But with Active Directory integrated stuff, I cannot figure out where the things ...

Hey, Scripting Guy! How Can I Create DNS Mail Exchanger (MX) Records and Have a Text File Generated to Show What Was Created?

February 24, 2009 Feb 24, 2009 02/24/09
ScriptingGuy1
Hey, Scripting Guy! We are adding some new Exchange Servers to our messaging infrastructure, and I want to create some new MX (Mail Exchanger) records in DNS. I do not want to to create these records manually because carpal tunnel is not my friend and manual creation tends to introduce errors. I like having a text file that shows exactly ...

Hey, Scripting Guy! How Do I Check Host Name Records?

February 23, 2009 Feb 23, 2009 02/23/09
ScriptingGuy1
Hey, Scripting Guy! We are having name resolution issues at work. It is so bad that when my wife calls me, the guy in the other cube gets the call. This manifests itself in concrete ways as well. Opening Office Outlook seems to take forever; going to internal Web sites takes a long time; trying to connect to an Office SharePoint site is ...

Hey, Scripting Guy! How Can I Import Data into Office Access from Office Excel?

February 19, 2009 Feb 19, 2009 02/19/09
ScriptingGuy1
Hey, Scripting Guy! I need to do hardware inventory on all our workstations and on all our servers. I know System Center Configuration Manager can do this and a whole lot more. We actually have it budgeted for deployment next year. However, that does not help me now. We had a summer intern that went around and typed a lot of information such...