Home

Welcome to the CentralDB wiki!

Here is the first page for the WIKI, I want to put the ins and outs of using this PowerShell collection software for database inventory.

Installation guidelines...

• Ok so I have set this up a few times but it always had a few glitches.
• Create the database with the scripts
  • Sometimes this needs a bit of fixes as you may want to move tables into different file groups etc.
• Put the scripts somewhere accessible by all servers.
  • So there is 2 ways to run these scripts
    • You can make an agent job on each server and execute them locally there with a runlocally flag turned to true.
    • You can execute the entire script remotely from your management server but this executes it serially which means if you have more then 10 servers it will be running all day.
• Permissions are tricky I currently am running this in a domain with an agent job using the same service account under all of them. The service account has to have some local admin or power user functionality to get the data. Running this using a local SQL account won't work as of now but is being worked on. (At a glacial pace)
• If you have errors, I cannot always fix them as I doubt I have time or knowledge of your environment. Posting them here may allow for the community (as small as it is to assist) or at least document issues.

I am sure there is more but for now this is all I have. New SQL build scripts and new powershell scripts will be coming.