Registered member login:
Register Now
Altirigos » Deployment Solution » Scripting/Tools/Docs » DS Database "Service" Table SQL Query

» Current Poll
Do you leave the Aclient enabled?
YES - 82.31%
107 Votes
NO - 17.69%
23 Votes
Total Votes: 130
You may not vote on this poll.
» Stats
Members: 9,498
Threads: 11,753
Posts: 55,312
Top Poster: Nick (4,981)
Welcome our newest member, Junior
» Online Users: 77
3 members and 74 guests
Junior, mmalsed, skakid
Most users online at once 294, 06-30-2007 at 12:24 PM.
» March 2010
S M T W T F S
28 1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31 123
Reply
Old 04-28-2009, 09:53 AM   #1 (permalink)
 
Status: Junior Altiris Admin
Join Date: 09-18-2007
Location: Egham, UK
Age: 30
Posts: 8


Unhappy DS Database "Service" Table SQL Query

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).
jkagalbraith is offline   Reply With Quote
Old 04-28-2009, 10:51 AM   #2 (permalink)
 
TRYDL's Avatar
 
Status: Super Altiris Admin
Join Date: 03-08-2006
Location: Baltimore, MD
Age: 29
Posts: 576


Good question. And the answer is I dont think so. Have you tried the DAgent to see if the results are different?

In your web app, it maybe necessary to have that information displayed in realtime. In other an ASP page with the appropriate WMI calls to the Win32_Service class.

On a side note, the Altiris Agent would be able to pull that information as a part of Basic Inventory.
__________________
3rd Floor Garage Door Operator
TRYDL is offline   Reply With Quote
Old 04-29-2009, 06:23 AM   #3 (permalink)
 
Status: Junior Altiris Admin
Join Date: 09-18-2007
Location: Egham, UK
Age: 30
Posts: 8


Not tryed the DAgent yet as we heard its rather flakey and in our environment would be a pain in the ass to get permission to roll out.

We dont use NS as we have no licenses and no money to buy them... plus I dont really like NS tbh.

:-(
jkagalbraith is offline   Reply With Quote
Reply

Tags
database, query, service, sql


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Powered by vBadvanced CMPS v3.0 RC2

All times are GMT -4. The time now is 01:03 PM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
vB.Sponsors
Altirigos