Pulling DNS information 2

[Daleana]

Has anyone successfully with a querie been able to pull DNS information? I know that it will pull the IP address, subnet, gateway, even the MAC address but I am not having very good luck writing one to pull static DNS info. Any help would be greatly appreciated.

 

[gnosis13]

Has anyone had luck getting DNS info from clients? We recently had a DNS problem and found some clients with static entries that should have been using DHCP. I would like to use SMS to find any other clients who are not getting the correct DNS entry from DHCP.

Looks easy but just doesn't seem to be present in SMS.

A+, N+, MCP

 

[Jpoandl]

I don't believe that the DNS information is collected by SMS by default. However, you can modify the hardware MOF file to collect additional information.

This will increase the size of your SMS database. Maybe a better way to solve this situation is to create a script that collect DNS information about your clients...

Here's one I wrote for collecting WINS information:

On Error Resume Next
Const ForReading = 1
Set objDictionary = CreateObject("Scripting.Dictionary")
Set objFSO = CreateObject("Scripting.FilesystemObject")
Set ObjtextFile = objFSO.Opentextfile("C:\windowsscripts\joe_test\serverlist.txt", ForReading)

i = 0
Do Until objtextfile.AtEndOfStream
strnextline=objtextfile.readline
objdictionary.add i, strnextline
i=i+1
loop

For each objitem in objdictionary
Strcomputer = objdictionary.item(objitem)
Set objWMIService = GetObject("winmgmts:" & "{impersonationlevel=impersonate}!\\" & strcomputer& "\root\cimv2")
Set colAdapters = objWMIService.ExecQuery ("SELECT * FROM Win32_NetworkAdapterConfiguration WHERE IPEnabled = True")

n = 1

For Each objAdapter in colAdapters

WScript.Echo objAdapter.DNSHostName & "," & objAdapter.WINSPrimaryServer & "," & objAdapter.WINSSecondaryServer
n = n + 1
Next

Next

Somthing like this could be created for looking at DNS...


Joseph L. Poandl
MCSE 2003

If your company is in need of experts to examine technical problems/solutions, please check out

http://www.NJCOMPUTERNETWORKS.com

(Sales@njcomputernetworks.com)

 

[brimar123]

Hi,

I am new to SMS 2003 and I install SMS for the first time. I would like tips for partitionning my disk for best performance...

I have server with CPU 3.06Ghz, 1.5Gig RAM and mirror 70Gig and I envisage to install Windows Server 2003 Standard with SQL 2000 on the same server for approximately 600 PC, I have another server for software distribution.

My fist idea is ...

Partition A (30 Gig) : O/S, SMS 2003 and SQL Software
Partition B (10 Gig) : SQL Transactions Logs
Partition C (30 Gig) : SQL Database

Any help would be greatly appreciated.

Thank you
Martin

Sorry for my english i speak just a little bit in english !!!

 

[Jpoandl]

(In the future start a new thread instead of jumping into a thread that is already started)

To answer your question, it doesn't matter how you partition your drive.

You have two 70GB drives in a mirror set. So, it doesn't matter if you create one large C:\ drive or partition the heck out of the disk. You will not see a performance gain because all of the data will exist on these two drives. You need to buy more disk drives and install pieces of your applications on seperate physical disks in order to see performance gains.

-later

Joseph L. Poandl
MCSE 2003

If your company is in need of experts to examine technical problems/solutions, please check out

http://www.NJCOMPUTERNETWORKS.com

(Sales@njcomputernetworks.com)

 

[tbrennans]

depends on how much you want to spend!
if one channel with Hardware controller perhaps

one array (RAID 5) partitioned into volumes OS, SQL, SMS and logs

if two channels with HD controller then
Channel 1 RAID 1 (OS)
Channel 1 RAID 5 (SQL)

Channel 2 RAID 5 (SMS)
Channel 2 RAID 5 (Logs)