# SMS returns **URL:** \ **Category:** programming\ **Created:** [November 3, 2003, 3:28pm UTC](https://forum.kirupa.com/t/sms-returns/34517 "2003-11-03T15:28:13Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![hamza84](https://avatars.discourse-cdn.com/v4/letter/h/ea5d25/32.png) [@hamza84](https://forum.kirupa.com/u/hamza84)\ **Post date:** [November 3, 2003, 3:28pm UTC](https://forum.kirupa.com/t/sms-returns/34517/1 "2003-11-03T15:28:13Z")
One of my clients wants me to put an SMS interface in the website. I’ve done a lot of searching everywhere but couldn;t find any good sources on how to implement it. Can anybody help me please? ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [November 12, 2003, 5:16pm UTC](https://forum.kirupa.com/t/sms-returns/34517/2 "2003-11-12T17:16:19Z")
We played with this about 2 years ago. If you get on the Enterprise Manager for your SMS server’s SQL server, you’ll see a database that looks something like SMS\_000 where 000 is your SMS site number. Browse around on the tables in there, and you’ll see a table with your computer names in it, another with hardware data, etc. If I remember right, in that computer names table, SMS has an ID column which ties a unique integer number to each computer. Then if you look at your hardware and software data tables, they have that ID # to represent each particular computer. If you’re good with SQL, you can write some pretty fancy join queries and get some fairly simple data sets back. Take a look at the Microsoft SQL server commands in the PHP reference for tying into MSSQL server with php… [http://us3.php.net/manual/en/ref.mssql.php](http://us3.php.net/manual/en/ref.mssql.php) ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [November 13, 2003, 10:59am UTC](https://forum.kirupa.com/t/sms-returns/34517/3 "2003-11-13T10:59:23Z")
whaaaa?? lol, I was talking about the sms text messaging stuff. I don’t get what you’re talking about. Whatever it is, sounds interesting… too bad i dont know how it works. Thanks anyways 🙂 ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [November 14, 2003, 6:39am UTC](https://forum.kirupa.com/t/sms-returns/34517/4 "2003-11-14T06:39:26Z")
Doh! I:-) I can’t help ya there… Microsoft makes something called Systems Management Server for use on big corporate networks for hardware and software inventory. Friggin complicated and buggy piece of software. Good luck with your SMS! :azn: ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [November 14, 2003, 12:59pm UTC](https://forum.kirupa.com/t/sms-returns/34517/5 "2003-11-14T12:59:34Z")
Haha, its cool. Thanx anyways 🙂 ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [November 14, 2003, 4:22pm UTC](https://forum.kirupa.com/t/sms-returns/34517/6 "2003-11-14T16:22:06Z")
in the ‘Free stuff’ section at [http://robuk.mchost.com](http://robuk.mchost.com), there’s a PHP sms thingy - I haven’t tried it, but it might work 🙂 ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [November 15, 2003, 8:17pm UTC](https://forum.kirupa.com/t/sms-returns/34517/7 "2003-11-15T20:17:58Z")
umm, i can’t find that section. Is it the right link?