 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Windows Server Forum / Systems Management Server / General Topics / October 2008SMS integration
In our office we have a software vendor who is in the process of implementing a help desk/ incident management type software. They want to pull information directly from the SMS_001 database (e.g inventoryobjectname) via SQL. My concern is that without some sort of abstration layer (SDK, api) future upgrades of SMS (SCCM) will be hindered. What is the recommended method of extracting info from SMS? Paul If they are using the views and not the tables it should not be a big issue. However I have heard of lots of issue with this type of setup, For example the Remdey add-on can crash the SQL server due to it creating too many connection to the server and overloading SQL. Also ensure that they are using Native SQL calls and not OBDC as this will affect your network, since ODBC has allot of overhead. I recommend that you create a test lab and full test this before implementing it within production. > In our office we have a software vendor who is in the process of > implementing [quoted text clipped - 6 lines] > > Paul |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.