Add Custom Data to Database for reporting on
Hi, I need to add custom data to report on with software update statistics. In the government, they report on IAVA# which are made up of Microsoft and non-Microsoft vulnerabilities. The Microsoft ones coinside with the MS buttleins #'s. What I need to do is create a new table with 4 columns: IAVA#, MSbulletin#, Release date, Due date. (an primary key I would assume). Then I can put together web reports giving Update statistics along with these manual inputs. What would be the best way to create and update new data monthly to the SCCM database?Thanks!Troy TroyW
January 20th, 2010 9:01pm

The best way would be to not update the SCCM Database since this isn't supported. That being said it might be better to have a stored procedure to copy the tables you need out to a new database for you to work with. This way you leave the integrity of the database intact. There is no way of knows what will happen to the database when you go to upgrade/patch/R2 etc to the server. It could prevent the site from being upgraded.http://www.sccm-tools.com http://sms-hints-tricks.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
January 20th, 2010 10:19pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics