May 27, 2009 at 7:41 PM
Edited May 27, 2009 at 7:41 PM
A couple of things as I dug deeper today
In the servers.disks table I believe the servername column should be a varchar not a varbinary , [ServerName] [VARBINARY](150) NOT NULL
Also I decided to add key relationships between the tables adding a new column to the database, sqlserver and disk tables referring to the systemkey in the system table. - I am also trying to consolidate my entries to match the names in the MSDB. Unfortunately
the MAPS database does not present instance names the same way that the msdb.dbo.sysmanagement_shared_registered_servers_internal does i.e SERVERNAME\INSTANCENAME. so that may be somewhat of a manual process
I did write some queries to import data that I’d be happy to share although I did not populate all the columns.
I would like to be consistent between all tables and be able to call the powershell scripts from one place