This is an SQL script that will basically take all machines that are listed in AD and adds the ones that do not already appear in the NetworkDevice table into it, this will allow remote execution tasks or adoption tasks to be run on any machine that appears in AD regardless of whether you have run a discovery.
This is an SQL script that will basically take all machines that are listed in AD and adds the ones that do not already appear in the NetworkDevice table into it, this will allow remote execution tasks or adoption tasks to be run on any machine that appears in AD regardless of whether you have run a discovery.
The steps it does are: Select from Computer table For each machine not already in NetworkDevice table add it
For each machine added create a record in the NetworkDeviceDiscoveredBy table for that machine for each DS in my hierarchy (Note: Assumes that an AD reconcile has run to populate the Computer table from AD)
Now when I perform a remote execute or adoption on any of these machines ManageSoft will:
- Lookup IP address of that machine from DNS
- Apply matching algorithm to determine closest DS
- Create job and execute
I have tested this script as best I can and it appears to work well. Now for a POC this is nice as if you are unable to discover the machine from NETBIOS you can create an entry in AD run the SQL and the go for your life.
Thanks for Chris and Paul for helping me put this together, ok thanks for writing it ALL for me. Hope you find this useful Dale.
There is no attachment for this article as it was migrated over from the MGS KB and no attachment was included on that document either.
Comments