jkagalbraith

Anyone, know why the service table in the eXpress database only shows enabled services?

I wrote a web app which takes data from multiple DS databases and presents it in a more useful central web format, but to only show enabled services is VERY iritating, and less than useful!

Anyone know if theres a way to get the AClient to pull all services, enabled or not?

FYI, the query I use on this table is:

SELECT computer.name,service.service_id,service.name,serv ice.display_name,service.description,service.image _path,service.start_type
FROM computer, service, tblManagedServerList
WHERE tblManagedServerList.ServerID = computer.computer_id
AND computer.computer_id=service.computer_id
ORDER BY computer.name, display_name;

tblManagedServerList is a table I created which just contains a subset of computer_ids which are managed on a specific service contract (there are other clients on the DS servers not managed by us).