So the MasterServerList table already has a port field that is auto-filled with 1433, if no value is specified for it. This will be the case for all future modules too. "C:\temp" you will need to edit the PowerShell script and modify the first lineĪs shown below. If you want to change the working directory and use something other then In my setup, I put all of these files in the Server instances and configured the Settings.ini file you should put all threeįiles in the same folder.
How to UseĪfter you have entered records into the Instances.txt file for your SQL It will create the database, tables and load data from the Instances.txtįile into inventoryMasterServerList. Want to use for the central data collection. Instance to use for the central server and also the name of the database you The script will use the Setting.ini file to determine what SQL Server The inventory.MasterServerList table is called:
The PowerShell script that creates the above objects and inserts data into Or you can just add new rows directly to table inventory.MasterServerList This text file can be updated with new instance information and the PowerShell script can be run again Server using a trusted connection, using the following information that is in If the database already exists it will not create theīy default, when you run the PowerShell script it will try to connect to the
There are two parameters that you will need to update in this file: This file is used to configure the central server and database that will be