Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SMS data transfer

Status
Not open for further replies.

jacksean

Programmer
Mar 25, 2009
1
0
0
CA
What I need to do is importing the name of software apps running on all machines in the organization. To import them into another custom database.

Anyone has a similar experience on this kind of operation ? Please share!

The way I see it, I should get the applications running on each machine and transfer it to the custom db.
How would you do this transfer, I mean I can get the reports but I would have to manually save them (export) as excel files. Is anyway I can access it, grabbing the data into a temp table or something like this ??
 
Create a read only account in SQL on the SMS/SCCM server, then on the other SQL server create an ODBC connection from that server to the SMS server and pull what you want.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top