Comparing SMS Inventories SQL Svr 7

  • Hi I would like to compare past and present hardware inventories in SMS. Im sure SQL Svr has the ability to do this probably from the command line but Im not sure how to go about it. Any help appreciated.

  • I have spent more time than I care for in the SMS database trying to retain where MS is storing pertinent data and it is extremely confusing to say the least. I know of no scripting for SMS that will do what you are asking so, the script would need to be created. If you give a specific table reference from SMS and what you would like to compare, I can offer some suggestions.

    David

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • I administer two 6.5 SMS databases...Nasty!

    -jg


    -JG

  • Try these:

    http://www3.sympatico.ca/pthomsen/SMS/SMS.html

    Maybe post in the MS forums?

    Steve Jones

    steve@dkranch.net

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply