MAPS.dbo.sql_assessments table not being created

Nov 13, 2009 at 7:21 PM

Hello all! 

I'm struggling to get the MAPS tool to create the MAPS.dbo.sql_assessments table that Buck's queries are searching for.  I have ran the discovery of a number of Servers to gather information about them but for the life of me I can't get it to create the above mentioned table.  It appears to be creating the other tables (i.e. app_virtualization_assessment, device_assessment, hardware_assessment, windows7_assessment, etc) but just not the sql_assessments table.  Any advice?


Steve Kenealy

Nov 16, 2009 at 4:47 PM

With the new maps application from MS, the correct name of the table is MAPS.dbo.sql_inventory

Just change the script to reflect the new table name, and everything should be good.



Dec 1, 2009 at 3:30 PM
Thanks, that was it!
Steve Kenealy
DBA | Database Services
5645 N. 90th St,, 90-120 | Omaha, NE 68134
o: 402.240.8751 | c: 402.598.8976
Food I love: David Sunflower Seeds