VCM and SQL Data Base 2010/2012

This is the scope: We are engaged in the cleanup of our systems with the sole purpose of checking

and remediateing vulnerabilities in all our servers. We will continue with the process in the

whole enterprise. We have a VCM as well as many other ITSM and inventory tools. They have been in

place for some time so do their widespread lax security. Our new security paradigm will arrive as

soon as I get my grips on this, to this end I must seek your advise.

First to start the cleanup I had to build a database which will enable me to organize the raw

data (bad one) I exported from VCM for further investigation and analysis. Moreover, I can

compare it to other Inventory tools like ITI, ECM and HPsim. I hope to get valid information by

the end of the exercise. Note that I developed a variance of which tool seems to be reliable and

accurate in finding valid servers as it is in this case.

My problem is this, my database is static: This means that I have to go to VCM to capture and

export data just to get an up to date inventory. This is not funny. I will like to find out how

to integrate our VCM with the SQL database 2012 I built. If you know how please let me know. I

just want my SQL database to be dynamic and in tune with the VCM. This can greatly assist me with

my work.

Thanks.

0 answers