Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
PowerHome Programming
 PowerHome Messageboard : PowerHome Programming
Subject Topic: Device Location List Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
ibscas
Groupie
Groupie


Joined: October 18 2008
Location: United States
Online Status: Offline
Posts: 46
Posted: October 28 2008 at 16:07 | IP Logged Quote ibscas
How would I get the list of all the device locations I have supplied to PH? I'm assuming there is either a built in command or and SQL statement to pull....

I've been SQL'ing the living daylights out of the system trying to find it and I can see it in the device tables, but not a 'master' table of them.

Thanks!


p.s.

Code:
ph_sql(1,"Select distinct location from devicestatus order by location")


Sort of gets me there, but I'm wondering if there is something better...

Edited by ibscas - October 28 2008 at 16:16
Back to Top View ibscas's Profile Search for other posts by ibscas
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum